Adding buildings and locations
When using the Commercial Property Buildings spreadsheet to add buildings, you can do any of the following:
- Add buildings to existing locations
- Add buildings to new locations
- Add multiple buildings to the same new location
In the Commercial Property line, buildings cannot
exist on their own—they are child entities of locations. When a new
building is created, it must be attached to a location, either an existing
or newly-created location. In the base configuration, importing a building
that has the LocationID
of an existing location creates the new building in the existing location.
Importing a building that has a blank
or unused LocationID creates
the new building in a new location. Importing multiple buildings with
identical invalid LocationID
fields creates a new location containing all of the new buildings. PolicyCenter
converts the invalid Loc ID
columns from the spreadsheet into valid LocationID field values when the
imported spreadsheet is accepted.
LocationID field is key. If the
LocationID does not exist
in the PolicyCenter database, the import operation creates a new location,
even if all of the address fields exactly match an existing location.
To determine the LocationID
of all of the locations defined within a policy, export a Commercial
Property Locations spreadsheet and find the location IDs in the Loc ID column.