biocodellc / geome-ui

MIT License
3 stars 4 forks source link

Corrupt .png photo files manually removed; still appear in expedition data and prevent data validation #624

Open tweedts opened 9 months ago

tweedts commented 9 months ago

I mistakenly uploaded a number of .png files instead of .jpgs for event photos in expedition PC2202L1. This resulted in corrupt photo files in the expedition.

When I download the expedition data workbook, these images appear in the eventPhotos tab with the following characteristics:

When I attempt to update sample data for this expedition by loading the entire workbook, the 'validation only' step clears without any errors. But continuing on, attempting to actually load the data fails validation and returns error "Missing Photo File". Updating data is possible by removing the eventPhotos tab from the workbook entirely and loading data that way.

I supplied a list of these event photos (PC2202L1_problemImages.csv) and they were manually removed by John. However, upon re-downloading this expedition data, these corrupt and missing event photos are still listed in the eventPhotos data with fields exactly as above. I am unable to load expedition data corrections by uploading the whole workbook, and get the same Missing Photo File error:

Screen Shot 2024-02-12 at 5 49 14 PM

It appears that these did not successfully get stripped from the database? If we can get this sorted I can re-load the same images as .jpg files.