Start a conversation

How do I import a roster into the AlertFind system?

Overview

When you need to process a roster, AlertFind provides the Automated Roster Import Tool to enable you to import rosters of User, Team, and Site data into your AlertFind system.

Prerequisites

  1. You are an Admin 
  2. The file format must be in .csv (comma-delimited) using UTF-8 encoding (not UTF-8 BOM), then the file must be compressed into a .zip container
  3. The filename must match exactly the name used in the last import
    1. Click Setting > Data Management
    2. Click Configure to see the file name used in the last import. Use this same file name.
  4. The file structure should match certain criteria, for further clarification on this, please check this article:  "Unexpected error occurred while importing file." in AlertFind The file name and headers are set by the onboarding team, then hardcoded into Python - changes require programming changes

Important note:
Only the last committed roster can be backed up. In the event that a roster is uploaded and committed with errors that need to be fixed, the previous roster will need to be restored prior to committing a new roster. Otherwise, the "last backup" will be the roster with bad data.

Example: 

  • There is a roster with good data in the AlertFind system (version 1). 
  • A new uploaded roster (version 2) is committed and one realizes it contains bad data. 
  • If a roster is uploaded and committed with fixed data (version 3), the "last version" is not version 1, but is version 2. 
  • To restore from version 3 to version 1 will require assistance from Support.

Solution

  1. Log in as an Admin to AlertFind
    List of Alertfind UI URLs:
  2. In the left pane, click on Application Settings

    User-added image

  3. In the right pane, scroll down to Data Management Settings and click Import.

    User-added image

  4. Click on Choose File and pick the .zip or .tgz file that contains your source file and click Open.

  5. In Notification Emails enter your email address.

  6. Click OK to generate a “simulated import”, meaning any changes are not committed to the database but can be reviewed in the resulting log file for errors before committing the changes.
    User-added image

  7. Check your email and you will receive a message containing two file links, as well as the text showing what will be changed. To use the links in the email: first log into AlertFind, and then copy/paste the links from the email, into your AlertFind window address bar and the results will be displayed.
    User-added image

    IMPORTANT: Proceed to the next step ONLY after you have validated that the changes that are shown are what you want to import into your production data. If you are still facing errors during the simulation step, please check the following article:  "Unexpected error occurred while importing file." in AlertFind

  8. In the right pane, scroll down to Data Management Settings and click Import.
    User-added image

  9. Click on Choose File and pick the .zip or .tgz file that contains your source file and click Open.

  10. Select the Commit check box (Take Auto Backup will be automatically checked)

  11. In Notification Emails enter your email address

  12. Click the Save button
    User-added image

Your roster has now been imported. Check your email for links to the log file.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Priyanka Bhotika

  2. Posted
  3. Updated

Comments