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 file format
It is possible to export employee data from Alexis HR to Visma Agda / Agda PS in a *.xml file format. 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 .
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.
Current constraints for the export
Compensation
The current file only supports exporting compensations that is of the type "Monthly" payout period. If an employee has a compensation in another format the employee will be exported but not the compensation.
Data that is exported
The following data is present in the export file with the defined logic as described
Alexis Field | Agda Field | Example |
Organization/Organisation | FTG_NR | Hardcoded to “1” |
Employee Number | ANST_NR | 702 |
Birth date | FODELSEDATUM | YYYY-MM-DD |
Social security number | PERSNR | YYYYMMDDNNNN |
Last name | EFTERNAMN |
|
First name | FORNAMN |
|
Nationality | MEDBORGARSKAP | SE |
Work email | EMAILADRESS | |
Children | Narstaende | Child(s) name and birthdate |
Emergency contacts | Narstaende | Emergency contact(s) full name, email and phonenumber |
N/A | UTBETALNINGSTYP | Hardcoded :Löneutbetalning |
N/A | UTBETALNINGSSATT | Hardcoded :Bankkonto |
Clearing number | CLEARINGNUMMER |
|
N/A | CHECKSIFFRA | If the Clearing number has more than 4 characters, the remaining characters are sent to this. |
Bank account | BANKKONTONUMMER |
|
N/A | ADRESSTYP | Hemadress or Mobiltelefon depending on what type. See below |
Work Phone | ADRESSTYP GALLANDE | Mobiltelefon False |
Work Phone | TELEFON | Work phone |
Home Address | ADRESSTYP GÄLLANDE | Hemadress true |
Personal - Street name | ADRESS |
|
Personal - Zip code
| POSTNR |
|
Personal - City | ORT |
|
Personal - Country | LAND |
|
Personal - Private phone | TELEFON |
|
Work - Title | BEFATTNING |
|
| BEFATTNINGSSTATUS | Hard coded to H |
Work - Office | TJANSTESTALLE |
|
Work - Department | AVDELNING |
|
Work - Reports to | ARBETSLEDARE |
|
Work - Cost center | PKONTERING2 = Cost center Code KORTNAMN = Cost center NAme | NAMN= hardcoded to "Kostnadsställe" |
Compensation
| FastaArter | We only send compensation that is defined as monthly in version 1
|
Employment start date | ANSTALLNINGSDATUM |
|
Employment end date | AVGANGSDATUM | Offboarding date, if it exists |
Reason for offboarding | AVGANGSORSAK | Frivillig or ofrivillig depending on offboarding reason, if it exists. |
Employment | Anställningsform | All employments are sent regardless if in the future or in the past.
|
Compensation ( Fasta Arter )
The current file only supports exporting compensations that is of the type "Monthly" payout period. If an employee has a compensation in another format the employee will be exported but not the compensation.
The monthly compensation is mapped to <LONEART>70</LONEART>.
Alexis will send all compensations when exporting the employee. In the example below all 3 compensations will be sent in the export.
Example of output of FastaArter on the above example
Example of output of FastaArter on the above example
<FastaArter>
<FastArt>
<LONEART>70</LONEART>
<AMOUNT>19000</AMOUNT>
<DATUM_UT></DATUM_UT>
<DATUM_IN>2024-01-01</DATUM_IN>
</FastArt>
<FastArt>
<LONEART>70</LONEART>
<AMOUNT>17500</AMOUNT>
<DATUM_UT>2023-12-31</DATUM_UT>
<DATUM_IN>2023-12-01</DATUM_IN>
</FastArt>
<FastArt>
<LONEART>70</LONEART>
<AMOUNT>15000</AMOUNT>
<DATUM_UT>2023-11-30</DATUM_UT>
<DATUM_IN>2023-10-01</DATUM_IN>
</FastArt>
</FastaArter>
Employment ( Anstallningar )
In the file we will always send all employments regardless if they are in the future or in the past.
The employment types in Alexis is mapped to the following employment types <anstallningsform> that needs to exist in Visma Agda
Alexis field | Visma Agda field | Comment |
Permanent employment | Tillsvidareanställning |
|
Fixed-term employment | Vikariat |
|
Probationary employment | Provanställning |
|
Hourly employment | Timanställning |
|
Consultant | Uppdragstagare |
|
Special fixed-term employment | Fri visstidsanställning |
|
Internship |
| They are left blank. |
Temporary employment |
| They are left blank. |
Example of output of Anställningar on the above example
Example of output of Anställningar on the above example
<Anstallningar>
<ANSTALLNINGSDATUM>2022-09-28</ANSTALLNINGSDATUM>
<AVGANGSDATUM></AVGANGSDATUM>
<AVGANGSORSAK></AVGANGSORSAK>
<Anstallningsform>
<TILLTRADE>2024-02-01</TILLTRADE>
<TILLTRADETOM></TILLTRADETOM>
<ANSTALLNINGSFORM>Tillsvidareanställning</ANSTALLNINGSFORM>
</Anstallningsform>
<Anstallningsform>
<TILLTRADE>2024-01-01</TILLTRADE>
<TILLTRADETOM>2024-01-31</TILLTRADETOM>
<ANSTALLNINGSFORM>Tillsvidareanställning</ANSTALLNINGSFORM>
</Anstallningsform>
<Anstallningsform>
<TILLTRADE>2022-09-28</TILLTRADE>
<TILLTRADETOM>2023-12-31</TILLTRADETOM>
<ANSTALLNINGSFORM>Tillsvidareanställning</ANSTALLNINGSFORM>
</Anstallningsform>
</Anstallningar>
Example output
Click to view example output
Click to view example output
<Personer>
<Person>
<FTG_NR>1</FTG_NR>
<ANST_NR>1</ANST_NR>
<FODELSEDATUM>1920-07-04</FODELSEDATUM>
<PERSNR></PERSNR>
<EFTERNAMN>America</EFTERNAMN>
<FORNAMN>Captain</FORNAMN>
<MEDBORGARSKAP></MEDBORGARSKAP> <EMAILADRESS>[email protected]</EMAILADRESS>
<Adresser>
<Adress>
<ADRESSTYP>Hemadress</ADRESSTYP>
<GALLANDE>true</GALLANDE>
<ADRESS>New street</ADRESS>
<POSTNR>12345</POSTNR>
<ORT>Amsterdam</ORT>
<LAND>GL</LAND>
<TELEFON>+4600000001</TELEFON>
</Adress>
<Adress>
<ADRESSTYP>Mobiltelefon</ADRESSTYP>
<GALLANDE>false</GALLANDE>
<ADRESS></ADRESS>
<POSTNR></POSTNR>
<ORT></ORT>
<LAND></LAND>
<TELEFON>+46701234567</TELEFON>
</Adress>
</Adresser>
<Narstaende>
<Narstaende>
<NARSTAENDENAMN>The youngest one</NARSTAENDENAMN>
<NARSTAENDEFODELSEDAG>2023-01-02</NARSTAENDEFODELSEDAG>
<NARSTAENDENOTERING>Barn</NARSTAENDENOTERING>
<NARSTAENDEVISAEJ>false</NARSTAENDEVISAEJ>
</Narstaende>
<Narstaende>
<NARSTAENDENAMN>Hailey Atwell</NARSTAENDENAMN>
<NARSTAENDEFODELSEDAG></NARSTAENDEFODELSEDAG>
<NARSTAENDENOTERING>Tel: +4612345678, Email: [email protected]</NARSTAENDENOTERING>
<NARSTAENDEVISAEJ>false</NARSTAENDEVISAEJ>
</Narstaende>
</Narstaende>
<Bankkonton>
<Bankkonto>
<UTBETALNINGSTYP>Löneutbetalning</UTBETALNINGSTYP>
<UTBETALNINGSSATT>Bankkonto</UTBETALNINGSSATT>
<CLEARINGNUMMER>1234</CLEARINGNUMMER>
<CHECKSIFFRA>5</CHECKSIFFRA>
<BANKKONTONUMMER>1234567890</BANKKONTONUMMER>
</Bankkonto>
</Bankkonton>
<Konteringar>
<Kontering>
<PKONTERING2 NAMN="Kostnadsställe" KORTNAMN="The first cost center">The Code</PKONTERING2>
</Kontering>
</Konteringar>
<Befattningar>
<Befattning>
<BEFATTNING>The New Rocket</BEFATTNING>
<BEFATTNINGSSTATUS>H</BEFATTNINGSSTATUS>
</Befattning>
</Befattningar>
<Organisationer>
<Organisation>
<TJANSTESTALLE>San Francisco</TJANSTESTALLE>
<AVDELNING>Department 1</AVDELNING>
<ARBETSLEDARE>Captain Marvel</ARBETSLEDARE>
</Organisation>
</Organisationer>
<FastaArter>
<FastArt>
<LONEART>70</LONEART>
<AMOUNT>15000</AMOUNT>
<DATUM_UT></DATUM_UT>
<DATUM_IN>2024-01-01</DATUM_IN>
</FastArt>
<FastArt>
<LONEART>70</LONEART>
<AMOUNT>9999</AMOUNT>
<DATUM_UT>2023-12-31</DATUM_UT>
<DATUM_IN>2022-05-30</DATUM_IN>
</FastArt>
</FastaArter>
<Anstallningar>
<ANSTALLNINGSDATUM>2022-09-28</ANSTALLNINGSDATUM>
<AVGANGSDATUM></AVGANGSDATUM>
<AVGANGSORSAK></AVGANGSORSAK>
<Anstallningsform>
<TILLTRADE>2024-02-01</TILLTRADE>
<TILLTRADETOM></TILLTRADETOM> <ANSTALLNINGSFORM>Tillsvidareanställning</ANSTALLNINGSFORM>
</Anstallningsform>
<Anstallningsform>
<TILLTRADE>2024-01-01</TILLTRADE>
<TILLTRADETOM>2024-01-31</TILLTRADETOM><ANSTALLNINGSFORM>Tillsvidareanställning</ANSTALLNINGSFORM>
</Anstallningsform>
<Anstallningsform>
<TILLTRADE>2022-09-28</TILLTRADE>
<TILLTRADETOM>2023-12-31</TILLTRADETOM><ANSTALLNINGSFORM>Tillsvidareanställning</ANSTALLNINGSFORM>
</Anstallningsform>
</Anstallningar>
</Person>
</Personer>