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 SkenarioLabs 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 SkenarioLabs 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, lease and maintenance costs and descriptions can be updated by import.
A building is a fundamental element in SkenarioLabs 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)
FI, UK, PT, SE, or PL
The name of the city or town.
street address of the building
or by a national building id (vtj-prt in Finland)
National building id
Finland: 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.
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 SkenarioLabs database, whereas the latter makes no such assumption but creates the building if needed. Units can be imported also with group id only.