topic Re: EXECUTE command to move files listed in an XLSX or TXT ? in QlikView

EXECUTE command to move files listed in an XLSX or TXT ?

dmohanty — Mon, 20 Aug 2018 11:31:39 GMT

Hi All,

I am in process of Moving and Coping some QVWs/QVDs from one Destination to other using an EXECUTE command in a QVW.

EXECUTE cmd.exe /C MOVE "SOURCE" "DESTINATION"

EXECUTE cmd.exe /C COPY "SOURCE" "DESTINATION".

Requirement -

Want to write the name of QVDs/QVWs in a single XLSX or TXT file, so that EXECUTE can read the file and MOVE and COPY all the entries in them. This would avoid writing the EXECUTE command multiple times for multiple files.

Any suggestions?

Regards!

Re: EXECUTE command to move files listed in an XLSX or TXT ?

jonathandienst — Mon, 20 Aug 2018 11:44:46 GMT

You could do the looping over set of filenames in a file in a WIndows batch file. Look here for an example:

scripting language - Copy a list (txt) of files - Stack Overflow

or here

https://www.google.com/search?source=hp&ei=jKd6W9SdN8HTkwX5lLPYCw&q=windows+command+line+moving+a+list+of+files&oq=windo…

Re: EXECUTE command to move files listed in an XLSX or TXT ?

dmohanty — Mon, 20 Aug 2018 13:25:57 GMT

Hi jontydkpi

This is cool. Thanks for this.

I was thinking to that in EXECUTE so that I can Automate the Reload of the the QVW in QMC.

Anyways, if we are doing that in a BATCH file, need to automate that may be by Windows Task Scheduler or Powershell.

Re: EXECUTE command to move files listed in an XLSX or TXT ?

jonathandienst — Tue, 21 Aug 2018 05:37:00 GMT

I was thinking you would use EXECUTE to call the batch file from within the script...

Re: EXECUTE command to move files listed in an XLSX or TXT ?

pradosh_thakur — Tue, 21 Aug 2018 05:54:26 GMT

so you want to do

EXECUTE cmd.exe /C COPY "SOURCE" "DESTINATION"

EXECUTE cmd.exe /C COPY "SOURCE1" "DESTINATION1"

EXECUTE cmd.exe /C xCOPY /Y /I "SOURCE" "DESTINATION" && "SOURCE1" "DESTINATION1"

store all the source and destination in table and use EXECUTE cmd.exe /C COPY "SOURCE" "DESTINATION" inside a for loop

store source and destination in a file and concatenate them in such a way that they form the part in bold and use a variable instead

EXECUTE cmd.exe /C xCOPY /Y /I "SOURCE" "DESTINATION" && "SOURCE1" "DESTINATION1"

regards

Pradosh

Re: EXECUTE command to move files listed in an XLSX or TXT ?

dmohanty — Tue, 21 Aug 2018 08:25:02 GMT

Hi pradosh_thakur

Thanks.

Your XCOPY Command and the Concatenation trick helped a lot. This is helping me achieving the results as well.

Also, I had already used the Storing in a Table technique as below -

QVW:
LOAD
QVW
FROM
Path\Deployment.xlsx
(ooxml, embedded labels, table is QVWs);

FOR Each vQVW in FieldValueList('QVW')
EXECUTE cmd.exe /C COPY "SOURCE" "DESTINATION";
NEXT vQVW

DROP TABLE QVW;