Bulk Uploading Faculty Member Information

This article provides specific details on bulk uploading roomsfaculty 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 rooms.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 buildingexisting existingdepartment and division in the system.
system (departments and divisions need to be manually created, see Adding and Modifying Departments and Adding and Modifying Divisions).

Bulk Uploading RoomsFaculty Member Information

Please follow the instructions here.

CSV Template Anatomy

Upon opening the CSV template for bulk uploading rooms,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?	Case-Sensitive?	Acceptable Values	Sample Values
BuildingFaculty 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 building/faciltydivision the roomfaculty member will be associated to. YES NO School buildingDivision name already existing in the system MBSecondary Education
HVElementary LabEducation
Senior High School RoomDepartment Name or Numbername Name,Name number, or code identifier forof the room.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 NA Faculty email address juandelacruz@school.edu.ph Faculty first name Given name/s of the individual faculty member. YES NA RoomFaculty first name LC1
LC2
LC3
201
203Juan RoomFaculty descriptionmiddle name SimpleMiddle descriptionname/s of the room.individual faculty member. NO NA RoomFaculty descriptionmiddle name Lecture Classroom 1
Lecture Classroom 2
Lecture Classroom 3
Computer Lab 1
Computer Lab 2Carlos RoomFaculty capacitylast name MaximumFamily numbername or surname of individualsan theindividual roomfaculty can accommodate.member. NOYES NA RoomFaculty capacitylast (number)name 120
240
40Dela Room floor location Specific floor or level where a particular room is situated within the building. NO NA Floor number 1
2Cruz

To associate multiple rooms with a single building within the CSV template, users should specify each room on separate rows, providing the necessary details for each room. Each row should correspond to a specific room, containing information such as Building Name, Room Name, Room Capacity, and Room Floor Location. By delineating each room per row in the template, users can accurately establish the connections between rooms and the corresponding building, ensuring proper organization and management of the data during the bulk upload process.