Loading work log entries in chronological order

[VarunP947598761]

Hi all,

I need to import Work notes entries from an external ticketing system into ServiceNow. And, moreover, the chronological ordering of Work Notes migrated needs to be maintained. External system will provide the dump of work notes in Excel format which can be imported via a Transform map.

I couldn't see any field on transform maps or field maps which specifies which order should be followed while the import set rows are being picked up for transformation and insertion into target table. However, general understanding remains that if the input dump has chronological order (most recent work note as last row in excel) of work notes maintained, then the order of insertion of work notes records into ServiceNow should be same as the order in which rows are present in excel (i.e. first row gets loaded first and so on). But, there is no documentation reference to prove this understanding. If anyone has documentation reference for the same, please share.

Is it the best possible recommended way to meet this requirement or are there any other better options?

Anyone else had this similar requirement and how was it implemented?

Varun Pandhi

[Mark Manders]

I assume you are importing them into the sys_journal_field table, since the work notes are stored there in ServiceNow? The 'order' in which the work notes will be shown on the record itself, is based on the creation date of the work note (sys_created_on), so if your excel has the creation date/time stamp and you map that to the sys_created_on field, you should be good.