I tried to convert a CSV file to XES using the CSV Import Plugin but the outcome is unexpected. I hope the following example illustrates my problem:
startdate, event, trace 16.11.2017, A, Case1
The date is in german format dd.mm.yyyy.
On the "Configure Conversion from CSV to XES" the plugin states it can't autodetect the date format. I shall be given in SimpleDateFormat fashion, therefore I type "d.M.y". After conversion is done the Log inspector activity A occured on 16.01.0201. This is not the expected. What can I do?
If possible, please replace the dots by another character. As an alternative, add an additional trailing dot to the timestamp ("16.11.2017.").
The problem is caused with a 'fix' for the milliseconds in a timestamp: If the trailing milliseconds have more than 3 digits (like 1.2345), this is truncated to three digits (like 1.234). Your date format suffers from this fix, as now the year (xxx.2017) gets truncated (xxx.201).
Answers