Formatting Exported Data

Table of contents:

FileMaker maintains a distinction between the way data is stored in a field and the way it is displayed. For example, although all dates are stored internally as simple integers, they may be displayed in many different date formats, such as "1-3-2006." Or a number, stored internally with 17 digits of precision, may be displayed with just 3 or 4 digits. None of these display options has any effect on the data stored in the fieldthey simply affect the way the data is shown to the user.

On FileMaker layouts, these formatting options are governed by choices made via the Format menu, in Layout mode. Some of these formatting options can be made to carry through to data when it's exported. To do so, when specifying fields for export, check the box labeled Apply Current Layout's Formatting to Exported Data. When this choice is selected, any formatting options applied via the Number, Date, or Time formatting dialogs are preserved. Text formatting, even character-based formatting such as uppercasing, is not preserved. Date and time formatting may both be applied to a timestamp field, and will be carried through on export.


Not all export types support formatting data based on the current layout. The DBF and DIF file formats offer no support for additional formatting. The WKS format allows additional formatting for time and number fields, but not for date fields.

Exporting Related Fields

Part I: Getting Started with FileMaker 8

FileMaker Overview

Using FileMaker Pro

Defining and Working with Fields

Working with Layouts

Part II: Developing Solutions with FileMaker

Relational Database Design

Working with Multiple Tables

Working with Relationships

Getting Started with Calculations

Getting Started with Scripting

Getting Started with Reporting

Part III: Developer Techniques

Developing for Multiuser Deployment

Implementing Security

Advanced Interface Techniques

Advanced Calculation Techniques

Advanced Scripting Techniques

Advanced Portal Techniques

Debugging and Troubleshooting

Converting Systems from Previous Versions of FileMaker Pro

Part IV: Data Integration and Publishing

Importing Data into FileMaker Pro

Exporting Data from FileMaker

Instant Web Publishing

FileMaker and Web Services

Custom Web Publishing

Part V: Deploying a FileMaker Solution

Deploying and Extending FileMaker

FileMaker Server and Server Advanced

FileMaker Mobile

Documenting Your FileMaker Solutions

Using FileMaker 8
Special Edition Using FileMaker 8
ISBN: 0789735121
EAN: 2147483647
Year: 2007
Pages: 296 © 2008-2020.
If you may any questions please contact us: