Importing items into the employee record
This article is intended for:
Module concerned:
Eurécia allows you to perform bulk imports of data into the employee record. For example, you can import several employees with a single click, or add the IBANs of all your employees to Eurécia.
This feature can be very useful when you need to make numerous changes.
Contents of this article:
Preparing the file to import
1/ Retrieving existing data
It is easier to download the file containing the existing data directly from Eurécia and modify this file, which will serve as the basis for your import.
Access: Admin area > General settings > Employees and users
- Click on '... >Export Excel'
- Select “Full employee export”
- Save this file in CSV format (separator: semicolon) (*.csv) using the “Save as” function
Warning! To import data into the employee record, you must have subscribed to the HR Portal module.
Otherwise, only information from the employee record can be imported.
2/ Modifying the file
- In this file, keep only the sheet (tab) containing the column or columns to be modified
- In the remaining sheet, delete all columns that are not required.
⚠️ Warning!
The import key is the employees' email address or employee number. It is therefore necessary to leave at least one of these two columns in the import file.
- Modify or add the data you want
- Save (in .csv format)
Warning!
- Some fields available for export cannot be imported.
- The following fields are only available for import for customers using “the new employee record” and not the employee record:
- RQTH worker, Disability percentage, RQTH end date
- Active health insurance, Health insurance end date
- Active health and welfare cover, Name of the health and welfare cover
- Shoe size, trouser size, shirt/jacket size.
Please do not hesitate to contact us for more information.
3/ Prerequisites
Most importable fields are “free-form”. The system will import what you enter in your file without any format constraints.
To import your file successfully, here is some important information:
- Departments, organisations, profiles (users, leave, etc.) and working hours must be created before the import and must be entered using their CODE and name or label.
- Checkboxes such as “is a user” or modules to be activated must be entered as follows:
- 1 = box checked
- 0 = box unchecked
- Some fields must be filled in with codes so that they can be correctly interpreted by the system. You will find the associated codes in the template file attached to this article.
Importing the file
Access: Admin area > General Settings > Manual data import
- Click on “New”
- Select the import type “Users” from the drop-down list
- Click on “Import a file”
- Enter a description, then select the .csv file to import
- Choose whether to perform the import using “Employee number” or “Email”, depending on the column retained in the file
- Click on “STEP 3 - Upload the file”
Associating fields
The next page allows you to associate each platform field with a column in the file. You must associate each useful column in your file with a platform field.
The preview column shows the first row of the column (excluding the header) so that you can check that the association is correct.
At the bottom of the page, you can:
- Click on the “Preview” button to check that the entire import will proceed correctly. If there are any errors, they will be listed individually, line by line
- Click on the “Start import” button: the employee records will be updated with the modified data
You will find an example of a file to import into Eurécia attached to this guide.
Support
Setting up the “manual data import” feature and the associated training are subject to a quotation. Please do not hesitate to contact us for more information!
Keywords: Imports · data · employee record · record · employee · users · file · update · import · user · employee · info · information · import · update · update · download · enter · bulk · several
Comments
Article is closed for comments.