metafresh logo and link to homepage

Format Example for the Import of Business Partner Data


For importing business partner data, you require an import format that is configured with the database table Import Business Partner.

The example below compares the data content of a file from a spreadsheet software (here, e.g., an Excel file before the conversion to a CSV or TXT file) with the import format for business partner data:

Explanatory Notes to the Example

Some useful notes

Information Example Note
Region • NRW
• AZ
NRW = North Rhine-Westphalia
AZ = Arizona
(You can look up the acronym (Name) of a region in the record tab “Region” of the respective country entry under “Country, Region” in the menu.)
ISO Country Code DE DE = Germany (German: Deutschland)
Two-letter country code (in acc. with ISO 3166-1 alpha-2).
(You can look up the ISO country code under “Country, Region” in the menu.)
Group Value • Standard
• 1000001
Search Key of the business partner group. Attention: Not the name!
First add the business partner group and then use the search key here.
(You can look up the search key in the respective entry under “Business Partner Group” in the menu.)
OrgValue metasfresh AG Search Key of the organization. Attention: Not the name!
(You can look up the search key under “Organization” in the menu.)

Next Steps

Zur Quelldatei auf