Need feedback from Product on how to handle real world csv errors #522

oco well-inventory-csv tests/features/data/well-inventory-real-user-entered-data.csv
[WELL INVENTORY IMPORT] COMPLETED WITH ISSUES
========================================================================
SUMMARY
  ---------------------------
  processed        |      129
  imported         |        0
  rows_with_issues |      129

VALIDATION
Validation errors: 607
Most common validation errors:
   # | field                        | count | error
  ------------------------------------------------------------------------------------------------------------------------------------------------
   1 | mp_height                    |   112 | Input should be a valid number, unable to parse string as a number
   2 | elevation_method             |   103 | Input should be 'Altimeter', 'Differentially corrected GPS', 'Survey-grade GPS', 'Global...
   3 | elevation_ft                 |    99 | Input should be a valid number, unable to parse string as a number
   4 | monitoring_frequency         |    82 | Input should be 'Monthly', 'Bimonthly', 'Bimonthly reported', 'Quarterly', 'Biannual', 'Annual',...
   5 | depth_to_water_ft            |    68 | Input should be a valid number, unable to parse string as a number

  Row 1 (8 issues)
    1. utm_easting: Input should be a valid number, unable to parse string as a number
       input:
    2. utm_northing: Input should be a valid number, unable to parse string as a number
       input:
    3. elevation_ft: Input should be a valid number, unable to parse string as a number
       input:
    4. elevation_method: Input should be 'Altimeter', 'Differentially corrected GPS', 'Survey-grade GPS', 'Global positioning system (GPS)', 'LiDAR DEM', 'Level or other survey method', 'Interpolated
                         from topographic map', 'Interpolated from digital elevation model (DEM)', 'Reported', 'Survey-grade Global Navigation Satellite Sys, Lvl1', 'USGS National Elevation Dataset
                         (NED)' or 'Unknown'
       input:
    5. measuring_point_height_ft: Input should be a valid number, unable to parse string as a number
       input:
    6. monitoring_frequency: Input should be 'Monthly', 'Bimonthly', 'Bimonthly reported', 'Quarterly', 'Biannual', 'Annual', 'Decadal' or 'Event-based'
       input: Monitoring complete
    7. mp_height: Input should be a valid number, unable to parse string as a number
       input:
    8. depth_to_water_ft: Input should be a valid number, unable to parse string as a number
       input:

  --------------------------------------------------------
  Row 2 (4 issues)
    1. elevation_ft: Input should be a valid number, unable to parse string as a number
       input:
    2. elevation_method: Input should be 'Altimeter', 'Differentially corrected GPS', 'Survey-grade GPS', 'Global positioning system (GPS)', 'LiDAR DEM', 'Level or other survey method', 'Interpolated
                         from topographic map', 'Interpolated from digital elevation model (DEM)', 'Reported', 'Survey-grade Global Navigation Satellite Sys, Lvl1', 'USGS National Elevation Dataset
                         (NED)' or 'Unknown'
       input:

... and 597 more validation errors
========================================================================