What you REALLY need to know about your historical data when changing Records Management Systems.

āWeāre not happy with our current software, but we canāt switch because weāll lose all our data.āĀ If that sounds familiar, youāre not alone!Ā Many agencies feel trapped by their software vendors.Ā Even if theyāre not holding your data hostage, itās a non-starter to think about moving on without that valuable history.Ā I mean, what good is intel if you canāt access it, right?
Iām going to go out on a limb and guess that if youāre reading this article, that youāre looking to upgrade your software but youāre not sure what to do about the years of data youāve entered into your current system.Ā I get it.Ā When my agency switched to EFORCEĀ®, that was our primary concern.Ā Weād been with our previous vendor for more than 30 years, but we had issues with their software that they werenāt willing to resolve, and it was time to move on.Ā We had to get something figured out.
So, hereās my thoughts on the issue; both as a LEO who actively participated in my agency switching software providers, and now working with EFORCEĀ® and seeing the technical side of that process.Ā Iām going to offer a no BS point of view that will hopefully save you time, headache and money.
Understand the Whole Issue
There are definitely benefits to importing the data from your old software into your new software.Ā On paper, without the benefit on peeking behind the curtain into the ādeep end of the poolā, it seems like a simple and convenient solution.Ā But to make an informed decision about doing a data conversion, you need to understand the issues with converting data from one system to another.Ā There are some BIG drawbacks that most companies arenāt going to discuss with you until itās too late.Ā Here the main problems you will run into:Ā
Data Type Inconsistencies:
Little differences with how your old and new vendors record the same information can lead to big issues.Ā This can manifest in lots of different ways, but the long and short of is this: Different companies store and reference data in different ways, which means converting information from one system to another doesnāt always work the way it needs to.Ā Either you end up missing information, or with info that has nowhere to go.Ā This takes time to rectify and is in some cases impossible.
Bad Source Data
Simply put, if you have duplicate name entries, and other such problems with the data in your old system, do you really want to introduce those issues into your new system?Ā If you havenāt already cleaned up that data, are you going to dedicate the time and money to fixing it now?
Cost of a Quality Conversion
For all the reasons we just listed, this process is EXTREMELY time consuming, which equals a high price tag.Ā This process isnāt worth doing if itās not done right, and that doesnāt come cheap.Ā A typical conversion usually needs to be worked and re-worked several times to get it right, and this can take anywhere from 6 months to a year.Ā That adds up fast
So what does this mean?Ā Am I SOL when it comes to accessing my old data?
Of course not.Ā But I want you to understand that when a vendor tells you that theyāll do a data conversion for you, itās much more complicated than importing a spreadsheet.Ā If they tell you otherwise, theyāre lying to you.Ā It doesnāt matter which software youāre trying to merge; a data conversion is like trying to hammer a square peg into a round hole.Ā If you beat it enough times, it will fit, but itās not going to be easy or pretty.
If Iām being honest, I donāt think a data conversion is worth what you will pay for it.Ā Will EFORCEĀ® do a data conversion for you? Ā ABSOLUTELY we will, but from experience I can tell you; for you to get your data to where youāre happy with it, itās not going to be cheap, and itās going to take some time.
Whatās the best course of action?
There are other options that are typically MUCH cheaper than a data conversion:
Manual Entry
There are just some cases that have to be maintained.Ā Capital cases, Sexual Assaults, etc. all necessitate active access to the records, especially the evidence.Ā Manually entering these cases into your new system is often the quickest, and most accurate way to get the information you need.Ā In the case of EFORCEĀ®, weāve got some great ways to make sure that doing this doesnāt cause issues with your state reporting (NIBRS, etc.).
View Only Access Licenses
Most software vendors will concede that you own the data, and theyāll happily provide it to you in a GIANT spreadsheet.Ā Data in this format is pretty much worthless because of the time it takes to wade through it to find what youāre after.Ā Almost every vendor will happily sell you a limited access license to their software for the purpose of accessing your old information.Ā The cost on this is usually cheaper than paying for a data conversion.
Hard Copies
Most software will let you āprintā case information out in digital format (such as PDF, etc.).Ā This option is certainly better than losing your information, but it can be time consuming to search through.Ā With some careful cataloguing, you can pretty cheaply make this data available to your agency through your computer network.
If I donāt do a data conversion, arenāt I going to miss that data?
What did my agency do?Ā We chose to pay for the Limited Use Access to our old software.Ā Was it a perfect solution?Ā I wish I could say that it was.Ā I would have much rather had all of my data at my fingertips in my new EFORCEĀ® System, but it was the most cost-effective way to easily access our old info.Ā When we first went live with EFORCEĀ®, we manually entered all of the cases we were actively working, as well as our capital, sex assault, etc. cases that we needed, and off we went to work.Ā In the beginning, records was busy pulling data from the old system.Ā After about six months, the only reason we looked at that system was for open records requests and court.Ā Our āfrequent fliersā had all been pretty much entered into EFORCEĀ®, and I really never looked back.
Conclusion
I guess what Iām saying is that I was, as Iām sure you are too, very concerned about losing access to my historical data.Ā But the reality was that by the time a data conversion would have been complete, we were already past the need to access that information regularly.Ā It was still there if we needed, and we did occasionally, but Iām glad that we did not pay for a data conversion.
Weād love to talk more with you and your agency about your options in switching to EFORCEĀ®, and how we can make that a smooth transition.Ā Feel free to give us a call at 888-570-4943, x.3 or send us an email to [email protected]