Export Records


The Export Records function can be found under the File menu in the LandView® database. It will allow you to export records in the currently opened file to a variety of formats including: DBF Files, HTML Table Files, FileMaker Pro Runtime Files, Tab-Separated Text Files, and Comma-Separated Text Files. If you have performed a Find, then only those records found will be copied.

For example you may have performed a Find on how many tracts in New Castle County, Delaware have less then 2,000 people. To export the 20 records that were found you would:

  1. Choose File menu - Export Records.

  2. In the Export Records to File dialog box, type a name and select a location for the file. Important:   If another file with the same name already exists in the same location, this new file replaces the existing file.

  3. Choose a file type from the Save as type list (Windows) or the Type list (Mac OS), then click Save. Use a file format supported by the application in which you plan to use the exported data.

  4. In the Specify Field Order for Export dialog box, indicate how you want FileMaker Pro to export the data.

  5. To:

    Include a field in the export
    Double-click the field name to move it to the Field Order list. To export all fields, click Move All.

    Include a related field in the export
    Choose a relationship from the relationship list, then move fields to the Field Order list. You can include related fields before, after, or between fields in the master file.

    Prevent data in a field from being exported
    Select a field in the Field Order list, then click Clear. To move all fields out of the list, click Clear All.

    Change the export order of the fields
    In the Field Order list, point to the double arrow to the left of the field name and drag it up or down.

    Use a different character set in the exported file (Windows only)
    Choose an item from the Character Set drop-down list.

  6. Select an option for formatting the exported data:

    Click Don't format output to export data exactly as it is typed in the field (for example, export 3.7 even if the field is formatted to display on the current layout as $3.70).

    Click Format output using current layout to use number, date, and time field formatting as specified for the included fields on the current layout. Symbols and other non-numeric values are exported as text. (For example, export $3.70 if the field is formatted to display this way on the current layout, even if the field actually holds 3.7.) You can't select this option for SYLK, DBF, or DIF formats.

  7. Click Export.

To use an exported file: Open an application that can read the file format, and then open the file.

Back to Table of Contents