Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rduvall33009
New Contributor

How to Copy QVDs from Location A to B using Script

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.

1 Solution

Accepted Solutions
MVP
MVP

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

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

6 Replies

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

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

MVP
MVP

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

DIRECTORY;

t: load rand() AutoGenerate 100;

store t into t.qvd (qvd);

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

rduvall33009
New Contributor

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

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. 

rduvall33009
New Contributor

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

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;

MVP
MVP

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

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

rduvall33009
New Contributor

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

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

Community Browser