Import your Wi-Fi access logs spreadsheet

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • Import Wi-Fi access logs from an Excel spreadsheet into the Wi-Fi Access Register table.

    Before you begin

    Role required: sn_imt_tracing.wifi_manager

    Procedure

    1. Navigate to All > Contact Tracing > Wi-Fi Access Management > Wi-Fi Access Register.
    2. Click Import Wi-Fi Access Data.
    3. In the Scheduled Data Imports list, open Wi-Fi Access Register Scheduled Import.
    4. In the Data Source field, open the Wi-Fi Access Register Data Source record.
      1. Click the manage attachments icon (Manage attachments icon).
      2. Click Choose File and select the source Excel file.
      3. Click the Load All Records related link to load the Excel data.
    5. Navigate to Scheduled Import record.
    6. Click Execute Now.
      The process runs in the background to load data from the Wi-Fi Access Register Stage table to the Wi-Fi Access Register table.
      Note:
      The number of records in the source Excel file affect the time needed before the imported data is available in the Wi-Fi Access Register table.
    7. Optional: Verify that the data records were imported into the Wi-Fi Access Register table by navigating to Contact Tracing > Wi-Fi Access Management > Wi-Fi Access Register.