Export images

[Sallaman]

Hi,

I have a database containing my customers. The information is customer name, adress, phone, customer number etc. There also is a picture (since we produce picuters) of every customer in a field. This field (container) is just a link to a folder where I put all my pictures and then it automatic appears in the record.

Now to my problem.

Lets say I have searched and found 100 records. I then would like to copy (export) all pictures found to a different but specified folder. I have tried a little with troi file but it only seems to work with on specied filename and not folders or?! Any other way or plugin??

Thanks in advance!

//Fredrik

[Fenton]

Can't you just copy the files one at a time? (it is not "exporting" in the FileMaker sense; you're just copying files from one place to another). Since it's a found set, just specifying the whole folder will not do.

You could capture the file paths of the found set using Copy All Records, but that wouldn't really help much. You'd still need to copy the files one at a time.

Your sidebar says that this is for FileMaker 7. In that case you could use a calculation of GetAsText to get the filepath of the existing image reference (if you don't have it already). It's the last line of the result (needs a little parsing, to remove the "image:" or "imagewin:" prefix; I'm on a Mac, "imagemac:").

Look at the Troi File example file "FileManipulation.fp7". Copy file is the first example. He has you choose the folder and the file, but you could just skip those steps and specify the file and folder. Try it, then look at the file path syntax. It should be what you expect on your operating system. The new file path doesn't exist yet (obviously). But it can be easily constructed from the new folder's path & the file name.