1 Reply Latest reply on Feb 21, 2012 4:18 AM by comment

    Export pictures from a container field

    collinbr

      I have a database that is used to perform inventory activities for equipment registration, the database includes a container field to capture a photograph of the equipment. I need help to understand how to write a script that will allow me to extract the photographs from the filemaker database and name them with the unique identifier of the original record they were associated with. Any suggestions or help would be gratefully accepted.

       

      Thanks,

       

      Brian

        • 1. Re: Export pictures from a container field
          comment

          Try something like:

           

          Show All Records

          Go to Record [ First ]

          Loop

          Set Variable [ $filePath ; Case ( Abs ( Get (SystemPlatform) ) = 1 ; "filemac:" ; "filewin:" ) & Get (DesktopPath) & "ExportFolder/" & YourTable::SerialID & ".jpg" ]

          Export Field Contents [ YourTable::ContainerField ; “$filePath” ]

          Go to Record [ Next ; Exit after last ]

          End Loop

           

          This will export the pictures to a folder named "ExportFolder" on your desktop (the folder must be created beforehand).