Getting Out What You Put In

Much of this book concentrates on tools for data entryfor getting data into a database system. But that information often needs to be extracted again. Sometimes the extraction takes the form of a report of some kind. At other times the best choice is simply to export the data into some specific format so that another program can import that data and work with it using different tools than might be available in FileMaker. Reasons for exporting might include the following:

  • Perhaps you know someone who is compiling a quarterly report in Excel and needs some numbers from your FileMaker system.
  • Perhaps the new accounting system needs transaction data from FileMaker, and likes to receive it in an XML format.
  • Perhaps you've been storing low-resolution images for an upcoming ad campaign in FileMaker, but you would like to make all the images available on a CD that can be used without FileMaker.

In this chapter we cover various means for getting data out of FileMaker. We discuss the traditional concept of exporting to other file formats, and we also cover the related topic of making FileMaker data available via an ODBC or JDBC connection. There are still other methods of extracting data from FileMaker, such as various web publishing methods, and the new Save Records as Excel and Save Records as PDF features, all of which are covered fully in other chapters.

For more on saving and sending records as Excel or PDF files, see "Delivering Reports," 298.

Additional information bearing on the topic of FileMaker web publishing can be found in Chapter 21, "Instant Web Publishing," p. 633; Chapter 22, "FileMaker and Web Services," p. 669; and Chapter 23, "Custom Web Publishing," p. 699.

 


The Basic Mechanics of Exporting

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

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net