Import or fix script with an Excel file .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2024 02:54 PM - edited ‎06-13-2024 02:56 PM
Hello everyone,
I have the following requirement that I am unable to implement. I have been provided with an Excel file containing one column with contract sys_ids and another column with a field for hours worked on the contracts. Therefore, each row has a sys_id and a field for hours worked. I need to update my contract table with the sys_ids of the existing contracts, updating the new field with the corresponding values (I have 240 rows). The complexity lies in the fact that I do not have a field to map, only sys_ids.
Thank you in advance for your time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-14-2024 08:42 PM
Does each sys_id in the excel correspond to the ServiceNow Contract sys_id?