I have finally spent about 3 hours time total to finish migrating my lifetype journal entries to WordPress.
The next phase is the photo album, but that is not priority.
Since online help fails me (broken links and missing scripts), I've done it manually via phpMyAdmin and mysql queries.
Below are my summary:
wordpress lifetype: plogdb
ID article_id
post_author '1'
post_date &
post_date_gmt plog_articles -> date
post_content text
post_title topic
post_status 'publish'
comment_status,
ping_status 'open'
post_name topic lowercase and hyphenated
post_modified,
post_modified_gmt plog_articles -> date
post_parent '0'
menu_order '0'
post_type 'post'
guid http://nycphantom.com/journal/?p=ID
comment_count plog_articles -> num_nonspam_comments
INSERT INTO `wp_posts`
(article_id,post_author,post_content,post_title,post_status,comment_status,ping_status,post_name,
post_parent,menu_order,post_type,guid)
SELECT ID,'1',text,topic,'publish','open','open',LCASE(REPLACE(REPLACE(REPLACE
(topic,'\'',''),'?',''),' ','-')),'0','0','post',CONCAT('http://nycphantom.com/journal/?p=',ID)
FROM `plog_articles_text`
UPDATE plog_articles p, wp_posts pp SET pp.post_date = p.date, pp.post_date_gmt = p.date,
pp.post_modified = p.date, pp.post_modified_gmt = p.date, pp.comment_count =
p.num_nonspam_comments WHERE pp.id = p.ID AND pp.id <= 2567
UPDATE `plog_article_categories_link` SET category_id = 37 WHERE category_id = 1
UPDATE `plog_article_categories_link` SET category_id = 38 WHERE category_id = 2
UPDATE `plog_article_categories_link` SET category_id = 36 WHERE category_id = 3
UPDATE `plog_article_categories_link` SET category_id = 39 WHERE category_id = 4
UPDATE `plog_article_categories_link` SET category_id = 33 WHERE category_id = 5
UPDATE `plog_article_categories_link` SET category_id = 40 WHERE category_id = 6
UPDATE `plog_article_categories_link` SET category_id = 41 WHERE category_id = 7
UPDATE `plog_article_categories_link` SET category_id = 42 WHERE category_id = 8
UPDATE `plog_article_categories_link` SET category_id = 51 WHERE category_id = 9
UPDATE `plog_article_categories_link` SET category_id = 43 WHERE category_id = 10
UPDATE `plog_article_categories_link` SET category_id = 34 WHERE category_id = 11
UPDATE `plog_article_categories_link` SET category_id = 44 WHERE category_id = 12
UPDATE `plog_article_categories_link` SET category_id = 45 WHERE category_id = 13
UPDATE `plog_article_categories_link` SET category_id = 35 WHERE category_id = 14
UPDATE `plog_article_categories_link` SET category_id = 46 WHERE category_id = 15
UPDATE `plog_article_categories_link` SET category_id = 47 WHERE category_id = 16
UPDATE `plog_article_categories_link` SET category_id = 48 WHERE category_id = 17
UPDATE `plog_article_categories_link` SET category_id = 49 WHERE category_id = 18
UPDATE `plog_article_categories_link` SET category_id = 50 WHERE category_id = 19
UPDATE `plog_article_categories_link` SET category_id = category_id - 30
INSERT INTO `wp_term_relationships` (object_id, term_taxonomy_id, term_order) SELECT article_id,
category_id, '0' FROM `plog_article_categories_link`
Emptied all comments in wordpress, since all spam but 1 testing comment.
INSERT INTO `wp_comments` (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_parent, user_id) SELECT id, article_id, user_name, user_email, user_url, client_ip, date, date, text, '0', '1', '0', '0' FROM `plog_articles_comments`