Bulk Uploading Courses

This article provides specific details on bulk uploading courses (or classes) using the powerful bulk upload feature.

The Bulk Upload article provides common general instruction on how to bulk upload various information into Grado. The focus here is on the crucial aspects of the CSV template for courses. We will explore the required fields, clarify what information is essential, outline validation requirements, and show the correct format for a successful upload.

Prerequisites

Needs at least one subject existing in the system.

Bulk Uploading Courses

Please follow the instructions here.

CSV Template Anatomy

Upon opening the CSV template for bulk uploading subjects,courses, you will see the following headers:

The table below outlines what each header mean as well acceptable values and validations for successful bulk upload of subjects:courses:

short  

Template Header	Description	Required?	Case-Sensitive?	Acceptable Values	Sample Values
SubjectClass name		NO	YES	YES	SubjectCourse name	EnglishG7Mag-AP for7 G7Ila-SCI Academic7 G7Ila-FIL and Professional Purposes Research Project Fundamentals of ABM 2 Principles of Marketing Applied Economics 27
Subject short name		YES	YES	Subject short name	FIL 101 ENG 101 MATH 101 ENTREP 101 FIL 7 III 101 EsP 9 EsP 8
SubjectSchedule display nameDay		NO	NO	["m", "mon", "monday"] ["tu", "tue", "tuesday"] ["w", "wed", "wednesday"] ["th", "thu", "thursday"] ["f", "fri", "friday"] ["sa", "sat", "saturday"] ["su", "sun", "sunday"]	Monday tu wed
Schedule Time Start		NO	NA	SubjectHH:MM:SS display nameP	Health9:00:00 8 Health 9 Physical Education 8 Physical Education 9AM
SubjectSchedule displayTime short nameEnd		NO	NA	SubjectHH:MM:SS displayP	12:00:00 PM
Building name		NO	NO	Building name	HV Lab
SubjectRoom UnitsName or Credit CountNumber		NO	YES	Room number in the provided building	401
Class slot total		YES	NA	maxCourse precisionslot 3 scale 2number	1.0100 0.25 150 250 350 12
SubjectFaculty descriptionemail		YES if course provided does not exist yet	YES	Faculty email	juandelacruz@school.edu.ph
Class starting AY year		NO	NA	SubjectFour descriptiondigit year	2022
SubjectClass amountterm		NO	NA	max precision 10 scale 4	1234567891.1234 1250.0
Transmutation table name		YES	NO	Transmutation name	deped transmutation
Department name		NO	NO	Department name	Senior High School Secondary Education Elementary Education
Subject grade item count		NO	NA	whole number	0 2 4
Is shs		YES if year level is not provided	YES if “true” NO if “yes” user can only input ["true" but "yes" can be inputted as "Yes"1st", "yEs", "YES", "yeS", ...	[“true”, “yes”]	true yes YES Yes yEs yeS
Is k10		YES if year level is not provided	YES if “true” NO if “yes” user can only input "true" but "yes" can be inputted as "Yes", "yEs", "YES", "yeS", ...	[“true”, “yes”]	true yes YES Yes yEs yeS
Subject Year Level		NO	NA	["kinder", "-12"] ["grade 1", "grade1", "grade one", "-11"] ["grade 2", "grade2", "grade two", "-10"] ["grade 3", "grade3", "grade three", "-9"] ["grade 4", "grade4", "grade four", "-8"] ["grade 5", "grade5", "grade five", "-7"] ["grade 6", "grade6", "grade six", "-6"] ["grade 7", "grade7", "grade seven", "-5"] ["grade 8", "grade8", "grade eight", "-4"] ["grade 9", "grade9", "grade nine", "-3"] ["grade 10", "grade10", "grade ten", "-2"] ["grade 11", "grade11", "grade eleven", "-1"] ["grade 12", "grade12", "grade twelve", "0"] ["1st year", "1styear", "first year"first", "1"] ["2nd year"2nd", "2ndyear", "second year"second", "2"] ["3rd year"3rd", "3rdyear", "third year"three", "3"] ["4thyear year"long", "4thyear"yearlong", "fourthyear_long", "long year"] ["summer", "midsem", "summer/midsem", "midsem/summer", "4"] ["5th year", "5thyear", "fifth year", "5"] ["6th year", "6thyear", "sixth year", "6"]	GradeFirst Year 1 Grade 7 Grade 11 Third Yearlong