Using some functionalities from this script I managed to port
a Xaraya 1.4 installation to Drupal 6.13.

The script performs the following tasks:

• imports users

• imports articles and comments

• imports forums and comments

• imports content types

• imports vocabularies and terms

• imports files

The first thing I’ve done was to eliminate the sequences table, which is deprecated starting from Drupal version 4.

Next, when managing categories, I’ve used the xaraya categories with parent id equal to 0 as Content Types and Vocabularies and inserted all the other as terms associated with the vocabulary.

The term hierachy is created by running a script on the term_hierarchy table setting parent_id 0 for the first child and the original parent_id for the next ones.

With regard to files and images, Inserting them into the ‘files’ table is not enought – the FileField
and ImageField Drupal modules are mandatory in order to associate a field with a node. (this is still work in progress)

One last note: in order to maintain database integrity, the original id-s must be used in all tables.

Click here to download the script

If you’ve encountered this message: “Windows cannot find url” when clicking links in external applications (like for example Yahoo Messenger, Adobe Acrobat, etc), here’s the solution as stated here:

1. Open Explorer
2. Select Tools and then Folder Options
3. Select the File Types tab
4. Select Extension: (NONE), File Type: HyperText Transfer Protocol
5. Click Advanced toward the bottom of the window
6. In the Edit File Type window, select open and click Edit
7. Clear the DDE message box (which should contain “%1″)
8. Click OK, Click OK
9. Repeat for File Type: HyperText Transfer Protocol with Privacy