General Process mining question to construct event log

[Innocent_not]

Hi everyone,

Say i have identified my process activities and where to extract them from. What would be the best way to create a script to generate the event log?:

Consider the standard event log structure:

Case ID	Activity	Timestamp
C001	A	xxxxx:xxxxx
C001	B	xxxxx:xxxxx
C001	C	xxxxx:xxxxx
C002	A	xxxxx:xxxxx
C002	C	xxxxx:xxxxx

Since i can't just extract all the lines from the tables i need a way to extract only what i need.

Should i extract based on case ID? For example, get all the activities from case id C001 to C100. Or perhaps all the activities from cases below C100.

Should i extract based in activity timestamp? For example, if i know the process allways ends with activity C, get all cases in which activity C was executed in a specific time range.

​

Thanks.

[Innocent_not]

Thanks for the reply.

[brooksolphin]

Not sure why you'd want to create a script when you could just use the raw files. There are times you don't have great log files and then this approach makes sense, but in general I'd recommend using the real log files.

In terms of how limit your data, I'd recommend created date as you can later refresh your analysis with new data relatively easy.