Google Apps Directory Sync Exclude Organization

With release 2.01 of Google Apps Directory Sync you can exclude organizations within your Google Apps domain from being sychronized.  This avoids having to individually exclude accounts like administrators or any other account that isn't in your LDAP or Active Directory.

However, there is zero documentation provided and we've found that only substring match will work.

Note also that there is an issue we confirmed with Google support that should be fixed in a future release where this exclusion rule will not work on any usernames that contain capital letters.  So if the username is Username@yourdomain.com instead of username@yourdomain.com this exclusion rule won't work on that account.  We had to use the GAM command line tool to rename some accounts to work around this issue for a customer.

If you would like some assistance with Google Apps Directory Sync feel free to contact Interlockit.com.

2nd Interlockit.com team member becomes a Google Apps Certified Deployment Specialist

We now have 2 staff members who are officially Google Apps Certified Deployment Specialists.

Once again we have demonstrated our high level of expertise and focus on Google Apps deployments since 2009.

How many Certified Deployment Specialists does your IT provider have?

Interlockit.com team member officially becomes a Google Apps Certified Deployment Specialist

Adoption of Google Apps is accelerating around the world with over 3 million businesses that have gone Google.  The Google partner community has more than doubled in the last year to over 2,500 partners in over 70 countries.

As far as we can tell less than 150 people have passed the Google Apps Certified Deployment Specialist exam.  Interlockit.com is pleased to be able to further differentiate ourselves in the Google Apps Marketplace.

Interlockit.com has successfully migrated over 2,500 users to Google Apps.  Deploying Google Apps is what we love to do!

Does your current provider have any Google Apps Certified Deployment Specialists on staff?

Blackberry Protect and remote wipe of mobile phones

What would happen if you suddenly lost your phone?  Does your phone auto lock with a PIN?  Can you wipe the data?  Can you remotely locate it?

RIM has just released Blackberry Protect for free to all North American users via the Blackbery App World.  You can use Blackberry Protect to locate, remotely lock, or wipe data from your Blackberry device if it is lost or stolen.  We recommend this software to all blackberry customers that are not running Blackberry Enterprise Server (BES).

Android and Windows Mobile devices can use Lookout Mobile Security which provides similar features.

Your phone has highly valuable personal information.  Grab some piece of mind now by installing one of these utilities on your phone.

Google Cloud Connect for Microsoft Office

We mentioned back in March 2010 that Google had acquired DocVerse and have been eagerly awaiting the product release.  It's finally here and wow did Google deliver!  They brought simultaneous document editing to Office 2003, 2007, and 2010.  There is no need to purchase an Office 2010 upgrade and setup a Sharepoint server or Skydrive to gain the Microsoft equivalent of this feature.

What is simultaneous editing?  It means that multiple people can edit the exact same document at the exact same time and automatically see the other person's changes.  With simultaneous editing you can work on different slides of a single Powerpoint presentaton file at the same time or update meeting minutes in a single Microsoft Word file at the same time.

By the way, simultaneous editing has been available with native Google Docs, Google Spreadsheets, and Google Presentations for years now.   It makes collaborating on documents and presentations a breeze.

I tested Google Cloud Connect by opening an existing Microsoft Word document in Office 2010 on one computer and synched it with Google Cloud Connect.  I then downloaded from Google Docs and opened it with another computer running Office 2007.  When I changed lines of text on either computer and clicked the save button, within seconds the other computer would refresh and show the same change.  Incredible functionality and I think that explains why it took almost 1 year from acquisition to release the product.

For more details and a video overview check out Google's official blog posting and Google Docs Help

Transition from Salesforce.com to Norada Solve360

Announcing the official launching of our Salesforce.com activity and opportunity migration tool!

We can migrate tasks, events, and activity records and emails from Salesforce.com to Norada Solve360 starting at $495 USD. Mapping custom activity fields and migrating lead activity adds slightly to the cost. We provide fixed priced estimates after reviewing your Salesforce.com and Solve360 account.

The history is pushed into a formatted note on the appropriate contact or company (Account) record.

Update: We can migrate open and closed Salesforce.com opportunity records too!

Give us a call at (416) 840-6268 or visit us at http://www.interlockit.com

Why isn't your current IT consultant or reseller promoting the cloud?

Cloud Computing is a disruptive wave that provides cheaper, more convenient, and simpler business solutions that work.  So why isn't your current consultant or reseller recommending Cloud Computing solutions?

It's simple:

1. Cloud software vendors sell direct to the customer and give little or zero margin to the reseller.
2. Consultants compete globally in the cloud for engagements because cloud systems can be setup and managed from anywhere without complex remote access solutions.
3. On-premise consultants know your existing network infrastructure and server configurations making customer's loyal to them for future work.  In the cloud you only need a web browser so the customer is more likely to choose the cloud software expert over their existing consultant.
4. For every $1 customers spend on Microsoft enterprise licensing fees, they spend $8 with consultants and channel vendors customizing Microsoft's tools or integrating other products.  This ecosystem works well with an on-premise model that requires physical management and integration of systems.

Bottom line is that, until forced to change, existing consultants and resellers will continue to focus on what makes them the most money which is traditional on-premise systems.

The challenge for Cloud Computing focused vendors like us is to constantly find new customers because the  recurring consulting dollars for us are much smaller.  However, we're 100% committed to cloud solutions because fundamentally it is the best solution for the customer.

We love our work because we're blazing a new trail and every day making our customer's extraordinarily happy with moving their business to the cloud.

Spam takes another hit: email authentication available to millions of Google Apps customers

Google has been an early and consistent supporter of email authentication technologies, which help ensure senders are who they say they are, and in turn help to curb spam.  Interlockit.com configures a Sender Policy Framework (SPF) record as a standard component of our Google Apps implementations that prevents spammers from sending messages with forged From addresses from your company domain.

On January 6th, 2011 Google made available the ability for Google Apps customers to sign their outgoing messages with DKIM, so that your sent mail is less likely to get caught up in recipients' spam filters.  Think of it as a finger print on your outgoing email that a spammer can't duplicate.  We've tested it for a few weeks and definitely recommend setting this up on all Google Apps accounts.

Google Apps is the first major email platform to offer simple DKIM signing at no extra cost other than the labour to configure it.  Once again the power of the cloud has made it possible to bring this feature to millions of customers quickly and affordably.

It takes an Interlockit.com team member about 30 minutes to configure DKIM on your DNS hosting control panel and on your Google Apps account.

If you are interested in having this feature enabled to ensure that more of your outgoing email reaches its destination  give us a call at (416) 840-6268.

Rogers Blackberry with Google Sync and Blackberry Internet Service Synchronization

Watch out for an issue we just encountered today with Blackberry Internet Service (BIS) on Rogers with a Blackberry Bold running Blackberry OS 5.0:

• if you change your price plan with Rogers it will reset your BIS settings and turn on Sync Contacts, and Sync Calendar via BIS automatically.  This will cause massive duplication of Google Calendar entries and corruption of address fields in Google Contacts if you also have Google Sync installed and running on your phone.  The difference between synching with BIS and Google Sync was discussed on a prior blog post here
• We still recommend using the Google Sync because it works better and faster than the BIS sync

The solution is to sign out of Google Sync before making changes to your account.  The next day review your BIS setup via the Email setup icon on your phone and make sure the Synchronization of calendar and contacts is turned off.  Then restart/login to Google Sync again.

Update April 19, 2011: We're seeing this issue much more frequently now across Rogers, Telus, and Bell.  They are upgrading their backend BIS systems so suddently Contact and Calendar sync can get turned on with zero warning causing corruption of Calendar and Contacts.  We hope that the cell phone companies will work with RIM to warn users before making the surprise upgrade.  As a result of this we strictly turn on the BIS Contact and Calendar Sync if supported by the phone.

New Year's Predictions and Milestones Achieved

Interlockit.com has now migrated over 2000 users to Google Apps!

The majority of our larger customers have migrated from Microsoft Exchange Server 2003 but we've also helped organizations of all sizes move away from traditional ISP hosted POP3/IMAP email accounts with Easyhosting.com, Bellhosting.ca, Telushosting.com, Godaddy.com, Networksolutions.com, and even from Hosted Microsoft Exchange at Sherweb.com.

One customer install really highlights an advantage of going all web browser based.  They had attempted to use a Hosted Microsoft Exchange Server solution for their employees spread around the world and in some countries where internet data lines are unreliable.  Going web browser based with Google Apps dramatically improved their ability to communicate and collaborate in real time across the company.  In particular they can finally communicate electronically with their employees in the Democratic Republic of Congo via Google Apps.

We're seing an increase in inquiries for Microsoft Online Services/BPOS deployments also.  Ultimately we deploy what the customer chooses but certainly discuss the pro's and con's of each option.  The head to head competition between Google and Microsoft is great for our customers in the end.

Our number one prediction for 2011 is that the pace of adoption of Cloud Computing solutions like Google Apps and Microsoft BPOS/Office 365 will continue to accelerate; and, as an early adopter that focuses exclusively on Cloud Solutions, Interlockit.com will continue to both save our customers money over the long term but also provide them with a better way of running their business.

Interlockit.com - Moving Businesses to the Cloud

Google defines 100% Web

Google today posted an excellent article about bringing customers to a world they call 100% web. Interlockit.com has helped numerous customers move their businesses to the cloud ranging from 1000's of users to sole proprietors. Defining the vision we share of 100% web will help future customers better spot the numerous cloud pretenders.

"This year cloud computing went mainstream, and the conversations moved beyond "this is a way to cut costs" to "this is a better way to run my business."  While many IT vendors have now adopted (or co-opted) the term “cloud computing” to describe a wide variety of technologies, most don’t deliver on the true promise of the cloud. Hosting single-tenant server products in a data center is not cloud computing. Nor is requiring customers to install thick client software. These solutions lock-in customers to multi-year release cycles, leave them with the significant costs of managing client software, and expose sensitive data on insecure devices."

You can read the complete Google Enterprise blog post here

How to create mailing labels from Google Apps

After much experimenting here is a way to do mailing labels from your Google Apps for Business/Premier Edition contacts:

1. If you're only using Google Apps from the web interface, install Google Apps Sync for Microsoft Outlook (requires Business Edition), don't import anything, run it, and allow it to finish loading your contacts.  No need to wait for it to sync the first 1 Gb of your email.
2. Open Microsoft Word (2007 or 2010 in my case), choose Mailings, Start Mail Merge, Labels, and select your label format.  Mine was Avery US Letter 5160 Easy Peel Address Labels.
3. Click Select Recipients, Select from Microsoft Outlook Contacts.  (You can fine tune the filters and the list of contacts again later by clicking Edit Recipient List from the toolbar.)
4. Click Address Block, Match Fields.  Beside "Address 1" choose "Home Address" or "Business Address" appropriately.  Change all the remaining address fields such as "City" to "(not matched)".  Since addresses in Google Apps are free format they don't parse consistently into the appropriate fields so choosing Home Address in Address 1 and clearing the rest of the fields gets around this problem.
5. Click Update Labels to make all the labels the same format.  Click Preview Results.
6. Select All (Ctrl-A) and change fonts, sizes, and line spacing according to your preferences.
7. Finish and Merge to a new document for further editing or send it to the printer.  You're all done!

P.S. I tried exporting the contacts into Google csv or Outlook csv format,  and converting them to an Excel spreadsheet using Excel or Google Spreadsheets but this gave me too many issues with the formatting of the addresses.  Maybe your contact list is cleaner than mine.  If you know another way that works well please share the knowledge and post a comment.

Family members, your Christmas cards on their way...

How to synchronize your Google Apps Calendar and Contacts with your Blackberry smartphone

As posted here on the official Blackberry blog, phones with Device Software 5.0 or higher can do wireless calendar and contacts synchronization without installing Google Apps Sync for Blackberry on the phone.

We've tested this out and it works but there are a few caveats:

• It causes many duplicates whereas we have not seen this issue with the Google Sync tool.  You can use the Google Apps Contact Merge option to clean them up later.
• You can't tell the phone to "Sync Now" like you can from the Google Sync icon.   If you create a contact on the phone it is immediately added to Google Apps.  However, we added a contact to Google Apps and after 3 hours it still hadn't arrived on the phone.  It's definitely not a push contact sync like Google Apps with the iPhone or Android.
• You can't sync multiple calendars like the Google Sync tool can.
• You can't specify how many weeks forward and back to keep in sync.

So the only advantage is that you don't have to install the Google Sync tool on your phone.

We recommend continuing to use the Google Sync for Blackberry tool.

Certainly give us a call at interlockit.com for assistance.

Android wallops Blackberry

Back on March 21, 2010 I blogged about the cost savings of using Android phones.

The Globe and Mail reports that Android phones account for a dominant 44 percent of the consumer smartphone market in Q3 2010

We're big proponents of the cloud because we're saving corporations lots of money on their IT and putting them on a continuous innovation curve; but we'll miss the billable hours from configuring Blackberries. :)

With an Android phone you sign it into your Google Apps account and you're done.  Email, Calendar, and Contact sync starts working immediately.

Tip:  Only buy phones with version 2.1 or greater of the Android OS.  And make sure the manufacturer is going to upgrade it to version 2.2 which is faster and adds flash player support.

In Canada we recommend the Google Nexus One from Videotron, Samsung Galaxy S from Rogers, HTC Desire from Telus, Motorola Milestone from Telus, and the HTC Desire Z from Bell

Enjoy!

Announcing: Norada Solve 360 CRM and Project Management Software

A common customer question is "How do I share my contacts with others?"

After much research we have signed on as a partner for Norada Solve360 Customer Relationship Management (CRM).  We compared it to Zoho, BatchBook, insight.ly, and Salesforce.com (which we use internally but will be switching).  The Solve360 user interface is fantastic, simple to use, yet powerful.  Google Apps is not just an application but a platform into which many products can already integrate. 

When you combine Norada Solve360 with Google Apps, Mailchimp/Constant Contact, Freshbooks, plus Mobile contacts and calendar synchronization you have the ultimate integrated platform for superior customer relationship management, marketing, sales results, project management, time management, and invoicing.

The real time integration is suberb and is an excellent showcase of the advantages of cloud computing.

Solve360 pricing starts at $40 per month for 3 users which is a huge bargain compared to the market leader Salesforce.com at $195 per month for 3 users.

Norada Solve360 is seeing huge growth and we're proud to be a business partner.

Why the iPad and iPhone need cloud based applications

Some might decry that the lack of a physical keyboard and the limitation of only being able to install applications from the App Store mean that the iPad can't be used for "real" business work.

But if your company is already using cloud based solutions like Google Apps, or Salesforce.com the iPad is perfect for the business professional on the go who doesn't need a full laptop.

And soon Google will release the ability to edit Google documents on an iPad or Android device allowing you to edit a spreadsheet from your iPad simultaneously with a co-worker on an office PC.

P.S. We've seen many iPad and iPhone users incorrectly setup their phones using IMAP, POP3, or the Google Mail icon on their phone.  Yes, it's counterintuitive but a Google Apps account gives you Email, Calendar, and Contacts sync via Microsoft Exchange Active Sync technology on the iPad or iPhone.  The official Google iPad and iPhone setup instructions are available here.

Or give us a call at Interlockit.com and we'll walk you through it.

70% of Canadians have a wireless device

Integration with mobile devices is a critical component of any email and document management solution.

A study released by firm iSuppli Corp shows that 73.4% of the earth's population has a mobile phone.  In Canada, 70% of our population has a wireless device.

You can join a live webinar for businesses on 9/23: Google Apps for mobile.  Click here for more details and to register.

For additional reading:

• http://www.isuppli.com/Mobile-and-Wireless-Communications/News/Pages/Global-Wireless-Subscriptions-Reach-5-Billion.aspx 
• http://mobilesyrup.com/2010/09/21/73-4-percent-of-the-earth%E2%80%99s-population-has-a-mobile-phone/

Two-factor authentication for Google Apps released

This is powerhouse stuff that was normally only available to larger enterprises...  Organizations like the brokerage house BMO-Nesbitt Burns use expensive RSA SecurID two-factor authentication solutions for employee remote access.  Google is bringing the same two-factor authentication capability to our Google Apps customers through the use of mobile phones for no additional cost.

Ultimately any system open to the Internet is only as secure as your passwords.  The problem with passwords is that employees tend to over use them across many websites and systems.  Even if you force regular password changes many employees will rotate a single character leaving it easy for former employees to guess.

With two-factor authentication the employee must supply the password (something they know) and a one-time verification code from their mobile phone (something they have).

Only cloud computing can deliver rapid innovations like two-factor authentication at such a low cost and with no upgrades to install.

And by the way, 1 million businesses have adopted Google Apps in less than 12 months bringing the total to 3 million businesses and 30 million users.

At Interlockit.com we're always available to help with your Google Apps setup.

For more details visit: http://googleenterprise.blogspot.com/2010/09/more-secure-cloud-for-millions-of.html

Google Apps User Rename

There are more friendly tools for renaming Google Apps users that you can purchase but GAM (Google Apps Manager) is free and can do user renaming plus much more:
http://code.google.com/p/google-apps-manager/

It's command line driven.  We use it for various batch operations like turning off webclips for all Google Apps user accounts.

With the ability to rename users there is no need to backup and restore user accounts just to change their email address.

Google Apps: Rapid innovation in the cloud versus hosted applications

Wow, Google is rolling out a massive number of improvements to Google Apps in a short amount of time!  I count 87 entries so far on the blog for 2010, which is an average of  ~10 per month.

This is a fundamental difference between true cloud computing and the hosting of applications.  Quickbooks for example (not Quickbooks online which is not availabe in Canada), is an excellent accounting application but having it hosted doesn't elimininate the work of installing patches, learning the significant changes from the prior version, and preparing for any major impact to your current business processes.  However, for certain businesses hosting Quickbooks in a data centre is a great option that eliminates the headaches of running your own servers, provides simple remote access, and ensures backups are stored offsite.  At Interlockit.com we've helped customers move a variety of applications into data centres but we always do a cost comparison to the alternatives before making the recommendations.  Sometimes the hardware or software requirements mean running it on the customer's own servers is the better option.

I like this analogy from one of the articles below:  "Buying the services of a traditional hosting provider is like renting a set of electricity generators, whereas a cloud computing provider provides an electrical power grid. The idea is that a cloud computing provider makes it extra easy to treat computing resources like a pay-as-you-go utility service."

NetSuite, SuccessFactors, Salesforce.com, Freshbooks, these are all true cloud computing applications that provide continuous innovation for all of their customers.  The learning curve is small because small changes are made on a continuous basis.

Remember the big learning curve when switching from Microsoft Office 2003 to 2007?

Subscribe to the Google Apps official blog to keep up with all the changes at http://googleappsupdates.blogspot.com/

Subscribe to the Microsoft Online Services/BPOS blog at http://blogs.technet.com/b/msonline/

For additional reading:

• Salesforce CEO: Private cloud is not real cloud 
• The differences between Hosting and Cloud Hosting 
• Cloud Computing versus traditional hosting