Textpattern CMS

#1 2012-11-07 15:01:40

gavnosis

Member

From: Milton Keynes, UK

Registered: 2005-03-12

Posts: 151

Website

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 :-)

#2 2012-11-07 15:06:07

colak

Admin

From: Cyprus

Registered: 2004-11-20

Posts: 9,174

Website GitHub Mastodon Twitter

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.

#3 2012-11-07 16:51:59

gavnosis

Member

From: Milton Keynes, UK

Registered: 2005-03-12

Posts: 151

Website

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

#4 2012-11-07 17:06:06

whaleen

Member

From: Portland

Registered: 2006-05-11

Posts: 373

Website

Re: Exporting articles only from TXP using PHPMyAdmin

gavnosis wrote:

Are they any use as as CSV?

Maybe with jmd_cvs as a tool to import them into the next installation?

Never used it myself.

---

txtstrap (Textpattern + Twitter Bootstrap + etc…)

#5 2012-11-08 09:17:16

Algaris

Member

From: England

Registered: 2006-01-27

Posts: 578

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)

#6 2012-11-08 10:03:53

gavnosis

Member

From: Milton Keynes, UK

Registered: 2005-03-12

Posts: 151

Website

Re: Exporting articles only from TXP using PHPMyAdmin

Thank you Whaleen and Algaris. I’ll give it a whirl later and report back…

#7 2012-11-12 12:56:20

gavnosis

Member

From: Milton Keynes, UK

Registered: 2005-03-12

Posts: 151

Website

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.

#8 2012-11-12 14:18:30

Algaris

Member

From: England

Registered: 2006-01-27

Posts: 578

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.