Loading Staff via an Excel Spreadsheet

VisitorRego is able to load staff from an Excel spreadsheet. The process of loading staff from an Excel spreadsheet involves mapping database fields.

Excel must be installed on the machine in question to utilise this function.

1. From VisitorRego's Admin mode choose Options> Data Load> Load Staff from Excel.



The Staff Load from Excel Spreadsheet window will open allowing you to select the file and map the columns in the spreadsheet to the fields in the VisitorRego database.

2. Click the three dot button  to select the Excel spreadsheet file to open.

3. Enter the row number of the column names. This will be the row number where the column names are listed (e.g. Name, Mobile, Email).

4. Click the database drop-down fields to the right of each of the column names from the Excel spreadsheet, then select the database field that they should be mapped to.

5. Once all of the fields are mapped, click the Load Staff From Excel button to load all staff from the Excel spreadsheet.

• Related Articles

• Loading staff Manually via Staff

  Staff details can be added and maintained in many different ways depending on how your VisitorRego unit is set up. The following knowledge base article provides instructions on how to add new staff, edit existing staff and delete staff directly ...

• Loading Staff from Active Directory - AD Quick Load

  As many companies have a large number of staff, loading them individually is an impractical task. To mitigate this, VisitorRego can pull the staff list from an Active Directory to populate the staff list. The instructions in this article guide you to ...

• An Overview of Loading Staff

  When a person signs in, they specify the staff member they are meeting with. Following registration, notifications can be sent to the designated staff member via email, text message (SMS), or a combination of both, informing the staff member that the ...

• Staff List

  Staff details can be added and maintained in many different ways depending on how your VisitorRego unit is set up. The following knowledge base article looks at the Staff List page in VR Portal and provides instructions on how to add new staff, edit ...

• Loading Staff from Active Directory – AD PowerShell script

  Active Directory and LDAP can be leveraged to enable automated importation of a staff list into VisitorRego. Active Directory integration is intended for a system administrator or IT specialist to set up. Knowledge of how your Active Directory is ...