Is there a way the uploaded pdf documents can just stay on a filesystem that is permission secured, and that a reference to the pdf file is added onto the mysql database ? Instead, currently, uploading the file onto OpenEMR adds the file onto the mysql database as a static blob which causes the database to increase (in one instance 11MB per patient for a scanned pdf chart) in size which is bad for mysql backups.
I need to archive all of the patient’s paper chart onto OpenEMR. Our idea is to enter important information only for a patient with a future appointment and then pdf scan all of the patient’s information and upload onto OpenEMR.
OpenEMR does not by store documents in mysql as static blobs. It only posts a single entry into a table with a link to location on the disk, typically openemr/sites/default/documents//document_name.ext
The built in backups, will include the document stored in the path.
There have been people that have modified OpenEMR to store the documents in MySQL, but that is not how it ships by default.