Importing excel which has 'Links Dirty?' as empty into ServiceNow

SGuha1997
Tera Contributor

‎08-09-2023 08:56 AM

Hi All,

I am trying to load data from a excel (.xlsx) file into a staging table. The excel is auto generated report.

Load Data section viewLoad Data section view

 

There is only one sheet in the excel. On clicking 'Submit' we get the below error.

Load Data errorLoad Data error

Message : com.glide.db.impex.datasource.DataSourceException: Unable to load headers. Please verify that the specified sheet number is valid

 

Then I checked the properties of the excel. Under the 'Details' tab, the 'Links Dirty?' field doesn't have any value.

File propertyFile property

 

So I saved the excel (no modification/update done what so ever), this updated the 'Links Dirty?' field value to 'No' and then tried to manually load the data, and the data load was successful.

 

Has anyone faced a similar issue before? Can you please share any solution for same.
Thanks!

0 Helpfuls
  • 769 Views
1 REPLY 1

Tony Chatfield1
Kilo Patron

‎08-09-2023 01:50 PM

Hi, based in below post; Links dirty is an indication that your excel file has embedded OLE links to other data and that the file considers these links/data sources to be out of date. I suspect saving the file fixes this 'out of date' issue.

The correct fix would be to reformat your excel file so that it contained text data only and not links to other records.

 

Dirty Links? - Microsoft Community