Upload excel file format to database

1
0
-1

Hello everyone, how to upload excel file format (xls or csv) to database in bonita?

2 answers

1
0
-1

Currently it is not possible to store files as a BDM object attribute. The recommended solution to store documents is to declare " documents " in the process definition. Documents are stored in the Bonita Engine database and not in BDM database.

You might be able to use a BDM object attribute of type text to store the content of the document. But I would clearly not recommend such solution due to risk related to performance, potential encoding issue, etc.

Comments

Submitted by yogabaskara17_1... on Thu, 10/10/2019 - 03:35

Hi antoine,

Thank for your explanation. But is there any solution to retrieve back to view and download the files that i have stored in bonita engine database? is it still possible to upload the file once my project deployed to be standalone application?

Submitted by antoine.mottier on Thu, 10/10/2019 - 09:58

Yes once a document is uploaded and stored in Bonita engine database it is possible to retrieve the file, display the file in a form and allow the user to download it. You can download an example (.bos file) from GitHub.

Note that the file is associated with a Bonita process instance. Meaning that when the process instance is archived the file is archived as well. Of course the file content is still available for download when archived.

The most important difference between a business data and a document is the life cycle of the information: document is associated with a process instance and follow process instance life cycle, business data is independent and can be created, updated and deleted by a bunch of different processes.

1
0
-1

Hi,
this may help:
Parse CSV

Comments

Submitted by yogabaskara17_1... on Mon, 10/07/2019 - 03:42

Hello,
Thanks for sharing, i made revision to the question that i asked. What i want to know is, i want to upload file any kind of file(pdf, doc, xls, etc..) and store it in bdm. I apologize if my question was make you misunderstood. i want to upload and download the file only. so the file itself stored in a table column in bdm. Im looking forward for any solution for this.
thank you

Notifications