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