Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 533
• To export only a portion of the records from the source FileMaker Pro file, perform a find
first. Only the records in the found set will be exported. See
Finding records.
• FileMaker Pro exports field names and field types to the exported file.
• Both Merge and FileMaker Pro formats include field names. However, the application into
which the data will be imported must support the format you choose. Some applications will
strip out the field names when importing the exported data.
• The exported file contains a single Standard form layout.
• Any global fields that you export are no longer global fields in the exported file. Instead,
each exported global field becomes a non-global field that repeats the global field value in
each exported record. If you wish, you can change the field to a global field in the exported
file.
Note To create a new file that contains the data, layouts, scripts, and other elements of the source
file, you may want to copy the file instead of exporting data. Then you can open the copied file and
make any changes you want to make, such as removing certain data. See
Saving and copying files.
HTML Table format
You can export data as an HTML table. This format is useful for displaying data as a static web page
in a web browser. For information on dynamically publishing a FileMaker
Pro database to the web,
see
Publishing databases with FileMaker WebDirect.
Exporting HTML files
• Each record exports as a row in the HTML table
• Each field exports as a column in the HTML table.
• Values in each repeating field are exported as a nested table containing one value per
column.
Merge format
You can import, convert, and export Merge files.
Converting Merge files to FileMaker Pro
• Field names are imported.
• All fields are text fields.
Exporting Merge files
FileMaker Pro exports a text file with the following characteristics:
• The character that separates fields is different depending on the language of your operating
system. On U.S. English systems, the field separator is a comma. On European systems,
the field separator character is a semicolon. The character may be different in other locales.
• Both Merge and FileMaker formats include field names. However, the application into which
the data will be imported must support the format you choose. Some applications will strip
out the field names when importing the exported data.
• Carriage return characters separate records.
• Field data is enclosed in quotation marks.
• The first record is a header that lists the field names.