Replacing Exchange Public Folder Functionality with Google Apps September 6, 2009
Posted by judismith in Email, Exchange, Gmail, Google Apps, Interoperability.Tags: Exchange, Gmail, Google Apps, Public Folders
11 comments
One of the problems with ditching Exchange and moving to Google Apps has been the lack of public folder functionality. Public folders are those folders that your Exchange admin would set up where they could give multiple users the right to view content and other users the rights to add and edit content. They are sort of a cheap intranet; at least that’s how we used them.
We successfully migrated 300+ users to Google Apps finishing late this Spring. Part of that required that we solve the lack of public folders. For those public folders where we would just put documents for access, we helped our users migrate to using Google Sites. With sites, users can easily post information or documents. Some of our users also use shared Google Docs for this purpose.
We still had the issue of having multiple users easily access one email account for customer service or other public facing email addresses. We turned to Email Center Pro for a solution that really improves on the public folder paradigm.
The things we like about Email Center Pro:
- Like public folders, there is a many to many relationship between email boxes and users. In other words, users can be assigned to multiple mailboxes and multiple users can be assigned to the same mailbox.
- The user interface is a very nice dashboard that has
- A drop down list of all the users mailboxes,
- A list of all the other users that are currently logged into that mailbox,
- The ability to save searches,
- Recent activity log,
- Account usage,
- The message inbox, and
- a customizable graph of mailbox activity that is exportable to CSV for further analysis.
- Plus there are about 15 more widgets that are available to add.
- Emails can be assigned for response to ensure that no emails are missed or forgotten and that they only get responded to one time.
- The Email Center Pro inbox can send you an alert when email arrives so you don’t have to keep checking.
- You can create and use templates for common responses, ensuring that communications are consistent and saving time.
- Create notes for other team members
- You can create a link from the email to a case in your case system. In our case we use Salesforce. This works nicely when you need to update the case with information from the email thread.
So, we didn’t solve all the problems with just Google. But that’s the great thing about Software as a Service (SaaS) solutions, they understand that complimentary functionality and seamless integration is the name of the game. All-in-all, with the public folder functionality replaced and improved, the transition to Google Apps went very well. We are very happy with the choice and the many new features that Google and Email Center Pro have added to our email handling.
Put GMail on Your Desktop with GeekTool August 23, 2009
Posted by judismith in GeekTool, Gmail, Google Apps, Macintosh OS X.Tags: GeekTool, Gmail
8 comments
Recently the folks over at Panic announced a cool new way to display critical stats on your desktop – Statoo. Like GeekTool, Statoo can put the weather, date, time, disk space, current song, and so on on your desktop. Unlike GeekTool, they do it all in a few clicks. Even more interesting was the ability to put email on the desktop. I hadn’t yet seen that done with GeekTool.
Intrigued by the email portion, I set out to have GeekTool display the most resent messages from my GMail inbox. This requires a little script fu, but not that much. Here’s what it looks like on my desktop.

The word “EMail is something I add as a header to this GeekTool module. Next, emails are displayed as the subject line first then below and indented slightly, the first few words from the body of the email. In the example above, the first email is my schedule from GCal. Since I’m writing this on a Sunday, I don’t have any events and the body is empty. The second email is some spam that GMail managed to miss. Then there is my reminder from Vitalist.com and so on.
To make this script work, we take advantage of the fact that GMail conveniently provides Atom feeds for any of your labels. You can access your feeds at https://mail.google.com/mail/feed/atom/<label name> where <label name> is the name of the label that you want to access. To access the feed for the inbox, we can take advantage of GMail’s built in “inbox” label. So the URL to access the feed for the inbox is https://mail.google.com/mail/feed/atom/inbox. This also works for Google Apps users. The URL is https://mail.google.com/a/<your company domain>/feed/atom/<label name> where <your company domain> is web domain that you use with Google Apps and as above <label name> is the label that you want to access. So the URL to access the feed for the inbox of a Google Apps user with a domain of somecompany.com is https://mail.google.com/a/somecompany.com/feed/atom/inbox.
OK, on to the script. I built the script with just a few variables for you to change. I’ve listed it below but you can download the complete script here.
#!/bin/sh
# Thanks to Dave Taylor at http://www.askdavetaylor.com for the great tutorial on accessing and parsing RSS feeds with a shell script
echo “EMail” # Puts the word “Email” at the top for a header to the module
# Provide your log in credentials
# NOTE – you MUST replace the @ in your username email with %40 or the script will fail
username=’user%40gmail.com’ # username is your email address with @ replaced by %40. For Google Apps users this will be user%40yourcompany.com
password=’password’ # your password# Set the label that you want use
label=’inbox’ # the GMail label that contains the email you wnat to display#Set the Wdith of the output
width=’45′ # The number of columns wide that you want the output# Required for Google Apps users
domain=’yourcompany.com’ # Your company domain – only needed for Google Apps users# If you are using Google Apps put a # at the beginning of the first url= line and remove it from the second url line.
url=’https://’”$username”‘:’”$password”‘@mail.google.com/mail/feed/atom/’”$label” # GMail users
#url=’https://’”$username”‘:’”$password”‘@mail.google.com/a/’”$domain”‘/feed/atom/’”$label” # Google Apps users – remember to edit your organization’s domain in domain variable above# Do not modify below this line
if [ $# -eq 1 ] ; then
headarg=$(( $1 * 2 )) # $(( )) specifies that you’re using an equation
else
headarg=”-8″ # default is four email messages
ficurl –silent “$url” | grep -E ‘(title>|summary>)’ | \
sed -n ’2,$p’ | \
sed -e ‘s/<title>//’ -e ‘s/<\/title>//’ -e ‘s/<summary>/ /’ \
-e ‘s/<\/summary>//’ | \
head $headarg | fmt -w “$width”
Once you have modified the file with your information, save it to a location with the name gmail.sh. I use a GeekTool folder inside my Documents folder. Then you will have to make the script executable. To do that, assuming you saved the file as above, open the terminal and enter
chmod +x ~/Documents/GeekTool/gmail.sh
While you are still in the Terminal, to see if everything is working, try running the script by entering
sh ~/Documents/GeekTool/gmail.sh
If you’ve done everything right, you should see the subject lines and a summary of the body for first 4 messages from your inbox listed in the terminal.
Once you’ve saved the file and added the execution permissions, we can now go over to GeekTool. Open System Preferences and select the GeekTool module. Then click on the button for a new entry and select Shell as the entry type. The enter the command to run the script file in the command box
sh ~/Documents/GeekTool/gmail.sh
The script is set to take an argument for how many messages you would like to see. It will default to 4 messages, but you can alter that by putting a dash followed by a number at the end of the command. For example if I want to see 10 messages instead of 4 the command would be
sh ~/Documents/GeekTool/gmail.sh -10
You can see the GeekTool set up in the picture below.

GeekTool settings for use with the gmail.sh script
That’s it! adjust the GeekTool settings to your liking or to match your awesome desktop and enjoy. I look forward to seeing GMail on the desktops featured Lifehacker from the Flickr Lifehacker Desktop Show and Tell pool.
Resolve GMail Undefined Issue July 19, 2008
Posted by judismith in Firefox, Gmail.Tags: Better GMail 2, Firefox, Gmail, GMail Conversation Preview, GreaseMonkey
6 comments
Resolve GMail Undefined Issue – Firefox
I’m fickle about browsers. Safari has some very nice features such as the ability to resize text boxes in forms. It also syncs bookmarks to my .Mac Mobile Me account to my other Macs and my iPhone. On the other hand there is much to love about Firefox 3. The biggest thing I like is the ability to have multiple home pages that open when I launch the browser. I know in Safari all I need to do is Command-click the bookmarks folder that contains all of my preferred pages. Still, if I can, I prefer to skip that step. I also like Firefox’s ability to use GreaseMonkey scripts to tweak certain webpages.
GMail Undefined Items

Because of the different features I will switch between browsers, using each one until I get frustrated with the its limitations.
Recently, I’ve been using Firefox and I noticed that my GMail messages would show “undefinedX” where the To: and the From: address as well as a number of other items are supposed to be displayed. I quickly checked in Safari to see if it was a browser specific issue. Sure enough, when I view the messages in Safari, all the information is where it is supposed to be.
Firefox Add Ons
In Firefox, I use a number of add ons to enhance my GMail experience. I use Better GMail 2 by Gina Trapani of LifeHacker.com fame, to make a number of tweaks to GMail. The Redesigned in Better GMail 2 skin is very eye pleasing and almost fools me into thinking that I am using a desktop client. I also use the GreaseMonkey to enable a variety of additional JavaScript tweaks in Firefox. One of these was the ability to preview conversations in GMail by right clicking on the message.
GMail Conversation Preview Script

One of the GreaseMonkey scripts that I use is the GMail Conversation Preview. I have to say that the one thing I really miss in GMail is the ability to see the message in a message pane without having to essentially open up the message. GMail Conversation Preview was a bit of a work-around for this.

A bit of searching on the web revealed this conversation over at Digg where user Kenley pointed out that the issue is caused by the GMail Conversation Preview GreaseMonkey script. By disabling GMail Conversation Preview all the information items return to normal.
To disable a GreaseMonkey Script in Firefox for Mac simply go to the menu bar and click on Tools -> GreaseMonkey -> Manage User Scripts… When the window opens, highlight the GMail Conversation Preview script and uncheck the “Enabled” button that is in the lower left corner of the Manage User Scripts window. Close the window. To see the results, use the refresh button in Firefox to refresh GMail and see the changes.
Google Apps – a Viable Replacement for Exchange? September 28, 2007
Posted by judismith in Exchange, Gmail, Google Apps.Tags: Exchange, Gmail, Google Apps
8 comments
Google Apps is a collection of online services from Google aimed at small to medium enterprises. Google Apps consist of GMail (which includes spam filtering), GoogleTalk, Google Calendar for communication, Google Docs, Start Page and Page Creator for collaboration and a control panel, access to APIs as well as 24/7 support for managing your Google services.
With these services you get either 10GB or 2GB of online mail storage, depending on your plan. You get support for mobile devices including Blackberrys. You use your own domain name and your emails are to and from you@yourdomain.com. You can even integrate Google Apps into your LDAP or Active Directory.
The biggest advantage of Google is that it is completely hosted. When we looked at Google for our enterprise we calculated that we could get rid of three systems – Exchange (2 servers), the Blackberry Server, and the spam appliance. It would also free up about 1 full-time employee.
So how much does this all cost? If you are an enterprise and you sign up for the premium service, it will set you back $50 per user per year. Yes, that is per year not per month. If you are a school or a 501(c)(3) non-profit organization – the cost is free, zip, nada.
For me that means we can support our 5000 volunteers with “official” email addresses. We couldn’t afford that even with Microsoft’s generous non-profit discounts. That means our volunteers can access their email and collaborate with each other anytime day or night, anywhere in the world and I don’t have to worry about whether our system is up or our ISP is down.
Let me just take a minute to add that while I am not a fan of Exchange because it is so proprietary and doesn’t play well with others, my hat is off to Microsoft for so generously supporting the non-profit community. A few other large software vendors – let’s start with Oracle – could learn from Microsoft in this regard.
So what’s the catch? There is some Exchange functionality missing. Some people think that GMail doesn’t support distribution lists. However, distribution list functionality is achieved by using the groups functionality in GMail contacts. Watch this three minute demo to see how it is done.
But, there are at least two significant pieces of Exchange functionality that are missing from Google Apps: public folders and delegates. Public folders allows a group of people to access the same set of emails and documents. Delegates allows me to let my assistant manage my calendar and appointments – which is a full-time job. But there is hope. See my upcoming posts on using Google Groups as a replacement for Exchange public folders and how to let your assistant manage your (Google) calendar.
View this Google Apps Q&A with Google Engineers