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)
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
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.
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.
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.
Having strong experience in linux/unix shell scripting. Can work on oracle PL/SQL. let me know if my profile suits your requirement.
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.
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.
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.
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.
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 .