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…
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…
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…
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…
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…
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…
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…
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…
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…
Splitting a Database in Microsoft Access
Microsoft Access is unique among all of the Microsoft Office applications in that it can be used to create entire applications that contain large storehouses of data, versatile data entry forms and sophisticated reports to present the data in a variety of ways. It also goes beyond other applications such as Microsoft Excel in that a…