How to Merge Multiple CSVs into a Single File Here's an ultra-easy solution to the challenge of merging multiple CSV files into a single file. I'm on a Mac OSX and used Terminal or iTerm Move all the CSV files into the same folder Open Terminal or iTerm or your favourite command-line app cd path-to-the-csv-folder  cat *.csv > ../result.csv  This combines all your CSVs into result.csv In my case, I needed to combine around 140 CSVs and this method took seconds. The merged file will have multiple records of the headers from each of your CSVs. If you need to clean this up, open result.csv with your favourite text editor and use search and replace.  

Cross-browser testing on Mac OSX: Emulate Internet Explorer, Android and Window phones Here's a quick, free, and relatively easy way to test IE browsers and emulate Android and Windows phones on Mac OSX - sign up for a free Microsoft account - start using the free Microsoft Edge Remote Tools

How to Configure MX records for a subdomain on ProtonMail If you are configuring a subdomain to use ProtonMail, it works well though the ProtonMail instructions aren't clear.  Here's what you need to do.

Sublime shortcut to wrap selected text in a tag This is a super-useful Sublime shortcut that's worth tattooing on your arm.  Ctr-Shift-W (Mac OSX)  or Alt-Shift-W (Windows)  

Optimising images and reducing file sizes It's sometimes difficult to create fast loading web pages, while at the same time including large and full-screen images. Here's a super easy way to reduce your image sizes by 50% ... plus it's lossless

Joomla error 500 - Unable to load renderer class If you get a  Joomla error 500 - Unable to load renderer class, the first thing you want to check your jdoc code in your template.  

How to open winmail.dat files on Mac OSX If you are on Mac OSX, you may occasionally receive winmail.dat email attachments from Windows users. Here's a surprisingly easy way to open them. 

How to fix a missing Admin Toolbar at the top of a WordPress page Working on an a client's WordPress site recently, and one of the tasks was to fix the missing Admin Toolbar.   The client had customised the theme and we could confirm the issue was theme related because if we temporarily changed the theme the missing admin toolbar would reappear  If this happens to you, the solution is easy enough:

How to configure MailGun and Google Business Apps in CiviCRM When configuring SMTP mail in CiiviCRM and you're using a secure port like 465, you need to prepend your hostname with ssl://, eg ssl://smtp.mailgun.org or ssl://smtp.gmail.com  

How to prevent duplicate URLs with sh404SEF If you use sh404SEF and can't solve problems of duplicate URLs, start by going to Components > sh404SEF > SEF URLs, then under the duplicates header compare the Non-SEF urls. If you see different values for the Itemid parameter, then that's the source of your problem.

After upgrading from Joomla 3.5 to Joomla 3.6.0 I suddenly got a JLIB_APPLICATION_ERROR_COMPONENT_NOT_LOADING error on the back end of the site.   If started by clearing the site cache from System > Clear Cache but that didn't help I'm using a CDN so I cleared that cache but still no joy I double checked error logs but nothing there of any significance I confirmed that disk space wasn't an issue I also checked Extensions > Manage > Database to be sure everything was good there The above checklist usually solves this error but not this time.

How to customise a Joomla template based on article ID Working on a custom Joomla template, I needed to change the page layout for a specific article and creating a new template for this one article didn't seem to be the right tool for the job. The solution was suprisingly easy.