Bulk upload Excel columns
Summarize
Summary of Bulk upload Excel columns
This bulk upload template enables ServiceNow customers to efficiently import detailed information about campuses, buildings, and floors into the Indoor Mapping application. Using Excel sheets structured according to the provided templates, customers can define key location attributes and configure visibility settings for multiple indoor mapping features.
Show less
Campus Template
The campus template requires fields such as:
- Campus Name: Unique identifier (max 255 characters).
- Campus Title: Display name used on map views.
- Campus Address: Optional physical address.
- Country: ISO 3166-1 Alpha-2 country code.
- Marker latitude and longitude: Geographic coordinates in decimal degrees.
- Feature enablement flags: YES/NO options to enable the campus for Kiosk Indoor Mapping, Scenario Planning, and Default Indoor Mapping views.
Building Template
The building template includes:
- Building Name: Unique identifier (max 255 characters).
- Building Title: Display name on map views.
- Campus Name: Must match an existing campus.
- Building Address: Optional physical address.
- Marker latitude and longitude: Precise geographic coordinates.
- Feature enablement flags: YES/NO options to enable Kiosk, Scenario, and Default Indoor Mapping views for the building.
Floor Template
The floor template requires comprehensive details, including:
- Floor Number: Unique numerical identifier.
- Floor Name: Name of the floor (max 255 characters).
- Floor Title and Floor Short Title: Optional display names; default to Floor Name and Floor Number if empty.
- Building Name and Campus Name: Must match existing entities.
- Source File Name and Source File Unit: CAD file details; unit must be selected from an extensive list of supported units (default is INCHES if unspecified).
- Feature enablement flags: YES/NO options to enable the floor for Kiosk, Scenario, and Default Indoor Mapping views.
Practical Use and Benefits
By correctly populating these templates, customers can bulk import location data directly into ServiceNow’s Indoor Mapping system, ensuring accurate geographic and structural representation. The feature enablement columns allow precise control over which views display each campus, building, or floor, facilitating tailored indoor navigation and planning experiences.
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. |