Import Users: What are the mandatory fields required for importing users?

[jblomqvist]

Hello,

What are the mandatory fields required for importing users?

In the help it mentions the optional fields but rather than guess and find out through import errors, what are the mandatory necessary fields required for importing users?

My guess is it's:

• E-mail: enter a unique email address. It will be used to log in. The email address must be compliant with the HTML specification explained in the W3C page. So comments, quoted strings and special characters like []/();:'"<>, are not allowed.
• Username: the user name that will be displayed in user interface to identify the user. It must be unique.If you import a user having the same name as an existing user, the import will work, and the imported user will overwrite the existing one.If you import a user having the same name as an existing entity that is not a user (for example a group), you will get an error. The same symmetrical error will happen if you import a group having the same name as an existing user.For example, importing a user called "Demo" will cause an error if a group called "Demo" already exists. If this particular error happens, it will be explained in the log.
• Password: the password for the imported user.
• Domain Account: specify a domain only if you want to link the user with a domain account. The domain account must to be unique among all users.A user must have an associated domain account to use the following features:
  • Receive reports in Qlik Sense hub.
  • Create On-Demand reports in QlikView.The user's Windows Active Directory user account must be associated as the domain account.
• Enabled: set to true if you want to create an active user. Set to false to create an inactive user that will be ignored during report generation.
• Time Zone: all reports are scheduled according to the time zone for a user. Be sure to type the name as it appears in Qlik NPrinting interface.
• Locale: you can assign to a user one of the following locales:
  • En for English
  • Es for Spanish
  • Fr for French
  • De for German
  • Pt for Portuguese
  • Ja for Japanese
  • It for Italian (starting from 17.2.1)
  • Zh for simplified Chinese (starting from 17.2.1)

But want clarification that is correct and no other fields.

[JustinDallas]

Your spreadsheet should probably have all the fields, if not for completeness, then just to make sure it doesn't throw any errors.

The help doc here shows which fields are optional, so you don't have to sweat about missing one:

https://help.qlik.com/en-US/nprinting/February2018/Content/DeployingQVNprinting/Import-Users-Filters...

In your example, you are missing Groups and Roles.  Missing Roles alone will set you up for a bad time.

[Lech_Miszkiewicz]

Agree with Justin,

Official documentation says clearly what is required, whats optional and provides the template file which should be used.

To add to it i would like to comment on fiew fields which made me struggle little bit:

• Domain Account:
  • when you loading user first time it will allow you to create any value in there
  • When you try to update user using import task, make sure that domain account value actualy exists, so make sure that the domain and user exist in your domain
  • you can leave this field blank if you dont want to populate it at all
• Filters (are optional) although it is not mentioned in help document
• Groups (are optional) although it is not mentioned in help document

regards

Lech