search

pinussilvestrus / camunda-modeler-excel-import-plugin

Camunda Modeler plugin to import Excel Sheets to DMN 1.3 Decision Tables (and vice versa).
MIT License
22 stars 3 forks source link

excel-upload-dmn-camunda-pain-points #117

Open RakeshDigit opened 1 year ago

RakeshDigit commented 1 year ago

Describe the Bug

We replicated the excel upload at our end and is working fine. Excel upload in camunda7 with plugin -camunda-modeler-excel-import-plugin However there are few shortcomings as mentioned below, which will be a pain point for the business team in the long run , once the handover is done.

While uploading the excel in DMN, one has to enter the below details manually.

Name of each DMN

Hit policy rule

Number of output columns

When the DMN is downloaded, please check the feasibility of these variables being downloaded in excel sheet as well , so that while upload this is pre populated. In case of tree structured DMN (8-10) DMN, human error can occur.

When the revised excel sheet is uploaded, all the tree structure /connections are lost. Only individual DMN’s are added in the DRD. One has to re-do, all the arrows and connections and re- test this again along with copy pasting the original Definition key in the new DMN’s. Once we go live , adding few rows can be done manually, but lets say we get a case where 50-100 rows needs to be added, then this redoing of the arrows every time , for the business might not work. Attaching the sample DMN. Could you please check this if there is a way to achieve the above. Would also request you to post this in the community and check

DMN file uplaoded

Steps to Reproduce

  1. Create DMN with Multi level hierarchy with some data set
  2. export DMN in excel
  3. modify the excel data and upload in camunda modular with plugin
  4. all the arrows and connections and re- test this again along with copy pasting the original Definition key in the new DMN’s and map the arrow between DMN again manually once we deploy .

Expected Behavior

Expected after excel dmn should display as before with addition data. No manually modification after excel upload for dmn deployment .

Environment

RakeshDigit commented 1 year ago

DMN samples Added [Uploading Excel_Upload_F (2).dmn…]()

pinussilvestrus commented 1 year ago

Thanks for opening the issue!

all the arrows and connections and re- test this again along with copy pasting the original Definition key in the new DMN’s and map the arrow between DMN again manually once we deploy .

Can you describe how you would imagine this information to be stored inside excel? As an additional metadata cell?

RakeshDigit commented 1 year ago

Hi @pinussilvestrus ,

Thanks for quick reply. Is it possible to maintain last sheet related to arrow mapping , DMN name and definition Key information and during DMN generation we can populate those information at run time.

RakeshDigit commented 1 year ago

Hi @pinussilvestrus ,

Any suggest to resolved the required gap . because without this feature if very difficult to Business team to rename and and update key for each existing DMN with new version changes. or any other way to copy the modified data from excel to existing DMN

pinussilvestrus commented 1 year ago

There needs to be an extension for the excel handler to persist this information to excel + parse it back on import.

This is a side project, so I likely have less time to work on new features. This project is open for external contributions to improve the situation.