This article is about importing a single file containing information about persons into Nepton service. More information about different methods of importing persons and technical details of the file formats can be found here.
Accessing the feature
Person data can be selected to be manually imported to Nepton via Employees section. If you have a single import file containing data of persons in supported format, you can select to import it manually under Employees > Persons > Import persons.
On first screen options to select a file are presented:
You can drag & drop the file using the file manager of your device (view depends on the operating system of your device):
Alternatively you can click the Choose file button and open the file from your device (view depends on the operating system of your device):
When you have selected the file, its name appears in the view:
If you chose a wrong file, you can remove the selection clicking the Remove icon next to the file name. You can then choose the correct file. Alternatively you can just choose a new file without removing the previous one and the previously selected file will not be imported - only one file can be imported at a time.
After you have selected the file, you need to provide details needed by service to interpret the values correctly:
Choose file encoding
Option for choosing file encoding is only available when the file being imported is of CSV format. This option defines the character set used for the file being imported. Possible options are:
- UTF-8
- ISO-8859-1
UTF-8 is a way of encoding Unicode character set, ISO-8859-1 is limited to common characters used in European languages. In general, the program or service you are creating the file with should provide the information about the encoding. If you choose a wrong encoding, latin characters with diacritics or characters for non-latin characters will probably appear incorrect.
Person import type
Person import type specifies the way the file contents are interpreted in Nepton. In general, Nepton recommends using the Default import type. It supports the most widest range of Nepton person information fields. More information about available fields for Default type are available here. Other types are for integrating with specific external systems or other special purposes. See linked pages below for each type for more information. All possible options are:
- Default
- Extend working contract dates
- Kieku (new accounts)
- Kieku (worktime rules)
- Mepco
- SAP
- SAP SuccessFactors
- Sympa
- Sympa HR Integration API
After you have selected the person import type, Nepton service will automatically do a preliminary analysis of the import file and present its results below the options. You can still choose the next option for changing the handling of the empty values in import file.
Empty values in import file
By default in manual person import, the fields that are empty in import file do not change existing field values. Using that option any existing values in Nepton service for persons being imported are preserved for all fields that have empty values in the import file.
Using option "Delete existing field values (Strict)" will force any existing values in Nepton service for persons being imported to be deleted from service if there are empty values in the import file for these fields.
Preliminary analysis
After you have selected the person import type, Nepton service will automatically do a preliminary analysis of the import file and present its results below the options:
If there are specific problems in one or several fields in the import file, warnings for these are presented here in yellow colour. For example:
These warnings indicate that certain fields cannot be imported to Nepton using the file. However, if no information about one or several persons can be imported, error messages for these are presented in red colour. For example:
Starting import
When you have reviewed the preliminary analysis and accept its results and there is at least some contents to be imported, you can start importing using the Import persons button:
If you chose the option that empty values will delete existing field values, you are required to confirm your choice after selecting the Import persons button.
After you select Confirm choice, the file contents will be imported to Nepton. If you select Cancel import, you can still change your selections.
Results
When the import operation has finished, the results for each imported entry are presented:
If there are problems but at least some information was successfully imported, warnings are presented in yellow:
If no information for one or more persons could be imported, error messages are presented in red:
Examples
Mass import supervisor information
There is a separate guidance page here with detailed information on how to import supervisor information using a spreadsheet program.
Add only new persons with mandatory information
An example of a CSV file to import initial mandatory information for new persons added to the system:
First name;Last name;Service usage language;Role
Hope;Hopeful;English;Employee
Dana;Dannerø;Danish;Supervisor
Matti;Meikäläinen;Finnish;Employee
Wojciech;Kozłowski;Polish;Employee
Sven;Svensson;Swedish;Employee
Ülle;Võsu;Estonian;Employee
Jakob;Hansen;Norwegian;Employee
As neither username nor employee number field is provided, the above will always add the persons as new to Nepton system even if persons with similar information were previously saved in the system.
Update worktime setting group codes for a number of persons
An example of an Excel file to update new worktime setting group codes for a group of people listed by their employee numbers:
The above will search for persons with employee numbers 101, 104, 106, 147 and 159 saved in Nepton and, if found, update their Worktime setting group code to be C100. As not all mandatory information is not provided, no new person will be added if person with the employee number given is not found.
Import empty values
An example of importing empty values for fields in CSV format. Persons are identified with the Username given. The field Additional administrative information is provided as empty:
Username;Employee number;Additional administrative information;Role
Hope Hopeful;101;;Employee
Dana Dannerø;102;;Supervisor
Matti Meikäläinen;104;;Employee
Wojciech Kozłowski;106;;Employee
Sven Svensson;147;Sven;;Employee
Ülle Võsu;159;Ülle;Võsu;;Employee
Øyvind Thorsen;168;;Supervisor
If this import file is imported with default option "Do not change existing field values (Safe)", any existing additional administrative information will still be found in Nepton after import. However, if the Additional administrative information field needs to be cleared for these persons, the option "Delete existing field values (Strict)" must be selected in the import options.