This article is about preserving SEO during a Drupal to WordPress migration. It’s not about which platform is better. A web search will bring up many articles about the relative SEO merits of Drupal versus WordPress. I’ve found the best summary on that topic in a forum post by Drupal.org user and developer, John Birchall:… [more]
Yojimbo to Tomboy Notes migration tool
I’m a huge fan of Bare Bones Software’s Yojimbo, an extremely useful tool for keeping information organised. It has been one of my most important applications since around 2008. I rely on Yojimbo as my ‘Anything Bucket‘ to save scraps of information, from code snippets and troubleshooting notes to project logs and research sources. A… [more]
How to avoid manually typing your password into OS X’s password dialog box
When mounting an encrypted disk in OS X for the first time, you’ll be presented with a dialog box that doesn’t allow you to paste in the password. This can be troublesome, especially if you’ve used a long, high-quality random password. Here’s how to get around having to manually enter your password into OS X’s… [more]
How To Configure SSH Key-Based Authentication on FreeBSD for Mac OS X and Panic’s Transmit FTP Client
This is a guide for setting up an Apple Mac OS X workstation with SSH key-based authentication to a remote FreeBSD server. I won’t go into any detail about these protocols or try to make a case for using them. If you’re reading this, you probably already have a basic grounding on SSH, SFTP and… [more]
Drupal to WordPress Image Migration
If you’re looking for a script to migrate images from Drupal to WordPress, check out Brendan Carr’s Drupal 6 to WordPress Image Migration plugin. Brendan used my Drupal to WordPress Migration Tool and developed his plugin as a companion. He also confirmed that my web-based script is compatible with WordPress 4. If you need to… [more]
Post-migration steps: what to do after a Drupal to WordPress migration project
From time-to-time I get clients who ask me to only export the content to a WordPress database, after which they’ll complete the remaining setup themselves. If this applies to your project, you can use these migration notes to help get your new WordPress site running properly. Import the database dump file Please see these notes… [more]
Importing your WordPress dump file after a Drupal to WordPress migration
If you hired me to run a content export only, you’ll be responsible for setting up WordPress on your own server. Here are some notes to help you with importing the migrated WordPress database. Import the database dump file I will deliver either a MySQL database dump file or login credentials to the phpMyAdmin control… [more]
Handling Drupal terms during a Drupal to WordPress migration
When migrating Drupal terms into WordPress, it’s important to understand exactly what terms are and how the two systems handle categorising information. A primer on Drupal taxonomies One of Drupal’s most powerful features is its ability to organise content with taxonomies. Unfortunately, the taxonomy system is also notorious as one of the trickiest things about… [more]
Drupal to WordPress migration activity diagram
This UML activity diagram accompanies my post, Drupal to WordPress migration explained. Diagram created with draw.io. Migration steps listing Prepare tables: This is where we reset the development database tables to a known state, ready for another migration pass. Delete unwanted vocabularies Delete unwanted terms Merge terms? Yes: go to step a; No: go to… [more]
Drupal to WordPress migration: user table mapping
This is part four of a series of posts documenting the table mappings for a site migration from Drupal 6 to WordPress 3. For more information, please see the first article in the series. Table mapping for WordPress users This maps Drupal user export to WordPress. Drupal 6.x WordPress 3.x Notes users wp_posts uid ID… [more]
Drupal to WordPress migration: comments table mapping
This is part three of a series of posts documenting the table mappings for a site migration from Drupal 6 to WordPress 3. For more information, please see the first article in the series. Table mapping for WordPress comments Drupal 6.x WordPress 3.x Notes comments wp_posts cid comment_ID nid comment_post_ID timestamp comment_date Converted from UNIX… [more]
Drupal to WordPress migration: terms table mapping
This is part two of a series of posts documenting the table mappings for a site migration from Drupal 6 to WordPress 3. For more information, please see the first article in the series. Table mapping for WordPress terms This table mapping exports the Drupal terms into WordPress. Drupal 6.x WordPress 3.x Notes term_data wp_terms… [more]
Drupal to WordPress migration: posts table mapping
Following on from Drupal to WordPress migration explained, I will create a series of posts documenting the table mappings for a site migration from Drupal 6.x to WordPress 3.x. To read the mapping, you look up the Drupal table on the left listing the fields we use for a migration. Directly to its right is… [more]
Drupal to WordPress migration SQL queries explained
In this post I will give a step-by-step explanation of my Drupal to WordPress migration SQL queries. For general information about migrating from Drupal to WordPress, please see instead my Drupal to WordPress Migration Guide. Since I offer site migration as a paid service, readers might be wondering why I’m giving away some of my… [more]
Emergency Plan for iPhone to improve preparedness in the Philippines
FOR IMMEDIATE RELEASE London, UK: Another Cup of Coffee Limited, a London-based web development company, aims to improve emergency preparedness in the Philippines with the launch of Emergency Plan for iPhone. The app is a simple tool designed to store an emergency plan for an earthquake, flood, typhoon or similar event. Valuable for families who… [more]
Safeguard your email address by registering a domain
A primary email address tied to your email provider could set you up for a great deal of inconvenience if they shut down. Registering your own domain helps control your email regardless of which company you’re currently using. On Thursday, 8th August 2013, a secure email service provider called Lavabit suddenly suspended operations. Its founder,… [more]
Drupal to WordPress utility now public
I’m releasing my in-house tool for Drupal to WordPress migration. You can go directly to the download page for the latest version of the utility. If you’d rather let someone else do the work, you can find more information at my dedicated migration service page. When I started Another Cup of Coffee, we specialized in… [more]
Creating emergency-resilient electronic file backups
Most computer users know about the importance of backups as it’s all too common to have years worth of information and memories wiped out by a computer crash. Generally though, the average backup strategy involves copying files into some sort of device in your home or office. This may be of little use if the… [more]
Protecting your password
A client’s Yahoo email account was hijacked recently. She found out after an email was sent out in her name, to her entire contact list, asking to borrow several thousand pounds. This was such an obvious scam that no-one fell for it. Fortunately, other than some embarrassment and inconvenience, there were no serious consequences. It… [more]