Report to Pull Building and Room Details

Lindsey Bryant

Has anyone found a way to pull all of the building and room information that has been configured under Settings > School Information > Buildings?

There are a couple of “System” reports that are available but it's not a complete list. For example, I need “room_code” which isn't an output. I also need all buildings and rooms, not just those that are part of a schedule or for a dorm.

When I went to create a basic or advance list, I didn't see a way to get to this system information. Has anyone else successfully pulled all building and room data out?

Erin Walton

Hello @Lindsey Bryant,

We can't pull room code in from the display fields that we have by default in the advanced lists, however there is a workaround using a custom field which can be added to include the Room Code and tied to each room. This custom field Room code field can be pulled into the advanced list.

To create this custom field, Navigate to Core > Settings > General Settings. Once here, select the Custom fields tab, scroll down to Admin view only fields, and select +Add field. Title the Field name ‘Room Code’, set status to active, set text field form control, location set to Room, and select no for both Required and Unique.

Once finished setting this up, the Admin view only field will need added manually to each room. To do so, navigate to Core > Settings > School information > Buildings. Select the pencil icon for an individual room to edit the room settings, at the bottom of the settings you should see the opportunity to select the ‘Admin Viewable only field’. Select the ‘Room Code’ admin view field from the dropdown > click on the blue text for ‘Add Additional Field’. The text box should appear to manually enter the room code.

Within the advanced list setup, make sure ‘Academic Room’ object (lives in Academic Group) is added and then within the Custom Field objects, expand to add ‘Custom Field - Room’. When adding the display fields, you should see a description for the newly added ‘Room Code’ field under ‘Custom Field - Room’ to mark and display.

As long as the buildings setup have Dorm group type included, you will be able to pull on this data as well using the ‘Dorm Room' object (lives in Dorm Group) and again the ‘Custom Field - Room’ object tied to it.

Pulling on all building and rooms can be achieved in the advanced lists by starting a new advanced list, and adding each of the group type Room objects along with a single instance of Custom Field - Room. For example, select Academic Group > Academic Room. Select Custom Field > select the Room Code custom field. Select Activity Group > Activity Room. Select Advisory Group > Advisory Room, etc. Make sure to uncheck the Inner join boxes for each object or the list will omit results if any object data is missing.

I hope this helps!

Erin

Lindsey Bryant

@Erin Walton

Thanks for the detailed response. I did find an API that allows us to get to the data, which will solve my immediate issue. Creating a custom field sounds like a nice work around but realistically, if it's a data point already in the system and built. I would think we can easily get it out of the system through a report and it appears to be a shortcoming.