›

Converting csv file to xes file

MunaMuna Posts: 23
in Process Mining
I'm using the related plugin in prom framework to convert a csv file to a xes file
I'm getting an exception : index out of bound.
The exception is returned in the first step of the plugin.


here is an example of the schema of the file: 
(the file  is exportd from oracle database)

What can be the error due to?
I'm using the lastest version of prom (6.9)



Tagged:
file.JPG 32.8K
exep.JPG 46.1K

Comments

  • hverbeekhverbeek Posts: 910
    Hi,

    A possible explanation for this is that not all lines in the CSV file have the same number of fields (columns).

    As far as I can see, you're using the semicolon as separator character. Are there any fields that contain semicolons? If so, this may result in the filed to be split into multiple fields.

    Kind regards,
    Eric.
  • MunaMuna Posts: 23
    edited August 2019
    Okaay,I checked that,
    And I've changed the separator to double quote for each entry of the file.
    As all the data is exported from oracle database, I'm sure that every line has the same number of columns.

    And no there are no fields containing semicolons


    Post edited by Muna on
Sign In or Register to comment.