This documentation is for Live Forms 9.1. v9.1 is a Cloud Only release. Not for you? Earlier documentation is available too.

COVID-19 Response Info: At frevvo, our top priorities have always been employees and customers. We have taken several steps to promote the well-being of our people, to minimize services disruptions, and to help where we can. Visit our website for updates.

Google Connector Release Notes


This page contains the compatibility release matrix supported for the frevvo Google Connector.

frevvo Google Connector VersionLive Forms Server Version
v3.0.4v9.0.10+ and Cloud
v3.0.3v9.0.7+ 
v3.0.2v9.0.7+
v3.0.11Cloud
v3.0.0v9.0.7+
v2.4.1v9.0.6+
v2.4.0v9.0.x
v2.3.21v7.4.0+
v2.3.1v7.3.2+
v2.3.0v7.3.0+
v2.1.1v6.2.3 or later
v2.1.0v6.1.3 or later
v2.0.0v5.3.8+
  1. This version of the connector was released for Cloud only. It is not needed for on-premise installations. 

frevvo only supports/certifies the Google Connector running in the Apache Tomcat container.


v3.0.4 (r01a42d2)

Released 1/15/2020

Version 3.0.4 of the Google Connector is a small bug fix patch release. This version was deployed to the frevvo Cloud on 1/17/2020 (no action required for Cloud Customers.) In-House customers, please refer to our frevvo Software Downloads Directory to download this version of the Google Connector.

Tickets Fixed

  • TIP-27193 - Control names that start with a number, i.e. "_1Name", and control names that differ from another control name only by an underscore, do not save data to that column of the Google Sheet.

v3.0.3 (rf269607)

Released 12/18/2019

Version 3.0.3 of the Google Connector is a small bug fix patch release. This version was deployed to the frevvo cloud on December 18, 2019 (no action required for Cloud Customers.) In-House customers, please refer to our frevvo Software Downloads Directory to download this version of the Google Connector.

Tickets Fixed

  •  TIP-26963 - Google Sheet: A control with an underscore '_' in the name is not getting saved in sheet.

v3.0.2 (rf4ba996)

Released 12/18/2019

Version 3.0.2 of the Google Connector is a small bug fix patch release. This version was deployed to the frevvo cloud on December 18, 2019 (no action required for Cloud Customers.) In-House customers, please refer to our frevvo Software Downloads Directory to download this version of the Google Connector.

Tickets Fixed
  • TIP-27156 - Google Connector returns unexpected results for worksheets that have empty rows and/or trailing empty columns.

v3.0.1 (rff1e9f6)

Released 12/14/2019

Version 3.0.1 of the Google Connector is a small bug fix patch release. This version was deployed to the frevvo cloud on December 14, 2019 (no action required for Cloud Customers.) In-House customers, please refer to our frevvo Software Downloads Directory to download this version of the Google Connector.

Tickets Fixed
  • TIP-27130 - Google Connector v3.0.0 only deals with columns A-Z

v3.0.0 (r3f100ff)

Released 11/13/19

Updated 12/10/19

Version 3.0.0 of the Google connector upgrades the connector to use the v4 Google Sheet API. This version will be deployed to the frevvo cloud in December 2019 (no action required for Cloud Customers.) The connector was released for in-house customers on November 13, 2019. Please refer to our frevvo Software Downloads Directory to download this version of the Google Connector.

On-premise customers using the Google Connector must upgrade to LiveForms v9 and Google Connector v3.0 by February 1, 2020 and no later than March 3, 2020. If you do not upgrade by March 3, 2020, forms and workflows integrated with Google Sheets will stop working. Google Connector v3.0 requires LiveForms v9. We recommend that you upgrade your development environment several weeks in advance in order to ensure a smooth upgrade of your production environment. Click here for more details on upgrading your connector.

Enhancements:
  • TIP-19812: Google Connector uses the new v4 Sheets API and v3 Drive API
Tickets Fixed:
  • TIP-26620: Starting frevvo takes too long (10 minutes.)

v2.4.1 (r4721f0a)

10/12/19

Version 2.4.1 of the Google connector is a small update release. This version was deployed to the frevvo cloud on Oct 12, 2019. The connector was released for in-house customers on Oct. 16, 2019. Please refer to our frevvo Software Downloads Directory to download the compatible version of the Google Connector.

v2.4.0 (rbadac90)

8/17/19

Version 2.4.0 of the Google connector is a small patch release with one bug fix and OpenJDK support. This version was deployed to the frevvo cloud on August 17, 2019. The connector was released for in-house customers on TBD. The Google Connector is included in the frevvo tomcat bundle. Please refer to our frevvo Software Downloads Directory to download the compatible version of the Google Connector.

frevvo recommends that you use this version of the connector with Live Forms versions v9.0.0+ to take full advantage of the improvements.

  • Open JDK Support
Ticket Fixed:
  • TIP-22499 - Connector status pages showing 'rDev' instead of the revision

v2.3.2 (r31128)

Cloud Only: 1/7/2018

Version 2.3.2 of the Google connector is a small patch release with enhancements for our Cloud environment. This version was deployed to the frevvo cloud on January 7, 2018. It was not officially released for in-house customers.

v2.3.1 (r30933)

10/6/2017

Version 2.3.1 of the Google connector is a small patch release with one bug fix and one enhancement for logging and configuration. This version was deployed to the frevvo cloud on September 9, 2017. The connector was released for in-house customers on 10/6/2017. The Google Connector is included in the frevvo tomcat bundle. Please refer to our frevvo Software Downloads Directory to download the compatible version of the Google Connector.

frevvo recommends that you use this version of the connector with Live Forms versions v7.3.2+ to take full advantage of the improvements.

Enhancements:
  • #21645 -  Ability to log messages in JSON format
Tickets Fixed:
  • #21610 - Attachment size limitation on frevvo Cloud causes "Could not POST data to http://google-connector:8080/google/documents/upload/upload. HTTP status 500" error

v2.3.0 (r30698)

9/2/2017

Version 2.3.0 of the Google connector is a small patch release with enhancements for logging and configuration. This version was deployed to the frevvo cloud on September 2, 2017. The connector was released for in-house customers on December 1, 2017. frevvo recommends that you use this version of the connector with Live Forms versions v7.3+ to take full advantage of the improvements.

Enhancements:
  • #21550 - Google Connector logging entries are captured in a separate logfile in <frevvo-home>\tomcat\logs
  • #21136 - Provide the client id/secret information using a property in the frevvo-config.properties file instead of the <frevvo-home>\tomcat\lib\client_secrets.json file

v2.1.1 (r27383)

12/24/15

This is a small patch release. This is compatible with v6.2.3+ releases. 

Enhancement:
  • google.war/web.xml parameter connector.google.http.timeout is a new parameter used to specify how long the frevvo google connector will wait for Google API to respond to a request. This is useful when Google is returning HTTP Error 500 for frevvo form submissions saved to Google Drive (#18808)
Tickets fixed:
  • #17628 - Performance Issues causing concessional rule timeout exceptions and failures performing read/write/update operations on Google Sheets.

v2.1 (r26460)

4/17/15

This is a small patch release. This is compatible with v6.1.3+ releases. 

Tickets fixed:
  • #17816 - Google sheets with + characters in their names or tab names don't work
  • #17848 - Read/Update Google Sheets does not work when password contains special characters such as { } # ? / \ ...
  • #17992 - Read/Update Google Sheets does might not update the Sheet/Tab or might update the wrong Sheet.Tab if multiple Sheets/Tabs have similar names like "Leave Approval" and "Leave Approval (Other)" and the rule references the shorter name like "Leave Approval".

Please also see the Google Connector fixes listed in the v6.1.3 release notes . You must also upgrade your frevvo server software to v6.1.3+.

v2.0 (r26214)

3/10/2015

This is a major update. This is compatible with v5.1.1. patch9, v5.3.8+ and v6.1.2.1+ releases. 

All customers must upgrade their frevvo Google Connector by April 20, 2015. The frevvo Google Connector v1.4 and earlier will stop working on this date. See this Notice from Google.

Features:
  • The frevvo Google Connector v2.0 uses the new Google Drive API. This replace the Google Documents List API v3.0 which Google has deprecated and will no longer support on April 20, 2015 (#16419)
  • Connector status page <frevvo server>/google/info (#16504)
  • Connector health check page <frevvo server>/google/health (#16906)
Tickets fixed:
  • #17389 - No preview available for default form/flow PDFs uploaded to Google drive.

  • #71594 - Upload to Google drive does not work if there is a slash "/" in the form name.

v1.4 (r16835)

9/25/2014

This is a small patch release and compatible with v5.3.5 and later releases. 

Tickets fixed:
  • #16676 - Google SS wizard - error with large number of spreadsheets. See work-around solution.

  • #16829 - Upload to Google Docs creates a duplicate named folder if one already exists rather than adding files to the existing folder.

v1.3 (r24651)

7/27/2014

This is a small patch release and compatible with v5.3.5

This update is bundled with the Live Forms In-house tomcat bundle software download. 

New Features:
  • The frevvo Google Connector wizards are now available for use with workflows.
  • Support for all types of Google Drive accounts:
    • Google for Education
    • Google for Business
    • Gmail

v1.2

GA release bundled with v5.1.x and v5.3.0 - v5.3.4

v1.1

GA release bundled with v4.1.x

v1.0

Initial GA Release.