Hi Team,
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
Excel_Upload_F.dmn (4.9 KB)
Please suggest the approach to resolve this issue