First of all, Happy New year!!!
I am working on trying to Develop a very user-friendly App for inserting Data into a Mysql for a client.
The client has 0 knowledge about what it's a Json, parsing, data formatting. The only skills the client has is all about Creating a CSV from an Excel.
So, this is the playground.
The client provides the app with a CSV, which it ingests through the file button, and all the information is displayed in a table container. Now that the app has the Data, is there a way to just click one button and do a Bulk insert of the whole table?
I've seen there is an option for an ACTION button in the table, but the client would need to click as many times as rows the CSV has, in order to insert all of them into a database in MYSQL.
is there a way to bulk insert in just one click all the data that has been ingested using the CSV?
Thanks in advance,