Đã Đóng

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

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

Kỹ năng: MySQL, PHP, Kiến trúc phần mềm, Visual Basic

Xem thêm: import inventory ftp magento, export import virtuemart database, export import magento database, quickbooks inventory database export, vbnet export file database, server inventory database, access inventory database, access chemical inventory database, inventory database access

Về Bên Thuê:
( 3 nhận xét ) Fleckney, United Kingdom

Mã Dự Án: #14843341

114 freelancer đang chào giá trung bình £2169 cho công việc này

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 Thêm

£2938 GBP trong 30 ngày
(157 Đánh Giá)
9.3
best1

Hi, Current bid is Placeholder. We would like to complete your requirement for auto download files via FTP in a csv file format, import to a database and produce an export file to a local location. We have experienc Thêm

£4500 GBP trong 30 ngày
(283 Đánh Giá)
9.9
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 trong 30 ngày
(391 Đánh Giá)
9.5
infoway

Hi Laurence, After gone through your project description one thing is not clear. Do you want us to build the web application and adjust those settings or do you already have any web app? For now check some of our Thêm

£2500 GBP trong 30 ngày
(420 Đánh Giá)
9.5
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 Thêm

£1500 GBP trong 7 ngày
(890 Đánh Giá)
8.5
Reflexlogic

I understand you want customized software developed which will automatically download file from FTP in CSV format and import into your database and then export file with real time data with few column Relevant Skills Thêm

£2319 GBP trong 30 ngày
(168 Đánh Giá)
8.6
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 Thêm

£2105 GBP trong 20 ngày
(191 Đánh Giá)
8.2
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 Thêm

£2000 GBP trong 25 ngày
(282 Đánh Giá)
8.3
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 Thêm

£1578 GBP trong 30 ngày
(212 Đánh Giá)
7.7
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 Thêm

£1546 GBP trong 40 ngày
(368 Đánh Giá)
8.1
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 Thêm

£1666 GBP trong 30 ngày
(88 Đánh Giá)
8.0
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 Thêm

£2368 GBP trong 30 ngày
(178 Đánh Giá)
8.3
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 Thêm

£2200 GBP trong 26 ngày
(92 Đánh Giá)
7.7
Techizer

Hi.. I would like to inform you that we are the most eligible freelancer here with whom you can discuss this project. Relevant Skills and Experience OUR WORKS….. www.theadvertplace.com https://www.cart2send.com. Thêm

£2500 GBP trong 30 ngày
(124 Đánh Giá)
7.7
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 Thêm

£2000 GBP trong 25 ngày
(117 Đánh Giá)
7.6
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 Thêm

£3421 GBP trong 30 ngày
(26 Đánh Giá)
7.2
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 trong 20 ngày
(204 Đánh Giá)
7.3
londonlance

We are a London (Shoreditch) based web development studio. Please get in touch to discuss further. Following are some of our recent projects; https://postlater.co/ A social media post scheduler and manager Thêm

£3000 GBP trong 30 ngày
(38 Đánh Giá)
7.5
JoomlaVogue

Template design : https://docs.google.com/spreadsheet/ccc?key=0AlhZrXy20aE9dHFDSGV3ZkJGcWZhdG9aMmlIWlhCd3c&usp=sharing#gid=7 Relevant Skills and Experience Template design : https://docs.google.com/spreadsheet/ccc?k Thêm

£1500 GBP trong 30 ngày
(107 Đánh Giá)
7.5
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 Thêm

£2500 GBP trong 30 ngày
(29 Đánh Giá)
7.4