A maintenance i subject to a property unit and it is highly recommended that maintenances are imported in a separate sheet, where they are tied to a unit by the corresponding ID. Certain headers are mandatory in order to import a maintenance, but additional details can also be imported by optional headers.
If a unit ID, date and type are imported via Excel, but the corresponding values are already in the database, the existing maintenance is updated.
Mandatory headers
Column title | Description | Allowed values |
---|---|---|
Unit ID | A unit ID of the unit subject to the lease contract | String |
Unit maintenance cost | Cost of the maintenance | Number |
Unit maintenance date | Date of a maintenance | Date |
Unit maintenance type | Type of maintenance | Bricklaying, Carpenter, Drainage & Groundworks, Electrician, Floorer, Fitter/Cleaner/Handyman/PlastererRepairs, Gas & Heating, Glazier, Misc, Plumber, Roofer, Safety & Security |
* Attempting to import a maintenance with an incompatible part will raise an error and the row will not be saved in the database.
Optional headers
Column title | Description | Allowed values |
---|---|---|
Unit maintenance description | Free description | String |