
Import of customer addresses
To import customer addresses from an external file, first go to gFM-Business to
Customers > Overview
or in any other mask within the main module [Customers].

Attention: The mask main menu can only be called up if there is at least one data record in the database. If this is not yet the case, you must first create a new (empty) customer, which you can delete again after the import.
If you want to import data from an external file, leave the data source set to [File] and confirm the dialog with the button [Import data]. This opens a file selection dialog in which you can now select the file to be imported. Please take the data format of the file to be imported into account when making your selection and set this to the correct format before selecting the desired file:
- FileMaker Pro files (.fmp12, data in FileMaker 12 format)
- Tab-delimited text files (.txt or .tab, different character encodings possible)
- Comma-separated text files (.csv, various character encodings possible)
- Mail merge files (.mer, mail merge files from Microsoft Word)
- Excel 95-2004 Workbooks (.xls, files from older Microsoft Excel versions)
- Excel workbooks (.xlsx, files in the extended new Microsoft Excel format)
- dBase files (.dbf, files in dBase data format)
As soon as you have selected the desired file, a dialog for adjusting the field sequence and character encoding for the import appears.
In this dialog, you can adjust the field sequence for the import if you want to import files that are not in the standard format of gFM-Business. The left column contains the fields of the source file, the right column contains the fields from gFM-Business. You can move the fields in the right-hand column up or down to assign a field to another field from the source file. The arrow between the two columns means that the corresponding field will be included in the import. If a field is not to be imported, you can remove the arrow by clicking on it.
If there are field names in the first line of the source file, activate the option "Do not import first data record (contains field names)".
You can use the two page buttons below the left-hand column to navigate through the data records in the source file before importing. This is useful, for example, if you want to check whether the fields are imported in the correct character format. If you want to import data from a text file, the file may be available in different text encodings (e.g. Windows ANSI, ASCII DOS, UTF-8 etc.). When importing text files, the import dialog contains an additional radio button for selecting the desired character encoding. If you do not know the character encoding of your source file, you can find out the correct representation of umlauts by navigating through the data records of the source file and then setting the correct character encoding.
After confirming the import dialog with the button [Import] the address data from the source file is imported into gFM-Business.
Import of article master data
To import article master data from an external file, first go to gFM-Business to
Articles > Article master
or in any other mask within the main module [Article].

Attention: The mask main menu can only be called up if there is at least one data record in the database. If this is not yet the case, you must first create a new (empty) item, which you can delete again after the import.
If you want to import data from an external file, leave the data source set to [File] and confirm the dialog with the button [Import data]. This opens a file selection dialog in which you can now select the file to be imported. Please take the data format of the file to be imported into account when making your selection and set this to the correct format before selecting the desired file:
- FileMaker Pro files (.fmp12, data in FileMaker 12 format)
- Tab-delimited text files (.txt or .tab, different character encodings possible)
- Comma-separated text files (.csv, various character encodings possible)
- Mail merge files (.mer, mail merge files from Microsoft Word)
- Excel 95-2004 Workbooks (.xls, files from older Microsoft Excel versions)
- Excel workbooks (.xlsx, files in the extended new Microsoft Excel format)
- dBase files (.dbf, files in dBase data format)
As soon as you have selected the desired file, a dialog for adjusting the field sequence and character encoding for the import appears.
In this dialog you can adjust the field sequence for the import of article data if you want to import files that are not in the standard format of gFM-Business. The left column contains the fields of the source file, the right column contains the fields from gFM-Business. You can move the fields in the right-hand column up or down to assign a field to another field from the source file. The arrow between the two columns means that the corresponding field will be included in the import. If a field is not to be imported, you can remove the arrow by clicking on it.
If there are field names in the first line of the source file, activate the option "Do not import first data record (contains field names)".
You can use the two page buttons below the left-hand column to navigate through the data records in the source file before importing. This is useful, for example, if you want to check whether the fields are imported in the correct character format. If you want to import data from a text file, the file may be available in different text encodings (e.g. Windows ANSI, ASCII DOS, UTF-8 etc.). When importing text files, the import dialog contains an additional radio button for selecting the desired character encoding. If you do not know the character encoding of your source file, you can find out the correct representation of umlauts by navigating through the data records of the source file and then setting the correct character encoding.
After confirming the import dialog with the button [Import] the article data is imported from the source file into gFM-Business.
Export of data from gFM-Business
All data entered in gFM-Business can also be exported again in order to be able to edit the data in other programs, for example. All data records called up are always exported - so if you only want to export some of the data records, first make a corresponding selection.
To export data, the symbol [Export] is available. After clicking on this icon, a file selection dialog appears in which you specify the name of the file to be exported and the desired file format. Data can generally be exported in the following file formats:
- FileMaker Pro file (.fmp12, data in FileMaker 12 format)
- Tab-delimited text file (.txt or .tab, different character encodings possible)
- Comma-separated text file (.csv, various character encodings possible)
- Mail merge file (.mer, mail merge files from Microsoft Word)
- HTMLTable (.htm as HTML list for display in web browsers)
- Excel workbook (.xlsx, files in the extended new Microsoft Excel format)
- dBase file (.dbf, files in dBase data format)
After entering a file name for the file to be exported and selecting the desired file format, a dialog box appears in which you can specify the export field sequence.
We have already set up a standard export field sequence in all modules, which you can adapt or extend in this dialog. After confirming the dialog with the [Export] the desired data is exported to a new file in the file format of your choice.

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.



