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 – 0Is there anything else that I need to change?
Thanks
- The topic ‘import posts from Custom CMS’ is closed to new replies.