Skip to main content

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
aadil_madarveet
Partner - Creator II
Partner - Creator II

Sense - Bulk Custom Property Addition using excel

Hi All,

I have setup Qlik Sense and configured all the server related option and the site is now up. However, to create security rules i need to add a custom property to the users based on which i can create the security rules.

I know that manually i can create a custom property and assign to the users from QMC.

I am looking to add custom property to all of the users from an excel file. Like, i'll extract the complete list of users from LDAP, i'll add the custom property to each of the users according to the requirement and then, i would like to import or read in this excel file into QMC to assign the custom property to all the users.

We do not have control over the current LDAP and so we cannot add the property to the LDAP now. and hence the workaround i am looking for.

Could someone please help me on how i can achieve this.

Thanks,

Aadil

3 Replies
krishgk_ispot
Partner - Contributor III
Partner - Contributor III

@aadil_madarveet Did you figure out the solution for bulk importing Custom Properties from Excel/DB?

aadil_madarveet
Partner - Creator II
Partner - Creator II
Author

Unfortunately. No.

The closest option i could come up with is to use the QRS API to update the custom properties of the users. 

User QRS API Endpoint

https://<serverName>/qrs/user/<user_id>?Xrfkey=abcdefghijklmnop

Reference Documentation:

https://help.qlik.com/en-US/sense-developer/November2018/APIs/repositoryserviceapi/index.html

simonaubert
Partner - Specialist II
Partner - Specialist II

Hello,

You can also vote for this idea https://community.qlik.com/t5/Ideas/Custom-Properties-Bulk-Load/idi-p/1767384

Best regards,

 

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision