Update MySQL Fields - Import Export CSV file from FTP sites

Ditutup

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)

Keahlian MySQL, PHP, Python, Shell Script, SQL

Lihat lebih lanjut: export mysql data csv file members area site, quickbooks csv export mysql, sql job export csv file ftp, export mysql table csv file perl, sugarcrm csv export related fields, outlook csv export header fields, export mysql data csv file net, export mysql csv upload ftp, mysql csv export import, php export mysql csv file, mysql script import csv file, import csv export text file visual basic, import csv export text file, php import export mysql, import date time mysql fields

ID Proyek: #11725592

20 freelancer menawar pada rata-rata $84 untuk pekerjaan ini

leomedina01

Hi sir, My name is Leonardo Medina, and I'm from Brazil. I'm a web developer, have lots of experience in PHP/MySQL/Jquery/Ajax, and perhaps I can assist you in your project. Please drop me a line, so we can discu Lagi

$105 USD dalam 1 hari
(153 Ulasan)
6.8
$357 USD dalam 5 hari
(25 Ulasan)
6.4
$277 USD dalam 1 hari
(33 Ulasan)
4.6
mohamadserag

Hello there, I'd like to know few details about the project if you're considering me, thanks and good luck with the project.

$77 USD dalam 4 hari
(16 Ulasan)
4.3
cracken

I have my existing script to get and update file in FTP server. I can take good care of your project with quality and on time. Let me know the the best of your time to dicsuss so we can move forward to the next level.

$99 USD dalam 0 hari
(11 Ulasan)
4.2
davedcb

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Thank you, Best regards, David

$50 USD dalam 3 hari
(21 Ulasan)
4.1
phiona06

Hi! I can create shell script for cron with such command: 1) CREATE TABLE IF NOT EXISTS RSRgroupstocklevel (SKU int, StockLevel int) 2) LOAD DATA INFILE 'IM-QTY-CSV.csv' INTO TABLE RSRgroupstocklevel ... 3) UPDATE R Lagi

$30 USD dalam 1 hari
(14 Ulasan)
4.0
crazyunix

im system administrator and web developer i can meet your needs you are welcome to chat with me and discuss

$111 USD dalam 1 hari
(20 Ulasan)
3.9
crypthne

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 administ Lagi

$30 USD dalam 3 hari
(10 Ulasan)
3.5
rajaaziz

Send me files show you demo first and then you allot project and pay.and confirm one thing more first csv file you will upload on server which data will be inserted into mysql table and than that data will be altered Lagi

$150 USD dalam 5 hari
(3 Ulasan)
3.1
trhoan00

Hello, I'm a senior developer. I'm ready to finish this project. Thank you for reading my bid

$55 USD dalam 1 hari
(3 Ulasan)
2.4
CoolTechie07

I'm interested in doing this. Pl share one sample input, PM me and lets get going. I'm interested in doing this. Pl share one sample input, PM me and lets get going. I'm interested in doing this. Pl share one sample Lagi

$34 USD dalam 1 hari
(1 Ulasan)
1.8
rreddi

Take csv file from ftp server and import into MySQL database. The database should have two fields ‘SKU’ and ‘StockLevel’ 1. you will need a shell script to get the files from the source 2. a php file to extract dat Lagi

$55 USD dalam 1 hari
(2 Ulasan)
1.8
$30 USD dalam 4 hari
(1 Ulasan)
1.1
ioannislato

Hello, I am a full time python developer, and will be able to complete this project for you. I have one question though. It is not clear to me why you are mentioning SQL. All the data that we need to do the processing Lagi

$40 USD dalam 2 hari
(2 Ulasan)
0.7
enumaaa

I will do it in python. I'm not sure why you need the mysql thing? If all what you want is to update the ftp file, this can be done in memory, unless there's a memory constraint or sth. Then we might be using a fast an Lagi

$10 USD dalam 1 hari
(2 Ulasan)
0.8
adibossiseu

Hello, I have experience with databases, python scripting and also, with using FTP, skills which will help me to get the job done for you in about 2 days. Hope that we will work together :)

$10 USD dalam 3 hari
(0 Ulasan)
0.0
ausprofreelancer

Hello, I have extensive experience in performing similar functions to those you are requesting in your project and do so on a daily basis. I have established projects using a combination of shell, PHP and MySQL to Lagi

$88 USD dalam 2 hari
(0 Ulasan)
0.0
santoshlashkare

A proposal has not yet been provided

$35 USD dalam 2 hari
(0 Ulasan)
0.0
sarahlamie

I have the experience needed to provide you with a bug free script

$35 USD dalam 2 hari
(0 Ulasan)
0.0