Showing posts with label Google Calendar. Show all posts
Showing posts with label Google Calendar. Show all posts

Tuesday, July 2, 2019

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. Headers.PNG (553×528)
  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.


Tuesday, January 9, 2018

Achieving weight loss and fitness goals with technology

I love crafting business solutions and making software integrate seamlessly for our Interlock IT customers, but it's even better when those solutions can be leveraged to help with personal goals like weight loss and fitness.

Hopefully this post can help you achieve your weight loss and fitness goals by using technology to integrate daily activity level, exercise, and calorie tracking. Did you know that you can even sync your Polar Training Results and Training Targets into your G Suite for Business Google Calendar? This is a great example of IOT (Internet of Things) where multiple devices and software can work together elegantly.

Background and issue

I've been running consistently for 3 years, despite experiencing every pain imaginable as I adapt my lifelong computer nerd body to running.

One of my issues was being very hungry after a Sunday long run and knowing that I needed to eat some extra calories to refuel. What I didn't want to do is overeat and negatively impact my weight loss for the week. A fitness tracker live integrated to MyFitnessPal is a perfect solution to know how much to refuel and still achieve your weight loss goals.

Beginner tips

I recommend that beginners start with a couch to 5K program like C25K. I started with Runtastic and a Wahoo heart rate monitor in May 2015 which has similar beginner walk/run training programs. In fact, I've learned that easy slow running and keeping my heart rate below 130 for the majority of my training is a key to avoiding overuse injuries, consistently enjoying running, and race success. The hard push to 5K I used to do in University was inefficient and uncomfortable, and took the joy out of the sport.

My 2018 Goals

  • Lose 10 to 15 pounds of weight by April 30th
  • Beat my half marathon personal record (PR) of 1:38:14
  • Complete my first full marathon
I completed my first half marathon and set my PR in May 2017. This November 2017--despite sticking religiously to the Polar half marathon training program--I failed to set a new half marathon PR partly because I gained some weight. Losing ten pounds saves a whole minute on a 5K and almost nine minutes on a full marathon. You can see all my PR's and running stats on Strava

My Technology Solution for fitness and calorie tracking

MyFitnessPal

Setup and Configuration

The screenshots and setup below are specific to integrating Polar devices with MyFitnessPal but do some homework and you'll see that Garmin watches, Fitbits, Apple Watches and more can integrate your daily activity and training to MyFitnessPal too.


Connect Polar Flow App to MyFitnessPal

  • On your smartphone open the Polar Flow App, Settings, and toggle on Connect MyFitnessPal. Follow the prompts to login and Authorize Polar to read and write to MyFitnessPal.
  • Note that you can integrate your Polar Training Results and Polar Training Targets to your G Suite for Business or personal Google Calendar with the two toggles in the Polar App Settings (this setting is only available in the Polar Flow smartphone App).
  • Alternatively, you can configure the MyFitnessPal integration via your web browser. Open https://flow.polar.com/settings, click the Connect button for MyFitnessPal and follow the prompts.

  • Next, inside MyFitnessPal on the web turn on Polar Flow Step tracking via the menu bar Apps, Steps. This means both exercise tracked and your steps for the day will be included in the "Exercise" Calories of MyFitnessPal:

Usage

Once Polar Flow is integrated to MyFitnessPal you should see "Exercise" automatically updated in the MyFitnessPal App and on the web from Polar Flow:
The data in the screenshot above shows my daily target of 1500 calories not including exercise; my food logged so far today after my lunch and afternoon snack of 1146; and my calories burned from exercise and steps of 520; leaving 874 calories to eat for my dinner and evening snack. The 1500 calorie target may see too low but remember that this is before exercise and steps (plus, I'm a small guy).

The exercise calories of 520 consists of my run, stretching, and Polar's estimate of my steps for the day:

Tip: Be careful not to eat the example 195 calorie "Polar Flow Calorie Adjustment" on workout days. It assumes that you'll achieve your Polar tracked daily goal of 100% or about 10,000 steps in addition to your workout so it can be overstated on your workout days. Throughout the day you'll see it change based on actual steps whenever your Polar watch syncs to the Polar Flow App. If you review the prior day "Adjustment" calories for the first while you'll get a better feel for how your activity impacts the adjustment. The next day (after a morning sync from your watch) is it adjusted to actuals and the calorie adjustment can even go negative (if you enable this setting in MyFitnessPal) to account for a low level of activity outside of your workout recorded.

Your Progress/weight is also updated automatically from Polar Flow to MyFitnessPal by either using the Polar Scale or by manually updating your weight in Polar Flow on the web in Settings: https://flow.polar.com/settings. You could enter your weight in MyFitnessPal directly but updating it in Polar Flow helps keep its calorie burn calculations more accurate and updates MyFitnessPal anyway.

Conclusions

Just like we can integrate cloud software for our business customers you can integrate your consumer devices into your Google Calendar, MyFitnessPal, Strava, and more to take advantage of each product's unique strengths. With cloud based solutions of today, integration is easy and reliable. Long gone are the days of running complicated unreliable synchronization software on your desktop computer just to get emails on your Blackberry or Palm device, yet many small businesses still suffer through similar headaches with their business software and email systems.

Contact us today at Interlockit.com and let us remove your IT headaches and software integration challenges!

Thursday, April 6, 2017

An easier way to login to G Suite

Google is soon rolling out a noticeable update to your sign-in page to give you an improved experience to securely sign in to your accounts. The purpose of this new design is to make browser sign-in flows consistent across computers, phones and tablets. Here's what it will look like on your desktop:
We find some G Suite users complain about an inconsistent login experience via multiple devices, especially if they aren't using a third party SSO (single sign-on) utility. Google heard the complaints and in addition to the improved aesthetics, the new Google sign-in page will remove the “Stay signed in” checkbox that at certain times appeared for G Suite customers. This checkbox has been the source of much confusion so removing the checkbox will enable users to remain signed in unless they specifically sign out. It's always recommended to use a private browser (incognito) window when using shared or public devices.
Users using a third-party SSO provider to access Google applications, such as Gmail, Calendar, Drive, etc., will not see any differences apart from the newly designed Google Accounts login page.

Users using a third-party SSO provider to access third-party applications will see an additional account selection page when they log in. This page will clarify which account they’re authenticating, as well as the permissions they’re granting to applications. All third-party SSO providers, including Active Directory Federation Services (ADFS) SSO, will use the new Google Accounts login process.
All G Suite users will be shown the account selection page, before or after being redirected to the third-party application, depending on whether they’re already signed in to their browser and the specific third-party application they’re accessing. It's important to note that after being prompted to confirm the correct Google account and granting the requested permissions upon initial login, only the account selection page will be shown again upon subsequent login attempts. Existing G Suite users who use Google as their identity provider, will not be affected by the changes and will only see the redesigned Google sign-in page.

Removal of an account from the sign-in page is easy, this can be done from the account selection page by clicking the “Remove an account” link.
Hopefully this will assist in resolving issues for G Suite users on multiple devices and users who use an SSO utility. The update will rollout on Monday, April 10, to a small set of users and will ramp up slowly over the course of several weeks. Additional details about this update can be found on the Google support page.

Get in touch with us today to learn more about G Suite and how it can make your business processes faster, safer, and more efficient!