Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
example:
set QVDPath='./QVD/';
Store * from MYTABLE into $(QVDPath)MYTABLE .QVD;
thanks, i am trying this out
thanks it worked !
thanks Cristina
it was also very useful