How to import users details

How to import users details

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 Company Settings module > Import data section. After deciding which details would you 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 users at once

Add multiple users at once with their details. This will save a lot of your time on company set up. Mind data formatting and fill in all data about your people that you want Mirro to handle according to the following legend: 

  1. The columns which are marked in purple are mandatory 
  2. Please use this date format: yyyy-mm-dd (format all columns that contains dates  before uploading the file) 
  3. Internal positions will be matched based on the short name. Make sure you have all the positions short names defined in Internal Positions section. In case the short name will not be found in internal positions list, the position will be automatically added as new.  
  4. Departments will be matched based on the short name. Make sure you have all the departments short names defined in Departments section. In case the short name will not be found in Departments List, the Department will be automatically added as new. 
  5. Please note that users are matched by email (Column D). New users will be added through import, existing users will be updated. 
  6. Please make sure the Employee Identifier (Column A) is unique per user. It will be used for user matching on various imports and 3rd party integration.
  7. Id Type (column M) may be "id" or "passport" 
  8. Please use the Company Location code for employee main location (column AC). The details about the quarters of your company can be found in the second sheet of the file.  
  9. Handicap grade (column AG) may be 0 (no handicap), 1 (first grade), 2 (second grade), 3 (third grade) or 4 (forth grade) 
  10. Base function (column AH) may be TRUE or FALSE 
  11. Tax Exempt (column AH) may be TRUE or FALSE 
  12. Employee status (column AL) may be Active or Inactive
To make sure that all details are filled-in accordingly, you will have the possibility first to simulate the import. When you perform a simulation, the application will let you know if the information from the file is correct or not. The difference between simulation process and import process consists in the option: Save employees with all valid lines* which should be unselected when performing a simulation. 

After the simulation has been finished, you will be redirected in the Import History page where you will be able to download the file imported to see the errors, if any errors will occur. In the same time, when the process will be finished, you will be notified offering you the possibility to download the file from the notification.

Once you managed to correct all errors from the file, to perform the import you will need to access the Company Settings module > Import Data section > Download the template for import employees > Fill-in the information according to the details from the legend > Save the information > Select the file to upload > Access the option Import and mark the field Save employees with all valid lines*. 



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 users in the application by accessing the People module > Users section.


    • Related Articles

    • How to import contract details

      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 import leave requests

      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 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 import performance managers and time-off approvers

      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 set-up position details for your colleague

      User management data can a little bit tricky and overwhelming when stored in multiple places. With MIRRO, you have the possibility to fill-in all user's details in one place. Even if we are talking about private information, position details, and ...