Normalize a CSV via Script ans MySQL
€8-30 EUR
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.
Project ID: #16010844
About the project
Awarded to:
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
19 freelancers are bidding on average €40 for this job
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
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 ...
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
This is very simple, just deploy a script on your server, All the operations will become Automation.
I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.
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
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.
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
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
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.