In our age of technology and communication it is common that our customers are adopting RiteTrack after using another data management system, often for a substantial amount of time. One of the largest concerns that we deal with is, “Will we get to keep our data and will it be complete?” At Handel, we understand that historical information is invaluable to spot trends, maintain reporting requirements, and increase interdepartmental communication. That is why we have developed proprietary software to quickly and accurately convert legacy data into RiteTrack.

Our data conversion process starts at the very beginning of our project management process; Handel views data conversions as a key and central part of our software implementations, not as an afterthought. Our trained project managers begin by explicitly mapping out each column in every table in the legacy database and define a place for it to go in the new RiteTrack system. This process takes place alongside the creation of the system design so that the mapping is completed before we start developing the system in order to make certain that no crucial data is left behind. During this process your project manager will highlight areas where the legacy data may not be clean or accurate so that no dirty information finds its way into the new system.

While on the initial site visit, your project manager will sit down with you and your staff to walk through your legacy system to gain a full understanding of its functionality, how your staff uses it, and any potential difficulties that may arise in the conversion process. Since every system is different we make sure to take the time to get to know it. This practice gets to the core of how Handel does business; each project and each customer is unique and we dedicate ourselves to forming a relationship based upon communication, transparency, and honesty.

Once a conversion map has been completed and approved, the data will begin the process of being moved into RiteTrack. Our skilled developers have built software to assist us in the conversion process. Using this single core technology reduces errors, speeds up the conversion process, and lowers cost. Our data conversion experts work side-by-side with our project managers throughout the entire project to make sure that this process is as streamlined as possible.

Much like our software development, our data conversion process involves multiple rounds of testing and validating to make sure that the end product is exactly what it should be. You and your staff will be able to see and test the converted data in a sandbox version of RiteTrack, this will even include any custom fields that have been added. For larger systems this is often done in phases to ensure that nothing is missed in the sheer volume of information we work with.

Handel’s Conversion Process (Click to Enlarge)

We have utilized this process on databases of all sizes, from a few thousand rows of data up to millions of rows. To gain a more complete understanding of how our data conversions fit into the entire software implementation process please read Problem Solved: A Story of Vanquishing Risk and Complexity.
Finally, when the entire data conversion has been tested and approved, Handel will pull a final and current copy of the legacy database for conversion. This information will be what eventually comprises your initial RiteTrack system. At the end of this process your users will have a new, friendly, and easy-to-use software solution complete with all of the data that has been tirelessly entered by users in the legacy system.

This simple, yet powerful, methodology, when paired with our proprietary software, takes the often frustrating and error-prone process of converting data and turns it into an efficient and organized procedure. What is more, our data conversions are fully supported just like our software. If there is an issue found after RiteTrack has gone live our data conversion experts will rectify the error, often with zero downtime for users. Our philosophy for data conversions is the same as it is for building software; we center everything on our clients and their needs in our pursuit for the best product possible.