How to import database tables from an existing website to Drupal

Posted by r2b2 on July 19, 2010 at 5:39am

Hello, Im wondering if there's any utility out there I can use to import my existing database table to Drupal schema other than re-entering thousands of records ?

Comments

=-=

Posted by VM on July 19, 2010 at 5:42am

may want to look into the node_import and/or node_export modules

Thanks .. im gonna try this

Posted by r2b2 on July 19, 2010 at 5:46am

Thanks .. im gonna try this out.. Im just trying my new Drupal knowledge and converting our existing website to Drupal.. just an experiment :D

=-=

Posted by VM on July 19, 2010 at 6:13am

ahhh, i read incorrectly. I incorrectly read from drupal to drupal. not from other DB to drupal. No idea how you will do that with a database that isn't already drupal.

Sounds like a huge headache

Posted by r2b2 on July 19, 2010 at 7:46am

Sounds like a huge headache haha... I think im gonna work study first how drupal saves CCK fields and how they relate to the nodes they were created for and then do a script that will replicate the structure of that table/s..

Thanks!

if you know how to convert

Posted by primerg on July 20, 2010 at 9:07pm

if you know how to convert your data to csv, then node_import can work for you.

--
Rachel J.
Solutions Architect, Promet Solutions Inc.
Drupal Web Development | Hosting | Online Marketing

_

Posted by WorldFallz on July 19, 2010 at 12:16pm

Checkout the http://drupal.org/project/migrate and http://drupal.org/project/tw modules as well as http://www.lullabot.com/articles/drupal-data-imports-migrate-and-table-w....

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}