Script to filter and join data from a CSV report and transfer it to a MySQL database.
Budget: $10 – $30 USD
I have sales reports from 5 different platforms and I need to unify them in a single database (MySQL).
I have all the records in CSV, so I need a script (or something similar) that allows me to upload these files and then filter them and store the data to a database.
- All reports have common fields (such as name, email, phone, etc). What varies in this case is the column name of each CSV, but I'll explain everything right.
- I already have the MySQL server in the cloud.
- I would like a solution that I could always use when I need to manually import new records, so I believe a script would be ideal.
I have all the records in CSV, so I need a script (or something similar) that allows me to upload these files and then filter them and store the data to a database.
- All reports have common fields (such as name, email, phone, etc). What varies in this case is the column name of each CSV, but I'll explain everything right.
- I already have the MySQL server in the cloud.
- I would like a solution that I could always use when I need to manually import new records, so I believe a script would be ideal.