Skip to main content

Weeding out Duplicate Accounts

It is Thursday again and time for our continuing series of helpful hints for the alarm billing software CryWolf®. I know it is scandalous, but we won't be looking at letters today. Today, we will focus on the subjects receiving those letters.

No matter how careful data entrants are, duplicate accounts seem to appear in the database.  I have discovered that these duplicate accounts are opened most frequently during alarm processing.  If CryWolf® doesn't find a match for the alarm site automatically, the manufacturer recommends manually searching three times before adding an account.  I think this is because the normal duplicate prevention measures built into the system don't work when an account is added during alarm processing.  Even following these measures, duplicate accounts will slip in due to misspellings or some other error.  As a result, it is a good idea to check the system occasionally for possible duplicate accounts.

To run a report that will list possible duplicates, go to the Report Menu.  Scroll down to Searches and then to List Possible Duplicate Accounts.
There are several options available to limit the search.
Click OK, and the search will begin.  The search will produce a list that includes all addresses that have the same number and street name.  It does not eliminate addresses that have different suite or apartment numbers.  This means that in our area where all of the stores in a shopping mall have the same street address with different suite numbers, all of the businesses will be listed as possible duplicates because they have the same street number.  This makes the report a bit bulky, but these addresses are easy to skim over as you review the report for real duplicates.

I hope this will help your units clean up your databases.  Prevention of duplicates is better, but this will help you find and remove the ones that do slip in.

Comments

Popular posts from this blog

In Memory of...

I was fortunate enough to be able to travel to Washington DC during National Police Week .  While there, the Hubster ran the Police Week 5K and we visited the Law Enforcement Officers Memoria l.  The memorial is a sobering reminder that so many have given all in the pursuit of public safety.  Unfortunately, it was raining so the pictures aren't great, but the rain seemed fitting--almost as if angels were mourning with those gathered there.  The memorial itself is surrounded by a beautiful park setting with trees and seasonal flowers and is composed of two curved marble walls engraved with the names of the more than 19,000 officers who have died. Each of the memorial walls is flanked by a lion protecting its cubs and keeping silent vigil. Seal embedded in center of the memorial plaza It seems that every day a new name is added to the list that will be inscribed just before Police Week begins.  The park and memorial are beautiful and worth a stop if ...

Albemarle County Ordinance Update

A dministrators of false alarm units are often called on to present information to the local government officials.  In preparation for my debut briefing the Supervisors in my county, I visited Albemarle County last week for their  Board of Supervisors meeting .  The Albemarle County Police Department was before the board to present some updates to their false alarm ordinance so it was a good opportunity to witness public reaction.  The great thing about local government is that the public has the opportunity to participate.  Albemarle County and many other counties allow citizens to have their time to air their opinions simply by signing up before the meeting begins.  The number of people who sign up, determines how much time each speaker is given.  For this meeting, there were so many people signed up, that the time limit was reduced to two minutes each. The agenda for each meeting is generally posted in advance but the public commentary doe...

Queen of the Dairy

Did you know that the Dairy Queen Blizzard turned 25 last year?  I remember when the Blizzard was introduced which makes me officially...old.  Anyway, there was no Dairy Queen in the town where I grew up but there was one where my great grandfather lived.  Do you remember when a trip longer than 15 minutes lasted fuh evah?  When I was little, the 65 minute drive to my great grandfather's small town felt like an eternity.  Maybe it felt so long  because  I was hoping for that extremely rare occurrence of a stop at the Dairy Queen.  My parents were teachers  and the budget was always tight, but occasionally we would stop at DQ and we could get a small cone.  We never got to choose--it was always just that small vanilla cone, but it was a treat nonetheless. Once I was able to drive and had a job, those stops at DQ were almost mandatory when I ventured on my own to my grandparents house.  I probably tried something different each time-...