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.
Certain headers are mandatory in order to import a renovation, but additional details can also be imported by optional 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).
Column title | Description | Allowed values |
---|---|---|
Description | Free text field for the description of the renovation. | Any string |
Cost | The cost of a renovation | Integer |
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.
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 heating system,Unit door,Unit balcony,Unit window,Unit electrics, Interior surfaces, Other |
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.
Column title | Description | Allowed values |
---|---|---|
Unit Renovation Description | Free text field for the description of the renovation. | Any string |
Unit Renovation Cost | The cost of a renovation | Integer |