2 Replies Latest reply: Oct 6, 2016 11:42 AM by Aravind Sasidharan RSS

    Qlik Sense ODBC UDC error

    Aravind Sasidharan

      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  [C:\<path>\user_attributes.csv] (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_ConfiguringSecurity_Envir…

       

      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!

        • Re: Qlik Sense ODBC UDC error
          Konrad Mattheis

          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

            • Re: Qlik Sense ODBC UDC error
              Aravind Sasidharan

              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