To prevent spam users, you can only post on this forum after registration, which is by invitation. If you want to post on the forum, please send me a mail (h DOT m DOT w DOT verbeek AT tue DOT nl) and I'll send you an invitation in return for an account.
Problem with dates on eventlog
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
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
Comments
-
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)
-
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.
-
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)
-
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.
-
Hi bfvdonge,
Thanks for your effort. I am using a csv file exported from the dsc file provide by Fluxicon.
Regards
Howdy, Stranger!
Categories
- 1.6K All Categories
- 45 Announcements / News
- 224 Process Mining
- 6 - BPI Challenge 2020
- 9 - BPI Challenge 2019
- 24 - BPI Challenge 2018
- 27 - BPI Challenge 2017
- 8 - BPI Challenge 2016
- 68 Research
- 1K ProM 6
- 393 - Usage
- 287 - Development
- 9 RapidProM
- 1 - Usage
- 7 - Development
- 54 ProM5
- 19 - Usage
- 187 Event Logs
- 32 - ProMimport
- 75 - XESame