Find Jobs
Hire Freelancers

Autoscript: import csv to MySQL -> modify the file -> export to CSV Tool

€8-30 EUR

Closed
Posted about 6 years ago

€8-30 EUR

Paid on delivery
Please no auto bid, explain what your solution is!!! 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: 16166483

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average €41 EUR for this job
User Avatar
hello sir i am expert in Javascript, MySQL, PHP, Software Architecture i am able to do this work you will satisfy with my work i can do this work asap thank you
€29 EUR in 1 day
4.9 (212 reviews)
6.6
6.6
User Avatar
Hi, Greetings of the day!! Thanks for review my Bid. I have gone through from your description and can do this work comfortably. I have 6+ years experience in development and i have done lot's of project in my development career. Website Development (MVC Frameworks,E-commerce),Strong database knowledge specifically MySQL. Extensive knowledge of PHP,Cakephp,CI,Laravel,Opencart,Wordpress,Zend,Node.js,Facebook Bot. Please open this PMB. Waiting for your response!! Regards,
€34 EUR in 1 day
5.0 (94 reviews)
6.2
6.2
User Avatar
let me try I have done work in csv and xlsx ...............................................................
€21 EUR in 1 day
5.0 (35 reviews)
5.7
5.7
User Avatar
Hello. Just to be clear, do you mean a simple substitution (if the input is 'x', use 'y' instead)? If so, that's a simple task. I'd create a CLI PHP script so it could be put to a cronjob, along with some json/ini configuration to match A<->B. Also, is the FTP server (b) outside the computer running the script or is it just a matter of placing the output CSV to some folder? Thank you.
€30 EUR in 1 day
5.0 (24 reviews)
5.5
5.5
User Avatar
Where you want run the code?server or local? Please send me details ...................................................... .................................
€100 EUR in 1 day
5.0 (47 reviews)
5.6
5.6
User Avatar
Hello, I am interested in your offer and is ready to cooperate. I have experience in writing scripts in Javascript , php, mysql. I have experience in creating web app, websites, amendment to the sites.
€55 EUR in 5 days
4.9 (13 reviews)
3.8
3.8
User Avatar
I have been working for well IT organization mostly worked for Microsoft project. Have a good experience of working for such type of project.
€55 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Berlin, Germany
5.0
7
Payment method verified
Member since Jun 28, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.