GWS Posted September 4, 2010 Share Posted September 4, 2010 Does anybody know if there is any help or documentation on exporting a worksheet into Filemaker Pro? Quote Link to comment
0 islandmon Posted September 18, 2010 Share Posted September 18, 2010 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. Quote Link to comment
0 GWS Posted September 20, 2010 Author Share Posted September 20, 2010 Thanks Islandmon. Quote Link to comment
Question
GWS
Does anybody know if there is any help or documentation on exporting a worksheet into Filemaker Pro?
Link to comment
2 answers to this question
Recommended Posts
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.