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

    User Directory Connector via CSV File

    Silvia Ganhao

      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