A system event file to be imported must use the formats supported by PPM, or a data format transformation must be configured. Use CTK to configure the data format of the source data. The data format is transformed into the required PPM format during the import.
See also chapter Data format transformation.
PPM supports the following formats.
must not contain commas (,) or periods (.) as separators (e.g., 9000).
must contain only a period (.) as a separator (e.g., 3.14).
The character strings WEEK, MONTH, and QUARTER are not interpreted. They only serve to interpret the numbers that follow them.
Please refer to this page for detailed explanations of the date formats:
http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html
The number of characters defines the minimum number of numbers. For example, the characters dd define a date with two numbers, such as 02, 08, 13, 25. The character d, however, defines a date with at least one number, such as 2, 8, 13, 25.
Each date format imported is set to the second-most detailed level of accuracy by selecting a neutral, smaller time unit for missing units. For example, if a month is missing, the value is set to January, and if a day is missing, the value is set to the first day of the month. Hours, minutes, and seconds are set to zero.
For imported time stamps, the time zone of the server applies.
Define custom time stamps
You can define additional time stamp formats. For the following keys common time stamp formats are specified in the file AdapterConfig_settings.properties.
These settings apply to the entire client, the XML import (graph format only), and all Data analytics data imports (including other tables, analysis realms, and Process analysis).
During date format conversion, the format stored in the XML_DATEFORMAT key is applied first. If this fails, the XML_DATEFORMAT_ALTERNATIVE is applied. If this fails, as well, the date is interpreted as a PPM default format. If no format can be applied, an error message is displayed and the event is skipped for import.