How to load plr data into blog database?

1 replies
Hi, guys,

I got a plr database which is distributed in sql format. It is a list of INSERT statements.

Any suggestions to load some database into WordPress blog system? I need to schedule the publishing @ 10 posts/day.

Anyone did this?

The source data format is the following:
INSERT INTO article(article_id, category_id, time, title, author, summary, text) VALUES(NULL, 1, ...)

While the exported WP data format for post table is:
INSERT DELAYED IGNORE INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_category`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES(...)

There are lots of differences between the two tables...


Thanks
David
#blog #data #database #load #plr
  • you'll probably need to get a custom script made for you.

    each sql file is unique and you'd need someone to code your sql fields to match the wordpress fields
    Signature


    {{ DiscussionBoard.errors[709513].message }}

Trending Topics