Comm One LLC Blog

Comm One .CSV File Import Extension / Name Utility If you have ever wanted to easily update your Comm One Call Accounting Station File from a .CSV File this utility is what you need.  This will take a CSV File that you create and overwrite the contents of your station file on the Comm One Call Accounting Software. FIELDS THAT CAN BE IMPORTED The fields you can import are: Extension Number Name Department Division Site SAMPLE CSV FILE LAYOUT The only field that is required is the extension filed.  The other fields are optional.  Here is an example of a .CSV File that could be used to import into Comm One.  You can name the file anything you would like as long as it has a .CSV File extension. 1248,"Millie Jesperson","SALES","DIV 22","SITE 22" 1252,"Jan Elles","ADMINISTRATION","DIV 23","SITE 23" 1253,"Dana Lassen","ADMINISTRATION","DIV 24","SITE 24"

     Many years ago when I was in my early 20's I lived in Japan with a couple of guys who were first cousins.  They were pretty good friends, but competed to be better than each other over just about everything.  One day they went out and purchased new wrist watches.  Electronics in Japan were inexpensive back then because of the exchange rate, and they both purchased very nice time pieces.  That's when all the fun began.  For days we kept asking them what time it was because they would both give a different answer and then attack each other maintaining that their watch had the correct time.  This went on for days until one morning we heard a scuffle followed by the cry "You can't tell me I'm wrong on this one, my watch is set to International Time".  I'm not sure what International Time had to do with it, but a fist fight broke out and we had to pull them apart before they killed each other.      I remember thinking how silly they were to argue ov

     I'm not much of a gardener, but I enjoy having a garden.  My father was a big gardener and I remember planting a garden in the backyard when I was a kid.  Now I mostly grow a wide variety of weeds.  This year I tried to make gardening easier.  I planted potatoes, carrots and pumpkins.  To make the garden easy to weed I made wide rows that I can easily weed with my electric tiller.  This was going to be my best garden ever.              Apparently word got out because the snails moved in.  Yesterday I checked on the garden and one of the potato plants was eaten to the ground and there were snails everywhere.   The snails come out at night.  You can tell because they leave little trails all over the sidewalk and patio.  I couldn't poison them because it ruins the vegetables, so I jumped on the web and found out that you can kill them with a container of beer.  They crawl into the beer, get drunk, and die.  Since I've never had a beer it's probably the same thin

MY THEORY OF EVERYTHING      One of my favorite authors and speakers is a man named Michio Kaku.  He is an astrophysicist that often speaks on a unifying theory of physics commonly referred to as The Theory of Everything.   While advanced theories of physics are far beyond me he is able to describe complex concepts of physics in terms that I can understand.    While learning about physics is enjoyable for me,  I understand that I will never be able to contribute to this body of knowledge.   While thinking about this the other day it dawned on me that I have my own unifying theory of life.  My theory doesn’t simplify the competing theories in advanced theoretical physics,  but it does simplify being a Dad. My unifying theory of life is simply “7”. HEY DAD?            Let’s start from the beginning.  When my two children were young they did with most children do and that is to ask a million questions.   For the first few years of their lives I dutifully answered every question as

HELPING GRANNY WITH HER COMPUTER       An odd thing happened this week.  My wife was visiting my Mother-In-Law (We call her Granny), and they needed me to login and check her machine for computer viruses.   As part of my regular job I log into hundreds of systems a month using LogMeIn Rescue.  The Rescue tool generates a random 6 digit number that the customer on the other end uses so I can login and take control of their computer.  RANDOM NUMBER FOR LOGMEIN RESCUE    As I generated the random code so I could log into Granny’s computer you can imagine my joy and amazement when the code came back as 666-911.  The number 666 is commonly associated in religion as the mark of the beast, or the devil’s number, and 911 has taken on a life of it’s own the past 15 years. It’s the end of the world, and it’s an emergency. FUN WITH GRANNY      In order to fully understand my joy with the code 666-911, you need to understand a little more about my relationship with my Mother-In-Law.

One day years ago we received a phone call from a friend who was stranded with his wife on the freeway.  His car had just sputtered and died.   We weren’t very far away so we went to assist him.   We’ll call him Larry.  (That’s not his real name)  We hopped in the car and found them stopped in the emergency lane with the hood up.   I jumped out to go “help” him.    Someone once described a similar incident where he jumped out, lifted the hood, and that ended the extent of his knowledge about cars.  I’m a little bit worse.  I’m lucky if I can find the hood release latch. Larry and I stared at the engine for a while.  I asked him if he ran out of gas – he said no.   I asked him when he had had the car serviced last.  Larry said he had owned the car for years and it had never needed service.   I asked about oil changes and he said “You’re supposed to change the oil?”  We checked the oil, and it had some, but it obviously needed an oil change.  Then we checked the only other think I ca

WHEN RECRUITER'S CHEAT - TWO AGENTS CUNNING PLAN       DRAPER UT 10/19/2017  - If you want to chat on the phone all day with a buddy and get credit for doing your job I found a couple of guys that can hook you up.  They worked for a staffing and recruiting office where they were required to spend a certain amount of time on the telephone each day.  Apparently the joy of self-esteem and hard work was lost on these two.  They figured out that they could take turns calling each other and they both would get credit at the end of the day for the phone usage. The boss would walk by and see them both busily talking on the telephone.  While their daily call stats appeared normal, their sales numbers were dropping off.         Smelling a rat the boss called me one day and asked me to investigate.  We ran a Frequently Called Number report for both individuals and discovered their cunning plan.  My Other Favorite Cunning Plan from Baldrick (YouTube - Black Adder The Third TV Series) If

HOW TO CATCH A COP       DRAPER UT 10/18/2017 - A Salt Lake Police Officer is facing charges for allegedly making a false 911 call to report a burglary at his estranged wife's home.  Apparently, police arrived at her home and didn't find anything amiss.  When they tracked down the phone number that had made the 911 call, they found a match to the phone number of a Salt Lake Police Lieutenant.  The officer may be charged with multiple misdemeanor counts including filing a false police report and could face six months in jail. Salt Lake Police Officer Accused of Making False 911 Call (Salt Lake Tribune 10/17/2017)      This report comes on the heels of an officer being fired from the same department for roughing up a nurse at the University Hospital.  The whole incident was captured on the officer's body cam, and when the footage was released to the public it went viral and caused the officer to go into hiding because of the threats he received. Utah Hospital to