Help

Using FileMaker Pro Advanced tools
F
ILEMAKER PRO HELP 592
• When you open an encrypted database file, you must enter the encryption password before
you can enter an account password or access the database. See Opening files protected
with passwords.
• When you export records from an encrypted database file, the records are always exported
to a file that is not encrypted, regardless of the export file format.
• Contents that are entered in an encrypted interactive container via the progressive
download of data are sent through an unencrypted connection.
• You can change the secure or open storage of container data that is stored externally after
you encrypt database files. See
Setting up container fields to store data externally.
• To add a new database file to an encrypted multi-file solution, encrypt the new file with the
same encryption password and
shared ID as the database files in the solution.
• After you upload an encrypted database file to FileMaker Server, you must enter the
encryption password when you open the file in FileMaker
Server. See Uploading files to
FileMaker Server and FileMaker Server Help.
Documenting database schemas (FileMaker Pro Advanced)
Use the Database Design Report feature to document the schema of your database and publish it in
to an HTML or XML file.
With the Database Design Report, you can:
• produce reports for any databases that are currently open, either locally or on a network
• gather statistics on the structure of your database
• use the information in the report to re-create the structure of your database if you lose the
original database files
• examine a textual representation of your database schema
• choose which elements (fields, relationships, scripts, and so on) and tables of the database
to document
• troubleshoot missing references, broken relationships, calculations, and more
A Database Design Report in HTML format includes a Report Overview that provides a snapshot of
the elements in each database file. The Report Overview contains hyperlinks to details about all
elements in each database file. The HTML version of the report is hyperlinked and you can view or
print it in a Javascript-enabled web browser.
A Database Design Report in XML format contains the same information, ready to be transformed
into the format you require. You can create tools that can use the Database Design Report XML to
analyze or process the structure of databases. For more information, download the
FileMaker
Pro Advanced DATABASE DESIGN REPORT XML OUTPUT GRAMMAR PDF, available at http:/
/www.filemaker.com/documentation.
To create a Database Design Report:
1. Open all database files for which you want to produce a Database Design Report.
You must have full access privileges for any file for which you want to produce a Database
Design Report and the file must be open in FileMaker
Pro Advanced. You can run a Database
Design Report on local or remote files.
2. Choose Tools menu > Database Design Report.
3. In the Available Files list, clear any files that you want to exclude from the report by
clearing the checkbox associated with the file.