How to Register Using Template
Learn how to download a course-specific Excel template, enter trainee details, upload prerequisite documents, and register multiple trainees for a course.
In This Section
Receive the course-specific template by email.
Enter trainee information in Excel.
Complete prerequisite sheets and prepare ZIP files when required.
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:
Contains guidelines for entering trainee details, completing prerequisite sheets, preparing ZIP files, and avoiding import errors.
Contains the fields required to enter the personal, identification, contact, and other details of each trainee.
Contains the prerequisite certificate details for courses that require them. This sheet appears only when the selected course has certificate prerequisite requirements.
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.
| Section | Instructions |
|---|---|
| Quick Start | Fill in Trainee Details first. If Course Prerequisite or Certificate Prerequisite sheets are present, complete them as required. |
| ZIP Required | If supporting documents such as PDFs or images are required, put all the necessary documents into one ZIP folder before uploading. |
| Step 1: Trainee Details | Fill in the Trainee Details sheet first. Use dropdowns for fields such as Gender and Country. |
| Step 2: Course Prerequisite | If the Course Prerequisite sheet is present, select the trainee and course name from the dropdowns. |
| Step 2.1: Institution Type | If 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 Prerequisite | If the Certificate Prerequisite sheet is present, select the trainee and enter the exact filename of the document being provided. |
| Do | Ensure that the filename entered in Excel exactly matches the filename inside the ZIP folder. |
| Do | Add trainees to Trainee Details before selecting their names in the prerequisite sheets. |
| Do | Provide a valid Institution Name and File Name when the type is External or Others. |
| Do | If Mandatory is set to YES, do not skip the row or leave its required fields blank. |
| Do | Use the DD-MM-YYYY format for all date fields. |
| Don't | Do not upload only the Excel file if prerequisite documents are required. Put the necessary files into one ZIP folder. |
| Don't | Do not add spaces at the end of filenames. For example, file.pdf may cause an error. |
| Don't | Do not modify or delete column headers or sheet names. |
| Don't | Do not enter free text in columns where dropdowns are provided. |
| Don't | Do not edit hidden ID columns because these are automatically generated for the system. |
| Note | If prerequisite sheets are not included in the template, completing Trainee Details is sufficient. |
| Help | Invalid 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.
| Field | Description |
|---|---|
| ID | Serial number for the trainee entry. |
| First Name | Enter the trainee's first name. |
| Last Name | Enter the trainee's last name. |
| Certificate Name | Enter the certificate name, if applicable. |
| Gender | Select the trainee's gender from the dropdown. |
| Date of Birth | Enter the trainee's date of birth in the required date format. |
| Unique Identification | Select the appropriate identification type from the dropdown. |
| Unique ID Value | Enter the identification number according to the selected identification type. |
| ID Format Info | Follow the instructions provided in this field to enter the Unique ID Value in the correct format. |
| Enter the trainee's email address. | |
| Country | Select the country from the dropdown. |
| State | Select the state from the dropdown. |
| City | Select the city from the dropdown. |
| Phone Number | Enter the trainee's phone number. |
| Address | Enter 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.
| Field | Description |
|---|---|
| Institution Type | Select the institution type. For Internal, select the course from the dropdown. For External, manually enter the required institution details. |
| Institution Name | Enter the institution name when required, particularly for external institutions. |
| Course Name | For an internal institution, select the applicable course from the dropdown. |
| Trainee Name | Select the trainee from the dropdown after adding the trainee to the Trainee Details sheet. |
| File Name | Enter 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.
| Field | Description |
|---|---|
| Prerequisite Certificate Name | Select the required prerequisite certificate from the dropdown. The available options depend on the course configuration. |
| Mandatory | Indicates whether the prerequisite is mandatory according to the course booking configuration. If set to YES, complete the required fields. |
| Trainee Details | Select the trainee from the dropdown. The trainee must already be listed in the Trainee Details sheet. |
| File Name | Enter the exact filename of the certificate or document that will be included in the prerequisite ZIP folder. |
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.
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
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