Ixonn Group

User Guides

Google Configuration/ Features

Table of Contents

From version 2.2.0 Google configuration is moved into a separate config tab in Setup->Settings->Google, this will allow a clear overview of all related Google config and features integrated into Ixonn.

In order to start configuring your Google Ixonn related features, you will need to create (in case you don’t have one till now) a project into a Google Developers Console. You can use one project to manage all of your applications, or you can create a different project specific for Ixonn.

Because Ixonn is a standalone application and is installed on your server and you are the data controller and responsible for processing all the data, you will need to configure additional config on the Google Developers Console page.

Prerequisite

Create New Google Developers Console Project

To get started, you need to first use the setup tool, which guides you through creating a project in the Google API Console, enabling the API, and creating credentials.

In most cases, after you create the project with the setup tool, the project will be auto-named My Project, but you can rename it manually to e.q. Ixonn

Generate API Key

Click on the top left sidebar toggle icon then APIs & Services -> Credentials to create new API key.

Click Create Credentials then from the drop-down select API Key

Google Developers Console Generate API Key

Add this API key in Setup->Settings->Google in the Google API Key input field, this will be your Google API key linked to Ixonn that will be used for various features.

Create OAuth client ID

The project OAuth client ID at the time this article is written is used only for the Google Drive Picker feature, if you don’t plan to use the Google Drive picker feature, you don’t need to generate OAuth client ID.

While you are on the credentials page, click Create credentials and then OAuth client ID

Google may ask you to set a product name on the consent screen, in most cases you will see this message “To create an OAuth client ID, you must first set a product name on the consent screen“, click on the right button Create consent screen and fill all the required fields, see below example of the consent.

After you create the consent, save and refresh the create OAuth client ID page, you should be able to start creating the OAuth client ID key as shown below.

In the Authorized Javascript Origins field, make sure that you enter the correct Ixonn installation domain name, or if you have installed Ixonn on subdomain, make sure you add the subdomain as authorized domain name. The Authorized Javascript Origins also should be the same domain name you added in consent Authorize domains area

After you create the OAuth client ID your credentials page should look like the image below.

Google API and OAuth Client ID

You can now copy the client id and add this client id in Ixonn in Setup->Settings->Google->Google API Client ID.

 


Google Features

Google Drive Picker (from v2.2.0)

Prerequisite for this feature is to have already configured in Ixonn Google API Key and OAuth Client ID as explained above.

NOTE: This feature requires verification from Google, see below for more information.

Google Drive Picker is a feature added in Ixonn in version 2.2.0, this feature will allow you to link your staff members Google account and select files to be included in Ixonn directly from your Google Drive, similar feature exists in Ixonn with Dropbox.

Enable Google Drive API and Google Picker API Library

First, you need to enable the Google Drive and Google Picker API libraries in the project you created, to achieve this, click on the top left menu toggle then APIs & Services->Library and search for Google Drive, click on the library and then click Enable then perform new search for Google Picker API and enable it.

Google Drive Library Enable

Enable Google Picker API

Enable Google Drive in Ixonn

The Google Drive feature is disabled by default and can be enabled once you configure the Google API Key, the OAuth Client ID and enabled the Google Drive Library, after ensuring this, in order to enable this feature, you can navigate to Setup->Settings->Google and set Enable Google Picker to Yes.

Authentication Google Drive

Once you enabled Google Drive Picker, navigate e.q. to some area where the Google Drive is available, for example, in this case, we will use the project files Google Drive and click on the right button Choose From Google Drive

Choose From Google Drive

A new popup will be shown to choose your Google account that you will grant access for the application.

App Verification

After you select your account, probably you will see a message “This app isn’t verified“, it’s your responsibility to ensure that the Project/App you created is verified, you can click here to read more how to verify your application, otherwise click on Advanced then Go to [App Name] (unsafe) just to test this feature for your own account.

Google App Isn't Verified

The verification process is clearly explained by Google and includes all the steps for how you can verify your app, as Ixonn does not hold any data for your company, you will need to verify this on your own as you will use the Google Drive Picker.

When Google asks for privacy policy URL, if you have a privacy policy for your main website, you can use this privacy policy or you can enable Ixonn GDPR features and use privacy policy page directly from Ixonn.

Support Features for Google Drive

Currently, Google Drive Picker is available for the following features:

  • Tasks
  • Invoices
  • Estimates
  • Proposals
  • Leads
  • Customer Profile Files
  • Contracts
  • Project Files

Setup Google Calendar

NOTE: This feature syncs your Google Calendar Events to Ixonn calendar. This feature does not sync your Ixonn calendar events with your Google Calendar.
To setup google calendar first, follow these steps.

Prerequisite for this feature is to have already configured in Ixonn Google API Key as explained above.

Enable Google Calendar API

First, you need to enable the Google Calendar API library in the project you created, to achieve this, click on the top left menu toggle then APIs & Services->Library and search for Google Calendar API, click on the library and then click Enable.

Make your Google Calendar public:

In the Google Calendar interface, locate the “My calendars” area on the left.

Hover over the calendar you need and click the downward arrow.

A menu will appear. Click “Settings and sharing“.

Check “Make available to public” and make sure “See all event details” is selected

Obtain your Google Calendar’s ID

While you are in the Settings and sharing, search for Calendar ID, you will see your Calendar ID. It will look something like “abcd1234@group.calendar.google.com

Copy the calendar ID and add the main calendar ID for your company in Setup->Settings->Google in the field Calendar ID


Setup Google Calendar for departments

Create a new calendar in the Google Calendar interface and get the calendar ID (same steps as mentioned above). You’ve probably already set up the Google API key in Setup -> Settings -> Google, now navigate to Settings -> Departments and add the Google calendar ID into the Google Calendar ID field for the department you want to set up. For multiple departments, you need to create different calendars in the Google Calendar interface.

Keep in mind that the main calendar is shown to all staff members.

Calendar Debugging

If you experience any problems setting up the calendar you should debug by hitting F12 on the keyboard (or right click inspect element on a browser) to and click console. If any errors are shown will be visible in the console.

Google Calendar API Console Error


Google reCaptcha

First, you need to generate Secret key and Site Key.

  1. Go to https://www.google.com/recaptcha/admin
  2. On Register new site enter Label eq. Ixonn – reCaptcha
  3. Add your domain name
  4. Click Register

Google reCaptcha

Copy the Secret Key and Site Key and go to Setup->Settings->Google->reCaptcha paste in the necessary fields.

Try visiting the admin login the reCaptcha should be visible.

reCaptcha keys are wrong and you got stuck in login?

It is important to configure reCapcha v2 not v3

In case you entered wrong keys and you got stuck in login please read more below.

Common issues here can be:

  1. Copying the keys with blank spaces, make sure that there are no blank spaces.
  2. Copying the keys with additional text around this key.
  3. The reCaptcha keys not existing in your in your google reCaptcha account.

Disable reCaptcha from phpmyadmin

  1. Login to cPanel.
  2. Go to phpmyadmin and select the database that Ixonn is using.
  3. Go to table tbloptions and by clicking on the top search phpmyadmin button do the following searches for the column name
    1. recaptcha_secret_key
    2. recaptcha_site_key
  4. Set the values on both rows empty.

Customer Map

Customer map is a feature used in the admin area and once you set up this feature for customer each time when you need the customer company location you can navigate to this customer profile and click on the Map tab.

To use this feature first you need to have properly configured Google API Key in Setup ->Settings->Google and in Google Developers Console make sure that you have enabled Geocoding API for the project you have created, to achieve this, click on the top left menu toggle then APIs & Services->Library and search for Geocoding API.

This feature works with Google Map Latitude and Longitude. Get the Latitude and Longitude from google map and insert into the customer profile.

Google Geocoding API Library

Related Articles

111238