Event Manager

Event Manager offers a simple way to schedule events. Whether you need to book meeting rooms or schedule appointments Event Manager can save you a lot of time.

Installing Event Manager

Getting started with Event Manager

Advanced Topics

Working in a different language

Pricing Information

Browse Event Manager support


see all


Categories

Calendar
Contacts
Customizing
Demos
Getting help
Getting started with Event Manager
Installing
Search
Working in a different language


Installing Event Manager

After installing Event Manager and running it for the first time you will see the following screen:



This means the database has not been found and the software is asking how you want to store the data. You have three options:

Single use on one computer.

Multiple people sharing data on the network.

Multiple people sharing data some from outside the network.

Single use on one computer

If you want to use the software on only one computer you should choose this option. Note that this option will use Mocrosoft Access database to store your data. If you want to use a different database you should choose the thrid option. When this option is chosen a Microsoft Access database file called EventMgr.mdb will be created in the C:\Users\Public\Documents\CyberMatrix\EventManager folder.

Multiple people sharing data on the network

If you want to use the software on more than one computer and sharing the data between them, you should choose this option. Note that this option will use Mocrosoft Access database to store your data. If you want to use a different database you should choose the thrid option. When this option is chosen a Microsoft Access database file called EventMgr.mdb will be created in the shared network folder you designate.

Multiple people sharing data some from outside the network

If you want to use the software on more than one computer with one or more computers outside your network or if you want to use a database other that Microsoft Access, you should choose this option.

Multi-User Installs

For multi-user installs you can rus the initial setup from a network folder or a portable drive like a USB key drive. When doing an istall this way the database settings are rememberd so you don't have to enter them each time. 


Getting started with Event Manager

Topics

Getting to know the Planner
What is the Navigation Pane?
Create and edit events on your calendar
Set an event reminder
Create or edit a contact
Searching
View your tasks
Create to-do items
Managing data
Configuring Event Manager
Running reports
Event Manager FAQ / Readme



Getting to know the Planner

The Planner is where you view bookings for the selected resource on the selected day. This is the first screen you see when Event Manager is started.



The Planner view consists of the Menu Ribbon, the Navigation Pane and the Planner.

The Menu Ribbon

The Menu Ribbon is a graphical menu. I consists of several tab of buttons, menus and other controls. The Menu Ribbon has four tabs: File, Home, Event, View and Tools.

File


Save As HTML - saves the current schedule to an HTML file that can be printed, emailed or placed on a website.
E-mail - e-mails the current schedule to the provided address.
Print - prints out a hard copy of the current calendar.

Home


Today - jumps to the current date on the Planner.
Day - shows a single day on the Planner.
Work Week - shows the work week on the Planner (Monday to Friday).
Week - shows the whole week on the Planner.
Month - shows an entire month on the Planner.
Resources - shows all resources on the Planner.
More - shows all other Planner views.
Find Event - searches for the first event that contains the entered text.
Find Slot - finds the first open time slot of entered hours.
Find Period - finds the first open range of entered days.
Help - menu of help resources for Event Manager.

Event

New Event - creates a new event.
New Items - 
Edit Event - edits the currently selected event.
Delete Event - deletes the currently selected event.
Cut Event - cuts the currently selected event and places it on the clipboard.
Copy Event - copies the currently selected event to the clipboard.
Paste Event - pastes the event in the cliboard onto the Planner.
Link Selected Events - links the currently selected events.
Approve Event - approves the currently selected event.
Reject Event - rejects the currently selected event.

View

Contacts - shows Manage Contacts screen.
Style - changes the current Windows style for Event Manager.
Change Menu Color - 

Tools

Login - allows you to log in or out as Administrator or another user. If security is not enabled the Login buttons are grayed out.
Change Password - brings up the change password dialog that allows you to change your log in password.
Options - brings up the Options screen, which allows global configuration settings to be changed.
Data Manager - brings up the Data Manager screen, which is used to administer the raw data used in Event Manager. 
Database - selects a different database.
Reports - brings up the Reports screen, which allows the printing of reports.
Auto Schedule - brings up the Event creator screen, which helps you automatically create events for resources and contacts.
CalDAV - syncs events with remote CalDAV server.
CardDAV - syncs contacts with remote CardDAV server.


Navigation Pane

The Navigation Pane appears on the left side of the Event Manager window and is how you switch between the different areas of Event Manager, such as Calendar, Waitlist and Tasks. 

To quickly see more or fewer buttons or folders, point to the horizontal splitter bar between the folders and the buttons, and drag the bar up or down when the pointer turns into a double-headed arrow. If you drag the horizontal splitter bar to the bottom of the Navigation Pane, all the large buttons become small buttons and appear as a single row of icons at the bottom of the Navigation Pane.

Calendar

The Calendar shows date selector and a resource list which are used to change what is seen on the Planner.

Waitlist

The Waitlist is a list of events that could not be entered in the Planner due to scheduling conflists. Items on the Waitlist can be dragged onto the Planner.

Tasks

The Tasks is a list of tasks or to do items that need to be completed.  Items on the task list can be dragged onto the Planner.


The Planner

The Planner is where all events are shown. 

Right clicking an event shows the event pop-upo menu:



Edit
Event - edits a single day of the event.
Series - edits the entire event series.

Delete
Event - deletes a single day of the event.
Series - deletes the entire event series.

Billing - shows the Billing Screen for the current event.


What is the Navigation Pane?

The Navigation Pane appears on the left side of the Event Manager window and is how you switch between the different areas of Event Manager, such as Calendar, Waitlist and Tasks. 

To quickly see more or fewer buttons or folders, point to the horizontal splitter bar between the folders and the buttons, and drag the bar up or down when the pointer turns into a double-headed arrow. If you drag the horizontal splitter bar to the bottom of the Navigation Pane, all the large buttons become small buttons and appear as a single row of icons at the bottom of the Navigation Pane.



Create and edit events on your calendar

Events are appointments with other people or bookings of rooms or other resources.

What do you want to do?

Create a new event

Change an event

Make an event repeat


Create a new event

1. In the Navigation Pane on the Event tab, click New Event in the New group. Alternately, you can click and drag a time block in your calendar grid and release.


2. In the Subject box, type a description of the event.

3. Enter the start and end times if they're not already set.

4. Enter an optional note about the event.

5. To make the event repeat, click the Recurrence Button image to the right of the end time. Click the frequency (Daily, Weekly, Monthly, Yearly) with which the appointment recurs, and then select options for the frequency. Click OK.

6. To add a list of contacts for the event click the Contacts button to the right of the URL box. Click OK.

7. To cause a reminder to appear before the appointment start time, click the Reminder checkbox and then enter the time the reminder should. To turn the reminder off, uncheck the Reminder checkbox.

8. To save the event click the OK button.


Change an event

1.Right click the event that you want to change.

2.Do one of the following:

Change options for an event that is not part of a series    

Choose Edit | Event from the popup menu and change the options, such as subject, location, and time, that you want to change.

Change options for all events in a series    

1.Choose Edit | Series from the popup menu to open the series, and then change any options that you want to change.

2.To change recurrence options, click the Recurrence icon to the right of the To time field, change the options and then click OK.

Change options for one event that is part of a series    

Choose Edit | Event from the popup menu and change the options, such as subject, location, and time, that you want to change.

Click OK to save.

Tip    In the calendar, you can drag the event to a different time. In Week view you can drag to a different date. In Resource view you can drag to a different resource. 

Make an event repeat

1.Right click the event that you want to change.

2.Choose Edit | Event from the popup menu to open the event.

3.To change recurrence options, click the Recurrence icon to the right of the To time field, change the options and then click OK.




Set an event reminder

1.Right click the event that you want to change.

2.Choose Edit | Event from the popup menu. Check the Reminder box, set the reminder time and enter the reminder message.



Search

There are three different ways to search in Event Manager:

Find an event

Find an open time interval

Find an open series of days

Find an event

1.Click the Home tab.
2.Click Find Event.
3.In the Find Dialog enter the text of the event to search for and press Find Next.

Find an open time interval

1.Click the Home tab.
2.Click Find Slot.
3.In the Find Dialog enter the length in hours of the open time slot to search for and press Find Next.

Find an open series of days

1.Click the Home tab.
2.Click Find Period.
3.In the Find Dialog enter the length in days of the open period to search for and press Find Next.



View your tasks

To-do items are displayed in the Task list pane of the Navigation Pane.



To view your tasks, click Tasks on the Navigation Pane.


Create to-do items

Many people keep a list of things to do. In Event Manager you can manage a list of to-do items and track task progress.
Create a to-do item

1. In Tasks section of the side bar right click on a blank section of the task list. Choose Add to-do item from the pop-up menu.

2. In the Subject box, type a name for the task. You can add more detail in the task body.
3. Click the row below to save the new task.


Managing data

The Event Manager program uses several data files.  The Data Manager screen allows viewing and editing of all Event Manager data.

To use the Data Manager:
1.Click the Tools tab.
2.Click Data Manager.

Note that if security has been enabled, you must first login as Admin or as Superuser if the Superuser data access option has been set.



The Data Manager consists of four sections: the Menu Ribbon, the Data Navigator, the Table List and the Data View.

The Menu Ribbon

The Menu Ribbon is a graphical menu. I consists of several tabs of buttons. The Menu Ribbon has three tabs: File, Edit and Tools.

File


Import CSV - imports a text file in comma separated variable (CSV) format into the current table. See also: Importing and Exporting Data in CSV Format
Export CSV - exports the current table to text (CSV) format. See also: Importing and Exporting Data in CSV 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 execute that query. Only Administrators can execute queries.
Export SQL - exports the current table data to SQL format. 

Edit


Save and Close - saves the currently edited record and closes the Data Manager.
Save and New - saves the currently edited record and adds a new record.
Cut Record  - copies the selected record into the Windows clipboard for pasting later and then deletes the 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.
Delete Selected Records - delete all the selected records. See also: Deleting records
Delete All Records - deletes all the records in the current table.
Find - finds the first occurance of entered text in the current column of the current table.
Replace - replaces the first occurance of entered text in the current column of the current table.

Tools


Repair Database - re-indexes the currently selected table. See also: Re-indexing Tables
Backup - makes a time-stamped backup file of all tables. See also: Backing up Data
Restore - replaces your existing data with the tables from a previous data backup. See also: Restoring data


The Data Navigator


The bar beneath the Menu Ribbon 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 checkmark 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.


Table List

The Table List is a list of all the tables used in Event Manager. When a table is clicked it becomes the current table and it's records are shown in the Data View.


The Data View

The Data View shows all the data for the current record of the current table and allows you to view and edit the data in this table. The Data View consists of two tabs: List and Record. See the Viewing and Editing Table Data section for more details.

List

The List tab shows all the records for the current table in a list or grid.

Record

The Record tab shows all the fields of the current record of the current table in a list or grid.



Record



Configuring Event Manager

There are many configuration options that allow you to customize the behavior of Event Manager to suit your needs. 

To access these configuration options:
1.Click the Tools tab.
2.Click Options.

The Options Screen consists of nine tabs: General, Schedule, Schedule Scripts, Alarms, Data, Billing, Email, Terms, Security and WebDAV.

General



Program options

Force contact - if checked, the user must enter the contact name when adding a booking.

In place editing - if checked, item editing takes place within the item itself rather than an edit dialog.

Allow double booking - if checked, resources can be booked more than once for the same time period.

Allow past booking - if checked, resources can be booked in the past.

Show tips on start up - if checked, helpful tips will be seen when the software first runs.

Font - indicates the font used through out the software. Languages using special characters (Unicode) should change the font to one that supports these characters.

Language - indicates the language used for the program captions. See also: Multi-Language Support

To do list options

Visible fields - indicates which to do fields are shown in the Task List.

Preview notes - if checked, the Notes field will be shown expanded below each task in the to do list.

Preview height - indicates the height in pixels of the Notes preview area.


Schedule



Schedule Options

Show topic highlight - if checked, the bookings will have a reverse color title bar when displayed in the schedule grid.

Show current time - if checked, a colored bar will be shown across the schedule grid indicating the current time.

Show current items - if checked appointments taking place right now will be colored green.

Move to current time - if checked, the schedule will automatically scroll down to the current time.

Repeat sidebar - if checked, the times sidebar will be shown beside every column in the planner.

Wide trackbar - if checked, each Planner item will have a wider bar on the left side.

Min column width - specifies the minimum column width to use in the multi-column views. When there are a large number of columns, this setting enables the planner to scroll instead of compacting columns.

Row height - specifies the height of the grid line rows in the planner grid.  Use a higher number to get larger rows.

Sidebar position - determines where the sidebar containing the schedule times will be positioned on the schedule grid. 

Booking shape - determines the shape of the booking items on the schedule grid. 
 
Background color - determines the background color of the schedule grid. 

Default booking color - determines the default color of bookings on the schedule grid. 

Unavailable color - determines the color of unavailable periods on the schedule grid. 

Date/time settings

Start - the Start time specifies the earliest time an event may be booked on any given day. 

End - the End time specifies the latest time an event may be booked on any given day. 

Note: If necessary you can have the start time later that the end time. I.e. if you need to book a resource from 11:00 PM to 01:00 AM the next day for example.

Interval - This number indicates the number of booking intervals in an hour.  For example:
30 - split the hour into two intervals i.e. 8:00 - 8:30
15 - split the hour into four intervals i.e. 8:00 - 8:15
10 - split the hour into six intervals i.e. 8:00 - 8:10

Hint duration - specifies how long (in seconds) schedule hints will remain showing.

Auto refresh every X minutes - if checked, the schedule will automatically refresh every time the number of minutes entered have passed.


Schedule Scripts



Schedule scripts allow you to configure what is seen for each event displayed in the schedule grid. There are two scripts: one for the monthly views and one for all other views.

Scripts consist of text and special macros. The macros are enclosed in percent marks and represent special fields in the database. For example, the %Topic% macro represents the booking topic. When text and a macro is enclosed within squiggly brackets, the text will not be shown if that macro value is blank. For example, if we wanted to show the contact field with a descriptor in front of it we could place {Contact: %Contact%} in the script. If the contact field is empty for any booking the Contact: text will not be seen.

Here is a list of available macros:
%Subject% - booking topic
%Resource% - resource name (only for Resources This Month View)
%Contact% - contact name
%Attendance% - number of people attending a meeting
%Capacity% - maximum number of people the resource can accommodate
%Notes% - booking notes
%StartTime% - booking start time
%EndTime% - booking end time


Alarms



Reminder settings

Set reminders for upcoming events - if checked, upcoming bookings reminders are sent to the booking contacts.

Reminder type - determines which type of reminder to use: pop-up dialog, wav sound file, electronic voice or email. For wav sound files you select the wav file in the field below.

Notification type - determines which type of notification - Notes, Caption or Message.

Occurrence - determines when the reiminder is seen: before the event, after the event or both.

Minutes before - the number of minutes before the event the reminder should activate.

Minutes after - the number of minutes after the event has started that the reminder should activate.


Data



Database options

The Data options tab is used to setup the databases used by the Event Manager server application. 

It is very important to set the correct IP address. If the wrong IP address is used, the client applications will not be able to connect to the server.

Database - this is a descriptive name for the current database settings.

Protocol - this is the back end SQL server database engine you wish to connect Event Manager to. The two options available are msaccess and ado. If you select ado to connect to a database such as MS SQL Server or MySQL, you must click the ADO Setup button to the right to setup your ADO connection parameters.

Database folder - this is the path where the Event Manager data files reside. When using MS Access this fields will contain the path to the Access database file. When using ADO this field will contain your ADO connection parameters.

Database Name - this is the name of the database to use on the remote database server.

IP Address - this is the IP address the back end SQL server database engine connects at.

Port - this is the port number the back end SQL server database engine connects at. Leave it at 0 to connect at the database server's default connection port.

User name - this is the user name required to connect to the remote database server.

Password - this is the password required to connect to the remote database server.


Billing



Tax rates

Tax rate - the Tax rate field is for those locales that must charge tax on goods and services sold. This field is in decimal format. That is, 7% would be entered as 0.07.

State tax rate - the State Tax rate field is an additional rate for state or provincial tax on goods and services sold. This field is in decimal format. That is, 7% would be entered as 0.07.

Invoice

Company address - the company address that will appear on invoices.

MerchantWARE credentials

The Merchant options section is used for those merchants wishing to use the MerchantWARE© payment system. If you would like to use credit card processing with CyberMatrix Event Manager please contact us so we can set you up with MerchantWARE©.

Name/DBA - your company name.

Site ID - your MerchantWARE site ID.

Key - your MerchantWARE key.

If you are not using the MerchantWARE© payment system be sure keep all these fields blank.


Email



SMTP server options

Use MAPI to send emails - if checked all e-mail will be sent using your default MAPI compliant mail program such as Outlook or Thunderbird.

Use password authentication - check this box if your mail server requires password notification before sending mail.

Use SSL/TLS - if checked e-mails can be sent using SMTP servers like GMail which use secure SSL/TLS technology.

Send e-mail notifications - if checked, whenever an event is changed or deleted, a notice will be e-mailed to event attendees and the resource contact.

Login ID - enter your SMTP authentication loginid here.

Password - enter your SMTP authentication password here.

SMTP mail host - this is the SMTP mail host used on your network.  Usually it is mail but enter whatever you use for configuring other mail programs.  If this option is not entered correctly, the e-mail features will not work.

SMTP port - this is the SMTP port used to send email on your network.  Usually it is 25 but you can enter another port number to get around port 25 blocking.

Default from address - the e-mail address here will show by default in the from field of any e-mails sent to event attendees. Some mail servers may require a valid email address for this setting in order to send emails. 

Catering email - for any bookings contain catering information that are added or edited, a note will be sent to the e-mail address listed here.


Terms



The Terms tab is used to configure the terms used in the application. For example, if you use Event Manager for scheduling patients in a doctor's office you might want to change the Contact term to Patient. In this way, wherever the term "Contact" appears, it will be replaced with the term "Patient" everywhere in the software.

Type - this specifies what type of people are using the application, doctors/dentists or others. If the Medical Clinic type is selected, the resource is referred to as practitioner, the event topic is referred to as case and the person the event is with is referred to as a patient. If the Legal Office type is selected the person is referred to as a client.

To use a custom set of terms set the Type to Default and type in your desired terms in the second column of the Terms Grid.


Security



Security options

The security section allows the enabling of security and setting other security options. 

Enable security - if checked the security system is enabled for the application. Note that when security is enabled for the first time the Administrator uses the default password of "magic". You should change this password immediately after enabling security to ensure a secure system. Write down your new password and store it in a secure location such as a safe. To set up the users in the Security table and to change the current passwords use the Detail tab of the Data Manager. See also: Security

Login to book - if checked, the user must login before they can add, delete or edit bookings.  This effectively gives view only rights to ordinary users that have not been issued a login and password.

Force Login - check this option if you wish to require all users to login before having access to Meeting Manager.

User security

The User Security grid is used to set group specific security options. Currently options can be set individually for Users and Manager. Administrators have full access.

Manage edits - if checked the user can edit data in the Data Manager and other data entry forms.

Require booking approval - if checked, bookings made by ordinary users must be approved by an administrator or superuser before they go live.

Edit own bookings - check this option if you want to allow users to edit their own bookings.

Delete own bookings - check this option if you want to allow users to delete their own bookings.

View own bookings - check this option if you want to allow users to view their own bookings.

WebDAV Options

The WebDAV section allows setting the options involved with synchronizing with remote CalDAV and CardDAV servers. 

CalDAV settings

The CalDAV section allows setting the options involved with synchronizing event calendar data with remote CalDAV servers. 

CalDAV url - URL of the CalDAV server to sync with.

CalDAV username - username of the CalDAV server.

CalDAV password - password of the CalDAV server.

Calendar name - the name of the calendar on the CalDAV server.

CardDAV settings

The CardDAV section allows setting the options involved with synchronizing contact data with remote CardDAV servers. 

CardDAV url - URL of the CardDAV server to sync with.

CardDAV username - username of the CardDAV server.

CardDAV password - password of the CardDAV server.



Where does Event Manager save my information and configurations?

The following is a list of locations where Event Manager information is saved.

Database Files

The Event Manager database files store all your calendars, contacts, tasks, and global configuration.

Where the database files are located depends on which database you use. For enterprise databases like MS SQL Server, MySQL or PostreSQL; all database files are stored on the database server. For local databases like MS Access, database files are stored in the Database Folder. The MS Access database file is called EventMgr.mdb. The SQLite database files is named eventmgr.sdb.

The fastest way to open the folder where your local database file (.mdb or .sdb) is saved is to do the following:
1.In Event Manager, click the Tools tab.
2.Click Database.
3.Click the folder icon to the very left of the Database Folder field.


Databases List (.Xml)

The Database List contains a list of the configured databases that have been setup on a particular PC. The Database List is located in C:\Users\Public\Documents\CyberMatrix\EventManager\Databases.xml


Machine Configuration File (.Ini)

The Machine Configuration File contains configuration settings for all users on a particular PC. The Machine Configuration File is located in C:\Users\Public\Documents\CyberMatrix\EventManager.ini


User Configuration File (.Ini)

The User Configuration File contains configuration settings for the current user on a particular PC. The User Configuration File is located in C:\Users\[username]\AppData\Roaming\CyberMatrix\EventManager.ini where [username] is the username for the current user on a particular PC.




Reports

Running reports
Creating and editing reports


Running reports

Reports summarize and consolidate event data, client data and other information.

On the Tools tab, in the Reports group, click Reports.


Print a Report

Click on the report in the Report List.

Optionally adjust Filters.

Optionally set fields to Sort by.

Click Print. 

Preview a Report

Click on the report in the Report List.

Optionally adjust Filters.

Optionally set fields to Sort by.

Click Preview. 

Change Printer Settings

Click Print Setup.

Change the printer, orientation or the paper size or source. 

Click Properties for advanced printer settings.

Email a Report

Click on the report in the Report List.

Optionally adjust Filters.

Optionally set fields to Sort by.

Click Email. 

Enter the email address and press OK.

Edit a Report

Click on the report in the Report List.

Click Edit Report. 

Make changes to the report in the Report Editor, save and close.

Create a New Report

Click New Report. 

Make changes to the report in the Report Editor, save and close.


Creating and editing reports



Auto scheduling events

Some people need to quickly create events, assign people to a resource. In Event Manager you can automatically assign contacts to resources.
What do you want to do?

Autoschedule events

Add a break

Import resource contact list

Autoschedule events

1. In Tools section of the toolbar right click the Auto Schedule button. 

2. Set the date range by entering dates in the Date From and Date To fields.
3. Set the event length in minutes in the field below.
4. Add any breaks you need in the Breaks box. See: Add a break
5. Assign the contacts you want to schedule with resources by selecting the contacts in the Contacts box on the right and drag them to the desired resource in the Resources box on the left. If you need a simple one to one pairing, check the One To One box. To import a CSV data files containing the contacts you wish to assign to resources click the Import Data button. See: Import resource contact list
6. Click the Create Events button on the toolbar to auto create the schedule.
7. Confirm the schedule in the Resource Schedule tab or the Contact Schedule tab.
8. Press the Save Schedule button to save the auto created events to the database.

Add breaks

1. Right click in the section Breaks box right click the Auto Schedule button. Choose Add from the pop-up menu.

2. Set the date range by entering dates in the Date From and Date To fields.
3. Press OK to save the break.

Import Resource contact list

1. To import a CSV data file containing the contacts you wish to assign to resources click the Import Data button. A open file dialog will appear to allow you navigate to the folder containing the CSF file and select it. 

2. Navigate to the folder using the directory treeview on the left. 
3. In the list box on the right select the CSV file containing the resource/contact data.
4. The CSV file must be in the following format: each line will start with a resource name followed by a list of contact names you wish to schedule with that resource. Each ID must be separated with a comma (,). The names must be identical to resources and contacts found in the software. If a name contains a comma character that name should be enclosed in double quotes. eg. "Ann Warren","Bob Hoogstraat","Alice Quinn"
5. Press Open to open the CSV file and load the data into the Event Creator form.


Event Manager FAQ / Readme



Advanced Topics

Creating and managing invoices
Where does Event Manager save my information and configurations?
Creating and editing reports
Auto scheduling events
Database Details
Moving Event Manager to another computer


Creating and managing invoices

Invoices are used to bill clients for an event booking. In order to use this feature an event must be assigned at least one attendee.

What do you want to do?

Create a new invoice

Process an invoice payment

Print an invoice

Delete an invoice


Create a new invoice

1.Right click the event that you want to change.

2. Choose Billing.

3. Click on the appropriate Invoice Status.

4. To save the invoice click the Save Invoice button.

5. To create another invoice for another attendee press the New Invoice button.


Process an invoice payment

1.Right click the event that you want to change.

2. Choose Billing.

3. Click on the appropriate Payment Method.

4. Click Process Payment.

5. Click on the appropriate Invoice Status.

6. To save the invoice click the Save Invoice button.


Print an invoice

1.Right click the event that you want to print an invoice for.

2. Choose Billing.

3. If there there is more than one invoice click on the one you want in the grid below.

4. Press Print Invoice.


Delete an invoice

1.Right click the event that you want to print an invoice for.

2. Choose Billing.

3. If there there is more than one invoice click on the one you want in the grid below.

4. Press Delete Invoice.



Moving Event Manager to another computer

There are five steps to moving Event Manager to another computer. For multi-user installation or if using an enterprise database such as MS SQL Server, MySQL or PostreSQL; you can omit steps 2, 3 and 5.

1. Install Event Manager on the new computer.
2. Backup your data on the old computer.
3. Copy the backup file to the new computer.
4. Copy the Database List, Machine Configuration File and User Configuration File to the new computer.
5. Restore the backup file on the new computer.


Working in a different language

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. Do not translate the text to the left of the equal sign. You do not have to convert lines starting with ; as these are comment lines and are ignored by the translator. You should not convert any text between square brackets [] as these are very important to the translator. 

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, E.g. Francais.lng.

To try out your language file open the options screen by choosing Tools | Options from the main menu and select your language from the language pull-down list.

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.




Calendar

Topics

Create and edit events on your calendar
Change the appearance of your calendar
Navigate in the Calendar
Print a calendar showing events
Set or remove event reminders
Go to a specified day in the calendar
Change the calendar time scale
Change the default reminder time


Change the appearance of your calendar

What do you want to do?

Change the time scale

Change the background color

Change the font


Change the time scale

By default, the calendar grid shows a time interval of 30 minutes. You can increase or decrease this interval.

To change the calendar time scale:
1.Click the Tools tab.
2.Click Options.
3.Click Schedule.
4.Under Date/Time Settings, click on the Interval edit box and enter the time interval in minutes.


Change the background color

1.Click the Tools tab.
2.Click Options.
3.Click Schedule.
4.Under Schedule Options, click Background color, click the color that you want.


Change the font

1.Click the Tools tab.
2.Click Options.
3.Click General.
4.Under Program Options, click Font, and then click the size and font that you want to use.


Navigate in the Calendar

What would you like to do?

Change the number of days displayed

Jump to a date


Change the number of days displayed

The Day, Work Week, Week, Month, and Resource View buttons allow you to choose the number of days that are displayed in the Calendar.



Day

The Day view shows one day at a time. To move to the next day or previous day, you can use the Back and Forward navigation buttons Back and Forward buttons in the calendar.

Work Week

The Work Week view displays the five day work week. 

Week

The Week view displays the complete seven day week.

Month

The Month view displays the current calendar month. 

Resource 

The Resource view displays all resources for the current day.


Jump to a date

Use the date navigator to move to a new date by clicking a date on the calendar.





Print a calendar showing events

By default, Event Manager prints the current day, week, or calendar month. If you want to print specific dates, use the Date Navigator in the Navigation Pane to select the dates that you want to show in the printed calendar.

1.Click the File tab.
2.Click Print.
3.Set any print options, such as the paper orientation or size.
4.To print specific pages, click Properties. 
5.Click Print. 


Set or remove event reminders

For all new events

1.Click the Tools tab.

2.Click Options.

3.Click Alarms.

4.To turn default reminders on or off for all new events, under Alarm settings, select or clear the Set alarms for upcoming events check box.

5.If you select the check box, enter how long before the event when you want the reminder to appear.


For existing appointments or meetings

1.Edit the event.

2.At the bottom of the Edit Event screen, check the Reminder box and select how long before the appointment or meeting when you want the reminder to appear. To turn a reminder off, uncheck the Reminder box.


Go to a specified day in the calendar

You can quickly navigate to any date in the Event Manager calendar with either the keyboard or the mouse.

Use the Date Navigator

1.In Calendar, at the top of the Navigation Pane, click the date in the Date Navigator.



To quickly jump to one of the previous or next three months, click the month name, and then click the month that you want.



2.Click the date that you want.


Use Go To Date

1.On the Home tab, in the Go To group, click Today.


Change the default reminder time

Reminders alert you to upcoming calendar events such as appointments and meetings. By default, reminders occur 15 minutes before the start of these calendar items. However, you can increase or decrease the default reminder time.

Note    Even when you change the default reminder time, you still have the choice to specify a custom reminder time for each calendar item that you create.

1.Click the Tools tab
2.Click Options.
3.Click Reminders.
4.Under Reminder settings, next to Occurance, enter a new time.
5.Click OK.


Contacts

Create or edit a contact
Add, change, or remove a picture for a contact
Save contacts as VCards (Electronic Business Cards)
Import a contact from a VCard file


Create or edit a contact

Contacts can be as simple as a name and e-mail address, or include additional detailed information such as street address, multiple phone numbers, a picture, birthdays, and any other information that relates to the contact.

On the View tab, in the Contacts group, click Contacts.


Create New Contact

Press New.

Enter a name and any other information that you want to include for the contact.

To finish entering contacts click Save then close the screen. 

Edit Existing Contact

Click on the contact in the Contact List in the upper left.

Change any information that you want to include for the contact.

To finish editing the contact click Save. 


Add, change, or remove a picture for a contact

In Event Manager, images can be added to a contact. This helps you can put a face to a name or a quickly match a logo to a company contact.

Add, remove or change a picture

Contact photos can be in most standard graphics file formats, including .jpg, .png, .gif, .bmp, or .tif.

Add or change a picture
1.On the View tab, in the Contacts group, click Contact.
2.Click on the contact that you want.
3.In the Details section, click the elipsis icon to the right of the Photo field.
4.Browse to locate the picture that you want to add, and then double-click the file name.
5.Click Save.

Remove a picture
1.In Contacts, click the contact that you want to change.
2.In the Details section, click the Clear icon to the right of the Photo field and the elipsis icon.
3.Click Save.




Save contacts as VCards

VCards are like electronic business cards. They are computer files that contain detailed information about a contact. These files can be shared with others though email.

To save a contact as a VCard

1.On the View tab, in the Contacts group, click Contact.
2.Click on the contact that you want.
3.Click Export.
4.Select the folder you would like to save the VCard to.


To export all contacts as a single VCard list

1.On the View tab, in the Contacts group, click Contact.
3.Click Export All.
4.Select the  folder you would like to save the VCard list to.


Import a contact from a VCard file

If you receinve a VCard file from another person you can easily import it into Event Manager.

To import a VCard contact

1.On the View tab, in the Contacts group, click Contact.
2.Click Import.
3.Naviage to the VCard file you want to import, press Open.


Customizing

Add, change, or remove a picture for a contact
Change the appearance of your calendar
Change the sound played for reminders
Change the Event Manager color scheme


Change the sound played for reminders

The default sound for reminders can be changed to any .wav file format audio file.
1.Click the Tools tab.
2.Click Options.
3.On the Reminders tab, the Reminder Type pull-down list must be selected for sound alerts.
4.To choose a different reminder sound, click the Browse Icon and then browse to the.wav sound that you want.

The audio file can be located in folder on your computer or network share to which your computer always has access.


Change the Event Manager color scheme

The default color scheme of Event Mananger is Office 2010 blue. Other additional color schemes are available. The color scheme changes the user interface background of the Event Manager program window and backgrounds for most program elements including the Navigation Pane, To-Do list, ribbon, and forms for Data Manager.

1.Click the View tab.
2.In the Appearance group click the Style pull-down list and a color scheme.


Database Details

This section details the fields in all the database tables used in this application.

categories

id - Autoincrement
category_name - String - 20
color - Integer

companies

id - Autoincrement
company_name - String - 20

config

The config table contains all the configuration details for the software.

id - Autoincrement
ini - Text - Unlimited
rejection_email_script - Text - Unlimited
deletion_email_script - Text - Unlimited
request_email_script - Text - Unlimited
approved_email_script - Text - Unlimited
changed_email_script - Text - Unlimited
added_email_script - Text - Unlimited
catering_email_script - Text - Unlimited
reminder_email_script - Text - Unlimited
last_udate - Timestamp
key_file - BLOB - Unlimited

contacts

The contacts table stores all contact information. Contacts can be assigned to resources and assigned to events as attendees. A client is a contact that is assigned to an invoice.

id - Autoincrement
contact_name - String - 30
company_name - String - 30
address1 - String - 30
address2 - String - 30
city - String - 30
region - String - 30
country - String - 30
postal - String - 10
bill_address1 - String - 30
bill_address2 - String - 30
bill_city - String - 30
bill_region - String - 30
bill_country - String - 30
bill_postal - String - 10
home_phone - String - 15
work_phone - String - 15
mobile_phone - String - 15
work_email - String - 255
home_email - String - 255
website - String - 255
job_title - String - 20
profession - String - 20
picture - Blob
birth_date - Date
notes - Memo
active - Small Integer
card_dav_id - String - 50

event_attendees

The event_attendees table stores all the attendees which have been assigned to events.

id - Autoincrement
event_id - Integer
contact_id - Integer
status - Integer - etApproved(0),esAttended(1),esCancelled(2),esNoShow(3),esRejected(4),esReminder(5),esRequested(6),esRescheduled(7),esUnavailable(8)

The event_id field links to the id field of the events table. The contact_id field links to the id field of the contacts table.

event_items

The event_items table stores all the items which have been assigned to events.

id - Autoincrement
event_id - Integer
item_id - Integer
amount - Integer

The event_id field links to the id field of the events table. The item_id field links to the id field of the items table.

event_resources

The event_resourcees table stores all the resources which have been assigned to events.

id - Autoincrement
event_id - Integer
resource_id - Integer
cal_dav_id - String - 50

The event_id field links to the id field of the events table. The resource_id field links to the id field in the resources table. 

events

The events table stores all the events.

id - Autoincrement
start_time - DateTime - date and time the event starts.
end_time - DateTime - date and time the event ends.
event_key - String - 40 - unique guid for the event.
link_id - Integer - the id of the event this event links to.
notes - Memo
subject - String - 250
recurrency - Memo - See: The Recurrency Field
until_date - DateTime - the date the event ends.
color - Integer
meta_data - Memo - See: The Metadata Field
status - Integer - etApproved(0),esAttended(1),esCancelled(2),esNoShow(3),esRejected(4),esReminder(5),esRequested(6),esRescheduled(7),esUnavailable(8)
location_id - Integer
contact_id - Integer
login_id - Integer
on_wait_list - Small Integer - if set to 1 this event will appear on the waiting list.
archived - Small Integer - if set to 1 this event will no longer appear on the calendar.


The location_id field links to the id field in the locations table. The contact_id field links to the id field in the contacts table. The login_id field links to the id field in the logins table.

holidays

The holidays table lists all the statutory holidays. Holidays are used to automatically fill in holiday hours on the schedule.

holiday_date - Date
holiday_name - String - 30

invoices

The invoices table lists all invoices. 

id - Autoincrement
event_id - Integer
client_id - Integer
amount - number
tax1 - number
tax2 - number
payment_method - Unsigned Integer 
check_no - String - 10
payment_status - Unsigned Integer 
reference_id - String - 8
auth_code - String 6 
invoice_date - Date
paid_date - Date

The event_id field links to the id field of the events table. The client_id field links to the id field of the contacts table.

items

id - Autoincrement
item_name - String - 25
cost - Float
duration - integer

locations

The locations table lists all the locations such as rooms or offices. 

id - Autoincrement
location_name - String - 30
color - integer
rank - integer 
security_level - integer

logins

The logins table keeps track of all the user names and passwords used for the security features. 

id - Autoincrement
contact_id - Integer
login_name - String 15
password - String 15
security_level - Unsigned Integer - slNone(0),slUser(1),slManager(2),slAdmin(3)
color - integer
active - Small Integer

The contact_id field links to the id field of the contacts table.

resource_categories

id - Autoincrement
resource_id - Integer
category_id - Integer

The resource_id field links to the id field in the resources table. The category_id field links to the id field in the categories table.

resource_unavailability

The resource_unavailability table lists all the days and times resources are unavailable.

id - Autoincrement
resource_id - Integer
day - Integer
from_time - DateTime - time the resource is unavailable.
to_time - DateTime - time the resource is unavailable.
from_date - DateTime - date the resource is unavailable.
to_date - DateTime - date the resource is unavailable.

The resource_id field links to the id field in the resources table. 

resources

id - Autoincrement
resource_name - String - 30
rank - Integer
capacity - Integer
cost - Float
color - integer
contact_id - Integer
picture - Blob
active - Small Integer
security_level - Integer

The contact_id field links to the id field of the contacts table.

status

The status table lists event status codes that appear in the event status pull-down list in the Add Event screen. 

id - Autoincrement
status_name - String - 15
color - integer
cost - Float

tmp_event_dates

The tmp_event_dates table is used to temporarily store all the dates of repeating events. This data is used for reports and searches.

event_id - Integer
event_start_date - DateTime - date the event starts.
event_end_date - DateTime - date the event ends.
user_id - String - 30
type - integer

The event_id field links to the id field of the events table. The user_id field refers to the users Windows login_id. The type field indicates what type of temporary data: 0 - schedule data, 1 - search data. 

to_do

The to_do table lists all the appointment To do lists. 

planner_key - String - 40 - unique guid for the event.
start_time - DateTime - date and time the event starts.
end_time - DateTime - date and time the event ends.
link_key - String - 40 - the event_key of the event this event links to.
notes - Memo
subject - String - 250
color - integer
image_id - Integer
recurrency - Memo - See: The Recurrency Field
caption - Small Integer
min_time_field - DateTime - the start time of the first occurrence of the event.
max_time_field - DateTime - the end time of the last occurrence of the event.
creation_date - DateTime - the item was created.
due_date - DateTime - the date the item must be completed by.
completion_date - DateTime - the date the item was completed.
complete - Small Integer
resource_id - Integer
status - Integer - etApproved(0),esAttended(1),esCancelled(2),esNoShow(3),esRejected(4),esReminder(5),esRequested(6),esRescheduled(7),esUnavailable(8)
priority - Small Integer
completion - Integer
total_time - Integer
project - String - 50

The resource_id field links to the id field in the resources table. The image_id is an integer that refers to the image index the item is assigned. This is the same as the image field in the events table meta_data field.


The Recurrency Field

The recurrency field is specified via a recurrency formula that is based on an implementation of the the RFC 2445 iCalendar spec. The structure of the recurrency string is built from a series of specifiers SPECIFIER=value, separated by a ';' delimiter. The rule is prefixed by RRULE: while the exceptions are prefixed by EXDATES:

Example:
RRULE:FREQ=MONTHLY;COUNT=5;BYDAY=2WE

Possible specifiers:

Frequency
FREQ=MONTHLY
The frequency specifier can be : HOURLY, DAILY, WEEKLY, MONTHLY, YEARLY

Interval
INTERVAL=2
The default interval is 1. When the interval is 1, this does not need to be specified in the recurrency formula. The interval sets the number of time blocks between two recurring events. If the interval is set to 2 for a hourly recurring event of 1 hour duration, this will create a recurring series of events with one hour blocks between the events.

Count
COUNT=3
Sets the number of occurencies of the event

Until
UNTIL=end date
Sets the date of the last occurrence of the time. Note that the time specification is in ISO format, ie: YYYYMMDD.T.HHMMSS. So, Sep 21, 2004 16h30 is written as 20040921T163000

Note, a recurrency without COUNT or UNTIL specifier is considered an inifinite recurrency.

ByDay, ByMonth
BYDAY=series of days
BYMONTH=series of months
The ByDay and ByMonth specifiers set for which days or months the recurrency rule is applicable. The series of days or months is a comma delimited series of the names of days using the 2 first letters for days or month numbers.
BYDAY=MO,TU,WE,TH,FR,SA,SU
BYMONTH=1,2,3,4,5,6,7,8,9,10,11,12

Example:
RRULE:FREQ=WEEKLY;COUNT=9;BYDAY=TU,TH
This rule specifies a recurrencies for 9 occurencies weekly repeated on every Tuesday and Thursday of the week.
RRULE:FREQ=DAILY;UNTIL=20051231T000000;BYMONTH=1,2

This rule specifies daily recurring events during the months january and february till Dec 31, 2005.

Optional specifier for ByDay
An optional specifier can be used for the day of weeks to indicate in what day of a month an event should occur. This is done by prefixing the day name by the occurrency number of the day in the month.
Example:
RRULE:FREQ=MONTHLY;COUNT=5;BYDAY=2WE
This specifies a recurrent event, every month, for 5 months on the 2nd Wednesday of the month.

Exceptions
Exceptions to recurrency rules are a list of dates for which the rule is not applicable. The exceptions can be specified by adding these to the recurrency string as comma delimited ISO start and end dates:
EXDATES:startdate1/enddate1,startdate2/enddate2, ...

Example:
EXDATES:20040913T000000/20040913T235959,20040914T000000/20040914T235959


The Metadata Field

The Metadata field contain many different pices of information packed into a single record.

  TBookingRecord = packed record
    MemoAlign: word; - alignment of item text -taLeftJustify(0), taRightJustify(1), taCenter(2)
    Shape: word; - 1-psRect, 2-psRounded, 3-psHexagon
    Flashing: boolean; - True if item will flash
    Image: word; -0-based index of ImageList
    FontName: string[30];
    FontSize: word;
    FontColor: integer;
    FontStyle: integer; - fsBold(0), fsItalic(1), fsUnderline(2), fsStrikeOut(3)
    BackgroundColor: TColor;
    SelectedBackgroundColor: TColor;
    TrackbarColor: TColor;
    SelectedFontColor: TColor;
    Reminder: boolean;
    ReminderTime: TDateTime;
    ReminderMessage: string[255];
    ReminderURL: string[255];
    Attachement: string[255];
    URL: string[255];
    Location: string[30];


Demos



Getting help

Get the version number for Event Manager
You can check which version of the Event Manager software is installed on your computer.

Contact CyberMatrix support
If help is unable to resolve your questions, support is available by email, online, or phone.


Get the version number for Event Manager

You can check which version of the Event Manager software is installed on your computer.

See the version number for Event Manager
1.Click the Home tab.
2.Click the down arrown next to Help.
3.Choose About.


Contact CyberMatrix support



Pricing Information



Contact information

---

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 immediately. 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* for the most recent version of this software. Technical support by telephone during business hours is free of charge** for all existing and potential CyberMatrix customers for the most recent version of this software. 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.

Customers with outdated versions of this software must purchase a yearly support contract for $100 or upgrade their software to the current version to continue with free email and non-emergency phone 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. No e-mail support is available for CyberMatrix freeware although bug reports are welcomed and may be responded to.

** May be subject to change in the future. No free phone support is available for CyberMatrix freeware.
 


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 EDITION 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
Project Clock
Timesheets
Employee Project Clock
Class Scheduler
Employee Scheduler
In Out Scheduler
Point Of Sale
Clipboard Magic
Reminder


The latest [trial] edition 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 64 MB RAM, 20 MB HD.

For Pro Schedule Client/Server we recommend a dedicated XP, 2003, Vista, 2008 or Windows 7 server with 500 MB RAM and power backup to host the Pro Schedule server application.

For Pro Schedule Web a dedicated Windows XP, 2003, Vista, 2008 or Windows 7 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.

There are four different editions of Meeting Manager: Meeting Manager Standard, Meeting Manager Client/Server, Meeting Manager Enterprise and Meeting Manager Web. 

CyberMatrix Meeting Manager runs on Windows ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 64 MB RAM, 20 MB HD.

For Meeting Manager Client/Server we recommend a dedicated XP, 2003, Vista, 2008 or Windows 7 server with 500 MB RAM and power backup to host the Meeting Manager server application.

For Meeting Manager Web a dedicated Windows XP, 2003, Vista, 2008 or Windows 7 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 512 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 64 MB RAM, 20 MB HD.

For Project Clock Client/Server and Project Clock Web we recommend a dedicated XP, 2003, Vista, 2008 or Windows 7 server with 500 MB RAM and power backup to host the Project Clock server application.

For Project Clock Web 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 or Windows Mobile.

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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 32 MB RAM and 10 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 four different editions 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 256 MB RAM 20 MB HD

For Timesheets Client/Server and Timesheets Web we recommend a dedicated XP, 2003, Vista, 2008 or Windows 7 server with 500 MB RAM and power backup to host the Timesheets server application.

For Timesheets Web the clients require only a web browser.

Timesheets Enterprise requires a database server such as Oracle, Microsoft SQL server, MySQL or PostgreSQL.

CyberMatrix Timesheets Standard and Web costs $55 for a single license. CyberMatrix Timesheets Client/Server and Enterprise costs $75 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 512 MB RAM and 30 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 512 MB RAM, 30 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 64 MB RAM 20 MB HD

In Out Scheduler costs $64 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 512 MB RAM and 20 MB hard disk space. The server application requires at least 1 GB RAM.

The CyberMatrix Point of Sale client costs $300 for a single-user 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 ME, XP, 2003 Server, Vista, 2008 Server and 7. System requirements: 256 MB RAM and 10 MB hard disk space.



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. 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. 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 in Windows usually you just have to double-click it and it will open as a folder. If you use an older version of Windows you will need an unzip program such as WinZip. You can find WinZip here: http://www.winzip.com. Once you have installed an unzip 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. I have downloaded and installed your trial edition. Now I want to purchase. Will the purchased edition 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. Any report files you have modified will be overwritten though. When you change a report you should save it with a new file name to prevent it being overwritten


Q. I have downloaded and installed your trial edition. Now I want to purchase. After purchase do I just enter a key to unlock the trial edition? 
A. No. After purchase you will have to install the full software. But you can install right over the trial edition and it will still use your old data. As a precaution always backup your data before 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 in the same manner as you installed the old version and your old data will remain intact.


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 US per hour. Contact us for a quote including as much detail as possible about how you want the software changed.


Q. We really like your software but would like to talk to some of your customers. Can you refer us to some of your customers in our area?

A. Due to privacy concerns we never give out customer information. You can look on the software's testimonial page for actual customer testimonials. We also have fully functional time-limited trial editions of our software you can try out to see how you like it before ordering.


Q. I tried to create a new report but hen I select the frxDBDataset1, no fields appear. How can I access the fields?

A. You need to add the report's SQL, save, close and then re-open to see the fields. You can choose Help | Getting Started With Custom Reports from the report screen to learn more about creating your own reports.


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?

A. You probably have not set a default printer in the 'Control panel - Printers' window.


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 outdated versions on the web site. Existing customers can upgrade to the latest version at a 50% discount though.


Q. What are your support fees?

A. Support by email is free. Phone support during business hours is free. 24 hour paid emergency support is available for a $25 fee per incident. For outdated software, a yearly $100 contract option is available.


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 edition of program X using  Internet Explorer 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. 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. Try emptying your browser cache and try downloading again. If you still can't download, send an e-mail and a trial edition setup file can be e-mailed to you as an attachment. 


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 feel free to send in an e-mail.


Q. My program shows the wrong date format. How can I make the software use the system date format we use? 

A. This is probably due to a bug in Windows. Try these steps:

1) choose Start/Configuration/Regional settings
2) on the first tab select a different country, e.g. Germany, and press [APPLY]
3) set the country back to what it should be and press [OK]
4) Now the software will behave again as expected. 


Q. Is it possible to do a silent install of your software?

A. Yes like this:

Setup.exe /SP- /silent /noicons "/dir=c:\Program Files\My Program"

Just change Setup.exe to the name of the setup file you want to install and My Program to the folder you want the software installed to. Note that in software with multiple install options, the first option will always be chosen with this technique. In this case you can use the /Type parameter like so:

Setup.exe /SP- /silent /noicons "/dir=c:\Program Files\My Program" "/Type=Client Only" 


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 the software 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. For concurrent licensing you just have to determine the maximum number of people that will be using the software at one time. That is the number of licenses you need. 


Q. Are your license fees annual fees? 

A. Our license fees are one-time fess for the current version. When we release a major new version you have the option of upgrading at a 50% discount. 


Q. We want to buy your software. We will have one person making changes to the data and eight people that will only be viewing the data. Do I need a single seat license or a 9 seat license? 

A. Since 9 people will have access to the software you will need a 9 seat license. 


Q. What is the difference between your trial edition and the full edition?

A. The only difference between our time-limited software and the full editions 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 in 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 new version 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 import the license key as explained in the download instructions. The download instructions were emailed to you after your purchased or upgraded the software.


Q. I just updated our software to a new minor version. Why does the software now say it is an evaluation copy? 

A. You must install the full software not the trial software. The full software download link was emailed to you after you purchased or upgraded the software. 
 

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 imported as explained in the registration instructions. How do I get rid of this message?

A. Check the Users table for ghost users. Ghost users are those users who are listed as still using the program even they no longer are. If there are any ghost users, delete those records. 


Database/Multi-user questions

---

Q. I upgraded an old version of your software to a newer version. Why can I no longer see any of my old data?

A1. If you upgraded from Employee Project Clock v6 or lower, Project Clock v8 or lower, Timesheets v3 or lower, Meeting Manager v7 or lower or Pro Schedule v6 or lower you must upgrade your data to the new format. Step by step instructions to upgrade your data are seen during installation right after the license agreement. After installation you can read these instructions by clicking the "Installation Instructions" shortcut on the program's start menu.

A2. Possibly you installed the data into a different folder using the Data only install. You'll need to find out where the old data folder was an set the data folder option setting to this path. 
 

Q. Why am I getting strange errors like this one below?

ElevateDB Error #600 File manager error (Cannot delete the file C:\DOCUME~1\fullerm\LOCALS~1\Temp\CM1S29083572PC45.EDBTbl (OS Error: The process cannot access the file because it is being used by another process. )). 

A. This is probably due to your anti-virus software interfering with our software's database files. Try configuring it to not scan the data folder of our software.


Q. How can we share data amongst several people with the Standard edition?

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 installed the Standard edition on only one machine. How can I setup another machine to use the same data? 

A. You need to either share the current data folder so the other machines can access it or move the data folder to a shared location and then setup each machine to use that data. 


Q. I want to share data amongst several people. Can I use the Standard edition or do I need to purchase the Client/Server edition?

A. The Standard editions of our software (as well as Class Scheduler, Employee Project Clock, Employee Scheduler, In Out Scheduler and Project Clock Pro) all use a local database. A local database can share data with multiple users over a network. However, shared local databases are 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 local database edition with more than 10 simultaneous users. With 10 or more simultaneous users the Client/Server edition will perform better.


Q1. When I Start Program X why does the following error message appear: <br><br>
ElevateDB Error #601 The table Users is corrupt
Q2. 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.) Newer versions of our software will re-index (repair) tables automatically if all users close the software and a single person restarts it. To re-index the table manually, first close down all instances of the software except one. Then select the problem table in the Detail tab of the Data Manager screen and then choose File | Re-index table (or File | Repair 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 CyberMatrix.


Q. When I try to start your software a Data Missing box appears and says that I need to attempt re-installation or enter new data folder location.  What does this mean and what do I need to do?

A. The software cannot find the data. Possibly the drive it was on is no longer available. You should verify that the machine where the data is stored is functioning properly and that no changes have been made relating to the data folder, e.g. drive mapping changes.


Q. When I try to re-index a table I get the error "Re-Index failed". 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 (.EDBTbl, .DAT), index file (.EDBIdx, .IDX), or BLOB file (.EDBBlb, .BLB) is 4 gigabytes. 


Q. Performance seems very slow. How can we make it faster?

A. Turn off anti-virus software, or configure it to NOT scan *.EDB* files on newer software and .DAT, .IDX, .BLB files on older software (or simply your entire database folder).


Q. How can I import data from another program into your software?

A. Export the data from the other program into CSV format. Then in the Data Manager screen of our software select View | Data Manager from the main menu. Select the table then choose File | Import CSV File. 


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. How can I use your file-server (local, standard) software with two different data folders on the same machine?
A. You could install the software in two different folders on the same machine each having separate data. The trick is that the data files must reside in a folder called Data inside the program's folder. 

Q. Which database engine is used in your software?

A. We use Elevate DB and the DBISAM database engine for all our non-Enterprise Windows business applications. Meeting Manager, Pro Schedule, Project Clock, Employee Project Clock, Timesheets and Point of Sale now use the Elevate DB engine.


Q. Can your database tables be accessed from Crystal Reports or other common database software?
A1. For newer non-enterprise editions 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

A2. For older versions 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. 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. 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. I exported a table to CSV. Why is it when I try to import that same CSV file it says there is an "Invalid data value in import data."?

A. When running the CSV import wizard, your time format must be exactly the same as what is in the CSV file. Most people leave in the .zzz part in the import format string when their CSV data does not have microseconds. The import is not always sophisticated enough to determine what date/time formats you are using. You have to tell it.  


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 edition 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 edition you would just install V2 in another folder. For the Standard edition 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:\ProgramX\Data. The software would have to be installed in the C:\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.  


Client/Server software 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. What is the advantage of Client/Server over File/Server?

A. Client/server applications will be faster on slow networks like wireless networks because only the data packets required are sent down the network. With File/Server every table in a query will be sent down the network. Client/Server application will be less susceptible to database corruption because there is no direct access to the data. Only the server machine directly writes to the data files. 


Q. We are using the Client/Server edition of program X. Why will the clients not connect to the server? 

A. There are only three possibilities for this problem. Either the server is not running, the IP address is entered incorrectly or something like a firewall is blocking access to the server. 

Sometimes the server software will not be listening to the correct IP address. Click the following link to watch a Flash demo of how to change the server IP. Change server IP.


Q. We are using the Client/Server edition 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 newer server software runs by default on port 12010. All our older server software runs on port 9000.


Q. We are very interested in the Client/Server edition of your software. However, we want the server application to run as a service. Is this possible? 

A. Yes it is possible to run the database server as an NT service. There are several advantages of running the server as a service: you can ensure it restarts if the machine reboots unexpectedly for any reason; you can take actions if the service crashes; and you can run the service as a specified user fairly easily. To install the edbsrvr.exe database server as a service enter the following command at a command line prompt or from the Run Menu:

edbsrvr.exe /install

To install the database server so that it does not interact with the desktop at all, which is required in instances where the current user will be logged out of the system, then you should use the /nointeract flag along with the /install command-line switch:

edbsrvr.exe /install /nointeract

This will install the service as a non-interactive service and the database server will not display a user interface when it is started.
To start the edbsrvr.exe database server as a service enter the following command at a command line prompt or from the Run Menu:

net start edbsrvr.exe


Q. I installed the server as a service and the service is running. When I try to run the server as a regular Windows application why do I see the error: "Only one usage of each socket address (protocol/network address/port) is normally permitted"?
 
A. Only one application can listen exclusively on a port at one time. You can't therefore run two instances of the server application at one time.


Q. We use the Client/Server edition 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 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 install the new server software on the new machine and then copy over the database files. The database files are those with the *.EDB* extensions for newer software and .Blb, .Dat and .Idx extensions for older software.


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 edition 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 edition you would just install V2 in another folder. For the Standard edition (or Project Clock Pro) 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\Data. The software would have to be installed in the C:\Program\ 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. 


Enterprise software questions

---

Q. We're using your Enterprise software with Microsoft SQL Server. On some of the client machines when we try to connect why do we get a Ntwdblib.dll not found error?
 
A. Each client needs special connectivity libraries installed. If these libraries are not installed the clients will not be able to connect to the database server. These libraries are available from the vendor of the database server you are planning to use. 

For MS SQL Server 2005 and higher you should connect using ADO instead of MSSQL. The following video shows how to setup ADO to work our software: MS SQL ADO Setup.

For older versions of Microsoft SQL Server you can just install the MS SQL client software or just copy the Ntwdblib.dll file to the Windows System folder (\winnt\system32 on XP).

 
Q.  I'm using Microsoft SQL server with your Enterprise edition software. I'm having a problem and want to send you our data so you can try to reproduce it and fix it. How can I send you our data? 

A. Unlike other large database servers, MS SQL Server does not have a function to backup data to a SQL INSERT script. You will need to use a third party utility to backup the data to a SQL script. Alternatively you could export each table to CSV format. Sending in a MS SQL Server backup file will not work.


Q. I'm trying to use your Enterprise edition with MySQL version 5. When trying to connect I get the error: "SQL Error: Client does not accept authentication protocol requested by server. Consider upgrading MySQL client". Does your software not work with MySQL v5? 
A. This software will run on MySQL v5. However, it connects as a v4 client. This means you will have to convert the connection password to the older style. You can do this with a query like the following:

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('magic');

See also: http://dev.mysql.com/doc/refman/5.0/en/old-client.html
 

Q.  What permissions should be given to the Database Server Account for the clients? 

A. The user needs SELECT, INSERT, UPDATE and possibly CREATE_TMP_TABLE privileges.