Convergence Manual

The Convergence Database

Convergence holds your data in a MySQL database running on your Convergence server. MySQL is freeware and is included in web hosting services. Commercial versions and paid support options are available through MySQL. The database contains not only your case data, but also most of your settings and configuration data as well.

Accessing the database with PHPmyAdmin

PHPmyAdmin is a free database utility that comes with most MySQL installations. PHPmyAdmin may be used to directly view and edit data in the database, recover data, to reset a password, or to make databse backups. Convergence should always take care of maintaining its own data, and using PHPmyAdmin to edit data should only be used when necessary if something goes wrong, and not as a normal method of changing data. However, if a case's data has been overwritten, or an admin password is lost, this tool may become needed.

If you are using CPanel for your server control panel, click the 'phpMyAdmin' icon in the 'Databases' section of your control panel home page.

After a brief delay, you should see a database control panel appear in a new tab.

Next, you will want to select the Convergence database by clicking on it in the database list in the upper left. Usually the database will have a name like 'yoursitename_cnv'. Once you click on a database name, you will see a list of data tables for that database.

Clicking on a table name or clicking the link 'Browse' for a table will give you a view of what's in that table. IMAGE:Data Table View

When a table is displayed like this, you may edit individual rows, delete rows, or add new ones. Corrections and additions can be made by hand, but this must be done carefully if it is done at all.

Convergence Table Structure

Every database contains tables of data, and each table contains rows of data and a defined set of columns for each row. Most tables have ID numbers that point to rows in other tables. For example, a case note entry in the database would contain a case ID number that would say which case the note is for. Most of the time, these database ID numbers for data rows are not visible in Convergence, and won't concern the average Convergence user. They become vitally important to understanding the database and working with the tables in it. If an ID number in the database does not point to a valid row, strange things may happen as Convergence attempts to make sense of the data.

Below is a list of the data tables Convergence uses, and a description of each one. Related tables are grouped together.

<Previous Page Table of Contents

This manual is published by Convergence Case Management Data Retrieval Software, LLC, whose software products are provided for use by parties who have paid for and have a current license to operate the software described herein.

Information in this manual is subject to change without notice, and does not represent any commitment on the part of Convergence Case Management Data Retrieval Software, LLC. The software described in this manual is furnished under a license agreement and may be used only in accordance with its terms and conditions.

This manual contains propietary information which is protected by Copyright. No part of this document may be reproduced, translated into any language or computer language, or transmitted in any form whatsoever without the prior written consent of Convergence Case Management Data Retrieval Software, LLC.