Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

QVX Code pages

Hello

We are curretly in process of adding support for QVX files to our ETL tools Advanced ETL Processor and Visual Importer ETL.

I am not able to find full list of Code pages supported and SDK documentation is confusing.

Can someone point me to the right direction please

Mike,

www.etl-tools.com

Tags (1)
5 Replies
MVP
MVP

QVX Code pages

Hi Mike,

you can read this from the XML header:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>   // Header Codepage = UTF-8

...

<QvxTableHeader>

<QvxFieldHeader>

     <FieldName>SomeField</FieldName>

     ...

     <CodePage>65001</CodePage>  // Data Codepage = UTF-8

In this case the codepage is UTF-8 (65001):

http://en.wikipedia.org/wiki/Code_page_65001

- Ralf

etl_tools
Contributor

QVX Code pages

Ralph

I uderstand that but I guess QVX support several codepages so we want to find a full list of codepages supported

by QlikVIew

so 65001 is UTF8

Any More?

Mike,

www.etl-tools.com

MVP
MVP

QVX Code pages

Yea, would be interesting to know..

I would expect that those are also working:

Windows-1252, ISO-8859-1, UTF-16

but haven't tried so far.


etl_tools
Contributor

QVX Code pages

Character encoding used to write field values in the QVX

data stream. 1200/1201 implies UTF16. Byte order mark

(BOM) is not allowed. BigEndian has no effect on UTF16.

If not set then UTF8 is assumed.

Does it it mean 1200 or 1201 implies UTF16?

Mike,

www.etl-tools.com

etl_tools
Contributor

QVX Code pages

Still no reply ...

Meantime we added support for QVX files generation to our ETL software

http://dbsoftlab.com/online-tutorials/advanced-etl-processor/generating-qlikview-qvx-files.html

Note

All data is exported as UTF8 text using row delimiter

This our first release and we will continue working on improoving our software

Mike,

dbSL

www.etl-tools.com

Community Browser