Search found 4 matches

by saratoga_
Mon Feb 11, 2008 5:27 pm
Forum: Joombie Coding Q/A
Topic: Batch Insert Text Files as Content Items
Replies: 6
Views: 748

Re: Batch Insert Text Files as Content Items

The installation I'm using is Joomla 1.0.13 Stable, because I haven't taken the time to upgrade.  That INSERT statement should work no matter what, as long as the ID is set to NULL.  I originally tried doing this without the ID set to NULL, only inserting the title, fulltext, catid, sectin...
by saratoga_
Mon Feb 11, 2008 5:50 am
Forum: Joombie Coding Q/A
Topic: Batch Insert Text Files as Content Items
Replies: 6
Views: 748

Re: Batch Insert Text Files as Content Items

Well, I managed with the help of a good friend to figure out how to automate this.  Here's the script I used with a bit of explanation <?php mysql_connect("yourhost", "youruser", "yourpassword") or die(mysql_error()); mysql_select_db("yourdb") or die(mysql_error()); /*All of the text files are ...
by saratoga_
Mon Feb 11, 2008 2:14 am
Forum: Joombie Coding Q/A
Topic: Batch Insert Text Files as Content Items
Replies: 6
Views: 748

Re: Batch Insert Text Files as Content Items

radiant_tech, could you share your mysql insert query for the content?  I have written a script to parse out the information I need from the folder of text files I have, but they're not properly inserting into my database (and not throwing back any errors!).

Thanks!
by saratoga_
Sat Feb 09, 2008 7:02 pm
Forum: Joombie Coding Q/A
Topic: Batch Insert Text Files as Content Items
Replies: 6
Views: 748

Batch Insert Text Files as Content Items

I have 500+ text files I'm looking to batch insert into the Joomla MySQL database.  I'd like for them to appear in a specific category and section, with the file name serving as the title and the content of the text file as the fulltext. It looks like there's no component to do this, so I'm loo...