Bulk upload Excel columns
Summarize
Summary of Bulk upload Excel columns
The bulk upload template allows users to efficiently input information regarding campuses, buildings, and floors into the system, facilitating enhanced mapping features and scenario planning capabilities.
Show less
Key Features
- Campus Template: Includes columns for campus name, title, address, country (ISO code), geographic coordinates, and options to enable features like Kiosk View, Scenario View, and Default View.
- Building Template: Captures building name, title, address, campus name, geographic coordinates, and feature enablement similar to the campus template.
- Floor Template: Contains columns for floor number, name, title, short title, building name, campus name, source file name, source file unit, and feature enablement options.
Key Outcomes
By utilizing the bulk upload template, ServiceNow customers can streamline the process of mapping campus infrastructure, enhance indoor navigation, and improve scenario planning, ultimately leading to better resource management and user experience within their facilities.
Use the bulk upload template to provide information about your campuses, buildings, and floors.
| Column | Description |
|---|---|
| Campus Name | Unique identifier of the campus. This column is limited to 255 characters. |
| Campus Title | Title of the campus that is displayed on the map views. |
| Campus Address | Physical address of the campus. This column is optional. |
| Country | Country in which the campus is located. You must use the ISO 3166-1 Alpha-2 code for the country. |
| Marker latitude | Geographic latitude coordinate for the campus in the decimal degrees format. |
| Marker longitude | Geographic longitude coordinate for the campus in the decimal degrees format. |
| Enable in Kiosk View | Option to enable the campus for the Kiosk Indoor Mapping feature. You must fill in YES or NO in this column. |
| Enable in Scenario View | Option to enable the campus for the Scenario Planning feature. You must fill in YES or NO in this column. |
| Enable in Default View | Option to enable the campus for the Default Indoor Mapping feature. You must fill in YES or NO in this column. |
| Column | Description |
|---|---|
| Building Name | Unique identifier for the building. This column is limited to 255 characters. |
| Building Title | Title of the building that is displayed on the map views. |
| Campus Name | Name of the campus in which the building is located. The name must match an existing campus. |
| Building Address | Physical address of the building. This column is optional. |
| Marker latitude | Precise latitude coordinate for the building in the decimal degrees format. |
| Marker longitude | Precise longitude coordinate for the building in the decimal degrees format. |
| Enable in Kiosk View | Option to enable the building for the Kiosk Indoor Mapping feature. You must fill in YES or NO in this column. |
| Enable in Scenario View | Option to enable the building for the Scenario Planning feature. You must fill in YES or NO in this column. |
| Enable in Default View | Option to enable the building for the Default Indoor Mapping feature. You must fill in YES or NO in this column. |
| Column | Description |
|---|---|
| Floor Number | Unique numerical identifier for the floor. |
| Floor Name | Name of the floor. This column is limited to 255 characters. |
| Floor Title | Title of the floor that is displayed on the map views. This column is optional. If this column is empty, the Floor Name is displayed on the map views. |
| Floor Short Title | Abbreviated title of the floor. This column is optional. If this column is empty, the Floor Number is used for identification. |
| Building Name | Name of the building in which the floor is located. The name must match an existing building |
| Campus Name | Name of the campus in which the building is located. The name must match an existing campus. |
| Source File Name | Name of the CAD file that contains the floor plan. |
| Source File Unit | Unit of measurement used in the source CAD file. You must select from the following:
If this column is empty, INCHES is used as the source file unit. |
| Enable in Kiosk View | Option to enable the floor for the Kiosk Indoor Mapping feature. You must fill in YES or NO in this column. |
| Enable in Scenario View | Option to enable the floor for the Scenario Planning feature. You must fill in YES or NO in this column. |
| Enable in Default View | Option to enable the floor for the Default Indoor Mapping feature. You must fill in YES or NO in this column. |