How to set the sys_created_on of an incident record to its actual record in from the excel file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2024 05:50 PM
Hello, devs!
How can I explicitly set the sys_created_on of an incident record that I will import using an Excel file? I have tried mapping it in my transform map but it doesn't work, the sys_created_on of the imported record is the time and date of the import.
The reason why I want to set the sys_created_on explicitly is that I am going to also import the comments and work notes of the records from one instance to another. I have read some posts about how to do it but I don't understand it quite well.
Can someone also explain in this post how to import the comments and work notes from one instance to another?
Thank you so much in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2024 06:42 PM
Hi @tidert_24
Please have a look into the following article. As per the article it says setting system fields through transform script or through field mapping in import set is not possible. The only option you have is the XML import.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0870503
Thanks!
Ram

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2024 07:48 PM
Hmm I didn't see any mention of not using a transform script in the article, only when you try to field map it. I'd be curious to try an onAfter transform script to see if you can override the date after the record is inserted. Once you have the records with the correct timestamp along with the work notes and comments then export xml the batch of records and import xml into the other instance. Or you could clone over another instance depending if they were both subprod instances