The reason this is not just a matter of inserting content into a table is because Drupal uses more than one table to manage the site.
There are a number of import modules available. It sounds like you know what you're doing, so maybe you can use one of those modules for a code base to create a custom mod for your needs. Having tasks handled by cron is something many modules do.
I'm assuming the developers list pointed you to the api documentation.
If you want a desktop solution, you might start with something like Performancing or even ecto.
Hope this helps.
Laura
On Jul 2, 2006, at 9:45 AM, dondi_2006 wrote:
Hello,
Some days ago I had asked on this list how to add content in Drupal from the mysql command line. I only got one suggestion to try the import_HTML module (http:// drupal.org/node/46008) but it really seems an overkill, and not the best approach to what I have to do.
I had also asked how to do the same thing in two different ways in the forums: http://drupal.org/node/62954 http://drupal.org/node/68605
without result so far: no feedback from others who posted, who I contacted directly, no usable documentation I could recognize, nothing...
Honestly, I can't believe this has never been done before: What I need to do is something that (OUTSIDE Drupal) reads a .txt file like this:
ARTICLE_CATEGORIES="travel/england/london, food/foreign/restaurants" TEXT="path/to/some/local/html/file/" CREATED_ON_DATE="YYYY/MM/DD" AUTHOR="John Doe"
etc etc.... (other variables like, for example, "create_a_forum_for_this_node")
and upload the node inside the Drupal database, just if I had inserted everything by hand in the proper drupal form.
I don't want to do it via drupal because I need this to happen regularly and automatically (say, a cron job on my home PC which publishes via ssh whatever file in $DRUPAL_CONTENT folder changed in the last hour): it's not a one-time job.
I've also tried to look for scripts doing this via the blogger API (or usable documentation on how to write them so they _are_ drupal compatible): nothing.
What am I missing? Is it really possible that everybody is happy pasting and changing stuff manually in a tiny textarea, EVERY darned time some node must be added or updated??
Thanks,
O.
-- [ Drupal support list | http://lists.drupal.org/ ]