FilePathToURL ( FMFilePath )

Convert from FileMaker filepath to URL

Average rating: 3.8 (45 votes) Log in to vote

Tom Robinson - Show more from this author

Sample input:

FilePathToURL ("file:/startupvol/Users/tom/fold & er/filepath.fp7")

Sample output:

file:///Volumes/startupvol/tom/Temp/fold & er/filepath.fp7

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
Convert from FileMaker filepath to URL

Useful for using the result from Get(FilePath) and Get(TemporaryPath) in an Open URL or Web Viewer

Examples (from / to):

	Case A:  OS X, FileVault protected home folder, normal folder, network folder, e.g. ‘Hard Drive’
		file:/Hard Drive/Desktop/fold & er/filepath.fp7
		file:///Volumes/Hard Drive/Desktop/fold & er/filepath.fp7
		Note Open URL fails for FileVault protected volumes under OS Ⅹ 10.4

	Case B:  Windows, UNC volume
		file://comp/share/fold & er/filepath.fp7
		file:\\comp\share\fold & er\filepath.fp7

	Case C:  Windows, drive letter, e.g. ‘C’
		file:/C:/Documents and Settings/Administrator/My Documents/fold & er/filepath.fp7
		file:///C:/Documents and Settings/Administrator/My Documents/fold & er/filepath.fp7

	Case X:  OS Ⅹ, Get(TemporaryPath)
		/Amphe/private/var/tmp/folders/501/TemporaryItems/FileMaker/
		file:///Volumes/Amphe/private/var/tmp/folders/501/TemporaryItems/FileMaker/

	Case Y:  Windows, Get(TemporaryPath)
		/C:/Documents and Settings/Administrator/Local Settings/Temp/
		file:///C:/Documents and Settings/Administrator/Local Settings/Temp/

Author:
	2006-11-07 Tom Robinson <http://www.tomrobinson.co.nz/>

Change History:
	2007-02-15 Tom Robinson
		Fix when running under OS Ⅹ Intel
	2007-05-03 Tom Robinson
		Add UNC drive support
		Don’t encode spaces, web viewer seems to want them raw
	2008-08-12 Tom Robinson
		Add support for Get(TemporaryPath) because FMI made that different from the others
*/

Case(
	left(FMFilePath;1)="/" and Abs(Get(SystemPlatform))=1;  /* (case x) */
		"file:///Volumes"&FMFilePath;
	left(FMFilePath;1)="/" and Get(SystemPlatform)=-2;  /* (case y) */
		"file://"&FMFilePath;
	Abs(Get(SystemPlatform))=1;  /* -1=PPC Mac, 1=Intel Mac (undocumented) */
		"file:///Volumes/"&Right(FMFilePath;Length(FMFilePath)-6);  /* (case a) */
	Get(SystemPlatform)=-2 and Left(fmfilepath;7)="file://";  /* Windows UNC drive */
		"file:\\\\"&Substitute(Right(FMFilePath;Length(FMFilePath)-7);"/";"\\")  /* (case b) */
	;  /* Anything else */
		"file:///"&Right(FMFilePath;Length(FMFilePath)-6))  /* (case c) */

Useful for using the result from Get(FilePath) and Get(TemporaryPath) in an Open URL or Web Viewer

Examples (from / to):

Case A: OS X, FileVault protected home folder, normal folder, network folder, e.g. ‘Hard Drive’
file:/Hard Drive/Desktop/fold & er/filepath.fp7
file:///Volumes/Hard Drive/Desktop/fold & er/filepath.fp7
Note Open URL fails for FileVault protected volumes under OS Ⅹ 10.4

Case B: Windows, UNC volume
file://comp/share/fold & er/filepath.fp7
file:\\comp\share\fold & er\filepath.fp7

Case C: Windows, drive letter, e.g. ‘C’
file:/C:/Documents and Settings/Administrator/My Documents/fold & er/filepath.fp7
file:///C:/Documents and Settings/Administrator/My Documents/fold & er/filepath.fp7

Case X: OS Ⅹ, Get(TemporaryPath)
/Amphe/private/var/tmp/folders/501/TemporaryItems/FileMaker/
file:///Volumes/Amphe/private/var/tmp/folders/501/TemporaryItems/FileMaker/

Case Y: Windows, Get(TemporaryPath)
/C:/Documents and Settings/Administrator/Local Settings/Temp/
file:///C:/Documents and Settings/Administrator/Local Settings/Temp/

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

FilePathToURL ( FMFilePath )

Comments

Support this website.

Support this website.