search

BiologicalRecordsCentre / iRecord

Repository to store and track enhancements, issues and tasks regarding the iRecord website.
http://irecord.org.uk
2 stars 1 forks source link

Correct BBS data with wrong vice-county (database location ID lookup) #1758

Open sacrevert opened 2 weeks ago

sacrevert commented 2 weeks ago

Due to a configuration error with the 'Bryophytes (BBS)' survey type, some records were imported matching a supplied vice-number to the "vice-county database location ID" field. This has created some nonsense vice-county values held against some bryophyte records (I'm not sure of the exact field name, as a download puts them in a column named "Vice county2", presumably because of multiple columns having the same name.)

For the attached records, can we do two things please:

  1. Delete values in the "Vice county2" (== vice-county from database location ID) for these records
  2. Copy correct values from VC number to the (currently empty) Vice county (supplied) field Bryophyte records with vice county information given.csv
johnvanbreda commented 2 weeks ago

@sacrevert I've had a look at a few example records (e.g. https://irecord.org.uk/record-details?occurrence_id=38912241) but they seem to be stored correctly. Also in the download on iRecord the data looked OK. Where are you getting the download from that shows these problems?

sacrevert commented 2 weeks ago

@robin-hutchinson supplied it. Can you shed light Robin please?

robin-hutchinson commented 2 weeks ago

I'm getting the download from iRecord but I'm using the single survey download option?

sacrevert commented 6 days ago

@johnvanbreda I suppose there must be some incorrect values stored somewhere in the "vice-county from database location ID" field if they were loaded to it and available by a least one download route. Rather than replace them (that seems unnecessary given that the correct information is apparently in the correct fields elsewhere), perhaps we can just clear that field for the records attached here?