Importing Hydrants

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).


Video 




Directions

1. Click on Hydrants> Hydrant Uploads.





2. Here we can see any:
  • Pending Uploads. 
  • Completed Uploads.





3. Click on Import Hydrants.


Click on Import Hydrants.


4. Here we can choose a .csv file and upload it. 
NOTE: If needed, you can download a sample .csv file and utilize it to put your information into. 


Here we can choose a .csv file and upload it.


5. You will be directed back to the landing page, and can determine the status of the upload in the # of processed/# of uploaded column. 





6. Click on Hydrants Import Wizard.


Click on Hydrants Import Wizard.


7. Here we have a easier way of uploading hydrant data. 
  • Choose the .csv file.
  • Determine what you want to do with Duplicate Records. You can
    • Skip the duplicate hydrant. 
    • Overwrite the duplicate hydrant. 
    • clone the duplicate hydrant. 
  • You can find duplicates by:
    • Hydrant id. 
    • Xref id. 
  • Click Next when done. 


Here we have a easier way of uploading hydrant data.


8. The next page determines how the fields will be mapped to their destination from the .csv file to the First Due platform. 
  • Each field can be associated with a specific column in the .csv file. 
NOTE: Only the Hydrant ID is required to be selected. 


The next page determines how the fields will be mapped to their destination from the .csv file to the First Due platform.


9. Click on next when you have associated the fields that you want to. 


Click on next when you have associated the fields that you want to.


10. You will now have to confirm the mapping from the .csv file to the destinations within First Due. If they look appropriate to you, select Import. 


You will now have to confirm  the mapping from the .csv file to the destinations within First Due. If they look appropriate to you, select Import.


11. You will be directed back to the landing page, and can determine the status of the upload in the # of processed/# of uploaded column. 






Correcting Errors 


1. To correct a upload that has not worked imported all hydrants, select the arrow to the right. 


To correct a upload that has not worked imported all hydrants, select the arrow to the right.



2. Click on Download.


Click on Download



3. Open the Excel Sheet, and scroll to the AH Vertical Column. 
  • Here you can see any errors that may be present. 
  • Correct the errors, and re-upload the file. 
  • You should now have the hydrants in the First Due system with no errors.  


Open the Excel Sheet, and scroll to the AH Vertical Column.

    • Related Articles

    • Inventory: Bulk Importing Inventory

      Purpose To provide instructions for importing multiple pieces of inventory using the inventory import template. The Sample CSV template is attached to the bottom of this article. Video Directions 1. Navigate to Assets > Inventory List. 2. Select the ...
    • Getting Started Guide – Hydrants

      Getting Started Guide – Hydrants – Purpose: This guide is designed to assist in setting up First Due accounts. This Guide contains articles that cover Set Up, Training Personnel, Helpful Articles, and Tips and Best Practices. Helpful articles for set ...
    • Hydrants 301

      First Due Academy: Hydrants 301 Hydrants 301 This training session focuses on First Due's Hydrant Module functionality and processes. In 101 level sessions we review fundamental module navigation, demonstrate common use cases, offer product tips, and ...
    • Hydrants 101

      First Due Academy: Hydrants 101 Hydrants 101 This training session focuses on First Due's Hydrant Module functionality and processes. In 101 level sessions we review fundamental module navigation, demonstrate common use cases, offer product tips, and ...
    • Pre-plans & Hydrants

      Product Roadmap Webinar Series -Pre-plans & Hydrants 2024