Closed

Normalize a CSV via Script and MySQL

hi, sorry for my delay: [url removed, login to view]

Your job is to create the following script to solve this progress and issue:

1. Pull a CSV from an URL (a)

2. save the CSV in an MYSQL table (a)

3. Normalize the data

4. in the normalization database are are two columns, 1 with the original phrase, in the 2nd the modified phrase (Example: 1 - "Blck" and 2 - "Black") Here the script needs to check if a phrase from the NORMALIZATION DATABASE in the Database A, if yes Change phrase 1 with phrase 2

5. save it to a new MYSQL table (b)

6. save the data from the new MYSQL table to a CSV on an FTP Server (b)

look also at the attached image- it shows the process.

There are more than one CSV A, results in more than one CSV B.

I need to add easily the URLs of A and define the target of CSV B.

The Normalization Database is valid for all. Here the databases are just tables in one MYSQL.

Please make it possible to run that script every day at a specific time.

On our Server runs PHP

Here you can find example of the tables:

[url removed, login to view]

Skills: Excel, MySQL, PHP, Software Architecture, Web Scraping

See more: i need an infographic designed based on the attached content 5 tips for buying a used car, i need an infographic designed based on the attached content - 5 tips for buying a used car, script php csv html mysql, upload import csv file mysql php script, script mysql query csv file email, php csv convert mysql script, php script uploading csv file mysql database, perl script convert csv file mysql, bash script mysql email results, script csv para mysql, php script mysql table csv, perl script csv importieren mysql datenbank, csv nach mysql php script, php script upload csv file mysql, perl script mysql imort csv, import csv script mysql, uploading csv file mysql php script

About the Employer:
( 7 reviews ) Berlin, Germany

Project ID: #16036645

12 freelancers are bidding on average €34 for this job

€14 EUR in 7 days
(85 Reviews)
5.4
kahilH

hello i'm a java developer highly skilled in webscraping and manipulating mysql databases. i invite you to discuss more on chat about your project.

€60 EUR in 1 day
(37 Reviews)
5.1
easysourcenet

Dear Hiring manager, Greetings of the day !!! I am web enthusiast from the India with more than 4 years of experience In the IT Industry. I have a portfolio of My Web development work that demonstrates my abilities More

€23 EUR in 1 day
(5 Reviews)
2.3
AkashW

Hi, I have read your project requirement for " Normalize a CSV via Script and MySQL ". I have skills and experience to do your tasks. Budget and timeline for project would be discussed in quick chat. Choose me f More

€34 EUR in 1 day
(6 Reviews)
2.0
phoniex7

I've 8+ years experience in Analytics industry. Worked on Excel, SQL, SAS and Big data extensively. Expect a Error free, on-time, good quality delivery from my side.

€30 EUR in 1 day
(1 Review)
1.3
emiliobool

Hello friend, I'm a full stack developer, I have worked with tons of csv files in PHP and other languages. I'm experiences with mysql and other databases, and I should be able to finish your project really fast.

€44 EUR in 1 day
(2 Reviews)
1.1
autumnsky996

A proposal has not yet been provided

€34 EUR in 2 days
(0 Reviews)
0.0
BeyoutiF00L

Our elite panel of developers, deliver the most, exquisite websites and apps, for all major platforms. These products are optimized for breath-taking performance and smooth user experience, which makes your business, c More

€8 EUR in 1 day
(2 Reviews)
0.0
sanjowinson

Instead of saying i'm a freelance , try, I will help to build a simple and strong platform for you to work.

€22 EUR in 2 days
(0 Reviews)
0.0
rockysonar

Hey! I am interested to do your work. U can hire me as I can do it at a cost affordable price & finish it in time successfully.

€12 EUR in 1 day
(0 Reviews)
0.0
chanakaindrajith

I'll be create a php functions for each small processes in this task, and will provide the complete solution sooner

€30 EUR in 1 day
(0 Reviews)
0.0
HENRYADUQUEA

Ingeniero en informática, con experiencia en arquitectura, diseño y desarrollo de software. Profesional responsable, analítico, organizado y disciplinado, en procura de ofrecer al cliente el mejor resultado.

€100 EUR in 15 days
(0 Reviews)
0.0