I have a large number of JPEG picture files saved in a container field. Is it possible to write a script to export all of these to separate JPEG files named as the contents of another field in the record?

If you have imported pictures (not references to pictures) there are no jpeg images to export. Upon import they are comverted to pict images, there is no way I know of to export the original picture at the original resolution.

If you want to "export" and use pictures in a database, import only references to the pictures and access the externally stored images for other uses.

-bd

You are Mac user. Soo, there is an AppleScript Solution.

A container field with the pict "picture"

A field with the name : "picture name".

Note : name of pict = 26 characters maximum!

Second note : this script use the osax "Akua Sweets" avable at

Macscripter

The Applescript (new version 09/26/01):

set the_folder to (choose folder with prompt "Selected the folder to export pictures")

set nb_exported to 0

set nb_records to 0

tell application "FileMaker Pro"

--activate

set nb_records to count records

repeat with nb from 1 to nb_records

--go to record nb

try

set my_pict to cell "picture" of record nb

set my_pict_name to cell "picture name" of record nb

set txt to offset of "." in my_pict_name

if txt = 0 then

set my_pict_name to my_pict_name & ".jpg"

else

set my_pict_name to