Automatically Inserting Image from Model Number

[Delights]

Greetings,

I have a image feild that is set to "Container" and called "Image". There is another field that is called "Wholesale ID No 2" which contains the model number for the wholesaler. The Image name is the "Wholesaler ID No 2".

What i want to do is set it so that it will automatically insert the pictures into the field using a web address and the model number.

There is over 2000 records that need to be done, however everyone has a different model number. For example

www.test.com/images/00001.jpg - model 00001

www.test.com/images/00002.jpg - model 00002

www.test.com/images/00003.jpg - model 00003

www.test.com/images/00004.jpg - model 00004

Thanks in advance for assistance.

[Cabinetman]

Where are the images? Online or in a table?

If in table heres a lookup I use....

auto_insert_image.zip

Edited October 4, 2008 by Guest

[Delights]

They are stored on the Web, remote, not tabled.

[Fenton]

I don't think you can Insert directly into a FileMaker container field using an HTTP path. It just isn't supported. So, you've got 2 basic methods.

1. Use a Web Viewer object. That will show the images using the web path.

2. Download the web images to a local file, then Insert each into a FileMaker container field.

Actually #2 has variations:

2.a. Insert [x] Reference only; implies the files are on, or have been moved to, a central file server machine.

2.b. Insert embedded; should put them into another related file likely, so as not to bloat your data file.

2.a. Just calculate the path to the image file; works much like Insert [x] as reference; requires a little more work.

Also #2 requires a tool to download the files. On a Mac, we have curl built in. On Windows you need:

1. A tool, Wget or Curl

2. A plug-in or command line to run it. Some plug-ins may be able to do this directly.

[Genx]

I don't think you can Insert directly into a FileMaker container field using an HTTP path

True, but if you want, there are a couple of plugins out there that'll do it for you - they're relatively cheap.

[Delights]

Plugins ?

Where would you get them from, how do they work ?

[Genx]

http://www.fmwebschool.com/grabit.php

There's another one but it's a fair bit more expensive and harder to use - though it does have more features.

http://www.troi.com/software/urlplugin.html

[Raybaudi]

I don't think you can Insert directly into a FileMaker container field using an HTTP path.

Not on a Mac and not with a script...

But you CAN insert an image into a container field ( by hand and on Win ) giving it the web address when it asks where is the file.

This is a strange ( Win ) feature that I discovered recently.

The images so grabbed will be stored into the temp folder of IE.