topic How to Copy QVDs from Location A to B using Script in QlikView

How to Copy QVDs from Location A to B using Script

rduvall33009 — Sat, 07 Mar 2015 17:19:40 GMT

Good Morning/Afternoon,

I'm looking to make a copy of QVDs made and placed in one location and then to later move to another. Reason I want to do this is as you know when creating QVDs the prior set is thrown out. So before making the new QVDs that will be stored in '..\QVD' by a QVD Generator I want to move the old set to a separate location '..\QVD_Prior'.

Any assistance will be much appreciated. I thank you in advance for your time and assistance.

Re: How to Copy QVDs from Location A to B using Script

MK_QSL — Sat, 07 Mar 2015 17:26:02 GMT

Rather than copy from one location to another location, why can't you store the same QVD in two different location in one go ?

Re: How to Copy QVDs from Location A to B using Script

maxgro — Sat, 07 Mar 2015 17:29:18 GMT

DIRECTORY;

t: load rand() AutoGenerate 100;

store t into t.qvd (qvd);

EXECUTE cmd.exe /C copy t.qvd t1.qvd;

Re: How to Copy QVDs from Location A to B using Script

rduvall33009 — Sat, 07 Mar 2015 17:32:04 GMT

Say I run the generator, data model and visualization. Then I find that the QVDs made in this process have data and/or errors. I would want the QVDs from the time before. So before making new I would want to move them. For what you suggest I would have two sets of QVDs with errors.

Re: How to Copy QVDs from Location A to B using Script

rduvall33009 — Sat, 07 Mar 2015 17:37:35 GMT

Good Morning/Afternoon Massimo,

Thank you for your fast response. In your answer is 't' the filepath? Such that:

DIRECTORY;

{location A with filename}: load rand() AutoGenerate 100;

store {location A with filename} into {location B with filename}.qvd (qvd);

EXECUTE cmd.exe /C copy {location A with filename}.qvd {location B with filename}1.qvd;

Re: How to Copy QVDs from Location A to B using Script

maxgro — Sat, 07 Mar 2015 17:43:46 GMT

t.qvd is the name of the file

if you want to move qvd file(s) from one folder to another you can use *.qvd; in the example below I have the .QVW document in one folder and 2 subfolder QVD and QVD_OLD

DIRECTORY;

t: load rand() AutoGenerate 100;

EXECUTE cmd.exe /C move /Y .\QVD\*.qvd .\QVD_OLD ;

store t into .\QVD\t.qvd (qvd);

the bold is the dos command, open a dos prompt and type

help move to get option for move

Re: How to Copy QVDs from Location A to B using Script

rduvall33009 — Sat, 07 Mar 2015 18:18:37 GMT

Many thanks. I was able to get that to work in a round about way.