I've been tasked with a project where the user needs to access the front end admin page that I've created and upload a CSV (1-3 daily). This Information needs to go into a database and be split into multiple tables (which I've also created). I've come up with some PHP code that can split a CSV into multiple tables upon import, but I'm looking to see if there is a better way to do this in Wordpress, maybe even via plugin.
Currently, working on my local server, I made a test HTML page with an upload section. In PHP, I have this handled to read the CSV and put the 203 fields into an array, splitting these by column names into 7 different tables. It's a lot of code but I think it works. For this to work on the wordpress site, I'll have to add the database and tables and then use a plugin to insert PHP code.
The only other factor is after an upload, I'll need the option to display the cvs data in another screen on a table. The main thing here is reading the CSV and putting the data in different DB tables in WP. Does anyone know of a better way to do this?