Hello everyone, how to upload excel file format (xls or csv) to database in bonita?
Hi,
this may help:
Parse CSV
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.
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
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?
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.
i would like to say sorry, because the sample that were you given doesn’t suits to my project. my project requires upload and download file features that is stored in the database. do you have any suggestion regarding to this?
thank you
As this question describe a need different than yours can I ask you to create another question? In your question you can add a link to this one highlighting what is different in your scenario. Thanks.
here i have created new question https://community.bonitasoft.com/questions-and-answers/upload-and-download-file-bdm-database