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
Description
Allowed values
Part
The subject of a renovation
automation 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
Renovation
The type of a renovation*
Part change, Miscellaneous repair, Mortar joint repair, Facade painting, Window fences and frames painting, Window sealing, Roof painting
Year
The year a renovation takes place
Integer
* 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
Description
Allowed values
Description
Free text field for the description of the renovation.
Any string
cost
The cost of a renovation
Integer
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
Description
Allowed values
Unit ID
The ID of a unit subject to a renovation
String
Unit Part
The subject of a renovation
Bathroom, Kitchen
Unit Renovation Year
The year a renovation takes place
Integer
* 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
Description
Allowed values
Unit Renovation Description
Free text field for the description of the renovation.