Open PipBrewer opened 1 year ago
Merging #152
merging #159
I would love a feature where a button-press would trigger the generation of a CSV file which then can be (manually?) copied to the N drive.
It would be a function that executes SQL: SELECT * FROM specimen WHERE recorddatetime = Now()
and writes the result to a file "Digitized_export_dd-MM-yyyy.csv"
Need to discuss what happens to exported records in db table
Effort required: 'Medium'
We need to move away from the assumption that digitized records will end up on the N drive. This is not future proof since there will be collections that do not have access to the N drive.
Create process to automatically send days MADD records to file and empty specimens records in database. At end of day, files are automatically uploaded to server and files deleted