Table Maintenance
Many of the data fields in CLIFF, including the user-defined fields, have pop-up lists of data associated with them. These lists are maintained as simple tables of data that may be accessed through the Table Maintenance function. The procedure for maintaining the tables of data is similar for all data lists, the only difference is if a list is comprised of single entries, or multiple entries
When opening a table for updating, it is quickly apparent if it is a single entry table, or multi-entry table as shown in the example below:

To Select a Table for Updating
- Click on the
button in the CLIFF menu bar.
- Select the Table to modify from the menu list. One of the above data lists will open.
Updating a Single Entry Table
- ADD - Enter the new value in the field at the bottom of the list and click Add. The new value will appear in the list.
CHANGE - Click on the data value to be changed. The data appears in the field at the bottom. Make the required changes and click Change.
DELETE - Click on the data value to be deleted. Click Delete.
PRINT - Click Print to print the data list. A new window with a printable version of the table will be displayed. Use your web browser's print function to print the document.
EXPORT - Click Export to export your data list from CLIFF. Your web browser will prompt you to save the file being downloaded from the server.
IMPORT - To import data values into your list click Import. A window will be displayed for you to define which file to import. Click the Browse... button to select the file. By default the imported data will be merged with the existing data. If you want the current contents to be replaced by the imported file, click Delete Existing Entries. Finally click Import to start the import.
The file to import must be a text file in standard ASCII format. CLIFF will not import data in Excel or Word format.
Updating a Multi-entry Table
- ADD - Click Add. CLIFF opens a new data entry window. Enter the data as per the specific help for that table and click Save.
CHANGE - Click on the data value to be changed. Click Change. CLIFF opens a new data entry window. Change the data as per the specific help for that table and click Save.
DELETE - Click on the data value to be deleted. Click Delete.
PRINT - Click Print to print the data list. A new window with a printable version of the table will be displayed. Use your web browser's print function to print the document.
EXPORT - Click Export to export your data list from CLIFF. Your web browser will prompt you to save the file being downloaded from the server.
IMPORT - To import data values into your list click Import. A window will be displayed for you to define which file to import. Click the Browse... button to select the file. By default the imported data will be merged with the existing data. If you want the current contents to be replaced by the imported file, click Delete Existing Entries. Finally click Import to start the import.
The file to import must be a text file in standard ASCII format. CLIFF will not import data in Excel or Word format.
NOTE: when information from pop-up lists is entered into data fields in the Logs or the Referrals, the actual data is entered in the field, not a reference back to the table. Therefore caution must be exercised when changing tables. For example, if a Log Type in the table is changed from 'Letters' to 'Correspondence' all the Logs with 'Letters' will not change.
Batch Type
Batch types allow you to set up different types of batches, for example petition, survey, and so on. See Table Maintenance for help on maintaining the Batch Types.
Duplicate Search
When entering Logs, CLIFF automatically searches for duplicates. However if you Log correspondence for which there is no Last Name and you enter a standard keyword, for example 'UNKNOWN', you do not want CLIFF to search the database for duplicates of this type of Log. To stop CLIFF searching for duplicates, enter the keyword(s) you use for these type of Logs in the Duplicate Search table.
See Table Maintenance for help on maintaining the Duplicate Search table.
Email Distribution Lists
If you frequently find yourself sending emails to the same users, you can simplify your work by creating Email Distribution lists.
To create an Email Distribution List
- Choose Emal Distribution Lists in the Table Maintenance Menu. The following window is displayed.

- Click Add to create a new distribution list. The following window is displayed.

- Enter the name of your list.
- Select user's email addresses in the left column that should be included in the list.
- Click the
button to move the email addresses to the right column.
- Click Save to save the list. The List of distribution lists will be redisplayed.
- Click Done to close the window of distribution lists.
To modify an Email Distribution List
- Choose Email Distribution Lists in the Table Maintenance Menu.
- Click on the distribution list to modify.
- Click Change to display the distribution list.
- Make changes as required.
- Click Save to save the list.
- Click Done to close the window of distribution lists.
To delete an Email Distribution List
- Choose Email Distribution Lists in the Table Maintenance Menu.
- Click on the distribution list to delete.
- Click on Delete.
- Click Done.
File Number
You may assign file numbers to Logs and Referrals as a reference to your paper files. Creating a table of file numbers makes it handy for entering file numbers that are frequently used. See Table Maintenance for help on maintaining the File Numbers.
Groups
Offices may be organized into Groups for reporting purposes. Groups may equate to Divisions in your organization where each Division may have multiple offices. A group may be comprised of several offices, but an office can only belong to a single group. See Table Maintenance for general help on maintaining Groups. The following provides additional help specific to Groups.

Group Data Fields
Group Name: name of group
Title: optional title or description of group.
Offices in Group: Assign Offices to the group. Only offices that have not been assigned to a Group are shown in the Available Offices list. An office cannot be assigned to more than one Group.
See About Table Maintenance for changing the Groups Table
Information Tags
Information tags provide additional information about data elements in pop-up fields. See Table Maintenance for general help on maintaining the Information Tags. The following provides additional help specific to Information Tags.
NOTE: Information Tags for a field must be activated in the Application Preferences before becoming available in the Log form.
To Add or Update an Information Tag
- Select, or add a new Information Tag as described in Table Maintenance to present the following form.

- In the input form, complete the fields as follows:
- Table - select the pop-up table the Information tag is for.
- Entry - enter the data value that will trigger the message. If it's an existing data value you may select it from the Values drop-down list.
- Info - the information to be displayed when the data value is selected. Note that you may use html tags in the text.
- Click Save.
- If you have not already done so, activate the Information Tags for the field in the Application Preferences.
Log Action
Each Log may be assigned an Action and an associated Due Date. The Log Action is assigned through the Log Action Table.See Table Maintenance for general help on maintaining Log Actions. The following provides additional help specific to Log Actions.

Data Fields
Log Action Enter a unique name for the action;
Due in Days if a Due Date is to be automatically generated, enter the number of days allowed for the action.
See About Table Maintenance for changing the Batch Type Table
Log Type
Log Types allow you to classify your Logs, for example correspondence, meeting request, and so on.
See Table Maintenance for help on maintaining the Log Types.
Noise Words
CLIFF automatically generates keywords for the following data fields:
First name,
Last name,
Company,
Subject,
The two user defined text fields, and
The six user defined pop-up fields.
You have the ability to filter out words you do not want keywords generated for by specifying noise words for CLIFF to ignore. For example, to, from, in, the, a, and so on.
Note that noise words are not filtered out of the first and last name.
When a new database is created in CLIFF, a default table of Noise Words is automatically built. You may modify this table as required.
See Table Maintenance for help on maintaining the Noise Words.
Office
Updated in Version 5.2
Offices are the primary organizational component in CLIFF and are used to establish ownership of Logs; and create Referrals. For more information about offices see Configuring Offices. See Table Maintenance for general help on maintaining Offices. The following provides additional help specific to Offices.
The following is office form for adding and changing office attributes. Note that an office cannot be deleted if it has been assigned to a Log or Referral.

Data Fields
- Name
- Enter a unique name for the Office. If this is an existing office and you change its name, all Logs and Referrals that contain that name will be automatically updated with the new name. Note: You may not change the Office Name if there are other users currently logged in to CLIFF. If other users are currently logged in, CLIFF will change the office name to read-only.
- Group
- Select a group from the pop-up. This is an optional entry and only necessary if your organization is using Groups.
- This Office is now obsolete
- If an office is no longer used but you cannot delete it because it is used in historical Logs or Referrals, make it obsolete. This removes it from all pop-up lists and prevents it from being assigned to new Logs or Referrals.
- Merging Office
- To merge an office with another office, click this check box and enter the "TO" office name in the name field. This will merge all Logs, Referrals, Templates, User Accounts, Distribution Lists, and Reports from this Office to the specified "To" Office. Warning: This merge is permanent. It is recommended that you have your database backed up before merging offices.
- New Logs created by this Office default to confidential
- Any Logs created by this Office are automatically made confidential.
- Users for Office
- Assign User Account(s) to the office by clicking on one or more accounts in the available list and clicking on the
button.
- Address and Contact information
- This is optional.
- E-mail
- The e-mail address where e-mail reports should be sent to. This is a required field if e-mail reports are to be sent from this office.
- CC
- Additional e-mail addresses for reports.
- Shared Offices
- If you want Logs created by this office to be automatically shared with other offices, Assign the offices as required. Note that only new Logs will be automatically shared. Logs that are imported or moved from another office will not be automatically shared. Instead of automatic sharing you may want to give users in other offices access to this office.
Office Distribution Lists
If you frequently find yourself creating Referrals to the same group of offices, you can simplify your work by creating distribution lists.
To create an Office Distribution List
- Choose Office Distribution Lists in the Table Maintenance Menu. The following window is displayed.

- Click Add to create a new distribution list. The following window is displayed.

- Enter the name of your list.
- If this distribution list is to be shared with other offices, click the Shared List checkbox. If you dont click the Shared List, only users in your office will see the distribution list.
- Select Offices in the left column that should be included in the list.
- Click the
button to move the Offices to the right column.
- Click Save to save the list. The List of distribution lists will be redisplayed.
- Click Done to close the window of distribution lists.
To modify an Office Distribution List
- Choose Office Distribution Lists in the Table Maintenance Menu.
- Click on the distribution list to modify.
- Click Change to display the distribution list.
- Make changes as required.
- Click Save to save the list.
- Click Done to close the window of distribution lists.
To delete an Office Distribution List
- Choose Distribution Lists in the Table Maintenance Menu.
- Click on the distribution list to delete.
- Click on Delete.
- Click Done.
Referral Action
When a Referral is created, an Action must be entered. The Referral Action is assigned through the Referral Action Table.

Data Fields
Referral Action Enter a unique name for the action.
Due in if a Due Date is to be automatically generated, enter the number of days allowed for the action.
See About Table Maintenance for changing the Referral Action Table
Referral Status
When creating and completing Referrals, CLIFF will assign standard status values. You may assign your own status values using the Referral Status tables, for example who in your Office that is working on a Referral.
See Table Maintenance for help on maintaining the Referral Status.
Salutation
The salutation or title to be assigned to a person.
See Table Maintenance for help on maintaining the Salutations.
Sign By
Typically this is the person who signed the response.
See Table Maintenance for help on maintaining the Sign Bys.
Special Author
If you want CLIFF to watch for "Special Authors" when creating Logs define the authors in the Special Author table. See Searching for Special Authors. See Table Maintenance for general help on maintaining the Special Authors. The following provides additional help specific to Special Authors.

Data Fields
First Name Enter the Authors first name;
Last Name Enter the Authors last name;
City Enter the Authors city;
Checkboxes Click the check boxes that should selected in the Log if the author is a Special Author.
See About Table Maintenance for changing the Special Author Table
User Defined Pop-up Fields
The eight user defined text fields each have an associated table. The label you assign to each of the fields in the Application Preferences is the name used in Table maintenance.
See Table Maintenance for help on maintaining the data lists for user-defined fields.
NOTE: If any of the fields are automatically populated by the postal code lookup function, you will not be allowed to Add or Delete entries in the associated table(s).