Download, modify and upload an .csv to phpmyadmin !! EASY
This project received 7 bids from talented freelancers with an average bid price of €6 EUR / hour.Get free quotes for a project like this
I want to do 2 times per week at one specific hour or also when I push a bottom in my website and should be executed 20 times (because I want to download every time 20 excels for 20 differents tables in my DB):
I want to download one excel file (.xls) from one internet website.
With that .xls, I need to be modify to change the "Date" column and put in the correct formar (YYYY-MM-DD) and replace all the "," of the text for "."
After that, save in a CSV file (.csv)
Once that is save in that format, upload to phpmyadmin (is in my localhost) and update JUST the new rows, because in the excel that I download I would have some rows that are actually in the DB).
And that's all.
More specific details by MP.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online