What is an interface in relation to FileMaker?
A interface is the generic term for the exchange of data between different systems. Most software programs have various interfaces. If you export data from FileMaker in a text or Excel format and open it in another program, your exported data is an interface between FileMaker and the other program.
Interfaces can be realized in various ways. The most common interfaces allow data to be exported in various text formats and re-imported into the target system in a compatible format. Interfaces can also be integrated directly into the systems and then exchange data with each other via a direct connection. A prominent example of such an interface is an online store interface that can directly access the corresponding store system. An example of a very simple interface is a barcode: After you have scanned it, the corresponding key stored in the barcode appears in the database.
The business software gFM-Business has numerous interfaces to third-party systems. First of all, by clicking on the [Export] symbol in the toolbar, each mask allows the data export of all data belonging to the mask in individual formats. During the export process you have the possibility to determine the fields and field sequence of the data to be exported. You can choose to export the desired data in the following formats:
- Tabulator separated text (.txt)
- Comma separated text (.csv)
- DBase (.dbf)
- Microsoft Word serial letter (.mer)
- HTML table (.htm)
- FileMaker Pro (.fmp12)
- XML (.xml)
- Microsoft Excel table (.xlsx)
Furthermore, gFM-Business contains the following additional interfaces for data exchange with other systems:
- German Post Internet stamp
- DHL Intraship recipient addresses
- DHL online franking
- DPD DELISprint
- GLS CSV
- Hermes address import
- Iloxx address export
- UPS WorldShip
- DATEV (EXTF/CSV)
- DTAUS file
- Bank X Online Banking
- MacGiro Online Banking
- Gambio GX3 Online shop
- Shopware Online shop
- WooCommerce Online shop
- Support TWAIN-compliant scanner
- support of telephone systems and Fritz!Box
What is a value list in FileMaker?
A value list in the FileMaker environment is a list of values that can be used within the FileMaker solution, for example in drop-down lists, pop-up menus or checkboxes. A value list can consist of either predefined static values or dynamic values generated from the database itself. The definition of value lists in FileMaker is done under the menu item [File > Manage > Value lists]. Read more >>>