I have a bunch of sports statistics that I use in some relational databases and things like that. Importantly, I have web scrapers and APIs and things like that to automatically download new data and always keep these databases current. I’d like to make this data available on my WordPress site and have some basic search fields to filter the data down.
I see there are bunches of plugins to do this but I couldn’t tell how dynamic they were. I got the impression that some were just table creation and then are relatively static afterwards.
I was wondering if anyone is aware of one where it will always populate from a csv or other file type that is stored in WordPress proper? Since I already have a lot of code outside of WordPress to update my data and go through a bunch of QC checks I’d like to just be able to dump the most recent output of all my code once a day into WordPress, whether that is from a csv, Excel file, or updating tables in MySQL. I wouldn’t want to have to update web pages daily of course so I’m hoping there’s a way where I can SFTP the latest output into a folder in WordPress that the plugin-created table would automatically pull from.
Thanks in advance and sorry if anything is unclear!
[ad_2]