Import your badge reader data from an Excel spreadsheet
Import your badge reader data from an Excel spreadsheet into the Badge Access Register table.
Before you begin
Ensure that you have added all your user badge and badge reader data.
Role required: sn_imt_tracing.badge_manager
Procedure
Navigate to All > Contact Tracing > Badge Management > Badge Access Register.
Click Import Badge Data.
In the Scheduled Data Imports list, open Badge Access Register Scheduled Import.
Attach the Excel file and load data in the Import Set table.
- Click the preview icon (
Preview icon\) next to the **Data source** field, and then click **Open Record**.
2. On the Data Source form, click the manage attachments icon \(
Manage attachments icon\).
3. Click **Choose File** and select the source Excel file.
4. Click **Download All**.
The Excel file is attached to the data source record.
5. Click the **Load All Records** related link to load the Excel data.
The imported data is available in the new Import Set table, Badge Access Register Stage \[sn\_imt\_tracing\_badge\_access\_register\_stage\].
Click Execute Now.
The process runs in the background to load data from the Badge Access Register Stage table to the Badge Access Register table.
Note: Depending on the number of records in the source Excel file, it might take a longer time for the imported data to be available in the Badge Access Register table.
Verify that the data records were imported into the Badge Access Register table by navigating to Contact Tracing > Badge Management > Badge Access Register.
Parent Topic:Collecting user badge data
Related topics