TOPIC: Trouble importing comments from WP

Hello,

Converting from WP to Joomla. I have the articles moved over and the post IDs in joomla articles match the ones that were used in WP. Installed JoomlaComment. I go and post a new comment and everything works fine.

I have 7000 comments to import. I am manually matching them up in "importcomment." I have tried matching different columns and I still can't get the comments attached to the proper articles. the comments are imported though. I think the article id is getting placed under the "importid" column in jos_comments.

Do you happen to have a list of the column heading in the jos_comments table and what each of them do. I might be able to fix it with that info.

Thanks

articleid = contentid

More info,

The comment was being attached to the correct article after matching it as stated. The problem is/was that the comments are not being published. The joomlacomment component lists them as published. If you unpublish each one and then republish them, everything works correctly.

Upon examining the database, jos_comment is listing a value of "2" for coments that should be approved (or were in WP). The value in my wordpress database is 1. After I go through the unpublish/republish the value of the joomacomment database is 1 and everything works.

Any idea why the values of 1 in my wordpress database are given a value of 2 upon inmport. Is there an easy way to fix this besides manually doing each one. I could batch them but then I would be approving a lot of spam comments and then I'd have to deal with them.

I don't know. I will try and see for myself.
an easy way to update all comments to published would be to open phpmyadmin and execute the following SQL(you have to be in the right database)

That fixed the issue. Now I have migrated my WP articles to Joomla and have the comments attached.