Import Comments and Work Notes

[wipeout630]

I am migrating Incidents from a different ticketing system into Service now.   As part of this migration, I have an excel file full of comments and work notes that need to be added to the migrated Incidents.   Some of the questions that I can't find answers to:

• When setting up the transform map, which table do the work notes/comments map to?
• How do I associate the work note/comment in the excel file to the Incident?
• Is it possible to set who & when the work note/comment was created?
  • I have configured the Incident import so that the date created reflects correctly, I'd like the work notes/comments to also reflect the date/time they were created and who created it.

[wipeout630]

I'm starting to think that I need to perform the Incident migration and work note/comment insert at the same time.   Currently, I'm trying to do the import using two sets.

[Subhajit1]

For Importing the Comments and Work Notes, you will have to import it to the sys_journal_field table, coalescing on the Record Numbers.

[wipeout630]

The problem with importing to the sys_journal_field table directly is that it doesn't have a method to associate back to a Record Number.

[bcronrath]

Did you ever figure this out Nathan?   I'm running into the same issue.