The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.
By r2b2 on
Hello,
I would like to seek your opinion on how I should go about importing our legacy table(s) to Drupal. Here is an example table :
| Projects |
|---|
| ProjectID |
| ProjectName |
| CountryID |
| StatusID |
ProjectID is the primary key, auto-increment. CountryID and StatusID are foreign keys pointing to Country and Status tables respectively.
Someone said I should use Node Import module. First I will create these fields in Drupal using CCK and export the legacy table as CSV file.
My problem is this :
There's quite a lot foreign keys in the Projects Table (around 10) including CountryID and StatusID. Should I create a node reference field for those foreign keys?
Thanks!
Comments
Node Reference -> Foreign keys
OK I am assuming that you are ok with Backup and Migrate modules or that you are using Node Import?
With regards to the use of foreign keys, I would recommend using the node reference. However, it will not strutcture your database as it was previously. If you use CCK to create your database, you will likely be creating each table as a separate content types and then linking with the nid (node id). However, you should be good to reassemble all of the data using Views.