(Deprecated) Manage, edit, back up Google contacts

Documentation •
In this article

Deprecated commands and functionalities

Attention: Google has deprecated the Contacts API used by Banana to access and modify contact data.
The new People API replacement has different purposes and functionalities.
The reading and modification of Google contacts will therefore be available ONLY UNTIL Google keeps the Contacts API in service. After that the synchronization commands will give an error. The data saved in the AC2 file will still be accessible. It is not known how long the Contacts API will still be available. Please do not use these features anymore.

Documentation

Download, view and edit your Google / Android address book contacts in a tabular format. You can update and clean contacts much faster and also print, copy and paste them into Excel.  You can also save the contacts file to your computer as a backup copy.

Addresses, Contacts table

Manage Google contacts

  1.     File->New command creates a New Empty Address Book.
  2.     Menu->Actions->Google Contacts->Download Changes.
    • You will be asked to authorize access to the contacts.
    • The Contacts table will be filled with your contacts.
  3. Edit and update the contacts as you like.
    • Menu->Data->Column Setup let you also make visible all predefined  columns, like Organization Name, Organization Title.
  4. Menu->Actions->Google Contacts->Send Changes.
    The local changes will be saved in Google.

For more information see the explanations below.

Authorize access to your contacts

Synchronizes the contents of your Banana file of the Address Book and Addresses type with the contacts of your Google account.

The first time you issue the command Download and replace existing contacts from the Actions-> Google Contacts menu, to connect to your Google contacts:

  • A window appears that displays a page of the Chrome browser integrated in Banana and asks you for your Google login.
  • You have to enter the email address and password of your Google account.

Banana only saves the email of your Google account: the session data and the password are not saved in Banana, but are managed by the mechanism of your browser.

Google Login

 

Immediately afterwards you must confirm that the Banana software can access and modify your contacts.

Google authorise

Synchronization commands

Download changes

This function imports data from Google and updates the values in Banana.

  • If there is already data existing in the table, the program will merge the various data in the tables
    • Groups.
    • Contacts.

Send changes

Send modified data in Banana to Google, updating your Google contacts.

  • To be able to send data to Google, you must have previously downloaded it at least once.
    If you have made changes on your mobile, you have will have to first download the data and then activate the command Send Changes.

A window with the elements modified, added or deleted will display.

importing addresses Google

It is not recommended to use the "GoogleNoSynchronize" column because it will no longer be used in subsequent versions. If Yes, the contact will not be synchronized with Google.

Download and Replace existing contacts

Banana will not always be able to synchronize all changes.
This command will delete the contacts in the Contacts table and replace them with the existing Google contacts.

This command will also delete items marked as "GoogleNoSynchronize"

Conversion of values in the table

Google contacts manages addresses, phone numbers and e-mail in a structured form. In the Contact stable, the data are instead managed via the column.

Telephone numbers and e-mails

Google allows you to define different e-mails and phone numbers. For each one a label and an indication by default is designed.
In Banana you must follow these directions:

  • If there are different types of telephone or e-mail, you will indicate them in the appropriate column (work, home, other).
  • If for each type there are several telephone numbers or e-mails, indicate them in the column, separated by a semicolon ";".
    Telephone work "+1234567890;+21234567890". E-mail work "example@gmail.com;example@yahoo.com"
  • If the phone number or e-mail has a particular label, it will be indicated in the Other column, with the label followed by a colon ":".
    If there are several numbers, separate them with a semicolon ";"
    "Holidays:+1234567890*;Cousin:+1234566777". "Temporary:example@gmail.com;Mama:example@yahoo.com"
  • To indicate that the phone is a number by default, mark it with an asterisk "*" after the number.Between the different numbers there can be only one default number.

Addresses

Google allows you to have multiple addresses for the same contact.

Banana Accounting instead allows to synchronize only one address, the "Home" being main one.

Groups

Groups defined in Google are imported into the Groups table and new ones can be added as well.

In the Group Id column of the Contacts table you can insert multiple membership groups by separating them with a semicolon ";".

Create a backup of your Google contacts

  1. Create a New empty Address Book file.
  2. Utilities1 Menu  -> Google contacts -> Download changes.
  3. Save the file on your computer with the day's date in the name.

Manage your Google address contacts

If you have multiple addresses in your address book, it will be easier to use the Banana address book to sort out your addresses. You can quickly correct errors, add information and remove duplicates and much more.

  1. Download data from Google contacts
  2. Effectuate your changes
    Remember that the F6 key (Mac Cmd-6) has several features (see the Info window below).
    In the Name and Surname column, invert the values.
  3. Hit the Send changes command button to send the changes to Google.

Archive and remove contacts that are no longer used 

You can save phone contacts that you no longer use on your computer and delete them from your phonebook.

First time:

  1. Create a new Address Book file.
  2. Utilities1 Menu-> Google Contacts-> Download Changes.
  3. Save the file in your documents, "Folder_Philip_donotcancel_ever", so you remember that it is an important file.
  4. Display the Archive view in the Contacts table
  5. In the Archive date column, insert the current date (type the dot ".") for all contacts you no longer require
  6. Utilities1 Menu -> Archive data -> Archive Table data -> Contacts.
  7. Utilities1 Menu-> Google Contacts -> Send Changes.
    Your data will be deleted from the address book.
  8. Utilities1-> Archive data -> View Archived data-> Contacts will allow you to access your archived contacts.
    If you want to add them back to your directory, you must copy the line in the Contacts table and delete it from the Archives.

Safe-keep your file. Proceed as follows if you wish to archive unused contacts:

  1. Open your Address book file.
  2. Utilities1 Menu -> Google contacts -> Download changes or if there are problems Download and replace existing contacts
  3. Proceed as indicated above in the Archiving and Sending Changes procedure.
  4. Save the changes.

Resume data in Excel

  • Download data from Google contacts.
  • Select all (upper left corner button)
  • Copy
  • Paste into Excel.

Synchronization problems and suggestions

The Google address book offers many possibilities and can be used in very different ways. We have tried to make it work better for you , but there may be situations where the program might experience problems with the changes that have been made.
If this is the case, it will be necessary to use the command function. Download and delete existing contacts, to completely realign the two archives.

We are obviously interested in continuously improving the functioning of our software, so send us an e-mail describing the problem and show us how to replicate the problem on our computers. This will allow us to fix the problem.
Any suggestions on how to improve the product are always welcome.

For technical details related to the connection, check the Google API documentation.

 

Tell us how we can help you better
If the information on this page is not what you're looking for, is not clear enough, or is not up-to-date, let us know.

Share this article: Twitter | Facebook | LinkedIn | Email