Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This article provides an overview of how to manage users using Qlik Application Automation. This approach can be useful when migrating from QlikView, or Qlik Sense Client Managed, to Qlik Sense Cloud when security concerns prevent the usage of Qlik-CLI and PowerShell scripting.
You will find an automation attached to this article that works with the Microsoft Excel connector. More information on importing automation can be found here.
Content
In this example, we use a Microsoft Excel file as a source file to manage users. A sheet name, for example, Users, must be added and this must also be provided as input when running the automation. The sheet must also contain these headers: userId, Name, Subject, Email, Roles, Licence, and Flag.
Example of sheet configuration:
If users are to be created the Flag column must be set to create. If users are to be deleted, there's no need to include roles, but Flag must be set to delete.
Add the List Rows With Headers block from the Microsoft Excel connector to read the values that have been configured in the Excel sheet.
When running the automation you must provide input to the automation, this includes the name of the worksheet to read data from. You also need to specify the first and last cell to read data from, as well as if users are to be created or deleted. Example :
Input | Value |
Worksheet Name | Users |
Excel Start Cell | A1 |
Excel End Cell | G5 |
Mode | Create |
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
How to manage space membership (users)
Thank you @Sonja_Bauernfeind .
COuld you tell me what the authorization key is and how to find it ?
Thank you
Anytime, @random_user_3869
Can you clarify what key you mean? Is it the API key? Managing API keys
All the best,
Sonja
Hello thank you for the support article.
I used
I have a google spreadsheet with the following column
:
- Userid : I set a random number
- Subject : i put a random ID
Roles : always empty
But after launching the automation i noticed that the following bloc (LOOP)
This block loops over 3 or 4 roles for each users.
And i didn't change the automation.
As output in the management console users have user roles.
What i want : Column Role empty in google spreadsheet = no roles.
Can you help.
Thank you
Please share the automation workspace and automation run json file.
To get the above details follow the steps described in this article.
Thanks
Hello @Sonja_Bauernfeind , regarding this screesnhot of List rows with headers/input Section
Do you think it is possible to identify the path of the preview file you see here.
I'm using a brand new account for work but i'm unable to know where i can put my excel file in order for the bloc to identify them.
Thank you
Hello,
Anyone has an idea ?
Thank you