Applications for Data Manipulation

Case 1 Problem:  

Company ABC has a old legacy system that worked really well for them and they had done so much customization that it would have been cost prohibitive to convert to a new system. The problem was it would only allow orders to be imported in one specific format using only the systems codes. What they had to do is print out all the orders they received electronically and hand key them in. This was slow and not cost effective.

Case 1 Solution:

What we did is wrote an application that read in the customers file, figured out which customer it was, translated the codes to the legacy's codes and uploaded it into the legacy system.  The translation program allowed the user to set up a translation on any or all the fields.