Adding more than one visitor to the IBSS system at a time is enabled in OneLens on the Visitor List page for the operational users who have corresponding role permissions. If they do, they see the Import button on the Visitor List page.
To add more than one visitor at a time, you need:
- Role permissions to have the Import button enabled.
- Correct XLSX file with visitor details for import.
File preparation
To prepare the XLSX file with visitor details, do the following:
- Create a new spreadsheet file and add the following column headers in this defined order. Ensure that there are no typos in the column names:
Visit_Id
Visit_Start_Date
Visit_End_Date
Visit_Host_Email
Visit_Host_Name
Visitor_Email
Visitor_First_Name
Visitor_Last_Name
Visitor_Company
Node_id
💾 Or download our template here.
- Ensure that there are no additional rows and that rows only include visitor details in the following format (see the scrolling table with the scrolling bar at the bottom of the page):
Visit_Id | Visit_Start_Date | Visit_End_Date | Visit_Host_Email | Visit_Host_Name | Visitor_Email | Visitor_First_Name | Visitor_Last_Name | Visitor_Company | Node_id |
---|---|---|---|---|---|---|---|---|---|
Leave blank | DD/MM/YYYY  hh:mm:ss | DD/MM/YYYY  hh:mm:ss |  |  |  |  |  |  |
Numeric value – ID of your building. |
- Save the file on your computer to be able to locate it during import.
File importing
To import the prepared visitor details, do the following:
- Visit OneLens > Visitors > Visitor List.
- Click Import. An Upload File popup opens.
- Click Select File. A popup opens where you select the prepared XLSX file with visitor details.
- Click Open in the File Open dialog.
- Click Ok to confirm file import.
- Click Ok to confirm the success message.
- Refresh the page to view visitors imported from the file and listed for the appropriate date ranges. If the visitor isn't listed, ensure that you are viewing the correct date range when the needed visit is scheduled for.