Skip to main content
HI team
what we need to check while collecting flat files from client

Hi, @sai.vamsh11 

Well, regardless of the structure, you always need to make sure that your input files contain, in the very least, the information for the Activity Table, i.e., case ID, activity and timestamp columns.


That's ok @1460047871 thanks for the information. But in my case we have files with us but there is no any case id activity name and time stamp in the files. So how to collect those data from cilent step by step

 


Hey @sai.vamsh11 

Which application are you doing an extract from? Is it SAP only?

 


Hi @vidushi.gupta13 iam using SAP source system

 


You need to find out which Tables your data correspond to in SAP. And find fields within those tables that may correspond to some date/ time..


We have implemented a project through connection with the Client's data lake. Can you pls enlighten me as to how to connect through flat files


Sorry i didnt get u do u need the flat files connection details

 


Yes, I need to understand how to do a connection through fat files. Up and until now we are getting data from a data lake which is hosted in Client server so it was pretty straightforward.

But wanted to understand how to create a Data pool by flat files dump given by client. How to make that connection. A screenshot of your existing use case will help


First we need to create top crate a data pool while process name and then after we have to select the file upload option to upload the flat file. where as the flat files accuracy should be 1 GB

 

There are many ways you can upload your own data to Snap and start your way to Process Mining Excellence, which we will discuss in this post. While the Celonis Intelligent Business Clouds allows to connect your Salesforce, SAP and many more systems to automatically mine your process, this is not the case with Snap. But don’t worry, we’ve got you covered with some alternatives.

 

Upload a CSV/XLSX file

If your event log is in a CSV or XLSX format, you can use the Quick start to upload it directly to Snap.

Just log into your Snap environment, and click on “New Project”.

 

CSVXLSX1 

The list of all our Quickstart options will appear. Click on “Upload XSV/XLSX file”.

 

CSVXLSX2The CSV/XLSX upload window will appear. You can either drag your file to the designated area or click on “Select File” to browse your computer and choose the file you wish to upload.

 

image 

Pro tip: If you don’t have a CSV/XLSX, you can toggle “Use Sample File”, or click on the “Download Sample File” and use that file instead.

Once you uploaded your file, you need to specify if your Sheet has a headers row, how the fields are separated and some other formatting settings like the Thousand separator and Decimal separator. You can also edit a specific field by clicking on it, modifying it and clicking on “Save” to save your edits. Once you’re done, click on “Next” to continue with the configuration.

 

image (1) 

You will also need to specify the Case ID, Activity and Timestamp of your file. These three are the foundational elements of Process Mining.

Case ID: Unique identifier of an item that goes through several activities during a process.

Activity: A stage in a process. A process consists of many activities.

Timestamp: The time of occurrence of a particular activity.

image (2) 

We will take care of the rest and build an initial Analysis for you to start Process Mining. Behind the scenes we are making the necessary transformations and creating a Data Model for your file.

image (3)Once done, you’ll see your Workspace with the Analysis we built ready to start. Simply click on “Analyses your sample event log” and get started! Or click on “Learn how to build your own analysis” to learn more and become a Process Mining expert!

 

image (4)image (5) 

 

 

 


This the steps for flat files uploading in celonis where celonis has guided me in the above way

 


Thanks a lot Vamshi for this!! :)

Really appreciate it!


Your welcome👍


Hi @sai.vamsh11 

Hope you're well!

Just wanted to understand a small difference between Celonis IBC and Snap.

I believe Snap has been renamed to Celonis IBC right? I am also exploring data load on celonis cloud through flat files approach.

Any help on this would be much appreciated


Hi @vidushi.gupta13 

I'm doing good n u!

What is the main difference between Celonis Snap and Celonis IBC Enterprise?

These are the main differences:

  • In Celonis Snap you can upload ONLY up to 500MB.
  • In Celonis Snap there is NO continuous integration with Event Collection as in IBC Enterprise.
  • Features like Transformation Center, Workflows and Machine Learning Workbench are NOT enabled.
  • Yes, as long as you don't exceed the limit of 500MB.

 


Thankyou for your response.

If we procure enterprise C4C+ licenses, do we get access to IBC or Snap?


Yes u will get for snap


Reply