Normalize a CSV via Script ans MySQL

In Progress Posted 6 years ago Paid on delivery
In Progress Paid on delivery

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.

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.

Database Programming MySQL PHP Software Architecture SQL

Project ID: #16010844

About the project

19 proposals Remote project Active 6 years ago

Awarded to:

arityinfoway

Hello Sir, I have gone through your requirements is Normalize a CSV via Script ans MySQL. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of experience i More

€63 EUR in 3 days
(116 Reviews)
6.7

19 freelancers are bidding on average €40 for this job

rajeshsonisl

Hi there, I can create the Normalization script in PHP directly on your server. I'll need CPanel access (file + phpMyAdmin). Can begin right now. Thanks. Rajesh Soni

€100 EUR in 1 day
(895 Reviews)
8.5
glennwilkins

sir pm me i can finish this today ... sir pm me i can finish this today ... sir pm me i can finish this today ... sir pm me i can finish this today ...

€50 EUR in 0 days
(121 Reviews)
6.1
fanninson45

INTRODUCTION I am a database programmer, I have questions regarding your CSV scripting project. You can contact me and we discuss further on this project. I can build and create value from enterprise data, perform uni More

€111 EUR in 5 days
(21 Reviews)
5.7
devctang

This is very simple, just deploy a script on your server, All the operations will become Automation.

€34 EUR in 2 days
(4 Reviews)
3.7
rashmisingh2990

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.

€30 EUR in 1 day
(17 Reviews)
3.8
nishanmark4u

I've read your proposal and I would definitely be able to develop your project with lot of creativity, as developing is my forte and I completely understand your requirement. I am new in freelancer but have An Experi More

€30 EUR in 1 day
(5 Reviews)
3.3
dslc

If the servers are running a Linux or UNIX variant, then a cron job can be used to run the script daily. The database interface and CSV parsing functionality could be implemented using either PHP or Perl.

€14 EUR in 2 days
(2 Reviews)
3.5
ChafaaBouzerba

A proposal has not yet been provided

€50 EUR in 2 days
(7 Reviews)
3.3
AVKor

Hello, I can help you with your project. I'm an expert in CSV parsing and processing and MySQL DBs. Please provide me more details about your project, it would be nice to have a few samples and know the structure More

€30 EUR in 5 days
(12 Reviews)
3.4
Xeeshanah

Hello there, I've read the project description and understand the solution you need for your problem. I can provide a script in c# which will produced the desire output you mentioned and you can schedule the script us More

€30 EUR in 1 day
(2 Reviews)
2.3
mohsinuetion

I am experienced Oracle/Mysql/Cassandra Database Administrator currently working with RTA (Road and transport), UAE as an Outsourced company (Ideal Soft Emirates) employee. I have almost 8+ years of experience as core More

€29 EUR in 1 day
(1 Review)
1.2
r3xhaseeb

Experience ETL Developer for the past 7 years. Certified MySQL Developer & Administrator Have already build some thing like this and only needed to modify my script for your project needs

€23 EUR in 1 day
(0 Reviews)
0.0
thiagodequeiroz

I have degree in computer science and deal with this kind of need daily. I will do this in few days and delivery a full functional and documenteded source code.

€19 EUR in 5 days
(0 Reviews)
0.0