Note: This file is currently in BETA version and not available for all customers, please contact us if you are interested in learning more.
X-ledger employee file format
It is possible to export employee data from Alexis HR to X-ledger in a *.csv file format. See end of article for example output
Export employees to X-ledger
The employee export is made from People → Export/Import → X-ledger .
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 X-ledger 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. Other fields are present in the file but are not populated. See example export for full list of "columns" exported.
Alexis Field | X-ledger field | Example |
Employee Number | Code | 20001 |
First name + Last name | Description | Kristin Sunde |
Employment types* | Employee Group imp* |
|
Same as column 2 : navn | Supplier Imp | Kristin Sunde |
First name | First Name | Kristin |
Last name | Last Name | Sunde |
First letter of first name+First letter of last name | Initials | KS |
Birth date | Date of Birth | 19631216 |
Social security number | Social Sec | 16126345788 |
Male or Female, if not set or “other” then send blank. | Gender | F |
Hire date | Employment From Imp | 19990518 |
Offboarded date. If it does not exist then send blank | Employment To Imp | 20101231 |
End date of probationary employment | Trial Date | Date |
”Frivillig” or “Ufrivillig” | Exit Reason Imp |
|
Cost center | Posting 1 | 2760 |
Private phone | Phone |
|
Work Phone | Cell Phone |
|
Work email |
| |
Private email | Email 2 |
|
*Employment types
Alexis employment types are mapped as follows for the X-ledger import.
Alexis Employment types | Employee Group imp |
Permanent | Fast ansatt |
Fixed-term Employment | Tidsbegrenset ansettelse |
Probationary Employment | Prøveansatt |
Hourly Employent | Timelønnet |
Consultant | Oppdrag |
Temporary Employment | Midlertidig ansatt |
Special Fixed-term employment | Spesiell tidsbegrenset ansettelse |
Internship | Praksis |
Example output
Click to view example header output
Click to view example header output
Code;Description;Employee Group Imp;Supplier Imp;First Name;Middle Name;Last Name;Initials;Alias Name;Prefix;Suffix;Date of Birth;Social Sec;Gender;Marital Status;Employment From Imp;Employment To Imp;Date From Imp;Date To Imp;Seniority Imp;Trial Date;Exit Reason Imp;Position Imp;Position Category Imp;Superior Imp;Timesheet;Overtime;FlexTime;TimeBased;Dummy Imp;Posting 1;Posting 2;XGL;Info;Internal Info;Phone;Phone 2;Cell Phone;Cell Phone 2;Email;Email 2;Text 1;Text 2;Text 3;Text 4;Text 5;Text 6;Value 1;Value 2;Number 1;Number 2;Amount 1;Amount 2;Bool 1;Bool 2;Date 1;Date 2;Date 3;Date 4;Code 1 Imp;Code 2 Imp;Code 3 Imp;Code 4 Imp;End of Line