Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
We would like to import users via a spreadsheet.
What type of Attributes can I create for Users imported via spreadsheet?
For example we have a sheet with the UserID values. In association in another sheet in the same file we have columns such as Name, Department, Country, Role etc provided per user. Can we import these values as attributes?
Is there a limit on how many attributes you can import? Do these attribute values have to have specific column names so Qlik Sense user directory connector can read it correctly?
I am not seeing anything accepted as a solution. @ToniKautto 's answer seems quite right.
To directly address your questions:
Yes, so long as the fulfill the spec (userid,name for the Users Sheet / CSV / Table / View and userid,type,value for the Attributes Sheet / CSV / Table / View).
Technically, I am sure there's a limit. At minimum something on the order of 2^64-1 as a 64 bit process. Practically, at scale, we've seen performance impacts on QRS intensive activity when we start to talk about millions of attributes across all users.
userid,type,value as outlined in the help doc that @ToniKautto pointed to.