Qlik Sense: UDC ODBC error "Field separator matches decimal separator or text delimiter"

[Alexis_Touet]

When setting up a User Directory Connector based on an Excel file (ODBC), you are trying to sync the users and attributes on a CSV but you are receiving the error :

"ERROR HY000 ODBC text Driver Text file specification field separator matches decimal separator or text delimiter"

Environment

Qlik Sense Enterprise on Windows  

Resolution

1. Create schema.ini file and place it in the same folder location as your CSV file.
2. Include a line that defines the current decimal separator used in the CSV. For more information on the schema.ini, please refer to the Related Content section

Example:
If your CSV uses a period as a decimal parameter, this is what the first 2 entries will look like in your schema.ini file.

[filename.csv]
DecimalSymbol=.

Note: You could also replace the decimal separator in the CSV file with another character, like a semicolon (;) for example.

Cause

The CSV file was generated with an Operating System set to English locale in its language settings and accessed from another OS set with Non-english locale language settings.

Related Content

https://docs.microsoft.com/en-us/sql/odbc/microsoft/schema-ini-file-text-file-driver?view=sql-server...