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.

Note: The 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.