Bulk Uploading Fees

This article provides specific details on bulk uploading sections 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 sections.fees. We will explore the required fields, clarify what information is essential, outline validation requirements, and show the correct format for a successful upload.

Prerequisites

NeedsDoesn't athave least one degree program and at least one Course/Class existing in the system.prerequisites.

Bulk Uploading SectionsFees

Please follow the instructions here.

CSV Template Anatomy

Upon opening the CSV template for bulk uploading sections,fees, 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 courses:fees:

Template Header	Description	Required?	Case-Sensitive?	Acceptable Values	Sample Values
Section starting AY year	The academic year in which a class/course section commences.	YES	NA	Four digit year	2020 2017
Section term	The term or semester during which a class or course section is scheduled to take place.	YES	NO	["1st", "first", "1"] ["2nd", "second", "2"] ["3rd", "three", "3"] ["year long", "yearlong", "year_long", "long year"] ["summer", "midsem", "summer/midsem", "midsem/summer", "4"]	First Year long
Section year level	The grade/study level to which a class or course section is assigned.	YES	NO	["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", "1"] ["2nd year", "2ndyear", "second year", "2"] ["3rd year", "3rdyear", "third year", "3"] ["4th year", "4thyear", "fourth year", "4"] ["5th year", "5thyear", "fifth year", "5"] ["6th year", "6thyear", "sixth year", "6"]	Grade 1 Grade 7 Grade 11 Third Year
Section name	Unique identifier or label assigned to a specific class or course section.	YES	NA	Section name	Gr9-Uranus Gr9-Mercury Gr8-Gmelina Gr8-Molave
Educ Program shortFee name	Shortened name of the educational/degree program.fee.	YES	YESNA	Degree program shortFee name	HStuition Eleminterest Academic - ABM Academic – HUMSSoverpaid
ClassFee nameamount	Name assigned to the class/course to beValue associated with the section.specific fee.	YES	NA	Decimal precision 12 scale 2	123456789000.12 2550.0
Fee Category name	Title or label assigned to a category or group of fees.	NO	YES	CourseFee category name	G7Mag-APTuition Registration 7Fee G7Ila-SCIMiscellaneous Other 7Fees
Fee label	The label of the fee displayed in forms.	NO	NA	Fee label	Tuition G7Ila-FIL 7Interest G7Ila-EsP 7 G7Ila-TLE 7Overpayment

In order to associate multiple classes or courses to a single section within the CSV template, users should provide the necessary details for each class or course on separate rows. Each row should correspond to a specific class or course, containing the relevant information such as Class/Course Name, Section Name, Section starting academic year, Section term, and other pertinent fields. By specifying each class per row in the template, users can accurately establish the connections between classes or courses and the corresponding section, ensuring proper organization and management of the data during the bulk upload process.