5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

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

by MattSanti
3 replies
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.
#convert #cvs #doc #file #mysql #upload #word #wordpress #xml
  • Profile picture of the author SimonFairbairn
    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
    {{ DiscussionBoard.errors[1301216].message }}
  • Profile picture of the author dspa72
    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...
    Signature
    {{ DiscussionBoard.errors[1301235].message }}
  • Profile picture of the author MattSanti
    Hey great guys, thanks for the info. I'll see how to get this coding thing to work. Matt
    Signature
    Clickbank InfoProduct website for sale: ElementsOfMemory.com. Online Memory Improvement Video Course. PM me with questions.
    {{ DiscussionBoard.errors[1302361].message }}

Trending Topics