HP Electronic Forms manual Exporting Records from FileMaker Pro, Import Field Mapping

Page 25

 

 

 

 

 

 

Index

 

Importing and

 

 

 

 

 

 

Electronic Forms User Guide

 

Exporting Records

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Import Field Mapping

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

View By:

Matching Names

 

 

 

 

 

 

 

 

 

 

Data in “134_146.FP3” Fields in “134_146 Copy.FP3”

 

Contractor

Street Address

City

State

Zip Code

Date

Contractor

Street Address

City

State

Zip Code

Date

 

Scan

 

Field Names

<<

>>

 

 

Data

 

 

Add new records

Replace data in current found set

Define Fields...

 

 

 

 

 

 

 

 

 

 

 

 

 

Import

 

Cancel

 

 

 

 

 

 

 

 

 

 

 

 

4.The fields in the source file will map to the fields in the destination file as shown in the list. You can drag the field names in the ‘Fields In’ list to change where FileMaker Pro maps data. Click the ‘Scan Data’ buttons to view data in the source file. By clicking the connection arrows between the fields, you can turn on or off the importing of data for those fields.

5.If the Destination file is a revised or updated version of the source file, or if the fields in both files are the same, click on the ‘Match Fields’ button to match the field entries.

6.Click ‘Add New Records’ to append the imported records to the end of the destination file or ‘Replace Data in Current Found Set’ to overwrite any existing records with the imported records.

7.Click on ‘OK’ and FileMaker Pro will do the rest.

Exporting Records from FileMaker Pro

Exporting records from FileMaker Pro to another application type is just as simple.

1. Open the source file - Locate the source file in the files list and click ‘OK’.

Some of the exportable file types are:

 

*.DBF = dBase III and IV

*.TAB & *.TXT = Tab-Separated Text

*.WKS & *.WK1 = Lotus 1.2.3.

*.CSV & *.TXT = Comma-Separated Text

*.SLK = Microsoft Excel

*.MER = Microsoft Word Merge Document

Page 11 - 2

Image 25
Contents Electronic Forms User Guide Welcome to Electronic Forms User Guide IIndex of Topicsi Windows Runtime Forms Optional Buttons Electronic Forms User GuideEnglish tric New Form Entering Information Electronic Forms User GuideCheck Boxes, Pop-up Menus, and Radio Buttons Text Formatting Electronic Forms User Guide Layout Status Area Browsing Records Electronic Forms User GuideLayout Dialog Box Browsing Records Electronic Forms User Guide Find Status Area Using Find ModeOmit Symbols DefinitionsWildcards Electronic Forms User Guide To sort records Sorting Records Electronic Forms User GuideFileMaker Pro has nine pull-down menus on the menu bar Form MenusFormat Printing Forms Selecting Print Options Troubleshooting Printer Problems Special Printing Requirements Str Cti s Layout ButtonsImporting Records into FileMaker Pro Exporting RecordsImport Field Mapping Exporting Records from FileMaker ProImporting and Exporting Selected or Sorted Records Supported Printers System SupportLong Print Times Printer / System TroubleshootingMulti-User Electronic Forms Appendix a Glossary of Terms Electronic Forms User Guide Glossary of Terms Electronic Forms User Guide Glossary of Terms Electronic Forms User Guide