Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
7
Project Description

Hi!
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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online