Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Qlik Sense ODBC UDC error

Hi,

I am using the load script to generate the users and user attributes in the format that Server needs.

so in the load script I do the ETL and use

Store user_attributes into  (txt, delimiter is ',');

Now this CSV is UTF-8 encoded. As suggested here

https://help.qlik.com/en-US/sense/1.1/Subsystems/ManagementConsole/Content/ServerUserGuide/SUG_Confi...

If I try to setup a UDC using ODBC

Driver={Microsoft Access Text Driver (*.txt, *.csv)};Extensions=asc,csv,tab,txt;DefaultDir=C:\<path>

I get an error saying cannot read userid from the table.

Manually created CSV in ansi format works fine.

Is it possible to force QLik to use ansi encoding while storing CSV files? Or is there any other way to change the driver parms to UTF-8 encoded CSV.

Thanks!

Tags (1)
3 Replies
konrad_mattheis
Not applicable

Re: Qlik Sense ODBC UDC error

Hi,

we using the same idea and this is working great.

I hopefully can finish very soon a nice document / howto on that.

Some important steps. First save the csv in qlik with ; as a separator.

Second use a shema.ini in the Directory to get it working.

bye Konrad

Not applicable

Re: Qlik Sense ODBC UDC error

Thanks Konrad; It works now.

The only change I had to make was to add a schema.ini in the same directory as the CSV file

Here is the ini file I used.

[users.csv]

ColNameHeader=True

Format=CSVDelimited

Col1="userid" Text

Col2="name" Text

[user_attributes.csv]

ColNameHeader=True

Format=CSVDelimited

Col1="userid" Text

Col2="type" Text

Col3="value" Text

nurfatenmunirah
Not applicable

Re: Qlik Sense ODBC UDC error

Hi Aravind,

I am facing the same issue as yours. Could you please tell me where should I make this changes?

Thank you in advanced.

Ragards,

Mun