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.
Labels:

Comments

Post a Comment

Thanks for stopping by my little piece of the web. I look forward to reading what you have to say!

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 ...
1 comment
Read more

Ferret Friday #5-Rice box

Ferrets are curious creatures that need a variety of toys and activities.    Our ferret loves to dig, and one of his favorite activities is digging in a plastic tub filled with rice.  We make sure it is not available at all times so that it remains a special treat. As much as he loves the rice, if given a choice, he would choose to dig in the dirt of my ficus or citrus tree.  He also loves to "tunnel" under the covers of our bed.  He is not normally a biter, but for some reason, he will bite any toes under sheets.  My theory is that since ferrets are tunnelers and are carnivorous, then he must have some instinct to eat what he finds while tunneling.  Maybe the toes are "earthworms" to him. When my kids were small, they also loved to play in their rice box.  Their rice was multi-colored though. We have added a few PVC pipes (we smoothed all rough edges with sandpaper).  Occasionally, we add some cardboard mailing tubes as well.
Post a Comment
Read more

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-...
2 comments
Read more