Support » Fixing WordPress » Custom CMS to wordpress database import

  • Hello,
    I have a site with custom CMS with MySQL database which has 30,000+ articles.I want to use now WP and want to import that contents also. How can I convert that database to WP post database format.

    I am writing a php script for that. the auricles all are in text only. No images attached. So, for text only, I noticed that I need to import these fields:

    wp-posts table

    ID – auto increment ( started from last post ID currently have)
    post_author – 1 (admin)
    post_date, post_date_gmt, post_modified and post_modified_gmt – same string in format YYYY-MM-DD HH:MM:SS
    post_content – (text content)
    post_title – same as post_title from original post
    post_excerpt – empty
    post_status – publish
    comment_status and ping_status – open
    post_password – empty
    post_name – title in lowercase and without space( “-” can be used instead of space)
    to_ping and pinged – empty
    post_content_filtered – empty
    post_parent – 0
    guid – permalink
    menu_order – 0
    post_type – post
    post_mime_type –
    comment_count – 0

    wp-term-relationship table

    object_id – post id
    term_taxonomy_id – category id
    term_order – 0

    Is there anything else that I need to change?


  • The topic ‘Custom CMS to wordpress database import’ is closed to new replies.