TOPICS

Ready to build a BPMN model?

Build your first business process model instantly with Camunda Platform 8.

Join the Camunda Developer Newsletter

Get the latest events, release notes, and product updates straight to your mailbox.

TRENDING CONTENT

Decision Model and Notation (DMN) is the new kid on the block when it comes to defining decisions and business rules. Like BPMN and CMMN, it tries to bridge the gap between human readable definition of business-relevant aspects and technical realization. DMN therefore has a graphical representation as well as an XML-based serialization format and Camunda provides you with a beautiful editor to manage both. So why not go full DMN any minute now? Probably because you work with business rule definitions for much longer than DMN is around and you manage them in Excel. Recreating these with the DMN editor is a tedious task. That is where Camunda’s newest community extension comes into play: The Excel worksheet to DMN converter.

Take an Excel table,

Example Excel table

convert it to DMN,

Example DMN table

and you are one step closer to automating business decisions with Camunda BPM.

How to use

The quickest way to get started is to try the command line tool:

  1. Download the command line tool. It is a runnable jar file, so you need to have Java installed.
  2. Take an Excel file that contains a decision to convert and place it next to the downloaded jar.
  3. Execute java -jar dmn-xlsx-cli-0.1.0.jar --inputs A,B,C --outputs D,E,F path/to/input/file.xlsx path/to/output/file.dmn. Note that this example assumes the columns A, B, and C are inputs and D, E, F are outputs. You can set these as you like.
  4. Obtain the dmn table and import it in Camunda modeler or in the online DMN table editor.

Background

The goal of this project is to provide a Java library for conversion between Excel worksheets and DMN tables. Since no two Excel tables look alike, the library aims for customization of the conversion process. On top of the standalone library, there is a process engine plugin that enables including Excel files in a process application deployment. The files are converted into DMN tables on the fly during deployment. For details, have a look at the GitHub repository.

Contribute

We are eager to receive feedback and improve the library in future versions. Contributions in form of code, bug reports, and feature ideas can be made directly in the camunda-dmn-xlsx repository on GitHub.

Start modelling business process workflows using BPMN

Related Content

Learn why more and more companies are investing in cloud-native technology, and how it can benefit you today.
We’ve enhanced Camunda Optimize to produce more structured data so that it is ready for machine learning, making it easier than ever to take advantage of AI to improve your processes. Learn how.
Learn how to migrate your process flows from Pega to Camunda quickly and easily with this guide, which walks you through how to use our free migration tool.