Importing Hydrants
Purpose
- 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.
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.
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.
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.
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.
9. 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.
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.
2. 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.
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 ...Equipment: Importing Equipment Via a csv File
Purpose To provide instructions for importing multiple pieces of equipment using a .csv File. Video Directions Navigate to Assets > Equipment List. Select Import CSV. Select Download sample spreadsheet (import template also attached below). Begin ...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 ...Adding ArcGIS Hydrants
Purpose To explain how to add ArcGIS Hydrants Video Directions 1. Click on Hydrants> ArcGIS Hydrants. 2. Click on New ArcGIS Hydrant Sync. 3. Here you will type in the Service URL that you received from your local GIS department. When done, select ...Adding Individual Hydrants
Purpose The purpose of this article is to explain how to add individual hydrants to 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 ...