Adding Users Using a Spreadsheet Import

Document created by user.oxriBaJeN4 Employee on Sep 10, 2015Last modified by user.oxriBaJeN4 Employee on Apr 7, 2017
Version 22Show Document
  • View in full screen mode

To enable your users to receive emails and sign in to Mimecast applications, they will need a user account. You can add multiple user accounts at a time using a spreadsheet import function we provide. This function additionally allows you to set user permissions, user attribute data and alias associations.

 

You can also import delegate mailbox access settings. See the Configure Delegate Mailbox Access page for further detail.

 

What You'll Need

  • A Mimecast administrator account with access to the Administration | Directories | Imports menu.
Mimecast only accepts .XLS spreadsheets for this function. .XLSX spreadsheets are not supported.

Walkthrough

 

 

Step 1: Create your Spreadsheet

 

ss.png

  1. Create a new spreadsheet and add a header value of email (case sensitive) to the spreadsheet. This acts as the Checkpoint cell for the import and tells Mimecast where to begin processing the data. This cell must be present within the A1 - M99 cell range. As implied by the header title, this column is where you should add all of the primary email addresses for the users you wish to import.
  2. Add another header in the cell directly to the right of the email cell titled name (case sensitive). The values entered in this column will map to the Global Name Mimecast field for the corresponding email address.
  3. Add another header in the cell directly to the right of the name cell titled password (case sensitive). This sets a Mimecast Cloud password for the corresponding email address.
  4. Once you have added all of the users you wish to import, save your spreadsheet as a .XLS file.
The steps described are the minimum required to import basic user information. See the table in Advanced section below for details on all of the possible settings that can be imported.

Step 2 - Process the Import

 

  1. Sign-in to the Administration Console.
  2. Select the Administration | Directories | Imports menu item.

    User_Import.png
  3. Select the Upload Only (No Folder) check box.
  4. Use the Choose File button in the Upload Spreadsheet (*.XLS) field to browse your local file system and upload the spreadsheet of users you wish to import.
  5. Click the Preview Changes button to start the import process.
  6. Once the spreadsheet has been processed you will be presented with a preview summary of the users found.
  7. Click Save to commit these changes to Mimecast.
If any imports are performed that pertain to Directory Users, a Manual Directory Synchronization must be performed immediately after the import is successful. This ensures mail flow to them is uninterrupted. Importing changes to these users causes their account type to be changed from "Directory User" to "Manually Imported User", and if the domain on which they reside uses the "Valid Directory Users Only" method of recipient validation, messages to them will be rejected until they are re-synchronized.

Advanced - All Available Settings for Import

 

The table below describes all available settings that can be imported for a user. Each setting you wish to include represents a column in your spreadsheet.

 

Column Heading (case sensitive)DescriptionExample
emailA valid email address. This must not contain spaces, surrounding quotes. etc.user@company.com
nameThe visible name that should accompany the email address and which populates the Global Name field.User Name
password

A Cloud password for a Mimecast user email address.

Ensure the entered password(s) comply with the Password complexity rules defined for your account in the Administration | Account | Account Settings menu. This is verified as part of the import process. Any passwords that do not comply, will cause the import to fail.
123@work
changepassword

Forces the user to change the Cloud password on first logon. This allows Administrators to specify a generic password globally, whilst also ensuring that users are forced to change passwords the first time they logon.

By default this is set to TRUE.

TRUE = Forced to change the password

FALSE = Not forced to change the password

passwordneverexpire

Allows you to specify if a Cloud password should expire as per the password expiration configuration or not.

If you are logged on with an administrator account that has a non-protected role (e.g. a Basic Admin) while running the import, you will not be able to change this setting for administrator accounts that have a protected role (e.g. Full or Super Administrators).

TRUE = The password will not expire

FALSE = The password will expire

accountlockedout

Allows you to unlock an account.

If you are logged on with an administrator account that has a non-protected role (e.g. a Basic Admin) while running the import, you will not be able to change this setting for administrator accounts that have a protected role (e.g. Full or Super Administrators).

FALSE = Account will be unlocked

popAllows the user to retrieve emails from a Mimecast mailbox (internal/local addresses only) using the POP3 protocol.

TRUE = Enabled

FALSE = Disabled

submitAllows the user to send emails from a Mimecast mailbox (internal/local addresses only) using SMTP Authentication

TRUE = Enabled

FALSE = Disabled

alias1Sets an alias email addresses for the user. It is possible to import up to 10 alias addresses for each primary address. To add additional alias addresses add a column for each alias with the heading alias2, alias3, etc.info@company.com
[Any customized value]If the field does not exist, the Import will ensure the attribute is created.telephonenumber, Physical Address, etc.
remoteaccountcode

The Mimecast account code of the Grouping or Mail Processing Account the user belongs to.

This functionality is specific to Advanced Account Administration

CxAy
adminrole

Enables Master Administrators to import account administrators for associated Mail Processing Accounts.

This functionality is specific to Advanced Account Administration

Basic, Helpdesk, Gateway
4 people found this helpful

Attachments

    Outcomes