QVD changed path

[felcar2013]

Hi

i am new to QV. In my script i access to qvd files located in a file server. I reorganized the qvd files and relocated them in a different folder. Now when i reload the script it was clear that the application does not recognize the path of the qvds. What should i do so that QV recognizes the new location of the qvds? Is it possible to create a text file with the path of the qvd files location and then use an "include" statement to call it?

thanks

felipe

[alexpanjhc · Accepted solution]

I created a folder   c:\QVW\ include and in that folder i have a file called Data_file_locations.txt

i have only one line in that file

SET vDFLocation = 'c:\QVW\Data\';

then in your script, you would need something like

//  Get the directory that the QVW is being reloaded from.

LET v_RootDirectory = Replace (DocumentPath (), '\' & DocumentName (), '');



//  Bring in variables from the Include directory file.



$(Include=$(v_RootDirectory)\Include\Data_File_Locations.txt);



//  Setup locations of different data sources.



SET v_QVDFolder = '$(vDFLocation)QVD\';

SET v_ExcelFolder = '$(vDFLocation)Excel\';

SET v_CSVFolder = '$(vDFLocation)CSV\';

SET v_ExcelControlFolder = '$(vDFLocation)Excel\';

when you load your source file(qvd or excel )

you'd need to do

LOAD

*
FROM
[$(v_ExcelControlFolder)INTAKE.xlsx]
(ooxml, embedded labels, header is 2 lines, table is INTAKE);

LOAD

*
FROM
[$(v_QVDFolder ))INTAKE.qvd];

when you change to the new system/location, you just need to change the include file.

HTP.

[#3]

example:

set QVDPath='./QVD/';

Store * from MYTABLE into $(QVDPath)MYTABLE .QVD;

[felcar2013]

thanks, i am trying this out

[felcar2013]

thanks it worked !

[felcar2013]

thanks Cristina

it was also very useful