Displaying Images from Text Fields

[lavaweb]

Hey guys, I'm using Filemaker Pro 5, and I have a database of products for our website, and one of the fields is for the products thumbnail image, and one is for the full sized image. Right now in those fields we have the basic URL to each image, for example, "/imagessmall/07589.jpg" (no quotes)

What I

[kenneth2k1]

Uh oh.

Duplicate post. The gestapo is coming for you!

[lavaweb]

Sorry, I posted under scripts before and realized that this might be a better place for it, I will try to remove one of the post.

[kenneth2k1]

I think that no one has responded because we will need some more information.

Like what you mean by "show up under each URL field." Because my answer would be to put the image container underneath the URL field in the layout.

Also, you said it was a product catalog, so is this db published over the web? Are you using CWP with CDML, or is this a runtime?

So, please give more info on your setup and what you mean by "show up underneath"

Ken

[lavaweb]

ok, what i mean is that i have a seperate database from our website, that we enter our product information into, then we export the information out of this database and into our website. Two of the fields on the database are Thumbnail image and Fullsize image. In these fields, we type the urls of each image for that product. Like for instance, for our product the XL-1s, the thumbnail field says "/imagessmall/xl-1s.jpg" because that is the link to that image for the website. Basiccally the same for the Full Size image, except the link would be "imageslarge/xl-1s.jpg"

Now what I am trying to do, to make it easier for my guys checking over the products by having the actual images displayed in the FMP layout for each product. so i have created two containers, one for the thumbnail and one for the full size image. And I have been trying to link the contents of that container to the text that is in it's perspective text field, either thumbnail or full size. This is where i need help, I have tried pretty basic scripts but none of them are working, does anyone know how to do this?

I have attached a preview of basically what I am looking for here.

[kenneth2k1]

Ok, I think I see what you mean.

So right now, you don't actually have the images displayed in your FM database. Is that right?

If so, then you will have to insert images into container fields to view them. You would probably only need one per record (in other words, you don't need an additional one for thumbnails, you can just shrink the container size). If you don't know how to create container fields, let us know.

Also, when you insert pictures into container fields, you can store only a reference to that image, so as not to increase the size of your db with image data. However, the path to the image should stay the same, or you may lose the reference. If the paths may change you might want to look into the Troi File Plugin.

If more than one image may be associated with a record, you might want to consider a relational system.

Ken

[lavaweb]

That correct I don

[kenneth2k1]

You wouldn't be able to have the container field reference the path in your URL field using FileMaker. But you might be able to automate the process.

In FM6, you are able to import contents of folders. If the path of the file is identical to the path in your URL field, then you could make that your match field when importing. I've never tried importing folder data into existing records, so you might want to test it on a db copy first.

The Troi File plugin that i mentioned earlier has some useful features also.

Hope this helps. Good luck