Addressbook

Contact information panel

The addressbook is a very powerful tool to manage contacts. It's very easy to share addressbooks with other users. Some default addressbooks (Customers, Prospects and suppliers) have been created. They are shared with the default group "Internal".

At each contact you can create linked items like tasks, appoinments, files, notes etc. as you can see in the Contact information panel screenshot. The latest links are shown immediately. To browse and manage all links of the contact, click at the "Links" button.

Sharing an addressbook

To share an addressbook with other users or user groups two things need to be setup. The user must have access to the addressbook module and to the addressbook. To setup the permissions for an addressbook go to :

Addressbook -> Administration -> Double click addressbook -> Permisssions.

Here you can add the users and user groups you want to grant access. Read more about managing permissions here.

If you want to create a global shared addressbook it is recommended to add this addressbook as the "admin" user so it won't be deleted along with a regular user when this employee leaves the company for example. This is a very common mistake.

Importing contacts

The addresbook can import contacts from another application. To import contacts you will have to export contacts to a comma seperated values file (*.csv) or a vCard (*.vcf) file from the other application first. Consult the documentation of that application on how to do this.

If you made a CVS file then you goto:

Addressbook -> Administration -> Double click the addressbook -> Import

Select the CSV file and click at 'Ok'. The address book file you have selected will be scanned for columns containing data. You can then select which columns from the old program should go to which columns in the Group-Office addressbook.

After clicking on 'OK' your address book will be filled with all the data from the addressbook file. If you open the new addressbook you will see that it has been filled with all the exported contacts information.

Note: Group-Office uses separate companies and contacts. If you are importing Companies and contacts separately it's wise to import the companies first. Group-Office will attempt to find an existing company to link to the contact. If it can't find a matching company it will create a new empty one. So if you import contacts first and after that the companies, you will end up with duplicates.

Tip: If the fields in your CSV file match the column names in Group-Office (Look at a Group-Office export for reference of these names). Then Group-Office will match the fields automatically and will save you from matching the fields each time.

Exporting contacts

It is also possible to export the group office address book to a Comma Seperated Values (*.csv) or vCard (*.vcf) file, you can either export Contacts or Companies. This process creates a file which can be used as a backup, to send it to a colleague for example or import it into another program.

To export an addressbook go to:

Adressbook -> Administration -> Export

Document merging for sending paper letters

To create a merged document to send a letter by regular mail you need to make an export to CSV first and then use that as a datasource for OpenOffice.Org or Microsoft Word.

Document templates

You can create document templates for OpenOffice.Org and Microsoft Office 2007 and up in Group-Office. This way you can have a document template filled with data from the addressbook automatically. To create a template use OpenOffice.Org or Microsoft office to create a new document and upload it at:

Addressbook -> Administration -> Templates -> Add document template

You can use the following values in the document:

Testing fields For testing you can simply add these tags:

1. {event}
2. {contact}
3. {company}
4. {note}
5. {project}

They will show you which tags you can use.

Custom fields

You can use custom fields like this:

{project:Custom field category:Custom field name}

{contact:Custom field category:Custom field name}

{company:Custom field category:Custom field name}

Common fields

{date} Current date

Fields of the logged in user:

{my_name}

{my_first_name}

{my_middle_name}

{my_last_name}

{my_initials}

{my_title}

{my_email}

{my_home_phone}

{my_fax}

{my_cellular}

{my_address}

{my_address_no}

{my_zip}

{my_city}

{my_state}

{my_country}

{my_company}

{my_department}

{my_function}

{my_department}

{my_work_phone}

{my_work_address}

{my_work_address_no}

{my_work_zip}

{my_work_city}

{my_work_state}

{my_work_country}

Fields of the contact / company:

{salutation} The salutation

{beginning} Dear sir / madam

{first_name} First name

{middle_name}

{last_name}

{initials}

{title}

{email}

{home_phone}

{fax}

{cellular}

{address}

{address_no}

{zip}

{city}

{state}

{country}

{company}

{department}

{function}

{work_phone}

{work_fax}

{work_address}

{work_address_no}

{work_city}

{work_zip}

{work_state}

{work_country}

{work_post_address}

{work_post_address_no}

{work_post_city}

{work_post_zip}

{work_post_state}

{work_post_country}

{homepage}

Project fields

{project:name}

{project:customer}

{project:description}

{project:ctime} Creation time

{project:mtime} Modification time

{project:status}

{project:type}

{project:start_time}

{project:due_time}

{project:units_budget}

{project:responsible_user_name} The manager

After you created the document go to:

Addressbook -> Manage templates -> Add Document template

Enter a name for the template and click at browse to select your document.

Click at 'Ok' to save it.

Now lookup a contact, company or project and click at:

New -> Document from template -> Select the template if you have more then one.

callto: links

Group-Office generates callto:+123456890 links for phone numbers. You can customize this link by putting this in your config.php for example:

$config['callto_template']='callto:{phone}+type=phone';

If you need to pass additional variables to a script that handles the call you might want to create a custom script to handle that:

You could create a custom php script in GO:

callto.php:

<?php
require('Group-Office.php');
header('location: someothercalltoscript.php?callto='.$_GET['phone'].'&user='.$_SESSION['GO_SESSION']['username']);
?>

Now just put that script in the calllto_template:

$config['callto_template']='callto.php?phone={phone}';