Suljettu

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

Taidot: MySQL, PHP, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: opencart import export file format, vba excel export file ftp, import inventory ftp magento, export import virtuemart database, import 80mb database file mysql, export import magento database, inventory database update text file, quickbooks inventory database export, aspnet import export file xls, vbnet export file database, server inventory database, access inventory database, access chemical inventory database, inventory database access, import sql database web developer

Tietoa työnantajasta:
( 3 arvostelua ) Fleckney, United Kingdom

Projektin tunnus: #14843341

112 freelanceria on tarjonnut keskimäärin 2170 £ tähän työhön

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 Lisää

2938 £ GBP 30 päivässä
(160 arvostelua)
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 Lisää

4500 £ GBP 30 päivässä
(287 arvostelua)
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 30 päivässä
(410 arvostelua)
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 Lisää

2500 £ GBP 30 päivässä
(456 arvostelua)
9.6
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 Lisää

2319 £ GBP 30 päivässä
(180 arvostelua)
8.7
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 Lisää

1500 £ GBP 7 päivässä
(949 arvostelua)
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 Lisää

2105 £ GBP 20 päivässä
(204 arvostelua)
8.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 Lisää

2000 £ GBP 25 päivässä
(353 arvostelua)
8.5
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 Lisää

1546 £ GBP 40 päivässä
(380 arvostelua)
8.2
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….. [url removed, login to view] https://www.cart2send.com. Lisää

2500 £ GBP 30 päivässä
(145 arvostelua)
8.0
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 Lisää

1666 £ GBP 30 päivässä
(88 arvostelua)
8.0
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 Lisää

2200 £ GBP 26 päivässä
(140 arvostelua)
8.1
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 Lisää

2368 £ GBP 30 päivässä
(188 arvostelua)
8.4
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 Lisää

2000 £ GBP 25 päivässä
(128 arvostelua)
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 Lisää

2500 £ GBP 30 päivässä
(32 arvostelua)
7.6
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 Lisää

1578 £ GBP 30 päivässä
(213 arvostelua)
7.8
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 Lisää

1500 £ GBP 12 päivässä
(224 arvostelua)
7.4
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 Lisää

3000 £ GBP 30 päivässä
(123 arvostelua)
7.1
specialist77

I can offer my support to develop the autodownload application with database import in 10 days including the testing and bug fixing. If you are interested I am available to begin immediately. Relevant Skills and Exper Lisää

1700 £ GBP 10 päivässä
(29 arvostelua)
7.2
albertmobi29

Hi there, Thanks for sharing details, we can assist you in developing a tool that will download a CSV file from FTP, import it to database and export a relevant file depending upon changes in column quantity. We Lisää

2500 £ GBP 30 päivässä
(46 arvostelua)
7.2