Script to move qvd files from 1 space to another

[Gazza]

Hi,

Does anyone know how to write a script that would loop through all the data folders in my Personal Space looking for any qvd's that start with 'EXT_' and copy them all into another Space called 'Target Space' ?

thanks

[rafaelencinas]

Hi @Gazza 

Solution 1

You can move and rename your QVDs by Administration Console 

 1 - Rename QVDs

2 - Move QVDs

Solution 2

1 - You must list all files in your personal space

2 - Load each table in memory

3 - Store new table into another space

for each File in filelist ('lib://DataFiles/*.*')

trace $(File);
let vTableName = Replace(File,'lib://DataFiles/','');

trace $(vTableName);

$(vTableName):
Load * From $(File)(qvd);

Store $(vTableName) into ['lib://NewSpace:DataFiles/EXT_'$(vTableName)](qvd);
Drop table $(vTableName);


next File

You cannot delete QVDs from script, you must have do it for Management Console or when you click in the data connection to read a file and click in the trash in the right

Bye !

[Sierd_Boersma]

Or you can write a powershell script with qlik CLI then you can delete the files.

[Gazza]

Thanks both of you.

My end goal here is to schedule a Qlik file to run each day (eventually in Prod) that will just copy over qvd's from different data folders, so not deleting anything, into a folder for Self Serve people to use.

Is there a better way to do this?

thanks