2 Replies Latest reply: Feb 8, 2017 11:08 AM by S�lvia Ganh�o RSS

    User Directory Connector via CSV File

    S�lvia Ganh�o




      I'm creating an User directory Connector via Excel (ODBC).

      I've installed the ODBC setup.


      The csv files I'm using, are created via qlik sense like this:


      LOAD * INLINE [

          userid, name

          111, Marie

          222, Joanna



                      Store  user into '$(vCSVPath)users.csv' ( txt, embedded labels, delimiter is ',', msq) ;



      LOAD * INLINE [

          userid, value,type

          111,email,  Marie@gggg.com

          222,email, Joanna@aaa.com



                      Store  attributes into '$(vCSVPath)attributes.csv' ( txt, embedded labels, delimiter is ',', msq) ;



      If I create a normal csv file outside qlik sense script and use this one, the UDC is created, but if I use the files generated through qlik sense script, it gives me this message:



      And both files are exactly the same.

      The only diference I can see is that the file generated by qlik sense script has a few more bytes (3),on file size.



      Any thougths ?


      Thanks in advance,