This article describes the default fields for the Mepco person import type in CSV format. The Mepco person import type is primarily intended for CSV file format without a header row. However, all other file formats are supported, so the fields can be imported according to Person import guidance, and a header row can be defined in the scheduled task settings for person import. In that case the fields will be imported according to the listed header row fields instead of the order described below.
Fields
Below is a list of the special identifiers and behaviours of fields related to this import mapping. Additional person information fields can be imported using the general import documentation.
| Identifier | Import Column Index | Mapped to Nepton Field | Description |
|---|---|---|---|
| Username | 1 | Username | |
| Firstname | 2 | First name | |
| Lastname | 3 | Last name | |
| Employee Number | 4 | Employee number | |
| 5 | |||
| Cost Center | 6 | Person group | |
| ContractStart | 7 | Employment start date | |
| ContractEnd | 8 | Employment end date | |
| Worktime calculation group | 9 | Worktime setting group | |
| Primary supervisor | 10 | Primary supervisor | |
| Valid from | 11 | Valid from date | This field includes the work contract start date in Mepco. Changes during the work contract needs to be updated to Nepton |
Business logic
-
If using supervisor - import field instead of 'primary supervisor'
If a primary supervisor is set, it will replace existing primary supervisor assignments. Empty supervisors will not be imported.- The only way to empty a persons' primary supervisor assignment is using the RESET keyword
-
Extend working contract length
- If a person has an existing working contract start date, imported start date can zero out the existing start date value, but start date value can't be changed to another value
- If a person has an existing working contract end date, imported end date can zero out the the existing end date value, or change the end date value to later date, but end date value can't be changed to earlier date
- These limitations ensure persons who have multiple contract dates can be viewed and managed properly in the service