Open bpasquer opened 6 months ago
Toni reported after testing the ingest of 2022 RLS MPA TEMPLATE WITH INVERT SIZE AND ALGAE_SA (email 2024-05-23) that the current software version does not have the issue. Because the original error cannot be replicated, investigating the cause is not possible. Nonetheless, I think it could be beneficial to verify whether sheets ingested with the same version of the software have also been affected. I propose we discuss the method for conducting this check (manual or automated;values/fields to check) once the list is established
A manual check was done on a couple of sheets ingested at the same period by Toni, to see if data has been omitted from the ingest After our discussions during the catch-up on 06/06/2024, it was acknowledged that implementing a solution to automate the check is complex. This would involve comparing rows in the original datasheet with records in the database and reporting on the differences. Given that we can assume the issue has been resolved, it is not considered worthwhile to invest further effort into this.
An enhancement to the ingested sheet summary report was proposed: to include the number of rows that were not ingested (i.e., the difference between staged and ingested rows).
Opening an issue to further investigate problem raised in email by Lizzi (email 2024-04-10) regarding Job 138 (2022 RLS MPA TEMPLATE WITH INVERT SIZE AND ALGAE_SA_Amended JB.xlsx):
2022 RLS MPA TEMPLATE WITH INVERT SIZE AND ALGAE_SA_Amended JB_Missing highlighted.xlsx