Skip to main content

Bulk Uploading Rooms

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

Prerequisites

Doesn'tNeeds haveat prerequisites.least one building existing in the system.

Bulk Uploading BuildingsRooms

Please follow the instructions here.

CSV Template Anatomy

Upon opening the CSV template for bulk uploading buildings,rooms, you will see the following headers:

image-1684118590650.pngimage-1684119217970.png

The table below outlines what each header mean as well acceptable values and validations for successful bulk upload of fees:

name Building
Template Header Description Required? Case-Sensitive? Acceptable Values Sample Values
Building name Name of the buildingbuilding/facilty the room will be associated to. YES N/ANO School building name already existing in the system MB
HV Lab
BuildingRoom shortName or NumberName, number, or code identifier for the room.YESNARoom name ShortenedLC1
LC2
LC3
201
203
Room descriptionSimple description of the buildingroom. NO N/ANA BuildingRoom short namedescription MainLecture Classroom 1
HVLecture Classroom 2
Lecture Classroom 3
Computer Lab 1
Computer Lab 2
BuildingRoom descriptioncapacity BuildingMaximum descriptionnumber of individuals the room can accommodate. NO N/ANA BuildingRoom descriptioncapacity (number) Main120
240
40
Room floor locationSpecific floor or level where a particular room is situated within the building.NONAFloor number1
High Voltage Lab2


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.