There are a few tables affected by adding a node. My suggestions:<div><ol><li>Node Import module -- alpha version</li><li>Write custom queries to insert data into each table</li><li>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)</li>
</ol><br><div class="gmail_quote">On Mon, Apr 12, 2010 at 2:56 PM, Dipen <span dir="ltr"><<a href="mailto:dipench@gmail.com">dipench@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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. <div><br></div><div>Link to feeds module - <a href="http://drupal.org/project/feeds" target="_blank">http://drupal.org/project/feeds</a></div>
<div><br></div><div>Note there are many modules which can help you with bulk import like migrate and tablewizard - <a href="http://drupal.org/project/migrate" target="_blank">http://drupal.org/project/migrate</a> (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.</div>
<div><br></div><div>Cheers</div><div>Dipen<div><div></div><div class="h5"><br><br><div class="gmail_quote">On Mon, Apr 12, 2010 at 2:51 PM, Mohamed Jadelrab <span dir="ltr"><<a href="mailto:jadelrab@gmail.com" target="_blank">jadelrab@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi John, <br><br>I think you want to create a script to populate the database directly, I will advise you to use drupal_execute() : <a href="http://api.drupal.org/api/function/drupal_execute/6" target="_blank">http://api.drupal.org/api/function/drupal_execute/6</a> 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 .. <br>
<br>if you still want to populate the database you need to check : <a href="http://drupal.org/node/82661" target="_blank">http://drupal.org/node/82661</a> CCK Overview , even it still needs to be updated. <br><br>Regards,<div>
<div></div><div><br><br><div class="gmail_quote">
On Mon, Apr 12, 2010 at 12:14 PM, John Mitchell <span dir="ltr"><<a href="mailto:mitchelljj98@gmail.com" target="_blank">mitchelljj98@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex">
I have added two fields called latitude and longitude to the story content type.<br>
<br>
I then created content for story using the drupal web application and<br>
populating the Title, Body, latitude and longitude fields.<br>
<br>
How do you create content for story by updating the database directly<br>
(what tables need to be updated?) for the Title, Body, latitude and<br>
longitude fields instead of using the Drupal web application?<br>
<br>
Thanks,<br>
<br>
John<br>
<font color="#888888"><br>
--<br>
John J. Mitchell<br>
</font></blockquote></div><br><br clear="all"><br></div></div>-- <br>Mohamed Jadelrab<br>
</div>
</blockquote></div><br></div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br>Cheers,<br>Mukesh<br>
</div>