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:

Dela

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 40
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.