Import Company Users (Add Users or Update Users)
If you have a large number of users to add or update, you may want to import the records, so you do not have to manually open and update each user record. You can import multiple users with a CSV file by doing the following:
- Export a copy of the CSV file structure.
- Populate the CSV file with user information.
- Import the CSV file into the system.
To export a copy of the CSV file structure
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click User Administration > Company Users.
- Click the File menu and choose Export > Export Structure.
Depending on your browser, the CSV file will be automatically downloaded or you will be prompted to download it manually.
To export existing users for update
- Go to the Company Workspace tab and switch to Admin mode.
- Click User Administration > Company Users in the left Navigator.
- Choose File > Export > All, or select users in the log and choose File > Export > Selection.
Depending on your browser, the CSV file will be automatically downloaded or you will be prompted to download it manually.
To populate the CSV file with user information
- Open Microsoft Excel (or another program compatible with CSV format), and open the CSV file you just saved.
- Enter or modify user information in the spreadsheet. The fields are discussed in the following table. Ensure that you review the notes after the table.
- Save in CSV format.
In this column: | Do this: |
---|---|
First Name* | Enter user's first name. |
Last Name* | Enter user's last name. |
Title | Enter user's company title. |
Email* | Enter user's email address. |
Work Phone | Enter user's work phone number. |
Mobile Phone | Enter user's cell phone number. |
Home Phone | Enter user's home phone number. |
Pager | Enter user's pager number. |
Fax | Enter user's fax number. |
Login Username* | Enter a unique username that the user will use to log in the system. |
Password | Enter a password that will allow the user to log in for the first time. The user can change the password after signing in. |
Time Zone* | Enter the code for the Time Zone (refer to the Unifier Data Reference Guide for the list of codes). This is a required field, even if you are entering a User Preferences Template Name (if the time zone specified in the template is different from this cell, the template selection will take precedence). |
Date Format* | Enter the code for the Date Format (refer to the Unifier Data Reference Guide for the list of codes). This is a required field, even if you are entering a User Preferences Template Name (if the date format specified in the template is different from this cell, the template selection will take precedence). |
Address | Enter the code for the company address to use with this user. (Refer to the Unifier Data Reference Guide for the list of codes) |
Template Name | If you have created User Preferences Templates, enter the name of the template to use for this user. |
Status* | Enter a status code for this user: Active=1, On-Hold=2, Inactive=0 |
* = mandatory column
Note the following:
- Do not delete or change the order of the columns; this will make the file invalid.
- Valid information must be entered into columns corresponding to required fields. An asterisk in the column header indicates required fields. (Expand the columns to see the asterisks if necessary.)
- For non-text-entry fields (Time Zone, Date Format, Address), enter the corresponding code. Valid codes are found in the Unifier Data Reference Guide.
- Non-required fields (column heading does not have an asterisk) are optional. You may enter information or leave these fields blank.
- The length of "Username" cannot exceed 64 characters and cannot include the following:
- Space
- Non-printable characters
To import the CSV file into the system
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click User Administration > Company Users.
- Choose New > Import to import the completed CSV file.
- Click Browse and navigate to where you saved the file.
- Click OK to import. New users are created and existing users are updated.
- Open the User record and set up the Groups, Permissions, Projects/Shells, and Proxy tabs as needed.
If any rows contain errors, no rows are imported. Error messages are listed in the CSV file.
To fix import errors
If you receive the Confirmation message:
Import could not be completed. Do you want to download a file with errors shown?
- Click Yes to open the CSV file.
- Fix the rows that contain errors.
- Re-import the file.
Last Published Tuesday, December 12, 2023