The Challenge
IT Systems Integrators source HW and SW from dozens of manufacturers, combine the disparate element into a packaged solution, and deliver the complete package to an end-user customer. There needs to be a single customer quote which pulls together all the pieces into a single document.
Each manufacturer typically has tens of thousands of SKUs, and each provides quotes in a proprietary format. For example:
A Sun quote might look like this:
While a Symantec support quote might look like this:
This application helps translate data from various vendor quotesinto a common format.
The key data element is the Map
Sample maps might look like this:
Sun Map
Symantec Map
Creating a Quote
The user imports the 'source' or 'vendor quote' into a database and identifies which row contains the field names. The field names are then mapped to output fields.
The map element records these relationships. You can choose an existing maps, or create ane one via jQuery. Each new map is saved in the database for later reuse.
Finally, the rows containing the line items are selected, and the final output quote is saved in the database and is also displayed for input to another program, typically a spreadsheet.
Programming Statistics
- 1856 Lines of Ruby code (MVC)
- 1439 lines of test code
- 99.4% test coverage
- Technologies used:
- Ruby on Rails
- JavaScript
- jQuery
- AJAX
- Postgres
- USPS Address Verification API
- Rspec
- Capybara
- Cucumber
- Haml
- Coffeescript
- Ruby on Rails
- JavaScript
- jQuery
- AJAX
- Postgres
- USPS Address Verification API
- Rspec
- Capybara
- Cucumber
- Haml
- Coffeescript