I’ve been playing around the Amazon’s Echo Dot for just under a week now and was curious about its portability. Obviously, the hardware just needs a place to plug in and a Wi-Fi network to access but I was really wondering if I could run its data through my phone’s 4G hotspot. Public networks are fine […]
My First 24 Hours With Alexa
I couldn’t resist any longer and decided to welcome Amazon’s Alexa into my home. I was a little hesitant at first about letting Amazon put a microphone in my house but my curiosity won out. I live alone anyway and the device can always be unplugged if necessary. At worst, it might get me to stop talking to […]
Read Time:
2 Min
A Quick Guide To Keeping Your Flash Drive Data Safe
When I started using computers about 30 years ago, the floppy disk was the standard of personal data storage. I actually started out using the 5.25″ disk so the 3.5″ disk with it’s hard case and a little bit more space was a welcome improvement at the time. We’ve come a long way in the […]
Read Time:
2 Min
Calculated Fields in CiviCRM
One of CiviCRM’s strengths is the ability to add custom fields to hold specific information about your contacts. One thing it doesn’t offer (yet) is a calculated field type that will present the results of calculations of other fields. While calculated fields are generally discouraged in relational database design, they are sometimes necessary within a […]
Read Time:
1 Min
Importing Case Data into CiviCase
Migrating to CiviCase On a recent project, I setup CiviCRM and CiviCase to enable a local organization to better manage its client database. The old database had been developed in Borland Paradox and was quickly becoming unusable. As a free and open source solution, CiviCRM turned out to be just the solution needed to accommodate this […]
Read Time:
2 Min
MySQL User Defined Function Example: Data Cleanup
(Updated June 9, 2016) The Challenge One of my current projects involves migrating a large amount of data away from an old custom Borland Paradox application into a new CiviCRM system. As with too many quickly-constructed apps, this old Paradox database wasn’t especially well designed and, among other the other challenges in salvaging the data, there were […]
Read Time:
1 Min
A Couple of Notes on Cloud Computing
Years ago, when I was making do with the limited computer equipment that I could afford, I never dreamed that I would one day be able to login to a website, plug in a few specs about the machine I wanted and then, a few minutes later, log into that machine remotely and run whatever […]
Read Time:
1 Min
Coding Basics – Deceptively Simple Programming
In my last post on coding basics, I talked about turning an algorithm into code and used Euclid’s Algorithm as an example of programming a sequence of steps. There’s an even simpler type of algorithm that I want to look at this time. A formula, such as the one for converting Fahrenheit to Celsius, is also […]
Read Time:
2 Min
From Algorithm to Code
In previous articles, I’ve talked about the importance of finding the right algorithm, or series of steps to follow, when coding a solution. Efficiency in terms of the amount of memory used and the amount of time taken by the operation are key factors for the program. Sometimes an appropriate algorithm is already available and in […]
Read Time:
1 Min
Installing MySQL on Mac OS X El Capitan
A few months ago, I wrote about how to install MySQL on Windows with IIS. Now I want to show you how to create an AMP web programming stack (Apache, MySQL & PHP) on Mac OS X. As with Windows, you could just go with a ready-made development environment like MAMP but, if you’re going to be […]
Read Time:
2 Min