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!
>>
>