Data Source With GZIP file

[Alex275]

Hello All, 

I need your help about importing data from a data source in Service Now. A tool in my company are exporting us data in csv format compressed in gzip format. 

If I try to import this file in the data source the import doesn't work. But if I import the file after uncompressed it, the import work. 

I think gzip format is not supported in data source (even if I check the "zipped" checkbox). Can you confirm that ? 

In this case, how can I import this file directly in Service Now ? 

Thanks, 

Alexandre

[harishdasari]

Hi Alex,

make sure there are any no spaces in your zipped file names, otherwise, this will fail to extract the data from zipped files.

Yes, Zipped field will work in the data source to extract any zipped files.

manually try to import a zipped file without any spaces in the file name, then you can come to know what is going wrong.

Thank you.

Hope this is Helpful.

[Alex275]

Hi Harishdasari, 

Thank you for your answer. However, I haven't any space in my filename. 

I tried to import the file after unzipping it and it worked. But if I try to import the file compressed (GZIP format) manually (filename.csv.gz), it doesn't work. I tried to do the same by compressing my file in ZIP format and I haven't any problem. 

I think GZIP format is not supported. I read something about using Mid Server to unzipped the file and use it after but my knowledge on this is quite limited. 

Thanks, 

Regards,

Alexandre

[Ankur Bawiskar]

Hi Alex,

I am 99% sure that gzip file won't work since there is nothing for that format in the ServiceNow documentation

you can try using directly the zip file

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Alex275]

Hi Ankur, 

Thank you for your answer. That's confirm my assumption. However our tool can extract data only in a gzip file. Do you know if a workaround exist for importing data with this format ? 

Thank, 

Alexandre