How do I overwrite SQL generated by a View?
There are several reasons to overwrite an SQL query generated by a view whether it’s to improve performance or join to tables not available to the view. After setting up the view, create a module with a function using hook_views_pre_execute. function [module name]_views_pre_execute(&$view) { if($view->name==”[view name]”) { $sql = “[the new query […]
How to add your personal private/protected Twitter account to Drupal
(Note: In this post I use the terms private and protected interchangeably.) There are times you may want to have your protected Tweets available on your site. Perhaps protected Tweets are available to your members but not necessarily the world at large. Non-private accounts are easy enough to pull: These feeds are easily accesible using […]
Undeliverable Message and 451 Greylisted
Overview/Problem This article explains how to fix the 451 Greylisted, System Administrator message that is received when you send an email to someone that has the same domain name. Example: If you had the email person1@domain.com and were trying to email person2@domain.com, you will get a message from the system administrator with a message regarding […]
Configure Veeam 6.0 Replication Job for VMware
Summary/Purpose This article is meant to give an overview of Veeam 6.0 on VMware, give other users an idea of our experiences, provide some general recommendations, and to provide a recommendation to adjust the Backup Proxy Transport setting to fix a processing speed issue that is present with Veeam 6.0 with version 6.0.0.153 and hotfix […]
Three Little Phrases
There are a few phrases I find cropping up regularly in the office that I think are useful and I’d like to share with you: “Great answers breed even better questions” This is the power of iterative analytics; the results of the analytical process provokes more refined, more targeted questions from the users. I *love* this […]
Adding Social Media Sharing to Your Drupal Content
The title of this post should be “Adding Social Media Sharing to Your Content” as the service we’re going to look at is not only for Drupal, but Blogger, WordPress, Tumblr, Joomla, TypePad, Posterous, Flash, the iOS or Android SDKs, an email newsletter or just a static site. AddThis is “the world’s largest sharing and […]
5 Developer Tips for Making Drupal Administration Easier for Your End User
A majority of the work for a Drupal site goes into theming the public facing side. Website usability has been drilled into our heads for years, so we tend to be very mindful of how navigation works, what colors are used, and how graphics are placed. One thing that tends to get overlooked, however, is […]
Episode 1: Introduction to Drupal – Install MAMP/WAMP, Drupal 7, and Setup a Sub-theme
This is the first episode of several to come over the following weeks. I thought this would be a good chance to break that barrier of entry for many of you wanting to get your hands dirty with Drupal. In this episode we setup a testing environment which will allow you install Drupal on your […]
Non-Traditional Data Sources in Tableau
Tableau gives us a lot of ways to connect to data. We can easily connect to Excel, Access, SQL Server, Oracle … the list goes on and on. One place that’s not in that list is email. We get a lot of data that’s been copied from some data source somewhere and pasted into email. […]
Creating a custom form page in Drupal 6 with a module
Webforms are great when you want to make a quick and useful form in Drupal. However, sometimes we may want a little more control over that form or need to run some custom PHP code when the form is submitted. Keep in mind, we can always use hook_form_alter() to modify Webforms and mold them to our […]