...
In addition to a unique building id, a full address, a national building id, or coordinates are mandatory to import a building.
Column title | Description | Allowed values |
---|---|---|
Building id AND | A unique building id. | Unique string |
Latitude and longitude OR | Make a column for latitude and a column for longitude. The coordinates are to be inside the building. | Numeric |
National building id OR | Specifies the unit in a building. The full address of the building is required when using the Unit specifier without Unit id. Unit specifier value can be anything which is unique within the given address. | Any string |
Country code, postcode, street address and city | Make a column for each of the four titles. Country code can take values FI, CA, CH, PL, SE, PT, UK, US. | String |
Optional headers
Column title | Description | Allowed values |
---|---|---|
Group id | Used to identify which group this property belongs to. If this is not given, it'll be created automatically. | Any string |
Group name | Name of the property group. If this is not given, it'll be created automatically for you. | Any string |
Building name | Name of the property building. If this is not given, it'll be created automatically for you. | Any string |
Building prototype | Usage type of the property building. | detached house, terraced house, office, apartment, commercial building, row house, school, retail building, industrial building, generic building, garage, warehouse and holiday home. |
Electricity energy type | grid electricity | |
Heating energy type | electric heating, district heating, oil boiler, gas boiler, ground-source heat pump, wooden pellet burner, solar hot water collector, gas condensing boiler, water source heat pump, eluppvärmining, fjärrvärmning, olja, and bergvärmepump | |
Building floor area | Gross floor area of the building in m2. | Integer |
Floors | Amount of levels in the building. Ground floors is counted as one. | Integer |
Floor height | (Average) floor height in the building in metres. | Integer |
Build year | Build year of the building. | Integer |
Building volume | The volume of a building in m3. | Integer |
Facade | The facade material of the building. | brick, concrete, metal, plaster, wood |
Roof | The roof material of the building | bitumen, metal, tile |
Car parking | Type of car parking | None, Parking space, Garage, Carport, Undercover parking |
Lot size in m2 | Lot size in m2 | Numeric |
Own lot | Own lot | Boolean |
Is waterside lot | Is waterside lot | Boolean |
End year of lot lease | End year of lot lease | Numeric |
Garden building(s) | Garden building(s) | Boolean |
Is housing company | Is housing company | Boolean |
Property image URL | Property image URL | Text |
Import custom properties
It is possible to import values for the building's custom property value fields such as property image. Prior to a custom field import, however, it is mandatory to create the field for a portfolio. For more information about creating a custom field, please refer to the Settings page.
...
A unit id is mandatory in order to import a unit. A unit id has to be unique in a portfolio. In addition, units are required to be linked to a building or a group (or both) by a building id or a group id.
Column title | Description | Allowed values |
---|---|---|
Unit id | Specifies the unit in a portfolio. If this is not given, it'll be created automatically. | Any string |
Building id OR | The id of the building where the unit is located | Any string |
Group id OR | The id of the property group where the unit is located | Any string |
Optional headers
Column title | Description | Allowed values |
---|---|---|
Unit name | Name of the property unit. If this is not given, it'll be created automatically. | Any string |
Unit description | Free text field for the description of the unit. Also, all information under the headers in your file that are not listed in these instructions will be presented here. NOTE: rows, where the header is misspelt will appear here. | Any string |
Unit price | Property units total value in local currency. Current date will be used as the value date. | Integer |
Total floor area | Unit's total floor area in m2. | Integer |
Unit Habitable Floor Area | Unit habitable floor area in m2 | Integer |
Unit usage type | Type of usage purpose of the unit. Allowed values are: Residential, Office, Retail, Storage or Other | String |
Unit floor | Unit's floor. Number 1 being ground floor. | Integer |
Condition | Unit's condition | Excellent, New, Good, Mediocre, Poor |
Number of rooms | Number of rooms | Integer |
Sauna | Type of sauna. Only for residential units in Finland. | Yes, No, Sauna building, Lakeside sauna |
Type of Balcony | Type of balcony | Balcony, Glazed Balcony, French Balcony |
Type of Kitchen | Type of kitchen | Kitchen, Open Plan Kitchen, Kitchenette |
Type of Terrace | Type of terrace | Yes, No, Glazed Terrace |
Has fireplace | Has fireplace | Boolean |
Monthly Maintenance Fee | Monthly maintenance fee | Integer |
Monthly Housing Loan Fee | Monthly housing fee | Integer |
Mortgage Application Id | Mortgage application Id | String |
Import custom
...
attributes
It is possible to import values for the unit's custom property attributes value fields such as property image. Prior to a custom field import, however, it is mandatory to create the field for a portfolio. For more information about creating a custom field, please refer to the Settings page.
...