Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

QlikView QVX File Format

Not applicable

QlikView QVX File Format

Tags (3)
Labels (1)
Comments
MVP
MVP

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

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
MVP
MVP

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

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

MVP
MVP

Hi Ian,

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

- Ralf

MVP
MVP

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

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..

MVP
MVP

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

chrisbrain
Valued Contributor

So 8 times in the above scenario or 2?

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