upload CSV data to database

Q&A
1

Hi,

I have a CSV and I want to upload its data to database.
For this I created a document of CSV type, which is reading CSV when I browser the button, but I cannot insert its records to mysql database.
I am using community version 6.4

Thanks,
Manoj

2

hello,
maybe this can helps you:
http://www.mysqltutorial.org/import-csv-file-mysql-table/

otherwise, maybe you can give us more context about your problem ?

Julien.

3

Thanks for your answer.

Actually my client wants to provide a upload functionality on a form(through process) which browser for csv file and upload it to mysql, not using MySql Workbench.

Thanks
Manoj

4

I have a question related for if anybody wants to check it, is about to import Excel or CSV file and apply data validation and complex business rules to the data with BPMN with Bonitasoft, is possible?
https://community.bonitasoft.com/questions-and-answers/import-excel-or-csv-file-and-apply-data-validation-and-complex-bussines-rules