<?xml version="1.0" encoding="iso-8859-1"?>
<chapter id="setup_addons">
  <title>Additional moregroupware components</title>
  
  <para>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.
  </para>
  
  <section id="setup_addons_reminder">
    <title>Appointment reminder</title>
    
    <para>
      This script is called via the <command>cron</command> daemon and
      sends out appointment reminders via email.
    </para>
    
    <important>
      <para>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.
      </para>
    </important>
    
  </section>
  
  <section id="setup_addons_mutt">
    <title>Address queries with Mutt</title>
    
    <para>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.
    </para>
    
    <para>
      This is supposed to be called by mutt. Insert <command>set
        query_command = "mgwquery.sh '%s'"
      </command>
      into your
      <filename>.muttrc</filename> to make this work (The script needs to be
      in your PATH. It it is not, provide the full path to the
      script).
    </para>
    
    <para>You have to change the variables at the beginning of this file
      to be able to connect to the database.
    </para>
    
    <para>To test the connection, you may afterwards call this script
      directly and give a single argument to it: <command>mgwquery.sh
        'a'
      </command>
    </para>
    
    <para>
      If this works you may use <command>Q</command> to query for contacts
      in the moregroupware database or <command>Ctrl-t</command> to
      auto-complete an address.
    </para>
    
  </section>
  
  <section id="setup_addons_mvcontacts">
    <title>Moving data from TWIG to moregroupware</title>
    
    <para>This converts TWIG contacts to moregroupware.</para>
    
    <para>The companies are mapped to the companies table, using the
      company entry of TWIG as key.
    </para>
    
    <para>All entries are mapped to contact group 1, which is Customers
      after installation of moregroupware. All countries are set to
      Germany.
    </para>
    
    <para>Adjust your connect data, database and table names below. And make
      a backup before proceeding.
    </para>
    
    <important>
      <para>ALL moregroupware contact and company DATA IS DELETED
        BEFORE CONVERSION!
      </para>
    </important>
    
    <para>After conversion prepare to fix the sequences manually.</para>
    
  </section>
  
</chapter>
