e-trainiaDocs
Schedule Classes

How to Register Using Template

Trainee Management Guide
How to Import Trainee Details Using a Template

Learn how to download a course-specific Excel template, enter trainee details, upload prerequisite documents, and register multiple trainees for a course.

Excel TemplateZIP DocumentsBulk Registration
ZIP

In This Section

01
Download Template

Receive the course-specific template by email.

02
Fill Trainee Details

Enter trainee information in Excel.

03
Add Prerequisites

Complete prerequisite sheets and prepare ZIP files when required.

04
Import and Submit

Upload the files, review the details, and complete registration.

Before You Begin

Each course has a separate import template. Always download the template for the course you want to register trainees for. The template and prerequisite documents must follow the required course and filename conventions.

1. Download the Template

Click Download Template

Click Download Template for the required course. The related Excel template will be sent to the respective user's email address.

Open the Email

Open the email and download the attached template for the selected course.

Verify the Course Name and Code

Check the template filename and confirm that it corresponds to the intended course.

Course-Specific Template

Each course has a separate template. Do not use a template generated for one course to import trainees into another course. If you want to use the same template for another course, rename the file according to the required course name and course code before uploading it.

2. Understand the Template Structure

The downloaded Excel template contains the following pages:

Page 1: Instructions

Contains guidelines for entering trainee details, completing prerequisite sheets, preparing ZIP files, and avoiding import errors.

Page 2: Trainee Details

Contains the fields required to enter the personal, identification, contact, and other details of each trainee.

Page 3: Certificate Prerequisite

Contains the prerequisite certificate details for courses that require them. This sheet appears only when the selected course has certificate prerequisite requirements.

COURSE-DEPENDENT

Read the first page carefully before entering information on the second page or any prerequisite sheets.

2.1. Template Instructions

The first page provides the following instructions.

SectionInstructions
Quick StartFill in Trainee Details first. If Course Prerequisite or Certificate Prerequisite sheets are present, complete them as required.
ZIP RequiredIf supporting documents such as PDFs or images are required, put all the necessary documents into one ZIP folder before uploading.
Step 1: Trainee DetailsFill in the Trainee Details sheet first. Use dropdowns for fields such as Gender and Country.
Step 2: Course PrerequisiteIf the Course Prerequisite sheet is present, select the trainee and course name from the dropdowns.
Step 2.1: Institution TypeIf the type is Internal, select the course from the dropdown. If the type is External, enter the Institution Name and File Name manually.
Step 3: Certificate PrerequisiteIf the Certificate Prerequisite sheet is present, select the trainee and enter the exact filename of the document being provided.
DoEnsure that the filename entered in Excel exactly matches the filename inside the ZIP folder.
DoAdd trainees to Trainee Details before selecting their names in the prerequisite sheets.
DoProvide a valid Institution Name and File Name when the type is External or Others.
DoIf Mandatory is set to YES, do not skip the row or leave its required fields blank.
DoUse the DD-MM-YYYY format for all date fields.
Don'tDo not upload only the Excel file if prerequisite documents are required. Put the necessary files into one ZIP folder.
Don'tDo not add spaces at the end of filenames. For example, file.pdf may cause an error.
Don'tDo not modify or delete column headers or sheet names.
Don'tDo not enter free text in columns where dropdowns are provided.
Don'tDo not edit hidden ID columns because these are automatically generated for the system.
NoteIf prerequisite sheets are not included in the template, completing Trainee Details is sufficient.
HelpInvalid data or missing files in the ZIP folder can cause the entire upload to fail. Double-check all filenames before uploading.

3. Fill in the Trainee Details

Open the Trainee Details sheet and enter the information for each trainee you want to register for the course.

FieldDescription
IDSerial number for the trainee entry.
First NameEnter the trainee's first name.
Last NameEnter the trainee's last name.
Certificate NameEnter the certificate name, if applicable.
GenderSelect the trainee's gender from the dropdown.
Date of BirthEnter the trainee's date of birth in the required date format.
Unique IdentificationSelect the appropriate identification type from the dropdown.
Unique ID ValueEnter the identification number according to the selected identification type.
ID Format InfoFollow the instructions provided in this field to enter the Unique ID Value in the correct format.
EmailEnter the trainee's email address.
CountrySelect the country from the dropdown.
StateSelect the state from the dropdown.
CitySelect the city from the dropdown.
Phone NumberEnter the trainee's phone number.
AddressEnter the trainee's address.

Tip

Use the dropdown options wherever they are provided. Follow the instructions in ID Format Info when entering the Unique ID Value, and verify all mandatory details before proceeding.

4. Complete the Prerequisite Sheets

If the selected course requires prerequisite courses or certificates, complete the corresponding prerequisite sheets included in the template.

Prerequisite Sheets

The prerequisite sheets are applicable only when they are included in the downloaded template. If they are not present, complete the Trainee Details sheet and proceed with the import.

4.1. Course Prerequisite

If the Course Prerequisite sheet is present, fill in the required information.

FieldDescription
Institution TypeSelect the institution type. For Internal, select the course from the dropdown. For External, manually enter the required institution details.
Institution NameEnter the institution name when required, particularly for external institutions.
Course NameFor an internal institution, select the applicable course from the dropdown.
Trainee NameSelect the trainee from the dropdown after adding the trainee to the Trainee Details sheet.
File NameEnter the exact filename of the document being provided, where required.

Important

Complete all mandatory fields. For external institutions, enter the required Institution Name and File Name manually. The document filename must match the actual file included in the ZIP folder.

4.2. Certificate Prerequisite

If the Certificate Prerequisite sheet is present, complete the following fields.

FieldDescription
Prerequisite Certificate NameSelect the required prerequisite certificate from the dropdown. The available options depend on the course configuration.
MandatoryIndicates whether the prerequisite is mandatory according to the course booking configuration. If set to YES, complete the required fields.
Trainee DetailsSelect the trainee from the dropdown. The trainee must already be listed in the Trainee Details sheet.
File NameEnter the exact filename of the certificate or document that will be included in the prerequisite ZIP folder.
⚠️ Filename Matching Is Required

If the Excel sheet contains my_cert.pdf, the certificate file must have exactly the same name: my_cert.pdf. Do not change the spelling, file extension, or spacing. The filename must match exactly for the certificate to be identified correctly.

5. Save the Completed Template

Before importing, complete the following checks.

  • Enter all required trainee details.
  • Complete the applicable prerequisite sheets.
  • Verify the dropdown selections.
  • Check that all mandatory prerequisite fields are completed.
  • Confirm that each filename matches the corresponding document in the ZIP folder.
  • Keep the original column headers and sheet names unchanged.
  • Save the completed Excel template using the required filename for the selected course.
  • Place all required prerequisite documents into one ZIP folder.

Ready to Import

Once the Excel template and any required prerequisite documents are ready, proceed to Import Template.

6. Import the Template

After saving the completed template, click Import Template. An import popup will appear.

Import Template
Upload Trainee Details*
EXCEL

Upload the completed trainee details Excel template for the selected course.

Upload Trainee Certificates (ZIP)*
ZIP

Upload a ZIP folder containing the prerequisite certificates and supporting documents required for the course. This field is displayed when the course has prerequisite requirements.

* Required field

6.1. Upload Trainee Details

Field: Upload Trainee Details*

  • Supported Format: Excel
  • Upload the completed trainee details template.
  • Ensure that the template belongs to the selected course.

6.2. Upload Trainee Certificates (ZIP)

Field: Upload Trainee Certificates (ZIP)*

  • Supported Format: ZIP
  • Upload a ZIP folder containing the required prerequisite certificates or supporting documents.
  • This field is displayed when the selected course has prerequisite requirements.
  • Ensure that the filenames match the entries in the prerequisite sheets.

Upload Requirements

The import popup marks the displayed upload fields as mandatory. When prerequisite documents are required, upload both the Excel template and the ZIP folder. If the course does not require prerequisite documents, the certificate upload field may not be displayed.

7. Import and Verify the Trainee Details

Upload the Required Files

Select the completed Excel template in Upload Trainee Details. If the course requires prerequisite documents, also select the ZIP folder in Upload Trainee Certificates (ZIP).

Click Import

Click Import to process the uploaded template. The trainee details will be populated in the registration form.

Review the Imported Information

Carefully verify the imported trainee details, including names, identification information, contact details, and prerequisite information.

Click Submit

Once all the details are correct, click Submit to complete the course registration.

Registration Completed

After successful submission, the trainees will be registered for the selected course.

8. Quick Reference

Import Checklist
Download the correct course-specific template from your email.
Fill in the Trainee Details sheet before the prerequisite sheets.
Complete all applicable mandatory prerequisite fields.
Package required certificates and supporting documents into a single ZIP folder.
Ensure that filenames in Excel match the files inside the ZIP folder exactly.
Import the template, review all details, and click Submit to complete registration.

Common Import Errors

The import may fail if the Excel template contains invalid data, required documents are missing, filenames do not match, mandatory prerequisite information is incomplete, or the template structure has been modified. Verify the template and ZIP folder before uploading.

Last updated on