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?
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
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@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
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@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@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
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@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@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@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
participants (4)
-
Dipen -
John Mitchell -
Mohamed Jadelrab -
Mukesh Agarwal