Ruby on Rails application where the user can upload a csv file, automatically import it into a MySQL database, run some cleanup scripts to validate/fix addresses and other fields, and then export the cleaned data into a comma delimited file which can then be downloaded for use with Microsoft Word Mail Merge files - I already have the mail merge files so don't worry about those. The original csv file usually contains anywhere from 100 to 500 rows, and always has 19 columns. The csv file does not contain headers, but I will explain the fields to you in that attached file. The MySQL database will only have 4 tables. One for people, one for charges, one for charge levels, and one for people/charge. I already have the db structure completed. You can find the initial schema in the zip file along with the sql data dumps that will populate the charges and charge_types tables. I would like an interface to choose which rows/records to filter out by Level of Offense when creating the cleaned csv file. I envision this as a setting which can be changed when needed, but not every time the filter is run. Any person without an address, or an address listed as Homeless/Vagrant/Transient should automatically not be included. Check addresses for validity and put them into the proper post office formatting including zip+4. See [url removed, login to view] for an idea of what I am talking about. This part of the project is of lowest priority and might be axed if too expensive/time consuming.
1) All source code of complete and fully-functional Rails application.
2) Deliverables must be in ready-to-run condition, as follows:
a)? The deliverable Rails application must successfully run on a webrick development server and render correctly in Firefox 1.0+ and IE 6+.
b) Buyer will install the application himself. 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).
Firefox 1.0+, IE 6+.