Bulk Room Import
The Bulk Room Import allows you to create or update multiple rooms at once using a CSV file. This is useful when initially setting up Manage1to1 or when adding rooms across multiple buildings.
CSV Format
Your CSV file must include a header row. Download the CSV Import Template for the correct format.
Required Columns
| Column | Description |
|---|---|
| Name | The name of the room (e.g., "Library Media Center", "Computer Lab 101") |
| Building Name | The name of the building this room belongs to. Must match an existing building in Manage1to1. You can also use the building's SIS code. |
Optional Columns
| Column | Description |
|---|---|
| Floor | The floor the room is on (e.g., "1st Floor", "2nd Floor", "Basement") |
| Comments | Any additional notes about the room |
| Responsible Staff | Comma-separated list of staff Local IDs to assign as responsible persons (e.g., "T1001,T1002"). Staff must be active with a matching Local ID in the system. |
How It Works
- Navigate to Settings → System Utilities
- Scroll to the Bulk Room Import section
- Upload your CSV file using the upload area
- Once uploaded, click Execute Room Import to process the file
Matching Behavior
Rooms are matched by Name + Building. When processing:
- If a room with the same name already exists in the same building, it will be updated with any new values from the CSV
- If no matching room is found, a new room will be created
- If the building name cannot be found, that row will be skipped and logged as an error
Building Resolution
The Building Name column is flexible — Manage1to1 will try to match it in the following order:
- Building name — matches against the building display name (case-insensitive)
- SIS/Building code — if no name match is found, tries to match against the building's SIS code
This means you can use either the full building name (e.g., "Lincoln Elementary") or the SIS code (e.g., "10300") in your CSV.
After Import
After the import completes, you'll see a summary showing how many rooms were created, updated, or failed. Any errors are logged to the Activity Log with details about which rows failed and why.
Tips
- Download the template first to ensure your columns are in the correct order
- Check your building names before importing — if a building name doesn't match, those rooms will be skipped
- You can run the import multiple times safely — existing rooms will be updated, not duplicated
- Keep room names consistent — "Lab 101" and "Computer Lab 101" would be treated as different rooms