Data Base Image multiple export??

November 26, 200718 yr

Newbies

Hi there

I have a job for a client who is using fmp9.

He has a Museum Catalog with a few hundred 'pages' of information.

There are a number of feilds.

It is a catalog for museum artefacts.

There is a name, a catalog number, an illustration (image) field, some descriptons, size etc...

We need to get the image out, which is possible by selecting the field, and exporting its contents. But we will need to do this 3,500 times.

here is my question:

Is it Possible to write a script, to start at page one, export the image and name it with the catalogue number. and move thru the whole list of say 500 pages and do this for every page.

i.e. the script would run something like:

1. open catalog

2. goto p1.

3. select cat. no. field

4. copy field content

5. select illustration1 field

6. export field content

7. paste copied cat no.

8. save in path /images

9. go to page +1 and go to step 1

10. loop till x= 500 (or something)

any ideas?

November 27, 200718 yr

You can cut down the steps somewhat, as the file is named at the same time it's exported.

Create a FileMaker calculation, result Text, Storage, [x] Do not store, =

"filemac:" & Get (DesktopPath) & "Museum_Images/" & Cat. No. & ".jpg"

This is just so you can see if it's correct. You're going to put it in a script Variable (script step).

Create the folder "Museum_Images" on your Desktop (somewhere to put them).

Find the records you want to do.

Go to Record [ First ]

Loop

Set Variable [ $path; "filemac:" & Get (DesktopPath) & "Museum_Images/" & Cat. No. & ".jpg" ]

Go to Field [ Illustration ]

Export Field Contents [ Illustration; $path ]

Go To Record/Request [ Next; Exit after last ]

End Loop

Type $path as is in the file dialog, don't put quotes around it.

You should look first to make sure your images are jpegs. If inserted in earlier versions of FileMaker they might be PICTs, ".pct", which are considerably larger.