Cancelled

Modify and upload a csv to phpmyadmin

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

Skills: HTML, MySQL, PHP

See more: phpmyadmin csv update, update column phpmyadmin csv, csv phpmyadmin, website data upload, download and upload, csv to excel, update mysql csv php, upload excel file php database, mysql php download upload, php upload file csv, rows insert, save upload, php table csv, insert xls mysql table, upload csv phpmyadmin, csv update, csv column format, php upload xls file database, excel column update, table csv, excel update mysql, modify table php, csv table, mysql insert update , mysql download upload

About the Employer:
( 6 reviews ) Vi, Spain

Project ID: #4218241

11 freelancers are bidding on average €41/hour for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

€6 EUR / hour
(228 Reviews)
7.7
diegou

hola por favor chequea el pmb, gracias

€20 EUR / hour
(35 Reviews)
5.7
sriraj1233

Ready to start this project

€6 EUR / hour
(68 Reviews)
5.3
svipl7

Hello we are 8+ years old web-development company. please check our portfolio for more details. thanks

€310 EUR / hour
(12 Reviews)
4.7
charli007

I am Expert in PHP and SQL.

€6 EUR / hour
(13 Reviews)
4.0
parthuji

4 years exp and quality work assured

€30 EUR / hour
(5 Reviews)
3.3
XWebHunter

Ready to work for you, we are close to each other and I can provide you a best service ;)

€8 EUR / hour
(7 Reviews)
3.2
codrutc

Hello Sir ! Ready to take on this task! just accept the bid and i will begin! thank you!

€50 EUR / hour
(9 Reviews)
3.0
aptsindia

Ready to do for you Skyp [url removed, login to view]

€4 EUR / hour
(1 Review)
0.0
habiburcsesust

i have seen project requirement. I could satisfy you 100%. I am expert in this type of project. Please check PM

€5 EUR / hour
(0 Reviews)
3.1
venkatreddyc

We are interested and available for the assignment.

€5 EUR / hour
(0 Reviews)
0.0
nemke82

I can help you its easy

€3 EUR / hour
(0 Reviews)
0.0