AI

Hi All,Earlier I had asked a question regarding how we can save/extract a table in our EMS as a csv file in our machine learning work bench, seeing the reactions or the lack of replies I got for the topic I think it would be helpful if I explain the code that I used/found to save the file as csv in my ML workbench. from pycelonis import get_celonisimport pycelonis.pql as pqlfrom pycelonis.config import Config celonis = get_celonis()data_pool = celonis.data_integration.get_data_pools().find("Datapool name")data_model = data_pool.get_data_models().find("Datamodel name")Config.DEFAULT_DATA_MODEL = data_modeltables = data_model.get_tables()table_name = data_model.get_tables().find("Table to find out")table_columns = table_name.get_columns()df = pql.DataFrame(  {    "column1": table_columns.find("column name in the table which has to

Hi All,'In the past couple of days we are facing an issue in the ML workbench, while running a specific python code which is long and also complex , the kernel suddenly becomes unknown from the busy state due to which we have to rerun the code again from the beginning and this goes on happening as a loop ,we have raised a ticket regarding this to celopeers, but would also like to know if someone had faced this issue before.

Hello everyone, Is there a change log / release notes of PyCelonis somewhere? This would be very helpful to make decisions when to upgrade to a new version. Thanks a lot!Pablo

Hello Community, today, we upgraded one of our ML Workbench to PyCelonis 2.6.Since then DEBUG informations are shown (see below). In the Jupyter Notebook we use: logging.getLogger("pycelonis").setLevel(logging.WARNING) If we execute the notebook on local computer, no DEBUG information if shown. On the other hand, if we execute it on the EMS, following DEGUB informations is shown: [2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST'

Hello all,we are still using PyCelonis 1.7 and we figured out that since yesterday the response of the function "api_request" has been changed.Before we got a list / dict or string. Since yesterday we get a request.model.response object. Have you noticed that? Are you also having issues with your api_request calls? Our current workaround was to get the "text" of the response object. Like: resp.text instead of: resp

Hi  I want to execute ML notebook using run_ml_notebook component in analyses but ML notebooks are not visible Is there any additional configurations required to be done ? Thanks 

Hi all, I want to pulling data from a knowledge model through the following code ... space = celonis.apps.get_spaces().find('Default')package = space.get_packages().find('Knowledge Model Test')knowledge_model = package.get_knowledge_model('999-automation-rate-bw-download')content = knowledge_model.get_content() But I get the error "PyCelonisPermissionError: You don't have permission to perform 'GET' ", even I have set all possible permissions (for "Space" / "Package / "Analysis").Any ideas which permissions are missing. Unfortunately the article below does not help me here. Thanks in advance,Best,Jonas 

Is it suggested to make a backup workbench or a new workbench ? If our current workbench is corrupted.

Hello, I have the following problem when PQL query tables from my analysis (PyCelonis version: 2.5.0): After identifying the required space, package , analysis and sheet, I specify the required table:olap_table_HistoricPOs = published_sheet_OpenPR.components.find("#{Historic_POs}", search_attribute="title") ... and query the table:olap_query_HistoricPOs = olap_table_HistoricPOs.get_query()olap_query_HistoricPOs Some columns are read correctly:(name='_CASE_KEY', query='"freitextbestellung"."_CASE_KEY"')and others are not. These get a hash and a brace like this:(name='#{order_items.SUPPLIER_NR}', query='"order_items". "SUPPLIER_NR"') This incorrect naming is kept in the subsequently created dataframe:df_historic_POs = pql.DataFrame.from_pql(olap_query_HistoricPOs, data_model=data_model)

Hi there,I would like to pull an OLAP table component out one analysis sheet into the ML bench If I try this way by ID it works:components = sheet.componentscomponent = components.find_by_id('Component_ID_Here') But I would like to import the table by name as the component ID might change.So I tried this but it does not work.:components = sheet.componentscomponent = components.find('Table_Title_Here') Hope you can give me a hint. Best,Conny

Hi All,I wanted to share an issue with you guys regarding the ML app we had in our server in which the app was automatically changing it's python package versions despite of whatever desired versions of python packages we install. Then we figured out that if the ML app had a file named virtual environments and in it's metadata if the versions are already set , no matter what ever desired versions of python packages we install it automatically changes it's version to the one mentioned in the metadata of that virtual environment. The reason for this is that the workbenches where virtual environments were used usually become corrupted and inaccessible. Files will not be recoverable if a workbench is corrupted.  The only way of resolving this issue is creating a new ML app and backing up the files in the current workbench (Excluding the virtual environments) and restoring them to a new workbench. This will ensure your data is protected from possible

Hi Team,I am trying to create a table in a specific data job before which i have done some calculations using pandas and i want to perform SQL using that table in the datajob.But the tutorial gives the datapool create tables and i am not able to access it in Datajob i need.Is there any way to do this?When i force the data_source_id while creating the table in data pool, it gives an error saying it cannot find that table and source id.Please let me know if there is a way.Thank you

Hi Team,I am trying to retrieve the data received from the data connection in a table to machine learning workbench to do some manipulations and write it to another table in datapool.Is it possible?I have tried so far . data_pool = c.data_integration.get_data_pools().find(<pool name>)a=data_pool.get_job(<job id>)b=data_pool.get_table(data_source_id=<sourceid> name=<table name>) But from here i am unable to get the function get_data_frame. Is there any other way?Please let me know.Thank you

Hi all,has anyone had problems when triggering a Jupyter Notebook from an Action Flow? I cannot even trigger the template provided in the educational page. It is puzzling because the POST requests succeeds with code 200 - so I assume that all required fields are correctly filled - yet the Notebook is not executed, it does not produce any output. I have tried to move the Notebook across folders and apps, to no avail. Anyone else had the same problem? Attached is the POST output (maybe the problem is that the ML notebook is QUEUED? but how would I solve it anyways?).

Hello all, I would like to send an xlsx file as an e-mail attachment. The file is generated by a Python script in ML Workbench. Due to the formatting of the xlsx file, it is not possible to load this file into the data model without further ado. Is it still possible to send the file automatically, e.g. via an action flow or skill?  Best regardsChristoph 

Hi,Im trying to add a table from Datapool to datamodel and i found this function, add_table_from_pool in the release notes of 1.5Now when i try its not present. Is this deprecated?If so, are there any alternatives?Please let me know. Now the error: 

Hello All,   I want to use pycelonis to get all version of data pool (including Draft if present) The below code does not not show data pool version    data_pool = celonis.pools.find("XXXXXXXXXXXXXXXX) print (data_pool)  Output: <Pool, id XXXXXXXXXXXXXXXX, name 000_Extraction (000_CELONIS_DATA)>   Is there any way i could get the data pool versions? 

Hi Team, Can you please help me with the code to extract Knowledge Mode Record information using Py Celonis.I checked the PyCelonis documentation but was not able to get the same. Thank You in advance. Regards,JB

Can anyone help me with the code for creating CLI profile?

Hi,I am trying to send API Request using the api_request() function but i am getting this RetryError. Can anyone please explain how to tackle this error. 

Hi,I am trying to connect to pycelonis from my local system to IBC .It was possible with all the required values when it was 1.7.4But after the upgrade to 2.0 , we are getting a getaddrinfo errorIs anyone else facing such an issue?If so, What needs to be done.Let me knowThanks

Hello all, How can I output the data model with a python command in the pycelonis package? in pycelonis 2.0.0this was done with the functionspool = celonis.pools.find('my_datapool')dm = pool.datamodels.find('my_datamodel') In pycelonis 2.0.1 this doesn't seem to work anymore.I get the data pool via:pool = celonis.data_integration.get_data_pool(celonis_pool_id) but how do I get the data models and the tables they contain? Many greetingsChristoph

Hello all, I want to know if is it possible to visualize the output of PyCelonis in EMS. For example, if I have any diagram in Python, I can show it in the EMS environment?Thanks

Hi All,I want to upgrade a single workbench app in Machine learning.I do not want to disturb any other app present in the the workbench.Is it possible to do it?Please provide any documentation if present. 

I'm getting an error when trying to add a table to a data modelThe main problem is: it was working last week and, when I tried to re-run today, I got the following error: HTTPStatusError: Client error '400 Bad Request' for url I dont know what could be triggering it, specially because it was working before and I didn't