WordPress.org

Support

Support » How-To and Troubleshooting » How to bulk load posts ?

How to bulk load posts ?

  • Hi,

    I have dumped post-title and post-body in a text file. How do I load this into MySQL database using WordPress. I basically want to bulk load these posts (over 2000) automatically instead of doing it manually one by one.

    Your help in this regard is appreciated.

    Thanks in advance

    Regards

Viewing 10 replies - 1 through 10 (of 10 total)
  • MichaelH

    @michaelh

    I’d do an Export of your blog, then look at that file to learn how to contruct an XML file that you can import into WordPress using Manage->Import->WordPress.

    Hi Michael,

    Thanks for your reply. Your way seems to be the best method to bulk load. However, I am unable to understand as to what value should I pass for the following tags:

    <wp:postmeta>
    <wp:meta_key>_edit_lock</wp:meta_key>
    <wp:meta_value>1228244329</wp:meta_value>
    </wp:postmeta>
    <wp:postmeta>
    <wp:meta_key>_edit_last</wp:meta_key>
    <wp:meta_value>1</wp:meta_value>
    </wp:postmeta>

    Before loading data, I will be create all the required categories and reference them in the xml file.

    I have created couple of sample posts and exported data into xml file and have noticed that “<wp:meta_value>1228244329</wp:meta_value>” value keeps changing between posts. However, a value of “1” is constant in the second occurrence in all the posts.

    Your kind help in this regard is appreciated.

    Regards

    Please help ………

    ?????

    any help ??????????

    I am having the same issue. I have not found the solution to what the <wp:meta_value>1228244329</wp:meta_value> is

    have you?

    i too would love an answer to this question… or maybe an alternative solution to bulk load posts?

    I wouldn’t worry about it too much.. I am in middle of something and actually I needed this information but…. I just realized. This is probably some kind of lock, so 2 people don’t edit the same post at the same time (or something similar). _edit_last has value 1 – probably id of a user you are using. you’re probably first user of this blog, right? 😉

    Maybe this is unix timestamp -> http://www.unixtimestamp.com/index.php

    “1228244329” means in human language “12 / 02 / 08 @ 12:58pm”

    It can be LAST EDIT time

    Hi, I made a plugin that allows users to import files that use the CSV format. With a properly set up file, you can import dozens, or even hundreds of pages into categories you’ve set up.

    http://www.wesg.ca/2008/06/wordpress-plugin-mass-page-maker/

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘How to bulk load posts ?’ is closed to new replies.
Skip to toolbar