2 Replies Latest reply: Feb 8, 2017 11:08 AM by Silvia Ganhao RSS

    User Directory Connector via CSV File

    Silvia Ganhao




      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,