Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
We are receiving daily total transaction into CSV file from bank , and we need to store the data into MYSQL DB then we need to fetch the data from DB and then show the report into dashboard using graphs, charts....
So please help in this case , i am using Laravel framework here
We can only give a general guide here:
1 . Set up your report's datasource to CSV file using CSVDataSource.
2 . In your report's setup Pipe your CSV data to a datastore.
3 . In your report's view, show the datastore with Table/DataTables. Create an Import data to MySQL button inside a ( <form method='post'><button name='Import'>...</button>...</form> )
4 . When a user click Import button, check for $_POST['Import'] or $input['Import']. If there's is, run the report $report->run() so that data is piped into the report's datastore. Then get the datastore data ($report->dataStore('myDatastore')->data()) and insert them into your MySQL database.
5 . Use some check/database table/file to make sure not to import the same file several times or use SQL Insert if not exists command.
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo