Insert contents from Envoria

To use data from Envoria, firesys provides an interface.

Authentication

If you are working with text KPIs from Envoria, authentication to the WeSustain server is required. In your Word document, click the "firesys settings" button on any firesys tab in the "*firesys" group and select the "Registration" tab. In the "Authentication" Ranges, click the "Add" button.

A dialogue opens in which the server path, the user name and the password must be stored.

Video: Add external service "Envoria"

To use data from Envoria (figures), you need authentication in firesys for this.

The explanation of each step in detail

How to add Envoria as an external service:

• Click on the "firesys settings" button in the ribbon under "*Design" in the "firesys" group.

• Click the "Add" button in the "Registration" tab under the "Authentication to external services" Ranges. The "Add external service" window will open.

• Select "Envoria" in the drop-down menu there, enter your user data and confirm with "Login".

Import data from Envoria

To import the numerical KPIs from Envoria, proceed as follows.

• Set an import definition according to which your data should be inserted into the MeetingPoint. In the "*Content" ribbon, in the "Data import" group, select the "Data import manager" button.

• The Data import manager opens.

• Select the "Create" button in the "Import definition" group. A dialog appears.

• In the dialog you have the possibility to select a data source from which the data should be imported. Clicking on the radio button opens the file selection dialog in which numbers can be imported directly from Envoria.

• Select an organizational unit and a Time period and click on the "Update" button to display the data in the list.

Video: Data import from Envoria

Define how the data from Envoria is transferred to MeetingPoint "modeled" using firesys.

The explanation of each step in detail

How to add a new Import definition of Envoria in the Data import manager:

• Set an Import definition according to which you want your data to be inserted into MeetingPoint. In the "*Content" ribbon, select the "Data import manager" button in the "Data import" group.

• The Data import manager opens.

• Select the "Create" button in the "Import definition" group. A dialog appears.

File selection

• In the dialog you have the option to select a data source from which the data should be imported. By clicking on the menu under "Data source" you get to the "Select data source" dialog. By clicking on the "Envoria" button you can select Envoria data as the source and then confirm with "OK". In the Ranges Details you can add further meta information to the Import definition. An existing key date in the firesys MeetingPoint can be used as the target for your data or a new one can be defined at this point.

• Clicking on "Next" takes you to the "File settings" tab.

File Settings

• Determine if there are column headers in the import file. If this is the case, the option will not transfer the first line of the file. Furthermore, the column separator must be specified so that firesys can correctly recognize and transfer the records.

• In the Ranges "Number format" the decimal separator and the thousands separator of the import file is set.

• Clicking on "Next" will take you to the "Assignment & Options" tab.

Assignment & Options

• In the Ranges "Column Mapping and Preview" the records have to be structured. The Ranges contains the live view of the import options. To import the data into firesys MeetingPoint the columns of the import file must be defined. There are four types for the data columns to choose from:

  • Account

  • Designation

  • Value

  • Comment

• The Account, Designation and Value columns are mandatory for the Data import; the Comment column is optional. All columns can be assigned only once.

• The "Import options" Ranges can be used to create additional options that will be applied when importing the data. Using these options, the data can be modeled and then transferred to the firesys MeetingPoint.

• In the video, an option is created that the account values should be divided by 1 million during the transfer.

• There are more options, the choices depend on the "target column"

• If you want to work with multiple import options the order in which the options should be applied must be defined.

• Clicking on "Complete" will take you to the Data import manager. The created Import definition is now available to you.

• Click on the "OK" button to apply this data to the import definition.

• In the Ranges Details further meta information can be added to the Import definition. An existing key date in the firesys MeetingPoint can be used as the target for your data or a new one can be defined at this point.

• In the "Column Mapping and Preview" Ranges, the data from Envoria is already mapped to the required structure of firesys. Additional Import options can be created to be applied when the data is imported. Using these options, the data can be modeled and then transferred to the firesys MeetingPoint.

• The connected data is imported by firesys using the Data import. In the Data import manager, you can recognize the imports from Envoria via the Envoria icon. The number KPIs can be used by the function insert account values or the function automate worksheet in Excel to create "automated" tables.

See also

External services
Insert contents from WeSustain

Further contents

→ firesys website
→ Customer area
→ YouTube