[development] How do you create content for story by updating the database directly (what tables need to be updated?) instead of using the Drupal web application?

[Mukesh Agarwal]

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 <dipench at gmail.com> 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 <jadelrab at gmail.com>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 <mitchelljj98 at gmail.com>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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20100412/af7306f8/attachment-0001.html