Specify timestamp and user ID on Journal Entries

roshanrao · ‎09-28-2017

Hi All,

We are developing a custom application that manages cases. This application replaces a system that the customer is using.

Their existing system currently has case notes, which would typically be modeled as journal entries in ServiceNow. The ask is to bring in these notes (along with timestamp and user ID) into ServiceNow at cutover. Is there any way to have these created so that the fields match the legacy system?

Adding the values from the legacy system in the note text would be a fall back, but may be confusing to users.

Thoughts?

Chuck Tomasi · ‎09-28-2017

You may be able to do it by importing the entries in to sys_journal_entry after you've already created the parent record (incident, problem, etc.) I haven't done this directly, but that's the table where the journal entries are stored so that's where I'd start.

View solution in original post

roshanrao · ‎09-29-2017

Fair enough. I'll try the direct insertions into sys_journal_field table.