Skip to main content

Import error: "The employee cannot report to their own indirect report"

  • Feb 19, 2024 10:47 AM UTC
  • Sep 16, 2024 9:04 PM UTC
  • 0 replies
  • 105 views
  • Translate All

When importing historic data in the work history table, if there have been restructures or event where an employee reported to someone who is now their direct report, bob will present the error “the employee cannot report to their own indirect report.” In this instance the data needs to be adjusted prior to reimporting the most recent information.

 

When the error presents in the import log, please ensure you export the error file. From there work through the “reports to” column in the error report to understand which profiles are linked to the errored files.

 

Depending on how many employee records you have in the system and how many errored employees there are, you may want to take one of two approaches.

If you have a small number of employees OR large number of employees with lots of errors:

1. Go to analytics > reports > new report > from a template > work history

2. Remove all the filters (including the advanced filter that’s only showing “active employees”)

3. Then use the column picker to add the “email” field into your report, and export as an xls

4. In the report, duplicate the sheet and label one “deletions” and the other “corrections”.

5. In the “deletions” sheet, go through the report locating the data rows with errors and the employees that are linked and highlighting them

    a. I suggest red/orange for the errored records and yellow for the linked records

 Please note, if you cannot easily see the error in the reporting line you will need to highlight all recordsfor the linked employee.

6. In the linked employee records within the “reports to” column clear the data and enter “<DELETE>”

 

7. Do this for all the employee records linked to an errored record
Should you not be able to clearly identify the link, do this for all records belonging
to the linked employee.
8. In the“corrections”sheet you can leave all the records as they are as we are going to import the records to override the existing.
9. Save your data sheet.
Please note, you can only import 1000 lines of data at one time so if you have more than this you will need to create multiple files for the import activity.
If you have a large number of employees with very few errors, once you have identified the errored and linked accounts:
1. Go to analytics>reports>new report>from a template>work history
2. Use the column picker to add the“email”field into your report
3. Remove all the filters(including the advanced filter that’s only showing
“active employees”) and add a filter for “Email equals [X]” (X = email account
of errored or linked employee).
4. Export report as xls for each employee then combine all of the reports to one data sheet.
5. In the new combined report, duplicate the main sheet and label one “deletions” and the other “corrections”.
6. In the“deletions”sheet, go through the report locating the data rows with
errors and the employees that are linked and highlighting them 

   a. I suggest red/orange for the errored records and yellow for the linked records


Please note, if you cannot easily see the error in the reporting line you will
need to highlight all records for the linked employee.
7. In the linked employee records within the“reports to”column clear the data and enter “<DELETE>”

 

When you have your report finalised this now becomes your import sheet.
1. Head to settings> data management > import > go to people import and use the third option to import table data by selecting the “work” option from the drop down menu, and selecting “replace existing and add new records”
2. Follow the steps of the import wizard and first import your“deletions”sheet.
3. Once done (hopefully with no errors)follow the steps again, this time selecting your file from the import drive, to import the “corrections” sheet.
4. Once correctly imported, go to one of the profiles to ensure the data is correct.


Happy error fixing