Import or fix script with an Excel file .

Nabs
Tera Contributor

‎06-13-2024 10:37 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.

 

 

Cchange.PNG

Thank you in advance for your time. 

0 Helpfuls
  • 1,154 Views
5 REPLIES 5

Razzumash
Tera Contributor

3 weeks ago - last edited 3 weeks ago

I had a similar issue before with reading Excel files and ended up converting the .xlsx to .csv first—it made things way easier to process in the script include. Also, make sure you’ve installed the correct library if you're using GlideXLS. In my case, I was running this on a system tied to a Microsoft Office 2024 Standard download key UK setup, which helped with formatting compatibility.

0 Helpfuls