Bulk Uploading Faculty Member Information
This article provides specific details on bulk uploading faculty member information 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 faculty member information. 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 existing department and division in the system (departments and divisions need to be manually created, see Adding and Modifying Departments and Adding and Modifying Divisions).
Bulk Uploading Faculty Member Information
Please follow the instructions here.
CSV Template Anatomy
Upon opening the CSV template for bulk uploading faculty member information, 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 fees:
| Template Header | Description | Required? | Must be Unique? | Case-Sensitive? | Acceptable Values | Sample Values |
| Faculty employee number | Unique identifier or numerical code assigned to an individual faculty member | YES, if no email | NA | Any combination of letter and number | 2017-E051 E055 |
|
| Division name |
Name of the division the faculty member will be associated to. | YES | NO | Division name | Secondary Education Elementary Education Senior High School |
|
| Department name | Name of the department the faculty member will be associated to. | NO | NO | Department name | Secondary Education Elementary Education Senior High School |
|
| Faculty email | Email address associated with individual faculty member. | YES, if no employee number | YES | NA | Faculty email address | juandelacruz@school.edu.ph |
| Faculty first name | Given name/s of the individual faculty member. | YES | NA | Faculty first name | Juan | |
| Faculty middle name | Middle name/s of the individual faculty member. | NO | NA | Faculty middle name | Carlos | |
| Faculty last name | Family name or surname of an individual faculty member. | YES | NA | Faculty last name | Dela Cruz | |
| Faculty employee number | YES, if no email | YES | NA | Faculty employee number | 2017-E051 E055 |
Notes
- Department name: If provided, department must be part of the provided division.
- Faculty employee number: Any character is currently accepted.