Applicant Import
The applicant import is an open source command line tool and can be found at https://github.com/eRecruiter/eRecruiter.ApplicantImport.
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 applicant properties.
The import allows columns to have multiline values. The multiline values 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.
Example-file:
Not supported characters
The quotation mark (") is not allowed in a value, because it encloses column values with multiline values.
Required fields
The import file must contain the columns FirstName, LastName.
Possible columns
| Column type | Name | Possible values / Input format / additional information |
|---|---|---|
Gender | Gender | male: "H", "M", "Herr", "Mr", "1" / female: "F", "W", "Frau", "Ms.", "Mrs.", "0" |
FirstName | First name | must never be empty |
LastName | Last name | must never be empty |
Title | Title | based on the mandator settings "title before name" or "title after name" is automatically set correctly. |
| E-mail address | must be a valid email-adress | |
| Phone | Phone number | |
| MobilePhone | Mobile phone | |
| Street | Street (address) | |
| ZipCode | ZIP code | |
| City | City (address) | |
| Country | Country (address) | must be an existing value to be valid |
| Nationality | Nationality (citizenship) | must be an existing value to be valid |
| Birthdate | Date of birth | use DateFormat to specify the date format, default is yyyy-MM-dd |
| Cv | CV | must be empty or a path to an existing file. allowed file extensions are: "doc", "docx", "pdf", "txt", "rtf", "odt", "xls", "xlsx" |
Photo | Photo | must be empty or a path to an existing file. allowed file extensions are: "jpg", "jpeg", "png", "bmp" |
Document | Document | must be empty or a path to an existing file (to import single file) or directory (to import all files in directory). Also, configuration for |
JobProfile | Job profile | must be an existing value to be valid |
| Region | Region | must be an existing value to be valid |
BeginDate | Earliest possible begin date | use |
| Id | Applicant identifier | This is actually a "magic column". If it is specified (and contains a valid applicant #), existing applicants will be updated instead of newly created. This is very handy if you want to bulk-add information to already existing applicants. |
| CareerLevel | Career level | must be an existing value to be valid |
Referrer | Bewerberquelle | must be an existing value to be valid |
| ReferrerAdditionalInfo | Referrer additional information | if present, a column for Referrer must be present as well |
Knowledge | Knowledge | configuration for |
CreationDate | Date of creation | use |
| ImportantInfo | Important information (about applicant) | If present the current date and time is used for the date of this information. |
Classification | Classification | must be an existing value to be valid. If present the classification date is set with the current date & time. |
| ClassificationReason | Classification reason | if present, a column for Classification must be present as well. |
CustomField | Custom field | configuration for If custom field type is CheckBox the allowed value for true is "X" and for nothing for false. |
History | History entry | |
| Ignore | Ignore | Specifically configure columns that should be ignored at all |
Matching of columns
The column names in the first row (header row) of the input file must be mapped to the appropriate column type in a configuration file. This configuration file is a JSON file and must contain the API connection settings and the column mappings like in the code block below.
Duplicates
Not possible with this applicant import.
Import
When importing an applicant a history entry with type "Editing" and subject "Applicant updated" is created.
When importing more than 30.000 applicants, please inform our support.