Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ChannaK
Creator
Creator

QVD source APP

Hi i need some help on how can i find APP name which is generating the QVD file 

I am storing my qvd files in google drive

i am not using documentname() while generating qvd's

any automation read from google drive and get app name of the qvd?

Labels (1)
2 Replies
TheLazyDevelopr
Creator
Creator

The QVD files contains the APP ID which created the qvd. You can read the QVD in XML format and that will contain the app id. I know the monitoring apps have code you can copy to get the name of the apps and their app ids.

ACorona_0-1712848932623.png

ACorona_1-1712848995173.png

 

The QVDTableHeader has the CreatorDoc field which holds your appid

ChannaK
Creator
Creator
Author

Hi i use this script


LIB CONNECT TO 'SpreadSheets';
QVD_Table:
LOAD QVDs as QVDs;

SELECT QVDs
FROM GetWorksheetV2
WITH PROPERTIES (
worksheetKey='ABS-BB:_0',
gidOverride='',
generatedNumberedColumns='false',
skipRows=''
);

 


for each qvd in FieldValueList('QVDs')
QVD_Details:
Load '$(vQvdPath)\$(qvd)' as _file_,
FileBaseName('$(vQvdPath)\$(qvd)') as fileName,
FileSize('$(vQvdPath)\$(qvd)') as fileSize,
//timestamp(FileTime('$(vQvdPath)\$(qvd)')) as fileModifiedTime,
// replace(FilePath('$(vPath)'),'lib://DataFiles', '$(vSystemPath)') as filePath,
Timestamp(QvdCreateTime('$(vQvdPath)\$(qvd)')) as filieCreateTime,
//SubField(TextBetween(concat([<?xml version="1.0" encoding="UTF-8" standalone="yes"?>],'##'),'STORE','.qvd'),'/',-1) as QVDName,
TextBetween(Concat([<?xml version="1.0" encoding="UTF-8" standalone="yes"?>],'##'),'<CreatorDoc>','</CreatorDoc>') as QVDSourceAppID
FROM [$(vQvdPath)/$(qvd)];
Next qvd;

Drop Table QVD_Table;

Exit Script;

 

this script works for me