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