Notifications
Clear all
Topic starter
I know this was asked at some time on the old CHUG. I stumbled across this when I was investigating a call where the user said pictures had disappeared out of registration. This is in EMR 9.5 but probably works for other versions.
The pictures are stored in the database as BLOBs (Binary Large Objects). Table is ml.person_pict. Two columns, PID and PICT. You can export the pictures out using Oracle's SQL Developer product.
In SQL Developer I had to change these settings:
Tools Preferences, Database, Export/View DDL Options, PDF Format, Column Layout
I set Binary Large Object Column to Link to BLOB Created in a Separate file
I ran a query to find the patient:
select pid, firstname, lastname from ml.person where medrecno is xxxxxx
Took the PID and queried the other table:
select * from ml.person_pict where pid = yyyyyyyyyyyyyyyyy (you could obviously join this table on the person table to return names, medical record number, etc.)
Then I highlighted the row returned (easiest way is to click a cell then CTRL-A), right-clicked a highlighted area and chose Export.
Changed the Format choice to PDF. Change the other fields as needed. Next then Finish. I ended up with a PDF and a new folder that had a .jpg file of the picture in Registration for that patient. Also works selecting multiple patients - creates a separate .jpg for each line.
Now, the .jpg file names aren't the PID number. You can open the .pdf file and click on the BLOB icon and you get a launch dialog that shows which file it wants to open.
Hope this helps someone sometime 
David Shower
OU Tulsa School of Community Medicine
Posted : July 13, 2012 5:40 am
DavidShower said:
I know this was asked at some time on the old CHUG. I stumbled across this when I was investigating a call where the user said pictures had disappeared out of registration. This is in EMR 9.5 but probably works for other versions.
The pictures are stored in the database as BLOBs (Binary Large Objects). Table is ml.person_pict. Two columns, PID and PICT. You can export the pictures out using Oracle's SQL Developer product.
In SQL Developer I had to change these settings:
Tools Preferences, Database, Export/View DDL Options, PDF Format, Column Layout
I set Binary Large Object Column to Link to BLOB Created in a Separate file
I ran a query to find the patient:
select pid, firstname, lastname from ml.person where medrecno is xxxxxx
Took the PID and queried the other table:
select * from ml.person_pict where pid = yyyyyyyyyyyyyyyyy (you could obviously join this table on the person table to return names, medical record number, etc.)
Then I highlighted the row returned (easiest way is to click a cell then CTRL-A), right-clicked a highlighted area and chose Export.
Changed the Format choice to PDF. Change the other fields as needed. Next then Finish. I ended up with a PDF and a new folder that had a .jpg file of the picture in Registration for that patient. Also works selecting multiple patients - creates a separate .jpg for each line.
Now, the .jpg file names aren't the PID number. You can open the .pdf file and click on the BLOB icon and you get a launch dialog that shows which file it wants to open.
Hope this helps someone sometime
David Shower
OU Tulsa School of Community Medicine
Thanks so much, David. We're on 9.5 SP2 as well. We'll give this a try.
David Bragg, MD
Baylor Health Care Systerm Dallas
Posted : August 10, 2012 12:21 am
We do not see a picture in EMR when we do not add it to registration. However, we do have a copy of the DL in the PM side to allow for ID verification.
Just a thought
Posted : August 13, 2012 3:39 am
Hi David,
I posted the photo capturing question. Can I get your email so I can contact you?
We are trying to use affinity cards.
I look forward to hearing from you.
Thanks
David Bragg
Baylor HealthCare
Dallas
Posted : November 29, 2012 1:56 am
