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