[ EN ]    [ DE ]    [ NL ] 
kOOL Logo HomeAboutDownloadDocumentation

  The People Module


Users may be assigned four different authorisation stages:

  • View
  • Edit
  • Administer
  • Moderation

Each authorisation stage contains all permissions of the lower stages.


The first stage allows the user to view peoples data, i.e. they appear in the list, but may not be changed or deleted.


The second stage (Edit) allows a user to change the people data, but not to delete it.


The third stage (administer) also allows the user to create or delete people, in addition to viewing and editing, i.e. full access.


In the last stage (moderate) requested address changes can be moderated i.e. applied or rejected.


If the smallgroup module (kg) is installed, four authorization stages are also available for it, they are: Viewing your own (1), Viewing all (2), Editing (3), deletion and creating (4). For more information about the small group module see below.


"Allow this user to moderate group subscriptions for his groups" gives a user permission to moderate subscriptions to groups for which their login has assign rights (2).

Fine Grained User Permissions (Rows)

User permissions may be assigned per login to groups of data, so that e.g. a small group leader can be given permission to view the addresses of their small group members, or to even edit them. Another example is to allow a small group leader, who is also the leader of the tea and coffee team, to view the personal data of his small group members and also to edit the personal data of members of the tea and coffee team. However, he has no access to any other details of people in the database. To achieve this, filters must be created to show the columns the user has access to as follows:

1. Create a filter for the small group and save it as preset “sg1”

2. Create a filter for the coffee team and store it as preset "coffee team".

In the Admin module you can now edit the appropriate Login. In the People section, under “ALL” select 0, under “Level 1” select filter preset "sg1" and for the stage 2 the filter preset "coffee team". We have given the login no permissions by default (Selected “0” under “ALL”), but then given viewing rights to the people in the filter preset "sg1", and edit (But not delete) rights to the people in "coffee team".

The filter presets "sg1" and "coffee team" may now be removed if they will not be needed for filtering people. The permissions will still stay in place as above and are even updated when people are added to removed from “sg1” or “coffee team”. ”

Fine grained user permissions (Columns)

It is possible to define which columns of personal data a particular user may view or edit. To do this, create a preset column filter containing the columns which the user may view. The same, or another filter may be used to limit columns that may be edited. Next edit the relevant login using the Admin module. Under “People” select the appropriate column filter preset for the two stages (view, edit).


NB: To allow all people to be viewed, either set the global access right (Labelled ALL) to stage 1 or higher, or use an appropriate filter preset to make the required columns accessible. This also applies to stage 2 (Edit).

Allow a user to search in all addresses and assign them to his own group

If you restrict a login's access to the members of a certain group and set the option "Addresses added by this user will be assigned to this group" you may also want to allow this login to search in all addresses and assign certain ones to his own group. This is particularly useful for logins that are responsible for certain groups of addresses and are supposed to work on them autonomously.

As soon as all these options are set this user will find a search box in his people module that allows him to search in all addresses and assign one to his own group. Such an assignment can trigger a notification email to a supervisor if you wish so. The global option "Send notification email if a user assignes an address to his own group" in the settings for the people module allows you to define such an email address.


kOOL may be used to group people into families. This makes it possible for example to send a mail merged letter to each individual or a single letter to the whole family. Each member of a family may be assigned a family role (Husband, wife or child). This enables the system to automatically calculate the number of children in a family. A further advantage of grouping people by families is that the address needs only to be changed once for the whole family, rather than once per person. Fields such as the address are stored once in the database for the whole family. They are marked with a family icon in the “edit person” screen. Therefore any change to one of these fields for one family member will also be made for every other member of the family.

Clicking on the plus sign next to the surname brings up the family options. The first option allows this person to be assigned to another family using the drop down list. If for example a child leaves home, "none" may be selected, to show the person no longer shares the family home. The “Add new” button may be used to create a new family after a wedding for example. The fields "Family Salutation", "Family Firstname" and "Family Lastname" also appear. The first allows a family salutation for export to be defined. If it is left blank, "Family" is used for the salutation. Using this field a different salutation can be specified, e.g. "Mr and Mrs". Similarly "Family Firstname" and "Family Lastname" may be used to override the family firstname and family lastname. If they are blank, the firstnames of the parents and the family lastname are used. If the members of the family have different surnames (and "Family Surname" is left blank), they are connected by hyphens. Using this field the family name could be overridden e.g. to "A. & B. Smith".

In the person list, several people may be combined into a family using the button labelled “Add selected people to family”. The family fields of these people are overwritten to make them all the same, so if their addresses were different to start with some data may be lost. The family role can be assigned afterwards by editing the person individually, or by using the multiple row edit function for the "Family Role" column.


The list of people may be filtered. Each column may have its own filter rules, and these rules may be combined.

Possible filter rules are: Surname, first name, post code, county, country, Home phone, Work Phone, fax, email, Marital status, date of birth, etc.

If different filter rules are applied, these are linked by using the AND operator, i.e. a person is only shown if all filter rules match (see examples). This standard behaviour may can be changed using the “link” option.

If several filter rules are added against the same column, these are linked using the OR operator, because for example a person can not live in London AND Manchester. However the group filter, is controlled by the “link” option to select OR or AND, to link the group filters. This is because a person may be a member of more than one group. The same holds for other filters: role, filter presets, rota and donation.

The filter rules may be negated individually using the "Opposite" tick box.

Regular expressions may be used. The wildcard is * (Matches any number of any letters) Therefore "Ba*" matches "Baker" as well as "Bailey".

Other special characters include:

^ - Matches the beginning of a line

$ - Matches the end of a line

Thus “*on$” matches “Thompson” but not “Jones”

And “^th” matches “Thompson” but not “Smith”

Some simple examples

  • Everyone with the surname "Meier": Surname: Meier
  • Everyone whose post code begins with MK4, e.g. MK40 4DR or MK4 9ED: Post code: MK4*
  • People who do not have a mobile phone: Mobile: ""
  • People who do have a mobile phone: Mobile "", opposite
  • All small group leaders: SG role "Leader"

More complex examples

  • Everyone who has both mobile and email: Mobile: "", Opposite - email: "", Opposite
  • All family members with no family role: Family "", opposite (shows all family members), Family role "".
  • Check sex and salutation: Sex "male", Salutation "Mrs" (this shows possibly wrong entries)

Special filters

  • Rota: Use this filter to select an event and get a list of all people scheduled for service during this event.
  • Filter Preset: Apply one of your saved filter presets as a single filter. This can be useful if you need to combine filters in a way it would not be possible with just one filter.
  • SG day, SG region, SG type: Apply these filters to display all people being in a smallgroup meeting on the given day, in the given region or being of the given type.
  • AddChildren: If you have filtered some addresses and would like to add all the children of the filtered people you may use this filter. You may set a range for the age of the children to be added. The third option "Show only children" allows you not to add the children but to only show the children of the filtered people.
  • AddParents: If you have a list of addresses and you would like to add the parents of the filtered children you may use this filter. If you tick the option "Show only parents" the parents will not be added, but you will only see the parents of the currently filtered children.
  • Duplicates: This filter tries to find duplicate addresses by compairing the definied fields. The found duplicates can then be merged (see below).
  • Logins: This filter allows you to get all the addresses assigned to kOOL logins. You may select all logins or only those belonging to a certain admin group.
  • DOB range: Search for all the people whose birthdays fall in a certaim time range, f.e. 2005-05-01 until 2006-4-30

Filter presets

Filters and filter combinations can be stored as presets. These can be used again later and refined by adding further options to them.

It is also possible to save the displayed columns and the ordering with the preset filter, by ticking the "Save columns and sorting" box before saving the preset. The next time the preset is selected, the same columns are displayed again using the same ordering. When the column layout and sorting is stored with the filter, a "+" appears next to its name in the drop down "Load Preset" list.

A user with authorization stage 4 (moderator) may save filter presets for other users. Click on the small downward arrow beside the floppy disc “Save” icon to display the list of users. Select the users for whom this preset should be saved for in addition to the current user. These preset filters are stored as copies, i.e. any user deleting the preset filter will only delete their own copy, everyone else keeps theirs.

A user with authorization stage 4 (moderator) may also save filter presets globally by ticking "Save globally" when saving a preset. This way the filter preset is not copied for the other users but stored globally. So all users can apply this filter preset but only users with authorization stage 4 may delete or change them. These global filter presets are marked with "[G]".

You can send an email directly to the selection of a filter preset. To do so, select your filter preset and then click on the mail icon below the selection bar. In the 'new mail' window, you see the email address of the preset. You may also define an alias for the preset. This alias can then be used in the email address. For example: people in a filter preset with alias 'test123' can be addressed with the email address 'test123@kool.domain.tld'.


To save cluttering the screen, individual filters may be removed from the list. To do this, use the layout screen in the admin module. Scroll down to the people filter section and add or remove columns from the list, If this is done, the line: "- - more - - " appears under the list. Clicking it will show the hidden filters again. By hiding the less frequently used filters, the more frequently used ones can be found more easily.

Advanced filtering with manual links

If the regularly available options to set links between different filters don't meet your needs, you might make it work with the advanced filter linking.

As soon as one or more filters are applied you'll find a tool icon which hides the regular links "OR"/"AND" and show a text field instead. The help icon which also appears gives you some hints on how to apply these advanced filtering: Each applied filter is identified by a number starting at zero. You may now enter these numbers to reference each applied filter together with "OR", "AND" and parenthesis to combine these filters in any way. When storing a filter preset with manually set linking, these will be stored also.

Merging duplicates

When a duplicate filter is applied (see above "special filters") you'll find a button "Merge" below the address list to merge duplicate addresses into one. This is done by keeping the entry with the most information and deleting the others. But for all deleted a new moderation entry will be created containing this record's data. This information will then have to be merged manually. The groups, smallgroups, donations, tracking entries and rota scheduling of all the addresses are merged automatically.

The merging takes place for all marked addresses by groups. So you may merge several groups of duplicates at once.

Advanced sorting

Each column header in the list view contains two arrow icons which let you sort your addresses by this column, ascending and descending. Sometimes it might be helpful to not only sort by one column but by two or more. This can be done using advanced sorting. Click the "advanced sorting" link above the address list. Two select boxes will appear. The first displays the column by which the details are currently being sorted. To add a second sorting column, simply select the desired column in the second box. Choose between ascending and descending sorting mode for each column using the corresponding icon to the right of the select box. It is possible to sort by as many columns as required.

You may choose one of the "normal" personal data columns or one of the currently displayed group columns as sorting columns.


Two views of personal data are available:

- Person list: A compact list. The columns shown can be selected.

- Address list: Overview of the most important address fields, which can be copied and pasted, for example to address letters or envelopes. Move the cursor on the icon left of the name and you see more options: "Delete Person", "Show version history", "Show address in Google Maps", "Show QR Code" and "Create Word letter addressed to this person". For more information see below "Actions".

Individual columns may be hidden (Or shown) in the person list. The filter rules are not affected, they are still applied even if the column is not shown. These views can be stored in preset filters.

The person list may be sorted by any column in ascending or descending order.

The birthday list shows upcoming birthdays. The time window over which the birthdays are shown, i.e. if the birthday occurs between 5 days ago and 20 days in the future for example, can be configured in the admin module.

Sorting Columns

The sequence of the columns can be arranged automatically or manually. To change the mode use the “Sort Columns” tick box. If the box is not ticked, new columns are always added to the right. The double arrows at the bottom of each column may be used to move the column left or right. The order will be saved if the column list is saved in a preset.

If “Sort Columns” is ticked, the columns are automatically arranged in the same order as they appear in the column submenu.

My list

Each kOOL user who has permission to view people, has their own list of people at their disposal called “My List”. An arbitrary list of people who can not easily be grouped together by use of filters, may be added to this list and shown together. This list can be used for example to export the peoples data, or to assign them to a team. The people are found individually and added to “My list” one by one using “Add Selected” under the “My List” box.

If the “List” link under “My List” is clicked, the people are listed. Actions may be done on this list, e.g. send an email to everyone in the list. People may be removed individually or in groups from the list.


In some places in kOOL you'll find the possibility to store people in "My List" or the import them out of "My List".


The selected people can be exported by means of actions. The following actions are available:

  • Excel Spreadsheet: This can be used to do for example a mail merge.
  • Excel Spreadsheet with options: Same as Excel Spreadsheet, but you are first directed to a page where you can set some preferences for the Excel export.
  • Mass Email: The email addresses of the selected people appear as an email, so that an email can be sent straight away, or the list of email addresses may be copied and pasted rather than having to copy them all individually. People who have no email address in their personal data will be listed, and an excel file is created with their details.
  • Labels: A PDF is created suitable for printing address labels. There is more information on this in the next section.
  • Mail merge: Write a letter directly inside kOOL and create a mail merge with individual texts. Uses LaTeX and creates the letter as PDF for printing. See more below.
  • SMS: If the personal data contains a valid mobile number, an SMS with a text of up to 160 characters can be sent to the mobile numbers. For more information, see the Send SMS section.
  • vCard: Exports the desired addresses into one vCard file which then may be imported into an address application like MS Outlook.
  • Charts: Display statistical graphs. The statistics only apply to the people selected by the current filter. You can choose which graphs to display by ticking them in the submenu "Charts".
  • PDF: This option allows you to create PDF files. Find out more about the possibilities and settings further down.

The "rows" drop down box is used to select which person or families are to be exported. The following options are available:

  • Filtered (people): Everyone in the current list (i.e. any filter applies) are exported individually, i.e. whether or not they are in a family makes no difference.
  • Filtered (families): Everyone in the current list (i.e. any filter applies) are exported as families if they belong to one. The family salutation, lastname and firstname are used as set by each family - or the default "Family", "", "Lastname" ist used. Which first names should get exported may be specified with the option "General Settings > Include firstnames for family exports". Families are only exported once, even if several members are in the list. The normal data fields are used for people who are not in a family.
  • Filtered (fam if 2+): If two or more members of one family are part of the current list of people they will be exported as a family. If only one member is found or if there is no family defined for a person, these will be exported as is.
  • Selected: All selected people/families are exported. In order to select an individual person, tick the first tick box column of the list to export. To export a family, tick the box in the second column, the family column, to select the whole family.
  • Selected (families): All selected individuals are exported. The family data is used if the individual is a family member. If the individual is not in a family their own data is used.
  • Selected (fam if 2+): Selected individuals are exported as families if two or more members of the family are in the current list.

Use the "columns" drop down box to define which personal data columns should be exported to Excel or labels. For example, a mail merge letter will needs address data but not small group or telephone data to be exported. The following options are available:

  • All: All columns for the selected people are exported. This will result in a large file.
  • Shown: The columns shown in the list are exported.
  • Shown + parents' data: This option adds columns to children's records which contain information about their parents, e.g. the mobile number.
  • "Preset filter": The options in quotation marks stand for the preset filters of that name, which were saved using the people module. Thus it is very easy to have the correct data for a mail merge or printing labels available. It is advisable to store preset column filters for the frequently used exports so that they can be selected and ease creation of the required data.

Icons that are shown when you move the cursor on the Edit-Icon:

Clipboard: Use this icon to copy the address into your systems clipboard.

GoogleMaps: Show this address on GoogleMaps

QR Code: Take a picture of this code to import the address to your mobile phone.

Word: Creates a letter in Word with this address.

Printing Labels

In order to print peoples addresses as labels, use the action "labels" to create a pdf file, which contains the data which can be printed. This makes it possible to, for example, print address labels. There are many other possibilities, e.g. name plates for a dinner etc. The columns selected in the drop down box "columns" are printed. For an address label the following columns would have to be selected; title, forename, surname, address, address line 2, Town/city, post code. To use “selected” these columns would need to be in the list view. Alternatively a preset column filter called "labels" would save arranging the columns every time you wish to print labels. Instead, simply select "labels" in the drop down box. Once the labels button is pressed, the following options are displayed:

  • Preset: The preset for the label size must be selected. These presets should be defined in the Admin module (see the Admin module documentation for more info)
  • First label: The position of the first label to be printed. Counting starts on the left of the first line and goes to the right, then the next line and so on. This is useful when a sheet of labels has been partly used.
  • Print Border: Borders may be printed or not. If the sheets do not contain individual labels these may be used to guide cutting.
  • Fill n pages: With this option ticked the whole sheet of labels is beeing filled with the selected addresses. If e.g. only three addresses are being printed, they will be repeated to fill the whole sheet.
  • Print each address x times: Raise the number to have each address printed several times.
  • Include return address: Tick this option to include the return address on the printed labels. As you tick the option, a selection bar appears which lets you specify the return address. You can choose between your login address, the info address (defined as setting) and a manual address. In addition, there is an option to prepend the string 'P.P.' to the return address. Edit the label preset to change the position and the font size for the return address.
  • Field Separator: After each field (address, forename, place etc.) it is possible to print a new line, a blank line, a space, or nothing at all. E.g. if first name and surname need to be on the same line, a space may be selected as a field separator after the forename. To put the address on the next line, newline may be selected as the field separator after the surname.
  • Plus Icon: Click on the '+' icon to add an empty line where you can enter some information manually.

Send SMS

It is possible to a text message to people's mobile phones. To do this: select the people to receive the SMS from the people list in kOOL. Next select the SMS action by clicking on the mobile phone icon. Two lists of people appear. The ones who have valid phone numbers appear first under "Recipients". Next those people who have no mobile number, or the number defined is invalid are listed. This list of people with invalid numbers may be downloaded in a spreadsheet, added to the "My list" list, or may overwrite "My list", by clicking the appropriate link. Additional recipients can be added manually. The text message is written in the text box. If the text is longer than 160 characters it will be divided up in multiple chunks. The message is sent using the "Send" button. The cost per recipient will vary depending on network and location. The available SMS Credit is shown under "Account balance".

If the logged in user's mobile number is activated as a sender ID this will be used as sender of the message. If the current user has more than one mobile number registered and/or and admin mobile set for his login, then a select box will be shown for the user to choose which one to be used as sender.

Mail merge

The mail merge feature of kOOL is not supposed to replace your text processing software (like OpenOffice.org, MS Word etc), but it offers an easy way to write a simple letter to multiple recipients. If you need the full potential of your text processing software just export your addresses as an Excel spreadsheet to create a mail merge.


Choose the rows and columns you want to export as for any other export method and click the mail merge icon. The selected addresses will be checked for completenes. Non-complete addresses will still be used for the mail merge, but you will be notified about them. You also get the chance to export them to "My list" to quickly fill in the missing data.

If you've written a mail merge letter in kOOL before a select box will appear with all the previously written letters. If you select one from this list, it's text and settings will be copied so you can base your next letter on this one.

If you have several letter layouts you may select the appropriate one. (This may be created by your system administrator by adding LaTeX .lco files)

Select the desired opening type, formal or informal.

If an address is assigned to your login and your organisations address has been entered in the contact settings (general settings in admin module), you get to choose the sender address. If only one of them is set, this one will be selected for you.

Enter a subject of your letter and write the letter's text itself in the big text box. You may use the icons above it to format your text. Use dashes ("-") as the first sign on a lign to create a bullet list. If your text doesn't fit into the box anymore you may enlarge it using the two blue arrows. At the bottom of your page you will find a list of markers you may use in the text and subject fields. Enter one of these and it will be replaced with the individual value in each letter. Only the columns you selected when starting the export are available here.

Finally enter the closing text and your signature. You may enter your signature as text or upload it as a picture. If you have uploaded a signature file before you reuse this by ticking "Use signature picture from last upload" or upload a new one which will overwrite the previously uploaded one.

Now you may start the mail merge by clicking "Merge mails" and a popup windows will offer you the PDF file with each letter starting on a new page.

Create a PDF list

Select the desired pdf layout from the select box. The available layouts can be managed in the admin module. Find out more about them in documentation of the admin module.

After selecting a layout the following options will appear:

  • Filter: The chosen filter preset defines the addresses to be exported. If the selected pdf layout already holds a filter preset this one will be selected by default "[Using Preset]". You may also apply the currently used filter by selecting "[Current Filter]". Or you may select one of your stored filter presets by their name.
  • Columns: Here you may select the columns to be printed for each address. If the selected pdf layout already holds a column preset it will be used as a default "[Using Preset]". By selecting the option "[Current Columns]" the currently visible columns will be used. Alternatively you may select one of your stored column presets.
  • Include Group Datafields: By ticking this option the group datafields of selected groups will be exported as separate columns.
  • Header and Footer: Use any text for the header and footer or use some of the described substitution variables. E.g. [[PageNumber]] will be replaced with the current page number.

The sorting of the list is generally set according to the sorting of the chosen layout. If this is set to empty, the sorting is done according to the sorting of the chosen filter preset. If this sorting isn't set either, the current sorting in the people module is used. 

Import Addresses

In the people Submenu there is an "import" option for users with authorization stage 4. This allows the import of address data from external sources. Import from a CSV or a vCard file is possible. You can create a CSV file e.g. from an Excel spreadsheet, which should be saved as a CSV (Comma Separated Values) file. The import is made by 3 steps:

1. Select the type of file containing your address data

2. (CSV) select the columns in the CSV file in their correct order, so that the data can be imported into the correct fields of the kOOL database. Select the file using the "Browse" button. The field and text separator should be defined in their relevant fields. The field separator stands between each column and the text separator surrounds the text of an individual column. If the first line of your CSV file contains column headings, they may be excluded from the import by ticking the “Ignore first line” box. If you choose a group as column, the entries in this column can contain the name of a role of this group (so this role will be assigned to the person) or x/yes/ja (so the person is assigned without role).

2. (vCard) The only option here is to select the vCard file to import. Both types of vCards are allowed, i.e. those with a single contact in, or those with several.

3. If the file and the data within it were verified, the first 5 records are displayed. If this looks OK the addresses may be assigned to a group and imported.

Editing People

If the permissions allow editing, an edit icon will appear in the second column of the person list. It does not appear in the address list view, only the person list view. Click on it to open the editing screen for the person. All personal data appears in the screen, no matter which columns were shown in the list screen.

Editing a single column for several people is also possible. Select the people to be edited using the tick box on the left, and click the “Edit this column for all selected rows” icon, which appears at the bottom of each column. Clicking on the tick box at the top or bottom of the selection column reverses the selection, so if none are selected, all the rows on the screen can be selected by clicking this tick box.


If your address records contain multiple email addresses or mobile numbers you will find a checkbox next to each email address and mobile number field. If none of these are ticked the first found address/number will be used when exporting addresses. But if one of them is ticket, then this will be used as the prefered address/number.

For this to work, you must list the additional fields for the email addresses in $LEUTE_EMAIL_FIELDS resp. $LEUTE_MOBILE_FIELDS for the mobile numbers in your ko-config.php.

Creating a new person

New people may be created by selecting “add person" from the people submenu to bring up the create person screen. This should be filled in as required. Fields may be left blank if desired.


Fast Filter

In order to quickly search for people, first name and/or surname can be provided for the Fast Filter. The people are filtered according to these criteria and matching ones are listed.

The tick box "Deleted" shows people who have been deleted. These were removed by clicking on the dustbin icon, This marks them as deleted, but does not remove them from the database. Clicking delete again on any row which is already marked as deleted will permanently remove it from the database.

The tick box "Show hidden" is only available if the general setting for displaying hidden people is set to "Let user decide". Then you may switch between displaying the hidden addresses or hiding them in the current list display.

The date selector labelled "show old version" allows personal data to be displayed as they where at a time in the past. See more below under "Versioning".

Version history

When a person's record is changed, the old version is saved. To view previous versions, e.g. to find what address someone had on a particular date in the past, use the date field in the fast filter and click OK. This feature is available to users who have edit rights for all people. You can apply filters to this old version as usual and you may also export them.

The history for a persons record can be displayed by clicking the clock symbol. Click the green "roll back" arrow to undo all changes to the record up to and including the selected change.

Moderating Changes

Keeping the personal data up to date is a time consuming task. To reduce this work, kOOL allows users to request address changes from the front module. These changes must then be accepted by a moderator, (a Login with moderator rights for the people module). Anyone can request changes but they must be authorised before they are actually applied.

The “Changes()” entry appears in the “people” submenu if the user has sufficient permissions. If there are one or more changes, this becomes a link to a screen listing them. They may be viewed and, if necessary, corrected before accepting them. The changes may also be completely rejected.

If kOOL detects that a requesting person belongs to a family, then there is a checkbox called 'decouple from family'. Tick it to decouple this person from the family. Use this if you don't want address changes of this person to cause address changes of all family members.


Settings for current user

  • Default view: Select the view you'd like to get to upon clicking "people" in the main navigation.
  • List: Number of people per page:
  • List: Number of smallgroups per page:
  • Order birthdays in people module by: Ordering by the date of birth may be done by age or by month and day.
  • Apply this filter for the birthday list: Only show people as defined by the selected filter in the birthday lists.
  • birthday list +: Number of days to show a birthday in advance.
  • birthday list -: Number of days after a birthday to still show it in the birthday list.
  • Include firstnames for family exports: When exporting addresses as families you may want to use no firstnames to address you members (e.g. "family smith") or use the parents' firstnames only. With the third option you may include the firstnames of all family members currently filtered, which might be helpful when exporting children.
  • Filters shown as fast filters: Select the filter you would like to have available in the fast filter submenu. If nothing is selected it defaults to the filters for lastname and firstname.
  • hide the following people filters: Select rarely used filters to hide them from the regular list of filters.
  • Columns for export "Shown and parents' data": Select the columns to be used as parents' columns.
  • Enable smallgroup data as address columns: This allows you to display small group information as a new column for the viewed addresses.
  • Show checkbox to select family: Set this to display an additional checkbox for each address assigned to a family. By ticking this family checkbox you may manually export this address as family and others as person.
  • Show groups which have ended: Enable or disable the display of groups with a pasted stop date. This is the same option as in the groups module.
  • Enabling a group column shows all datafields as well: By default the group datafields must be enabled one by one. With this option all group datafields will be activated automatically if their group is displayed.

Global settings (access level 3 needed)

  • Show or hide hidden addresses: Select how to treat hidden addresses.
  • Allow addresses to be deleted permanently?: Set this to Yes to allow deleted addresses to be deleted permanently. Otherwise the deleted addresses just stay.
  • Send notification email if a user assignes an address to his own group: If a user is allowed a search for addresses he usually has no access to and assigns one of those to his own group, a notification email is sent to this address. (See login setting "Allow this user to search in all addresses and assign them to his own group" )
  • Labels presets: This link gets you to the presets for printing labels in the admin module.
  • PDF layouts: This link gets you to the PDF layouts in the admin module.

Smallgroup Module (KG)

Small group administration is done in its own module, which is a sub-module of the people module. Permission to use the module can be assigned per user. The "small group" submenu can be used to show all small groups (List Groups), or create a new small group. The list view of the small groups is identical to all other list view in kOOL and should be easy to understand.

A small group's name need not have anything do with the small group leader. For example small groups may be called "blue", "yellow" etc. if so desired. The leader assigned to a small group, appears in the list view in parentheses after the small group's name. Likewise the number of participants can be shown in the list. This is calculated from the number of people assigned to the group.


To assign a person to a small group: First edit the personal data of the desired person. Find the small group in the smallgroup list and choose the entry with the desired role (Leader, Member, etc). A single person may be part of several small groups and/or leader of several groups.

This assignment may be done for several persons at once using the multi edit function.

It is also possible to edit the small group record and assign leaders and members there. This is especially handy if you create a new small group and want to assign several people to this new group.


View small group columns in address list: Each column from a small group may be displayed as an extra column in list of addresses. This allows you to e.g. display for every person which region his small group is in.

Accessing peoples data from Outlook/Thunderbird

The address, telephone and email address data for the people in the kOOL database are stored in an LDAP directory, or other listing service. Many Email programs e.g. Outlook Express or Thunderbird can use these services for address books. The personal data may only be accessed if the user has the correct permission, i.e. a user needs to log in to the listing service with their kOOL Login. To use the listing service from Outlook, follow these instructions:

  • Note: These instructions are for Outlook XP. Other versions will be slightly different.
  • From the menu bar in Outlook click on Tools->Email Accounts.
  • Select "Add a new directory or address book" and click next.
  • Select "Internet Directory Service (LDAP)" and click next.
  • Type the hostname of the kOOL LDAP server in the box, and tick "This server requires me to log on".
  • The username and password fields appear.
  • The user name will be: "cn=LOGIN,ou=login,ou=kOOL_demo,dc=Ihr.LDAP.Server,dc=com". LOGIN should be replaced by the user's kOOL login name. Replace kOOL_demo etc. with whatever is defined in config/ko config.inc.
  • The password is the users kOOL password
  • Click "More Settings"
  • Click OK on the "Add email account" alert.
  • Change "Display Name" if desired. Click on the "Search" tab.
  • In the "Search Base" field, enter the search base: "ou=kOOL_demo,dc=Ihr.LDAPServer,dc=com". As above, the exact name depends on what is set up in the configuration.
  • Click OK to return to the "Directory Service (Ldap) settings" screen.
  • Click Next.
  • Click Finish on the "Congratulations" screen.
  • As the alert said, Outlook needs to be restarted here so the new address book shows up in the following steps. Select File->Exit to close, and then start Outlook up again.
  • From the main outlook window, select Tools->Address Book to bring up the address book.
  • The newly added address book should show up under the "Show names from" heading. Select it from the drop down list.
  • Type something in the "Type name or Select from List"
  • It can take a while for the names to appear the first time. Try tools->find, put "a" in the "Display name" field, select the "Contains" option, and click OK. Results should now be displayed.

To use the listing service from Thunderbird, use the following instructions.

  • From the main thunderbird window select Tools-> Address book to bring up the address book.
  • From the File menu select New->LDAP Directory
  • Enter the following data into the dialogue box:
  • Name: KOOL addresses
  • Hostname: The LDAP server name.
  • Base DN: ou=kOOL_demo,dc=Your.LDAP.Server,dc=com
  • Port number: 389 (standard)
  • Bind cn=LOGIN,ou=login,ou=kOOL_demo,dc=Your.LDAP.Server.dc=com
    ("kOOL_demo" should be replaced with the correct value, which is defined in config/ko-config.inc. "LOGIN" must be replaced by the users kOOL Login name.)
  • The address list on the left should now contain the "kOOL addresses" entry which was created above.
  • In the right hand side of the toolbar is a search box. Enter a name (Or a search term) in it.
  • A password prompt may appear. The user simply enters their own kOOL password, and clicks OK. Thunderbird may be instructed to save the password at this stage if required.
  • Close the address book.
  • The following steps will enable address autocompletion for email addresses from the kOOL LDAP server.
  • From the menu select Edit->Settings
  • In the dialogue box that appears, select the Composition tab.
  • Now select the "Addressing" tab which appears below.
  • Tick "Directory Server" and select "kOOL addresses" as created above.
  • Now create a new email, and start typing a name in the "To:" field. If it matches a (single) name in the kOOL LDAP directory, it will autocomplete.
©Renzo Lauper, CH-5000 Aarau, All rights reserved