Can I use an Excel xls or xlsx file to define a decision table leveraging FEEL?

24 views
Skip to first unread message

Doug F

unread,
Mar 19, 2021, 9:42:03 PMMar 19
to Kogito development mailing list
Hi,

I am using decision tables, and have been entering the rows and corresponding FEEL statements in the dmn editor, and it is working incredibly well. (btw, please don't deprecate First hit policy - I need this and the compile time warning makes me nervous!)

I would like to be able to write the FEEL-based decision table using Excel, and be able to either import it, or consume it directly, without having to manually enter it into the editor. I find the editor too cumbersome for larger tables, and it lacks the infrastructure that I can provide in Excel to help business analysts build their decision tables.

Is this possible?

The Excel file cells would be formatted exactly the same way as the decision table cells using the dmn editor extension.

Otherwise, I was thinking I might be able to write VBA that could construct the <dmn:decisionTable> node that I could paste into the dmn file.

Thanks!

Doug

Jozef Marko

unread,
Mar 22, 2021, 4:23:18 AMMar 22
to kogito-de...@googlegroups.com
Hello Doug,

Currently it is not possible to define DMN logic in spreadsheet and import it into our designer. However we are aware of this missing feature. We are working on improvements in this area. However as it requires a lot of refactoring in our codebase, we do not know the date it will be delivered. We have a jira for it https://issues.redhat.com/browse/KOGITO-3656 already, however it is part of a much larger epic.

--
You received this message because you are subscribed to the Google Groups "Kogito development mailing list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to kogito-developm...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/kogito-development/9adf3c1a-732f-4a8a-8788-741ba4d60fcbn%40googlegroups.com.


--
Regards, Jozef
RHBA Quality Engineer

Idan Gazit

unread,
Mar 23, 2021, 6:42:38 PMMar 23
to Kogito development mailing list
Hi,

There is any timeframe for this issue? I planned to ask about that as well... Working only with the editor can cause typing errors and takes a lot of effort when the table is big.

Thanks,
Idan

karreiro

unread,
Mar 24, 2021, 5:27:13 AMMar 24
to Kogito development mailing list
Hi Idan,

As Jozef mentioned, we are working on several enhancements in this area, which implies a lot of refactoring. Those enhancements include:
- support to copy/paste integration with other spreadsheets
- code-highlight/code-completion on all cells that carry FEEL expressions
- performance enhancements

My expectation is to switch to the new implementation by the mid of 2021.

This kind of improvement is always announced on our blog https://blog.kie.org - you can stay tuned there for this or other news related to the editor :-)
Reply all
Reply to author
Forward
0 new messages