2 Replies Latest reply on Apr 21, 2015 2:32 AM by flovelett

    Trouble with External Storage Container Field

    flovelett

      Title

      Trouble with External Storage Container Field

      Post

      I've created an image database with about 3000 records. A container field is set up with open external storage with a folder (same parent folder as the database) containing JPG's.

      Problems:

             
      1. Some image files links (1-5%) are broken each time the database is opened even when the image file has not moved. A "missing file" icon displays in the container field.
      2.      
      3. Re-inserting (the original) picture file into the container field results in a copy (or copies) of the file appearing in the external storage folder: 0100.jpg, 0100-1,jpg, 0100-2.jpg.
      4.      
      5. When the image files were cataloged with a Digital Asset Manager "DAM" (for keywording), FileMaker displayed an error icon in each container field: <Tampered: filename.jpg>. The files were not moved.

      This is the first time I've used external storage for a container field. I understand why using the DAM software caused the error message (most DAM's write to XMP descriptor fields, but am puzzled by the "missing file" problem & file replication.

      How should I manage this? Is there a way of changing container field behavior so that minor file modification does not create the link to be lost? Do I need to maintain a separate set of image files for keywording?

      Is there any way to relink all 3000 image files other than manually?

      (FM Pro 12.0v4 running on Mac OS X 10.6.8)

      Thanks,

      Felicia Lovelett

        • 1. Re: Trouble with External Storage Container Field
          philmodjunk

          Is there a way of changing container field behavior so that minor file modification does not create the link to be lost?

          Are you referring to the DAM program making changes or are your users making changes to the files? In either case, don't change the files while they are in this folder. Create a copy of the file or files and modify them there. If this is by your users, export a copy of the file from the container field, edit it and then re-insert it into the container field. For you DAM, I'd copy the entire folder to a different drive and run the DAM on the copy.

          Is there any way to relink all 3000 image files other than manually?

          Possibly. You can use the Folder option for Import records to import all of the files back into a table in FileMaker. WHen you do, you can populate a text field with the file names. You then may be able to use the file names and a script to re-link your re-imported files to their original records. But this assumes facts about your database that may not actually be the case.

          • 2. Re: Trouble with External Storage Container Field
            flovelett

            Followed your suggestions:

            Added a text field with the file names. After a bit of work in Excel to make certain that the record ID's matched, I was able to re-import all 3000+ images. Huge savings of time and frustration!

            The DAM program now writes metadata on its own copy of the image file folder.

            Decided to return to embedding the images directly in the container field. The files are low-resolution jpg's, so there isn't a storage/performance issue. No more strange duplicates or missing files now.

            Thanks for your help.