Agda Visma / Agda PS INL Employee export

Modified on Fri, 2 May at 2:06 PM

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 Simployer One 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

Simployer One 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 Simployer OneHR. 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

3;EMPLOYEE;HOURLY;19900507-9018;SE;The other Street;Stockholm;21345;SE;work_hourly_employed_1717501049813@alexishr.com;+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.

Attachments (1)

Inl

Alexis_AGDAP....Inl
996 Bytes