aodn / imos-toolbox

Graphical tool for QC'ing and NetCDF'ing oceanographic datasets
GNU General Public License v3.0
46 stars 31 forks source link

Validate DB entries #645

Open ocehugo opened 4 years ago

ocehugo commented 4 years ago

A common issue with users is unrecognizable errors in the toolbox when some database entry is wrong.

The pain point here is that the toolbox debugging msg is, most of the time, unclear for those cases. Moreover, it's daunting to detect this kind of problems in large/lot of csv files. As the DB field size increases, so does the chance of errors and failure because of a single entry.

We should try to validate the entry(ies) at read time, and provide a more useful error message.