Home › Forums › Users › General User's Discussion ›

Attaching large files within OpenVPMS

Submitted by bellvet on Fri, 04/12/2009 - 14:08
in

Hi,

Our receptionist has just tried to attach a scanned copy of a patients medical records to it's file. This is often done when clients move from one clinic to another and bring a copy of their records with them.

Today the file was quite large, 17 pages of hx and path results were scanned, and would not attach to the file as it was too large (see screen shot attached of error received). In the past we've broken the hx up and scanned it in several sections and then attached each section to the file. This takes time and I notice in the error it says: "Packet for query is too large (30148682 > 16776192). You can change this value on the server by setting the max_allowed_packet' variable."

How do I change this value, and if I change it does it affect any other areas in the system?

Sandra.

‹ Patient weight on charges page Getting a desktop experience with OpenVPMS using prism. ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Attaching large files within OpenVPMS

Submitted by Tony De Keizer (not verified) on Fri, 04/12/2009 - 15:00.
Hi Sandra,This is actually a Mysql confguration issue and your integrator can change the value in Mysql to allow queries containing large amounts of data to work.   I would say though that an approx 30M compressed file (OpenVPMS compresses documents before it stores them and uncompress's them when you access them) is, in my opinion, very large for a 17 page scanned document.  It would indicate that the scanning is being done at a very high resolution and colour settings.  Did you scan the document yourself or receive the file somehow ? If the former I would have a good look at your scanning settings as I believe you may be wasting a lot of storage space for little benefit in the end result for this type of information  ...CheersTony

On Fri, Dec 4, 2009 at 2:08 PM, <sandra@bellvet.com.au> wrote:
Hi, Our receptionist has just tried to attach a scanned copy of a patients medical records to it's file. This is often done when clients move from one clinic to another and bring a copy of their records with them.   Today the file was quite large, 17 pages of hx and path results were scanned, and would not attach to the file as it was too large (see screen shot attached of error received).  In the past we've broken the hx up and scanned it in several sections and then attached each section to the file.  This takes time and I notice in the error it says:  "Packet for query is too large (30148682 > 16776192). You can change this value on the server by setting the max_allowed_packet' variable."

How do I change this value, and if I change it does it affect any other areas in the system? Sandra. File attachments: [attach doc error 4th Dec 09.doc]: //www.openvpms.org/fileuploads/attach%20doc%20error%204th%20Dec%2009.doc" target="_blank">http://www.openvpms.org/fileuploads/attach%20doc%20error%204th%20Dec%2009.doc ---------- Original attachments can be found at: //www.openvpms.org/node/1063" target="_blank">http://www.openvpms.org/node/1063 _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: //lists.openvpms.org/listinfo/users" target="_blank">http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- //tinyurl.com/openvfu" target="_blank">http://tinyurl.com/openvfu

Scanning settings

Submitted by Matt C on Mon, 07/12/2009 - 17:23.

We tend to scan at 150dpi into pdfs. It is probably overkill to be honest. 17 pages pending on type of content would equate to about 7MB uncompressed.

Matt C

Syndicate content