hypoluxa
Member
Posted 2 years ago #
I'm looking to import a few thousand posts into my wordpress db. I can make the formatting anyway that's need, I just don't know how to move the formatted posts.
Can I do a back-up of the db, manually put the data in, and then send it back up?
Is there a plug-in that can do it?
thanks for the help
Where are the few thousand posts currently? Another CMS or blogging system?
Can it export them as RSS?
hypoluxa
Member
Posted 2 years ago #
They are not posts, they are in a spreadsheet. I'd like to make them posts.
Since they are in a database I can export them whichever way works for WP.
thanks
facing the same problem here ... the dashboard offers the opportunity to import a rss-file. so if someone could tell, what kind of structure this file has to have, this should work.
so i need the definitions for the rss-header, an entry an the rss-footer.
hypoluxa
Member
Posted 2 years ago #
I've figured out how to do it! You don't need feed header/footer. Put a line break between each <item>. In my import I didn't need to adjust the <pubDate> but I'm sure using the format below, you can do it.
<item><title>TITLE OF POST</title><comments></comments><pubDate>Sun, 01 Nov 2006 18:50:02 +0000</pubDate><dc:creator>YOUR USERNAME</dc:creator><category>YOUR CATEGORY THAT MUST MATCH</category><description>CAN BE REFERRED FROM CONTENT</description><content:encoded>CONTENT WITH POSTS--CAN ALSO INCLUDE HTML</content:encoded></item>
ccsachs
Member
Posted 2 years ago #
i just found your post and have a question. I am new to Wordpress (and blogging) and have a bunch of html files that I converted to an excel file. I can easily modify the file so that it is a text file like the one in your sample.
How did you import this? as RSS Import?
What is meant by description?
Thanks.