Importing photographs into FM from a folder

[Jim D]

Hello All

I'm a photographer who has been working with FM for about 5 years. I have numerous DB's where I have imported pictures though a loop in a FM script by manually specifying the file to import each time in the dialogue box. I have never used apple scripting and am wondering whether it is possible to write a script that will automatically go to the next file in a folder each time the FM script is calling for an import. Thanks in advance.

Jim

[iamme]

Jim,

You may set up a loop in your filemaker table

and for every record call this script to check

your Photo folder and import the file reference.

Use the "Perform Applecsript" script step in your loop using

something like;

tell application "FileMaker Pro"

activate

set thePhotoPath "YourHardDrive:YourPhotoFolder"

tell database "Photos.fp5"

set PhotoName to cell "FM_PhotoName" of current record

set FileRef to thePhotoPath & ":" & PhotoName as string

set cell "FM_Photo" of current record to reference to file (FileRef)

end tell

end tell

Good Luck!

Dave

[Ocean West]

If ya wan't to spend a little money, I do recommend Troi File Plug-in It handles this request quite nicely.