HELP needed: import specific images.

[MacB]

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.

[vi]

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.