General Product Q&A

What the max size of number of character that can be extracted in table.column of type Text in celonis.

Hello,  There were no announcements about new Pycelonis version, however recently, by accident I've seen that 2.0.0 appeared out of nowhere. I've took a peak, and I'm dumbfounded. It's completely unreadable, missing a lot of important information (like examples or methods/attributes that can be used). It's also important that even if you find some example, it'll be single line of code (or two) that won't work even with modification... It should be marked as BETA Version, and users feedback should be taken into consideration. Also very important migration guide is very easy to miss:https://celonis.github.io/pycelonis/2.0.0/tutorials/executed/04_migration/01_migration_guide/ Some more interesting screenshots: 1) Action flows: thanks for detailed description on how we can interact with Action flows!2) Lack of the most useful function: api_request() It was only a wrapper for request, however it allowed to get things like list of Celonis users very conveniently. 

I did some courses in Celonis, how do I get badges for the same? I don't have anything in my Credly account too. I need to do some other courses too but holding them off till I understand the certification process

How I will get certificate from you after complete my course.

Hi I have following requirement to have ceolins user info. in SharePoint O365 excel file Step1: Download & Upload all Celonis User Information in Excel File in office 365 (Do we have any database table for this user information, like when the onboarding was done, when user was locked and which user groups and permission we assigned to this user, I want to see that information in SharePoint excel file.) Step2: Every Onboarding, off-boarding and locking of user get updated by action flow in Excel file in Office 365. Celonis User Database --> Update in O365 Excel file on any change in Celonis user  ThanksAnimesh

Upgraded data integration release date? I read a while ago about the new changes to the data integration section in the Celonis EMS. I can't find if there's any date set when the update goes live. Is there a date set? Thanks in advance

Hello, Do you have any experience how to in corporate MSEG & MKPF into O2C data model? Seems that we can join MSEG to MARA through material number. I would be grateful for any hints. Best regards, Lukasz Best regards, Lukasz

There is one file per analysis and another for the entire package, all in YAML script detailing the visuals.

Will i be again required to participate to complete 3 certification or I will be considered as certified ?

Hi Folks! I would like to know if there is any way to avoid inserting duplicate records when we execute delta jobs. I cannot use Replication Cockpit, since we're using a non-standard system.

Delivery date change use case - Dear experts , In delivery date change use case , Celonis assigns delivery date on behalf of user for high probable delay case, Can you tell me how Celonis determines the new date ? is there ML function within PQL library

If the data refresh schedule is picked up from a table which is not connected to the case table in the data model then how to query the data refresh schedule and display it in the action flow.

Business Process Specialist (m/w/d) Supply ChainBizerba Location: Balingen (Germany)Description: Wir bei Bizerba verbinden die traditionellen Werte eines Familienunternehmens mit den internationalen Karrieremöglichkeiten eines global agierenden Konzerns. Wir nennen das die "Bizerba Open World" und freuen uns darauf, diese gemeinsam weiterzuentwickeln (Check out the full description following the link) Apply here

We have recently changed the database connection from uplink to direct wherein required to move all tables (nearby 50) to direct connection, to avoid any re extraction. Any suggestion would be helpful.

This is related to this question: https://www.celopeers.com/s/question/0D50700001vMXJgCAO/distribution-lists-in-action-flows?language=en_US I have been able to figure out how to send to a distribution list, but it is instead using an HTTP Request. This allows our action flow to reference a "no reply" account where we can send within the company. The issue I'm now having is how to attach a PDF while using JSON. This is how my module is currently set up  I have my PDF being converted to a JSON string as can be seen by '9. JSON string'.  Is there a parameter I'm missing in the JSON request? The email can be sent and works correctly, but without the necessary PDF attached 

Can you please tell me how case id of two different process gets linked like p2p and o2c , will it be material id ? because thats the only thing that looks like case id ?

Can general ledger process and closing be modelled into celonis ? has anyone observed any process mining use case around this ? My thinking is it might not be possible but still needs your opinion.

Dear experts have you came across any instances in your projects , where you implemented automation to auto update master data like price ?

Is it possible to add hyperlink to the Free Comment? (I know we can add link in free comment component but would like to know if hyper is possible as well)

How can I make a custom dimension based on a process flow? I want to make an OLAP with a case count for both 'push' (goods are produced before order) and 'pull' (starts with act receive order) cases? so based on those flows i want to create a dimension

📢 🎄 Dear current and future Starter Kit users,📢 🎄  As an early Christmas present, the Starter Kit brings amazing updates. Check them out in the market place! 1. Updates on inefficiency deep dives!Go to the next level of understanding detailed insights into the hidden inefficiencies by surfacing root causes automatically. You’ll now find deep dives and recommended solutions for all the available inefficiencies - have a look at Manual Sales Order Creation, Delivery Blocks, Active Billing Blocks or any of the 20 inefficiency deep dives. 2.“Start here” view In order to help you utilize the Starter Kit more efficiently a “Start here” view is now available in-app to guide you through the different steps to take. Update your Starter Kits today! Not using the Starter Kit yet?The Order Management Starter Kit is your kickstart to gain insights into the most impactful order management use cases.It is a collection of assets that help identify and frame the most valu

Hi,  I had a permission error when installing a Python library on Machine Learning Workbench, and when I tried to run the command with sudo, I was asked for the password for Admin permission (Jovyan), is there any default password for the super user? 

Could you please help me to define PQL formula for the below use case? Average time( When count(WI of a DOCID)>2 then 0 When count(WI of a DOCID)=2 then END_DATE - START-DATE of highest WI ELSE END_DATE - START-DATE )