topic Re: using Unzip in load script in QlikView

using Unzip in load script

Mon, 27 Jul 2015 14:35:37 GMT

I have the following in my script and it works from the desktop but when running on the server the unzip command is not executed

any ideas ?

EXECUTE cmd.exe /C COPY /Y "$(vJPM)" "$(vServerName)\QV\QVDs\Temp\";

EXECUTE cmd.exe /C unzip "$(vServerName)\qv\qvds\temp\*.zip" "noble_JPM*.*" -q -d $(vServerName)\qv\qvds\temp\;

Re: using Unzip in load script

Anonymous — Mon, 27 Jul 2015 14:42:05 GMT

Have you tried to use the full path of the unzip, like: C:\Progra~1\Unzip\unzip.exe "$(vServerName).........?

Re: using Unzip in load script

petter — Mon, 27 Jul 2015 14:44:10 GMT

Unzip is not a standard program on a Windows Server so you will have to get it installed to be able to use it.

Re: using Unzip in load script

Gysbert_Wassenaar — Mon, 27 Jul 2015 14:46:44 GMT

You don't use an absolute path to the unzip executable. Are you sure that the path to it is in the PATH environment variable of the service account that reloads the qlikview document?

Re: using Unzip in load script

Mon, 27 Jul 2015 15:37:40 GMT

unzip is in the PATH environment variable of the service account and I have used an absolute path but still does not work

Re: using Unzip in load script

Mon, 27 Jul 2015 15:43:28 GMT

Was a DOS issue with the absolute path - moved unzip from Program files\unzip to C:\unzip and it is working - thanks