# Additional moregroupware components

moregroupware has some addons that can optionally be used to enhance the "user experience". Setup and usage of these addons are described in this chapter.

## Appointment reminder

This script is called via the `cron` daemon and sends out appointment reminders via email.

This is still very experimental and might not work at all! Hopefully this will be worked on in the future... but for now just make sure you know what you are doing if you use this.

## Address queries with Mutt

This script queries the (remote) moregroupware database server for names and email addresses and returns data which Mutt (the email client) can use to display a selection menu.

This is supposed to be called by mutt. Insert `set query_command = "mgwquery.sh '%s'"` into your `.muttrc` to make this work (The script needs to be in your PATH. It it is not, provide the full path to the script).

You have to change the variables at the beginning of this file to be able to connect to the database.

To test the connection, you may afterwards call this script directly and give a single argument to it: `mgwquery.sh 'a'`

If this works you may use `Q` to query for contacts in the moregroupware database or `Ctrl-t` to auto-complete an address.

## Moving data from TWIG to moregroupware

This converts TWIG contacts to moregroupware.

The companies are mapped to the companies table, using the company entry of TWIG as key.

All entries are mapped to contact group 1, which is Customers after installation of moregroupware. All countries are set to Germany.

Adjust your connect data, database and table names below. And make a backup before proceeding.

ALL moregroupware contact and company DATA IS DELETED BEFORE CONVERSION!

After conversion prepare to fix the sequences manually.