How the connector works and how to set it up with Deel
How integration works
-
-
- Solutions concerned: Core HR and Payroll
- Integration type: Flat file
- Sense of integration: Lucca to Deel
-
Foreword
Setting up an FTP
To set up the integration, the administrator of the Lucca database must set up an FTP . This will automatically synchronize data on users, establishments and salaries.
Setting up the integration
1. Export of employee data
When sending employee data to Deel, an export must becreated that includes the following data:
-
- Payroll number
- Address
- Zip code
- First name
- Last name
- Country of residence
- City
- Job title
- Date of effect
- Business email
- Contract start date
- Full-time equivalent (value to be created in exports)Â
- Full-time (drop-down list to be created in export)
- Contract start date
To help you, you can consult these two help sheets:
The settings for this export must be as follows:
-
File templates:
- File name: data_{{config.name}}_{{export.date}}_{{export.hour}}_{{export.period}}
- Format : CSV
- Encoding: UTF-8 without BOM
- Culture: English
- Date format: MM/dd/yyyy
- Field separator: Semicolon
- Decimal separator: Dot
- Include in export file: check âOnly modified employeesâ and âEmployees created and updatedâ
- File structure
Lucca Data / Body | Header | Comment |
Payroll number | employeeNumber | Â |
Address | addressLine1 | Â |
Zip code | zip | Â |
First name | firstName | Â |
Last name | lastName | Â |
Country of residence | country | Â |
City | city | Â |
Job title | jobTitle | Â |
Date of effect | jobEffectiveDate | Â |
Business email | workEmail | Â |
Contract start date | startDate | Â |
Full-time equivalent | fte | the data must be between 0.1 and 1 |
Job type | employmentType | the data must be Full Time or Part Time |
Contract start date | employmentEffectiveDate | Â |
Establishmentâs city | localization | Â |
Update data via import into Lucca
If you need to update employee data en masse, please refer to the dedicated sheet: Importing employee data
2. Export of establishments
Another export must be configured to import establishments from Lucca to Deel.
The settings for this export must be as follows:
-
File templates:
- File name: establishment_{{config.name}}_{{export.date}}_{{export.hour}}_{{export.period}}
- Format : CSV
- Encoding: UTF-8 without BOM
- Culture: English
- Date format: MM/dd/yyyy
- Field separator: Semicolon
- Decimal separator: Dot
- Include in export file: check âAll employeesâ.
- File structure
Lucca Data / Body | Header |
Establishment code | companyId |
Establishment name | companyName |
3. Export of payroll
To send payroll data, you will need to create a generic payroll export.
In terms of settings, here are our recommendations:
- In the Export scope, select the establishments and population concerned, as well as the fixed and variable payroll elements to be exported to Deel. The configuration name must be Compensation export
-
In Export data and format, you can select the "Institution (code)", "Employee (payroll number)" and "Employee (login)" fields to be included in the export.Â
Check the box âShow only active natures linked to the establishments in this exportâ
-
-
- File name: compensation_$[configName]_$[exportDate]_$[exportPeriod]
- Format : CSV
- Encoding: ANSI
- Date format: MM/dd/yyyy
- Field separator: Semicolon
- Check the Use inverted commas (ââ) box to force text format in the generated file
-
- In Automated exports, configure FTP export with only the export file(s)
To help you, you can consult these two help sheets: