This week, many accounts have been deleted by accident from the ProM forum.

Due to an excessive amount of bogus accounts, we decided a while back that new subscribers were to be treated as applicants, rather than as immediately as members. However, this only shifted the problem, as we now had an excessive amount of applicants. For this reason, new subscribers now need to be invited by an administrator (that would be me). In the process of removing all the bogus applicants, accounts of members have been deleted by accident. We did not realize (in time) that members were still listed as applicants, and that by rejecting an applicant one deletes the associated member as well :-(. So, as a result of rejecting pending applicants, accounts of members were deleted. Sorry for that, won't happen again.

Former members can send me an e-mail (h DOT m DOT w DOT verbeek AT tue DOT nl) asking for an invitation. Also, if you would like to join the forum, please send me an e-mail asking for an invitation.

Eric Verbeek.

XESame with single table and non-unique IDs
  • JBuijsJBuijs
    Posts: 389
    User 'Pachf' asked the following questions in this topic:

    I saw the order example for XESAME, I opened it and it was ok
    (visualization also), but I have a question: it is possible to create a
    mapping for only one data table (no multi table with relations)?

    For example if we have a structure in a csv file:

    ID;date_of_order;date_of_delivery;product
    1;01-01-2011;03-01-2011;A
    1;01-01-2011;04-01-2011;A
    2;01-01-2011;04-01-2011;A
    3;01-01-2011;04-01-2011;B
    3;01-01-2011;04-01-2011;B
    4;01-01-2011;04-01-2011;A
    ...

    It
    XESAME mapping works with non-uniqe ID, if I have only one ID for order
    and delivery (and product delivery are in two phase; e.g. product A
    first with ID 1 then the rest also with ID 1 but at the same day)? So I
    have full processes and I want to define ordering as trace and order,
    deliver as two events.

    Or it works only with more tables (order, delivery, etc.) and links between them?

    Thanks
    Post edited by JBuijs at 2011-01-25 06:17:02
    Joos Buijs
    Forum Admin
  • JBuijsJBuijs
    Posts: 389
    First of all, XESame can extract data from 1 or more tables in 1 database.

    As to your second question, XESame works with non-unique IDs but the resulting event log will be different.

    For example, if you would specify a trace for each ID then you would get 4 trace instances (so in your example there would be traces 1,2,3 and 4). You do not get 2 instances for ID 1 or 2 instances for ID 3. Trace identifiers should always be unique.

    If you would specify an event 'order creation' and relate it to the trace via the 'ID' value then you would get 6 instances of this event in your event log. Two for trace 1, one for trace 2, two for trace 3 and one for trace 4. The timestamp value of this event would be the value of the 'date_of_order' column.
    The same would happen for your event definition of the 'delivery' event. For this event however you specify the 'date_of_delivery' column to contain the date of the event.

    Each record in your data set is treated as an instance of an event, with a certain relation to a trace.
    You could restrict the number of events using SQL critearia in the 'WHERE' attribute of the 'Properties' tab in XESame. Here you can use any normal SQL query that you would write to extract those events (with the trace IDs) that you want.

    For an introduction in XESame the best resource at the moment is my Masters thesis which can be found here:
    http://prom.win.tue.nl/research/wiki/_media/xesame/xesma_thesis_final.pdf

    If you have any remaining questions, please let us know!
    Joos Buijs
    Forum Admin
  • JBuijsJBuijs
    Posts: 389
    In the Connection settings panel, did you enter the '[' and ']' symbols in the 'SQL Query Column Seperator' setting?

    Otherwise, check if there exists a column named 'ID' in your data source.
    Joos Buijs
    Forum Admin
  • JBuijsJBuijs
    Posts: 389
    You can add a file to a post by clicking on the 'Attach a file' link just below the edit box of a new post. It might be a good idea to compress the .mapping file (e.g. zip it) before uploading.
    Joos Buijs
    Forum Admin
  • JBuijsJBuijs
    Posts: 389
    Dear Pachf,

    I tried to run your mapping exactly as you specified it on the proba.csv file exactly as you provided and it works.
    The only thing I did was generate the schema.ini that is used by the ODBC CSV driver. I attached this file to the post (remove the '.txt' part). You might want to try using this schema.ini and run XESame again. If it works, could you tell me what the differences are between the two .ini files?

    Hope this helps!
    Attachments
    		 schema.ini.txt 188B
    Joos Buijs
    Forum Admin
  • JBuijsJBuijs
    Posts: 389
    No problem 'pachf', happy mining!
    Joos Buijs
    Forum Admin
Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

In this Discussion

Tagged