search

bcgov / gwells

Groundwater Wells and Aquifers application for the Ministry of Environment
https://apps.nrs.gov.bc.ca/gwells/
Apache License 2.0
30 stars 36 forks source link

Bulk upload failed with an error message #2244

Closed QSu-2023 closed 5 months ago

QSu-2023 commented 5 months ago

One of our hydrogeologist was trying to do a bulk upload and got an error message. Would anyone be available to help her with this? Thanks! Please refer to the GWELLS Teams channel for details.

Error message:

The CSV data conflicts with existing vertical aquifer extents in the GWELLS database. You can resolve the conflicts by either:

  1. Editing the CSV and re-uploading it

  2. Click the well tag numbers below to editing the existing data.

Image

acatchpole commented 5 months ago

This is functioning as intended. When doing a Vertical Aquifer Extents Bulk Upload, an error is generated if a well being updated already has vertical aquifer extent data. If the new data is intended to override, the old data must be manually deleted. To do this, click on the well tag number of the wells with the error. That takes you to the manual 'Edit Vertical Aquifer Extents' page. Then:

  1. Remove the existing data
  2. Hit save Image

Once the existing data is removed, the bulk update will go through.

There is a second type of error found for this particular bulk update indicating that a WTN is present in more than one place. The .csv will need to be edited so that there is only one entry per WTN.

Per user feedback, a change could be made to allow overwriting existing data. Passed to SO to create and prioritize a ticket for that work.