Update many users' options from a CSV
To update many users at once, open Admin console › Manage Domain(s) › your domain › Bulk Add and click the Update User Details tab. Download the example file, keep the email address in the first column, fill in only the option columns you want to change, using 1 to enable and 0 to disable, then click Upload. You get an email when it finishes.
How to update many users' options from a csv
Where: Admin console › Manage Domain(s) › your domain › Bulk Add › Update User Details
- Open Manage Domain(s), expand your domain and click Bulk Add.
- Open the Update User Details tab.
- Download the example file next to Example Of CSV File.
- Keep Email Address in the first column. Fill in only the columns you want to change, and delete the rest.
- Click Upload next to Import file containing list of user details and choose the file. An email tells you when the process is finished.
Rules for values
| Value type | Format |
|---|---|
| On or off options | 1 to enable, 0 to disable. |
| Mailbox space and secure quota | A number in MB. The domain quota grows automatically if needed. |
| Expires on | DDMMYYYY, DD-MM-YYYY or DD/MM/YYYY. It cannot be later than the domain's own expiry date. |
| Times | 12-hour format with AM or PM, for example 9:00 AM. |
| Several email addresses | Separate them with a pipe, for example `a@acme.in |
| File name | Letters and numbers, spaces, hyphens (-) and underscores (_) only. |
Columns you can use
The example file has a header row with these columns. Email Address is required. Every other column is optional.
| Group | Columns |
|---|---|
| Identity | First Name, Last Name, Alternate Email, Mobile (8 to 13 digits), Display Name (up to 30 characters), Employee Code (up to 20), User Info (up to 100) |
| Work details | Company, Work Address, Work City, Work State, Work Country, Work Pin Code, Work Phone, Department, Designation |
| Online profiles | Facebook ID, Linkedin ID, Twitter ID, Website |
| Home details | Home Address, Home City, Home State, Home Country, Home Pin Code, Resident Phone |
| Sign-in and access | Allow Multiple Login, Enable 2-Step Auth, Home IP, Office IP, Timezone, Disable Settings, Rights Permission, Enable multiple email |
| Mail and apps | Add signature to all messages as default, Show Chat Window, Sync mail from archive (POP/IMAP), Enable Contact Sync, Enable Calendar Sync, Enable Call Recording, Enable Lead |
| Space and expiry | Allowed Space (MB), Secure Quota (MB), Deactivate if inactive for (Days) (1 or more), Expires on |
| Attendance | Enable Attendance and Tracking, Capture Location Data from mobile app, Capture Location Data from mobile app in every (5 to 60 minutes), Capture Location Data From time, Capture Location Data To time, Enable Mark Attendance Module in Mobile APP, Share Location Data, Share Location Data With |
On/off columns take 1 or 0. Enable 2-Step Auth works only when your domain has Allow Dual Authentication turned on in Edit Domain on the Option tab.
Example
Acme India's 200 field staff need more mailbox space before the audit season. Rohit keeps two columns, Email Address and Allowed Space (MB), uploads the file on Update User Details and gets an email when all 200 accounts are updated.
Good to know
- Download a fresh example file for each domain, because some columns depend on the services your domain has.
- To turn on attendance from the mobile app, fill in the tracking interval and the from and to times as well, or the option is not applied.
- Only CSV files are accepted. Only one upload runs at a time.
Common questions
What happens if the new mailbox sizes add up to more than the domain's space?
The domain quota is raised automatically to fit the values in the file.
What if a column needs a service my domain does not have?
That column is skipped during the update. The other columns are still applied.