You'll need to export the pictures using export field contents to create indvidual files, one file for each picture. The file formats you mention don't support graphic content.
Thank you - I realise csv and excel aren't picture containers, but even when exporting as HTML it says "cannot export container" or something, so the photos don't get exported there, either.
Or perhaps there's another way? If I connected it to some kind of sql connector or something?
All I need is the photos dumped out with their record name - I can glue the rest together, but the idea of going through each record, going "file > export" etc, then manually naming it...
You can script the export field contents step in a loop that steps through each record and exports the picture. The script can be constructed to name the file and specify an folder to recieve the exported pictures.
Right. Scripting. Remembering that this is the first and last time I am ever likely to use filemaker pro, and it's only to open and export, what would be the quickest way of doing that script?
I've found things to do with scripts http://www.filemaker.com/products/fmp/script_triggers.html but this looks like a learning curve.
So, you are saying that there's no built-in bulk export? In this case it looks like manually open and save as might help. I just wish there was a way to display pictures which say "needs quicktime" even when quicktime is installed, and that it wouldn't take 28 seconds to redisplay a list of 143 names and photos on a 3Ghz pc with 4Gb RAM , (although I suspect that might be the original maker of the db using pct format even thought they don't actually display)
Create a field that we can use to name each exported picture. This field should automatically assign the correct file type suffix.
Use File | Manage | Database | Fields to add a calculation field that will give you the name of the original picture file inserted into the container field. Name it "TextofContRef".
Enter the field name, select "calculation" as it's type and click Create.
Select the name of the container field by double-clicking it in the upper pane.
Select "text" instead of number from the lower left corner of the dialog.
Click OK and keep clicking OK to dismiss dialog and return to the Database layouts.
Select manage Scripts... from the scripts menu and click the new button.
Add steps by double-clicking the step listed in the left hand pane.
Specify parameters for these steps by clicking the Specify... buttons and other controls that appear in the bottom of the dialog when you have that step selected.
Show All Records
Set Variable [$FilePath; Value: "filewin:" & "/DriveLetter:/Your filepath goes here use / to delimit folders/" & YourTableName::TextofContRef]
#Don't type in "Value:" in the above expression, Filemaker adds that after you click OK.
Go to Record [next; exit after last]