larryaronson.com

Articles

Larry Aronson on Webcertain.tv

At MarketingProfs B2B Forum in Boston last October, I was interviewed by Gemma Houghton for Webcertain.tv.

our 11 minute conversion, “Capitalising On New Technologies”, can be seen here: http://webcertain.tv/vod/capitalising-on-new-technologies/13525 .

Power of Music Debut

Power-of-Music-screenshotI am proud to announce that The Power of Music, a project I’ve been working on since June, has finally launched.

The Power of Music is an eight-part, multimedia, professional development course for music educators. The video series and website provide an introduction to El Sistema, the pioneering approach to music education and illuminate the ways it’s being adapted for teaching music in the U.S.

The website was developed for WNET/Thirteen public television with support from the Annenberg foundation. It features over 45 videos and 3 interactive applications. The website’s graphic design was done by Michael Pinto of vm.com with additional graphics by Gwen Singley.

•••

Startup Secrets

Startup SecretsHow to pick a winning startup to work for

I was at the NY Tech Meetup last Tuesday evening. If you’re not familiar with it, the NY Tech Meetup is the largest monthly meetup anywhere.

For the September meeting, they usually pull out all the stops. True to form, it was awesome. Our mayor, Bill de Blasio, dropped by to make a Tech Sector booster speech (see approximate rendering at right).

The NY Tech Meetup is a demo-or-die event where 10 companies get 10 minutes each to show their stuff. There’s no judging. But let’s face it – attendees are picking winners and losers.

During the short Q&A sessions between demos one question is taboo: What’s your business plan?

•••

GoDaddy Update Question

A client friend recently wrote:

I got an email from go daddy and spoke to an agent about updating [the website].

I didn’t understand much of what he was explaining but he said it was not that hard to do. He said I need to back up and move the content over to the new platform. Something called a linix C panal web hosting.

I answered:

GoDaddy is trying to get you to move [the website] into their new-ish account management structure in order to make it easier to sell you additional hosting products and services. This is separate from your domain name registrations with GoDaddy which won’t have to be renewed for another couple of years.

  • You DO have to renew your Web hosting agreement for [the website] by Sept. 8.
  • You don’t have to change the hosting plan.
  • It would be a good idea to backup [the website] in any case.

Your current hosting plan is called, “Economy Classic Hosting Linux” and GoDaddy wants to move/upgrade you to “Economy Linux Hosting with cPanel”.  In anticipation, they’ve already setup the new account with a dummy website and a separate username/password. The new plan would cost you $6.99/mo whereas your current plan is $5.99/mo.

Linux is the preferred operating system for Web servers. It’s very similar to MacOS – like two sisters who went to different schools and dress differently. cPanel is software for managing an account on a Linux server. Like the Systems Preferences application on a Mac, it has a number of panels for changing your settings and adding/removing features.

If you have no interest in adding new features to [the website] – i.e: email accounts, e-commerce packages, premium support – don’t upgrade, just renew the current plan. I can help you with that.

Don’t let GoDaddy persuade you that [the website] needs more than “economy” level resources. Although it is a gallery website, all of the images are optimized for quick loading and minimal bandwidth. The web pages are simple HTML, requiring no extra resources on the server for the amount of traffic you anticipate.

About WordPress Themes

What to Choose, How to Choose.

There’s a never ending discussion about WordPress themes in forums I visit and meetups I attend. Paid vs. free; custom clones vs. child-parent themes; large frameworks like Genesis vs. stand-alone themes like Twenty Eleven. Here are my thoughts:

•••

Happy Birthday WordPress

WordPress is 9 years old today and has announced the availability of the first release candidate (RC1) of the next version, 3.4, which I’ve just installed on my local MAMP stack.

So far, there’s no sign of a new “TwentyTwelve” theme. However, there is a new theme previewer/activator that allows an administrator to set a number of theme options and see how they look before saving the options and activating the theme. It’s really nifty. I’ll have more on the new version after the weekend.

But, I also wanted to share my excitement on attending a wonderful event last Thursday and getting to meet Matt Mullenweg, the creator of WordPress and CEO of Automattic. The event was the first in a series of monthly “fireside chats” organized by Pandodaily.com. Matt was interviewed by Sarah Lacy, the founder and editor-in-chief of PandoDaily. It was a long, free-wheeling and thoroughly enjoyable interview and Q&A. My thanks to Howard Greenstein for  getting me in to the event.

Happy Memorial Day!
Larry Aronson

 

Where’s My Query?

Working With WordPress Hooks

When you’re dealing with custom post types you eventually come to the question of what should show up on an archive or search results page (SRP). Say the custom post types are created by a plugin or are built into a special-purpose theme like property listing posts in a real estate theme. How do you know whether or not they’ll show up on an SRP?

The answer is found in the question.
Specifically, the SQL select statement – the request that WordPress sends to the blog’s database. Unfortunately, that statement isn’t readily available to the code in the theme’s template files. The main database query for a WordPress page happens before any of the code in the theme folder is run.

We need to use a WordPress hook to capture the SQL statement before it’s sent to the database. Then we can display it later anywhere we want to; like at the bottom of a Search Results Page. (OK, I’ve read enough; just give me the code.)

The WordPress hook to use is called, posts_request. WordPress passes the main SQL select statement to any filter function registered at that hook. That function can modify the query but, for now, we can just store a copy of it in a global variable. This hack requires editing your theme’s functions file, so make sure you take a backup copy first.

Add the following code to the theme’s functions.php file.

function my_posts_request_filter( $input ) {
     global $my_sql_statement;
     $my_sql_statement = $input;
     return $input;
 }

You can rename the variables and the function itself, if you want; just be consistent when you use the global variable later in your template files.

The function has to be registered to run at the post_request hook. Add the following line to the functions.php file. It can go either before or after the function definition you just entered.

add_filter( 'posts_request', 'my_posts_request_filter', 9999 );

The first argument of the add_filter function is the name of the hook and the second is the name of your function. The third argument is the priority. This we set to a large value because we want our function to run after all other functions registered at that same hook, in case any of them modify the SQL statement.

Save  functions.php and load a page from the site just to make sure you’ve not made any stupid syntax errors. Your site should be unchanged by the new filter function; all it’s doing is saving one more global variable in the WordPress sea of data objects available to the theme.

Now we do the same to instruct WordPress to display the SQL statement at the bottom of a SRP page. Add the following function to the functions.php file:

function print_my_sql_statement() { 
     global $my_sql_statement; 
     if (is_search()) print_r($my_sql_statement); 
}

The first line  makes the global variable, $my_sql_statement available to the function. The second prints the value of the global on the condition that the current page is the result of a search.

To get this code to execute at the end of a page, you add it to the wp_footer hook:

add_action( 'wp_footer', 'print_my_sql_statement', 9999 );

I found this technique very helpful in learning how the WordPress functions, wp_query() and get_posts(), process their arguments, which can get rather complex when trying to include/exclude posts based on the values of custom fields. Understanding that process made it possible to use another WordPress hook, pre_get_posts, to exclude some custom post types from site searches based on their custom field settings. I hope you find this helpful as well.

Happy Hacking,
Larry Aronson

 

Photo Credit: http://www.flickr.com/photos/widnr/6544914763/

The word from WordPress was that version 3.3 would arrive sometime this week. Well, It’s here and it’s a major release. Whereas version 3.2 was mostly a bug fix and stability release, version 3.3 introduces new tools for all users from admins to authors and subscribers.

I’ve been working with the beta and release candidates here on this blog and the improvement that has me most excited is the unified drag-n-drop media loader. In version 3.3, the four buttons for image, video, audio and media are gone;  there’s only one Upload/Insert media tool.


Post editor tool bar with unified media tool

 

Clicking the Upload/Insert button pops up the new loader which defines a space for dragging and droppin one or more files. You can see this in the following screenshot showing me uploading the following screenshot into this post following this sentence.

 

 

The uploader then smartly figures out what type each file is and displays them in the familiar show/hide popup panel. But, it keeps the drag-n-drop window available for more quick uploads into the gallery. Editors will appreciate this thoughtful touch.

The second new feature I like is the Welcome to WordPress 3.x dashboard page that you’re returned to after automatically upgrading to a new version. It describes the new features. It’s the version’s README file located in your blog at /wp-admin/about.php. It’s very friendly.

 

It part of a package of new features that make the dashboard a more friendly place for the millions of non-technical, website owner/operators who are using WordPress as personal publishing platforms (like many of my clients.) In the same manner, version 3.3 pops up a tip window the first time you try a dashboard feature or visit an admin page.  And, throughout the dashboard, there are improvements and added touches that’ll make it more application-like. According to the about page, these are:

  • Combined toolbar and admin bar — They’ve finally gotten it right and it can be customized by theme developers
  • Fly-out dashboard menus — No more accordions. The sub-menu extend out horizontally
  • Screen design fixes — To take into account tablets and other non-pc devices and screens
  • Better  help information — A frame open at the top of the page with tabbed sections and related links

For theme developers, WordPress version 3.3 adds new APIs for the editor and dashboard admin screens supposedly making it easier to customize the back end for special themes and applications. It also include the complete jQuery UI stack and makes good use of it. This more or less standardizes WordPress’ JavaScript framework. It’s a good move, in my opinion. Other JavaScript frameworks such as MooTools, Prototype and Scriptaculous may have richer behaviors to attach to page elements, but they are also prone to causing plugin conflicts.

Anyway, Based on my first impressions and a few hours spent with it, I con recommend updating your WordPress to version 3.3 soon, especially if you regularly write posts with images and other media attachments. As always, back up your WordPress files and database before you upgrade your website. If you’re using non-standard plugins or customizations, ask your web developer if they are compatible with the new version. And, don’t forget that you can aways get answers from the WordPress Support Forums.

Happy Blogging!
Larry Aronson