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

[Doug F]

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]

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]

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]

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 :-)