AnsweredAssumed Answered

Filemaker export is skipping 5 records of 750

Question asked by wendy on Aug 7, 2018
Latest reply on Aug 8, 2018 by Mike_Mitchell

I have a very simple FileMaker file on my desktop with two fields and 750 records.

ImageThumbnail   (container)

metaImageFilename  (Text)


Mac OS El Capitan (expecting new Macs soon) with FileMaker Pro 15 Advanced


I am exporting the contents of the container field to a folder on the desktop using this script:

Go to Record/Request/Page [ First ]


Set Variable [ $PATH; Value:Get ( DesktopPath ) & "/" & "FMImagesToFix" & "/" & GetAsText ( FIXIMAGES::metaImageFilename ) ]

Export Field Contents [ FIXIMAGES::imageThumbnail; “$PATH” ]

Go to Record/Request/Page [ Next; Exit after last ]

End Loop


It is consistently exporting only 745 records. To figure out which ones, I tried turning on Error Capture, placing the Get (Last Error) step at various locations, and having it write to a field--consistent zeros. I tried having it increment a counter variable and writing that to a counter field, which always ended up at 750. Finally in desperation I had it add a counter to to the NAME OF THE IMAGE FILE being exported to the folder on my desktop:


Set Variable [ $PATH; Value:Get ( DesktopPath ) & "/" & "FMImagesToFix" & "/" & GetAsText ( FIXIMAGES::metaImageFilename ) & " " & $counter


NOW I get 750 records in the folder--what I expected--but now, of course, I have 750 files with numbers added to the end of the filename.


Any idea what's going on? Is this a bug or am I doing something wrong?