Importing User Details in Bulk

You can create or modify a large number of users in a comma separated values (.csv) file and import the details into Sonitrol CORE in bulk.

Tip:

  • The file name must have a .csv extension.

  • The first line of the file is the header row.

  • Each user must be on a separate row.

  • Do not duplicate the same user on multiple rows in the same file.

The following table describes the user details are required in the import file.

Note: Ensure that column name in the import file matches the column name in the table below. For custom fields, the column name must match the name provided in the custom field.

Column Name

 Description

Organisation name

Mandatory

User Id

Yes for existing users.

Should be left blank for new users.

Username

Mandatory for General and Operator user types.

IUsername must be unique and should not be in use.

First Name

Mandatory

Last name

Mandatory

User Type

Mandatory

Email

Optional

Email must be unique and should not be assigned to a user in the system.

Tags[0] to Tags [5]

Optional

Up to a maximum of 6 tags can be assigned to a user. Each tag must be in a separate column.

Tags can have only lower case characters.

Roles[0] to Roles [n]

Optional

In case of multiple roles, each role must be in a separate column.

Extended Time

Optional

If not specified, value will be set to False.

MFA Method

Optional

If not specified for existing users, there is no change to the existing value. If this value is not specified for new users, MFA Method is set to Unique Code (Authenticator App).

Custom Fields

The column name must match the display name defined in the system. For enum type of custom fields, the values must match the enum list provided in the system.

To import user details:

  1. Click System on the left navigation pane.
  2. Click Features on the top navigation bar.

  3. In the User Menu section, click Import & Export.

  4. In the Imports tab, click Choose a file.

    The list of users created or modified is displayed. If the import failed, the reason for failure is displayed. indicates that the row contains new user details. indicates that the row contains existing user details. If a user is successfully created or udpated, appears. Else, appears along with an error.

  5. After you fix the conflicts and errors, click Proceed to import all the users.