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.
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.