Exporting JPEGs

[andrew.ryan]

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?

[LiveOak]

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

[h2o]

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