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

What is that Binocular Button anyway?

Sometimes we get so busy doing our jobs that we fail to take the time to learn more about the tools that we use everyday.  For alarm administrators, that tool is often CryWolf® or another similar program. Once I had discovered the Text Select tool, I began looking at other items on the tool bar.  In doing so, I found that clicking on the Binocular Button at the top right of a report (red arrow to the left) opens a search box.  This makes sense because the binocular button is officially called the Find Text tool.  To find what you are looking for, simply enter the word or number that you want to locate in the "Find What:" box (blue arrow below). If you want to limit the search, click on the search parameters boxes (green arrow below). Click the Search button (red arrow below) and the magic begins. In no time at all, the results of the search will be displayed in the results box (circled in black below).  Here, the sample shows that I searched for t...
Post a Comment
Read more