Batch enrollment by student in trainings

Students can be enrolled in one or more trainings by importing via spreadsheet.

To import, follow the steps below:

1. Click on Students from the main menu

2. Click the List All Students Enrollments button icon located in the upper right corner (first icon)

3. Click the Import Training Enrollment button icon located in the upper right corner (first icon)

4. Click the Download Modelo button icon located in the upper right corner (first icon) to download the template spreadsheet

5. Open the downloaded file

6. Fill in the columns with the information, as instructed below:

id_aluno	Enter the student ID number. To check the student ID, follow the steps below: Click on Students in the main menu Search for the desired student in the search bar The student ID is the number displayed in the ID column.
codigo_aluno	Enter the student code number, if any.
id_treinamento	Enter the ID number(s) of the training(s) you wish to enroll the student in. To check the training ID, follow the steps below: Click on Trainings in the main menu Click on the On-line submenu Search for the desired training(s) in the Research bar in the upper right corner The training code is the number displayed in the ID column. If the student needs to be enrolled in two or more trainings, separate the numbers by commas only. For example: 1,3,5,9.
codigo_treinamento	Enter the training code number, if any.
validade	Enter the day, month and year of the training(s) enrollment validity, in the following format: 00/00/0000 If there is no validity, leave the field blank.
enviar_email	Enter the email sending number (1 or 0), where: 1 to send email to the student that the enrollment has been completed, upon completion of enrollment 0 to enroll the student but not email them that the enrollment has been completed

Do not make any changes or deletions in the first row of the spreadsheet column, identified by the column headings.

When importing student enrollments via the worksheet, students will be enrolled in the indicated trainings even if the student's profile and the profile registered for the training are different.

7. Save the worksheet to your computer

8. Return to the platform

9. Click Select

10. Locate and select the file

11. Click Send on the platform to upload the file

On the next screen, you can view the report of the students enrolled by importing via the spreadsheet.

If the registration was successful, an ID will be generated for each registration made.

If there was an error with the registration, the report will inform you of the error and the reason for the error.

{{component-feedback-article}}