The address book is a very powerful tool to manage contacts and organizations. It’s easy to share address books with other users.
The address book module supports:
Import and export¶
You can import and export a Comma Separated File (.csv) or a vcard (.vcf).
These functions are accessible via the more menu in the toolbar above the grid:
Any format can be imported as long as the required columns are available. After selecting the file a dialog will be opened where you can match the fields:
When the column names match the name of the Group-Office field name or label it will be mapped automatically.
Some fields like e-mail addresses or phone numbers can have multiple values. They must be in a single CSV column but separeted by 3 colons (:::).
name,email,emailType John,email@example.com ::: firstname.lastname@example.org, work ::: home
Each address books can have groups. They’re useful for organizing your address book.
Advanced search syntax¶
Next to Custom filters you can also use an advanced search syntax in the address book search bar.
If you enter a string of text it will search through the name and debtor number fields by default. But you can also search on other fields. For example:
modified: > -1 week
Will show all contacts that have been modified in the past week.
age: > 30 age: < 40
Will show all contacts with an age between 30 and 40.
birthday: < 1 months
Will show all contacts with a birthday coming up within one month.
Will show all employees of the organizations Intermesh and Group-Office
You can use these fields:
- org (Organization name)
- createdat (date)
- createdby (User’s display name)
- modifiedat (date)
- modifiedby (User’s display name)
- commentedat (date)
- age (number)
- gender (M, F or null)
- birthday (date)
- isuser (0 or 1)
- Custom fields By using <databaseName>: query. Lookup the database name in system settings.
String search explained¶
For example when searching for:
name: John Jacks
It will find anything with “John Jacks*”. Because of the automatic wildcards (*) also “John Jackson” will match for example.
If you want to search for a phrase or without wildcards then you can use quotes:
name: "John Jacks"