Importing Nemsis Licensure/Certification

Importing Nemsis Licensure/Certification

Purpose Statement

  1. The purpose of this article is to guide users through the process of importing personnel NEMSIS Licensure/Certification data using the Import Wizard in the Admin module.

Background Information

  1. Importing personnel licensure and certification records in bulk ensures data consistency and saves time when updating or onboarding staff. This process requires the use of a CSV file and allows mapping up to 28 data fields.
Prerequisites
  • Admin-level access
  • CSV file ready or use of the sample spreadsheet template
  • CSV file must not exceed 64 MB

Step-by-Step Guide


Step 1: Access the Import Wizard
  • Navigate to the Admin module.
  • Select Import Wizard from the available options.


Begin by navigating to Admin module and selecting the Import Wizard.



Step 2: Select the Import Table
  • From the Import Type dropdown, choose Personnel - NEMSIS Licensure/Certification.
  • Click Next.


Select Your Table



Step 3: Upload the CSV File
  • Click Browse File to upload your CSV.
  • If you don’t have a file ready, download the Sample Spreadsheet, enter data in the specified columns, and save as CSV.
InfoNote: Max file size is 64 MB.


Upload File



Step 4: Review File Upload
  • Once uploaded, you can remove the file using the X icon if needed.
  • Review file size and details.
  • Click Next when ready.


Once file is uploaded



Step 5: Choose Import Type
  • Choose one of the following:
    • Add New Rows
    • Update Existing Rows
    • Add or Update Rows
  • Click Next.


Choose Import Type



Step 6: Map Fields
  • Use the dropdowns under Fields in your uploaded file to map up to 28 fields.
  • If using the sample spreadsheet, fields should map automatically.
  • Click Next after completing the field mapping.


Map Field



Step 7: Import and Review Results
  • View the number of rows successfully imported.
  • If there are errors:
    • Click Download to view the error report.
    • The final column in the spreadsheet will show reasons for any failed imports.
  • If all rows are correct or have been resolved, click Finish.


Import

Best Practices

  • Always start with the sample template to ensure proper formatting.
  • Use descriptive names for saved import files.
  • Double-check data accuracy before importing.
  • Validate that certifications match agency requirements.

Troubleshooting & FAQs

What if my file is over 64 MB?
  1. Split the file into smaller segments and import separately.
Why can’t I map a specific field?
  1. Ensure the column header in your CSV matches expected values. Use the sample spreadsheet as a reference.
How can I fix import errors?
  1. Download the error report after import, review the "Error" column, fix the indicated issues, and re-import the corrected file.

    • Related Articles

    • Personnel Record: NEMSIS Tab

      Purpose Statement The NEMSIS (National Emergency Medical Services Information System) tab in personnel records allows departments to document and maintain comprehensive EMS certification and licensing data for each individual. This feature ensures ...

    • EMS Setup - Certification Levels

      Purpose Statement This article demonstrates how to set a user's EMS certification level in order to make the user available for ePCR documentation and ensure NEMSIS compliance requirements are met. Background Information EMS certification levels are ...

    • v_personnel_nemsis_licensure

      Purpose Personnel NEMSIS licensure records. Relationships v_personnel_nemsis: Many-to-One (N:1) Many licenses link to one NEMSIS record Referenced through personnel_nemsis_id v_personnel: Many-to-One (N:1) Many licenses link to one personnel ...

    • v_personnel_nemsis

      Purpose Personnel NEMSIS certification details. Relationships v_personnel: Many-to-One (N:1) Many NEMSIS records link to one personnel Referenced through personnel_id v_personnel_nemsis_licensure: One-to-Many (1:N) One NEMSIS record can have many ...

    • Inventory: Bulk Importing Inventory

      Purpose To provide instructions for importing multiple items of inventory using the inventory import template. The Sample CSV template is attached to the bottom of this article. The MOST recent CSV Spreadsheet is always available for download from ...