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

[Ankur Bawiskar]

Hi Alex,

the only way I could see is use mid server and get the file as normal zip file i.e. extracting from gzip and then do the processing

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, 

I marked your answer as correct because you answered my question. However, I have very few knowledge of using Mid Server. Can you tell me more on how to implement the solution ? 

Do I need to create a script directly on the Mid Server to do the processing or can I create a Mid Server script include on ServiceNow that will do the processing ? 

Thanks in advance, 

Alex 

[Prabha Desai]

Hi Ankur,

Can you please share some pointers as to how we can unzip a csv.gz file using mid server?

Any help in this regard will be highly appreciated.

Thanks is advance,

Prabha Desai

[Ankur Bawiskar · Accepted solution]

Hi Prabha,

you will have to write custom mid server script include script which handles this and send back the normal file

Regards
Ankur

[Liz26]

Hi Ankur, do you have any script template or a link to share of how to achieve this? please