Remove unwanted fields from Gravity Forms CSV export options

Ever had a situation where you’ve got Gravity Forms setup and you want to export entries in CSV format – but you don’t want certain fields… well ever, yet they show up in the export list of options?

I’m talking things like “Payment Amount” or “Payment Date” or other things like “Transaction ID” or even “IP” or “Source URL” or similar. Perhaps you just don’t need these at all, and you want to be able to “just export” by hitting “select all”?

In these circumstances, code comes to the rescue!

Read more

How Do You Pronounce “MySQL”?

We sometimes talk on the telephone with various technology companies, and their representatives. Two camps, both alike in dignity The people on the telephone fall into one of two camps: technical and non-technical. Nobody, however, seems to be sure exactly how to pronounce the abbreviation “MySQL”. The people who made and host MySQL have been …

Read more

How to Find & Replace in MySQL

Sometimes, we need to find and replace certain strings or pieces of data in MySQL on the fly, for example if we’ve changed a Top Level domain (TLD) and want to update a bunch of links all in one go. For those times, the following command can be issued: The code from the Gist above …

Read more

How to: Find out Apache version from Command Line (SSH)

Have you logged into your server or VPS via command line (SSH – this is really the best and only way to do this now – Telnet is not going to encrypt your communications… this is bad!) and are now wondering how to quickly discover what version of Apache you are running? Find your Apache …

Read more

Allow HTTPS on Amazon EC2

If you have recently setup an Amazon EC2 instance and would like to configure access to Port 443 (HTTPS:// traffic) on your new instance, there are a few things you should do. First Step – Allow Port 443 in your Security Group Firstly, you need to tell your EC2 instance that it is allowed to …

Read more

AWS EC2 Instance Won’t Stop

If you use a lot – or even just one – EC2 instance on Amazon Web Services (AWS), from time-to-time, you might find that an instance becomes unresponsive, you can’t get in via SSH, and, when in the AWS console, the instance just won’t stop! When this happens, you select “Stop” in the console, and …

Read more

Installing the GD Library

Because I just posted this description in the post I wrote on how to make WordPress Auto-Thumbnails work, I thought I would also post those instructions straight up as a pointer for anyone out there who is looking for the command required to install the GD Library in their LAMP setup, so here it is: …

Read more

Linux & Apache Server – Set Local Time to London, UK, Europe

A quick and simple command you might need from time-to-time if you’re running apache webservers in one or other Linux flavour. We often grab EC2 instances on Amazon, for example, for our clients and, for various reasons, we want the server to know what time it is here in the UK! So here’s the command …

Read more