Contents
Phone Lister is an application for managing corporate phone lists and personnel data.
Installing Phone Lister
Getting started
Using Phone Lister
Administrator Functions
Preventing Data Corruption
Frequently Asked Questions
Multi-Language Support
License
Purchase Information
Feedback
Other CyberMatrix Software
Find up to date information on all CyberMatrix software at:
http://www.cybermatrix.com
Installing Phone Lister
DataBase Updates for Existing Phone Lister Users
The easiest way to upgrade Phone Lister and continue using your old data is to simply install over the old version. Be sure to backup your data first as a precaution. If you want to use your old data in a new folder you will either have to copy over your entire old data folder to the new folder and then point the software to use this new folder or install data in a new folder and then copy over the database files. The database files are those with the .Dat and .Idx extensions.
NOTE: This version of Phone Lister requires major updates to the database files. It is strongly recommended you backup any existing Phone Lister data before using this software. These updates will occur automatically when this version is first run. However, the updates cannot be performed if anyone else is using the program. Before running this version ensure no one else is running the application on your network.
Custom Report Updates
Whenever Phone Lister is installed, it will overwrite any existing reports. Therefore, if you have made changes to any of the included reports you should backup them up before upgrading.
Installing Phone Lister
There are three ways Phone Lister can be installed:
On a single user's machine.
On a shared network location where the program and data is accessed by all users.
On every user's machine with only the data stored on the network.
Note: if installing this software for use by multiple people, all people must have read/write access to the Data folder on the shared drive.
Installing Phone Lister on a single user's machine or a fully shared network location
Use the setup program to make the initial install on a local drive for a single-user. When prompted for an installation type, choose the first option, Standard. The data will be stored in the shared user Application Data\CyberMatrix\PhoneLister folder. E.g. C:\Documents and Settings\All Users\Application Data\CyberMatrix\PhoneLister. If you want to use a data folder in another location, you should choose the Client Only option when at the installation type selection screen. Otherwise, you will have to change the Data Path setting in the configuration screen. The DataPath setting is stored in a text file called PhoneLister.Ini. This file can be found in the user Application Data\CyberMatrix folder. E.g. C:\Documents and Settings\Administrator\Application Data\CyberMatrix\PhoneLister.Ini.
Installing Phone Lister on one or more machines with network-shared data
There are two ways Phone Lister can be installed in order to share data with multiple people: fully shared and shared data only. In a fully shared setup, the program and all data are installed on a shared network location. Users will use icons to access the software. To tell the program where the shared data is located you will need to either:
1) Enter the data path when you see the file missing message after trying to run the software on each client or
2) Copy over a PhoneLister.Ini file containing the DataPath setting to each client's C:\Documents and Settings\[UserName]\Application Data\CyberMatrix\ folder.
3) Install the shared data folder in a folder called "Data" off the shared program folder. That is, if you installed Phone Lister into a folder called I:\Shared\PL, just install the data to I:\Shared\PL\Data.
In a shared data only setup, just the data resides on a shared network location. The software and other support files reside on the user's own computer. Installing Phone Lister in this way will generally be faster since the program executable will not always be pulled down through the network. However, installation and applying updates will involve significantly more work.
To install only the data on the network and install Phone Lister on one or machines with network-shared data do the following:
Run the setup program on a single machine.
Choose the Data Only option, when at the installation type selection screen.
After installing the data, run the setup program again to install Phone Lister on all the machines that need to use the software. If you are sharing the entire application on the network, just install to this machine.
Choose the Client Only option, when at the installation type selection screen.
At the "Enter Network Data Location" prompt screen, enter the network data folder location where you installed the data previously.
Setting up the User's Workstations
In a fully shared multi-user setup, the Phone Lister program files and data will reside in a common directory on the network. You will need to manually setup icons for your users.
Security
The default password for the Administrator login is "magic". To ensure you have a secure system change the password immediately. Write down the new password and store it in a secure location such as the company safe.
Getting Started
Purpose of Phone Lister
Phone Lister is an application for managing corporate phone lists and personnel data.
Entering Data
The first step in using Phone Lister is to enter your data. Your data will include information about your employees, sites and departments. When you first use the program, there should be some sample data. Once you have finished experimenting with this data you should erase it and enter your own data. Data is erased and added in the Data Manager screen. See the Data Manager link for more details on deleting old data and entering new data.
Entering Phone List Data
The first step is to enter your phone list data. Phone list data is entered in the Phone List table using the Data Manager.
Sites
Sites are the different buildings or locations where your employees are located.
Departments
Departments are the groups each employee belongs to.
Related topics: Using Phone Lister, Viewing and Editing Table Data
Using Phone Lister
Getting to Know the Main Screen
Working with Phone Lister Data
Sorting Phone List
Searching for List Entries
Switching Between Split-View and Full Screen view
Configuring Phone Lister
Viewing Reports
Custom Reporting
Getting to Know the Main Screen
On starting Phone Lister you will see the main form.
The Phone Lister main screen consists of the menu bar, the tool bar and the list view.
The menu bar
The menu bar has three sections: File, View and Help.
The File section
The File section contains the following functions:
Find - Locates records where the current field contains the entered text. See also: Searching for List Entries
Open Database - Brings up a folder selection dialog to allow changing to a whole new database.
Language - Contains a sub menu of all the different language available for this program. To change to a different language just select the desired language from the sub-menu. See also: Multi-Language Support
Open registration key file
This item is only seen in the non-trial software. Choosing this menu item allows you to import a registration key file to properly register the software.
Close - Closes Phone Lister.
The View section
The View section contains the following functions:
Picture - Shows the picture, if any, assigned to the current phone list entry.
Admin Screen - Brings up the Admin Screen where list data is entered and program options are configured. See also: Administrator Functions
Reports - Brings up the Reporting screen where several different phone list reports may be viewed. See also: Reporting
Options - Split Screen - Splits the screen into two sections with the phone list on the left and detail of the selected phone list entry on the right. See also: Switching Between Split-View and Full Screen view
Sort - Allows the phone list to be sorted either ascending or descending by the selected column. See also: Sorting Phone List
The toolbar
The toolbar consists of several buttons. These buttons perform essential functions of the Pro Schedule program. These essential functions can also be found on the menu.
The data navigator Bar
The bar in the middle of the toolbar is the data navigator. The data navigator is for navigating the records of the phone list. The first button |< will move to the first record of the phone list. The second button < will move to the previous record. The third button > will move to the next record. The fourth button >| will move to the last record. The last button refreshes the phone list to show the latest changes made to it.
The Alphabetic Toolbar
The alphabetic toolbar allows you to quickly move to the section starting with the letter shown on the selected button. See Also: The Alphabetic Toolbar
The phone list
The phone list shows a list of people and their contact details. The information shown has been setup by the administrator of the software. The titles at the top of the list can be clicked to sort that column. See also: Sorting Phone List
The contact detail section
The contact detail section shows the full details vertically of the currently selected phone list record. This section is only seen when the Split Screen option has been enabled. See also: Switching Between Split-View and Full Screen view
Sorting Phone List
It is very easy to sort the phone list. To sort simply click on the data grid title cell of the column you wish to sort on. Click the cell once more to sort descending. You may also sort by choosing View | Sort | Ascending and View | Sort | Descending from the menu.
Searching for List Entries
To search for text in the data grid first click in the column in which you wish to search. Then choose File | Find from the menu. A search dialog will pop up.
By default the case of the text is ignored. For case sensitive searches, check the Match Case check box.
To search in the reverse direction ensure the Up radio button is selected.
Switching Between Split-View and Full Screen view
By default the main phone list screen is shown in full-screen view. To have a detail window shown to the left side of the screen simply choose View | Options | Split Screen from the main menu.
Alphabetic Toolbar
Click on a button to quickly move to the section starting with the letter shown on the selected button. For example, if your list is sorted by last name click anywhere in the last name column and press the B button to quickly move to the first entry starting with B.
Reporting
Phone Lister has several reporting features. Visit the links below to find out more about them.
Getting to know the Reporting Screen
Exporting reports to different formats
Customizing reports
Viewing Reports
The phone list reports enable you to print out hard copies of the phone lists. The Administrator determines which lists can be viewed. To view the available lists choose View | Reports from the main menu. The following screen will appear:
The reporting screen consists of a menu, the report selector and the filters. See below for a description of each section.
Menu
The menu consists of two parts: File and Help.
File
Print Setup - Brings up a print setup dialog so you can change printer options such as the printer used.
Print - Sends the current report to the printer.
Print Preview - Sends the current report to the screen so you can check it before printing.
Close - Closes the reporting screen and returns to the main screen.
The Report Selector
The report selector allows you to select a report to view. It consists of a list of all the available reports. When a report is selected, it will have a dot to the left of the report name.
Filters
The report filters allow you to limit the amount of data seen on the reports. See below for a description of the different filters.
Site filter
Select a site to show only phone list data for a certain site.
HTML Reports
Any report can easily be viewed in HTML format. To show a report in HTML format just make sure the HTML check box in the bottom right corner of the report list screen is checked. Choose File | Preview to view the selected report in your web browser.
Administrator Functions
Getting to Know the Administrator Screen
Entering Phone List Data
Assigning Picture to a contact listing
Phone List Table Details
Excluding Records from the user list
Viewing SQL Queries
Deleting Records
Inserting Records
Importing and Exporting Data in CSV Format
Working with Multiple Databases
Record Search and Replace
Backing Up Data
Restoring data
Customizing Reports
Configuring Phone Lister
Getting to Know the Administrator Screen
To access the administrator functions, including phone list data entry and options setting, select View | Admin Screen from the main menu. The following screen should appear:
The Administrator screen consists of three parts: the menu bar, the toolbar and the data view tabs.
The Menu Bar
The menu bar has six sections: File, Search, View, Records, Phone Lists and Help.
File Section
The File section contains the following functions:
Import CSV file - Imports a CSV file into the selected table. See also: Importing and Exporting Data in CSV Format
Export to CSV - Exports the current table to CSV file format.
New SQL File - Opens the Notepad text editor to allow you to create a new SQL file. See also: Viewing SQL Queries
Edit SQL File - Opens the Notepad text editor to allow you to edit an existing SQL file.
Open SQL File - Allows you to choose an existing SQL file and shows the results of that query in the detail tab data grid.
Execute SQL File - Allows you to choose an existing SQL file and executes that query. See also: Executing SQL Queries
Re-index Table - Re-index the currently selected table. See also: Re-indexing Tables
New Database - Creates a new database in the chosen folder.
Close - Closes the Data Manager screen.
Search Section
The Search section allows you to find records when in any of the tab views. To search for a record you must first click in or tab over to the field in which you want to search. Then choose Find from the Search menu. In the dialog that pops up, enter the text you want to search for then press the Find Next button. To find the next occurrence of that text press the Find Next button again.
The View section
The View section contains the following functions:
Phone List Data - Shows the phone list table in the detail tab view.
Site Data - Shows the site table is the detail tab view.
Department Data - Shows the department table data in the detail tab view.
Options - Brings up the configuration screen. The configuration screens allows you to customize Phone Lister to a certain extent by changing several different options. See also: Configuring Phone Lister
Records Section
The Records section contains the following functions:
Insert Record - Inserts a record above the current record. See also: Inserting Records
Delete Selected Records - Delete all the selected records. See also: Deleting records
Delete All Records - Deletes all the records in the current table.
Load Image - Brings up an open Jpeg file dialog allowing the selected file to be bound to the current record.
Copy Record - Copies the selected record into the Windows clipboard for pasting later.
Paste Record - Pastes the record contained in the Windows clipboard into a new record.
Cut Record - Copies the selected record into the Windows clipboard for pasting later and then deletes the record.
Backup Data - Makes a time-stamped backup file of all tables. See also: Backing up Data
Restore Data - Replaces your existing data with the tables from a previous data backup. See also: Restoring data
Phone Lists
New - Brings up the custom report designer allowing you to create a new report. See also: Custom Reporting
Edit - Show the report selector dialog to allow you to choose a report to edit in the custom report designer. Provided the SQL is not changed you will be able to preview the edited report inside the custom report designer.
Print - Show the report selector dialog to allow you to print a custom report.
Preview - Show the report selector dialog to allow you to print preview a custom report.
The Data navigator Bar
The bar at the top is the data navigator. The data navigator is for navigating the records of the current table. The first button |< will move to the first record of the current table. The second button < will move to the previous record. The third button > will move to the next record. The fourth button >| will move to the last record. The + button will add a new record. The - button will delete the current record. The button with the check mark will save changes made to the current record. The x button will cancel any changes made to an unsaved record. The last button refreshes the current table to show the latest changes made to it.
The Data Tabs
The data tabs show all the tables used in Employee Scheduler and allow you to view and edit the data in them. See the Viewing and Editing Table Data section for more details.
Importing and Exporting Data in CSV Format
Importing Data
Phone Lister can import data in the form of CSV files. If you have existing data from another application, this data can be imported into Phone Lister provided it is saved in the right format. CSV files used for importing must follow the exact same format as the table into which they will be imported. That is, if you look at a table in the detail view of the Data Manager you will notice the order of the fields in the table. This is the same order that your CSV file must be in. Most spreadsheet programs like Microsoft Excel allow you to easily load in CSV file and move columns around.
See the section Phone Lister Tables for more details on each table's field types and sizes.
To import a CSV file, open the Data Manager and select the table from which you want to import into. Then choose File | Import From CSV from the Data Manager menu. A wizard will guide you through importing the CSV file.
Exporting Data
Data can also be exported in CSV file format from Phone Lister. This data can be imported into other applications that can handle CSV imports.
To export a CSV file first select the table to export from the Data Manager. Then choose File | Export To CSV from the menu. A file select dialog will allow you to select the CSV file to export.
Viewing SQL Queries
It is possible to view the results of simple SQL statements stored in external text files. SQL stands for Structured Query Language; it is a way to extract information from databases using English-like commands.
To create a new SQL file, either create one using any text editor or choose File | New SQL File from the menu. Save the SQL file to a folder, usually the Phone Lister Data folder. Remember to save with the .SQL extension.
To open a previously saved SQL file choose File | Open SQL File from the menu. A file select dialog will pop up allowing you to choose a SQL file. After selecting a file, you should see the results of the query in the data grid.
Here is an example of a simple SQL Select query:
SELECT FirstName, LastName, Extension, location FROM PhList
ORDER BY FirstName, LastName
WHERE SiteID='S2'
ORDER BY FirstName, LastName
This query shows all phone list records, sorted by first and last name, for the site "S2".
Note that when using dates in SQL, you must use the ISO date format (yyyy-mm-dd).
For more information on SQL, consult a good introductory database textbook. There is also some documentation on the supported SQL calls in the database engine manual. To read this manual, choose Help | DB Engine Manual from the Data Manager menu.
Executing SQL Queries
It is possible to execute simple SQL statements stored in external text files. SQL stands for Structured Query Language; it is a way to manipulate information from databases using English-like commands.
To create a new SQL file, either create one using any text editor or choose File | New SQL File from the menu. Save the SQL file to a folder, usually the Phone Lister Data folder. Remember to save with the .SQL extension.
To open a previously saved SQL, file choose File | Open SQL File from the menu. A file select dialog will pop up allowing you to choose a SQL file. After selecting a file, you should see the results of the query in the data grid.
Here is an example of a simple SQL Update query:
UPDATE PhList SET LastName='Smith' WHERE LastName='Jones'
This query will update all phone list records where the LastName is "Jones". For these records, the LastName will be renamed to "Smith".
For more information on SQL, consult a good introductory database textbook. There is also some documentation on the supported SQL calls in the database engine manual. To read this manual, choose Help | DB Engine Manual from the Data Manager menu.
Re-indexing Tables
Over time, one of your tables may become corrupted. See the section Avoiding Corruption to learn more about table corruption. Usually when a table is corrupted, you will see an error message such as:
DBISAM Engine Error #9217 Error reading From Data File C:\Program Files\Phone Lister\data\PhList.dat
Corrupted tables must be re-indexed to make them function properly. Re-indexing or repairing the table is simple. Just select the corrupted table by choosing View | Phone List Data or View | Site Data from the Admin menu. Then choose File | Re-index Table from the Data Views menu. It does no harm to repair a non-corrupt table.
DBSys
If you are unable to open the application to do a re-index, you can get the DBSys utility. DBSys is a utility from Elevate Software, the makers of the database engine used in Phone Lister. Use this program to repair the affected table.
Last Resort
If after trying all these solutions you still have problems, you can zip up the problem data files and e-mail them to CyberMatrix support.
Inserting Records
To insert a record when in form view, press the + button on the navigator bar.
To insert a record in the detail view, click on the record above which you wish to insert a record. Then either press the [Ctrl]+[I] key combination or choose File | Insert Record from the menu.
Deleting Records
To delete a record when in form view, navigate to the record and press the - button on the navigator bar.
To delete one or more records in the detail view, select the records to delete. To select multiple records, click on the first record then hold down the [Ctrl] Key and click to select individual records or hold down the [Shift] key to select a range of records. To delete the selected records, either press the [Ctrl]+[D] key combination or choose File | Delete Selected Records from the menu. To delete all the records in the current table, choose File | Delete All Records from the menu.
Backing up Data
To create a backup of your data choose Records | Backup Data from the menu in the Administrator screen. Running this function will create a zip file in the Data\Backup folder. The zip file will have a name consisting of the current date and time the archive was completed.
Related topics: Restoring Data
Restoring data
To restore previously archived data choose Records | Restore Data from the Administrator menu. A file select dialog will pop up allowing you to choose the archive you would like to restore.
Entering Phone List Data
Phone list data can be entered in two ways, by detail view and by form view. In both views you can use the buttons on the data navigator to add and delete records and to navigate through the current table. To cancel any changes made to the current record press the ESC key. To save the changes to an edited record simply move off the record to another record or click the update button (the one with a check mark) on the toolbar.
Entering data in detail view
In Detail view data is entered in the data grid. First, make sure the Detail tab is selected on the Data View Selector tab. To enter data in a grid cell, simply position the cursor on the cell and type in the data.
To add a new record, you can position the cursor to the end of the table and press the down arrow key.
Entering data in form view
To enter data in form view first choose the table you wish to enter data for by selecting the appropriate tab on the Data View Selector tab. Enter your data in the fields.
Assigning picture to a contact listing
To associate a Jpeg image with a contact record, place the cursor on a record. Then choose File | Load image from the menu. A Jpeg image file selector dialog will pop up. Select the desired file and press the Open button. The selected image will now be associated with the current record.
Phone List Table Details
Phone Lister has two tables: Departments, Phone List Data and Site Data.
Departments
This table lists all the departments. Here are the field sizes and descriptions:
Department - Text - 20 - unique
The Department field links to the Department field in the Phone List table.
Phone List
FirstName - Text - 20
LastName - Text - 20
ID - Text - 10
CountryCode - Number
AreaCode - Number
Prefix - Number
Extension - Text - 15
Location - Text - 10
Department - Text - 20
Discipline - Text - 20
Supervisor - Text - 30
Flag - Text - 1
SiteID - Text - 10
DirectLine - Text - 15
Fax - Text - 15
Beeper - Text - 15
Mobile - Text - 15
HomePhone - Text - 15
Email - Text - 30
Address1 - Text - 20
Address2 - Text - 20
City - Text - 15
State - Text - 15
Country - Text - 15
PostalCode - Text - 15
BirthDate - Date
SpouseName - Text - 30
Picture - BLOB
Exclude - Boolean
The SiteID field links to the SiteID field in the Sites table. The Department field links to the Department field in the Departments table.
Sites
This table lists all the different sites and their description. Here are the field sizes and descriptions:
SiteID - Text - 10 - unique
Description - Text - 30
District - Text - 50
Location - Text - 30
Phone - Text - 15
Fax - Text - 15
Extension - Text - 10
Contact - Text - 30
Notes - Unlimited text
Users
This table lists all the users of the software. Here are the field sizes and descriptions:
LoginID - String - 30 - unique
LastIn - TimeStamp
LastOut - TimeStamp
Excluding records from the user list
If you would like to prevent certain contact records from showing up on the user phone list screen, make sure the Exclude field for that record has a check in it.
Working with Multiple Databases
Phone Lister allows the creation of multiple databases.
Creating a new Database
To create a new database choose File | New Database from the Admin menu. A select directory dialog box will pop up. Type in the folder name and press the OK button and then the Yes button. The new database will have now been created. You will then be asked if you'd like to change to the new database now.
Record Search and Replace
Text in record fields may be searched for and even replaced. To find a piece of text first click on the column you want to search on. Then choose Search | Find from the Admin menu. In the search dialog, enter the text to search for then click the Find Next button. The current data grid row indicator on the left should move to the first occurrence of the text.
Configuring Phone Lister
Phone Lister may be customized to a certain extent by modifying the many configuration options. The configuration options are changed in the configuration screen.
To change Phone Lister options choose View | Options from the admin menu. There are five different option tabs: the General tab, the Security tab, the User Fields tab, the User Reports tab and Field Terms.
General Options
The General Options section is for setting program and report options.
This is what the General Options section looks like.
Program Options
Show Tips on Start Up
If this option is checked helpful tips will be seen when the software first runs.
Report Options
Reports Location
This value indicates the path where the reports folder is located. To change the path, click on the open folder icon to the right and select a new path. Ordinarily, the Report Location field will be blank. When the Report Location field is blank, the report location will default to the Reports folder off the data folder (usually C:\Program Data\Project Clock\Reports\).
Security Options
The Security Options section is used to enable/disable security and to change the admin password.
This is what the Security Options section looks like.
Enable Security
If this box is checked users must login using the admin password in order to add/edit data and change program options.
Old Password
Enter the currently used password here.
New Password
Enter the new password you now want to use here.
Verify
Re-enter the new password here.
Change Password
This commits the new administrator password.
By default security is turned off. This means that in a multi-user environment, any user will be able to view and edit the phone list data. Check the Enable Security box to enable security. When security is enabled a user must enter a password in order to enter the administrator section of the program.
The default password is "magic". You should change this password if it is important that users cannot view or change the phone list data.
To change the password first enter the old password in the Old Password edit box. Then enter your new password in the New Password and Verify edit boxes. Press the Change Password button to change the password. If the new passwords Password and Verify edit boxes are identical the password will be changed.
Important: remember to store your changed password in a safe location such as the company safe.
User Field Options
This page is used to enable which symbols are available in the Flag field pull-down list. This page is also used to determine which of the database fields ordinary users will see on the main screen listing.
This is what the User Field Options section looks like.
Add Symbol
When a symbol is chosen from this list it will show up in the symbol list.
Symbol List
This is the list of symbols that will show up in the pull-down list of the Flag data field.
Available Fields
These are all the fields that ordinary users cannot currently see in the main phone list data view.
User Fields
This is a list of all the fields that ordinary users will see in the main phone list data grid. The order of the fields here is the order they will be seen on the data grid. Move fields around by dragging and dropping them to a new position.
To add symbols to the Flag pull-down list simply select the desired symbol from the Symbols pull-down list. The symbol you chose should appear in the symbol list.
To configure which fields are visible to users use the arrow buttons to move available fields into the user field list. The order of the fields in this list determine the order in which the fields are displayed in the user data grid. You may change the order of the fields by dragging and dropping.
User Report Options
This page is used to configure which of the available reports ordinary users can see in the Phone List selector screen.
This is what the User Report Options section looks like.
Available Reports
This is a list of all the available reports in the Reports subfolder.
User Reports
This is a list of all the reports that the users will see in the Phone List selector screen.
Use the arrow buttons to copy reports over to the User Report grid. To delete reports from the User Report Grid first click on the cell to select the row then right click the mouse. From the pop-up menu choose delete.
Field Term Options
This screen is used to change the terms used to describe the data shown on the main screen. To change the displayed text for a term simply enter the new text to the cell immediately right of the data term.
This is what the Field Term Options section looks like.
Terms list
Lists all the database field names to the left and all user-modified terms to the right.
Customizing Reports
This software comes with a powerful report designer feature. With the report designer, you can create your own unique reports or edit existing ones.
Editing an Existing Report
The easiest way to create a new report is to edit an existing one. This software comes with several pre-built reports. To edit one of these select Custom Reports | Edit from the Report Selector menu. A file select dialog will pop up allowing you to choose a report. After selecting a report, the report designer will appear. In the report designer you can add graphics and text to the report or even move fields around or add new ones. See the report designer help file for more details. To add new fields you will need to modify the SQL variable to include those fields. The SQL variable is explained below.
Adding new fields to reports
To add new fields to a report all you need to do is modify the report SQL to include the two fields and then add the two field boxes to the report.
Modifying the SQL variable:
First start the report designer by selecting Custom Reports | New from the Report Selector menu. Now modify the SQL variable to include the new fields. From the menu choose Report | Variables. Click on the SQL variable. You will see the existing report SQL. Add the new fields to the end of the SELECT clause. Click OK to save the changed variable.
Now add the new fields to the report:
See the Creating Reports section below on how to add the new fields to the report.
Creating Reports
There are several steps to create your own reports.
First, create the report:
Start the report designer by selecting Custom Reports | New from the Report Selector menu.
Next assign the datasets
Datasets are assigned in the Data tab to the right. Double click where it says No data available. In the selection dialog check frxDBDataset1. You will see the available data fields appear.
Now create the SQL variable:
From the menu choose Report | Variables.
Click on the New Category button (the button with a glinting yellow folder icon). This will create a new category.
Name the category something like ReportVariables.
Click the New Variable button (the glinting fx button).
Call the new variable SQL.
In the Expression box, enter your SQL query. For example: SELECT * FROM PhList.
Click OK to save the new variable.
Note that the existing template.fr3 report has this step completed for you already.
Now add bands to the report:
Click on the Insert Band button (the button with the three squares and plus sign).
A list of band types will appear.
Click on Report Title, Page Header, Master Data (select the frxDataset1 Dataset) and Page Footer bands.
Now add fields to the report:
In the Data tab to the right select the fields of the query you want to see on your report and drag them onto the Master Detail band positioning them where you want them. The Master Detail band is the long rectangle in the middle of the report with the blue heading.
Note that the fields available may not match what you have added to the SQL variable. If that is the case you will have to save the report (if you haven't already), close the report designer and reopen it. This will update the query to use the SQL the report is based on.
Now add field labels to the report:
Click on the Text Object button (the button with the ab on it).
No click on the Page Header band where you want the first field caption to appear.
A dialog will pop up allowing you to type the text for the field label. Type the text and press the green check mark to save.
Repeat this for all other field labels.
Your report should now work. Save the report. Press the Close button to return to the Reporting Screen. Choose Custom Reports | Preview Report from the menu. Select your new report and press OK to see what your report will look like when printed.
Note that choosing File | Preview from the report designer menu may not work depending on what fields you've added to the report. To get the report to preview correctly from the report designer you will need to save the report (if you haven't already), close the report designer and the preview the report from the report selector screen. This will update the query to use the SQL the report is based on.
Additional Help
See the UserManual-en.pdf help file for more details on report design (choose Help | Report Designer from the Reporting Screen menu).
Purchase Information
You may freely evaluate the trial version Phone Lister without any costs for a period of 30 days. If you wish to continue using the program after 30 days, you must purchase it from CyberMatrix. If you do not wish to purchase the program after 30 days you must uninstall it from your computer.
After 30 non-consecutive days from the time of installation the software will cease functioning. Although the program will be basically unusable, it will still be possible to register it.
The following rates apply to bulk purchases of the Phone Lister program:
Phone Lister
Single license $50.
10 users $200.
25 users $350.
50 users $600.
100 users $1000.
Site License $1500 (for up to ten different sites).
Non-profit Discount
Not for profit agencies are entitled to a 10% discount when software is purchased directly from CyberMatrix.
There are several ways to purchase Phone Lister:
All CyberMatrix software can be purchased directly from CyberMatrix by fax, phone, funds transfer, purchase order or by regular postal (snail) mail. Note that all prices are in U.S. dollars.
Fax
For fax orders click here to fill out the order form and fax toll free to 1-866-425-2670.
Internet Secure Server
This program can be purchased immediately on the Internet by credit card via an Internet secure link. Purchasing solely via the Internet also eliminates shipping and handling costs. Please go to:
http://www.cyber-matrix.com/
Phone
For phone orders using a Visa credit card you may call CyberMatrix directly at (250)503-1009.
Toll Free
For phone orders by Visa or American Express credit cards, call toll free in Canada and the U.S.: 1-888-664-0383.
Funds Transfer
Funds may be transferred directly from your bank account to ours. Contact us for account information. There is an additional $10 charge for orders under $300 when using this option.
Snail Mail
You can also register Phone Lister by printing and filling out the registration form. (Note, you may also use the registration form on the Phone Lister main menu: Help | Purchase Information.)
Purchase Order
Companies and government agencies may purchase this software by way of purchase orders. Standard credit references are required before PO's may be processed. This information may be faxed toll free to 1-866-425-2670.
After Purchasing
After you have purchased Phone Lister, you will receive from CyberMatrix the full commercial version of Phone Lister and instructions on registering the software. The commercial version can be sent out on disk for an extra fee or downloaded for free.
If you have chosen not to receive the software on disk, when your order and payment has been received you will promptly be e-mailed a registration key. It is therefore important to include a valid e-mail address when you place your order. Instructions will be provided on how to use the registration key with the program.
Upgrade Information
All registered users of Phone Lister are guaranteed that all future product revisions, both major and minor will be provided free of charge for a minimum of six months after the date of purchase.
Any major revisions after six months may accompany an upgrade fee that will be not more than 50% of the suggested retail price for said revision.
All upgrades will be made available for electronic download.
See also: Registration Form, Bulk Purchases
Bulk Purchases
The following rates apply to bulk purchases of the Phone Lister program:
Phone Lister
Single license $50.
10 users $200.
25 users $350.
50 users $600.
100 users $1000.
Site License $1500 (for up to ten different sites).
See also: Order Form, Purchasing Phone Lister
Phone Lister Order Form
Remit To:
CyberMatrix Corp.
3104-30th Ave
Suite #224
Vernon, B.C. V1T 9M9
Canada
Fax: 1-866-425-2670
Name: _________________________________________
Company: _________________________________________
Address: _________________________________________
_________________________________________
_________________________________________
Ship To: _________________________________________
_________________________________________
_________________________________________
(For credit card orders the name and address must be exactly the same as they appear on your credit card and statement.)
Email: _________________________________________
[All prices in U.S. Dollars.]
Registration details
Phone Lister
___________ Single license $50.
___________ 10 users $200.
___________ 25 users $350.
___________ 50 users $600.
___________ 100 users $1000.
___________ Site License $1500.
___________ Number of users [enter "Site" for a site license].
___________ SubTotal
___________ Send software on electronic media (disk) - $5 - ($15 registered).
___________ Send software by courier - $30 ($60 outside North America).
___________ Send registration code via e-mail - FREE (make sure to include e-mail address).
___________ Total
Payment method
[ ] Check
[ ] Money Order
[ ] Visa - Credit Card Number: ______________________ Expire Date: ___________
[ ] Mastercard - Credit Card Number: ______________________ Expire Date: ___________
[ ] Amex - Card #: ________________________________ CID #:___________ Expire Date:___________
[ ] Discover - Credit Card Number: ______________________ Expire Date: ___________
[ ] Purchase Order: ______________________
(For P.O.'s please fax your standard credit references form to 1-866-425-2670.)
Where did you hear about Phone Lister:
________________________________________________________________
Avoiding Data Corruption
Phone Lister uses a local database to store it's data. Unfortunately, local databases are susceptible to corruption if the computer is shut down abnormally. Corruption occurs while the program is in the middle of writing to the database and the program is prevented from completing the write. For this reason you should always perform proper shutdowns. You should never shut off the computer or reset it while Windows is still running. Perform a proper shutdown by choosing Shut Down and either Restart or Shutdown from the start menu. If your system starts to act abnormally try exit Phone Lister first and then perform a proper shutdown.
If your system appears frozen first try hitting the Ctrl + Alt + Delete key combination. This should bring up a task list. You may be able to end the task that is no longer responding. Sometimes the system will crash so hard that you cannot even bring up the task list. If this happens reset the machine and repair any corrupted data tables if necessary.
Repairing Tables
Over time one of your tables may become corrupted. Usually when a table is corrupted you will see an error message such as:
DBISAM Engine Error #9217 Error reading From Data File C:\Program Data\Phone Lister\PhList.dat
Repairing the table is simple. First select the corrupted table by choosing View | Phone List Data or View | Site Data from the Admin menu. Then choose File | Repair Table from the Data Views menu. It does no harm to repair a non-corrupt table.
DBSys
If you are unable to open the application to do a repair you can get the DBSys utility. DBSys is a utility from Elevate Software, the makers of the database engine used in Phone Lister. Use this program to repair the affected table.
Frequently Asked Questions
Questions for users new to computers and the Internet
Questions about CyberMatrix Software
Database/Multi-user questions
Questions about Phone Lister
Questions about Phone Lister
Q. When I Start Phone Lister the following error message comes up:
DBISAM Engine Error #9217 Error reading From Data File C:\Program Data\Phone Lister\data\PhList.dat
A. This is a corruption error. Phone Lister uses a local database to store it's data. Corruption can happen in any local database when a system is shut down abnormally. You should never shut down or restart a Windows machine without doing a proper Windows shutdown first (i.e., choosing Shut Down from the Start menu.) To repair the table, first select the corrupted table by choosing View | Phone List Data or View | Site Data from the Admin menu. Then choose File | Repair Table from the Data Views menu. It does no harm to repair a non-corrupt table.
DBSys
If you are unable to open the application to do a repair you can get the DBSys utility. DBSys is a utility from Elevate Software, the makers of the database engine used in Phone Lister. Use this program to repair the affected table.
Last Resort
If after trying all these solutions you still have problems, you can zip up the data files and e-mail them to UNCONVERTED WINHELP MACRO:! ExecProgram("support@cyber-matrix.com",)CyberMatrix support.
Multi-Language Support
This program can be configured to support almost any language. Currently only English is supported. However, users of this software may easily create support for their own language.
This software uses language files to store all its internal text strings. These files end with the .lng extension. To create a language file for your language do the following:
Simply open the existing English.lng file with any text editor such as Notepad.
You will see that the language file is split into two sections [Translations] and [Messages]. To convert to your language replace all the strings to the right of the equal sign (=) with your language's equivalent.
Note that menu captions use the ampersand (&) to enable a hot key on the character following it.
Finally save the modified text file to the name of your language, Eg. Francais.lng.
To try out your language file select File | Language from the main menu and select your language.
Please be sure to send us your translations so we can allow everyone else to use your language with this software as well. Contributors will be noted on this page.
Report Translations
The report list used in the program is generated from all the report files in the Reports folder. To translate the report names you will have to changes the report names to your language's equivalents.
Contact information
CyberMatrix feels a strong sense of commitment to meeting the requirements of its customers and potential customers. Please feel free to contact CyberMatrix at any time regarding what you did or did not like about the product.* Is anything missing, broken or can something be improved? The greatest effort possible will be made to timely incorporate customer suggestions into future versions of this product.
Customizations unique to your company's requirements can be performed for a negotiated fee. If you require certain features to be added to our software and cannot wait for a future version you can pay to have the new features added. Contact us for details.
Please email any comments or suggested improvements to CyberMatrix at feedback@cybermatrix.com
Technical Support
Technical support by e-mail is free of charge for all existing and potential CyberMatrix customers*. Technical support by telephone is free of charge** for all existing and potential CyberMatrix customers*. 24-hour emergency phone support is available for a $25 (US) per incident fee. Visit this web page for details:
http://www.cybermatrix.com/contacts.html
Please be sure you have searched the help and the CyberMatrix web site first before requesting support.
Please send any support requests to CyberMatrix support@cybermatrix.com
* Please assign a single representative of your company to contact CyberMatrix regarding support issues. Feedback is welcomed from anyone but only the designated support representative will be guaranteed a response.
** May be subject to change in the future.
Product license
BY RUNNING THIS SOFTWARE, YOU ARE CONSENTING TO BE BOUND BY AND ARE BECOMING A PARTY TO THIS AGREEMENT. IF YOU DO NOT AGREE TO ALL OF THE TERMS OF THIS AGREEMENT, DO NOT EXECUTE IT.
LICENSE GRANT.
CyberMatrix Corporation grants you a non-exclusive license to use the Software free of charge for evaluation and trial purposes only for a limited time. THE TRIAL VERSION OF THIS SOFTWARE CONTAINS CODE THAT DISABLES MOST OF ITS FEATURES AFTER IT HAS BEEN EXECUTED A PREDETERMINED NUMBER OF DAYS. This License does not entitle you to hard-copy documentation, support or telephone assistance.
DISCLAIMER OF WARRANTY.
The Software is provided on an AS IS basis, without warranty of any kind, including without limitation the warranties that the Software is merchantable, fit for a particular purpose or non-infringing. The entire risk as to the quality and performance of the Software is borne by you. Should the Software prove defective in any respect, you and not CyberMatrix Corporation or its suppliers assume the entire cost of any service and repair. In addition, the security mechanisms implemented by the Software have inherent limitations, and you must determine that the Software sufficiently meets your requirements. This disclaimer of warranty constitutes an essential part of the agreement. No use of the Software is authorized hereunder except under this Disclaimer.
TERMINATION.
The license granted will terminate after you have executed the program not more than thirty times unless you register the software. The license will terminate automatically if you fail to comply with the limitations described herein. You must destroy all copies of the Software upon termination.
TERMS APPLICABLE WHEN LICENSE FEES PAID:
LICENSE GRANT.
Subject to payment of applicable license fees, Licensor grants to you a non-exclusive license to use the Software and accompanying documentation ("Documentation") in the manner described below under "SCOPE OF LICENSE GRANT".
LIMITED WARRANTY.
Licensor warrants that for a period of ninety (90) days from the date of acquisition, the Software, if operated as directed, will substantially achieve the functionality described in the Documentation. Licensor does not warrant, however, that your use of the Software will be uninterrupted or that the operation of the Software will be error-free or secure. In addition, the security mechanisms implemented by the Software have inherent limitations, and you must determine that the Software sufficiently meets your requirements. Licensor also warrants that the media containing the Software, if provided by Licensor, is free from defects in material and workmanship and will so remain for ninety (90) days from the date you acquired the Software. Licensor's sole liability for any breach of this warranty shall be, in Licensor's sole discretion: (i) to replace your defective media or Software; or (ii) to advise you how to achieve substantially the same functionality with the Software as described in the Documentation through a procedure different from that set forth in the Documentation; or (iii) if the above remedies are impracticable, to refund the license fee you paid for the Software. Repaired, corrected, or replaced Software and Documentation shall be covered by this limited warranty for the period remaining under the warranty that covered the original Software, or if longer, for thirty (30) days after the date (a) of delivery to you of the repaired or replaced Software, or (b) Licensor advised you how to operate the Software so as to achieve substantially the same functionality described in the Documentation.
Only if you inform Licensor of your problem with the Software during the applicable warranty period and provide evidence of the date you purchased a license to the Software will Licensor be obliged to honor this warranty. Licensor will use reasonable commercial efforts to repair, replace, advise or, for individual consumers, refund pursuant to the foregoing warranty within thirty (30) days of being so notified.
If any modifications are made to the Software by you during the warranty period; if the media is subjected to accident, abuse, or improper use; or if you violate the terms of this Agreement, then this warranty shall immediately terminate. Moreover, this warranty shall not apply if the Software is used on or in conjunction with hardware or software other than the unmodified version of hardware and software with which the Software was designed to be used as described in the Documentation.
THIS IS A LIMITED WARRANTY, AND IT IS THE ONLY WARRANTY MADE BY LICENSOR OR ITS SUPPLIERS. LICENSOR MAKES NO OTHER WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT OF THIRD PARTIES' RIGHTS. YOU MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, SHALL BE LIMITED TO THE ABOVE LIMITED WARRANTY PERIOD. MOREOVER, IN NO EVENT WILL WARRANTIES PROVIDED BY LAW, IF ANY, APPLY UNLESS THEY ARE REQUIRED TO APPLY BY STATUTE NOTWITHSTANDING THEIR EXCLUSION BY CONTRACT. NO DEALER, AGENT, OR EMPLOYEE OF LICENSOR IS AUTHORIZED TO MAKE ANY MODIFICATIONS, EXTENSIONS, OR ADDITIONS TO THIS LIMITED WARRANTY.
TERMS APPLICABLE TO ALL LICENSE GRANTS
SCOPE OF LICENSE GRANT.
You may:
Use the Software on any single computer;
Use the Software on a network, provided that a licensed copy of the Software has been acquired for each machine permitted to access the Software through the network;
Copy the Software for archival purposes, provided any copy must contain all of the original Software's proprietary notices; or
If you have purchased a Right to Copy license for multiple copies of the Software, make the number of copies of Software (but not the Documentation) stated on the packing slip or invoice, provided any copy must contain all of the original Software's proprietary notices. The number of copies on the invoice is the total number of copies that may be made. Additional copies of Documentation may be purchased from Licensor.
You may not:
Permit other individuals to use the Software except under the terms listed above;
Permit concurrent use of the Software;
Modify, translate, reverse engineer, decompile, disassemble (except and solely to the extent an applicable statute expressly and specifically prohibits such restrictions), or create derivative works based on the Software;
Copy the Software other than as specified above;
Rent, lease, grant a security interest in, or otherwise transfer rights to the Software; or
Remove any proprietary notices or labels on the Software.
TITLE.
Title, ownership rights, and intellectual property rights in the Software shall remain in CyberMatrix Corporation and/or its suppliers. The Software is protected by copyright and other intellectual property laws and by international treaties. Title and related rights in the content accessed through the Software is the property of the applicable content owner and is protected by applicable law. The license granted under this Agreement gives you no rights to such content.
TERMINATION.
This Agreement and the license granted hereunder will terminate automatically if you fail to comply with the limitations described herein. Upon termination, you must destroy all copies of the Software and Documentation.
LIMITATION OF LIABILITY.
UNDER NO CIRCUMSTANCES AND UNDER NO LEGAL THEORY, TORT, CONTRACT, OR OTHERWISE, SHALL LICENSOR OR ITS SUPPLIERS OR RESELLERS BE LIABLE TO YOU OR ANY OTHER PERSON FOR ANY INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES OF ANY CHARACTER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF GOODWILL, WORK STOPPAGE, COMPUTER FAILURE OR MALFUNCTION, OR ANY AND ALL OTHER COMMERCIAL DAMAGES OR LOSSES. IN NO EVENT WILL LICENSOR BE LIABLE FOR ANY DAMAGES IN EXCESS OF THE AMOUNT LICENSOR RECEIVED FROM YOU FOR A LICENSE TO THE SOFTWARE, EVEN IF LICENSOR SHALL HAVE BEEN INFORMED OF THE POSSIBILITY OF SUCH DAMAGES, OR FOR ANY CLAIM BY ANY THIRD PARTY. THIS LIMITATION OF LIABILITY SHALL NOT APPLY TO LIABILITY FOR DEATH OR PERSONAL INJURY RESULTING FROM LICENSOR'S NEGLIGENCE TO THE EXTENT APPLICABLE LAW PROHIBITS SUCH LIMITATION. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THIS EXCLUSION AND LIMITATION MAY NOT APPLY TO YOU.
HIGH RISK ACTIVITIES.
The Software is not fault-tolerant and is not designed, manufactured or intended for use or resale as on-line control equipment in hazardous environments requiring fail-safe performance, such as in the operation of nuclear facilities, aircraft navigation or communication systems, air traffic control, direct life support machines, or weapons systems, in which the failure of the Software could lead directly to death, personal injury, or severe physical or environmental damage ("High Risk Activities"). Accordingly, Licensor and its suppliers specifically disclaim any express or implied warranty of fitness for High Risk Activities.
MISCELLANEOUS.
This Agreement represents the complete agreement concerning the license granted hereunder and may be amended only by a writing executed by both parties. THE ACCEPTANCE OF ANY PURCHASE ORDER PLACED BY YOU IS EXPRESSLY MADE CONDITIONAL ON YOUR ASSENT TO THE TERMS SET FORTH HEREIN, AND NOT THOSE IN YOUR PURCHASE ORDER. If any provision of this Agreement is held to be unenforceable, such provision shall be reformed only to the extent necessary to make it enforceable. This Agreement shall be governed by Alberta law, excluding conflict of law provisions (except to the extent applicable law, if any, provides otherwise). The application of the United Nations Convention of Contracts for the International Sale of Goods is expressly excluded.
Other CyberMatrix software
Pro Schedule
Meeting Manager
Class Scheduler
Project Clock
Reminder
Timesheets
Employee Project Clock
Employee Scheduler
In Out Scheduler
Point Of Sale
Phone Lister
Clipboard Magic
The latest [trial] version of all programs can be obtained from http://www.cybermatrix.com
Pro Schedule
CyberMatrix Pro Schedule is an easy to use single or multi-user appointment scheduling calendar. Pro Schedule is ideal for doctors, dentists, nurses, health care workers, lawyers, veterinarians, driving instructors or any other professionals who are often scheduling appointments. Pro Schedule can be used in clinics, hospitals, beauty salons, office buildings, driving schools or anywhere else requiring personnel appointment scheduling.
There are four different editions of Pro Schedule: Pro Schedule Standard, Pro Schedule Client/Server, Pro Schedule Enterprise and Pro Schedule Web. Additional software allows Pro Schedule appointments to be synchronized with the PalmOS and Pocket PC calendar applications.
Pro Schedule runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium, 64 MB RAM, 20 MB HD.
For Pro Schedule Client/Server we recommend a dedicated NT4, W2K, XP or 2003 server with 500 MB RAM and power backup to host the Pro Schedule server application.
Pro Schedule Web requires a web server running Windows that can serve Windows executable CGI scripts. A dedicated Windows NT, 2000, XP or 2003 server is recommended. The clients require only a web browser.
Pro Schedule Enterprise requires a database server such as Microsoft SQL server, MySQL or PostgreSQL.
The Pro Schedule PocketPC synchronization utility requires a PocketPC device running Windows Mobile with .Net support or Windows CE.
Pro Schedule Standard costs $100 for a single license, Client/Server is $200, Enterprise is $200 and Web is $100. Affordable multiple-user license packs are also available.
Meeting Manager
CyberMatrix Meeting Manager is an easy to use group calendar application for scheduling meeting rooms, reserving meeting rooms and scheduling resources.
Use Meeting Manager to schedule conference rooms, schedule board meetings, reserve rooms, schedule resources, schedule A/V equipment, schedule classrooms, schedule church events, schedule rental cars, schedule driving instructors and even schedule tennis courts and squash courts. Meeting Manager can handle all your meeting scheduling needs.
CyberMatrix Meeting Manager runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium, 64 MB RAM, 20 MB HD.
For Meeting Manager Client/Server we recommend a dedicated NT4, W2K, XP or 2003 server with 500 MB RAM and power backup to host the Meeting Manager server application.
Meeting Manager Web requires a web server running Windows that can serve Windows executable CGI scripts. A dedicated Windows NT, 2000, XP or 2003 server is recommended. The clients require only a web browser.
Meeting Manager Enterprise requires a database server such as Microsoft SQL server, MySQL or PostgreSQL.
CyberMatrix Meeting Manager Standard costs $100 for a single license, Client/Server is $200, Enterprise is $200 and Web is $100. Affordable multiple-user license packs are also available.
Class Scheduler
CyberMatrix Class Scheduler is an easy to use single or multi-user application for scheduling students classes. The software is ideal for schools and other educational institutions that need to quickly schedule classes.
Class Scheduler runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium, 64 MB RAM, 20 MB hard disk space.
Class Scheduler costs $100 (US) for a single license. Other license packages are available.
Project Clock
Project Clock is a project time entry system. Project Clock is useful for consultants, lawyers, engineers, contractors, project managers or anyone else who must record time billed to different projects.
Project Clock Pro can be accessed over a network and has custom reporting and timesheet entry features. Project Clock Client/Server can access data over an Internet connection. Project Clock Web can be accessed from any web browser. Project Clock Palm runs on hand held computers using PalmOS and can sync data with Project Clock for Windows. Project Clock CE runs on Pocket PC hand held computers using Windows CE and can sync data with Project Clock for Windows.
Project Clock runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium, 64 MB RAM, 10 MB HD.
For Project Clock Client/Server we recommend a dedicated NT4, W2K, XP or 2003 server with 500 MB RAM and power backup to host the Project Clock server application.
Project Clock Web requires a web server that can serve Windows executable CGI scripts. A dedicated Windows NT, 2000, XP or 2003 server is recommended. The clients require only a web browser.
Project Clock Palm requires an Palm device running PalmOS v3.5 or higher.
Project Clock CE requires an PocketPC device running Windows CE with ADOCE.
Project Clock Standard and Web costs $35 for a single-user license, Project Clock Pro costs $55 for a single-user license, Project Clock Client/Server costs $75 for a single-user license. Project Clock Palm costs $20 for a single-user license or $10 for existing Project Clock customers. Network and site licenses are available.
Reminder
CyberMatrix Reminder is a free software program that allows you to enter upcoming events that you need to be reminded of. When the event approached a reminder notice will pop up to remind you of the event.
CyberMatrix Reminder is free and runs on Windows 95, 98, ME, NT 4.0, 2000 and XP. System requirements: 486, 8 MB RAM and 4 MB hard disk space.
Timesheets
CyberMatrix Timesheets is an easy to use Windows-based multi-user timesheet entry software application. Timesheets features simple, intuitive employee time entry by client, project and task. The custom reporting features allow existing reports to be changed and new reports to be added. CyberMatrix Timesheets is an ideal solution for those companies wishing to replace their old-fashioned paper-based timesheet entry.
CyberMatrix Timesheets was designed to provide an effortless transition for those accustomed to the traditional paper-based timesheet entry. The timesheet entry screen looks like a standard timesheet entry form. Unlike traditional timesheets though, managers can validate and edit their employees time immediately from their own computers without having to pore over scores of timesheet reports.
Timesheets has two different versions to accommodate the needs of various customer types. Timesheets comes in Standard, Client/Server, Enterprise and Web editions. The Standard, Client/Server and Enterprise editions have a simple intuitive graphical interface. While the Standard edition can be used with multiple users over a network, the Client/Server and Enterprise editions are better suited for large numbers of users. Only the Enterprise edition can be scaled up to handle massive user loads. The Client/Server, Enterprise and Web editions can be used with multiple users accessing employee time data over the company intranet or even the Internet.
CyberMatrix Timesheets runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium 32 MB RAM 20 MB HD
CyberMatrix Timesheets Standard and Web costs $35 for a single license. CyberMatrix Timesheets Client/Server and Enterprise costs $55 for a single license. Network and site licenses are available.
Employee Project Clock
Employee Project Clock is an employee time tracking system. This software package is useful for companies that must keep track of their employee's time.
Employee Project Clock can be used by multiple people over a network. Employee Project Clock Pro also contains a powerful custom reporting feature. With the custom reporting tool, those who need additional reports can easily build their own.
Employee Project Clock is easy to use. Employees simply choose their name and optionally choose a project or job code. To start billing time punch in by pressing the In button. To stop billing, enter an optional comment and press the Out button to punch out. The time data is safely stored in the database for later reporting purposes.
Employee Project Clock runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: 486, 8 MB RAM and 4 MB hard disk space.
Employee Project Clock costs $75 for a single-user license. Network and site licenses are available.
Employee Scheduler
Employee Scheduler is an easy to use single or multi-user software application for creating and managing employee schedules. Employee schedule administrators can save time by using Employee Scheduler to automatically generate optimal schedules for their employees. Employees can be assigned into categories, have their day/time availability and scheduling priority entered in order to affect the generated schedules. After automatic scheduling takes place, the manual scheduling features can be used to easily adjust the schedules graphically. The schedule exception features allow for managing holidays, leave and sick days. The time clock options allows the software to act as a time clock that records when employees arrive and leave for the day.
Employee Scheduler sports an attractive intuitive display of your employee schedules. Use the schedule view to view by single employee, by all employees, by week and by employees in week. Filter by day, or employee. Employee Scheduler is multi-user ready, you can share schedule data over your network for all your employees. Exchange schedule data with other programs via the CSV import/export feature. Access data from other database applications using the separate ODBC driver.
CyberMatrix Employee Scheduler will run on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium, 32 MB RAM, 20 MB HD.
Employee Scheduler costs $100 for a single-user license. Network and site licenses are available.
In Out Scheduler
CyberMatrix In Out Scheduler is a multi-user attendance tracking application that visually indicates which employees are out of the office and at what time and date they will return. It is an ideal solution for those companies wishing to replace their old-fashioned In/Out scheduling board.
In Out Scheduler was designed to provide an effortless transition for those accustomed to the traditional scheduling boards. To this effect, the software looks a lot like an actual scheduling board. Virtual pins are used to designate which employees are in, which are out and when they will return. Unlike the traditional scheduling boards, In Out Scheduler can be accessed by all employees from the comfort of their own computers.
CyberMatrix In Out Scheduler runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium 32 MB RAM 20 MB HD
In Out Scheduler costs $35 for a single-user license. Network and site licenses are available.
Point Of Sale
CyberMatrix Point of Sale is a software application for retail sales management. It is designed to run on an ordinary Windows PC with a receipt printer. A keyboard intercept bar code scanner and cash tray are optional.
CyberMatrix Point of Sale can be used by businesses that sell goods, services or a combination of the two. For retail store chains, a server application can be setup to allow data sharing and synchronization between the different stores.
CyberMatrix Point of Sale runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium, 32 MB RAM and 20 MB hard disk space. The server application requires at least 256 MB RAM.
The CyberMatrix Point of Sale client costs $300 for a single-user license. The optional CyberMatrix Point of Sale server costs $1000 for a single-user license. Affordable multi-license packages are also available.
Phone Lister
Phone Lister is an application used to manage corporate phone lists. Phone Lister can dramatically improve the speed of telephone extension retrieval for companies still using traditional time intensive paper-based solutions or limited in-house applications for phone list management. Phone Lister can be used by a single person or by an entire company sharing phone list data over their network. Phone Lister features an easy-to-use phone list display screen, searching and sorting functions and data import/export. There is even a custom reporting tool allowing the modification of existing reports and the creation of new ones.
An alphabetic toolbar allow for fast searching. The main screen can be split showing the detail of the current phone listing. There is also a capability for using multiple languages.
Phone Lister runs on Windows 95, 98, ME, NT 4.0, 2000, XP and 2003 server. System requirements: Pentium, 8 MB RAM and 10 MB hard disk space.
Phone Lister costs $50 (US) for a single license. Affordable multi-license packages are also available.
Clipboard Magic
Clipboard Magic is a free Windows Clipboard extender. If you spend a lot of time cutting and pasting repetitive text Clipboard Magic can greatly improve your productivity.
By default, any text copied to the Windows Clipboard is automatically stored in Clipboard Magic. The text can range from a single line to several pages. At the click of the mouse, any item is automatically copied back to the Windows Clipboard allowing you to paste the text in any Windows compatible document.
The automatic clipboard archiving can be turned off. This feature is useful when manually editing the clipboard list. Another very handy feature of Clipboard Magic is that clipboard lists can be saved to external files for reloading later.
Clipboard Magic is small, fast and unobtrusive. By default, the program runs from the Windows System tray allowing quick and easy access. Clipboard Magic can be configured to automatically start when Windows starts and to start minimized.
Clipboard Magic is free and runs on Windows 95, 98, ME, NT 4.0, 2000 and XP.
Questions for users new to computers and the Internet
Q. What is Try Before You Buy or Trialware software?
A. Trialware is software that you can try out or demo first. If you decide you like the software, you can then purchase it. When you purchase the program you will either be sent a separate fully functional program and/or you will be sent a registration key file or code with instructions on how to apply the key to your program.
Q. I already have program X installed but I downloaded a new version. Should I install to the same location as the older version?
A. The proper way to upgrade to a new version is to backup any important Program X data files first, uninstall Program X and then install the new version of Program X in the same folder. However, many people simply reinstall right over the old version to save time. Make sure Program X is not running when you do this though.
Q. How do I uninstall program X?
A. Click the Start button to bring up the Start Menu. Then choose Settings and then Control Panel. Double click on the Add/Remove Programs icon. Select the program you wish to remove and then click the Add/Remove button. Voilą. According to Windows development guidelines, no data files created by the user are to be automatically deleted during the uninstall. Therefore, there may be a few "crumbs" (files) left in the program directory. Therefore, if you uninstalled Program X, the folder C:\Program Files\Program X may contain a few data files. You will have to delete these manually.
Q. How do I decide between Mirrors Sites 1 and Mirrors Sites 2 to download one of your programs?
A. Try Mirror Sites1 first, otherwise use Mirror Sites2. These will search the net and list download locations from around the world.
Q. I downloaded one of your programs called program.zip how can I run it?
A. Files ending in .Zip are compressed files. To open these files you need an uncompressor program such as Winzip. You can find WinZip here: http://www.winzip.com. Once you have installed an uncompressor program like WinZip, when you double-click on a .zip file, you will see the contents of the zipped file. Then you can unzip the contents of the zipped file to a temporary file location such as C:\Temp.
Q. OK I figured out how to unzip the file, but how do I install the program?
A. To install the program double-click on the installer file usually called SETUP.EXE or INSTALL.EXE. This will start the installation process.
Q. What is the "system tray"?
A. The Windows system tray is the area to the right or the Windows task bar. Certain programs, including Project Clock and Clipboard Magic, will have small icons here.
Questions about CyberMatrix Software
Q. We really like your software but desperately need a feature added. Can you add it right now?
A. All customer feature requests are put on a ToDo list but we can't guarantee with certainty when or if the feature will ever be added. If you need a new feature immediately, you can pay to have it added. We charge out at $75 per hour. Contact us for a quote including as much detail as possible about how you want the software changed.
Q. I tried to customize one of your reports. Now the report no longer works. How can I restore the original report?
A. You can just delete the bad report and reinstall the software to restore the original.
Q. Why do I see the error "There is no default printer selected" when I try to print on Windows NT4?
A1. Your administrator may have set restrictions so that you can't access the 'Control panel - Printers' window.
A2. You may be using a login script to get the list of printers from the server upon workstation startup. If the printer in the device list is capitalized differently than the printer's device name you will see this error.
Q. I have downloaded and installed your trial demo. Now I want to purchase. Will the purchased version overwrite my data?
A. No. Our business software was designed to leave existing data intact when upgrading the software. However, as a precaution you should always backup your data prior to upgrading.
Q. I purchased Program X version 2.00. I notice now that version 2.10 is out. If I upgrade, will I lose the data I have been working with?
A. No, the setup software leaves your existing data alone. Just install the new version into the same folder as the old version and your old data will remain intact.
Q. I purchased Program X version 1.00 several years ago. I got a new machine and tried to reinstall using the download directions I got when I purchased the software. However the link no longer works. What am I doing wrong?
A. We don't maintain downloads for old versions on the web site. Existing customers can upgrade to the latest version at a 50% discount though.
Q. What is the time frame for a return email to help get an issue resolved if one arises?
A. It depends on the severity. Urgent issues get a response almost immediately during business hours. Non-urgent issues should get a response within two business days.
Q. I downloaded the trial version of program X using IE 6.0 under Windows XP but when I tried to run the software I received a message that the setup files were corrupt and to obtain another copy of the software. What am I doing wrong?
A. This is most likely a bug in Internet Explorer. Try downloading the file instead of trying to run it. Save the file to a folder like My Documents not your desktop. You might also consider using a superior web browser like Firefox which does not have this bug. We can always email you the file if need be.
Q. I tried to download program X but it said it was not a valid archive. What am I doing wrong?
A. Nothing. Large Zip archives sometimes become corrupted during the download process. In the meantime, try to download files from one of the mirror site links. If these links turn up empty, it is probably because a new version has been released. If you can't wait, send an e-mail and a demo copy can be e-mailed to you as an attachment.
Q. I tried to download the trial version of program X using IE 6.0 under Windows XP but the file had CRC errors and would not extract. Why is this?
A. This may be an issue with your firewall or DSL modem. Try going into the Internet Explorer menu item "Tools > Internet Options > Advanced" and switching OFF the option under Browsing which tells IE to "Use Passive FTP (for firewall and DSL modem compatibility"
Q. I tried your X program and like it. Do you have a version that does Z or runs on Y?
A. All CyberMatrix software is listed at the main web site. If you don't see it, we don't carry it. If you have a feature request for a particular program send us an e-mail.
Q. I downloaded Program X and now my anti-virus software says the file is infected with a virus. When are you going to address this?
A. No CyberMatrix software has ever been verified to contain a virus. Most likely, you are seeing a false detection. If this happens send us an e-mail detailing the anti-virus software you use, the program claimed to contain a virus, it's version and where you obtained (downloaded) it.
Questions about CyberMatrix Software Licensing
Q. I notice you offer a 10 seat license for your software. What do you mean by a seat?
A1. A seat means one machine that is used to access the software. If you have 10 machines that will access the software (even if everything is installed on the server) you will need a 10 seat license.
A2. For our Web software we basically use what is called concurrent licensing. That means you just have to determine the maximum number of people that will be using the schedule at one time. That is the number of licenses you need.
Q. We want to buy your software. We will have one person making changes to the data and people that will only be viewing the data. Do I need a single seat license or a 10 seat license?
A. Since 10 people will have access to the software you will need a ten seat license.
Q. What is the difference between your trial versions and the full version?
A. The only difference between our time-limited software and the full versions is that the time-limited software stops working after a certain number of days.
Q. What is a site license?
A. A site license allows the unlimited use of the software on any number of machines is up to 10 different sites (or buildings/locations) of a company.
Q. I have already purchased version 1.1 of your program Z. If I download version 1.2 do I have to purchase the program again?
A. No. CyberMatrix has a policy of providing all minor version changes free of charge to existing customers.
Q. I purchased version 1.0 of program X four months ago. I notice you now have version 2.0 available. Do I have to pay the full price again.
A. No. CyberMatrix has a policy of providing major version changes free of charge to existing customers if the program has been purchased within the last six months of the year that the new version was released. If you have purchased the program more than six months ago, the program will be available for upgrade, usually at a 50% discount.
Q. We had a hard drive crash. I re-installed the software. Now we are getting a message saying we have exceeded our licensing. How do I correct this?
A. You need to copy in the license key to the program's folder as explained in the registration instructions.
Q. We had a hard drive crash. I re-installed the software. Now we are getting a message saying we have exceeded our licensing. The registration key has been copied to the program's folder as explained in the registration instructions. How do I get rid of this message?
A. Check the Users table for ghost users. If there are any ghost users, delete those records.
Database/Multi-user questions
Q. What does Client/Server mean?
A. Client/server applications have a client and a server component. The client only talks to the server and only the server has direct access to the data. File server applications have no server component and they can directly access the data.
Q. How can we share data amongst several people with the Standard version?
A. To share data with multiple users over a network you should install the data on a network shared folder then install the software on each computer. To do this run the setup program and select the Data only installation option. The Select Destination Location screen will appear. This will be where the program data will be placed. Complete the setup for the data. Then run the setup file from each of the client machines, choosing the Client only installation for each one. When asked for the data folder enter the folder where you installed the data earlier.
Q. I want to share data amongst several people. Can I use the Standard version or do I need to purchase the Client/Server version?
A. The Standard versions of our software (and Project Clock Pro) can share data with multiple users over a network. However, the standard version will be more likely to require database re-indexing especially in networks with unstable machines or inexperienced users. A general rule of thumb is not to use the standard version with more than 10 simultaneous users. In this case, the Client/Server version will perform better.
Q. When I Start Program X why does the following error message comes up:
DBISAM Engine Error #9217 Error reading From Data File C:\Program Files\Cyber App\data\ATable.dat
A. This is a corruption error. Several CyberMatrix programs use a local database to store their data. Corruption can happen in any local database when a system is shut down abnormally. You should never shut down or restart a Windows machine without doing a proper Windows shutdown first (i.e., choosing Shut Down from the Start menu.) To repair the table, select the table in the Data Explorer (or Data Views) screen and then choose File | Repair table.
DBSys
If you are unable to open the application to do a repair, you can get the DBSys utility. DBSys is a utility from Elevate Software, the makers of the database engine used in our database software. Use this program to repair the affected table.
Windows 95:
There exists problems with several versions of the network redirector provided with the Windows 95 Microsoft Client for Microsoft Networks that can cause data corruption in DBISAM data files when they reside on a shared Windows 95 server. One of the problems occurs when the network redirector (vredir.vxd) improperly caches server data locally and can cause various problems such as key violation exceptions with auto-increment primary keys and others that should never occur. If you are experiencing random problems with data corruption when sharing data files in a Windows 95-only environment then please download the updated network redirector and apply the update to all Windows 95 machines on the network. Please note that these problems do not occur when accessing Novell NetWare servers.
You can find more information at:
support.microsoft.com/support/kb/articles/Q174/3/71.asp
Windows NT:
If you don't have NT Service Pack 3 or higher you may want to check and see if the NT server has opportunistic locking turned off:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters"EnableOplocks" (DWORD) = 0 (default=1)
NT Service Pack 3 supposedly fixes the problems with opportunistic locking on the NT server platform. Remember to re-apply the service pack after any updates to the system.
Last Resort
If after trying all these solutions you still have problems, you can zip up the data files and e-mail them to CyberMatrix.
Q. When I try to re-index a tabled I get the error "DBISAM Engine Error #10242 Cannot unlock table or record in the table 'TableX'". How do I fix this?
A. Get everyone off the system (shutdown their machines if necessary) and try re-indexing again.
Q. What is the purpose of the Users table?
A. The Users table merely keeps a running log of which users are believed to be logged into the system.
Q. What is the maximum size of a single table?
A. The maximum size of a table (.DAT), index file (.IDX), or BLOB file (.BLB) is 4 gigabytes.
Q. I have setup Program X on an NT 4.0 station. When only one person access the software, everything is fine. When other machines use Program X everything slows to a crawl. What's going on?
A. This is an NT4 issue, and most likely related to opportunistic locking settings and the SP level. Due to bugs in early versions of NT4 a lot of servers had opportunistic locks turned off, but since this has been fixed they haven't turned them back on. Ensure the OpportunisticLocking functionality is enabled (=1) in the registry.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters"EnableOplocks" (DWORD) = 1
Both the server and the workstation must agree. Make sure you have SP4 or higher. The other thing that can cause slowdown problems is using NetBeui in conjunction with TCP/IP (especially making NetBEUI the default protocol). You might also try turning off StrictChangeDetection. It is recommended that you get an NT server administrator to look at the server and make sure that it's configured properly.
If you are running 10 Base T on your network, try upgrading to 100 Base T.
You might also consider getting a Quantum "Snap Server".
Q. We are running your software on a Windows 2000 peer-to-peer network setup. We're experiencing performance problems. How can we speed things up?
A1. On Windows 2000 there is a bug relating to UNC paths. http://support.microsoft.com/support/kb/articles/Q249/7/99.ASP You will see significant performance problems with database applications if different people access the same shared files using different paths. To work around the problem, you can map the shared path to a common drive letter.
A2. A rather annoying "feature" included with Windows 2000 can impact the responsiveness in network browsing from Win2K systems to Windows 98 PCs. When you browse the network and double-click on an available workstation, you may experience a delay of up to 30 seconds. This is due to a resource scanning routine that has to do with Scheduled Tasks. In most cases, it's not necessary, so simply deleting the associated registry key will work around the issue. When you upgrade Windows components or versions of Internet Explorer, this may be replaced, so you'll have to delete the key again in order to rid yourself of the reinstated delay. Navigate to the following registry location:
HKEY_LOCAL_MACHINE \ Software \ Microsoft \ Windows \ CurrentVersion \ Explorer \ RemoteComputer \ NameSpace
Then delete the following key:
{D6277990-4C6A-11CF-8D87-00AA0060F5BF}
Q. We're running Program X on a Windows 95/98 peer to peer network. Performance seems very slow. How can we make it faster?
A. Make sure your network cards are set to half duplex. If you are running Norton Antivirus, disable "Auto Protect".
Q. Will Program X run on Novel?
A. CyberMatrix database applications will run fine on a properly configured Novell Network. Novell does have one issue of which you need to be aware. Unlike Windows NT, Novell has a default maximum number of record locks per client of 500. Therefore, you may need to change the Novell default record locks. You can do this by adding 2 lines into your system autoexec files as follows:
SET MAXIMUM RECORD LOCKS PER CONNECTION = 5000
SET MAXIMUM RECORD LOCKS = 40000
You should use TCP/IP and eliminate the IPX/SPX protocol (may need Novell 5) completely from the NT box. On the workstation, make sure the Microsoft Client is bound to TCP/IP only and the Microsoft Novell client is bound to IPX only. Remove any protocols you do not use such as Netbios from your workstations (you need it for NT server). Also, look at the protocol resolution order.
With Novell, it is also important to make sure you are not running full duplex if your network design is 10BaseT or 100BaseT since without an intelligent (expensive) switch this can corrupt Novell packets.
Q. How can I export table data into Excel?
A. Export the table into CSV format in the Data Manager screen: select View | Data Manager from the main menu. Select the table then choose File | Export to CSV. Load the saved file into Excel.
Q. Which database engine is used in your software?
A. We use the DBISAM database engine for all our Windows business applications.
Q. Can DBISAM tables be accessed from Crystal Reports or other common database software?
A. For newer non-enterprise versions of our software (Class Scheduler v3+, CyberMatrix Office, Employee Project Clock v2.20+, Employee Scheduler, In Out Scheduler, Meeting Manager v4+, Phone Lister, Point Of Sale, Project Clock v5.10+, Pro Schedule v3+, Timesheets) we have an ODBC driver available. See:
http://www.cybermatrix.com/odbc.html
A. For older version of our software there is an ODBC driver available that others have used to access database tables from Crystal Reports. You can get it here:
http://www.cybermatrix.com/download/odbc.zip
We do not offer any support for this older driver.
Q. Where can I learn how to use SQL?
A. Try these links: SQLCourse2.com, SQL Tutorial 1
Q. We are using the Client/Server version of program X. Why are we getting a windows socket error (10065) on API connect on one of the client stations?
A. This is probably a firewall issue. You need to open a port. All our server software runs on port 9000.
Q. I have a single license for Program X. I logged in as someone else, and then I had a crash. Now when I try to start Program X again it says "The number of users have exceeded your license. Contact CyberMatrix to purchase additional licenses." What do I do to use the software again?
A. Login as the other person, shut down Program X and then login as yourself.
Q. We are very interested in the Client/Server version of your software. However, we want the server application to run as a service. Is this possible?
A. Yes, you can use the "srvany" tool from the Microsoft Resource kit to run the server application as a service.
Here is a tutorial on setting up our servers as a service.
1) Use the "instsrv" tool to install the service to the registry
Example:
instsrv yourservicename "C:\Program Files\Resource Pro Kit\bin\srvany.exe"
Note that the executable name has to be "srvany.exe"
2) After you are done with step (1), you need to edit the registry either by using the registry editor or by using a batch file.
Create a subkey name "Parameters" under
"HKLM\SYSTEM\CurrentControlSet\Services\yourservicename\"
so that the tree structure looks like
"HKLM\SYSTEM\CurrentControlSet\Services\yourservicename\Parameters"
Then, in the Parameter Subkey, add the values "Application" and make it point to your application executable.
Example, "C:\ProjectClock\PCServer.exe"
3) DONE. You will be able to start/stop the service from both the
"service" manager and the command prompt using "sc stop service name"
Q. We use the Client/Server version of your software. We want to install the latest version on a new server. What is the best way to upgrade and still use our old data?
A. You have two choices. You can either copy over your entire old server folder over to the new server machine and then install the new server software into this folder. Or you can install the new server software on the new machine and then copy over the database files. The database files are those with the .Dat and .Idx extensions.
Q. I want to move Program X to a new machine but keep all my data. What is the best way to do this?
A. You could over your program and data folder over to the new machine but then there would be no shortcuts in your start menu. The best way is to install the software on the new machine. Then on the old machine do a backup from Program X's Data Manager, copy that backup file to the new machine, and then restore the backup file on the new machine using Program X's Data Manager.
Q. We are using version 1 of your software. Is it possible to install the V2 trial of the software on the same machine so that both versions can be run side by side.
A. Yes. For the Client/Server version the V2 server would have to run on a different server machine but V1 and V2 of the client can be installed into different folders. However you would have to log in as another user for V2. For the Web version you would just install V2 in another folder. For the Standard version you would have to do a Data Only and Client only install of V2. The data would have to be installed in a folder called Data just off the program folder i.e.: C:\Program Files\ProgramX\Data. The software would have to be installed in the C:\Program Files\ProgramX folder. Then you should run V1 and make sure it is still using the old data folder. Alternatively you could just run V2 under a different user account i.e. log in as another user for V2.