7 - Database Center

The Database Center is the page giving you the overview on all your data. On this page, you can can also download databases or upload databases to the WebApp from other sources.

Overview of the available databases

Within the Sympheny Database Center (icon :databaseicon: at the bottom left of your screen), you have access to up to two databases:

• My User Database: this database is your own private database. Individual users can directly maintain this database.

• “Organization” Database: this is the database specific to your organization (available for Enterprise clients). This database is named after your organization, and only accounts from your organization have access to this data. The assigned Super Users from your organization can maintain this database, such as uploading and deleting data. The data is available for all accounts within your organization.

Download databases

It may be useful to download your database if you would like to have an overview of all of your data or do some post-processing, adjusting, etc.

To download your data, simply navigate to the database and the type of data you’d like to download (e.g., Energy Demands, On-site Resources or the category of Technologies). On the right side of your screen, you will see a Download button. After clicking on it, scroll to the bottom of the page, where you’ll have to press the download arrow, to open the data in excel.

Tip: The format of the downloaded excel file is the same that the one required for the upload of databases.

By default, the uploaded data will be “added“ to the existing database. If you wish to Replace the entire database, you can unclick “Append to existing data“. Please note, the existing data will be Removed.

Upload databases

Format/Template

To upload data to your databases, you first have to prepare your data with the correct format. Different parameters can be entered depending on the type of data you wish to upload.

Here you can download the templates for the upload of storage and conversion technologies:

Conversion-Technology-Template.xlsx

Storage-Technology-Template.xlsx

Energy Carriers (EC) have to follow the exact nomenclature given in the table below.

Nevertheless, after adding a specific technology from the scenario editor, the Energy Carriers can be changed to any other ECs that are available in the respective scenario.

Upload

Similarly to the download steps, select the database you wish to replace/add data to as well as the type of data (Energy Demands, On-site Resources or the category of Technology). As prompted, drop or click to select your file and then press upload.

If you want to add data to your existing database, make sure to leave the box ‘Append existing data’ ticked. This will add the new data to your existing database. Unticking this box means your data will be fully replaced.

Finally, note that the databases that you are allowed to modify depend on your roles and permissions within your organization.

Roles & Permissions

Depending on the account type and the license, different rights are available to different users.

Direct upload within the Scenario

Single items can also be uploaded to My User Database directly from the scenario editor (i.e., Setup), by ticking the box ‘Save the technology for future use?’.