Data enrichment php application that enriches a datafile with information from a mysql database linking the zipcode in the file with the zipcode in the database. The application has to do the folowwing actions: - user uploads source file (this file can be in different data formats like delimited (csv, tab, etc), fixed value text files, MS Excel, MS Access, dBase, etc. the files uploaded cab be Zipped (.zip) - user determines which column in the source file contains the zip-code - application will build a file with the enriched data in the same format as the source file or in Excel text format. 2 files can be build and outputed here: one with all the data from the source file enriched (all) and one with only the records that matches a zipcode in the database enriched (clean) All records that doesn't match with a zipcode in the database will be outputed in a error-file/log the user can select if he likes to download the results as they are or in compressed ZIP-format. --- for now the zip-code database only has two columns: zip code and companyCode. I also need an upload funcion to update/replace the database with my Excel file with the data in it. The data file has over 12000 records.. (i've added a smaller example in the zip file) the source file can have over 50000 records in it. the zip code in the source code can have a different format than the zipcode in the database. zip codes in the source code can be: 1234AB, 1234 AB, AB1234, AB 1234, 1234, 1234ABROTTERDAM, 1234AB ROTTERDAM while the zipcode in the database is 1234AB ---
## Deliverables
- The application and database must have the parts as described above in it. - The application have to be able to handle big source and output files (70000 records, over 10MB) - 100% payment after work is completed and tested by us - functionality can be added during the project for which buyer and seller have to agree about the price. AND 1) Complete and fully-functional working application 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
Apache/1.3.33 (Unix) PHP/4.3.9 MySQL 4.0.18-standard