Jump to content
  • 0

Filemaker Export


GWS

Question

2 answers to this question

Recommended Posts

  • 0

Filemaker Pro > Help:

Importing data into FileMaker Pro

When you import data, you?re bringing data from another data source (usually a file) into an existing FileMaker?Pro file. If you want to create a new FileMaker?Pro file from another data source, see Converting a data file to a new FileMaker Pro file.

FileMaker?Pro can import many different file formats. For a list of file formats that FileMaker?Pro supports, see Supported import/export file formats.

____

Supported import/export file formats

FileMaker Pro and many application programs that you want to exchange data with use a proprietary file format. In order to exchange data, you must export the data from one application in a format that the other application can import. If you?re exchanging data with another application program, check the documentation that came with that program to determine a common intermediary file format that both FileMaker Pro and the other program supports.

FileMaker Pro supports the import/export file formats listed in the following table. FileMaker both imports and exports most formats, but a few formats are either import/convert only or export only.

Most file formats support data conversion only and do not import or export formatting such as font, size, style, and color. Some of the formats export or convert field names and field types. For details on a particular format, click its link in the following table.

Supported

format

Filename

extension

Import/convert

or export

Notes

Comma-Separated Text format

.csv or .txt

Both

?

Works with BASIC programs and applications like Bento.

?

Format is also called Comma-Separated Values (CSV).

FileMaker Pro format

.fp7

Both

?

Import from previous versions (3.0 and later) after you convert the file to the current file format.

?

Export to the current FileMaker Pro file format.

?

Format retains field names.

HTML Table format

.htm

Export only

?

Exports data as an HTML table for use as a static web page.

Merge format

.mer

Both

?

Good export format for creating form letters in a word processor.

?

Format retains field names.

Microsoft Excel format

.xls or .xlsx

Both

?

Microsoft Excel 2008 for the Mac OS X supports the same file format (.xlsx) as Microsoft Excel 2007 for Windows.

Tab-Separated Text format

.tab or .txt

Both

?

Works with most applications. If you aren't sure which format to use, try this one first.

XML format

.xml

Both

?

In addition to XML files, you can import the XML data result of an HTTP request.

You can also do the following:

?

Import image files or text files from a folder all at once. See Importing a folder of files all at once.

?

Mac OS: Import photos from a digital camera. See Importing photos from a digital camera or other device (Mac OS).

?

Mac OS: Import from Bento data sources. See Importing Bento data (Mac OS).

?

Import from ODBC data sources and use FileMaker Pro as ODBC data source to serve FileMaker Pro data. See Querying an ODBC data source from FileMaker Pro and Sharing FileMaker Pro data via ODBC or JDBC.

?

Publish FileMaker Pro database files to a web page. See Publishing databases on the web.

?

Save a layout as a PDF file that can be used later as a blank form. See Saving and sending records as a PDF file.

____

If FileMaker?Pro does not support the format of a particular application, you may still be able to convert the data by exporting data from that application in a format that FileMaker?Pro does support. For example, FileMaker?Pro does not import Microsoft Access files, but you can export the data from Microsoft Access to a format that FileMaker?Pro does support, and then import that file.

The source file does not need to have the same number of fields in the same order as the target file. During the import process, you can arrange the target fields so that the source data imports into the correct fields, as well as skip fields that you don?t want to import.

When you import data into an existing FileMaker?Pro file, you can:

???

add new records from the source file

???

update records with information from the source file

???

update matching records with information from the source file

Important??Some of the above options can overwrite existing data in your file. For more information, see Methods of importing data into an existing file.

Notes

???

You can import data from any field type into any compatible field except calculation and summary fields. You can only import into container fields if you're importing from another FileMaker?Pro file, importing photos from a digital camera or other device, or importing a folder of image files. When you import data into a global field, the last item imported into the field from the source file determines the global field value.

???

You can only import data into a single table at a time. To import data into related fields, import data directly into the table that contains the related field.

???

If the source file is a FileMaker?Pro file with multiple tables, you can only import data from a single table at a time. To import fields from related tables, import directly from the table that contains the field.

???

To ensure that imported data is correctly formatted, you can define fields so that data is validated as it is imported. During import, data is skipped when it does not conform to the validation options you set. Once the import is complete, a Summary dialog reports the number of skipped records and fields. For more information, see Defining field validation.

???

If you routinely import data from the same source, you can create a script that uses the Import Records script step to automate the process. For more information, see Creating scripts to automate tasks and Import Records script step.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...