I have imported web posts from my blog that had been running on Community Server. I have an RSS of the comments, and can pretty easily create a C# program to parse the comments and extract the essentials. I have tested the following on mySql and it works great, but I can’t figure out how to connect my Visual Studio environmetn to my hosted database on justHosts.com. Is the best way to do this to learn enough php to write a script? I couldn’t find a generic script to do this.
insert into wp_comments (comment_author, comment_date_gmt, comment_content, comment_Post_ID) select ‘<1>’, ‘<2>’, ‘<3>’, ID FROM wp_posts where post_status = ‘publish’ and post_name like ‘<4>%’
where <1> is the author, <2> the date/time, <3> the content and <4> the name of the post the comment refers to, all parsed from the RSS of my original comments.
Thanks
The topic ‘Import Comments from unsupported blog’ is closed to new replies.
(@jesseliberty)
16 years, 1 month ago
I have imported web posts from my blog that had been running on Community Server. I have an RSS of the comments, and can pretty easily create a C# program to parse the comments and extract the essentials. I have tested the following on mySql and it works great, but I can’t figure out how to connect my Visual Studio environmetn to my hosted database on justHosts.com. Is the best way to do this to learn enough php to write a script? I couldn’t find a generic script to do this.
insert into wp_comments (comment_author, comment_date_gmt, comment_content, comment_Post_ID) select ‘<1>’, ‘<2>’, ‘<3>’, ID FROM wp_posts where post_status = ‘publish’ and post_name like ‘<4>%’
where <1> is the author, <2> the date/time, <3> the content and <4> the name of the post the comment refers to, all parsed from the RSS of my original comments.
Thanks