# Upload excel file format to database

**URL:** <https://community.ofelia.com/t/upload-excel-file-format-to-database/9817>\
**Category:** Q&A\
**Created:** [1 October 2019 03:50 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817 "2019-10-01T03:50:28Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![yogabaskara17\_140830](https://avatars.discourse-cdn.com/v4/letter/y/7ea924/32.png) [@yogabaskara17\_140830](https://community.ofelia.com/u/yogabaskara17_140830)\
**Post date:** [1 October 2019 03:50 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/1 "2019-10-01T03:50:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![azap\_ad\_1400955](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@azap\_ad\_1400955](https://community.ofelia.com/u/azap_ad_1400955)\
**Post date:** [4 October 2019 12:38 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/2 "2019-10-04T12:38:43Z")

</div>

Hi,  
this may help:  
[Parse CSV](http://community.ofelia.com/questions-and-answers/parse-csv-file)

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [8 October 2019 13:22 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/3 "2019-10-08T13:22:05Z")

</div>

Currently it is not possible to store files as a BDM object attribute. The recommended solution to store documents is to declare " [documents](https://documentation.bonitasoft.com/bonita/7.9/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.

---

<div class="post-metadata">

**Author:** ![yogabaskara17\_140830](https://avatars.discourse-cdn.com/v4/letter/y/7ea924/32.png) [@yogabaskara17\_140830](https://community.ofelia.com/u/yogabaskara17_140830)\
**Post date:** [7 October 2019 01:42 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/4 "2019-10-07T01:42:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![yogabaskara17\_140830](https://avatars.discourse-cdn.com/v4/letter/y/7ea924/32.png) [@yogabaskara17\_140830](https://community.ofelia.com/u/yogabaskara17_140830)\
**Post date:** [10 October 2019 01:35 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/5 "2019-10-10T01:35:36Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [10 October 2019 07:58 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/6 "2019-10-10T07:58:25Z")

</div>

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](https://github.com/Bonitasoft-Community/file-upload-download-example/releases/latest) (.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.

---

<div class="post-metadata">

**Author:** ![yogabaskara17\_140830](https://avatars.discourse-cdn.com/v4/letter/y/7ea924/32.png) [@yogabaskara17\_140830](https://community.ofelia.com/u/yogabaskara17_140830)\
**Post date:** [25 November 2019 06:41 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/7 "2019-11-25T06:41:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [25 November 2019 09:22 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/8 "2019-11-25T09:22:42Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![yogabaskara17\_140830](https://avatars.discourse-cdn.com/v4/letter/y/7ea924/32.png) [@yogabaskara17\_140830](https://community.ofelia.com/u/yogabaskara17_140830)\
**Post date:** [25 November 2019 13:52 UTC](https://community.ofelia.com/t/upload-excel-file-format-to-database/9817/9 "2019-11-25T13:52:30Z")

</div>

here i have created new question [http://community.ofelia.com/questions-and-answers/upload-and-download-file-bdm-database](http://community.ofelia.com/questions-and-answers/upload-and-download-file-bdm-database)
