4 Replies Latest reply on May 2, 2012 11:39 PM by AlanStirling

    Use EXIF to auto rotate images on import

    user744

      I work on a database that is used for dance competition photography. On any given weekend we import from 50,000 to 200,000 images from 1 to 4 photographers. These are imported automatically without intervention. The logisitics are daunting but these images are copied to folders which are auto imported using AppleScript and FileMaker's import from folder. They are then viewed by the dancers within a few minutes after the routine. The frustrating thing is that the EXIF data contained in the file contains the rotation information. The Finder on the Macintosh seems to use that data to display the pictures in their proper rotation. This auto rotation is done even if the pictures were simply copied from one drive to another vs. imported directly from the camera or chip. FileMaker only imports Filename, path, Image and Thumbnail as the four fields from the folder import. The EXIF data is in the file it's simply not accessed unless you import directly from the chip which in this case is not possible. Is there anyway to have FileMaker easily rotate these pictures. Right now we have to have user intervention to rotate the pictures for us. There are plug-ins that can go out and get the info from a file then apply the rotation. But when you are importing 200,000 pictures in a weekend, even that would be tough to implement. Really need this to happen on the fly as it imports. This import from folder code seems to have been the same ever since FM6. FM 12 seems to have the same options.

       

      Any ideas would be appreicated.

       

      Screen Shot 2012-05-02 at 6.35.54 PM.png

      Finder Display.

      Screen Shot 2012-05-02 at 6.36.59 PM.png

      FileMaker Import of same images.

        • 1. Re: Use EXIF to auto rotate images on import
          Malcolm

          I work on a database that is used for dance competition photography.... these images are copied to folders which are auto imported using AppleScript and FileMaker's import from folder.

           

          Right now we have to have user intervention to rotate the pictures for us. There are plug-ins that can go out and get the info from a file then apply the rotation. But when you are importing 200,000 pictures in a weekend, even that would be tough to implement. Really need this to happen on the fly as it imports.

           

          Applescript can read EXIF data and rotate the image as required but that may be a bit slow. For more speed and convenience you could use AppleScript to control imageMagick on the command line to do the job

           

          Malcolm

          • 2. Re: Use EXIF to auto rotate images on import
            user744

            Yes. Using AppleScript and ImageEvents can do it but it takes 1.5 - 2.0 seconds per image AND you still need user intervention. I would like to have FM simply read the data which is provided by the cameras that tell you where the bottom of the picture is and auto import it that way. We do use a large amount of comand line scripts to sync the photo and video data that we transfer from the rooms. We are not afraid of the command line still just not practical with the volume we are talking about.

             

            Thank you.

            • 3. Re: Use EXIF to auto rotate images on import
              Malcolm

              what about imageMagick ?

              • 4. Re: Use EXIF to auto rotate images on import
                AlanStirling

                Hi User

                 

                Have you looked at the Troi File plug-in?

                 

                Version 6 specifically mentions EXIF Data and a Landscape/Portrait flag.

                 

                I haven't used it to import images, but it's the standard fall-back solution for processing external files from within FileMaker.

                 

                http://troi.com/software/fileplugin.html

                 

                It's already FM12 compatible.

                 

                Best wishes - Alan Stirling, London UK.

                 

                 

                 

                Alan Stirling Technology Ltd, 135 Lisson Grove, London NW1 6UP

                +44 (0) 20 7724 2456 - alan@ast.fm - www.ast.fm

                FileMaker Pro Developer - Certified for FM versions: 7 to 11.