Easiest way to find out which QVW has generated the particular QVD?

[#1]

Hi All

May I know which is the easiest way to find out which QVW has genarated the particular QVD? For example we have N number of QVD's in a folder. Which is the best way for the new users to find which QVW has generated the required QVD as there are lots of QVW's in a folder we are not sure which is that QVW that has generated the particular QVD.

Thanks

Attitude

[#2]

you can do it another way

if you use "generate log file" you can find the qvd generated by this qvw

is it ok for you?

[#3]

Thanks for your reponse! I cannot do that, because all the QVW's are in a seperate folder and all the QVD's are in a seperate folder. So it is very difficult to find out which QVW has generated the particular QVD!

[#4]

There is no easy way to did this, you would have to look at the file save time and try and match it back to a group of QVW's on the server that ran during that time. 😞   Regards  R

[#5 · Accepted solution]

try right mouse button (and open in Notepad+))

you shoul see something like this:

?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<QvdTableHeader>

   <QvBuildNo>8935</QvBuildNo>

   <CreatorDoc>E:\QlikView\Publisher\Sourcedocuments\QVD_store \HM_PARAGONY_NAGLOWKI_NrSklepWartoscIloscPozycji2qvd.qvw</CreatorDoc>

[#6]

Thanks PariPari! Now I am able to find out which QVW has generated the particular QVD.It is taking so much time to opens up in Notepad+ though! 🙂

[#7]

better computer

coffee

or siesta break:))

[#8]

Hi All

Is there is any way of finding the required information please? As obviously it will take lot of time to open a QVD file in a notepad+. So do suggest if there is other way of finding the required information.

Thanks,

Attitude

[#9]

try this :

go to script

select field data ---> local file (and chose you file)

next

select fixed record

[swuehl]

Create a text file on your desktop, call it more.bat and enter as content of the file

more %1

then save. Drag your qvd file on the more.bat icon.

There are also some advanced tools out there to to look at the meta data (check out the meta model group here in the community and the tools they offer).

Or maybe Dmitry's tool here:

http://bi-review.blogspot.co.uk/p/fast-qvd-viewer.html

edit:

Or if you want to create a table in QV containing these informations yourself, try something like this to get the meta data of all qvds in the current directory:

QvdTableHeader:

LOAD QvBuildNo,

    CreatorDoc,

    CreateUtcTime,

    SourceFileSize,

    TableName,

    RecordByteSize,

    NoOfRecords,

    Offset,

    Length,

    [Fields/QvdFieldHeader/FieldName] as FieldName,

    [Fields/QvdFieldHeader/BitOffset] as BitOffset,

    [Fields/QvdFieldHeader/BitWidth] as BitWidth,

    [Fields/QvdFieldHeader/Bias] as Bias,

    [Fields/QvdFieldHeader/NoOfSymbols] as NoOfSymbols,

    [Fields/QvdFieldHeader/Offset] as [QvdFieldHeader/Offset],

    [Fields/QvdFieldHeader/Length] as [QvdFieldHeader/Length],

    [Fields/QvdFieldHeader/NumberFormat/Type] as Type,

    [Fields/QvdFieldHeader/NumberFormat/nDec] as nDec,

    [Fields/QvdFieldHeader/NumberFormat/UseThou] as UseThou,

    %Key_QvdTableHeader_B94FCCAC68ED3E20    // Key for this table: QvdTableHeader

FROM *.qvd (XmlSimple, Table is [QvdTableHeader]);