OK, I am not following...
I can export images of the reports by "printing" the images in pdf
format into iPhoto.
Each iPhoto image has a unique ID such as "6k7HMh", but I have no idea
where this ID comes from.
How do I get the appropriate Patient ID, date and report type to be
associated with each image?
On Oct 14, 2012, at 10:39 PM, Al Jeffrey wrote:
That's it!
Give the new database the records with the Patient ID, Report ID and
Image ID. If they want to print view etc, just check the pertinent
report, patient etc. to get the proper image ID.
The only trick is, have you provided the database with the proper
image ID. Its a bit of work if you haven't. You said you could give
the images unique ids. I assume that you haven't done this yet.
Al Jeffrey
On 2012-10-14, at 8:07 PM, Jay Erlebacher <[email protected]> wrote:
Each image doesn't have a unique ID, though I could give it one.
Each image is associated with a unique patient ID and a date as
well as a report type.
Those fields are needed to file the image away in the new EMR.
I could make a concatenated field that has all three pieces of data.
I am not sure what is meant by a "reference". I can't find in in
the FMP help so I suppose it doesn't exist in FMP6.
I am eager to see how this can be done!
Jay E
On Oct 14, 2012, at 9:55 PM, Al Jeffrey wrote:
I do this all the time.
Does each "image" have a unique ID? (Are they stored as
references? I forget if FMP6 can store references.) If not can
they be exported at images, and given unique names?
Does your FMP6 database have the patient ID and report ID?
Does the database know the unique ID of the image? (linked the the
Patient ID etc above?)
Then, as long as the above is true, you can edit the reference to
its new location, and all the images can be copied there at once
in its folder. (Its easier to keep them in the same place anyway..)
Al Jeffrey
On 2012-10-14, at 7:34 PM, Jay Erlebacher <[email protected]> wrote:
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!
