Hi,

I've written a solution for a publishing company for storing and managing an Image DB. Situation is:

WE have all images (23,000 +), in high-res and low-res and they are stored on our raidsystems etc.

WE upload the low-res thumbs to our webservers.

THEY insert image data (filename, comments, size etc) and a cField creates the correct path to the image. Thats all working fine.

but now this:

I've written a complete workflow solution for managing images and editorial stuff, aswell as lay-out setups, colorcharts for pages etc... al working fine too. The managing sulotion however checks for available images in the Image DB and sets a flag (either yes or no, portalview). There is a button there that opens the URL aswell but I rather put the thumb in the list aswell.

So, finaly, heres my question:

Can I set a containerfield to 'grab' and show the thumb in the managing db, so that when a item# is entered they will see a list of available images?

I really dont know where to start with this and I rather hear from you guru's than trying to invent a wheel that will not turn...

TIA

JP

If you're a mac user, there might be an applescript solution.

Hi,

Yes I am a macuser, but I need it to be rocksolid since those who will be using this solution didnt invent the lightbulb

Furthermore - I don't know where to start writing that script :

Can you point me in the right direction??

TIA

JP

If you already have the path to the thumbnail, a simple applescript should do the trick.

Tell app "FileMaker Pro"

set thePath to cell "Thumbnail Path"

set cell "Thumbnail Container" to reference to file thePath

end tell

You can run this applescript in a FM ScriptMaker script using the Perform AppleScript command. This script will insert a reference to the image in the database. If you need to store the image in filemaker, how you do it depends on whether you are running 9.x or OS X.

Thanks, you did point me in the right direction! But what if the enduser decides to move to a wintel platform? This could be happening in the near future since the solution i made is something they like. They came up with this idea to show thumbs in the portals but I - for now - could convince them that their bandwidth to the net wouldnt be sufficient... hehe hoping they will kinda forget about it.

Still i want to resolve this matter in a nice way.

Thanks

JP

I think the troi file plug-in will probably do what you want, and it's cross-platform.