Google Calendar Exporting / Importing

Google to Google Calendar Migration

In some scenarios it is necessary to migrate Google Calendar data manually between two Google accounts.

Usually, this is very simple.

Exporting from Google Calendar

1. Open Google Calendar on the source account
2. Go to Calendar settings > Import & Export
3. Click Export, and a ZIP file with all calendars will download to your computer
4. Extract the ZIP file, noting there is a separate .ics file for each calendar

Importing to Google Calendar

1. Open Google Calendar on the target account
2. If they don't already exist, create an appropriate target calendar for each calendar you will import to this account. Note, often you may not want to bring the primary calendar of the source account into the primary calendar of the target account.
3. Go to Calendar settings > Import & Export
4. Select the .ics file you intend to import
5. Select the appropriate target calendar
6. Click Import

Dealing with large calendars that fail to import

In many cases, a larger calendar will fail to import. This is because of limitations in Google Calendar's import capabilities. The solution is to manually divide the .ics file into several files, importing each separately. Usually, if each file is under 2.5mb it will import without issues, but in some cases you will need to split the files smaller.

Notepad++ is used in the example below.

Open the .ics file in Notepad++ and identify the headers, events, and footers of the .ics file. The headers are every part of the file that come before the first event, and the footers are every part that come after the last event. Everything encapsulated within "BEGIN: VEVENT" and "END:VEVENT" is an individual event. See screenshot below for example of Header, Event, and Footer sections.

The concept of splitting the file is quite simple. We want to create multiple files with the Header and Footer sections intact, while splitting the event content across each of our multiple files, keeping each individual event intact. This is where Notepad++ comes in handy, since it gives you a line reference to the left of each line, so you can keep track of which events you are including in each file.

These example instructions assume you want to split a single .ics file into 2 files:

1. Open the original .ics file and identify the headers.
2. Create two new blank .ics files (name them appropriately to keep track of them) and paste the headers into each file.
3. From the original .ics file, select roughly the first half of events by starting at the first line with "BEGIN:VEVENT" and choosing a line that contains "END:VEVENT" somewhere near the middle of the file. Copy-paste this into the first new .ics file.
   
4. From the original .ics file, select the next half of events after the data you copied, which should be the next event beginning with "BEGIN:VEVENT" all the way to near the end of the file, the last line that contains "END:VEVENT". Copy-paste this into the second new .ics file.
   
5. Open the original .ics file and identify the footers.
6. Copy-paste the footers to the end of each of the new .ics files.
7. Save both of your new files and proceed to import them one-by-one.

If you have questions or if you would like someone from our team to handle this for you, you can fill out this form.

New pricing for G Suite Basic and Business FAQ for Canada and USA

Google G Suite prices have remained the same for more than a decade despite providing a continuous stream of customer focused innovation and adding over a dozen new services.

If you are buying G suite from Google directly or through another Google Cloud Partner please visit this blog post to learn how to lock in today's pricing for 1 more year for significant savings!

We've created this FAQ to help customers understand the pricing changes and will continue to update it as new information becomes available for Canadian and USA customers in CAD and USD.

On January 16th, 2019 Google Cloud Announced price increases that will take effect April 2nd, 2019.

The new prices in USD and CAD are below:

G Suite Edition	USD (per user/month)	CAD (per user/month)
Basic	$6	$7.80
Business	$12	$15.60
Enterprise	$25	$34.00

Enterprise Edition prices remain the same.

You can find the current USD pricing and an overview of what's contained in each edition here: https://gsuite.google.com/pricing.html

A detailed comparison of the G Suite editions is here: https://gsuite.google.com/compare-editions/

The $50/user/year G Suite Basic Annual plan which was a 20% discount over the $5/user/month ($60/user/year) Flex plan has been eliminated. Annual and Monthly Flex plans now cost the same overall per year. There will no longer be a discount for locking into an Annual plan.

Customers purchasing G Suite in Canadian Dollars (CAD) on either Annual or Monthly Flex plans directly from Google or from a reseller (confirmed January 22nd) will receive a limited time regional discount for the first year below:

G Suite Edition	Ends April 1st, 2020    (per user/month)	Starts April 2nd, 2020    (per user/month)
Basic	$7.02 CAD (10% discount)	$7.80 CAD (regular price)
Business	$13.26 CAD (15% discount)	$15.60 CAD (regular price)

For customers on Annual plans the discount will apply to the full first year of renewals occurring April 2nd, 2019 until December 31st, 2019. Renewals prior to April 2nd, 2019 will not see a price increase until renewal in 2020. Annual plan customers cannot renew early/reset their contract term unless they upgrade to Business or Enterprise. Annual CAD renewals after December 31st, 2019 will not receive the regional discount.

Upgrading from Basic to Business Edition is actually a great option to reset your contract term and lock in the $10/user/month pricing for 1 more year. G Suite Business with Team Drives and Unlimited Storage is giving our customers freedom from traditional Windows file shares and other non-integrated, non-cloud storage solutions.

Canadian and US customers paying in USD will not receive any regional or transition discounts either direct or through partners.

The good news is that our Interlockit.com customers currently on the monthly Flex plans have the additional option to switch to an annual plan before the April 2nd price increase and lock in today's Basic Edition for $50/user/year or Business Edition for $120/user/year for a full year.

Unlike Interlockit.com customers, those buying directly from Google on monthly Flex do not have the option to switch to an annual plan before the price increase and save as much as 62% for 1 year.

If you know of organizations buying G Suite from Google directly please refer them to us at Interlockit.com so we can also save them significant money for 1 more year!

How to save money and delay the G Suite price increase

On January 16th, 2019 Google Cloud Announced price increases that will take effect April 2nd, 2019.

Organizations currently purchasing G Suite Basic for $50 on an annual plan in USD are facing a 44% price increase effective April 2nd, 2019.

The new prices in U.S. Dollars (USD) and Canadian Dollars (CAD) are below:

G Suite Edition	USD (per user/month)	CAD (per user/month)
Basic	$6	$7.80
Business	$12	$15.60
Enterprise	$25	$34.00

If your organization is currently buying G Suite Basic or Business Edition directly from Google on a monthly Flex plan you can switch to an Annual subscription through us at Interlockit.com before the price increase date and keep the old pricing for 1 whole year!

In addition, if your G Suite plan with Google direct is an annual commitment, switching to us at Interlockit.com as your partner will reset the annual contract start date to the date of the transfer letting you keep the old pricing for another year!

The potential savings of resetting your contract date are huge and there is zero interruption to your G Suite service. It's just a back end billing change. You are never locked in and can return to buying direct from Google after the 1 year is up but we expect you'll enjoy our excellent G Suite technical support team and stay on board with us.

Another great way to reset your contract date and lock in the savings is to upgrade to G Suite for Business Edition at the current $10/user/month or $120/user/year price on an annual contract. Your annual Basic contract gets terminated on the day of the upgrade effective resetting your term and locking in the old pricing for 1 year. Click here for the G Suite editions overview and a detailed comparison. G Suite Business with Team Drives and Unlimited Storage is giving our customers freedom from traditional Windows file shares and other non-integrated, non-cloud storage solutions.

Currently G Suite Basic on an annual plan is $50/user/year and G Suite Business is $120/user/year. These prices will increase to $72/user/year and $144/user/year respectively on April 2, 2019

Interlockit.com can save you $22 USD/user on Basic and $24 USD/user on Business Edition for 1 year. The savings on Canadian Dollar (CAD) G Suite plans can be even higher!

Contact us at Interlockit.com to learn more about what your cost savings could be.

G Suite Calendar Interop: share free/busy data between G Suite and Office 365!

Google has recently released a new version of Calendar Interop which includes the much-anticipated support for Office 365. In light of this--as well as the old version being deprecated--we have run into a few clients that found the available instructions a bit hard to follow.

That's where Interlockit.com comes in to save the day! We're getting straight into the technical details in this post, so put on your geek face and pour yourself a fresh coffee before jumping in.

Prerequisites!

• Access to a G Suite Super Admin account.
• Access to an Office 365 Global Admin account.
• One spare G Suite license to use as a role account.
• You will need to know how to connect to Exchange Online Powershell and run simple powershell commands.
• Users must not have matching accounts in both G Suite and Office 365; both systems will prioritize internal users and ignore Calendar Interop if an internal user is found during lookup.

Create role account

In order to facilitate sharing of calendar information between your G Suite and Office 365 tenant, a role account must exist on each side.

On G Suite

• Sign into your Google Admin Console and go to the Users section.
• Configure a new regular user account (no admin privileges) with an email address of your choosing. I recommend “interop@yourgsuitedomain.com”.
• It is recommended this account be used exclusively for calendar interop.
• Go ahead and set a permanent password right away and keep it ins a safe place. We will need to log in to this account to complete steps later in this guide.

*tip: leave the Admin Console open until you have completed this guide, as you will need it in following steps.

On Office 365

• Configure a new mail-enabled user (no additional privileges) using the New-MailUser cmdlet in Exchange Online Powershell. Example:
  
  New-MailUser -Name "Calendar Interop" -ExternalEmailAddress interop@externaldomain.com -MicrosoftOnlineServicesID interop@your365domain.com -Password (ConvertTo-SecureString -String ‘yourpassword' -AsPlainText -Force)

• The name can be anything, so be descriptive.
• This email address must not exist in Office 365 as a user or contact. The role account shouldn’t need to receive mail, so it doesn’t really matter what address you use here.
• This email address must use an accepted domain in Office 365. This address will not accept mail, but behaves like the user ID for the role account on your tenant.
• Set any password you like. It must be within ‘single-quotes’.
• It is recommended this account be used exclusively for calendar interop.

*tip: leave Powershell open until you have completed this guide, as you will need it in following steps.

Create an Office 365 availability configuration

In order to give our Office 365 role account the ability to feed free/busy data to G Suite, we must create a new availability configuration and assign it to the role account using the New-AvailabilityConfig cmdlet in Exchange Online Powershell:

New-AvailabilityConfig -OrgWideAccount “Calendar Interop”

Make sure you use the same name in quotes used when first setting up the Office 365 role account.

Configure the G Suite admin console

• Sign into your Google Admin Console and navigate to Apps > G Suite > Calendar
• Scroll down and expand the “Calendar Interop Management” section.

• Fill in the Exchange Web services URL for Office 365:
  https://outlook.office365.com/ews/exchange.asmx
• Enter the Exchange role account’s user ID (in our case, interop@your365domain.com).
• Enter the Exchange role account’s password.
• Check the box for “Enable user availability lookups”.
• Click “SAVE CHANGES”

Add the availability address space in Office 365

• From your G Suite admin account, open Google’s Credential Generation Tool. Check the box, and click “Generate new credentials”

• When prompted, sign in with the G Suite role account you created earlier. It will ask for permission to access calendar data. Click “Allow”.

• Click “Download”, and save the credentials.dat file somewhere safe--you will not be able to retrieve this file again in the future without breaking the setup, requiring you to repeat all the steps in this section.

• Open the Configuration Tool

• Click “Choose File” and select the credentials.dat file you downloaded in an earlier step.
• Select “Exchange 2013 or newer, including Office 365”
• Enter the user ID of the Office 365 role account, in this example we are using “interop@your365domain.com”
• Enter your G Suite domain in the field asking which address space you wish to add to exchange. In this example we are using “yourgsuitedomain.com”.
• Click “Show Exchange Setup”.
• You will be presented with the following page:

• Copy-paste the above section of green text into Exchange Online Powershell. You may need to hit “Enter” once each command completes, until all the commands have been run.

Create contacts for your G Suite users in Office 365

In order for Office 365 to display the free/busy data for a G Suite user, that user must be represented as a contact in the Office 365 system:

• You can add contacts manually in the Office 365 Admin center under the “Users > Contacts” section.
• You can use Exchange Online powershell to do bulk updates of contacts if needed.

You’re all set!

Now you can create a test event in a G Suite user account and an Office 365 user account respectively, to test that each are able to see the free/busy indicator of the other.

*tip: it may take a few hours for the Exchange Online settings in Office 365 to propagate, so if your initial tests don’t work, wait a few hours and try again before taking troubleshooting measures.

Google provides a Troubleshooting tool but it is limited in functionality. If you get lost, give me a shout over at Interlockit.com and we'll get you sorted in no time! Now, don't you feel like you deserve another coffee?

Here's an even beefier tier of G Suite!

Most of us know that G Suite is offered in two tiers; Basic and Business. Announced January 31st of this year, G Suite is now available at a premium level; G Suite Enterprise. Here's a quick breakdown of the respective tiers:

G Suite Basic is a professional office suite of collaborative productivity apps that offers your business professional email, shared calendars, online document editing and storage, video meetings, and much more. Basic is offered at $5 per user per month.

G Suite Business is the enhanced office suite. In addition to everything available in G Suite Basic, it includes unlimited Google Drive storage and Google Vault for everyone in your organization, plus additional Drive administration, auditing, and reporting features. Business is offered at $10 per user per month.

G Suite Enterprise is the new premium office suite. In addition to everything available in G Suite Business, it includes advanced administrator controls and customization features. Enterprise is offered at $25 per user per month.

Although many small to medium sized business may not consider the Enterprise tier, it's a value-packed and full-featured version of G Suite from all angles. To start, administrators on an Enterprise subscription get the following abilities:

• Add another layer of protection to prevent sensitive information from being revealed to those who shouldn’t have it. 
• Scan email traffic for specific content, such as credit card or social security numbers, and set up policy-based actions when this content is detected.
• Identify and mitigate loss of confidential data in scanned images. 
• Use a third-party archiving product to store and discover mission-critical email. 
• Analyze Gmail logs using advanced and customized queries. 
• Require a security key to sign in to G Suite Enterprise. 
• Enhance email security by enabling S/MIME encryption. 
• Use dial-in phone numbers for Google Hangouts/Meetings (gives each meeting a dedicated dial-in phone number).

Google extending DLP (data loss prevention) to Google Drive, making it even easier for admins to secure sensitive data, control what content can be stored and protect users from accidentally sharing confidential information externally.

In addition to these administrative features, Enterprise users get data loss prevention for Gmail and Drive to prevent leakage of sensitive data, such as credit card numbers, via emails or Drive. Users can set up policy-based actions to notify the admin, add warnings to message headers, or block emails from being sent when sensitive content is detected. Over 50 detectors for sensitive content matching are available with custom rules to provide warnings or block sharing. Enterprise also allows you to integrate Gmail with third-party archiving tools to help you meet complex email compliance requirements; this goes beyond archiving with the Google Vault service. These are definitely premium features but one of our favourite's is the ability to use dial in numbers for Google Hangouts/Meetings so team members on the road can feel connected and productive in meetings despite wi-fi or data issues.

The new tier is definitely great for businesses, but is also ideal for Education, Government, and even non-profits. With the new Enterprise tier, Google brings all of the great services from it's other G Suite tiers, along with a few new ones of it's own, to really meet the needs of organizations that require the above and beyond. Find more details on Enterprise here: https://gsuite.google.com/solutions/enterprise/. 

InterlockIT is pleased to announce that Google is now offering discounts of up to 40% on upgrades to Enterprise for existing G Suite Basic and Business customers (some conditions apply). This offer is valid until June 30, 2017, so hurry up and get in touch with us today to learn more!

G Suite Series - Google Drive

Data - it's everywhere. Files, folders, documents, spreadsheets, presentations and many more kinds of data exists so that we can reference, log, and share our work. There's no doubt that it's what empowers businesses to grow. It's a crucial element of business and takes lots of time to create and gather. We work hard to acquire it, so shouldn't we invest in protecting it and have easy access to it?

As a business grows, it becomes an increasing challenge to scale storage and sync all that data. With this increasing challenge, more and more companies are beginning to understand the value cloud computing has to offer. Whether you're on Dropbox, Box, Microsoft's OneDrive, or even your own Windows file server, you are using a storage system designed to compile your data in one place. Not all storage systems are equal.

Google, the cloud champion, has it's own cloud storage solution to keep all your work in one secure place; Google Drive.

It's one of the most powerful tools available for businesses today to effortlessly store, share, and sync files. If you use G Suite's Docs, Slides, and Sheets, lucky you! You've got the perfect solution for easy collaboration and file/folder management.

Google understands that businesses need efficient, collaborative and scalable tools that will actually make work easier. There's no better example of this than Google Drive. Here are a few incredible ways it can add value to your business:

Get as much storage as you need: With G Suite Basic, 30 GB of storage per user shared across Drive and Gmail means plenty of room for your data, and you can purchase additional space as needed. If you're not sure how much data you'll need, opting for G Suite Business will give you truly unlimited storage. You'll never have to think about low storage problems - use as much as you want! Can't decide which G Suite tier is right for you? Check out our comparison post.

Sync files with your computer automatically: You can choose to sync all or some of your files to a designated folder on your computer. Any changes you make locally are automatically mirrored in Google Drive, and vice versa. I behaves just like your local hard drive but with the piece of mind that everything is replicated securely in the cloud and everyone can see the up to date version.

View files without buying additional software: Need to open a file but don't have the right software installed? That was the old way of doing things. Now Drive lets you view over 40 of the most popular formats including videos, images, Microsoft Office documents, spreadsheets, and PDFs. You can upload any type of file to Google Drive and even convert certain types to a web-based Google document format like Docs, Sheets, or Slides for truly real time collaborative editing.

Google Powered Search: Google is the most popular search engine on the planet, for good reason! Knowing that, you have the most powerful search features built into your data store. Stop the frantic hunt for important documents buried deep in layered folders. Simply enter some keywords to pull up the right file in seconds, even if it's an image or PDF of handwritten notes - that's powerful!

Easy-to-manage sharing controls: Google understands the importance of privacy and ensures your files are only shared with those you want to share with. Keep files private, until you decide to share them. Grant specific permissions to download, edit, comment, or view, avoiding multiple versions and file merging. Google Drive is unrivaled for collaborative document-editing projects.

Third-party applications to extend Drive functionality: There are hundreds of integrated apps available including Pandadoc for quotes/e-signatures,  Slack for enhanced sharing capabilities, and Smartsheet for project management to get things done directly from Drive. You can find more great integrated apps on the Chrome Web Store.

Google Drive is a solid system and many user's will agree that it's possibly the easiest file storage solution to set up and use. Compared to Microsoft, in mobile online storage, "Google Drive bagged nearly 10 times the number of monthly-active users than did Microsoft's OneDrive: 47 million to 4.9 million" according to Computer World.

Already have a G Suite domain but aren't partnered with a Google Cloud Partner? Here's why you should! Contact us today to learn more about how G Suite can improve and add incredible value to your business!

Why you should use a Google Cloud Partner!

More than 5 million businesses use Google's collection of productivity apps known as G Suite (formerly known as Google Apps for Work) and over 5,000 businesses sign up every day. With such a large and growing user base, Google relies on partners like Interlock IT to provide customer relationships and expertise, personalized outreach, and a broad range of services to users. Partners like us also provide essential services that allow users to take maximum advantage of G Suite, ease their initial setup and assist with migration, customization, and the general user experience.

Our team at Interlock IT helps companies move to the cloud to streamline productivity, user experience, and cost. As a G Suite reseller we manage hundreds of global G Suite customers and are occasionally asked what the benefits are of partnering up with a reseller. There are many reasons why it's useful--and in many cases better--to have a reseller manage your G Suite domain. Here are just a few:

Data Migration and Deployment
As the first Canadian Premier Google Apps Partner, Interlock IT has a highly experienced and dedicated team to lead your transition to G Suite. Our deployment team addresses all migration needs, including deployment, integration, and adoption. Our team is here to ensure that your business has a smooth and seamless transition without any downtime or data loss. All data from legacy systems are safely transferred with utmost care. In our almost seven years of moving hundreds of customers to G Suite, we have not once experienced a lost email or file - you're in safe hands!

G Suite Integrated Add-ons
With our large customer base we have lots of hands on experience with G Suite integrated add-ons to cover your needs in any situation. Need to manage leads, contacts, and drive sales results with Solve CRM or Copper CRM? Want to replace your on premise accounting solution with Xero? Need time sheets, expense reporting, and online/automated credit card billing with Freshbooks? There is a wealth of 100% web browser based cloud software solutions available that deeply integrate to G Suite, eliminating separate login/passwords, and much more.

Support
Although G Suite includes free Google support, Google support reps are unfamiliar with your company and business needs. Compared to Google support, our smaller and agile team understands and builds rapport with our customers on a deeper level, maintaining a healthy customer relationship to quickly and efficiently resolve tier 2 support issues. We're a simple phone call or email away and can even submit/escalate support requests to Google on your behalf accordingly so you can focus on running your business.

Training
Many businesses don't leverage the full potential of G Suite until their users have received adequate training. With our engaging G Suite training sessions, we can demonstrate the features and best-practices of the Google experience. Our G Suite Certified Deployment Specialists stay up to date with the latest improvements and upgrades to provide a wide range of rich content training for all G Suite applications including Gmail, Calendar, Docs, Sheets, Slides, and Google Drive. For businesses that prefer to maintain their own infrastructure, we also train IT administrators on Google's Admin console for fine-grained admin controls, audit reports, eDiscovery, and custom application development.

Custom App Integration
Every business has its own unique needs, and in some cases the out-of-box solution doesn't cover all the bases. Our team has ample experience with designing and integrating custom applications with G Suite. For example, Blink Reports is a product we created to bridge the gap between Google Sheets and Xero to allow Xero customers to build financial reports, charts, and virtual dashboards connected to their live Xero data. Need standardized signatures? Need to synchronize G Suite users with your school administration system? These are just a few examples of solutions we've custom built for our customers. If there's a cloud application that your business needs to integrate with G Suite, our team is ready to design and deploy it!

Among the many advantages, these are a few key benefits of running your business with a Google Cloud Partner. With a reseller like InterlockIT, you're not only getting powerful world class collaborative G Suite tools, you're also getting many years of experience providing cloud-consulting, on-going technical support, and domain management. Contact us today to purchase your G Suite subscription with InterlockIT! It's quick, simple, and you'll thank yourself later!