Create students en masse
Students can be registered in batches by importing them via a spreadsheet.
Instructions
To register students in bulk, follow the steps below:
Click on Students in the main menu
Click the Import button icon located in the upper right corner (third icon)
Click the Download Modelo button icon located in the upper right corner (first icon) to download the template spreadsheet
Open the downloaded file
Fill in the columns with the information, as instructed below:
nome | Enter the student's first name. |
sobrenome | Enter the student's last name. |
cpf | Enter the 11 digits of the student's CPF, if required (as configured in the account settings). Enter only the numbers, no periods or dashes. If not required, leave the field blank. |
empresa | Enter the company code. To verify the company registration code, follow the steps below:
The company code is the number displayed in the ID column. |
codigo_aluno | Enter the desired code for the student. If you do not want to enter a code, leave the field blank. |
perfil | Enter the desired code(s) of the student profile(s). To verify the student profile registration code, follow the steps below:
The student profile code is the number displayed in the ID column. If the student needs to be registered in two or more profiles, separate the numbers by commas only. For example: 1,3,5,9. |
idioma | Enter the acronym of the student's language (pt, en or es), where:
|
login | Enter the student's login e-mail address. |
senha | Enter the student's password. |
liberar | Enter the release number (1 or 0), being:
|
matricula_treinamentos | Enter the code(s) of the training(s) you wish to enroll the student in at the time of registration. To verify the training code, follow the steps below:
The training code is the number displayed in the ID column. If the student needs to be registered in two or more trainings, separate the numbers by commas only. For example: 1,3,5,9. If you do not want to enroll the student in any training at the time of registration, leave the field blank. |
matricula_treinamentos_validade | Enter the day, month, and year of the training(s) enrollment validity, in the following format: 00/00/0000 If the student is not enrolled in any training, leave the field blank. |
matricula_trilhas | Enter the code(s) of the track(s) you wish to enroll the student in at the time of registration. To check the track code, follow the steps below:
The track code is the number displayed in the ID column. If the student needs to be registered in two or more tracks, separate the numbers by commas only. For example: 1,3,5,9. If you do not want to enroll the student in any track at the time of registration, leave the field blank. |
matricula_trilhas_validade | Enter the day, month, and year of the trail registration expiration date(s), in the following format: 00/00/0000 If the student is not enrolled in any track, leave the field blank. |
enviar_email | Enter the email sending number (1 or 0), being:
|
telefone | Enter the student's contact phone number. Enter numbers only, no periods or dashes. If you do not want to register the phone number, leave the field blank. |
Do not make any changes or deletions in the first row of the spreadsheet column, identified by the column headings.
Save the worksheet on your computer
Return to the platform
Click Select
Locate and select the file
Click Send on the platform to upload the file
On the next screen, you can view the report of the students registered by importing via spreadsheet.
If the registration is successful, an ID will be generated for each student registered. The student will be notified of their registration by e-mail, according to the configuration established in the Student registration e-mail routine.
If there was an error with the registration, the error, and the reason for the error will be informed in the ID column.
To edit the registration or delete a student, go to Create, edit or delete student.
{{component-feedback-article}}