Importing incident history into journal entries

bwong
Kilo Explorer

Hello,

We're experimenting data migration from our legacy Helpdesk system into Servicenow. For incident history, we need to import it in such a way that the history shows up in the incidents' page under the Activities section. Say, if there were 10 edits to the incident, the 10 edits will show up under the Activities section in a chronological order.

We're working with a Servicenow associate, who suggested that we should import(more precisely, import, and run transform) into the sys_journal_field table. What I did was that I made a few changes of one incident manually through the GUI and try to model the import data based on these changes as an example. And that didn't work. The imported entries don't show up under the Activities section.

Nobody on the Community forums seems to have the exact problem. The closest forum post I found was the following, regarding modifying journal entries:

Modify journal field entries?

That gave me a little clue, which is to also import into the sys_audit table, also modeling the data based on the GUI changes as examples. And that also failed. The imported and transformed history doesn't show up under the Activities section.

Can someone give us any insight?

Brian
bwong@imageworks.com