You should look at Feeds module to bulk import nodes into your system, for that to happen you will need to prepare your input either in CSV, tabbed file etc.
Link to feeds module - http://drupal.org/project/feeds Note there are many modules which can help you with bulk import like migrate and tablewizard - http://drupal.org/project/migrate (Though I haven't used migrate and tw and recently got to know abt them) and I am sure there are few others, also doing a SQL import is error prone so try and use the cleaner approach for the import. Cheers Dipen On Mon, Apr 12, 2010 at 2:51 PM, Mohamed Jadelrab <[email protected]>wrote: > Hi John, > > I think you want to create a script to populate the database directly, I > will advise you to use drupal_execute() : > http://api.drupal.org/api/function/drupal_execute/6 as it will maintain > the insertion of other fields as well like the author, created, and it will > keep you in the same context of adding the content one by one .. > > if you still want to populate the database you need to check : > http://drupal.org/node/82661 CCK Overview , even it still needs to be > updated. > > Regards, > > > On Mon, Apr 12, 2010 at 12:14 PM, John Mitchell <[email protected]>wrote: > >> I have added two fields called latitude and longitude to the story content >> type. >> >> I then created content for story using the drupal web application and >> populating the Title, Body, latitude and longitude fields. >> >> How do you create content for story by updating the database directly >> (what tables need to be updated?) for the Title, Body, latitude and >> longitude fields instead of using the Drupal web application? >> >> Thanks, >> >> John >> >> -- >> John J. Mitchell >> > > > > -- > Mohamed Jadelrab >
