Upload or Attach a PDF file to a patient record - Like you can with JPG images

Submitted by skaatje-debian on Fri, 2007-08-10 14:45
::

Does anyone know if it is possible to upload and attach a PDF file to a patient record? I know you can add a scanned image under the Scanned Documents but it does not work with PDF files. It only will show the first page of the file.

If this is possible under which "Patient-Configure-Component" must you attach it with?

Submitted by skaatje-debian on Sat, 2007-09-15 18:00.

I would like to re-phrase my question I previously posted.

My situation is such that I wish to upload files (of all kinds) into the mysql database. I can see that in the "images" table it clearly will accept any type of binary file (therefore any document). I also see in the module "scanned_documents.emr.module.php" that it is coded to display the image - hence djvu plugin/usage.

What would be the best way to disable this feature (djvu-in this module) or add the functionality to upload and download files straight from the database.

Has anyone tried or succeeded in such a task?

Submitted by jeff on Sun, 2007-09-16 13:27.

Is there any reason why you would rather store large BLOBs in the database than in the data/store/ directory structure?

There's a class (lib/class.Djvu.php) to handle rendering of Djvu documents to JPEG images for the browser and to PDF for printing.

We had initially decided to use Djvu due to the space saving compared to TIFF or PDF storage of scanned documents. If you want to convert from PDF to Djvu, I recommend the Djvulibre suite, with djvudigital (which needs gsdjvu to function properly).

Jeff Buchbinder
Project Head
FreeMED Software Foundation, Inc
http://freemedsoftware.org/

Submitted by skaatje-debian on Tue, 2007-09-25 14:14.

(Reasoning) At the moment I have scanned .pdf files of all old patient files that I wished to upload and store to the database. (I like the djvu files for size in this case as you can imagine - so format for me is not an issue - I have the Djvulibre/gsdjvu suite as well). The data/store directory structure is fine if I can get it to work.

(How I got to where I am) I had tried uploading pdf files but noticed only the first page would display. Then I researched and saw the use of the djvu plugin. I converted a few documents (test docs-not patient files) at "http://any2djvu.djvuzone.org/" but when I uploaded the files into the database it gave me an error (the demo site gave the same errors)
"Djvu: file does not exist "img/store/93/48/15/ad/542a4a7c5e8a2dfa04fea9f5/558.djvu"

The problem is that I need multiple pages to be displayed (jpeg will not offer this - djvu will, but is not working for me). I have searched and tested numerous files and have only found one file on the demo site which offers multiple page viewing. I think this document might be the key to the problem.

It is located at (Fitch, Alfred Pat.833 - Scanned Document - 2007-01-18 - CBC and LFT's. Note low WBC )
http://www.freemed.info/module_loader.php?module=ScannedDocuments&patien...

If you need anymore information let me know.

Submitted by skaatje-debian on Tue, 2007-10-16 20:44.

By any chance have you had time to look into this?
I am most curious about what type of file was uploaded to create the multiple page viewer working.
Thanks.