csv file format is required to perform bulk OOB assignment. Create a csv file with format below:


CSV format: 

<groupId>,<userId>,<mobileNo>,<email><newline>

<groupId>,<userId>,<mobileNo>,<email><newline>


Example:

16,user1,01873456789,a@abc.com.my

16,user2,0122334455,b@cba.com

...

...


To open csv using excel, please refer below:


For Excel 2013:

 

  • Open Blank Workbook.
  • Go to DATA tab.
  • Click button From Text in the General External Data section.
  • Select your CSV file.
  • Follow the Text Import Wizard. (in step 2, select the delimiter of your text)