Matrix View DataBase - MVDB
Groups / Businesses & Subjects / People, Places, & Things

Matrix View DataBase (MVDB)
Click the 'dB' on the Opening Page
Use the List Subjects - Members of the Group > 'List' Button to select any Member of the Group.
The Base Selection* (ie this case, Group*) will allow any Members (Subjects) to be selected for view & vice-versa -
It provides the view to put an Event/Activity combined with MVDB Group and/or Subject(s) (see Events and MVDB View).

Largest      Smaller      Smaller      Smallest

General MVDB Information:

Data that applies to a Subject / Person appears in Blue.
Data that applies to a Group / Business appears in Navy.
Data that Appear in a Teal color, indicates that some of the selectable data applies to a Subject / Person and some of it applies to a Group / Business.
Press the Send to Report > Go Button that sends selected (Share:) to the Reports Page.
  Non Administrator Users can only Export self Authored Events.  
Compare 2 Subjects/People or Group/Businesses to compare or compare Notes to Event/Activity Notes The 'Drop-Down' Box,   Compare_Fcn   or   Compare_From   Press Go that gives:   From:_TTO9988   then drop-down to   Compare To*   and select another Group/Business or use the 'Switch' Button to move the Base (*) to search for a Subject/Person to find and select or go to the Chronology Page to compare Notes for Comparison. Now Go to the Comparison Page.
Import .vcf/.csv Files from your Google Contacts (or iCloud or others...), save these .vcf files in your Import (\Calandex III\CdexFiles\CdexImport) Directory. Import saved Phone or Internet Contacts from the Internet standard .vcf file. Simply create a .Cdex File (auto) and Compare and Import. Go
You can also select Reverse Lookups Go.

Search for Data:

Select either Subject/People, Groups/Business, or the Subjects or Groups category.
Subject/People:
    ID Number - First Name/Middle Name/Nickname - Last Name - Share Name - Birth Day - Search Notes
Groups/Business:
    ID Number - Category - Name - Products/Services/Function - Search Notes
Subjects or Groups:
    Address - Phone - Web Site - E-Mail - Date(s) Who In
'Data Mining':
    Note the Star (*) after the 'Group / Business' header. Also notice 'Finding Groups by...' under the selection boxes. This means that the Group is the base and the List Subjects - Members of the Group > List Button will list all the Member Subjects. Now press the 'Switch' Button. The Star (*) will now be after the 'Subject / Person' header and 'Finding Subjects by...' appears under the selection boxes. This is a very powerful tool to use to locate People, Businesses, and/or Families that are connected to each other.
The List Buttons under Address/Web & Phone/E-Mail allows selection of respective Records associated with the Subject and/or Group in the view. Tip: A Teal color implies that there are Records available that refer to both the Subject and Group.

Editing MVDB Notes

To get to the 'MVDB Notes Edit Page', just Click on the appropriate 'Notes' Box. Go to the 'Help' Page for: Edit Event Notes by Clicking on a Notes Box then scroll down to the second picture. The Edit Notes procedures for Events and MVDB Data is Similar. 'Simulate Clicking on a Notes Box.'
Tip: To send someone a txt message that you want to remember and look up later, Create the message in a word processor, copy it here as a 'Send' Note, push the txt button and paste the message in the 'Message:' Box, make sure the phone number is the only one checked above, then press 'Send';

Go to the top of the Page

---

Editing MVDB Data:
Note: Permanent Data cannot be changed unless the MVDB is in Edit Mode.
Press the 'Edit' Button, 3 check box options become available:

Edit Current Data
Add New
Delete Current Data

Non Administrator Users can only Edit self Authored Events.

Editing Current MVDB Data: Current Data is simply the Data in the Current view. Check the 'Edit Current Data', 4 or 5 check boxes become available: if there are no Subject / Group attached to the base Group / Subject respectively. Subject / Person Group / business Address / Web Phone / EMail Subject to Group Title

Edit Current Data Go to the top of the Page

Editing: Adding New Subject (Group) MVDB Data: Press the 'Add New Button', 5 check box options become available: The 'OK' Button becomes available immediately after checking either the Subject (or Group) Box is checked. When the 'OK' Button is pressed, the new data entry forms are opened & highlighted. Tip: Use the 'Tab' keys on the keyboard to move around while you add data. (auto entries are recorded and entered in the City/State data when the 'Tab' key is used)

Add New Subject (Group)

Editing: Adding New Address and/or Phone MVDB Data: Press the 'Add New Button', 5 check box options become available: The 'OK' Button is not available until after checking either the Address and/or Phone Box is checked, then you must pick either the Subject or group for attachment. When the 'OK' Button is pressed, the new data entry forms are opened & highlighted. Tip: Use the 'Tab' keys on the keyboard to move around while you add data. (auto entries are recorded and entered in the City/State data when the 'Tab' key is used)

Add New Address and/or Phone Go to the top of the Page

Editing: Auto Inputting of MVDB Data: Press the 'Edit Button' (in the 2 Images for adding New Input directly above), The Edit Panel is replaced by the view to the right. This panel sets up all your Auto-Inputs Select the Auto Input Data to be changed. Click on one or add a new one to the list. Decide if default mode will be checked. if so, check the 'Auto Input' box, then 'Save' Select the next Data to change or 'Quit'

Auto-in - Set Data

Import Cell Phone Contact .vcf & .csv Files to the (MVDB)
Click the 'Import vcf csv File' Button on the MVDB Page
Select a .vcf or .csv File from the list

Largest      Smaller      Smaller      Smallest

Creating a .Cdex Import File from a .vcf or .csv File

Select a File from the Import Directory (/Calandex III/CdexFiles/CdexImport).
  If you select a .vcf File, a .csv file will be created, click yes to continue the process.
  You can now create the .Cdex File one entity at a time.
Line '0' is a template only
Move down 1 Line at a time, make any edit corrections or additions.
Add and Save to the .Cdex Import File you are creating.
When you Exit, you will then be able to Compare and Import. The Page will appear at Exit time.

Reverse Lookups to the (MVDB)

Largest      Smaller      Smaller      Smallest

Select Subjects or Groups for Reverse lookups.

Tip: Select Phone, then input the last 4 numbers of your search.
For Date / Who-In, Who-In is the Author or who put the data in the system, for example:
Pick Date(s):
greater than
less that
greater than and less than


then pick the User Alias.
Note that you have the option of picking:
just the Author, eliminate the Date by choosing a Date less that and equal to a date in the future.
just the Date(s)
both the Author and the Date(s) limitations in your search.

Date / WhoIn Select Panel