› ›
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 converting csv file to mxml file using Prom Import framework

achilambiachilambi Posts: 3
edited August 2012 in - ProMimport

When I import the CSV file it says Import was not possible (bad file) How should I convert the file to Mxml format

achilambi

Answers

  • pporouhanpporouhan Posts: 4
    I have the same problem too! :( Anyone can help?
  • pporouhanpporouhan Posts: 4
    I can not Convert to MXML/XES using PromImport and XESame!
    Unfortunately, demo version of Nitro also converts only 3% of the process!
    Anyone can help us? How can we convert Excel, XML, Access Database or CSV files into MXMLor XES?
    Is there any other way much easier than XESame, PromImport or Nitro?

  • nicogschnicogsch Posts: 9
    edited September 2012
    Hi,
    Try to use XESame. First at all, you must read the Master Thesis made by J.Buijs. (http://www.processmining.org/_media/xesame/xesma_thesis_final.pdf)
    Then you should convert your own csv files.
    The main steps that you need to do:

    1. If you are using Microsoft Excel or any CSV file, you must config the data source on ODBC Data Source Administrator. (http://www.oraclenerd.com/2010/02/obiee-text-file-as-data-source.html)
    2. Give all rights to the windows user as Admin.
    3. Open XESame (1.1)
    4. Set the url to database connection: jdbc:odbc:NAME (The name is the same that was created in the first step. It can be different if you are using another DB so you must set the jdbc driver too)
    5. Make the sql to Log, Trace and Event (See the examples)
    6. Set the output location and the format type (XES or MXML)
    7. Execute conversion 
    8. Hands on Prom

    I hope this helps,
    Regards.

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