image calculation/container for images on a web server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matpac4@gmail.com - 23 Jul 2008 03:33 GMT

Hello - I've looked for 2 days to do this but no luck so maybe someone
can solve this for me in 30 seconds!

I have a FM DB.

I have a bunch of images which are in a folder on my computer and I
get these to appear next to the appropriate db entry with the
following defined calculation field which is saved as a variable:

"image:/Macintosh HD/Users/Me/Photos/X" & Employee Number & "." &
extension

Now this works fine.

The problem is that it doesn't work with IWP. The picture is blank.

So I'd also like to try and get it to pick and display the image, not
from a folder on my computer, but from a folder on my website.

I was thinking something like this:
"image:http://www.mywebsite.com/Photos/X" & Employee Number & "." &
extension

I've tried this and variations but it isn't working.

Does anyone know if this is possible and where I'm going wrong?
I think If I can link to the file on the server it may have a better
chance of being displayed on IWP also it helps me for other resaons
too.

Thanks for any help with this.

Reply to this Message

Helpful Harry - 23 Jul 2008 07:21 GMT

In article
<28693dd6-d256-4314-a59e-1ad905c813e3@w7g2000hsa.googlegroups.com>,

> Hello - I've looked for 2 days to do this but no luck so maybe someone
> can solve this for me in 30 seconds!
[quoted text clipped - 27 lines]
>
> Thanks for any help with this.

I don't know anything about IWP, but make sure the image files are in a
web-compatible format, ie. JPEG or GIF (or PNG if you really must). Web
browsers will have problems with anything else.

You could always try storing the images in the database rather than
linking. It shouldn't take up too much disk space, unless you've got
many hundreds of employees or have the images at a huge resolution /
size.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Reply to this Message

iacon - 23 Jul 2008 08:43 GMT

I have tried something like this in the past, from what I recall it
doesn't work. The IWP won't display the content of a container.

Reply to this Message

matpac4@gmail.com - 23 Jul 2008 11:45 GMT

> I have tried something like this in the past, from what I recall it
> doesn't work. The IWP won't display the content of a container.

Thanks Harry and Lacon.

I have about 4000 employees in this database project and the images
are nearly always jpg, gif, png, sometimes bmp. Sometimes high
resolution also.

If iwp won't display the contents of a container is there another way
of doing this?

Can it not just show the image like any other web page with an 'img'
tag?

I love this software but it's driving me crazy.

Reply to this Message

Bill - 23 Jul 2008 16:10 GMT

In article
<b241badb-57b7-4e26-8ac8-49b49b677697@p25g2000hsf.googlegroups.com>,

> > I have tried something like this in the past, from what I recall it
> > doesn't work. The IWP won't display the content of a container.
[quoted text clipped - 12 lines]
>
> I love this software but it's driving me crazy.

On the contrary: IWP in FMP 7 and later does display container images on
the web.

Signature

Bill Collins
For email, change "fake" to "earthlink"

Reply to this Message

Ursus - 23 Jul 2008 22:41 GMT

> In article
> <b241badb-57b7-4e26-8ac8-49b49b677697@p25g2000hsf.googlegroups.com>,
[quoted text clipped - 18 lines]
> On the contrary: IWP in FMP 7 and later does display container images on
> the web.

Yes but the image has to be inside the filemaker DB and can NOT be a
calculated reference.

Ursus

Reply to this Message

FastWolf - 23 Jul 2008 18:53 GMT

>Hello - I've looked for 2 days to do this but no luck so maybe someone
>can solve this for me in 30 seconds!
[quoted text clipped - 27 lines]
>
>Thanks for any help with this.

What about just exporting an HTML tag using the calc:

"<img src=http://www.website.com/pathname" & Employee Number & "." &
extension

hope this helps

Signature

FW

FileMaker Pro 8.5 Advanced on Windows XP Pro SP2
FileMaker Server 8.0 on Windows 2003 Server R2

Reply to this Message

matpac4@gmail.com - 24 Jul 2008 00:38 GMT

> >Hello - I've looked for 2 days to do this but no luck so maybe someone
> >can solve this for me in 30 seconds!
[quoted text clipped - 40 lines]
> FileMaker Pro 8.5 Advanced on Windows XP Pro SP2
> FileMaker Server 8.0 on Windows 2003 Server R2

Thanks but I still can't get this to work/

I have the variable as a calculation (where the result of the
calculation is a container).
Using variations of the img tag you gave me doesn't work.

Is there somewhere that I specify html img tag?

How do I bring 4000 images into the database without problems?

Thanks for your help.

Reply to this Message

FastWolf - 29 Jul 2008 21:16 GMT

>> >Hello - I've looked for 2 days to do this but no luck so maybe someone
>> >can solve this for me in 30 seconds!
[quoted text clipped - 48 lines]
>
>Is there somewhere that I specify html img tag?

>Thanks for your help.

I screwed up with my previous post, here's what it should look like:

$some_variable= "<img src=\"http://www.website.com/pathname/" &
Employee Number & " . " & Extension & "\">"

Note the quotes escaped with backslashes (\") that enclose the URL
inside the <img> tag; and the quotes NOT escaped (") that enclose the
text constant parts of the calculation. Let's say Employee Number is
1234 and Extension is jpg, then the calc resolves to this:

<img src="http://www.website.com/pathname/1234.jpg">

This tag is suitable to insert into a HTML document. You could
actually use the variable in a calc field to create a HTML doc to hold
the image for you:

html_calc= "<html><body>" & $some_variable & "</body></html>"

>How do I bring 4000 images into the database without problems?

I'd do that with a Web viewer on my layout, using the variable and/or
a calc field.

hope this helps

Signature

FW

FileMaker Pro 8.5 Advanced on Windows XP Pro SP2
FileMaker Server 8.0 on Windows 2003 Server R2

Reply to this Message