How to import accounts from CSV to Zimbra

One of the common questions when migrating a system from another mail server
(Microsoft Exchange, MDaemon, Qmail or Postfix) on Zimbra is the import of the account
Email.



Consider the option when account data is publicly available. The import process in this case can be easily optimized using a special script.

How to work with the table:
')
1. Download the excel file .



2. Fill in columns A, B, and C. Columns D, E, F, G, and H are formulas.

3. When done, copy all the rows in column H, except for the header row.
columns.

4. Create a new file. For example, account-zimbra.sh

5. Copy the attached data to a new file and transfer it.

6. Open the console and run the following command as root (copy the file name /
folder):

su cd /home/hoadmin chmod +x acount-zimbra.sh su – zimbra sh /home/hoadmin/account-zimbra.sh 

7. Done, if unlucky, all accounts should be well imported

Note:

• The domain name (for example: domain.com) must be created first.
• Make sure the password length matches the minimum password length available in the menu.
• admin Zimbra.
• If you want to change the password when you first log in, change the command:

 zimbraPasswordMustChange FALSE zimbraPasswordMustChange TRUE 

Hope this was helpful.