Using the qlik-cli it is possible to import a list of users to a tenant from a csv file.
It will be then possible to assign roles, entitlements and space permissions to the users before they log in to the tenant.
Here's a possible example of how to do that.
- Create a csv file called userlist.csv in this format (see attached sample file)
Name,Email
Mick Case,Mick.Case@example.com
Davide Bironi,Davide.Bironi@example.com
Kenny Handsley,Kenny.Handsley@example.com
Leigh Kersriver,Leigh.Kersriver@example.com
Gerry Vain,Gerry.Vain@example.com
Tommy Ioni,Tommy.Ioni@example.com
Terence Attendant,Terence.Attendant@example.com
John Oughborne,John.Oughborne@example.com
William Guard,William.Guard@example.com
Renato Padovano,Renato.Padovano@example.com
- Save the following shell script and put it in the same folder as the csv file
- Powershell version (note: if the location of the qlik-cli is not added as an Environment Variable Path you will need to modify the script to include the full path in front of the command "qlik")
# Import the csv file as an array of objects
$csv = Import-Csv -Path userlist.csv
# Initialize a counter for the subject
$counter = 1
# Loop through each object in the array
foreach ($row in $csv) {
# Generate the subject using the counter
$subject = "ExampleSubject" + $counter
# Execute the qlik-cli command with the column values and the subject
qlik user create --name $row.Name --email $row.Email --subject $subject
# Increment the counter
$counter++
}
- Bash version for UNIX systems:
#!/bin/bash
# Get the number of lines in the csv file
lines=$(wc -l < userlist.csv)
# Loop from the second line to the last line (skipping the header row)
for ((i=2; i<=lines; i++))
do
# Get the name and email values from the ith line using cut
name=$(cut -d, -f1 userlist.csv | sed -n "${i}p")
email=$(cut -d, -f2 userlist.csv | sed -n "${i}p")
# Generate the subject using the counter
subject="ExampleSubject$counter"
# Execute the qlik-cli command with the column values and the subject
qlik user create --name "$name" --email "$email" --subject "$subject"
# Increment the counter
((counter++))
done
- Execute the scripts according to your operating system requirements
NOTE: users will be created with a temporary SubjectId like "ExampleSubject1", "ExampleSubject2", and so so on. After the first login, users will get a proper SubjectId.
Roles, entitlements and space permissions will follow the users to the new subject.
Alternatives ways of adding users via scripts might be achieved via the an /api/v1/users CALL with the POST method and a payload like:
PAYLOAD:
{
"email": "name@example.com",
"name": "First Lastname",
"subject": "SubjectXYZ"
}
The information and the files in this article are provided as-is and will be used at your discretion. Depending on the tool(s) used, customization(s), and/or other factors, ongoing support on the solution below may not be provided by Qlik Support.
Environment
