The company import is available through a wizard in the eRecruiter backend (.../Modules/Import/Companies) if you have the permissions to import data.
General data structure
- One account has many locations.
- One location can have none, one or more contacts.
- A contact must be assigned to one location.
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.
...
Internal name | Name | Description / Possible values |
---|---|---|
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. |
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-Adresse | Used as identity column |
ContactPhone | Telefon | Used 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:
...
Matching of columns
The column names in the first row (header row) of the input file are compared with the internal names or the names (see the table above) and are preselected in the wizard's dropdowns if any match was found.
Duplicates
There is an automatic duplicate check during the importing process. Duplicate companies, locations or contacts will not be created; also existing information will never be overwritten, but missing information will be added to existing companies, locations or contacts when it exists in the import file.
Import
When importing a company a history entry with type "Create" and subject "Company created" is created.