Timestamp incorrect after converting from CSV to XES

LexHanze

I got event logs with date and time with fractional seconds and the problem is when I try to convert the csv with the "Convert CSV to XES" plugin the result of date/timestamps is not correct. For example, the timestamp in the CSV file is "2017-04-06 05:45:11.098000000" and the time in the XES file turns out like this: "07.04.2017 08:58:31.000". This are my settings in the plugin:


I changed the order of my date in the CSV file from: "2017-04-06 05:45:11.098000000" to "06-04-2017 05:45:11.098000000" and now it does display the correct timestamp only the fractional seconds are all set to 0 after conversion. So the end result after conversion is this: "06-04-2017 05:45:11.000". I'm still missing the fractional seconds I desperately need. The dateformat at the time of conversion is: "dd-MM-yyyy HH:mm:ss.SSS" but it doesn't work apparently.
Can anybody help me with this problem?

JBuijs

Hi Lex,

did you try to put in 9x S in the format string? Since the fraction has 9 digits, I guess you need your format string to match this.

Let me know if this helps.

fmannhardt

Hi Lex, which ProM version are you using. There has been some recent improvement with regard to milliseconds. Maybe try out the current nightly build.

LexHanze

Hi all,

Thanks for the reply's! I removed 6 zero's from my milliseconds and than it worked. So Joos I think you are right about the 9 times S solution.

Everybody thanks for the help!

LexHanze

Hi Joos,

I want to select yes on the question: Did this answer the question? But I get a "Fatal Error in PHP.trigger_error();". So at the moment I can't accept your answer as being correct.

JBuijs

Thanks for letting me know! I've put it on my todo list