Problem with dates on eventlog

talesfc

Hi,

I am having some problem with dates on the eventlog. The Challenge descripton says the eventlog presents a set of purchase order events submitted in 2018. However, when importing either the xes file in PROM or the dsc file in DISCO, the registered start date appears as "01 jan 1948" and end date is "09 april 2020". 

Also, when trying to export imported log in PROM to a CSV file, import fails due to java error.

regards

Tales Costa

talesfc

Just checked that there are 7 cases with future end dates (case ends after 2018) and 50+ cases with old start dates (case starts before 2018) 

bfvdonge

Yes, there may be data entry errors. That's normal in real-life processes. Feel free to deal with them in any way you see fit.

bfvdonge

As for the issues with ProM, please provide detailed descriptions on how to reproduce the errors, but do this in the proper category (this question is not BPI Challenge specific)

bfvdonge

I was able to reproduce the problem of exporting to CSV in ProM. If you want the CSV version of the data, you can download it here: http://icpmconference.org/wp-content/uploads/BPIChallenge2019CSV.zip

The CSV file has Literal columns which contain free text. Sometimes, they contain also the "," symbol which is used in the file to separate columns. To properly parse each line, you can use the following code in Java: String.split(",(?=([^\"]*\"[^\"]*\")*[^\"]*$)"). This regular expression splits each line on a "," symbol, but ignores any parts between double quotes. After splitting your String.trim() to remove the quotes from the items.

talesfc

Hi bfvdonge,
Thanks for your effort. I am using a csv file exported from the dsc file provide by Fluxicon.
Regards