Closed

Modify and upload a csv to phpmyadmin

This project received 12 bids from talented freelancers with an average bid price of €38 EUR / hour.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
12
Project Description

I want to have one buttom in my website.
When I click that buttom I want to update my MySQL Database with some files.
Thouse files are on the internet, in one website. Are update every week.
One files is an Excel (.xls, like attached).
With that the steps to do are the next ones:
1. Download to my computer from the website (is allocated in a simple web like [url removed, login to view])
2. Modify the column "Date" to have the normal date format for MySQL (YYYY-MM-DD)
3. Replace all "," for "."
4. Save in a .csv file
5. Upload to my Database (Phpmyadmin, Mysql) in one table (I'll provide the exact name of the table).
5.1 Delete all the previous data in that table.
5.2 Insert all the data from the .csv

With the .csv the steps are the next ones:
1. Download to my computer from the website (is allocated in a simple web like [url removed, login to view]). The columns are separated by ","
2. Modify the column "Date" to have the normal date format for MySQL (YYYY-MM-DD).
3. Save in a .csv file
5. Upload to my Database (Phpmyadmin, Mysql) in one table. (I'll provide the list with the names like [url removed, login to view] go to the table unitedkingdom and [url removed, login to view] goes to italy table)
5.1 DO NOT delete all the previous data in that table.
5.2 Insert ONLY the rows that are new for the DB

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