A few months ago I batch uploaded a couple of hundred records from a spreadsheet. As far as I was aware the data went in fine.
Today I see that the records were all assigned the date 16/07/1905. I still have the spreadsheet, so I went back and checked, to find that (to save time I presume) I had given them all the date 2024. They were fairly low-value records from my perspective, mostly of common species which I figured might be useful for filling in monad distributions in an area which had no data at all, so I didn't think it was worth recording the exact date for each.
Now I face the task of correcting them all. iRecord has batched them based on grid refs I assume, so every one I edit might fix a few extra ones recorded at the same location, which is useful.
It would have been better all round if the system had rejected them all at the upload stage, telling me that the date was incorrect (that would have been an easy fix). That isn't what happened though.
Just thought I should let people know.
Comments
iRecord importer termlists for vague dates
The correct way of doing this from a spreadsheet is detailed at the bottom of this page: https://irecord.org.uk/help/import-termlists
However, it is perfectly reasonable to expect that some sensible error message be thrown when the spreadsheet does not conform. I have added this to our issue tracker: https://github.com/BiologicalRecordsCentre/iRecord/issues/1819
I'm not sure if this would work with a spreadsheet upload as I've not done that, but tucked away in the user settings, under edit then right at the bottom is a section on vague dates. It has a default to normal page settings ticked as standard, but you can change it to allow vague dates or never allow vague dates. Perhaps selecting the allow vague dates would prevent this happening in the future (still worth flagging here though as most people might not be aware of that setting).