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

      Hi,

       

       

      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:

      user:

      LOAD * INLINE [

          userid, name

          111, Marie

          222, Joanna

      ];

       

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

       

      attributes:

      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:

       

      tocommunity.png

      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,

       

      Sílvia