Import applicant profiles from a CSV file into eRecruiter. You'll need an up-and-running eRecruiter API endpoint (eRecruiter version >= 2.5, API version >= 1.17) and the respective API key.
This nifty little tool builds automatically on every commit on GitHub using AppVeyor. You can download the latest build here: https://ci.appveyor.com/project/eRecruiter/erecruiter-applicantimport/build/artifacts
eRecruiter.ApplicantImport.exe --config=your_config_file.json --file=your_csv_file.csv
You'll need to specify a configuration file (contains API and column configuration) and a CSV file (contains the actual data to import).
Use optional parameter --continueOnWarnings
to automatically continue on warnings. This is useful when running as an automated job.
Use optional parameter --generateCsvStub
to create an empty CSV file based on the configuration specified. This will not import anything and is nothing but a helper to get started quickly with new CSV files. This CSV file will be created on the location specified with the --file
parameter.
Use optional parameter --logFile=log.txt
to output all messages/errors/warnings to a log file in addition to the usual output on the console.
Each applicant attribute corresponds to a column in your CSV file. At the moment, these attributes are supported:
- Gender:
Gender
- First name:
FirstName
- must never be empty - Last name:
LastName
- must never be empty - Title:
Title
- based on the mandator settings "title before name" or "title after name" is automatically set correctly. - E-Mail:
Email
- Phone:
Phone
- Mobile phone:
MobilePhone
- Street (address):
Street
- ZIP code:
ZipCode
- City (address):
City
- Country (address):
Country
- Nationality (citizenship):
Nationality
- Date of birth::
Birthdate
- useDateFormat
to specify the date format, default isyyyy-MM-dd
. - CV:
Cv
- must be empty or a path to an existing file - Photo (applicant portrait):
Photo
- must be empty or a path to an existing file - 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 forSubType
is required to specify the applicant document type. - Job profile:
JobProfile
- Region:
Region
- Earliest possible begin date:
BeginDate
- useDateFormat
to specify the date format, default isyyyy-MM-dd
. - Applicant #:
Id
- 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. - Career level:
Careerlevel
- Referrer:
Referrer
- Referrer additional information:
ReferrerAdditionalInfo
- if present, a column forReferrer
must be present as well. - Knowledge:
Knowledge
- configuration forSubType
is required to specify the knowledge. - Date of creation:
CreationDate
- useDateFormat
to specify the date format, default isyyyy-MM-dd
. - Important information (about applicant:
ImportantInfo
- Classification:
Classification
- Classification reason:
ClassificationReason
- if present, a column forClassification
must be present as well. - Custom field:
CustomField
- configuration forSubType
is required to specify the custom field. Also, configuration forDateFormat
is supported (if custom field is of typeDate
) - History entry:
History
- Ignore:
Ignore
- Specifically configure columns that should be ignored at all.
- None
For an example JSON configuration file that contains all supported applicant attributes, see example-configuration.json
Use UTF8 encoding and TAB-separated CSV. See example-data.csv for an example CSV file.