Format
The input file must be a tab-separated ("\t") Textfile in UTF8 format. The rows are separated by new line and the columns are separated by tab. You can generate the input file with e.g. Microsoft Excel => Export => Change file type (*.csv). The first row must have the name of the columns to be able to map the columns to the appropriate account properties.
The import allows one column to have a multiline value. The multiline value should be separated by usual CR, LF (\n\r) characters and must be enclosed in quotation marks ("). Microsoft Excel generates this format automatically when exporting to an Tab-separated value (TSV) file.
Not supported characters
The quotation mark (") is not allowed in a value, because it encloses column values with multiline values.
Folgende Daten können importiert werden:.
Required fields
The import file must contain the column CompanyName. If a location should be imported the columns LocationStreet, LocationZipCode and are necessary LocationCity. If a contact should be imported the columns ContactFirstName and ContactFirstName must be provided.
Possible columns
| Internal name | Name | Description / Possible values |
|---|---|---|
| Daten des Kunden | ||
| Name | Name des Kunden | Benutzerdefinierte Felder | Benutzerdefinierte Felder des Kunden
| Company data | ||
| CompanyName | Name | must never be empty. If empty company is ignored. |
| CustomField | Custom Field | Only custom fields with target "Account" are possible to import. |
| Daten des Kundenstandorts | ||
| Straße | Straßenname und Hausnummer des Kundenstandorts | |
| PLZ | PLZ des Kundenstandorts | |
| Stadt | Stadt des Kundenstandorts | |
| Daten des Ansprechpartners | ||
Geschlecht | Geschlecht des Ansprechpartners | |
| Vorname | Vorname des Ansprechpartners | |
Nachname | Nachname des Ansprechpartners | |
| Titel | Titel des Ansprechpartners | |
| Position | Position des Ansprechpartners||
| Company location data | ||
| LocationStreet | Straße | Street and street number / If not provided the location is ignored. Used as identity column. |
| LocationZipCode | PLZ | If not provided the location is ignored. Used as identity column. |
| LocationCity | Stadt | If not provided the location is ignored. Used as identity column. |
| Contact data | ||
| ContactGender | Geschlecht | male: "H", "M", "Herr", "Mr.", "1", "Mann" / female: anything else |
| ContactFirstName | Vorname | If not provided the contact is ignored. |
| ContactLastName | Nachname | If not provided the contact is ignored. |
| ContactTitle | Titel | |
| ContactPosition | Position | |
| ContactEmail | E-Mail-AdresseAdresse des Ansprechpartners | Used as identity column |
| ContactPhone | Telefon | Telefonnummer des Ansprechpartners |
| Benutzername | Benutzername des Ansprechpartners für das Kundenportal | |
| Passwort | Passwort des Ansprechpartners für das KundenportalUsed as identity column | |
| ContactUsername | Benutzername | The username of the contact for the account portal. |
| ContactPassword | Passwort | The password of the contact for the account portal. |
Allg. Infos zum Import:
- Bei einem Kunden können mehrere Standorte importiert werden.
- Für einen Standort können kein, ein oder mehrere Ansprechpartner importiert werden.
- Jeder Ansprechpartner muss aber einem bestimmten Standort zugeordnet werden.