Back
Course Progress & Certificate on CSV Student Import
With EzyCourse, you have the luxury of importing existing students onto your platform, enrolling them into different products, and even setting expiry dates in terms of product access. All from importing a simple CSV file.
In this article, you will learn how to add the course progress of a student when importing through a CSV file and let them get the course certificate.
[Note: Please read how to structure your CSV file first. We have discussed there how to structure your CSV file when you are importing students, what columns are needed, and how to enroll them into courses or other products with expiry dates. Please read the doc first to better understand the following guide.
In this guide, we’ll only show how you can add two new columns for assigning course completion and giving certificates.]
Adding Column for Course Progress
On your Google sheet or the CSV file, add a column named courses_progress. This column will hold the course IDs that should be set as completed for any particular student.
Simply add the course ID on this column to set a course as completed for any student.
To find the course ID of a course, go to Courses -> All Courses.
To set multiple courses as completed, simply separate each ID with a comma.
If you set a course as completed, then the student will automatically receive the course certificate on the student dashboard.
You can set the certificate issue date for the courses which you’ve set as completed. To set the certificate issue date for a completed course, you need to add another column called courses_completion_dates.
To set the date, use a ‘vertical bar or pipe (|)’ in-between the course ID and the date. Write in this format: course_id|YYYY-MM-DD.
To set certificate issue dates for multiple courses, simply separate each one with a comma.
To see how you can import students into your platform from CSV, please read: Import Students with CSV