The Basic Mechanics of Exporting

The basic principles of exporting data from FileMaker are straightforward. You first pick a single table from which to export. (You cannot independently export data from two tables at once, although you can export related fields to any extent you want, a topic discussed in more depth later in this chapter.) You then choose an output file format and file location, and pick specific fields from your chosen table for export. Before you export, there are a few extra options you can choose that govern grouping and formatting of the exported data. That's all there is to it. Let's look at each step a bit more closely.

Choosing a Source Table

As with much else in FileMaker 8, the starting point for a data export is determined by the user's context in the current systemspecifically by the currently active layout, which in turn is tied (via its table occurrence) to an underlying data table (aka source table). So the currently active layout controls implicitly which table is the source table for the export.

Choosing an Output File Format

After your context is established, you'll need to choose File, Export to begin the export process. The next step in that process is to choose an output file format and file destination. FileMaker offers you a choice of 12 export formats, as shown in Figure 20.1. Some of these are plain-text formats, such as tab-delimited text, which could be read in any text editor; others are binary file formats that require more specific software to open, such as FileMaker Pro. This chapter goes into greater detail on available file formats in a later section.

Figure 20.1. FileMaker Pro can export data to various formats.

Selecting Fields to Export

After you've selected an output file type and destination, you'll be prompted to choose some fields to export, via the dialog shown in Figure 20.2.

Figure 20.2. Most fields can be exported from a FileMaker database, but container fields cannot.

In addition to selecting fields for export, it's also possible to select grouping options for the fields, and to choose whether to format the exported data according to the current layout formats. These options, too, are discussed in more detail later in this chapter.

At any point in the field selection process, you can use the small up/down arrows beside each selected field name to change the order in which the fields are exported: Click the arrow and drag to move the field, or use (-up/down) [Ctrl+up/down] if you prefer the keyboard. After you have a satisfactory field list, click Export, and the data will be exported to the file format and location of your choice.

Exporting Issues to Consider

Although the basic mechanics of exporting are simple, there are a couple of key points that bear remembering:

• To export data from a file, a user must have sufficient privileges to do so. This is governed by selections within the user's privilege set. The user must have the Allow Exporting check box checked within the settings for her privilege set. Additionally, the user will not be able to export any records for which she does not have at least the capability to view the record.

  For more information on privileges and security in FileMaker, see Chapter 12, "Implementing Security," 325.

• Data will be exported only from records in the user's current found set. To export data from all records in a table, it's necessary to first run Show All Records to ensure that no records are omitted from the found set. Regardless of the found set, any records that the user's privileges prevent her from viewing cannot be exported.
• There are certain practical limits on which fields you can export. Container fields can be exported only if the target file format is a FileMaker Pro file (we discuss other strategies for exporting files in container fields later in the chapter). And there are certain fields, such as summary or global fields, that it may not always make sense to export, even though it's technically possible.