There will be a CSV comma delimitted file created by Amazon Every 4 hours that will have our orders in them. Typical Information LISTINGID, NAME ADDRESS, EMAIL ORDERID... etc.
I am needing someone to write - IN ASP ONLY - a program that we can upload a file to our server, and properly import the orders in accordance with the MAPPING that I will give you. The orders CANNOT be duplicated in any way, and I will also need error checking in the file just in case ITEM ID's do not match... We may also need error checking in the Address section as well... all Address lines cannot be more than 34 characters. You will see in the two files enclosed. ONE is sample daily import, and the other is the mapping of which table, and field I need the data imported to. Again checking for proper items, and address length, and DUPLICATES will be VERY IMPORTANT as to not fill up the Database. This will be written in ASP an MUST reside on my win2k3 server.
When importing we will also need to import "BUNCHES" for example someone purchase a LOT of 4 cartridges... the system will CHECK an existing table that will state there is a LOT order, and pull the items from there.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Win2k3 - Access Database - ASP