Search found 4 matches
- 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...
- 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 ...
- 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!
Thanks!
- 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...