There are a few tables affected by adding a node. My suggestions: 1. Node Import module -- alpha version 2. Write custom queries to insert data into each table 3. Use node_save for rescue, I would use this :-) Lets say you have a table where you have the 4 pieces of data for every story, browse through them using mysql and build the node object accordingly, after building the node object, use node_save function to create the node (All in all just a small script can do this)
On Mon, Apr 12, 2010 at 2:56 PM, Dipen <[email protected]> wrote: > 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 >> > > -- Cheers, Mukesh
