UK & Ireland DrupalCamps 2012

UK & Ireland DrupalCamps 2012

Sunday, Jan 27, 2013
I thought that a retrospective at DrupalCamps (not sure whether those words should be joined or not?) over 2012 would be an interesting thing to look at. Both to see the enthusiasm and passion that is behind the Drupal community in the UK & Ireland but also to contrast with other development and tech conferences. My initial inspiration was receiving a mailshot from an unnamed conference offering conference tickets at the early bird price of £999. ...

Read more
Tuning MySql using mysqltuner.pl

Tuning MySql using mysqltuner.pl

Wednesday, Dec 5, 2012
There are lots of details online about how to create and edit web pages/sites and how to make things look pretty, however, there is a lot less about how to get things working nicely on servers be them development or live servers. Of course, hosting websites is maybe not something for everyone and certainly at Will Hall Online, my usual response may well be to get a server to run your website but if you are running a small website, with limited resource requirements, shared hosting can do a fantastic job. ...

Read more
Desktop Application Style CSS Buttons

Desktop Application Style CSS Buttons

Thursday, Nov 29, 2012
Getting the right amount of visual attractiveness and common interface into a site, so as to make it easy for a user, can be a difficult path to tread. On the one hand, everyone expects that their site should reflect their brand, with visuals, graphics, fonts, image and user interface all being custom to them, however, making web applications that users find easy to se normally means compromising on some parts to make the site navigation easily recognisable. ...

Read more
Quota alerts for email users

Quota alerts for email users

Thursday, Nov 8, 2012
Recently I have been doing quite a few more system administrator tasks around different office. I wrote this bash script (I realise it is probably not perfect to bash officianados, however, it does solve that problem). I have attached the completed file below if you want to download it. Bash Code #!/bin/bash # get all users whose uid is greater than 1000 and less than 60000 for user in `awk -F':' '{if ($3 > 1000 && $3 < 60000) print $1}' /etc/passwd` do # create array as output from quota command array=( $(quota -v $user)) # retrieve amount of space user is using block=${array[17]} #retrieve quota that user is allowed quota=${array[18]} # result = quota - amount used result=$(($quota-$block)) # if result is less than 20000 then do something. ...

Read more
Drupal Commerce Display Products in a View

Drupal Commerce Display Products in a View

Monday, Oct 1, 2012
Recently I have been working with Drupal Commerce quite a bit, however, it can be difficult to get your views to display as required, especially as there is no way to specifically select the product entity inside views. So here are a few tips for getting your products to display in useful views. Drupal Commerce product reference relationships OK, so you want to display the products referenced (images prices etc) rather than the node that is linked to them. ...

Read more
Rules for Fools: Presentation and DrupalCambs

Rules for Fools: Presentation and DrupalCambs

Thursday, Sep 27, 2012
Rules is a module to do causation in Drupal.

Read more
Will Hall Online working with Integro Languages in Alumni Magazine

Will Hall Online working with Integro Languages in Alumni Magazine

Wednesday, Sep 12, 2012
Will Hall Online has featured in the Anglia Ruskin University Alumni magazine for our work with Integro Languages. We are building a CRM system using Drupal to enable more efficient and scalable management of their translation and interpretation business. We are proud to be working with Integro Languages especially because it maintains links with our previous university. I had a fabulous time, both academically and socially, whilst at university in Cambridge and seeing the progress of others who you shared accomodation, lectures and student bars with is a great validation of education. ...

Read more
Create An Output File From A SQL Query

Create An Output File From A SQL Query

Monday, Sep 10, 2012
Sometimes, keeping files as hard copy, or just being able to move things in and around using csv files or such like can be great. However, doing so when you don’t have access to a mysql client (like phpmyadmin) can be a bit tricky. Hopefully this script can help you out. Of course you can change things inside it to make a whole wealth of different files with different data inside it. ...

Read more
Updating embedded content from the database

Updating embedded content from the database

Tuesday, Aug 21, 2012
This is part 2 (or a re-visit) of a previous blog post (Drupal Post Migration Data Cleanup) on updating content after moving it to another domain . If you have your data inside a multisite, you probably have some embedded some images/files into node bodies (or such like) and want an easy way to replace all of the instances. OK great. Using the REPLACE function in MySql you can easily replace instances where the url for the files is wrong. ...

Read more
Drupal Views: 'An AJAX HTTP request terminated abnormally'

Drupal Views: 'An AJAX HTTP request terminated abnormally'

Tuesday, Aug 14, 2012
How to resolve “An AJAX HTTP request terminated abnormally” error on Drupal? As a regular Drupaller I come across quite a few errors now and again. Fortunately (although I get this one quite a bit in views) I do know what I am doing wrong. It is all down to the ````$base_urlthat you have set insettings.php. If you have set it (uncommented the # from http://www.example.com) and you attempt to use it from a non authenticated domain you will get this error. ...

Read more