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 <[log in to unmask]> 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 <[log in to unmask]> 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" <[log in to unmask]> 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!
>>> 
>> 
>