I receive a scheduled e-mail every morning with a .CSV attachment (auto exported from an age-old programme from the 80's). The info is timesheets, project data like contact detail, P/O details, payments, invoices, etc.
I want to e-mail it into something that can "read and convert" that data and upload it into a MYSQL database, which I can use to set-up a dashboard in ZOHO Analytics. I am really tired of converting the spreadsheet every morning to a useful format.
I need suggestions to:
1. Set-up an inbox to receive the .csv file
2. Manually of automatically convert it and host in the cloud, MYSQL database.
3. Help me to set-up some initial reports from the MYSQL data in Zoho Analytics.