How to import leave requests

How to import leave requests

Mirro makes the set-up process easier by using Imports. You can import multiple information in your application: 
  1. Users and their details
  2. Management lines
  3. Employment Contracts
  4. Performance managers and coordinators
  5. Time off balances
  6. Carry over days
Import files support .xlsx format and import templates are available to download. For a successful import, please mind data formatting from the downloaded templates.

To import the data in Mirro, you will need to access the Admin Area module > Import data section. After deciding which details you would like to upload, you will need to download the template which should be filled-in with the information according to the header and the legend. 

Import multiple leave requests at once for each user in part 

Getting the time off balance up to date for everyone all at once using imports. One of the main admin issues companies are facing is correct handling of attendance. Use these imports - time off requests import and carry over days import -  when onboarding your company and you are good to go for your entire journey with Mirro. 

Using Mirro you have the possibility to upload requests leave all at once. Before importing the files you will need to define the rules in the Leave settings section from the Admin Area module. When filling-in the details in the import file, please mind data formatting according to the legend below: 
  1. The column Employee Identifier should be filled-in with the e-mail address of the user or the employee identifier (available in the position details of the user). 
  2. The column Time off rule refers to the rule's name from which the user is taking a request. The rules can be seen by accessing the Leave settings section from the Admin Area module. 
  3. The column Created Date refers to the date when the request has been created. Please mind data formatting: Month / Day / Year, example: 1/20/2020. 
  4. The column Start Date refers to the date when the time off is starting. Please mind data formatting: Month / Day / Year, example: 1/20/2020. 
  5. The column End Date refers to the date when the time off is ending. Please mind data formatting: Month / Day / Year, example: 1/20/2020. 
  6. The column Status refers to the status of the request which can be approved or new. Using the approved status you will be uploading the request already approved. Using the status new you will be uploading the requests and they will be in pending, waiting to be approved. 
  7. The column Days refers to the days from the time-off request. 
  8. The column Approver Employee Identifier refers to the user which is approving the request, which can be filled-in with the e-mail of the user found in Mirro. 
Each request should represent a row in the file. For example, if Jack has two requests in a month, one for 10 January and another one for 24-25 January, each request should be added separately.


When the file is ready to be imported, you will need to access the Admin Area module > Import Data section > Download the template Import timeoffs requests > Fill-in the information > Save the information > Select the file to upload and access the option Import 


Once you accessed the import option, you will be redirected in the Import History section where you can track the progress of the import. In the same time, when the process will be finished, you will receive a notification to know that the process is finished.

When the details will be imported, you will be able to find the time-off requests in All requests section from the Leave & Attendance module. In the same time, the user balance will be updated according with the requests uploaded. 

    • Related Articles

    • How to manage all leave requests

      Mirro is offering you the possibility to organize and manage all leave requests which are performed by your colleagues. Based on the access rights associated with you in Mirro, you can handle all leave requests within the company or only the ones for ...

    • How to import carry-over days

      Mirro makes the set-up process easier by using Imports. You can import multiple information in your application:  Users and their details Management lines Employment Contracts Performance managers and coordinators Time off balances Carry over days ...

    • How to manage all flexi-time requests

      Mirro is offering you the possibility to organize and manage all flexi-time requests which are performed by your colleagues. Based on the roles which you have in Mirro, you can handle all flexi-time requests or only the ones for which you received ...

    • How to manage all work away requests

      Mirro is offering you the possibility to organize and manage all work away requests which are performed by your colleagues. Based on the roles which you have in Mirro, you can handle all work away requests or only the ones for which you received ...

    • How to define the leave rules

      Different company policies imply customized setup of vacation, leave or days off. Mirro allows specialists to define company-specific time-off rules of different types. Setup custom rules for different types of leave, vacation or other days off 1. ...