Jump to content
Sign in to follow this  
Jim D

Importing photographs into FM from a folder

Recommended Posts

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.


Share this post

Link to post
Share on other sites


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"


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!


Share this post

Link to post
Share on other sites

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

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.