Database Reference
In-Depth Information
Figure 21-10. When FileMaker exports the data, it includes each field in the right-hand list in the
export file. The order of the fields in this list determines their order in the export file, and you can
change it by dragging fields up or down in the list. To add every field in the field list to the export
order list, click Move All. Likewise, to remove all fields from the export order, click Clear All.
To choose a field for export, select it and then click Move, or just double-click it. FileMaker
adds the field to the “Field export order” list but doesn't actually move it there. It just stays
in the list of available fields. If you accidentally try to add a field to the Export order list
more than once, FileMaker will see that it's already there and silently decline to add it again.
NOTE
If a field isn't on the current layout, it doesn't show up in the list of available fields on the left side,
so if you're wasting time scrolling through fields that you don't need, you can cancel and then
switch to a simpler layout from the same table. But if you can't find a field that you
know
is in the
table, use the pop-up menu to choose Current Table. That way, you'll get a list of all the fields in the
table, regardless of which ones are on the current layout.
At the bottom of the window, the “Output file character set” pop-up menu lets you tell
FileMaker how to
encode
characters in the export file so the receiving computer can read
them properly. For instance, if you're using Mac OS X and you know the person receiving
the export file is using Windows, it probably makes sense to choose the Windows (ANSI)
choice. Unfortunately, the conversion from Macintosh to Windows or Windows to Mac is
imperfect, so some less-common characters may be switched out for others in the output file.
