topic QVX Code pages in QlikView

QVX Code pages

etl_tools — Thu, 26 Jan 2012 18:55:32 GMT

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

QVX Code pages

rbecher — Thu, 26 Jan 2012 19:17:45 GMT

Hi Mike,

you can read this from the XML header:

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

...

<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

QVX Code pages

etl_tools — Thu, 26 Jan 2012 19:27:16 GMT

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

QVX Code pages

rbecher — Thu, 26 Jan 2012 19:40:14 GMT

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.

QVX Code pages

etl_tools — Thu, 26 Jan 2012 23:59:38 GMT

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

QVX Code pages

etl_tools — Tue, 31 Jan 2012 17:16:03 GMT

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