New event code configurations can be imported in bulk via an Excel spreadsheet. To import event codes, navigate to Configuration > Event Code on the left side menu and click the “Bulk import” button at the top of the event codes screen.

When the user clicks Bulk import, a new tab opens and the Download Template button is displayed on the top right of the screen. Users can use populate this template with all the needed event code information and then import the Event Codes using the Import event codes button.

The template has a “ReadMe” tab that includes instructions and descriptions of the required data.

After populating the template, click the Import event codes button; this opens a new tab. Click the Import codes button.

The user is guided through four steps.

Step 1: Choose a file – navigate to the .csv file and choose it.

Step 2: Map fields – allows users to view and validate existing mapping from the .csv file to SCE. Modifications to the imported mapping may be performed during this step..

Step 3: Import options – users can name the Event code upload case and begin the validation process.

Step 4: Validate and review – SCE runs all the validations and systematically presents the following:

• Start time: Time the validation process began.
• Running time: Total time the validation process ran.
• Valid rows: Total rows in the uploaded excel sheet which are valid and have passed all the validations
• Invalid rows: Total rows in the uploaded excel sheet which are invalid and did not pass all the validations.

Records with errors are highlighted along with the description of the errors.

Users can choose to correct the errors and reload the event codes or continue the import process. If the user chooses to continue, the system presents a summary of the event code bulk import.

The following statistics are seen:

• Number of rows in file: This number would show the total number of rows in the file which were processed.
• Number of valid rows: This number would show the total number of valid rows in the file.
• Number of invalid rows: This number would show the total number of valid rows in the file.
• Number of codes imported: This number would show the total number of event codes loaded.