Update MySQL Fields - Import Export CSV file from FTP sites

Budget $10 - $30 USD
Bids 21
Average Bid $82
Status Closed

Objective: To keep a stock level file updated on an ftp site. The code will need to do a find and replace preformed on the ‘Stock Level’ field. We need to find stock levels that are greater than 3, if it is greater than 3 then the value needs to be changed to 3. (example: if value is 22, change the value to 3) We never want to have a inventory level for a product that is greater than 3. Once the fields have been updated, then export the table as an csv file to an ftp site.

The code can be either SQL, PHP, Python, command line

Take csv file from ftp server and import into MySQL database. The database should have two fields ‘SKU’ and ‘StockLevel’

1. MySQL database table ‘RSRgroupstocklevel’ the Field ‘StockLevel’ should be calculated to ‘0’ so all stocklevel is zero before importing new levels.

2. The csv file [url removed, login to view] will be imported from an ftp location into ‘RSRgroupstocklevel’ table

3. The file [url removed, login to view] does not have headers. It is two colums. One is the SKU name and the other is the stocklevel which is a number between 0 to 5000.

4. ‘RSRgroupstocklevel’ table find all ‘StockLevel’ filed numbers that are greater than 3, if greater than 3 change to ‘3’.

5. Export ‘RSRgroupstocklevel’ table as csv to ftp location.

6. This code should be run on a schedule of every 30 minutes. You may want to use an MySQL Event to do this. Or a cron job. (the original inventory list on the ftp server is constantly being updated)

7. Create brief documentation for re-use of the script. Provide steps and documentation on how to implement. (where to save files, any configuration)

8. Example Files can be provided during the bidding process, just ask and I will send them to you.

9. You will NOT be provided a machine / server, so please don’t ask for it. We can test your script on our server if you want to ensure that it will work at our end.

10. If have suggestions on a better way to complete this task then let me know. (changing values greater than 3 in a csv file on a schedule)

Get Free Quotes For A Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • CoolTechie07 Profile Picture


    Jaipur,  India

    Hi all, quality delivery and customer satisfaction is my motto. - I have experience of developing applications in C++/C on both Linux and Windows platforms that are efficient and performant. - I also do have skills in Shell scripting, Python, PHP, C#, ASP.NET, Perl, MT4, MQL4, Excel, VBA, all types of Data Transformation & Analysis, Web Scraping. - 10+ years of experience in hardcore programming. Looking forward to get more challenging work here.

  • adibossiseu Profile Picture


    Beius,  Romania

    I'm good at writing code, especially in Python, C, Java. Used to work in Python with databases, like SQLite, PosgreSQL, or MySQL. Also, used to work with big quantities of data in Python.

  • davedcb Profile Picture


    Lisboa,  Portugal

    I'm a Biomedical Engineer, specialized in Medical Electronics. I am skilled in sensors, robotics, signal and image processing and programming, particularly in the C, Python, SQL, PL/SQL and JAVA programming languages.

  • santoshlashkare Profile Picture



    Having strong experience in linux/unix shell scripting. Can work on oracle PL/SQL. let me know if my profile suits your requirement.

  • cracken Profile Picture


    Talisay,  Philippines

    Enthusiastic developer, expert in all web applications, iOS and android development looking to be hired. Throughout my career I have been working as a Python, PHP, Java, Perl, Javascript, java developer and angular JS, ShellScript. If my qualifications are suitable for you, please consider me for your current project or future job.

  • mrohailparacha Profile Picture


    Lahore,  Pakistan

    I have got vast experience in web development, desktop development, scrapping and troubleshooting. I have done work in web hosting , server development and database development. I prefer to work for customer satisfaction and provide best quality work in most affordable prices.

  • ioannislato Profile Picture


    Sheffield,  United Kingdom

    Backend development in Java/Python/Groovy, Frontend in JS/ ReactJS, also mobile with React native. Attention to detail, only looking for interesting projects, with clients that have a clear understanding of what they need.

  • crypthne Profile Picture


    Kediri,  Indonesia

    I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.

  • enumaaa Profile Picture


    Maadi,  Egypt

    I'm curious, I love exploring new fields, technologies, and experiences: Archer, Management, Cooking, Massage, Drawing(stick figures), 2D Animations, SkyDiving, Games (playing them), VR, Leap Motion, MYO, ... ,etc. I would sell my soul for a hololens. I never get bored of acquiring more knowledge about anything, sugar and cat gifs. I love to support people around me to try the stuff they've always wanted to go for,yet they never gave it a try.

  • rreddi Profile Picture


    Hyderabad,  India

    An 8 year Tech Developer specializing in C#, Python, PHP, MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Bootstrap , HTML 5 , CSS and Java Script .