Skip to main content
All CollectionsOwner & Admin ManualsPeopleExport / Import
Visma Agda / Agda PS : AIM Employee export
Visma Agda / Agda PS : AIM Employee export

Information about exporting employee data to Visma Agda / Agda PS

Stephan Hale avatar
Written by Stephan Hale
Updated over 5 months ago

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

<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

<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

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

Did this answer your question?