Convert Word Doc to XML OR CVS File to MySQL to Upload to Wordpress

MattSanti · 10-21-2009, 12:11 AM

Okay I have an old public domain book I want to to post on to my wordpress blog.

It's over 200 pages so I don't want to manually copy and paste every single post and hit publish 200+ times.

Would there be a way to somehow export with all the settings I need - take the book, turn it into a CVS file then convert that to MySQL database which then could be imported into wordpress?

I know there is some kind of way, just don't know what every technical step is.

SimonFairbairn · 10-21-2009, 05:38 AM

It sounds possible, but it'll probably take a few tries to get it right. If you use PHPMyAdmin, you'd be able to import CSV files but you'll have to make the CSV file match the table structure of the wp_posts table within the WordPress database.

If you want the stuff to be the post content, then your CSV file would need to look something like this:

Code:

"","2009-10-21 10:00:00","2009-10-21 10:00:00","{YOUR CONTENT HERE}","{YOUR TITLE HERE}","","publish","open","","{YOUR TITLE HERE}","","","2009-10-21 10:00:00","2009-10-09 10:00:00","","0","","0","post","",""

I haven't tested this so I can't guarantee that it'll work but that's basically the table structure of the wp_posts table and it's how each line of your CSV file will need to look.

Hope this helps!

Si

dspa72 · 10-21-2009, 05:52 AM

I know of this problem, I have searched for something like that but with no success. I figured out a solution in my new software (coming soon), but you alway need to split the document in many txt files...

MattSanti · 10-21-2009, 12:31 PM

Hey great guys, thanks for the info. I'll see how to get this coding thing to work. Matt

starboy19 · 10-22-2009, 10:49 AM

You can do it online. There are pleanty of convertors. you just upload your file, give your email and when is ready they announce you to download it.
It's simple.
From some time I use only online tools for little projects of course ( not in cases when you have some private data)

.

10-21-2009, 12:11 AM	#1
MattSanti HyperActive Warrior War Room Member Join Date: Jun 2008 Location: Seattle, Washington, USA Posts: 148 Thanks: 8 Thanked 13 Times in 9 Posts Social Networking Contact Info	Convert Word Doc to XML OR CVS File to MySQL to Upload to Wordpress Okay I have an old public domain book I want to to post on to my wordpress blog. It's over 200 pages so I don't want to manually copy and paste every single post and hit publish 200+ times. Would there be a way to somehow export with all the settings I need - take the book, turn it into a CVS file then convert that to MySQL database which then could be imported into wordpress? I know there is some kind of way, just don't know what every technical step is.
	>>>>>---WSO: 9 Spots Left: Introducing Matt's Powerful Web 2.0 Backlink Extravaganza! I Hate Your Competition Too!---<<<<<

10-21-2009, 05:38 AM	#2
SimonFairbairn Warrior Member Join Date: Oct 2009 Location: Manchester, UK Posts: 21 Thanks: 1 Thanked 2 Times in 2 Posts Social Networking	Re: Convert Word Doc to XML OR CVS File to MySQL to Upload to Wordpress It sounds possible, but it'll probably take a few tries to get it right. If you use PHPMyAdmin, you'd be able to import CSV files but you'll have to make the CSV file match the table structure of the wp_posts table within the WordPress database. If you want the stuff to be the post content, then your CSV file would need to look something like this: Code: "","2009-10-21 10:00:00","2009-10-21 10:00:00","{YOUR CONTENT HERE}","{YOUR TITLE HERE}","","publish","open","","{YOUR TITLE HERE}","","","2009-10-21 10:00:00","2009-10-09 10:00:00","","0","","0","post","","" I haven't tested this so I can't guarantee that it'll work but that's basically the table structure of the wp_posts table and it's how each line of your CSV file will need to look. Hope this helps! Si
	Create stunning InfoProducts mini-sites in under 10 minutes with our amazing FREE WordPress theme: http://www.infoproductstheme.com

10-21-2009, 05:52 AM	#3
dspa72 Donato Spagnolo War Room Member Join Date: May 2006 Location: Italy Posts: 140 Thanks: 5 Thanked 27 Times in 9 Posts Contact Info	Re: Convert Word Doc to XML OR CVS File to MySQL to Upload to Wordpress I know of this problem, I have searched for something like that but with no success. I figured out a solution in my new software (coming soon), but you alway need to split the document in many txt files...
	New Semi-Autoblogging Tool a "white hat" program that gets "black hat" results >>www.BlogHatter.com<< coming soon...

10-21-2009, 12:31 PM	#4
MattSanti HyperActive Warrior War Room Member Join Date: Jun 2008 Location: Seattle, Washington, USA Posts: 148 Thanks: 8 Thanked 13 Times in 9 Posts Social Networking Contact Info	Re: Convert Word Doc to XML OR CVS File to MySQL to Upload to Wordpress Hey great guys, thanks for the info. I'll see how to get this coding thing to work. Matt
	>>>>>---WSO: 9 Spots Left: Introducing Matt's Powerful Web 2.0 Backlink Extravaganza! I Hate Your Competition Too!---<<<<<

10-22-2009, 10:49 AM	#5
starboy19 Active Warrior Join Date: Oct 2009 Posts: 40 Thanks: 3 Thanked 3 Times in 3 Posts	Re: Convert Word Doc to XML OR CVS File to MySQL to Upload to Wordpress You can do it online. There are pleanty of convertors. you just upload your file, give your email and when is ready they announce you to download it. It's simple. From some time I use only online tools for little projects of course ( not in cases when you have some private data) .