Import Inventory to a Database via FTP and Produce an Export File Hourly

Ditutup Dipasang 6 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

SUMMARY:

We are an online bookshop and we require a software engineer to create an application to auto download files via FTP in a csv file format, import to a database and produce an export file to a local location.

PROCESS:

1 Download latest .CSV file from the FTP location

2 Import to the database

3 Depending on any changes to column "Quantity" in the latest .CSV file compared to what is already in the database, produce an export file with relevant data that has changed.

The exported file will use the same data columns from the import file and also add the column "Monsoon OP", "Classification" and "eBayStoreCategory"

Deadline for completion is 30th August 2017 and must be tested and working.

Please advise if you have any questions.

Laurence @ The Monster Bookshop

MySQL PHP Perancangan Perangkat Lunak Visual Basic

ID Proyek: #14843341

Tentang proyek

106 proposal Proyek online Aktif 6 tahun yang lalu

106 freelancer rata-rata menawar £2182 untuk pekerjaan ini

kchg

https://www.freelancer.com/u/kchg.html As you can see my profile, my ranking is TOP 5TH in freelancer.com I'd like to discuss with you in detail. Sincerely, KCH G

£3333 GBP dalam 30 hari
(440 Ulasan)
9.8
rinsadsl

Dear Laurance I have worked with FTP transfer earlier. I can download the CSV file from the FTP , update the local database and create the export file based on the effect to the Quantity. I can deliver this project Lebih banyak

£1500 GBP dalam 7 hari
(1336 Ulasan)
9.7
meet2amitvw

Let's discuss more about project to finalise the proper scope with estimated cost and time so ping me over the freelancer chat.....I will share some demo as well for recent works if you want to check. Relevant Skills Lebih banyak

£2938 GBP dalam 30 hari
(181 Ulasan)
9.4
monitrix

Hi, Consider me I am having an highly experienced team with me expert in various platform . Share more information so i clear my queries over chat. Thanks:) Relevant Skills and Experience MySQL, PHP, Software Architec Lebih banyak

£2000 GBP dalam 25 hari
(540 Ulasan)
9.4
TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Lebih banyak

£2105 GBP dalam 20 hari
(261 Ulasan)
8.9
bdsiddhi

We already have developed similar functionality in which system will automatically get the FTP files and import into the DB and based on the inserted data we can export it as what we want. Relevant Skills and Experie Lebih banyak

£2368 GBP dalam 30 hari
(295 Ulasan)
9.0
mithusamsukha

Dear Client I have 6+ years of experience with Development and Designing. I have worked on lots of projects and offering below services :- 1 PHP Frameworks (Laravel and CI) 2 CMS (Joomla , WordPress , Magneto Lebih banyak

£3000 GBP dalam 30 hari
(87 Ulasan)
8.7
webbookstudio

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so Lebih banyak

£2200 GBP dalam 26 hari
(395 Ulasan)
9.0
babysoftS

Hi Laurence, I understand your requirement to auto download files via FTP in a csv file format, import into database and generate an export file to a local location. I can finish it by 31st August. Relevant Skill Lebih banyak

£2000 GBP dalam 25 hari
(201 Ulasan)
8.6
hiretechexperts

Hi, Have gone through the details provided , but still need to clarify few things before proceeding. So please send a message when you are available to discuss. For now I am putting a placeholder bid amount as the am Lebih banyak

£2500 GBP dalam 10 hari
(77 Ulasan)
8.3
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex Lebih banyak

£3000 GBP dalam 30 hari
(426 Ulasan)
8.4
marchingantssl

Hi Laurence, We have done similar thing for one of our book seller client from Sweden. I would like to get more details from you for the project, what technologies the existing platform uses etc. Relevant Skills and Lebih banyak

£1578 GBP dalam 30 hari
(253 Ulasan)
8.0
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks Relevant Skills and Experience MySQL, PHP Lebih banyak

£1546 GBP dalam 40 hari
(475 Ulasan)
8.3
fleetways

We would like to propose a PHP based command line application (or a windows client application), kindly respond to enable further discussion. Not sure you want this (download, import and export) a recurring feature (e Lebih banyak

£1666 GBP dalam 30 hari
(97 Ulasan)
8.3
esalem

I am interested in your project and like to discuss the details with you like what is the data structure of the imported csv file? and what is the data structure of the current existing database ? Relevant Skills and Lebih banyak

£3421 GBP dalam 30 hari
(68 Ulasan)
8.0
Rauxmedia

Experienced Software Engineer at your service. Vast experience creating solid automation scripts. For this project, I'd use Python to complete the entire process described above. Relevant Skills and Experience Python, Lebih banyak

£2500 GBP dalam 20 hari
(52 Ulasan)
7.6
amrshawky35

Hi Laurence, Is it possible that the CSV file would contain a new item that is not in database? So in this case what should happen? I'd like to discuss more details with you regarding the needed functionality so Lebih banyak

£1500 GBP dalam 6 hari
(119 Ulasan)
7.7
eclipsetechno

Hi Laurence, We will schedule File transfer but you need to have an SSH server installed on remote host (OpenSSH is free). For the application, admin shall take the batch file and import it to the DB from back en Lebih banyak

£2500 GBP dalam 30 hari
(38 Ulasan)
7.7
inzaghi2006

Hi, I'm senior developer and I'm very interested in your project. Please contact me for detail. Thanks Relevant Skills and Experience I've done may projects Proposed Milestones £1500 GBP - project milestone

£1500 GBP dalam 20 hari
(221 Ulasan)
7.5
mascotindia123

Hey Friend, Myself having has 10 + years experience of web site development. We have skilled programmer, We are 14 person team of developer, designer and tester provide you excellent services. Expert in Custom p Lebih banyak

£1500 GBP dalam 12 hari
(319 Ulasan)
7.8