Import/Exporting Users

The import users feature was added in v1.3.

Importing new users

Importing users will allow multiple users to be added to ResourceXpress quickly, this is done using a CSV file, and a sample file can be downloaded from the Import screen.

To Import users navigate to the Users List screen, this can be found under the header User Management → Users, then choose +Import.

Download Sample

Click on Sample File to download a sample CSV file to edit and upload.

The CSV file can be modified using Excel, fill in the information under the appropriate columns then save the file, keeping the CSV format.

CSV Columns

FirstName* & LastName

The FirstName* and LastName column will determine how a user is displayed throughout the system, in most locations the user's name will be displayed as FirstName LastName, using the first row from the example above, when this user creates bookings their name will be displayed as John Smith.

UserName* & AliasName

The UserName* and AliasName are additional fields.

EmailId*

The EmailId* is the user's email address, this is used to send notification emails as well as allow the user to sign into ResourceXpress.

FirstName, UserName and EmailId are required.

MobileNo

The user's cell/mobile number.

This number is not used in the system and is only visible to RX accounts with User Management rights.

AccessCode & RFId

An AccessCode would typically be a 4-6 digit number that users can use on RX devices such as Room Screens, Kiosks and Maps to quickly authenticate bookings.

The RFId value is the value from a user's RFID access card. Certain devices support NFC/RFID readers such as the Aura-X Room Screen or Qubi.
Users can quickly authenticate using their card instead of typing their username & password or AccessCode.

UserRole

By default, all users will be assigned the role User, however other roles can be assigned, see the Roles guide for more information about this, Roles.

When assigning roles, via the Import feature, use the Role Name.
To assign multiple roles, use the hash/pound (#) symbol to separate each value.

DefaultLocation

DefaultLocation is used to provide a user with the relevant resource for their location. It does not restrict users to only those selected but applies editable filters automatically.
This will also be used for loading the most relevant Kiosk for a user when accessing the Kiosk URL without an ID number.

BookableLocations & ViewOnlyLocations v2022.1

Adding a location to BookableLocations will allow the user to view and create bookings in this location.

ViewOnlyLocations work in conjunction with Bookable Locations.
Adding a location to Viewable Locations will allow the user view-only access to resources in these locations. They will not have access to create bookings.


For DefaultLocations, BookableLocations and ViewOnlyLocations the ID number(s) for the required locations will be needed, these ID numbers can be found from the Location edit screen.

Navigate to Administration Settings → System Settings → Locations (tab) then click the edit icon () for the required location, the ID number will be shown in the URL.

AllowedLocations Deprecated

This options works in a similar way to BookableLocations

Default Calendar View

This value will determine the default view a user has when accessing Booking Manager.

See below for how each view will look.

Day

Week

Month

My Booking Colour

The MyBookingColour column accepts a hex code, this allows for a unique colour to be assigned to that user when viewing their bookings in the Booking Manager.

Only the assigned user will see this unique colour to help differentiate their bookings from all others.

Online tools such as https://htmlcolorcodes.com/ can be used to help get the correct HEX code required.

Date Format

The Date Format will determine how users will see all date formats via the Admin Dashboard or Booking Manager.

6 available format options can be used;

Format Options

Example

Format Options

Example

dd-mm-yyyy

01-12-2020

dd/mm/yyyy

01/12/2020

mm-dd-yyyy

12-01-2020

mm/dd/yyyy

12/01/2020

yyyy-mm-dd

2020-12-01

yyyy/mm/dd

2020/12/01

Assigned Profiles

Assigned Profile is an optional setting that allows a workspace to be assigned to a user by default.

If a user has an assigned profile the profile ID value will be required, this value can be found in the first column of the Resource List view.

A user can only have one Profile assigned to them, therefore, only a single value is accepted in this column.

Import

After updating the spreadsheet, return to ResourceXpress, click on Choose File and select the updated CSV file, click Preview to check the data is correct.

Click Upload to add the new users.

Exporting & Updating Users

Selecting the Export button will download a CSV file of all existing users, this CSV file will be similar to the Sample file as detailed above.

To update users you can use the Export users feature, then follow the steps as above, using the Import feature selecting your exported users data file. Any new users will be created and any changes to existing users will also be made.

The following macros are not currently supported in the footer:
  • style