It's official: Interlockit.com is a Xero Certified Development Partner

Interlockit.com is currently the only Custom Integration Xero Development Partner in North America!

Xero provides online accounting, bank reconciliation, and invoicing services and integrates with a wide range of powerful software solutions and add-ons.

We have extensive experience building live integrations between Xero and Google Spreadsheets, credit card payment gateways, FreshBooks, Solve360, and more.

Our listing on the Xero website: http://www.xero.com/add-ons/custom-integration/

For more details visit our website at: http://www.interlockit.com/Home/services/xero/xero-custom-integration

Blair Collins from Interlockit.com presenting at CMA Ontario's SME 2013: Small Business, Big Success event on January 24th

Re-invigorate and re-charge the way you think about your business. Specially developed for entrepreneurs, SME 2013 will provide you with strategies to grow your small-to-medium business. Its blend of specialized speakers and networking opportunities will provide you the professional insights to take your business to the next level.

For more event details visit: http://pdi-cma.com/cmp/sme.html

Get Organized with Google Apps and free web services for 2013

One of the top resolutions for many Canadians is to get organized. Between work life, home life and their social life, people are juggling more and more each year. As schedules become increasingly hectic, staying in control can feel overwhelming at times, but getting organized doesn't have to be a lofty goal.

Frazzled families can finally toss all those paper to-do lists, post-it notes, kitchen calendars, pocket organizers and baskets of bills with the web – and free web services ranging from web calendars that you can share with a spouse or family, to web-based documents that can save your sanity as you plan family events.

The web can take a lot of work out of managing your life.  A free Google account is all you need to get started.  You can take your information with you wherever you are, whether on a laptop, tablet or smartphone. Here are just a few ways people can get their lives organized online:

• Move the kitchen calendar online – See how your spouse’s and kids’ schedules line up with yours by sharing a Google Calendar. Different colours/calendars click on and off to show events for different members of the family, carpool schedules, swimming practices, birthdays etc.

• Toss out bulky pocket organizers – Have your Google calendar sync automatically to your smart phone calendar or set up text message reminders of calendar events.

• Use Google Tasks for your to do list which works on your mobile device by opening http://gmail.com/tasks from your mobile browser.

• Create Google Tasks directly from an email with the shortcut Shift + T or by choosing Add to Tasks from the More options menu in your Gmail conversation.  This ensures you won't lose track of the related email content.

• Organize your expenses for 2013 and keep track of your spending plan on Google Docs Spreadsheets.  You can edit Google Spreadsheets directly from your iPad or Android tablet or of course from any web browser.

• For a more sophisticated but still free financial planner that automatically retrieves all your transactions from most Canadian banks you can setup the Canadian version of Mint.com in 10 minutes or less.

• Google sites is a free tool that lets you build collaborative websites. You can give anyone on your sports team, or PTA group permission to edit or just view the content of the site. You can make the site public or private. Sites makes it easy to embed the latest news updates, contact lists, videos, photos, group calendars and more.

• On the business side; need to better manage your customer relationships and projects?  Try out Norada Solve360 CRM and give us a ring to show you how it integrates with other solutions for accounting, contacts, calendaring, and email marketing.

Now’s the time to make those New Year’s resolutions a reality!

Some content from: Official Google Canada Blog

Rogers Wireless Speed Test: LG Nexus 4 vs. Samsung Galaxy S3 vs. LTE Hotspot

Our customers are always asking for our advice on smartphones. Apple's iPhone is very user friendly and a great choice, and as a Canadian I really hope RIM succeeds with BlackBerry 10 but I'm concerned that they may be too late to the party to get a seat.

But we're all Android fans since Android-based phones integrate so nicely to the Google Apps platform and the Google ecosystem as a whole. Android phones have been on the market since 2008 and in the third quarter of 2012 accounted for a full 72.4% of all smartphones.

Yesterday I received the popular and hard-to-get Google Nexus 4 built by LG.  The Nexus 4 (with 16GB of storage) costs just $359 in Canada (even less in the US), unlocked, and without a contract! It is a "pentaband" phone which means it works on nearly all GSM carriers worldwide!

It's a top-spec phone that is just as speedy as my wife's Samsung Galaxy S3, but it doesn't have LTE. So to help others in deciding if they can live without LTE, I did side by side speed tests on the Rogers network:

Phone	Download Speed	Upload Speed
LG Nexus 4 HSPA+	3109 Kbps	987 Kbps
Samsung Galaxy S3 LTE	11423 Kbps	7013 Kbps
LTE Hotspot (Sierra 763S)	21647 Kbps	5458 Kbps

LTE is certainly faster than HSPA+, but using the Galaxy S3 and Nexus 4 phones side-by-side on media-intensive apps like Google+ the difference is barely noticeable. YouTube videos certainly start up a touch faster over LTE than HSPA+.

The side by side usability difference is not sufficient to make me regret the purchase decision, and I love saving $220 over the outright price of $599 for the Samsung Galaxy S3. I also have the added benefit of getting the latest Android software directly from Google as soon as it's released, where S3 owners will have to wait months on end to receive Android 4.2 and its new features like Photo Sphere.  Even my two year-old Google Nexus S received Google Now long before S3 owners did. The S3 also comes pre-loaded with carrier applications that you can disable but not remove. The Rogers Visual Voicemail plus app constantly nags you that it doesn't work over Wi-fi even if you don't have the service.  Rogers also has to approve the S3 software updates which delays getting new features after Google releases them.

The bottom line is I highly recommend the Nexus 4 smartphone for Canadians, and at its current price, there's almost no reason to buy anything else. Let's just hope LG and Google can catch up with the huge demand. I think it will have an impact on smartphone prices worldwide. Google's disruptive move, delivering a flagship phone for a value phone price, demonstrates their continued industry leadership and innovation.

Test Notes:

• Speedtest.net Android application and Speedtest.net website on MacBook with Google Chrome used for testing.
• Nexus 4 Android version 4.2.1 on Rogers Wireless network using HSPA.
• Samsung Galaxy S3 Android version 4.1 on Rogers Wireless using LTE.
• Rogers LTE Hotspot Sierra Wireless Aircard 763S tethered via USB to a Macbook Pro. Wi-Fi Hotspot speed test results were lower than USB.
• Rogers LTE has a theoretical download speed of 100 Mbps.
• Rogers HSPA has a theoretical speed limit of 21 Mbps.
• The LG Nexus 4 has HSPA+, capable of 42Mbps speeds.
• 1 Mbps = 1024 Kbps.
• Nexus 4 LTE hack was not tested since it causes other issues like breaking Google Now.
• Your results will vary depending on your location and time of day.  This was done on the window sill in our office in Mississauga where I show 3 out of 4 bars on the Nexus 4.

Norada Solve360 CRM and Xero integrate beautifully in the cloud!

Congratulations to the Norada team on officially becoming a Xero Cloud Accounting Software CRM Add-on!

Interlockit.com is proud to be a Norada Solve360 CRM Strategic Partner and a Xero Certified Partner.

The Xero integration shows your customer's outstanding balances right on the Solve360 company or contact record.  You're only 1 click away from creating a new invoice, syncing the contact info from Solve360 to Xero, or opening the customer record in Xero.

At Interlockit.com we believe that the next killer business application in the cloud won't come from one vendor; instead it will be a multi-vendor fully integrated solution like Solve360 combined with Xero and Google Apps.

In fact, we've already replaced the expensive all-in-one cloud ERP solution from Netsuite at a customer site with Xero, Solve360, Freshbooks, Google Apps, and Mailchimp.  The customer's employees love the greatly improved functionality, ease of use, and on top of all that they're saving thousands of dollars per year in license fees.

A Secret Gmail Feature Is Hiding In Plain Sight...

This is an awesome Google Apps Gmail tip posted on Gizmodo.

Including the entire chain of text from prior emails is not necessary due to conversation threading in Gmail.

A quick way to help your email replies be more focused and concise is to select the relevant text in the email you want to reply to, then hit the reply button.  Only the selected text will be quoted.  Continue your reply as per usual.

Enjoy.

Tips for "The new compose in Gmail"

Google Apps users now have the option of turning on "The new compose in Gmail".

Note that you've always been able to Shift-Mouse Click the Compose button to open your new message in a separate web browser window.  You can also click the small black up arrow on the right hand side of the "To:" field to open in a window after you've started composing.

We are bringing this to your attention because the new compose button is missing lab features like Canned Responses and doesn't appear as a separate window on your Windows taskbar making it harder to find when it is embedded in your main email tab.

Certainly try it out.  You can always switch back to the prior compose interface from the arrowhead menu at the bottom right corner of the new compose feature.

Interlockit.com becomes a Xero Certified Partner

Blair Collins, a Certified Management Accountant and Google Apps Certified Specialist has passed the necessary exams to become a Xero Certified Advisor.  This also means Interlockit.com is officially a Xero Certified Partner and able to integrate your business with our favourite small business online accounting solution.  Xero boasts over 110,000 customer's worldwide and has grown 118% from last year.

Here's why we like Xero:

1. Collaboration - Xero's software is integrated with Google Apps so you're only 2 clicks away from opening the financial dashboard and doing your accounting in real time.  No separate passwords to memorize, but still completely secure and encrypted.
2. 100% Web Based Cloud Computing - Work from anywhere, at anytime, on any device.  Too many vendors are distorting the definition of cloud computing; you can't be 100% web based without starting from scratch and building a new product.  Why is your accounting system still running on traditional on-premise servers and computers that are expensive and cumbersome to remotely access?  Just open your web browser and get to work.  No software to install, patch, upgrade, secure, or backup. It just works.
3. Continuous improvement - Just last week all Xero customer's gained the ability to do online invoicing instead of emailing pdf file attachments.  Due to its modern technology platform, Xero can deliver continuous improvement without interruption.
4. Web Services API - Xero's Application Programming Interface allows us and other vendors to extend Xero's functionality.  It's why you can combine Solve360, Freshbooks, and Google Apps with Xero and they integrate rock-solid reliably and in a simple manner.  Our customers are never stuck with accepting what Xero provides them because we can program extensions at a reasonable cost.

You get all this for a mere $39 USD per month for as many users as you need--there is no limit.  Contact us at Interlockit.com for more details.

Interlockit.com team member is re-certified for Google Apps Certified Deployment Specialist

Google requires that all Google Apps Deployment Specialist's recertify every 18 months.  The Google Apps product changes frequently so it's important that specialists maintain their Google Apps skills.

Back in March of 2011, when our first team member passed his specialist exam there were 3 million organizations on Google Apps and over 2,500 Google Apps Authorized Resellers worldwide.  Today over 5 million organizations are on Google Apps and over 6,000 organizations are resellers.

Interlockit.com is proud to maintain our elite status as 1 of only 2 Google Apps Premier Authorized Resellers in Canada.  Our best guess is that only 40 organizations worldwide are Premier Authorized for Google Apps.

Is your current consultant a Google Apps Certified Deployment Specialist?

Chrome web browser print preview problem, and why you need .NET Framework

Google’s Chrome is now the most popular Web browser worldwide, surpassing Microsoft’s Internet Explorer for the first time in May 2012 according to StatCounter.

We’ve run into an issue several times wherein a user will attempt to print a web page or document using Chrome’s default print preview rather than the standard Windows print preview screen, but upon actually sending the job to the printer it simply vanishes. Chrome thinks it’s printed the job and so keeps on going but the job is never actually delivered to the printer. Another variation of this problem is one where the user will try to print a document or web page but Chrome simply doesn’t load the print preview properly and the job can’t be sent to print at all.

Keep in mind that this issue only applies to systems running Windows XP.  Newer machines running Windows Vista and Windows 7 do not experience this problem.

There’s a simple fix for this issue and it comes in the form of Microsoft’s .NET Framework. Downloading and installing the latest version is always recommended anyway (just like Windows Updates!), but for systems that are running outdated versions of .NET (older than 3.5), this issue will nearly always crop up. The most up-to-date version Microsoft has published is .NET Framework 4.5, but the issue is resolved with version 3.5. Downloading these, or newer, versions of the .NET Framework will resolve the printing issues, and users should be able to print from Chrome as they would from any other web browser.

Now that you've got Chrome working properly, the next step might be taking a moment to think about retiring Internet Explorer...

Blair Collins from Interlockit.com presenting at CMA Ontario's Simplif•IT: Technology Foundations for Finance Professionals

Get the Job Done with Google: The consumerization of IT and what Google can do for your business beyond search, today!
A fundamental shift... There was a time when business technology was at the forefront of innovation and productivity. IT professionals have stopped innovating and rely on a handful of vendors who design bloated software that gets released every few years. At the same time, consumer technology has taken off. With the power of massive data centers, modern browsers and smart mobile devices at their fingertips, people find it easier than ever to communicate, create, and collaborate. Many people have fallen in love with the simplicity and freedom of these services, and they want to use them everywhere.

Learn more from Interlockit.com and what solutions from Google your business can be using today! Plan now for the massive impact "The consumerization of IT" can have on your business now. Learn why Canadian Google Apps customers like Hoffman-LA Roche, Genetech, Solutions Stores-Your Organized Living, Golf Town, Delta Hotels, AMJ Campbell Van Lines, Feronia, Taylor Moving, Greenwood College, The York School and others love hitting "Refresh" on their business technology.

CMA Ontario Tech Symposium
Google+ Event

Google Apps Script: How to retrieve more than 200 items from a List Page

We're constantly building customer solutions for Google Apps, Solve360, Freshbooks, and Xero with Google Apps Script and Google App Engine.   Below is a handy tip for Google Apps Script developers.

Posted on behalf of Cameron Roberts, Senior Developer, Interlockit.com

When interacting with a Google Sites list page via the Google Apps Script SitesApp service, the documented getListItems() function returns only 200 items, while the maximum length of a List Page in sites is 500 Items. This function takes advantage of undocumented parameter values that can be passed to getListItems() to retrieve all items in batches of 200.  

/*
   Function: getAllListPageItems(page)
  Parameter: page - An instance of the Google Apps Script Services "ListPage" class.
Description: A robust function which uses undocumented Google Services functonality to retrieve ALL items from a list page. At time of writing (June 2012), the Google Services getListItems() method returns only the first 200 items of a ListPage. This function will catch failed API calls and re-try until all list items have been retrieved. This function will also throw an informative exception if the passed parameter is not a valid ListPage object.

Usage Example:
 
   //retrieve items from list page and write to Log.

   var page = SitesApp.getPageByUrl('http://sites.google.com/a/yourdomain.xyz/yoursite/yourListPage');
   var items = getAllListItems(page);

   for(var i in items){
       var item = items[i];
       Logger.log(item);
       //..Perform your processing on list items here.
   }


Written by Cameron Roberts, Interlockit.com

*/

function getAllListPageItems(page){
  if(page && page.getPageType && page.getPageType() == 'ListPage'){
    var items = [];
    var start = 0;
    var size = 200;
    var failed = false;
    do{
      try{
        var item_batch = page.getListItems({start:start,max:size});
        failed = false;
        items = items.concat(item_batch);
        start += size;
      }catch(e){
        failed = true;
      }
    }while(item_batch.length == size || failed);
    return items;
  }else{
    throw 'Parameter passed to getAllListItems was not a List Page: '+page;
  }
}


The relevant post from Google, which exposes the undocumented functionality, is http://code.google.com/p/google-apps-script-issues/issues/detail?id=666

Canada tops for mobile data loss

The HR Reporter recently shared a study by the Ponemon Institute which Crashplan also highlighted on their blog.

HRReporter.com notes:

• Corporate mobile devices and the bring-your-own device (BYOD) phenomenon are rapidly circumventing enterprise security and policies in Canada.
• 71 percent of 421 respondents in Canada agree the use of mobile devices in the workplace is important to achieving business objectives.
• 72 percent of Canadian respondents also believe these devices put their organizations at risk — and only  half of the organizations surveyed have the necessary security controls to address the risk.
• 58 percent of the organizations experienced data loss resulting from employee use of insecure mobile devices.
• Canada and Italy ranked the highest out of 12 countries surveyed for mobile data loss.

Bottom line is Mobile devices are a huge security risk.  Smartphones can store an immense amount of sensitive emails and contact databases which may easily fall into unfriendly hands.

Google Apps has excellent built in Mobile Device Management that allows customers to remotely wipe the synced data contents of iPhones, and Androids plus enforce password and screen lock policies.  You can even control and approve what devices are allowed to connect to your organization's Google Apps data.

For Blackberries we offer a Google Apps integrated Blackberry Enterprise Server solution for $10/device/month with similar capabilities for remote wipe of data, etc.

There are no complex integrations requirements or other extra costs for Mobile Device Management with Google Apps for iPhone, iPad, or Android devices.  There is no need to purchase expensive 3rd party solutions like RIM Mobile Fusion that exceed the $50 USD/year/user cost of Google Apps.  Zenprise is another Mobile Device Management solution with prices starting at $40/device/year.

Contact us at Interlockit.com to learn more about protecting your organization's valuable data with Google Apps.

The rumours were true... Announcing Google Drive

On April 24th Google announced Google Drive, a new way to access and share all your files and folders, at any time and on any device.  Google Drive replaces and enhances what you know today as your Google Documents List.

Google Apps users now have a fantastic alternative to other cloud storage solutions like Dropbox, Egnyte, and Box.

An immediate benefit to Google Apps customers is that your 1 Gb non Google Docs storage limit has been expanded to 5 Gb.  The storage of Google Docs format files is still unlimited.

Effective this week Google Apps Resellers like us can sell you Google Apps domain licenses for additional storage that you can then assign to specific users.  Pricing starts at $4/month for 20 Gb.

Think of Google Drive as your personal stash of files and folders that follows you wherever you go - it lets you keep everything and share anything. With Google Drive, you can access files, folders, and Google Docs from a web browser or any device where you've installed your Google Drive.

Your Google Drive is in the cloud, but you can also install the desktop and mobile application to access your files from your computer, smartphone, tablet, or other Android or iOS mobile device, in addition to the online interface at drive.google.com. Google Drive's built-in sync capability ensures that your files, folders, and Google Docs are the same on all your devices.

To try it out visit drive.google.com/start

Note that currently only rapid release domains will see Google Drive.  Scheduled Release domains will see it in Phase 2 for which a timeline has not yet been set.

Contact us at Interlockit.com if you'd like assistance with configuring Google Drive, purchasing licenses, or understanding better how this might help your business eliminate file servers completely!

Crashplan vs. Mozy

We've been Mozy users since 2009 for cloud online data backup but had read various positive reviews for CrashPlan.  Two months ago we started testing it out and have completely switched over all our workstation and server backups to CrashPlan.  Today we cancelled our Mozy account before it renews.

Here's what we like about CrashPlan over Mozy:

• easier to understand user interface
• no lengthy delays selecting or changing which files are backed up.  On a home theatre PC with 23,000 files and 125 Gb I would open Mozy and go get a coffee before I could start making changes.  Then when you pressed OK it was another long delay.  No such long delays with Crashplan.  We had a similar even longer delay in selecting files to backup with MozyPro (business version) at a customer site on their file server.  We had to give up and put the customer on Storage Guardian which works fine but is way too complex for most small businesses to manage.
• Windows Servers can be backed up without any additional cost or restrictions with Crashplan.  We must admit that we were cheating by using MozyHome and running a batch routine to copy files from the file server to a workstation to then be backed up in the cloud on Mozy.  Crashplan runs fine on our old Windows Server 2003 file server directly.
• 3 way backup/social backup that's easy to setup.  Have a brother with some extra hard drive space?  You can use Crashplan for free and back up your data on his computer and his on yours over the internet.  Inside our office we backup both to Crashplan online and to a large hard drive on one of the workstations.  We do this because restoring from a local drive copy will always be  faster than downloading it from the web.

Certainly contact us at Interlockit.com if you would like some assistance with deploying your online data backup and disaster recovery plan.

Show your customer addresses on Google Maps

Do a Google Search on mapping customer addresses and you'll get all sorts of overly complicated ways to do it with third party stuff, etc.

Google Spreadsheets does it very easily "out of the box", well that is... in the cloud for free.

Follow these steps published by Google: http://support.google.com/docs/bin/answer.py?hl=en&answer=91601 to use a gadget for mapping addresses from the rows of a Google Spreadsheet.  Last column as tooltip is how you can show the customer name.

In our case we used a Google Apps Script to populate the rows of the Google spreadsheet instantly from our Norada Solve360 CRM using this: http://goo.gl/DyV0F

So now with a few clicks we can display a real time map of our customer locations and refresh it instantly.

If you have a more complex reporting/spreadsheet need that might require Google Apps Script programming contact us at Interlockit.com.

Enjoy!

Google Apps Vault brings better integrated email archiving to Google Apps

As a Google Apps Postini Authorized Reseller we've handled numerous implementations of Postini email archiving and message security.  While Postini has great technology its user interface was ages behind the simplicity of Google Apps.  We're definitely excited about the release of Google Vault which is so much better integrated into the core Google Apps product.

Google Apps Vault eliminates all sorts of administrative headaches for Google Apps and Postini customers such as managing duplicate user lists, email aliases, and email distribution groups across the 2 systems.

Currently Google Vault is only available to new Google Apps customers but we expect Google to allow the migration of existing customers from Postini to Google Apps Vault soon.

By the way, Google Postini is still the best cloud spam and virus filter for Microsoft Exchange or other emails servers on the market.  It will continue to be supported and enhanced for the long term as there is a huge install base of existing users.  Since ~90% of all email is spam, Google Postini removes this heavy load from your internet data lines and on-premise Exchange server.  When we switch customers from an on-premise firewall based spam filter to Postini or Google Apps they are often shocked by the dramatic drop in load on their internet data lines.

Source: http://googleenterprise.blogspot.ca/2012/03/google-apps-vault-brings-information.html

Google Apps integration with Salesforce.com

We've helped lots of customers configure their Salesforce.com integration to Google Apps.  From that experience we've learned which Salesforce AppExchange for Google Apps products work well.

We like Cirrus Insight.  You can lookup the relevant Salesforce data as soon as you open an email in Gmail.  Plus it's all done in the Cloud so there's no software to install. Just configure it once and everyone in your company can use it.

Contact us if you need help with the set-up or more advanced tricks like only showing the Cirrus Insight Gmail Contextual Gadget to some users instead of all.

Interlockit.com Website Relaunch

Check out our relaunched website at http://interlockit.com!

The site is 100% based on Google Sites so it's super easy for our team to update it and we pay zero hosting fees.  If they are logged into their Gmail/Google Apps account it is only a few clicks away to start editing the site.  No separate passwords to remember.  We can also set page level permissions to allow team members to modify only certain sections.

We have the right talent on board that can do amazing things with the Google Sites platform.

Our Contact Us form is live integrated into our Solve360 CRM; so no re-keying of information from emails and a task is assigned to a team member to follow-up.

Let us know if you would like a quote on building your own website with Google Sites!

Interlockit.com team member becomes Google Apps Certified Sales Specialist

As part of the launch of the new tier of Google Apps PREMIER Resellers effective Feb. 14th, 2012, myself, Blair Collins, has received the Google Apps Certified Sales Specialist Certification.  We were part of the beta exam process so we're among the first in the world to receive the certification.

Details on the requirements can be found at: http://certification.googleapps.com/Home/sales-certification

Interlockit.com is pleased to be able to further differentiate ourselves in the Google Apps Marketplace with two Google Apps Certified Deployment Specialists, a Google Apps Certified Sales Specialist, and our Google Apps PREMIER SMB Reseller status.  Very few organizations in the world have achieved this level of recognition.

Deploying Google Apps is what we love to do!

Is your current provider Google Apps certified?