Importing to Insight to include Comments.

CHARLES J PIKE

We are migrating data from a DB in to Insight and would also like to be able to import the comments from the original information to the Comments in the Objects. Importing a CSV doesn't seem to provide this functionality, but is it possible via a JSON import, and if so, any example would be appreciated. Or any other suggestion.

PD Sheehan

I've only ever imported from CSV or Database sources.

I can't imagine how JSON Import would work for comments. How does the mapping work?

But if I was in your situation, I'd probably create all the objects first, then use the groovy console to import the comments as a second pass.

Basically, the script would read the comment csv, find the corresponding object (created in the prior pass) then add all the comments for the object.