Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ChannaK
Contributor III
Contributor III

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
TheLazyDeveloper

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
Contributor III
Contributor III
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