Thanks
The reports are nicely formatted in FMP6 so they can be printed out or
faxed.
I would like to preserve the formatting as is, and import the reports
as images into the new EMR.
All these EMRs allow one to scan images into them, so I thought that
would work.
The trick is to how to identify each image with its patient number,
date, and report type, so they get put away in the right place.
As it turns out, my idea to store the reports as images in container
fields may not work, since you can't export container fields in FMP6
or in FMP8.
The EMR software will read SQL files, but I have no idea how to get
the images and the key fields from FMP6 into that format.
On Oct 14, 2012, at 9:02 PM, John Weinshel wrote:
If I'm following, you haven't yet scanned or converted the images.
Or, if
you have done so, they have not yet been entered into Filemaker. Is
that
correct?
If they are not yet in Filemaker, then it might make more sense to
move
them directly into the new software, since you will have to manually
associate them with the Patient ID either way.
If the new software is SQL based, you may be able to use the Execute
SQL
script step (not the similarly named function in FMP12) to INSERT
Filemaker containers as BLOBS; I cannot recall if that was possible in
.fp5. Even if it were, it would require finding drivers that would
work,
and it seems like a lot more work than moving the images directly
into the
new system as you scan them.
In 12, you can store files directly in container fields, without
needing
to scan or convert them, something worth considering if the decision
to
use other software is not final.
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Business Alliance
Certified For Filemaker 12
On 10/14/12 5:22 PM, "Jay Erlebacher" <[email protected]> wrote:
I have a question re Filemaker 6, and hope some of you have a
memory of
that long gone but well loved version.
I am unfortunately being forced to convert my beloved home made FMP6
electronic medical record (EMR) to a government certified commercial
program, and I am hoping to transfer as much information as possible.
I"m not sure of this, but it seems that the best way to transfer
office
notes, procedure results etc will be as images of the reports with
all
the beautiful formatting intact.
I will need to export images of the reports together with key
fields such
as the date of the report and the patient ID number.
The only way I see to export images is to print them as pdfs or JPEGs
into a Preview file, import the images into iPhoto, export the iPhoto
images into a folder and then import the images into a Filemaker
file.
After that I need to export them from Filemaker into some format
that the
commercial EMR can import.
Seems much more kludgy than it should, and I can't figure out how
to keep
the Date field and the Patient ID field together with the images.
Can anyone advise me?
Thanks for your wisdom!
