topic Re: Extract zip files from WinSCP with qlikview in QlikView

Extract zip files from WinSCP with qlikview

AlexPanda5 — Fri, 31 Jul 2020 10:07:52 GMT

Hey guys!

I'm Alex, first post here!

I'm trying to extract som zip files from a WinSCP sftp.

This is my script:

EXECUTE C:\Program Files (x86)\WinSCP\WinSCP.exe /console /command "lcd
""D:/PRE - BI/PRODUCCION/E11_Nielsen/flatfiles/""" "open
sftp://user:pass@host/" "get *.zip -filemask=">2D"" "/" "exit";

User and pass are generic, but I can confirm that I can get into the sftp using WinSCP.

However, my script just do nothing, as you can see in the image

Any ideas?

Thank you!

Re: Extract zip files from WinSCP with qlikview

jmmolero — Wed, 05 Aug 2020 05:53:38 GMT

I see that execution finished...

Re: Extract zip files from WinSCP with qlikview

AlexPanda5 — Wed, 05 Aug 2020 06:41:43 GMT

Yes, but it doesn't extract a thing!

Re: Extract zip files from WinSCP with qlikview

marcus_sommer — Wed, 05 Aug 2020 13:09:52 GMT

The first part is definitely not valid because it missed a quotes-wrapping like:

"C:\Program Files (x86)\WinSCP\WinSCP.exe"

I don't know if the other parts are correct (syntax and logic) - if it's not worked now I suggest to simplify it by spliting the task into fetching the data and then to unzip them within separate batch-files. If they work like expected you may remain by them and calling the batches within the Qlik EXECUTE statement (and amybe also an appropriate sleep-statement to give them time to finish) instead of using there a rather complex call.

Beside this you need also to ensure that you have enabled the execution from external stuff within your user- and the document-properties.

- Marcus