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

10-21-2009, 12:11 AM	#1
MattSanti HyperActive Warrior War Room Member Join Date: Jun 2008 Location: Seattle, Washington, USA Posts: 249 Blog Entries: 1 Thanks: 11 Thanked 35 Times in 22 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.
	Want To Earn 75% Commission Rates By Reselling A Proven Self Help Book (& Receive 1-on-1 Support From Matt)

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: 307 Thanks: 55 Thanked 88 Times in 36 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...
	P.S.: This Post is generated using the BBCode Editor >> Autoblogging on Blogger & Wordpress WSO << >> Get your Unique Software to Resell WSO <<

10-21-2009, 12:31 PM	#4
MattSanti HyperActive Warrior War Room Member Join Date: Jun 2008 Location: Seattle, Washington, USA Posts: 249 Blog Entries: 1 Thanks: 11 Thanked 35 Times in 22 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
	Want To Earn 75% Commission Rates By Reselling A Proven Self Help Book (& Receive 1-on-1 Support From Matt)