By thomasmurphy on

Hi,

The site I'm working on has about 11,000 pages in an custom Perl/Interbase CMS, and I want to import them into a new drupal 5.7 site. The only fields that need to be transferred are

Title
Author (taxonomy term - not user related)
Synopsis
Date Published
Category
Region
Body

All the taxonomy terms and fields have equivalents in the drupal system. I suppose this could be done by writing something in Perl to import data into the Drupal MySQL, or convert the Interbase into MySQL and using a PHP tool to do the transfer.

Anyone done anything like this before? I have a reasonable budget but it's not massive.

Tom

⋅ Categories: Drupal 5.x

Comments

NewZeal’s picture

NewZeal commented

Hi Tom,

You left no contact.

I would say that the Perl/Interbase CMS would be able to export the data as a CSV (comma separated) assuming the 11,000 pages are all kept in a database. A php script could then be written to import the data into respective Drupal tables.

I have a website at www.passingphase.co.nz.

And my mail is kent at passingphase.co.nz

I might be able to help

Kent

thomasmurphy’s picture

thomasmurphy commented

didn't want to get spamed. I work at the NZ parliament, we can swap ideas here and I'll give you a buzz if we need to get into detail. The current system doesn't have an export functionality.

NewZeal’s picture

NewZeal commented

That seems rather strange that there is no CSV export. I'm sure it would be easy to find a PERL script that will do the job.

2 mins later:

Found one.

developmenticon’s picture

developmenticon commented

yes it can be done essaly. i have done like this job 40 times.
plz contact me on freelancer.drupal@gmail.com

Thanks