Upload Metadata and Data Values

Standard uploading is broken up into two processes: (1) upload metadata files (2) upload data values files. The process is identical for both metadata and data value uploading but it is important that you first upload metadata before moving on to data values.

• New: Valid records ready to be committed to the database.
• Rejected: Records that could not be validated by the application.
• Updated: Records that have been updated because the uploaded record had a previously used key with other, changed metadata that are ready to be committed to the database.
• Duplicate: Records that are a complete match of records that have been previously committed to the database.

Note: The HydroServer Uploader reports on and does not insert duplicate metadata, however the HydroServer does not report on duplicate data values. Instead, all valid data values are inserted and duplicates are checked for and removed automatically on a weekly basis. This process helps to increase the speed of the upload.

Once you have loaded valid files and continued to the inserting process, an upload summary will appear with information on the metadata or data values you inserted. An example of the Upload Summary table is shown below. Notice there are 3 records that have been rejected in the Sites table and 2 records in the methods table.

To edit the rejected records click on the rejected column. A pop up window will appear with a red drop down arrow that allows you to edit the row. Click on the red arrow to view information on why the record was rejected. In this example, the LatLongDatumSRSName is empty. Click to select the cell under LatLongDatumSRSName, to enter the correct LatLongDatumSRSName as shown below. This example shows the correct LatLongDatumSRSName as WGS84. Re-upload after correcting rejected records.

Alternately, you may decide to click Download to correct the errors in Excel before re-Uploading. Once the data has been re-uploaded, the Upload Summary should reflect the corrections and show the increased number of Inserted records. Click Finish to navigate back to the HydroServer Homepage and continue to upload Data Values.