Export of processes
You can export process data completely or filtered, for example for data backup.
An export function for the process data is available to the user as an icon in the BPC toolbar, for example to post-process part of the process data or to make it available to another department.
It is up to the user which data is exported. A maximum number of data records must be specified for export for the XLSX file format because XLSX exports are resource-intensive. A limit ensures stable and quickly usable Excel files. The default value is 10,000 data rows. No limit is necessary for other file formats.
The user does not make any selections in the first step and starts the export function using the icon on the BPC toolbar. In the new window that opens, the user decides on the file format to which the process data is to be exported. In addition, the limit of data lines after which the data lines in the export file are to be truncated can be defined.
^ However, it is recommended to limit the dataset before the actual export, e.g. using the filter functions. In this way, defined data volumes can be exported in advance for further use.
Activating the export icon also opens a window here, which the user can use
-
to specify the file format in which the data should be exported
-
A new line limit can restrict the export of data volumes that are still too large
Only export certain columns (take current view into account)
The user has the option of only exporting the columns that they currently see on their screen. To do this, as in the image above, the option Include current view must be activated.
Export child data
In addition to exporting data records, it is also possible to include the processing history (the child data) of each data record in the export. To do this, the option Export history/child data option must be activated in the export window.
Open CSV export file with Excel
Once the monitor data has been exported, the file can be opened on your local computer. A coding error may occur when opening the CSV file with Excel, which contains German umlauts.
The error can be reproduced as follows:
Open the CSV file. The file is automatically opened with the suggested software (in this case Excel). As a result, the opened file is defective (see below), for example, the umlauts and special characters are decoded and displayed incorrectly. This error is already known (see also http://blog.wenzlaff.de/?p=12084). The cause is that Excel does not recognize the coding correctly when automatically opening a file.
You could also export an Excel file in the monitor. There will then be no problem when opening. If you do want to export the CSV file and then open it with Excel, the error described above can be corrected as follows:
-
Open a new tab in Excel.
-
Select File > Import in the application bar.
-
Select CSV in the newly opened window.
-
Select the Unicode (UTF-8) option.
The file is now displayed correctly.
