One of our partners has a patch application . The patch application is a database application running on our server provided by our partners that syncs with our partners main database. The Partner server sends transaction to the patch application. We send updates on from our side to the patch which is then picked up by the Partner Server.
Requirement :
Write a script that queries the Patch applciation. The patch application uses access as a db. The script will query and download all new transactions/entries at a predetermined timeframe eg 15 mins/30mins/45mins/1hr . The download file will be sent via WEBSERVICES to our main system. If web services is not possible then the application will send the files via FTP to a user/pass we provide.
Application Specification and sample database will be provide for winning bid. We prefer entire process to be web based. So if it is possible to install the patch application and script on a hosting company that will allow the required ports open that will be helpful.
This is a simple job so outrageuos bids that dont address the requirement directly will be deleted without a second reading. PLIZ ADDRESS THE REQUIREMENT WITH YOUR PROPOSAL.