Operation and implementation of the connector with Stairwage
How the integration works
-
-
- Solutions involved: Poplee Core HR
- Type of integration: flat file
- Integration direction: Lucca to Stairwage
-
Setting up the integration
To perform the integration, the Lucca database administrator will need to set up an FTP.
You will need to configure your HR file with the data below. The data is necessary for the correct functioning of the connector. The export will be sent automatically at a time set by you (we recommend during the night, 3am for example).Â
This implementation requires a modification of the settings on Lucca:
- creation of a user export in the format required by Stairwage
- creation of a section in the HR file with the necessary data for Stairwage
When sending employee data to Stairwage, a dedicated section must be created in the employee's HR folder with the following mandatory data:
-
- Establishment (Name)
- Employee Number
- Last name
- First name
- Annual salary (create a number with comma)
- Contract start date
- Contract end date (if available)
- Date of birth
- Professional or personal email
- IBAN
- Address
- City (create a text data type)
- Zip code (create a text data type)
- Professional or personal email
The settings in the PSRH export must be done in this order:Â
Lucca data | Export code |
Establishment (Name) | employer |
Employee Number | sharedId |
Last name | last name |
First name | firstName |
Annual salary | base-salary |
Contract start date | contract-start-date |
Contract end date | contract-end-date |
Date of birth | date-of-birth |
Professional or personal email | mobile-phone-number |
IBAN | iban |
Address | address |
City | city |
Postal code | zip-code |
Professional or personal email |
Here is an example of the expected file Export_Stairwage
The export configuration must be:
- Generic CSV format
- Date format dd/MM/yyyy
- Decimal point separator: comma
- Field separator: semicolon
- File type: CSV file
- select "Generate header row" Data code
V- Set up the transfer on an FTP folder
You can read these help sheets to help you set up your export:
Update data via an import
If you need to update employee data in bulk, please refer to the relevant page: Importing employee data