Find QVD store statement in many apps

[GraceGao]

Hi Experts,

i could not find which app to store the QVD. is there any way to search QVD name to find QVD builder app? 

Please help. 

Thanks.

[saso_1970]

Hi Open qvd in notepad ++

[PunamWagh]

If you want to know the app from which that qvd is generated then you can get this information in QVD's metadata,

LOAD
CreatorDoc as "Application ID",     // qvd builder APP ID

NoOfRecords,
Offset,
"Length",
"Lineage/LineageInfo/Discriminator",
filename() as QvdsName,
Filetime() as QvdsRefreshTime,
FileSize() as QvdFileSize,
FROM [lib://path and qvd name]
(XmlSimple, table is QvdTableHeader);

[Majed]

For this, I would suggest creating a separate app, add this in the load script.

This load script loops through the files in the QVD folder, and reads the header from each file.

After running the load script, open a new sheet, add a straight table, add all the fields, and viola, you have all the QVD folder files with all their details.

let a =1; // just a counter
FOR Each File in '.qvd'

FOR Each FileName in FileList('lib://QVD-Folder (user)/*.qvd' ) // Please change to the lib entry of the QVD file

TRACE $(FileName);
a = $(a) +1;
trace $(a);
let the_file = SubField( '$(FileName)','/',4); // the file with extension
let the_file_stripped = "Replace($(the_file),'.qvd','')"; // the file without .qvd extension

Trace $(the_file);
Trace $(the_file_stripped);

NoConcatenate // we don't want the tables to be concatenated

$(the_file_stripped):

LOAD
CreatorDoc as "Application ID", // qvd builder APP ID

NoOfRecords,
Offset,
"Length",
"Lineage/LineageInfo/Discriminator",
filename() as QvdsName,
Filetime() as QvdsRefreshTime,
FileSize() as QvdFileSize

From 'lib://QVD-Folder (user)/'$(the_file)
(XmlSimple, table is QvdTableHeader)
;

NEXT FileName;

NEXT File;

[vikasmahajan]

Hi,

use following code :

FOR i = 0 to NoOfTables()-1

LET vTabNam = TableName($(i));

STORE $(vTabNam) into $(vTabNam).qvd (qvd);

NEXT i

This will create all qvds from your entire models.