Just wondering if anyone knows why when I import a folder off of a server and store the pics as a ref. that when I use the "Open URL" nothing happens.

If you create a calculation simply referencing the container field (text result) and look at the result, you'll notice that there is more information in there than you need (On Mac but not Windows). And, the path information is the same as what you need for the Open URL script step to open a file. Here is a calculation that converts the image path to a file path:

Let(

ImagePath = RightValues(container; 1);

Substitute(

Left(ImagePath; Length(ImagePath) - 1);

["imagemac:/"; "file://"];

["imagewin:/"; "file://"]

)

)

Hi,

I tried using this calc., but something is going wrong. My current file path is

file://Mac3/zz_ImageDatabase/00002/7323827.jpg

I tried using the Open URL and inserted the calc. that is posted, but I keep getting invalid URL. Do I need 2 sep. fields-1 for the file path and 1 for the image path?

Is the file server mounted when you run the script? Can you post an example file demonstrating the problem?

Edited June 1, 200619 yr by Guest

Yes, I am mounted to the server. I am on a mobile account, but that should not matter. Attached is a .zip file.

Thanks

ImageDatabase.zip

Well, it took me a while to surf through your files and locate the correct fields and scripts. It's always nice to give directions in your file when someone offers to assist you.

Anyhow, I have attached a working version of the files. It doesn't appear the solution every contained the calculation referenced in this thread.

ImageDatabase.zip

Thank you! I will give this a try. Sorry for not including instruction pertaining to my files-it will not happen again.

Thanks

Well, I imported a folder of about 5 images that are located on a local server. Everything imported perfectly. However, when I click on the "Open Image" I get Question marks "?" in both the image and file path fields. Here is a file path for one of the images.

file://Mac3/zz_ImageDatabase/00002/7657759.jpg

I am confused on whats going on. When a picture is imported from the server and stored only as a reference then a complete file path is needed. Should an alias of the picture be created so that when it is moved the picture will be able to relink itself? Is there another way to open an image other than "Open URL"?

I don't have a file server available on which to test this. Maybe someone else here can figure out what's wrong with the calculation. All I can say is it works fine on my Macintosh and Windows computers with a path from the local hard drive.

Hello,

Thanks for trying. What exactly is the calc. you provided earlier in this post do? Maybe I can go from there.

Thanks

The calculation replaces the image path with a file path using the Substitute function. This requires removing "imagemac:/" or "imagewin:/" and replacing or substituting it with "file://". Before this can be done, additional information (only on the Macintosh) must be removed. You can see this information if you just look at the path provided when a calculation simply referencing the container field is displayed in text format. However, you won't see anything additional unless you view it on a Macintosh.

I don't have a file server available on which to test this. Maybe someone else here can figure out what's wrong with the calculation.

Hi, I have used the above calculation for opening files (thank you John!) but have the same problem as Joe: when the file is stored on the server it doesn't work. Does anyone have a solution for this? I'm using an applescript for Mac clients instead of "open url", but not sure how to make it work for Windows clients. I would really appreciate any ideas! Thank you in advance.

I don't have a network either, but have you tried what Filemaker Help says is the supported path format for the "absolute path to a target file or folder on a Windows volume shared using Windows file sharing":

filewin://computerName/shareName/directoryName/fileName

Thanks a lot for the tip! I'll add the computer name to the path and test it with my fingers crossed.