Note: This file is currently in BETA version and not available for all customers, please contact us if you are interested in learning more.
Visma Agda / Agda PS INL file format
It is possible to export employee data from Alexis HR to Visma Agda / Agda PS in a *.csv file format with using an *.inl file as definition in AGDA PS.
See end of article for example output
Export employees to Visma Agda / Agda PS
The employee export is made from People → Export/Import → Visma Agda INL .
When exporting you are giving the choice to export all active employees or to customize the report to only filter out a subset of employees (currently only organization available).
The file will then download and you can from then refer to the documentation for Visma Agda / Agda PS on how to import a xml file containing employee data.
Data that is exported
The following data is present in the export file with the defined logic as described
Alexis Field | Agda Field | Example |
Employee Number | ANSTNR |
|
Last name | EFTERNAMNSMÅ |
|
First name | FÖRNAMNSMÅ |
|
Social security number | PERSNR |
|
Nationality | MEDBORGARE |
|
Personal : Street name | ADRESSSMÅ |
|
Personal : City | ORT |
|
Personal : Zip code | POSTNR |
|
Personal : Address Country | LAND |
|
Work : Work email | EMAILADR |
|
Work : Work phone | TELEFON |
|
Work : Cost center | KONTRUB1 | Cost center for the employee (either inherited or defined) will be sent in the file as KONTRUB1 |
Financial : Tax table | TABELL |
|
Financial : Clearing number | CLEARINGNUMMER |
|
N/A | CHECKSIFFRA | If the Clearing number has more than 4 characters, the remaining characters are sent to this. |
Financial : Bank account | KONTONUMMER
|
|
Employment : Hire date | ANSTDATUM | Date of first employment |
Employment : Offboard date
| SLUTDATUM | The date the user is offboarded. |
Employment : Current employment effective date | TILLTRÄDE |
|
Employment : Current employment effective date | SYSSDATUM |
|
Work : Title | BEFATTNING |
|
Employment : Employment rate | SYSSGRAD |
|
- | DAGAR/VECKA | Hardcoded to 5 for now |
- | VECKARBTID | Hardcoded to 40 for now |
Work - Office name | TJSTALLE |
|
Work - Department name | AVDELNING |
|
Work - Report to managers name | ARBETSLEDARE |
|
- | SEMESTERAVTAL | Hardcoded to "Ingen beräkning" for now |
Office - CFAR number | CFAR |
|
Office - Work place number SCB | ARBSTÄLLENR |
|
- | PERSKAT_KLP | Hardcoded to 3 for now |
- | AMF | Hardcoded to 0 for now |
Custom field "Utbetalningsgrupp" | UTBETALNINGSGRUPP | Custom configuration, see below |
Custom field "Attestkod Tid" | ATTESTKOD_TID | The value from the selected custom filed will be included in the file. |
Custom field "Sociala avgifter" | SOCIALAAVGIFTER | The value from the selected custom filed will be included in the file. |
Custom field "AGI-typ" | AGITYP | The value from the selected custom filed will be included in the file. |
Custom field "Skattekod" | SKATTEKOD | The value from the selected custom filed will be included in the file. |
Custom field "verksamhetskod" | KONTRUB10 | The value from the selected custom filed will be included in the file. |
Custom field configuration
Some of the items needed for AGDA requires definitions that does not exist in Alexis HR. But if these are created as custom fields with the correct field names they are included in the file export.
Make sure that the custom field label matches the definitions above and that "Allow multiple values" is NOT checked.
It is then up to you to decide what should be sent as the value to be able to match your current configuration in AGDA PS
Example output
Click to view example output
Click to view example output
3;EMPLOYEE;HOURLY;19900507-9018;SE;The other Street;Stockholm;21345;SE;[email protected];+46704354543;Grupp 1;Agi typ 2;Sociala avgifter 1;Skattekod 1;32;3214;;6574634;20240401;;20240401;20240401;Permanent employment;;50;5;40;Stockholm;Stöd Online;The boss;Attest 2;Ingen beräkning;1234-1234;1;3;0
INL file
AGDA PS needs an INL file in order to know what items in the datafile should be positioned to. This also means that you in this file can decide
You can download the current INL file here.
The INL file needs to be in ANSI format (Windows 1252) so do not open in excel or similar because then the formatting might be lost.