Importing incident history into journal entries

[bwong]

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

[adiddigi]

Hey Brian,
We did something similar. We were asked to migrate the Activity log and the Work notes from one instance to other and we did the transformation from sys_journal related tables.
One more important note is : Did you move the incidents from one instance to other or you had created NEW incidents there?
If you had created new incidents afresh in the new instance, its impossible to migrate the Journal-Activity information.
Also have a look at sys_audit table.

[bwong]

The other system we're exporting/migrating from is a legacy system that's custom written, so it's not from SN to SN. The target system is a new instance of SN, but I'm not sure if that matters in this case.

We have already tried importing into sys_journal_field and sys_audit, basically modeling the data based on entries that are manually entered through the GUI. And these imported entries just don't show up under the Activities section...

[jamesmcwhinney]

I am in the exact same boat.   Attempting to import into journal entries and sys_audit but nothing displays correctly in the activities box...

Did you ever find a solution?

[jamesmcwhinney]

I managed to find a way to import the journal entries.

Turned out we were over thinking it..

How to import legacy incidents, comments and worknotes via c# & web services

Cheers,

- James