Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
You can import buildings, units and renovations by an Excel document on Skenarios service's Import & Export-page. Buildings, units and renovations can be uploaded in single or separate Excel sheets and the sheets can contain only predefined set of columns.
How to
Go to the Export & Import view.
Choose the portfolio where data should be imported or create a new one.
For new portfolios, you can give a title for the portfolio.
Before import, you can also choose if Skenarios should assume all properties to have their renovation history done by assumed renovations. If you choose not to generate historical renovations, all needed renovations and repairs are scheduled for the next year.
After a successful upload, you will be informed which sheets and rows in the uploaded file are invalid and not uploaded to the Skenarios database. A row might be declared invalid if a mandatory cell is empty, or there is a spelling error. Fix these rows appropriately according to these instructions.
Import file format
The first row in the Excel file is a header row, but the order of the headers is not fixed. For headers, you can use lower and upper case letters as you wish, but a misspelling yields an erroneous result.
Below the header row are the actual data rows. Import Excel can only be used to upload new properties; it cannot be used to update existing properties. However, renovation costs and descriptions can be updated by import.
Overview
A building is a fundamental element in Skenarios and thus any imported unit or renovation has to be tied to a building. A building can be imported by an address (which is composed of a country code, city, postcode and street address)
Column title | Description | Allowed values |
---|---|---|
Country code | FI, UK, PT, SE, or PL | |
City | The name of the city or town. | String |
Postcode | Post code | String |
Street address | street address of the building | String |
or by a vtj-prt (only applicable in Finland)
Column title | Description | Allowed values |
---|---|---|
vtj-prt | Permanent Construction ID (VTJ-PRT) is issued to all buildings in Finland. It can be used to identify the exact location of the building. Enter only if you know the actual ID. | String |
As almost any type of import has to be tied to a building, it has to be imported with building details (that is, address or vtj-prt) or a building ID. These two methods have a significant difference; the latter assumes the building in question is already in Skenarios database, whereas the latter makes no such assumption but creates the building if needed. Units can be imported also with group id only.
Importing buildings
Buildings can be imported by an address or vtj-prt, that is, the four components composing an address or vtj-prt are mandatory headers to import a building. For further details, see Overview. In addition, further details of a building can be imported by optional headers.
Examples using only the mandatory headers
a) A building at Example Street 1, 00100 Helsinki, Finland, is a single construction and has two staircases, A and B.
In this case,
Country code: FI
City: Helsinki
Postcode: 00100
Street address: Example Street 1
b) If both Example Street 1 A and Example Street 1 B are separate constructions, consequently both buildings would have their own street addresses:
Street address: Example Street 1 A
and
Street address: Example Street 1 B
Optional headers
The volume of a building in m3.
Import custom properties
It is possible to import values for 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 Settings page.
To import value for custom property field, enter title of the property field as a header to the Excel sheet as it would be any normal field. If there are multiple fields with the same title, first field will be used, but it remains undecided, which one.
Importing Units
Certain headers are mandatory in order to import a unit, but additional details can also be imported by optional headers.
Mandatory Headers
In addition to the unit identifier (Unit id or Unit specifier), full address, vtj-prt, building id, or group id is required in order to import a unit. A unit identifier can either be a unit id or a unit specifier. While each unit specifier has to be unique for a given building, a unit id has to be unique in the entire portfolio.
Optional headers
Import custom properties
It is possible to import values for unit'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 Settings page.
To import value for custom property field, enter title of the property field as a header to the Excel sheet as it would be any normal field. If there are multiple fields with the same title, first field will be used, but it remains undecided, which one.
Importing 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.
* 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).