topic Re: Sense - Bulk Custom Property Addition using excel in Management & Governance

Sense - Bulk Custom Property Addition using excel

aadil_madarveet — Mon, 18 Jul 2016 07:51:44 GMT

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

Re: Sense - Bulk Custom Property Addition using excel

krishgk_ispot — Fri, 16 Nov 2018 00:33:28 GMT

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

Re: Sense - Bulk Custom Property Addition using excel

aadil_madarveet — Wed, 05 Dec 2018 06:45:02 GMT

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

Re: Sense - Bulk Custom Property Addition using excel

simonaubert — Thu, 14 Jan 2021 07:12:37 GMT

Hello,

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

Best regards,

Simon