User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Publishing databases on the web
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
84 FileMaker Pro User’s Guide
Opening shared databases remotely using a URL
The FileMaker Pro installer registers FMP7 as an Internet protocol.
This enables you to open a shared database using a URL.
FileMaker Pro databases shared via TCP/IP can be opened remotely
using the list of local hosts, the IP address of the host machine, or the
DNS name of the host machine if one has been defined. For example,
a database hosted from a computer with an IP address of
192.168.10.0, and a DNS name of host.domain.com can be opened by
entering either the IP address or the DNS name in the
File menu > Open
Remote
> Network File Path field.
To open a shared database using a URL:
1. Launch a web browser on the intended client machine.
2. Enter the URL of the host machine into the browser’s address area
using the format: [<][URL:]FMP7://
[[account:password@]netaddress]/databasename[>]
Optional parameters are indicated by square brackets ("[ ]"). Because
URLs cannot contain spaces, any spaces in database names are
encoded as plus signs ("+").
Examples
FMP7://My+Addresses.fp7
FMP7://192.168.10.0/My+Addresses.fp7
Closing a hosted file
Before a shared file can be closed by a host, all clients must close the
file. FileMaker Pro allows you to prompt networked clients to close
the shared file when you do one of the following: close the file, change
the sharing conditions for the file, exit FileMaker Pro, or perform a
task that requires all clients to close the file. If a client does not
respond to your request to close a shared file within 30 seconds,
FileMaker Pro will attempt to close the shared file on the clients’
machine.
To close a hosted file:
1. On the computer hosting the file, choose File menu > Close.
2. If any clients have the shared file open, you see a dialog box listing
those clients. Click
Ask to send a message to these clients requesting
that they close the file.
3. Clients see a dialog box requesting that they close the file.
For more information about sharing files over a network, see Help.
Importing and exporting data
You can exchange information between FileMaker Pro and other
applications by importing and exporting data. You can:
1 import data into an existing FileMaker Pro file, either into a new
table or into an existing table
1 convert data from other applications to new FileMaker Pro files
1 export data for use in other applications
Saving and sending data in other formats
You can save FileMaker Pro data as a Microsoft Excel worksheet or
an Adobe PDF file, allowing you to give your record data to users who
don’t have FileMaker
Pro.
FileMaker Pro lets you email the Excel worksheet or PDF file when
you save it. You can also create scripts to save records as Excel or PDF.
If FileMaker Pro
Clients click Cancel Waits for those clients to close the file
Clients click Close Now Closes the shared file on the client’s computer
Clients do nothing Attempts to close the file after 30 seconds, if it can be
closed safely