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

Lexington KY False Alarms

Our travels last week took us through Kentucky.  Of course I had to peruse the web to see what is going on in the world of false alarm reduction in the bluegrass state.  Of the cities that we would be visiting, Lexington was the first that I found with a false alarm reduction unit.

Alarm systems in Lexington must be registered and there is an application fee of $15, which seems to be a one time fee. (Update: the $15 fee is an annual fee). Lexington's ordinance is similar to most other ordinances, but it has a feature that I have not seen before.  The fine schedule lists minimum and maximum fines.  If an alarm user doesn't contest the alarm, they pay the minimum fine.  If they contest the fine and lose, they could end up paying the maximum fine. Fines begin at the fourth alarm with a $25 minimum fine and go up to a $300 minimum fine for the 9th alarm (maximum fine is $500).  These fines are relatively low compared to fines in the area where I live;  however, the 10th alarm in L…

Coal mine

I have always been drawn to the strange and unusual, especially when it involves venturing off the highway onto back roads with the promise of an adventure.  On the way back from Youngest's college orientation, we found ourselves in Beckley, West Virginia at a McDonald's.  This was not our first choice, but sometimes you have to take what you can get.  While we were enjoying our fine dining experience, my eyes were drawn to this sign that was just visible from where we were sitting.  When we finished eating, I couldn't leave without a photo.  To my astonishment, Hubster asked if I wanted to visit the exhibit.  After I picked my jaw off the floor of the car, I responded "sure".
With no more than that arrow pointing the way, we set off into the wilds of West Virginia.  Youngest swore he heard the sound of banjos.  After several miles of twists and turns,  I was beginning to think that we had missed a sign.To my relief, a sign appeared letting us know that we had ar…

New Technology-QR Code

We are going to venture away from CryWolf® today to discuss other technology that can assist in the mission of reducing false alarms.  One emerging technology that can be harnessed by alarm units is the QR code. As an example, the QR code below includes the web address for this blog.
A QR code is a form of bar code similar to a UPC code but with the ability to hold greater amounts of data. These codes were developed by an auto manufacturer in Japan to help them track parts.  Although the company holds the patent rights, they have chosen to not exercise those rights. This allows free use of the technology.
QR codes may be formatted to hold all manner of information such as phone numbers, e-mail addresses, gps data, or a web address. QR codes can easily be added to business cards, brochures, and other printed materials.  Many Home Owner Associations in our area allow us a small space in their publications and QR codes are perfect for this space.  The codes can even be included on facebo…