Applications For Data Manipulation

Case 1 Problem:

Company ABC had an old legacy system that worked really well for them. The company had customized the system so much that it would have been cost-prohibitive to convert to a new system. But the system only allowed orders to be imported in one specific format, using only the system's codes. Therefore, the company had to print out electronically-received orders, and then manually key them in. This was slow and not cost-effective.

Case 1 Solution:

TAP Solutions wrote an application that read in the customer's 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 fields.