Import Excel or CSV file and apply data validation and complex business rules to the data with BPMN on Bonitasoft, is possible?
Hello fellow Bonita users!
I want to know if is possible to have an interface to import Excel or CSV files, to validate each record (type and format, white spaces, etc) and, the most important thing, to apply to each row several complex rules using BPMN in order to achieve some result based on each row records.
On the company we are very interested in to give a try to this technology, will be useful if any give us a clue if have any experience related.
thanks in advance.
with Bonita it is absolutely possible to develop a connector that reads a csv or excel file and store the data in Bonita format (either using process variables or business object variables).
From there, with your data properly imported you can design design validation processes.
The data model you will need to design highly depends on the data in your excel sheets.
If you want to develop such a connector you have many choices:
- For Excel sheets, you can use the Apache POI java library
- For CSV, there is OpenCSV library by example.