topic Re: Script to move qvd files from 1 space to another in App Development

Script to move qvd files from 1 space to another

Gazza — Wed, 18 Jun 2025 16:33:10 GMT

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

Re: Script to move qvd files from 1 space to another

rafaelencinas — Wed, 18 Jun 2025 17:21:50 GMT

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 !

Re: Script to move qvd files from 1 space to another

Sierd_Boersma — Thu, 19 Jun 2025 04:35:23 GMT

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

Re: Script to move qvd files from 1 space to another

Gazza — Thu, 19 Jun 2025 08:06:51 GMT

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