{% extends "base_authenticated.html" %} {% block title %}Review Invalid Rows - {{ COMPANY_NAME }}{% endblock %} {% block extra_head %} {% endblock %} {% block page_title %}Review Invalid Rows{% endblock %} {% block content %}

Review Invalid Rows

The following rows contain errors and cannot be imported. Please review the issues below.

File: {{ filename }}

Review invalid rows before importing valid records

{{ analysis.total_rows }}
Total Rows in File
{{ analysis.valid_rows }}
Valid Rows
{{ analysis.invalid_rows }}
Invalid Rows

What happens next?

The invalid rows shown below will be skipped during import. Only the {{ analysis.valid_rows }} valid rows will be imported into the system. You can proceed with importing the valid records, or cancel and fix the issues in your Excel file.

{% if analysis.invalid_rows > 0 %}
{% for invalid in analysis.invalid_details %}
Row {{ invalid.row_number }}

{% if invalid.row_data.employee_name %} {{ invalid.row_data.employee_name }} {% if invalid.row_data.employee_id %}(ID: {{ invalid.row_data.employee_id }}){% endif %} {% else %} Invalid Record {% endif %}

{{ invalid.errors|length }} Error{% if invalid.errors|length != 1 %}s{% endif %}

Validation Errors

    {% for error in invalid.errors %}
  • {{ error }}
  • {% endfor %}

Row Data

Employee ID: {{ invalid.row_data.employee_id or 'Missing' }}
Name: {{ invalid.row_data.employee_name or 'Missing' }}
Date: {{ invalid.row_data.attendance_date or 'Missing' }}
Time: {{ invalid.row_data.attendance_time or 'Missing' }}
Location: {{ invalid.row_data.location_name or 'Missing' }}
Action: {{ invalid.row_data.action_description or 'Missing' }}
{% if invalid.row_data.platform %}
Platform: {{ invalid.row_data.platform }}
{% endif %} {% if invalid.row_data.event_description %}
Event: {{ invalid.row_data.event_description }}
{% endif %} {% if invalid.row_data.recorded_address %}
Address: {{ invalid.row_data.recorded_address }}
{% endif %}
{% endfor %}
{% else %}

All rows are valid!

No invalid rows found. You can proceed with the import.

Back to Import
{% endif %}
{% endblock %}