Configure detected data types
PPM automatically detects the data types of the contained process data. The Configure detected data types page displays the CSV file settings and a table with a preview of the data. The table contains a maximum of the first 100 data rows. Depending on the number of columns, it could be that fewer rows are shown in preview. If the data was not recognized correctly, you can edit the CSV file settings and change the data type assignment.
The data types of the process data are displayed in the header of the individual data columns. The headers correspond to the headers from the CSV file. If there are some values not set in the CSV file, the corresponding cells are empty in the preview table. Additionally, if a column value cannot be parsed with the configured data type, the cell is highlighted in red. Only the values shown in the preview table are parsed with the configured data type. So it is possible that the data not displayed may also contain values that cannot be parsed either.
Note that this page cannot be edited if you have opened the page using the View project option on the Manage project page.
Click CSV file settings to change the CSV parameters.
Select an encoding from the corresponding drop-down menu, or enter an encoding manually.
The default encoding is UTF-8.
Select a separator from the corresponding drop-down menu, or enter a separator manually.
The default separator is ;.
Select a mask character from the corresponding drop-down menu, or enter a mask character manually.
The default mask character is ".
Click Refresh to reload the process data.
The process data is reloaded according to the CSV file settings and displayed in the data table.
Click on a header of a data column to edit the data type of the corresponding process data.
Select a data type from the Data type drop-down menu.
You can set further parameters according to your selection.
For the data type Number, you can specify the grouping character and the decimal separator.
For the data type Time, you can select a time format in the appropriate drop-down menu, or enter a time format manually. For details on the possible formats, see the table below.
Click X to close the dialog.
Your settings are applied and the data in the preview table is updated accordingly.
Click Next.
Your settings are applied.
If you want to return to the previous wizard page, click Previous. To exit the wizard, click Cancel. If you click Cancel to close the dialog, the configuration is deleted and the Manage projects page opens.
Data in the format attribute corresponds to the Java time stamp format:
Symbol | Description | Data type | Example |
|---|---|---|---|
G | Epoch identifier | Text | AD |
y | Year | Figure | 2003 |
MM | Calendar month | Figure | 09 |
MMM | Calendar month | Text | Sep |
MMMM | Calendar month | Text | September |
d | Calendar day | Figure | 26 |
h | Hour, American notation (1-12) | Figure | 12 |
H | Hour (0-23) | Figure | 14 |
m | Minute | Figure | 42 |
s | Second | Figure | 57 |
S | Millisecond | Figure | 978 |
E | Day of the week | Text | Thursday |
F | Recurrence of weekday in month | Figure | 2 |
D | Day of the year | Figure | 189 |
w | Calendar week | Figure | 27 |
W | Week of the month | Figure | 2 (2. week of the month) |
a | Time of day identifier | Text | PM |
k | Hour (1-24) | Figure | 24 |
K | Hour, American notation (0-11) | Figure | 7 |
z | Time zone | Text | GMT |
´ | Escape character for text | Characters | 'Example text' |
´´ | Simple apostrophe | Characters | 'Example' 'Text' |