Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView QVX File Format

Comments
MVP & Luminary
MVP & Luminary

Hi,

I found some not well formatted QVX files where a <Creator> section inside the <QvxTableHeader> tag exists.

If this is a capable QVX format: Can QlikTech provide a full featured XML Schema (.xsd) please!

- Ralf

0 Likes
Employee
Employee
Hi
The additional tags you are seeing are due to the missing (qvx) statement at the end of the store command within QlikView, not generating the qvx correctly they will fail to load back into Qlikview when selecting qvx as a table file
store * from ABC into ABC.qvx (qvx)
the Xsd for the <QvxTableHeader> is in section 1.1 of the QVX File Format.pdf, sample below:

<xs:element name=
"QvxTableHeader ">

<xs:complexType>
<xs:all>
<xs:element name="MajorVersion " type="xs:integer" />
<xs:element name="MinorVersion " type="xs:integer" />
<xs:element name="CreateUtcTime" type="xs:dateTime" minOccurs="0" />
<xs:element name="TableName" type="xs:string" />
<xs:element name="UsesSeparatorByte" type="xs:boolean" " minOccurs="0" />
<xs:element name="BlockSize" type="xs:integer" minOccurs="0" />

Thanks
Ian
0 Likes
MVP & Luminary
MVP & Luminary

Hi Ian,

thanks for your response. In this case the file was created from a vendor's ETL software..

So, I wonder how tolerant the QlikView Load would be processing mal-formatted XML headers. Or, a different XML schema is used?

Ralf

0 Likes
Employee
Employee

Hi

Could you post a copy of the QVX file so I can take a look? also which ETL produced it

Thanks

Ian

0 Likes
MVP & Luminary
MVP & Luminary

Hi Ian,

I cannot upload a file here. You could download it here: http://bit.ly/zfuIof

- Ralf

0 Likes
MVP & Luminary
MVP & Luminary

Thanks for updating this document!

But, I still wonder why QlikView itself uses the "not recommended" format QVX_QV_DUAL if files are created via STORE command...

etl_tools
Contributor

There are some problems with this document.

While working with named pipes certain windows API functions should be used.

This functions use some parameters and user rights as well.

There is nothing in this document about theese parameters.

(Plus they must be called in certain order)

Not everyone is using .NET some people use C++ some Java

While writing our own ETL tools QlikView connector we had to guess those parameters.

We did but it was not easy

http://www.etl-tools.com/etl-tools/qlikview-connector/overview.html

Mike

0 Likes
chrisbrain
Valued Contributor

A couple of questions on the QVX file spec:  1) The PDF says: - Record separator byte RS (0x1E) is written before every record.   Does this mean before every field value? So if you had a table with 4 rows by 2 columns you would write this 8 times?  2) If we are sending a QVX file to QlikView over http, should we set the 'contenttype' of the http response to something specific?  At present I can only get the column headers to appear in QlikView..

0 Likes
MVP & Luminary
MVP & Luminary

1) Record separator byte RS (0x1E) is written ONCE before every record

0 Likes
chrisbrain
Valued Contributor

So 8 times in the above scenario or 2?

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2011-12-02 02:34 PM
Updated by: