Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find the generator qvw file of a perticular QVD ?

Any one please let me know how to find the Source genetor qvw file for a perticular qvd file.

Thanks in advance.

11 Replies
Not applicable
Author

Hi,

As for as i know there is no feature in qlikview to find out the Source Generator Qvw.

Developer who has developed the appllication should maintain seperate forlder for the Sources Generator Applications.

IF not you need to open all the QVW application and search (Ctrl + F) for the qvd genartaion code.

- Peterson

Not applicable
Author

Thanks alot Peterson..

Not applicable
Author

This doesn't help your problem right now but is maybe something to consider- when any change gets made to a production report, put a copy of the script into sourcesafe/TSF/SubVersion/some other versioning system. This will allow you to easily search it for the reference to the QVD. This is very useful for all sorts of scenarios - including the one that I hate the most:

DBA: I am changing field X to Y

QV developer: Oh ok I shall go and open every qvw and search the script

DBA: oh ok how long will that take?

QV Developer: Longer than it should 🙂

Whilst I remember it is best to put your connection strings into text files (use the Include function in QV to reference them), as going through each QVW to replace a string due to a server name/server IP change is a pain. One change in a text file is easier. I think when I have time I may make a list of these kinds of things. Granted, in each version of QV these kinds of things are getting easier and easier to manage.

Not applicable
Author

I found that if u store the the qvd as an xml file then open it in explorer it will show you meta data about the QVD.

kiranmanoharrode
Creator III
Creator III

Hi Vutukuru,

Double click on Qvd file and open with notepad...

on 3rd or 4th line of that notepad file you will find creatordoc, which is the QVW file which generated respective qvd.

Regads

Kiran

Anonymous
Not applicable
Author

Open the qvd with a text editor or xml reader and in the first few lines, the value after <CreatorDoc> is the qvw that generated it.

Anonymous
Not applicable
Author

Hi..so in this case we will loose the benefits of loading from the QVD file...correct?

flipside
Partner - Specialist II
Partner - Specialist II

You can read the data in Qlikview itself ...

QvdTableHeader:
LOAD
Filename() as QVDName,
QvBuildNo,
CreatorDoc,
CreateUtcTime,
TableName,
NoOfRecords
FROM [data1.qvd] (XmlSimple, Table is [QvdTableHeader]);

... but yes this will be a separate load to the data contained therein.

flipside

Anonymous
Not applicable
Author

Hi Kiran...This notepad works...Many Thanks