CSV/Excel Data imports via HTTPS method

[Narendra7]

Hi All,

I have read that we can import https files data into Servicenow from Data source. However, when I try to Load either https/http, I keep on getting Null records. Am I missing something here? Could someone please point me in right direction.

When I click on Test Load 20 Records and Load All records from Related Links, I am getting Null Records to the Import Set table. 

Status showing Loaded, however records are zero.

Why it is behaving like this ?

Thanks,

Narendra

[Mark Stanger]

What does your import log say?

[Narendra7]

Hi Mark,

Thanks for your Prompt response. Below is the import Log screen shot.

Thanks,

Narendra

[Mark Stanger]

Looks like it can't open it for some reason so there's likely some issue with your file.  I would try a couple of things to try and validate.

1)  Save the same file both as a CSV and regular XLS and try to import those.  See if the file format makes any difference.  I've seen unpredictable behavior with XLSX before so these other formats are probably a better bet.

2)  If step 1 doesn't give you a better result: Export a list of ServiceNow records from a list to CSV (this will give you a format that SN should be able to handle).  Try to import that file and see what you get.

Hopefully one of these things points you to what ServiceNow doesn't like about your file...or if ServiceNow really can't import anything from your HTTPS source.

[Narendra7]

Hi Mark,

Thanks once again for your quick response.

I tried both the options but no luck.

1)  Save the same file both as a CSV and regular XLS and try to import those.  See if the file format makes any difference.  I've seen unpredictable behavior with XLSX before so these other formats are probably a better bet.

For Excel file in different format(.xls) it showing an error in the Import Log is "IOException on file /glide/nodes/dev43704001_16583/bin/../tmp/ids0640d4ed0f3f13005c9c8e8ce1050ef7.tmp, error in loading headers from the xlsx data source: Can't open the specified file: '/glide/nodes/dev43704001_16583/bin/../tmp/ids0640d4ed0f3f13005c9c8e8ce1050ef7.tmp'"

I saved the file in .csv format, this time no error but not able to see the data in the Staging table.

2)  If step 1 doesn't give you a better result: Export a list of ServiceNow records from a list to CSV (this will give you a format that SN should be able to handle).  Try to import that file and see what you get.

I export some data from SN in both the formats excel and csv and tried to import via Https but the same issue.

However, when I try to import the data from one SN instance to another via Https, it is working fine. I am not able to understand the exact issue with other Https url.

Thanks once again!!

Thanks,

Narendra