Importing comments from CComments

[RobertvanderHulst]

I was able to import comments from CCOmments with the following SQL script.
Feel free to use it (my prefix is j3_ as you can see)

insert into `j3_engage_comments` (id, asset_id, ip, body, name, created_by, modified_by, created, modified, enabled)
select m.id, asset_id, ip, comment, name, userid, userid, date, m.modified,1 from j3_comment m, j3_content c
where m.contentid = c.id

CComment does not have threading, so the parent_id is not filled.
And CComment does not store the comment as html, so the comments may look a bit 'rough' but the text is copied just fine.

[tk5ep]

Hi,
I tried you SQL command, but this caused the comment field not to be displayed.
I added the email addresses and it work .
So the correct SQL script is
insert into j3_engage_comments (id, asset_id, ip, body, name, email, created_by, modified_by, created, modified, enabled) select m.id, asset_id, ip, comment, name, email, userid, userid, date, m.modified,1 from j3_comment m, j3_content c where m.contentid = c.id