Interbase/Firebird custom CMS pages to drupal nodes
thomasmurphy - March 27, 2008 - 00:34
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
Perl/Interbase CMS
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
didn't want to get spamed. I
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.
That seems rather strange
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.
database import
yes it can be done essaly. i have done like this job 40 times.
plz contact me on freelancer.drupal@gmail.com
Thanks