WordPress.org

Ready to get started?Download WordPress

Forums

How to bulk load posts ? (11 posts)

  1. momen.web
    Member
    Posted 5 years ago #

    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

  2. MichaelH
    Member
    Posted 5 years ago #

    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.

  3. momen.web
    Member
    Posted 5 years ago #

    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

  4. momen.web
    Member
    Posted 5 years ago #

    Please help .........

  5. momen.web
    Member
    Posted 5 years ago #

    ?????

  6. momen.web
    Member
    Posted 5 years ago #

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

  7. Athmaus
    Member
    Posted 5 years ago #

    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?

  8. Nehe555
    Member
    Posted 5 years ago #

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

  9. lokers
    Member
    Posted 5 years ago #

    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? ;)

  10. motopunkt
    Member
    Posted 5 years ago #

    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

  11. wesg
    Member
    Posted 5 years ago #

    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/

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.