Category “Blog”

Advanced Fastmail rules: Filter all newsletters and filter emails by contact groups

data-sorting-lego

I love Fastmail. They are a super email hosting provider that I’ve used for years now. They have been rock solid and constantly improving. This week I learned how to do something awesome with their email Rules.

Here’s what I wanted to do:

  1. Automatically filter all newsletters and stuff I subscribed to into a Subscriptions folder.
  2. Make exceptions for my favorite newsletters and keep them in the Inbox.

Here’s how to do it:

Subscriptions Rule : Filter all newsletters

My first attempt was to create a filter for each email provider – Mailchimp, Campaign Monitor, InfusionSoft, etc. But there are too many email marketing services and my rules list kept growing and growing.

Then a lightbulb moment: All email marketing service providers include a List-Unsubscribe email header.

list-unsubscribe.png

List-Unsubscribe email header

A quick support request to the awesome Fastmail team, and they told me how I could filter emails based on this header.

First, make sure you have already created a folder for Subscriptions (or Newsletters, if you prefer). Then go to Settings → Rules → Advanced. Then find the File into Folders tab. Create an advanced rule with the following settings:

Message with: Advanced
The text: exists ["List-Unsubscribe"]
File into folder: Subscriptions
Order: 1

Now any emails sent from a email marketing service will be sorted into the Subscriptions folder. Time to create some exceptions for my favorite newsletters.

Exceptions Rule: Filter by Address Book group

Now go to your Address Book and create a new group. I call mine “Must Reads”. Add your favorite newsletter senders email address to this group.

must-reads

Next, create another rule (Settings → Rules → Advanced).

Message with: Advanced
The text: header :contains "X-Spam-known-sender" "Must Reads"
File into folder: Inbox
Order: 0

Important! You must set the order of this exception rule to a lower value than the first rule. In my case, the order for my exception rule is 0 while the subscriptions rule is 1. This way, Fastmail will process the exception rule first and bypass the subscriptions rule.

Here’s what my rules look like:

final-rules

Click for larger version

Yep, there’s another rule in there to filter emails that are just for Promotions e.g. senders who often email about sales that I want to take advantage of.

Hooray! Your inbox is now saner, and you won’t miss anything from the newsletters you really love.

Bonus tip: Unsubscribe from half of all your subscriptions. Seriously.

Why you should avoid themes that come bundled with plugins – a $15 value!

kora

Bundled plugins usually don’t include automatic updates. Unfortunately most theme buyers only find out after they get hacked.

 

Who loves a $60 theme with free page builder and slider more than the site owner? The web designer. Their single investment gives them hundreds of possible combinations, all without writing a single line of code. Sites are not purpose-built any more. They are adapted from the starting theme design, limited by the web designer’s grasp of the page builder and slider, his creativity (and technical knowledge).

But all those possible combinations, all the features that came along with the theme add up to bloat. And that bloat translates to WooCommerce complaining that templates are out of date. Or slow performance because the site is carrying along a hundred other templates and features it doesn’t need.

So the website owner buys a website from the web designer, not knowing of all these issues. The site is left to grow outdated as it is not kept updated with new versions of the page builder and/or slider plugin. Then the inevitable security vulnerability rears it’s head. Visual Composer and Revolution Slider were both affected fairly recently, the latter indirectly compromising up to 100,000 sites.

The website owner realizes that their site is hacked, leading to panicked messages like the above.

So, don’t buy themes with bundled plugins. If you do, buy licenses for them to keep them updated.

And if you’re a web designer for gods sake take the time to educate your customer you lazy bastard.

See a list of your Loved / Liked songs in Apple Music

Apple Music is awesome! …but quite difficult to figure out ? It took me some digging around to figure out how to find my Loved tracks, but I finally figured it out. Here’s how to do it:

  1. Click the heart button (♥) to Love the song
  2. Click the 3-dot button (…) and then click Add to My Music
  3. Create a Smart Playlist where “Loved” = “is true”
songs-i-loved

Smart playlist to display songs you’ve Loved

That being said… loving / liking a song only tunes the “For Your” section in Apple Music – it doesn’t affect Apple Music Radio. Learn more: How to properly use “Likes” in Apple Music. Something for you to consider as you curate your playlists.

Enjoy!

Fix "Google Calendar invitations cannot be forwarded via email" error messages

There are 2 steps to solving this issue:

1. Add your second, non-Gmail email as an alternate email address – Sign in to your Google Account with another email address

2. Setup Google Calendar to accept invitations from the alternate email address – How to respond to invitations forwarded from your alternate email address

Need a step by step guide with screenshots? Check out this article on TechRepublic – Add alternate email addresses for calendar scheduling

Best related posts plugins to replace nRelate

On 1 December 2014, nRelate announced that it would be switching off its related posts recommendation service. Their Related Posts plugin and service for WordPress was an extremely popular plugin because of its ease of use and many options. So now that they are shutting their doors, many WordPress site owners are looking around for a replacement. Here is what I am recommending to my WordPress tech support customers at ClickWP.

IMPORTANT: Choosing the wrong related posts plugin can severely slow your site down. This is because calculating the related-ness of posts is a resource intensive process. For sites with more than 200 posts, I recommend off-loading the computational work to an external service.

The best plugin to replace nRelate is… it depends.

tl;dr Summary

If you use Jetpack and don’t care about customization, use the Jetpack Related Posts module.

If you don’t want to signup for other accounts & services, Contextual Related Posts is a good option for sites with less than 200 posts. Another to consider is Related Posts for WordPress which claims to be able to handle a lot more posts.

If you don’t mind or need an external service to compute your related posts, Shareaholic and AddThis are the best options. One thing to note is that AddThis settings are controlled outside of WordPress, so you must signup for an AddThis account to use this option.

If you’re a publisher who’s willing to pay to increase your audience engagement with your content, Contextly seems very promising.

Want more options? Read this post by Followistic: The 10 Best Related Posts Plugins for WordPress

My thoughts on each of the above options: Read More »

Welcome Aaron

Aaron’s first selfie.

3.6kg & 50cm long, even bigger than his brother!

Zack's birthday

Zack’s recently gotten into Toy Story, so this year I got him Woody and Buzz Lightyear. I had to buy them from DisneyStore.com and have them shipped all the way, which was a bit of a hassle, but Zack’s reaction was so worth it. And I have fun playing with them too 😉

Webfaction hosting gives you lots of flexibility and power, if you can live without cPanel

webfaction-logo

Updated November 2017

Webfaction is an unpretentious, down-to-earth web host that gives you great performance and value. Cool hipsters types may not host their sites here (they’re on Media Temple) but in my 3+ years using Webfaction I’ve been well and truly impressed. Webfaction has provided the greatest performance and value for any web host I’ve ever used, and I happily recommend them.

Fantastic performance

Shortly after switching one of my customers to Webfaction, they had a post go viral. As a result, they received 24k pageviews over a period of 3 days. Webfaction held up like a champ.

24,000 pageviews in 27 hours - no problems

24,000 pageviews in 27 hours – no problems

There were no hiccups, database errors or even slow pages. Of course, I had W3 Total Cache installed and configured but the credit has to go to the web server. Webfaction can also serve your site from multiple servers with automatic load balancing if you need it.

Just 2 weeks ago, a customer of mine who was on Media Temple complained that her site was struggling and that the WordPress dashboard was taking almost 30 seconds to load on average. I switched her to Webfaction and her site immediately started loading quicker and her performance issues have largely been solved.

Read More »

Useful SQL queries for migrating a WordPress database

First, if at all possible, use the WP Migrate DB Pro or BackupBuddy plugins to migrate your WordPress database. The money spent will save yourself a lot of frustration and hair pulling, and hours if not days of cleanup and massaging of the WordPress database.

But if that’s not possible, welcome to my world for the past week. I’ve had to migrate a WordPress database without my favorite migration tools. After scouring the web for tutorials and tips, I’m compiling them here for easy reference.

Gather Your Tools

First thing you need is to get your hands on the following:

1. Database name, prefix, user and password.

You can find these defined in the wp-config.php file. In the following examples, be sure to swap out the database name wordpress and prefix wp_ with the correct values from your situation.

2. Access to phpMyAdmin so that you can interact with the database.

We’ll be running the commands below through the SQL tab in phpMyAdmin.

Running SQL queries on your database with phpMyAdmin

You could also connect directly to MySQL through the terminal / shell prompt. Good luck if you don’t have phpMyAdmin.

3. Backup, Backup, Backup

Don’t say I didn’t warn you. Export your untouched database and lock it up. If all goes wrong, restore to this backup.

Change the Site URL

The first thing you would want to do is to change the site URL. You can browse the wp_options table for the siteurl and home options values directly, or you can use this SQL command:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE option_name = 'siteurl' OR option_name = 'home';

Next, you’ll want to replace all instances of oldsiteurl.com in your post’s contents and GUID.

UPDATE wp_posts SET post_content = REPLACE (post_content, '//www.oldsiteurl.com', '//www.newsiteurl.com');
UPDATE wp_posts SET guid = REPLACE (guid, '//www.oldsiteurl.com', '//www.newsiteurl.com');

Read More »

Standard Chartered KL Marathon 2013 – already looking forward to 2014

Last Sunday I ran the 10km (Speed) race at the Standard Chartered KL Marathon. It was such a great experience for me and I’m already looking forward to next year.

I got a big kick weaving my way through the pack at the beginning of the race, running alongside thousands of fellow runners in downtown KL, disrupting traffic and running flat out at the finish line.

StanChart KL Marathon 2013

Me completing my 10K at SCKLM2013. This picture cost me SGD30…

The event is the most popular road race in Malaysia and this year saw a record-breaking 33,000+ runners. SCKLM had to be postponed from its original date in June due to the haze situation, but the event last week was top notch. I felt that it was really well-organized and let the runners really enjoy the race. Read More »