Import Users

Bulk importing users on your domain

Overview

The Import Users feature in MangoApps allows network admins and organization admins to bulk import and invite users using a CSV file. This enables onboarding by adding a large number of users at once, reducing manual effort.


Preparing the CSV File

To ensure a successful import, the CSV file MUST be formatted correctly.

Below is a list of out-of-the-box fields that can be synced through a CSV file. Either 'email/login' or 'employee ID' is required:

Fields in the CSV File

  • name – Full name of the user (Displayed as "User Name" in the Admin Portal).

  • firstname – The user's given name.

  • lastname – The user's surname or family name.

  • email/login – Unique email ID/login ID (Primary identifier for users). Mandatory.

  • Date of Birth (dob) – The user's birthdate (MM/DD/YY format).

  • title – The user's job title or designation.

  • organization – The company or department the user belongs to. Must match an existing organization on the domain for automatic assignment

  • phone – The user's contact number.

  • desktop_extension – The user’s internal phone extension.

  • mobile – The user's mobile phone number.

  • manager – Manager assigned to the user (for reporting structure).

  • Enabled – This column determines the user account status, with supported values being TRUE, FALSE, and DELETED.

    • TRUE – The account is enabled.

    • FALSE – The account will be disabled.

    • DELETED – The account will be deleted during the CSV import.

  • locale – The user’s preferred language and region settings (Must match the Admin Portal language list).

  • Office Locations – The physical office locations associated with the user (Must match an existing office location on the domain).

  • also known as – Alternative names or nicknames.

  • education – Details about the user’s academic background.

  • experience – Work experience and employment history.

  • expertise – Areas of specialization or skills.

  • employee id – A unique identifier for the user (mandatory).

  • profile image – The user’s profile picture. This option is only available through sFTP Import process (fetch from URL). Regular CSV import cannot load profile images.

  • gender – The user's gender identity.

  • Languages Known – Languages the user can speak or understand.

  • relationship status – Marital or relationship status.

  • Name Of Children – Names of the user’s children, if applicable.

  • alternate email – A secondary email address for the user.

  • date of joining – The date the user joined the organization.

  • address – The user's residential or office address.

  • skype – The user’s Skype ID for communication.

  • Social Media Handles – Links or usernames for social media accounts.

  • bio – A brief biography or personal summary of the user.

  • DefaultPassword – The initial password assigned to the user.

  • User Role – The role assigned to the user within the system.

  • Add To Teams – Specifies teams or groups the user should be added to.

  • Restricted user – Indicates if the user has limited access or permissions. The supported values for this column are 'Y' or 'N', meaning yes or no. Yes means the user will be in a restricted role and No indicates the user will be a normal user.

  • Skills – A list of the user’s professional skills.

Download a sample CSV file using the View sample CSV format link in the Admin Portal.


How to Import Users

Upload the CSV File

  • Click Browse File, select the CSV file, and click Open.

Choose an Import Option

  • Skip the records → Prevents updates to existing users.

  • Update existing users → Updates all existing users with the CSV data.

Additional Configurations

  • Allow out-of-network users to be imported – Allows adding users with non-company email domains.

  • Auto-send invites to new users – Automatically emails login credentials to new users.

Click Import Now to start the process.


Post-Import Actions

  • The network admin receives an email confirming the import status.

  • If "Invite users without an Email ID" is disabled in Admin Portal > Domain > General Settings, users without an email are skipped.

  • Imported users are automatically assigned the "Network User" role, regardless of email domain.


FAQs

What role is assigned to users imported via a CSV file?

All users imported via CSV are assigned the Network User role.

Last updated