Help

Creating a database
F
ILEMAKER PRO HELP 200
Note FileMaker Pro does not support URL protocols as file paths.
Examples of single file paths
Examples of multiple file paths
Use multiple file paths when you want FileMaker Pro to search a list of potential files. File paths are
searched in the order in which they appear. FileMaker
Pro opens the first file it is able to
successfully locate, which completes the search. Each file path must be on a separate line.
• Example 1: In this example, a FileMaker Pro database must work on two different operating
systems: a Windows system that accesses local Windows files, and an OS
X system that
accesses local OS
X files. On both platforms, the database must access a local file named
test.xlsx.
filewin:/C:/ExcelFiles/Hosted/test.xlsx
filemac:/MacintoshHD/ExcelFiles/Hosted/test.xlsx
• Example 2: In this example for a scripted record import, a FileMaker Pro database should
access a file that is hosted. However, because the host may not be available, you also
reference two alternate files, one hosted by a different server, the other stored locally on
your hard drive. If the first network file is unavailable, FileMaker
Pro will search for the
second network file. If the second network file is also unavailable, FileMaker
Pro will search
for the local file.
fmnet:/192.168.10.10/Databases/test.fmp12
fmnet:/192.168.100.120/Databases/test.fmp12
file:../Databases/test.fmp12
Variables
You can use variables in file paths. Variables let you specify file or folder paths dynamically for many
scripts, for example, the Export Records script step. See Using variables.
Use the Set Variable script step to create local and global variables.
Full remote
(Windows)
The absolute path to a target file or folder
on a Windows volume shared using
Windows file sharing
filewin://computerName/
shareName/directoryName/
fileName
filewin://computerName/
shareName/directoryName/
FileMaker Network The network path to a shared
FileMaker Pro file
fmnet:/hostIPaddress/
fileName
Type of path Description Format
Type of path Example
Relative file:MyDocuments/test.xlsx
Full local (OS X) filemac:/MacintoshHD/Users/JohnSmith/Documents/test.xlsx
Full remote
(Windows)
filewin://SalesComputer/SharedVolume/ExcelFiles/test.xlsx
FileMaker
Network
fmnet:/192.168.10.10/database.fmp12