Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Exporting articles only from TXP using PHPMyAdmin
I’ve happily done a whole site before, and included DROP TABLE in the SQL file
If I want to export articles only (to put in a clean installation – things have gone wrong, it’s all in an old version of MySQL etc.), which table is it to EXPORT?
Thanks :-)
Offline
Re: Exporting articles only from TXP using PHPMyAdmin
all articles are saved in the textpattern table but I think that it is not recommended to just import one table.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Exporting articles only from TXP using PHPMyAdmin
OK… What’s the best way to export a few hundred articles then if TXP has (possibly) gone wrong. Are they any use as as CSV?
Thank you
Offline
Offline
#5 2012-11-08 09:17:16
- Algaris
- Member
- From: England
- Registered: 2006-01-27
- Posts: 572
Re: Exporting articles only from TXP using PHPMyAdmin
I use jmd_cvs on a regular basis to import hundreds of calendar events into a Textpattern website that I maintain. All of the data I import starts life in a Word document which I copy and paste into a spreadsheet but I would imagine you should be able to use it with articles exported as a CSV file.
I would strongly advise you test this on a local install first though as jmd_cvs can be a little unforgiving if the spreadsheet isn’t exactly to the plugins liking. If any of your articles make use of special characters such as fancy quotes, ampersands or em dashes, etc. make sure to follow the instructions Blur left in the thread.
—Edit —
Here are some instructions on how I set things up to import my CSV file.
http://forum.textpattern.com/viewtopic.php?pid=246024#p246024
Last edited by Algaris (2012-11-08 09:33:06)
Offline
Re: Exporting articles only from TXP using PHPMyAdmin
Thank you Whaleen and Algaris. I’ll give it a whirl later and report back…
Offline
Re: Exporting articles only from TXP using PHPMyAdmin
…so, if the CSV has come from Textpattern iteself, am I right in assuming that the header row should match perfectly i.e.
ID, Posted, Expires, AuthorID, LastMod, LastModID, Title, Body, Body_html, Excerpt, Excerpt_html…etc.
Offline
#8 2012-11-12 14:18:30
- Algaris
- Member
- From: England
- Registered: 2006-01-27
- Posts: 572
Re: Exporting articles only from TXP using PHPMyAdmin
I would assume so but being to cautious type myself I’d open up the CSV file and double check the header row against the plugins requirements. Also I’ll reiterate what I said earlier. Make sure you test it on a local install first.
Offline