Hi ladies and gents...

I've not been around that much but here, again, a problem I am facing:

We have about 10.000 hires images which are linked to about 5000 products, all done in Filemaker 9 Server Advanced. To get and/or update those linked images we perform an "import folder" script which imports a reference into a separate table for linking: works great but takes a while. Now I wonder: HOW can i import the images of the current active record? Name convention: SKU_.tiff and SKU_detail1 or SKU_fx1 and such. In other words: behind the underscore is variable data, not always know to the user. (example: D41112_.tiff, D4112_detail1.tiff, D4112_detail2.tiff and D4112_2draw.ai) I guess I have to perform a find in the finder and import the result: I have no clue how to do this: i am able to find the specific related images (pass the content of the clipboard to the Finder) but there it ends. ANY help is appreciated!!! Thx.

would it be an option to have all images of your D41112 product in a D41112 sub folder of your images folder? Then you could still do a folder import, but it would be very fast.

Since FM folder imports also handles subfolders, you can still do a 'system-wide' update/reimport.

If that is not an option, then take a look at this post - I had similar issues with 100K+ pictures that just needed too long to import. The thread sort of "demystifies" the content of a container field and how to manipulate the content.

http://www.filemakerforums.com/forum/showtopic.php?tid/189345/

You could have your new images in a special update folder, do a fast folder import, and then move them via script to the permanent folder and manipulate the path of the container field accordingly.