Description

{gdata id=|oI1w3djF0e4|} You can integrate Contact Enhanced with Google Docs -> Spreadsheets;

Requirement

  1. Contact Enhanced 2.5 OR newer;
  2. Have configured the form and all the custom fields;
  3. A Google Account;

Usage for Contact Enhanced 3.4.6 and newer

The Google OAuth 2.0 system supports server-to-server interactions such as those between a web application and a Google service. For this scenario you need a service account, which is an account that belongs to your application instead of to an individual end user. Please read Using OAuth 2.0 for Server to Server Applications

  1. Go to the Google Developers Console.
  2. Create a new project. You can give any name to this project, but for the sake of this tutorial use CONTACTENHANCED_YOURDOMAIN, just replace YOURDOMAIN with your domain (without the dots).
  3. In the sidebar on the left, expand APIs & auth. Next, click APIs. In the list of APIs, make sure to enable the Drive API.
  4. In the sidebar on the left, select Credentials.
  5. To set up a new service account, do the following:

    1. Under the OAuth heading, select Create new Client ID.
    2. When prompted, select Service Account and click Create Client ID.
    3. A dialog box appears. To proceed, click Okay, got it.
    4. You will download a P12 Key file.

    If you already have a service account, you can generate a new key by clicking the appropriate button beneath the existing service-account credentials table.

 

 

 

Usage for Contact Enhanced 2.5 up to 3.4.5.1

  1. Download and install the Zend GData Library using Joomla Installer;
  2. Select Components → Contact Enhanced → Contacts from the drop-down menu on the back-end of your Joomla! installation, then Select a Contact the you wish to integrate with Google Spreadsheets;
  3. Set Use Google Spreadsheets to Yes;
  4. Set 'Setup (CSV) file' to Yes, go to the front-end and submit the contact form; This will prompt a window to download a .csv file;
  5. Set 'Setup (CSV) file' to No;
  6. Upload that CSV file to Google Spreadsheet;
  7. Get the Key from the URL. Example:
    https://docs.google.com/spreadsheet

    /ccc?key=0AhFfmwqdmyk4c&hl=en_US#gid=0
    The key is 0AhFfmwqdmyk4c
  8. Get the worksheet name and enter in the Worksheet field;