Feat 85: validate & format datetime in xlsx job template

AllenNeuralDynamics / aind-data-transfer-service

FastAPI service to run data compression and transfer jobs on the hpc

MIT License

1 stars 0 forks source link

Closed helen-m-lin closed 5 months ago

helen-m-lin commented 5 months ago

closes #85

Add data validator for acq_datetime column to check input is valid date
Enforce excel to format and save dates in ISO datetime format (yyyy-mm-dd hh:mm:ss)
Update unit tests and add new test for files with empty rows (Excel saves formatted blank cells as empty rows)