I've created a custom content type, and I want to import a huge amount of data (13,000 entries) into it. I've located the tables where the fields live in the database -- some of them. I can create entries with PHPmyAdmin, but it doesn't appear in Drupal, because the entries aren't complete. To be more specific, I can't locate the title field.

Does anyone have pointers on doing a MySQL import directly into the database that I could then manipulate from Drupal?

Comments

ludo1960’s picture

..look into the node import module http://drupal.org/project/node_import

If that doesn't do the job then http://api.drupal.org/api/function/drupal_execute/6 should do it

estebandido’s picture

Node Import doesn't look up to the job. How do I apply drupal_execute? The documentation isn't very clear.

mradcliffe’s picture

Why do you think node_import won't work? If you have the data in mysql already you could try migrate.

I like to use node_save when I'm writing a custom import script.