You can export the data either a) as a native Excel workbook or b) as
a CSV-formatted text file by clicking on the download arrow on the upper
For report with time buckets, two structures are available:
Uses the same layout as shown on the screen. The time buckets are shown
as columns in the CSV-file.
A separate line is generated for each time bucket. This flat format can
be more appropriate for further processing by other tools.
The export is not limited to the page currently displayed on the screen,
but all pages in the filtered selection will be exported.
A couple of notes on the CSV-format:
- The separator in the CSV-files varies with the chosen language: If in your
language a comma is used as a decimal separator for numbers, the CSV file
will use a semicolon (;) as delimiter. Otherwise a comma (,) is used.
- The date format exported and imported by frePPLe is ‘YYYY-MM-DD HH:MM:SS’.
Microsoft Excel tends to export dates in your local format, which can cause
problems when you save the file again and try to importing it back in frePPLe.
The best approach is to import the cells as text to avoid any conversion.
- The export process will encode the data file in the encoding defined by the
setting CSV_CHARSET (default UTF-8).
Exporting to Excel format avoids these common pitfalls from the CSV
In the Execution screen you also have the capability to export all entities
into a single Excel workbook.