Common errors when uploading your data template, their meaning, and how to fix them.
⚠️ Error Code | Description | Fix |
|---|---|---|
Invalid literal for int() with base 10: | Employee ID contains non-numerical values. | Use only numbers for Employee IDs. If letters/symbols can’t be removed, replace with sequential numbers (e.g., 1, 2, 3… 556, 557, 558) |
Duplicate email encountered | Same email address listed for more than one employee. | Ensure each employee has a unique email in both the template and portal. Use Excel Filter and Sort to find duplicates. |
Header "Medical Insurance" appears to be missing; re-download the template and be sure not to modify the headers. | Template headers do not match the portal. | Re-download the template and ensure program names, order, and spelling match exactly. Leave unused plan/coverage columns blank but do not delete them |
<sqlalchemy.sql.elements.TextClause object at 0z7f9ba5335f60> | Employee ID field contains blanks while other cells in that row have data. | Use Excel Filter with (blanks) to locate and fill missing Employee IDs. |