Import bulk users in Adobe CQ

[SushantRao-i5mC]

I am trying to upload bulk users in Adobe CQ. These users are present in an excel/CSV file. I also want to assign permissions. How can I do that?

[Sham_HC]

Create group with permissions, assign user to that group & do not(avoid) set permissions at user level.

[smacdonald2008 · Accepted solution]

You need to write a custom AEM service for this. The custom service uses the AEM User Management APIs to create users. 

http://jackrabbit.apache.org/api/2.2/org/apache/jackrabbit/core/security/user/package-summary.html

The custom AEM service needs to read an Excel file. See this community article for info on using AEM and Excel.

http://helpx.adobe.com/experience-manager/using/creating-custom-excel-service-experience.html