Skip links

Import customers and articles into gFM-Business

Importing data from external files

Import of customer and article dataSince version 1.7.5 of the CRM- and merchandise management system gFM-Business, customer and article data can be imported from external files and optionally from a Gambio-based online store into the gFM BusinessDatabase import. The files to be imported can be in tab and comma-separated text format, in Excel format (.xls or .xlsx) or in dBase format (.dbf). In principle, the files do not have to have a specific field format, as the import sequence of the fields can be freely defined by the user during the import process. However, data import is easier if the data is in the same format as the sample files, which are stored in the document directory [Export] are supplied with gFM-Business. In this short article we explain step by step how you can import customer addresses and article data from external files into gFM-Business.

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].

Importing data from external filesNow select the function at the bottom left of the main mask menu [Import data] and a popover dialog opens asking from which data source the data should be imported.

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.

Import dialog for adjusting the field sequence

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].

Importing data from external filesNow select the function at the bottom left of the main mask menu [Import data] and a popover dialog opens asking from which data source the data should be imported.

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.

Import dialog for article master data

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.

Field sequence for exporting data from gFM-Business

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.

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: Importing customer and article data into gFM-Business