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

CiteBlue

I have been enjoying participating in the MSU College of Law Social Media Contest . I have learned (and am still learning) a lot. Because of my activity, I have been able to connect with organizations and people that I would never have come across without social media. For this introvert, it has been like opening a whole new world. (I know, most people would never guess that I am an introvert; they probably just think that I am a snob. In social settings, I am a complete misfit, but put me in front of a classroom or conference room and I shine. It is strange, I know, but that is me. Perhaps we will dissect that in a different post). It has been interesting to see what posts attract followers. It has also been eye opening to figure out that followers also appear with an agenda--for example, some follow hoping to be followed in return to build their own group. This week, a company called CiteBlue "followed" me on Twitter. I wasn't familiar with the company, so I clicked o...
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

Default doesn't mean Permanent

My unit has been around for a number of years, so rarely do we create a new alarm company account as a result of receiving an unsolicited registration form.  These days, new alarm company accounts usually result from a citizen registering their alarm system and reporting an alarm company that is not in our database.  Of course, we aren’t going to let that alarm company do business in our county without being registered, so we create an account for the company and place it in pending status until they return all of the required forms.    Occasionally, I have been bothered by the fact that the status for a new alarm company account defaulted to "Registered" status and had to be manually changed to "Pending".  It made more sense to me that the default status should be "Pending". Tonight, I had a few minutes to investigate for a solution. While using  CryWolf®,   I have found solutions to be available if I take the time to look for them.  If you...
Post a Comment
Read more