What you will get
A corrected spreadsheet after a refused import. The good news comes first:
When there is an error, nothing is saved. Not even the students on the good rows. There is no half-finished import, and you never have to hunt for who got in and who did not.
How to read the red box
It appears at the top of the second step, one line per problem.
The number is the line of the file, counting the header. "Linha 2" is the first student in the spreadsheet — the same number Excel shows down the side.
Fix everything in the spreadsheet, save, click Choose another file and upload again.
The most common messages
The email field is required The cell is empty in a spreadsheet where the school demands an email. Fill it in, or drop the row and register that student by hand later.
The birth date field must be a valid date
The date is in a format the system does not recognise. It takes 2004-07-22,
22/07/2004 and 07/22/2004. Anything else — a spelled-out month, a two-digit
year, dots instead of slashes — is refused.
Invalid CPF The verification digits do not add up. Check the document; if your school registers foreign students, the check can be turned off in Settings › Student Portal.
Duplicate login identifier in file Two rows with the same email (or the same ID, if login is by document). Decide which one stays.
Duplicate document in file Two rows with the same ID. Almost always the same student typed twice.
The document number has already been taken That ID already belongs to a student at your school. If it is the same person, drop the row: they are already registered.
When the error list is enormous
The system stops listing after 100 problems. A full box is nearly always one error repeated on every row — a column mapped wrong, or a date format the whole file uses.
Look at the first error and fix the cause, not the hundred rows.
The error that never reaches the red box
A repeated student is not an error. If the spreadsheet holds people who are already registered, the import goes through and the green summary counts them under Existing records preserved. Nobody is duplicated and no existing record is overwritten.
Worth knowing: re-importing the same spreadsheet is safe.
How you know it worked
The screen returns to the student list with the green summary banner in place of the red box. If New students shows the number you expected, you are done.
If something goes wrong
You fixed it and the same error came back. Check that you saved the right file — and that your spreadsheet program did not rebuild the old format on save.
An error mentions a field you did not map. The system validates required fields even when they were left on Ignore field. Point it at the right column.
An error points at a row that looks blank. Completely empty rows are skipped. If a space or a stray semicolon survived, the row is no longer empty — delete the whole row.
Reviewed on · view as plain text