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.