Title: import posts from Custom CMS
Last modified: August 20, 2016

---

# import posts from Custom CMS

 *  [infocoolsms](https://wordpress.org/support/users/infocoolsms/)
 * (@infocoolsms)
 * [14 years, 10 months ago](https://wordpress.org/support/topic/import-posts-from-custom-cms/)
 * 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?
 * Thanks

The topic ‘import posts from Custom CMS’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [infocoolsms](https://wordpress.org/support/users/infocoolsms/)
 * Last activity: [14 years, 10 months ago](https://wordpress.org/support/topic/import-posts-from-custom-cms/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics