here is a simple sql script for migrate posts from phpwcms into modx db for given category,
set vaild id’s before run and don’t forget about backup
USE modx_db
SET @modx_parent_id = 2;
SET @wcms_parent_id = 17;
SET @modx_template_id = 6;
INSERT INTO site_content
(`pagetitle`,`introtext`,`createdon`,`content`,`published`,`parent`,`template`,`menutitle`, `searchable`, `hidemenu`, `createdby`)
SELECT article_title, article_summary, article_created, ac.acontent_text, 1, @modx_parent_id, @modx_template_id, '', 0, 1, 1
FROM wcms_db.phpwcms_article a, wcms_db.phpwcms_articlecontent ac
where article_cid = @wcms_parent_id and a.article_id = ac.acontent_aid;
