Download file and unzip it afterwards

[m-feisst]

Hello Community,
we are currently trying to download a zip-file form a ftp-server and unziping it afterwards. We use following steps:

At first, we open a connection providing the hostname, user and password. Afterwards we download the desired zip-file. After the download is completed, we close the connection. Everything is fine until now.

As soon as we want to unzip the file, we get following error at step 4:

To prove it´s not a problem with the file, we decided to download it with an FTP-tool (winscp) and unzip it manually. Following this way, it works. So it can´t be a problem with the original file.

Fortunately the vendor of the file also grants access by http. We decided to download it fia http by step "Download File" and afterwards we unziped the file by step "Unzip File". The process ends without an error. But if I look into the folder with the unziped file, the folder is empty. It seems, that the file is to big, because we were able to unzip small files. The size of the file is about 48 MB.

My final Question consist of two questions?

- Had anybody else the same problem with ftp in the past? How did you solve it?
- There are restrictions on the file size, if we want to unzip it?

[vishal]

Hi m-feisst!

If you look here https://github.com/SheetJS/sheetjs/issues/2204 the error points somewhat towards corrupted zip file, and moreover you mentioned its working for smaller sized files (It seems, that the file is to big, because we were able to unzip small files. ). Although not able to get any details on file size limitation for Unzip, suggesting you try out with different zipped file sizes to understand behavior of the automation.

Other ways to identify Unzip behavior would be to zip a files locally with different sizes and try Unzip step only to know until what size the automation supports. Also by using locally zipped file instead of FTP file for testing we will know if source zipped file is corrupted or issue is with file size.

Hope it helps..

Regards,

Vishal Rathi

[vishal]

Few more links...

• Here https://stackoverflow.com/questions/59872848/error-corrupted-zip-cant-find-end-of-central-directory-... there is reference to the error occurring due to file being in "write mode" before other operations can begin.
• Here https://github.com/SheetJS/sheetjs/issues/35 there is reference to error stating about what type of application creates the file might lead to the "can't find end of central directory error"