Image Cleanup

[bcooney]

I have a client that has an image database with references to image files. Some of the references are invalid, but some are valid. The images are scattered over three disks.

I'd like to loop thru the records and move the image file to one directory, updating the reference. If it's an invalid path, I'd like to mark the record. Is this possible? Troi? SuperContainer?

[Fenton]

It should be possible. You'd be recreating what some of the better image management apps do. Which is to look for the file if it's not where it's supposed to be, using its name, and moving it.

I haven't really tried this on different volumes, but there's no reason why it shouldn't work. If you're needing cross-platform look at the Troi File, and its Search function. I've tried it on my local volume and it's awesomely fast.

It's Exists function is great also. It can tell you if an image is missing using a FileMaker calculation.

[bcooney]

Telepathy works! I was hoping you'd see this post. Many thanks, Fenton.

[comment]

Just thinking aloud: it should be possible even without a plugin. Exporting field contents (in a loop) would DUPLICATE all the available images to a central location, and trapping for error would enable marking the missing ones.

As for deleting the originals (if necessary), perhaps this trick could be utilized?

http://www.fmforums.com/forum/showtopic.php?tid/191249

[bcooney]

But these are references only...exporting field contents would be used if the image is stored in the file. Right?

[comment]

There is no such limitation, AFAIK.