- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 02:27 AM - edited 04-29-2025 03:18 AM
I have created a data source and attached a excel to it.
when I run the data source I got two records created in incident table.
now I just created schedule import and attached it to the data source but no update to the records in incident?
what i am missing?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 03:40 AM
you need to ensure the new file is added to the data source before you run scheduled import.
If you don't do that then it will pick the same file and will ignore the import set rows based on your transform map coalesce logic.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 04:20 AM
Hi @Manikantahere ,
Please ensure that the new file is added to the Data Source before running the Scheduled Import.
If this step is missed, the system may pick up the previous file again, and depending on your Transform Map's coalesce logic, it might ignore the new import set rows.
If you found this response helpful, kindly mark it as correct and close the thread to assist future readers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 02:52 AM
Hello @Manikantahere ,
Can you check is the data not coming to import set table itself, or present in it and not updating the Incident table.
Any coalesce field in the data, not making the records to be updated ?
Regards,
Najmuddin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 03:20 AM
coalesce is there and its coming to import sets.
so do I need to re upload the document always after editing or it will consider updated document??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 03:24 AM
Coelesce makes sure that there are no duplicate records are created.
Check with a new Data and run the schedule.
If the above information helps you, Kindly mark this post as Helpful and Accept the solution.
Regards,
Najmuddin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 03:32 AM
It consistently retrieves the uploaded document data but not the document stored on the PC where I updated the data.
is that true that I keep on upload the document if I do modifications to the sheet? does it take automatically same file destination?