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!