VIN Decoder

1) Application to decode Vehicle VIN Codes from 1981 - 2012. a) Prefer this to be a web application with a web interface. 2) Must decode batches of at least 10+ million VINs per day. a) Must utilize a database i) Preferably MySQL but not required. 3) If a VIN is invalid it must print the VIN Code decode as much as possible and print "Bad Code" and the section of the code for the sections that can not be decoded. 4) Decode VIN to plain text. a) Only need the first 11 characters decoded. 5) The tables used to decode the VINs are extreamly large. a) I will supply the tables in whatever format is necessary for the application. b) Tables change every year and per manufacturer which means there will be thousands of tables used to decode the VINs. c) Program will first need to determin the Country, Manufacturer, Vehicle Type, Year, and Assembly Plant from the VIN Code before it can decode the Vehicle Features. d) Necessary Headers: VIN,Country,Manufacturer,Vehicle Type,Vehicle Features(Digit 4-8),Check Digit,Year,Assembly Plant,Seq Number i) Seq Number should not be decoded. Just reprinted. 6) We will need the option to export the decoded VIN File as a CSV file. 7) If this is programmed as a desktop application then an input and output directory need to be specified. 8) Application must be designed in a way that it can easily be moved/copied from one server to another. Reference Links for VIN Codes Here are some pages you can use that explain how to decode a VIN Number. [login to view URL] [login to view URL] [login to view URL] [login to view URL] I would like to have a Sample Project completed . This sample project will only include tables for 2004-2011 and possibly have a 100,000 VIN decode limit in place. I will use this to decode a list of 10,000 VINs and then decode 100,000 VINs in order to calculate approximate time needed to decode batches of VIN codes. Upon receiving sample project a 30% milestone will be paid. From there any adjustments that need to be made in order to consider the project successful will be completed. Once the sample project works completely an additional 30% milestone will be paid. Finally all tables will be added and limitations removed. The remainder of the full payment will then be released.