I just installed updates to my Filemaker Server 7 Advanced to 7.0v3 a couple of days ago on a Windows 2003 Server.

Now my open url scripts do not work properly with the native filemaker pro 7.0v3 client. They trigger my IE 6 browser but the address gets messed up. Filemaker is adding an extra / into the calculated address. For example: My calculated url field shows: http://tps/fmp/form2.pdf

What gets put into the address box on IE 6 was: http://tps//fmp/form2.pdf.

Where did the extra / after the tps come from??

This script is of course is triggered from a button in the database and is also triggered from IWP on the web. However it works from IWP and puts the correct url into IE 6 and finds the file.

Has anyone else noticed this 7.0v3 update feature??

I tried calculating the field by breaking up the text parts into simpler expressions but the results were the same.

Additional trials on a 2nd machine with Developer 7.0v3 on a local database.

the bad addressing of the url occures with http://abc/xyz.pdf turning it into http://abc//xyz.pdf

It does the same thing with https://abc/xyz.pdf turning it into https://abc//xyz.pdf

however when using ftp://abc/xyz.pdf it correctly produces ftp://abc/xyz.pdf

So this does not appear to be just a new upgrade issue on the server. Perhaps it carries through on all the 7.0v3 upgrades

It's a known bug.

EXTREMELY horrible bug. Make using Open URL completely useless with IWP. Any further news on this one?

I have noticed this, but decided to ignore it because it hasn't seemed to cause any serious ill effects. I'm not sure that I see why it is such a problem.

I agree its a bug, and that it should be fixed, but....

As an example, take the link to this thread:

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=155299&an=0&page=0#155299

Now I mangle it far worse than filemaker has:

http://www.fmforums.com///threads///showflat.php?Cat=0&Number=155299&an=0&page=0#155299

And the link still works for me perfectly happily using IE6 on several different machines.

Also, as noted in the original post, this bug doesn't present when using the IWP client so it certainly doesn't render the script step useless for IWP!

Cheers,

Sean.

This might help. It's from the Filemaker website knowledge base:

--------------------------------------------------------------------------------

Filemaker Knowledge Base Answer ID 244

APPLICABLE TO: FileMaker Pro 7, FileMaker Developer 7

ISSUE:

The Open URL script adds an extra slash (/) within URL's when performed which causes some URL's to fail.

EXPLANATION:

When passing a URL to the Open URL script step, and extra slash ( / ) character is added after the top-level domain part of the URL. For example, http://www.mysite.com/folder/ will become http://www.mysite.com//folder/. Only the slash after the top-level domain part is doubled; other slashes in the URL are not affected.

The result is the same whether the step is performed with or without dialog. When performing with dialog, the extra slash is not displayed in the dialog.

RESOLUTION:

Leaving off the http:// part of the URL works around this issue. However, on Windows, if the URL does not start with www, the page will not load if the http:// part is not included.

FileMaker, Inc. has confirmed this issue with the products listed.

--------------------------------------------------------------------------------

Our internal FM db's are accessed via a URL that mimicks this form http://admin.mycompany.com. OpenURL(http://admin.mycompany.com adds a

So far, the only workaround I've found for accessing these db's through an openURL script step is to set up a virtual dns that contains a "www" at the beginning (http://www.fmdbs.mycompany.com). This way the script step becomes openURL("www.fmdbs.mycompany.com"), and leaves out that extra slash.

I've had this problem since I started using IWP.

-Maynard