Create users with a spreadsheet

Setup spreadsheets save time and let you create multiple items at once.

The menu displays spreadsheets matching your permissions.
Always download a new spreadsheet before you begin adding data because the spreadsheet is populated with information from your database.
To avoid errors when creating different objects refer to the required upload order.
To save time when creating many objects, select from the drop-down menu and then copy and paste the value into the other rows.

Format rules

Enter all information as text or dates.
You can add sheets to the notebook, UtilityManagement only processes the sheet named DataEntry.
Do not rename, remove, or rearrange columns.

Download the spreadsheet

You can find all the spreadsheets to manage users and user groups on the Users and Roles page or on the Setup Spreadsheet Log page.

On the Users and Roles page

Click the Excel icon.
Under the Download section, choose Create User Spreadsheet.
Download the spreadsheet.
The name format is yyyymmdd-CREATE_User.xlsx.
Add your information and save.
Use the Excel icon to upload your spreadsheet.
The Setup Spreadsheet Log reports the results and any errors. You can download the kickout (errors) spreadsheet from the hyperlink, fix any errors, and upload the error sheet.

*Not available to Pro and Express users.

Permissions

The ability to create objects is determined by user role and any limits placed on the user's topmost place or topmost cost center.

Maximum length for codes and names

The column header lists the maximum length for each attribute. When entering data, a red cell indicates the name or code exceeding the specified length. If you upload the spreadsheet without fixing the cell, the row fails to process and an error spreadsheet is created.

Create users spreadsheet details

Column	Rules
User Name	User credentials for logging into UtilityManagement.
Full Name	Enter the full name of the user.
Email	Email address of the user.
User Role	Choose a role for the user.
Temporary Password	Enter a temporary password for the user. The user changes the password on first log in.
Limit Place Access	Optional. Choose the topmost place for user access, if left blank defaults to the topmost place of the creating user. This selection limits the user's access to the buildings and meters tree. The user has access to the this level and below.
Limit Cost Center Access	Optional. Choose the topmost cost center for user access, if left blank defaults to the topmost access of the creating user. This selection limits the user's access in the accounts tree. The user has access to the designated cost center and below.
Recommended Reports Group	Choose from the drop-down.
Active	If blank defaults to yes.
Require Strong Password	If blank defaults to Require Strong Password. A strong password consists of a minimum of 8 characters, containing at least 1 uppercase, 1 lowercase, 1 number, and 1 symbol.
Days Until Password Expires	If blank the password doesn't expire. 1 to 999 days is a valid entry.
Maximum Bill Approval Amount	If blank no limit is set for the user.