3 Replies Latest reply on Sep 21, 2010 4:54 AM by Joser

    Resize the resolution of photo's already in a database

    Joser

      Title

      Resize the resolution of photo's already in a database

      Post

      Hello,

      we've got a database with hundreds of photo's all set in container fields. These photo's all have a resolution of 3072x2304. The database is now more then 1 GB

      This resolution is to large and begins to slow down the database.

      Is there a way to reduce the resolution of these photo's already inside the database to ex. 1024x800 ?

      it would be a hell of a job to do this one by one. Is there a plugin, or other program to do this automaticly?

      kind regards,

      Joser

        • 1. Re: Resize the resolution of photo's already in a database
          philmodjunk

          Filemaker can resample graphic images, you'd need an image editor such as PhotoShop to do that. Don't know how much it would affect performance, but if you stored your images by reference in the container fields, your entire database would be much smaller.

          • 2. Re: Resize the resolution of photo's already in a database
            FentonJones

            It would be good to know what platform you are on, Mac or PC. On a Mac, this can be done with AppleScript. On a PC, the InsideScan plug-in can resize images, maybe others (Troi File can I think, but it costs more than InsideScan). 

            In either case you'd need to either do them one a time, via a script with a Loop, or export them all out, then do 'em all at once, with any image resize application (there are many that can do an entire folder, some free). 

            In either case it can be automated. But which depends on a few things. For one thing, an 'en masse' export into a single folder would require that the file names be unique. Which they may already be; use GetAsText (container) to set the current image's name into a text field to see. Or you may be able to add something to the name to make them unique. The advantage of this is that you would not need a plug-in or AppleScript, just a graphics app.

            In any case, you'd want to export out the graphics, to save as full-resolution files. So really, you need unique names or a folder structure.

            The FileMaker step to export each as a file is Export Field Contents. You would need to construct a full FileMaker syntax path for the proposed file, set it into a script Variable, then use that as the path.

            Let us know what the image names are, or ask for me help with that. 

            • 3. Re: Resize the resolution of photo's already in a database
              Joser

              Thank you both for your help !

              i tried the plugin " InsideScan "  and it does just what i need .

              With a simple script, I will be able to resize all the pictures to a more adjusted resolution.

              Again many thanks !

               

              regards

              Joser