Skip to main content

Search

Knowledge Center

Importing Hydrants

Purpose

  1. The purpose of this article is to explain how to import NEW hydrants into your First Due account.

Important: If you are using an ArcGIS hydrant layer from your water company (or other source) AND rely on that source exclusively for hydrant data, you will not need to add your hydrants directly within the First Due Hydrant Module. New hydrants will appear as they are added to ArcGIS file by your water company (or other source).

Background Information

The Hydrant Uploads page provides two ways to import hydrant records:

  • Import Hydrants uploads a CSV file using the standard import process. A sample file is available for this method.
  • Hydrants Import Wizard lets you select how to handle duplicates and map CSV columns to First Due fields before importing. The wizard does not provide a sample file download.

The uploads list shows the total number of records, the number processed, the number imported, and who initiated the upload. You can expand an upload to access its file and review errors.

Step-by-Step Guide

Access Hydrant Uploads

  1. Open the module stack, select Hydrants, and then select Hydrant Uploads.

  2. Review the uploads list, which includes pending and completed uploads. You can search the list and move between pages when there are multiple uploads.

Method 1: Import Hydrants

  1. Click Import Hydrants.

  2. Select a CSV file to upload. If you do not have a file prepared, download the sample spreadsheet and use its column headers as a guide.

  3. Click Upload.

  4. Return to the uploads list and review the record counts, including how many were processed and imported.

     

Method 2: Hydrants Import Wizard

  1. Click Hydrants Import Wizard.

  2. Choose your CSV file. The wizard does not include a sample file download.
  3. Select how to handle duplicate records:
    • Skip: Do not import a duplicate record.
    • Overwrite: Replace data for an existing duplicate hydrant. Caution: this can cause existing hydrant data to be lost.
    • Clone: Create a separate record for a duplicate.

  4. Choose how duplicates are identified: Hydrant ID or [CONFLICT C1: The new transcript says First Due ID; the older article says Xref ID. Confirm the label displayed in the wizard.].

  5. Click Next.

  6. Match the columns in your CSV file to their destination fields in First Due. Hydrant ID is the only field identified as required on this mapping screen.

  7. Click Next and review the mapping summary.

  8. After verifying the selections, click Import.

Correct Import Errors

  1. In Hydrant Uploads, locate an upload whose imported count is lower than its processed count.

  2. Expand the upload using the arrow on the right, then click Download to review the file and associated errors.

  3. Open the downloaded spreadsheet and review the error information. Examples shown in the training include duplicate Hydrant ID or Xref values, a blank type, and missing latitude or longitude values.

  4. Correct the reported issues in the import data, then upload the corrected file again using the applicable import method.
  5. Review the processed and imported counts again. If records still fail, repeat the error review and correction process.

Expected Result

The Hydrant Uploads list reports how many records were processed and successfully imported. When the imported count is lower than expected, use the download option to inspect and correct errors before trying again.