How to add Exchange Distribution Lists in Bulk through HC?

Question: How to add Bulk Exchange Distribution Lists through HC?

Answer:  In Hosting Controller control panel, Exchange Distribution Groups of type Security and Distribution can be added in bulk by navigating to the path Provisioning >> Exchange Organizations >> Distribution Lists >> Add Bulk Distribution Lists
 
Below is the CSV format. Sample file can be downloaded from this link Bulk-DL.zip
Name,EmailId,Type,AdministratorList,MembersList,IncomingMessageSize(MB),IsSendersInsideAndOutsideOrganization
 
GroupA Test1,bulkdltest@hc10.com,Distribution,shr@hc10.com;hc10@hc10.com,hc10@hc10.com;hc101@hc10.com;shr@hc10.com,50,True   
GroupB,bulkdltest1@hc10.com,security,shr@hc10.com;hc10@hc10.com,hc10@hc10.com;hc101@hc10.com;shr@hc10.com,50,False  
 
Important: Don't insert space after comma ','
 
If you are providing multiple Group Administrators and MembersList then ensure that email addresses are separated by semicolon.Please see below for clarity :
 
P.S.
  • All fields are mandatory therefore do not miss any field in the CSV file.
  • Both Distribution Lists of type Security and Distribution can be added in bulk.