Import renovations

Renovations can be subject to property units and buildings. It is highly recommended that unit and building renovations are imported in separate sheets, where they are tied to a building or a unit by corresponding building or unit ID's. 

Import building renovations

Certain headers are mandatory in order to import a renovation, but additional details can also be imported by optional headers.

Mandatory headers

In addition to sufficient information to link a renovation to a building (see Overview), importing a renovation requires also the following mandatory fields.

Column title DescriptionAllowed values
PartThe subject of a renovationautomation system, balcony, base floor, cooling system,  electric installations, external wall, facade, fire protection system, heat distribution, heating system, interior, lift, other, roof, sitework, substructure, superstructure, ventilation, water & sanitation, window
RenovationThe type of a renovation*Part change, Miscellaneous repair, Mortar joint repair, Facade painting, Window fences and frames painting, Window sealing, Roof painting
YearThe year a renovation takes placeInteger

* Attempting to import a renovation with an incompatible part will not raise an error, but the renovation is changed to Miscellaneous repair. Furthermore, importing a renovation for a non-existing part will not raise an error, but the renovation is changed to Part change (thus creating the part).

Optional headers

Column title DescriptionAllowed values
DescriptionFree text field for the description of the renovation.Any string
CostThe cost of a renovationInteger

Import unit renovations

Certain headers are mandatory in order to import a renovation, but additional details can also be imported by optional headers. A unit renovation is updated if a unit renovation is already found in the database, where the unit ID, part, and renovation year are equivalent.

Mandatory headers

Column title DescriptionAllowed values
Unit IDThe ID of a unit subject to a renovationString
Unit PartThe subject of a renovation

Bathroom, Kitchen, Unit heating system,Unit door,Unit balcony,Unit window,Unit electrics, Interior surfaces, Other

Unit Renovation YearThe year a renovation takes placeInteger

* Attempting to import a renovation with an incompatible part will raise an error and the renovation will not be saved to the database.

Optional headers

Column title DescriptionAllowed values
Unit Renovation DescriptionFree text field for the description of the renovation.Any string
Unit Renovation CostThe cost of a renovationInteger