Contents
Meeting Manager is a multi-user application for coordinating the booking of meeting room resources in office buildings. Resources can be the meeting rooms themselves or special equipment needed for meetings such as overhead projectors.
Installing Meeting Manager
Getting Started
Configuring Meeting Manager
Using Meeting Manager
Meeting Manager Configuration
Adding Users and Changing Passwords
Assigning Security to Resources
Meeting Manager Data
Preventing Database Corruption
Differences between the local, client/server, enterprise and web editions
Multi-Language Support
Frequently Asked Questions
Purchase Information
Feedback and Technical Support
License Information
Other CyberMatrix Software
For up to date news on Meeting Manager visit the CyberMatrix home page:
http://www.cybermatrix.com
© 1998-2008 CyberMatrix Corporation, Inc. All rights reserved.
Getting started
Starting Meeting Manager
When Meeting Manager is first started a bulletin screen may appear if the bulletin feature has been enabled. See also: Bulletin screen. If security has been enabled a login dialog will appear. If you haven't already contact your administrator for your username and password. See also: Security. After that the Tips dialog will appear and after that the main screen.
Entering your data
The first step in using Meeting Manager is to setup your resource data. Data is entered and edited using the Data Manager. See the Data Manager section for details on how to use it.
If you are using Meeting Manager Client/Server the Data Manager will be found in the server software.
If you are using Meeting Manager Enterprise, there is no Data Manager. The data will have to be entered in the control center of your back-end database system. Alternatively, data can be entered using the forms listed on the Tools menu of the main form.
Here are links that explain some common tasks:
Adding a New Booking
Deleting an Existing Booking
Editing an Existing Booking
See the Using Meeting Manager section for the full details on using Meeting Manager.
Bulletin Screen
This screen pops up whenever Meeting Manager is started. Click the check box titled "Do Not Show This Bulletin Again" to prevent seeing this screen again. Alternatively, you can uncheck the View|Options|Show Bulletin option on the main menu.
Security
By default, there is no security in place for Meeting Manager. This means that in a multi-user environment, any user will be able to view and edit any other person's bookings. To prevent this you can implement the security option (see the Options screen). When security is in place, an administrator must login in order to edit other users' bookings as well as access the security options screen.
When security is enabled, a login dialog box will pop up when you try to access any of the administrative features.
The default password for all security levels is "magic". To ensure you have a secure system change the passwords immediately.
Important: write down and store your changed password in a secure location such as the company safe.
If you wish all users to login before using the software, you must set the Force Login option. In this case, all user names and passwords must be entered into the Security table. See the Manage Security section for help in working with the security table.
In the Meeting Manager program, there are three levels of security.
User
User level security is the default security level. Users will be able to edit bookings they have made unless the Allow user edits option has been unchecked.
Your Meeting Manager Administrator may have setup the application to default to allow only viewing and not booking. If this is the case and you require booking privileges, you must contact your Administrator to receive the User security level password.
If the Login To Book option has been set in the software, users must login as a user before booking resources.
If the Force login option has been set each user must login when the program starts.
Superuser
The Superuser security level allows you to book resources that require Superuser access. Contact your administrator if you require this feature. Note that Superusers may edit others' bookings if the Allow superuser edits option has been set.
Administrator
As well as having Superuser privileges, the Administrator security level allows you to delete and edit any booking regardless of who entered the booking. Only Administrators can access the Meeting Manager options section and the Data Manager. The default Administrator password is magic. To ensure you have a secure system change the passwords immediately. Write down the new passwords and store them in a secure location such as the company safe.
Logging in to a Security Level
To log in as a User, Superuser or Administrator select File | Login from the main menu. A login box will pop up asking you to enter a username and password. You can enter User, Superuser, Administrator or your own loginID assigned to you by your administrator. Note that login IDs and passwords are case-sensitive. They must be entered exactly as they appear in the Security table.
Assigning Security Levels to Users
Security levels can be assigned to users by editing the Security table using the Data Manager. To make a user an Administrator simply enter an uppercase A in the level field for that user. To make a person a Superuser enter an S.
Using Meeting Manager
Getting to know the Main Screen
Adding a New Booking
Booking an Entire Day
Requesting, Approving and Rejecting Bookings
Deleting an Existing Booking
Editing an Existing Booking
Copying a Booking
Week at a Glance
Resources at a Glance
Month at a Glance
Viewing Resource Details
Viewing Booking Reports
Viewing Schedule Report
Searching for Available Resources at Given Time
Searching for Bookings
Searching for an Available Time slot
Searching for an Available Time Period
Requesting, Approving and Rejecting Bookings
Resolving Booking Conflicts
Meeting Manager Security
Meeting Manager Data
Making your own Reports
Getting to know the Main Screen
On running the program, the following screen will appear.
The main screen is where you view bookings for the selected resource on the selected day. The main screen consists of a menu and various visual controls.
The visual controls
The visual controls consist of a toolbar and the scheduler grid. The scheduler grid shows a list of times and any bookings that are scheduled for those times. The toolbar has two parts. The top part consists of several buttons. These buttons perform key functions of the Meeting Manager program. These key functions can also be found on the menu.
The bottom part of the toolbar contains three filter fields: Resource, Date and Category. Click the down arrow to the right to show a list of available resources. Upon selecting a different resource, the schedule will update to show all bookings for that resource on the listed day. The Date filter changes the booking date. Click the down arrow to the right to bring up a small calendar. Upon selecting a different date, the schedule will update to show all bookings on the selected date for the listed resource. The Category filter changes the current resource category. When a category is selected only bookings of resources belonging to the selected category will be shown.
The menu
The Meeting Manager main menu has four sections: File, Bookings, View and Help.
The File Menu
The File menu contains these functions:
Open Site - Brings up a sub-menu containing all sites. Each site is basically a separate database having different resources, bookings and configuration settings. Selecting a site allows you to open another site and enter bookings for that site. [The Site menu is not available in the Client/Server and Enterprise editions.]
Login - Allows you to login as Administrator or another user. If security is not enabled the Login and Logout menu items are grayed out.
Logout - Logs the current user out.
Change Password - Brings up the change password dialog that allows you to change your log in password.
Language - Brings up a sub-menu containing all available language files. Selecting a new language will cause all text in the software to be translated into the new language.
Exit - Closes the program.
The Bookings Menu
The Bookings menu contains these functions:
Add Booking - Brings up the Add Booking screen where a start and end time for the new booking must be entered.
Delete Booking - Deletes the selected (colored light yellow) booking. If security has been enabled only an Administrator or the person who first entered the booking can delete bookings. See also: Security
Edit Booking - Allows selected booking to be edited.
View Booking - Brings up the View Booking Screen, allowing all booking details to be seen.
Copy Booking - Brings up the Add Booking Screen with a copy of the selected booking.
Book for Whole Day - Attempts to book the current resource for the whole day.
Send E-mail to Booking Contacts - Brings up the E-mail screen with the current resource's e-mail contacts.
Find Existing Booking - Brings up the Find Booking screen allowing you to search for bookings by resource, date, topic or notes.
Find Next Booking - Finds the next booking matching the current search criteria.
Find Time Slot - Finds the next available time slot for the current resource starting on the current day. In the dialog box enter the time slot interval in the following format hh:mm. For example, to find the next available three-hour time slot enter 3:00.
Find Next Time Slot - Find the next available time slot.
Find Time Period - Find the next available sequence of days for the current resource starting on the current day. In the dialog box enter the number of days in the period. For example, to find the next available three-day time period enter 3.
Find Next Time Period - Finds the next available time slot.
Refresh Schedule - Refreshes the meeting scheduler grid with the most recent data in the database.
The View Menu
The View menu contains these functions:
Data Manager - Brings up the Data Manager screen, which is used to administer the raw data used in Meeting Manager. Note that the Data Manager menu item is not available in the Client/Server client software nor in the Enterprise edition.
Options - Brings up the Options screen, which allows global configuration settings to be changed.
Week at a Glance - Changes the schedule view to show all the week's bookings for the selected resource.
Weekdays at a Glance - Changes the schedule view to show all the week's weekday bookings for the selected resource.
Resources at a Glance - Changes the schedule view to show the bookings of all resources on the selected day.
Resources this Week - Changes the schedule view to show the bookings of all resources for the current week.
Month at a Glance - Changes the schedule view to show all bookings of the selected resource in the selected month.
Resources this Month - Changes the schedule view to show all bookings of all resources in the selected month.
Next Date - Increments the schedule date depending on the view. In single view the date is changed to the next date, in week view the date is changed to the next week and in month view the date is changed to the next month.
Previous Date - Decrements the schedule date depending on the view.
Booking Reports - Brings up the Booking Reports screen, which allows the printing of reports.
Schedule Report - Sends the current schedule to the chosen printer. For Monthly reports an HTML schedule report is shown.
Schedule HTML Report - Shows the current schedule in HTML format.
Resource Details - Shows details about the currently selected room or resource. Details include resource description, capacity and equipment usually found in the room.
The Tools Menu
The Tools menu contains these functions:
Manage Categories - Brings up the Manage Categories screen, where resource categories can be added or edited. See also: Managing Categories.
Manage Contacts - Brings up the Manage Contacts screen, where booking contacts can be added or edited. See also: Managing Contacts.
Manage RAAG - Brings up the Manage Resources At A Glance screen, where resources for the Resources At A Glance view can be added or edited. See also: Managing Resources At A Glance, Schedule Options.
Manage Resources - Brings up the Manage Resources screen, where resources can be added or edited. See also: Managing Resources.
Manage Resources Unavailable - Brings up the Manage Resources Unavailable screen, where resource availability records can be added or edited. See also: Managing Resources Unavailable.
Manage Security - Brings up the Manage Security screen, where user names and passwords can be added or edited. See also: Managing Security.
Manage Status - Brings up the Manage Status screen, where booking status records can be added or edited. See also: Managing Status.
Manage Topics - Brings up the Manage Topics screen, where booking topics can be added or edited. See also: Managing Topics.
Managing Categories
To manage categories choose Tools | Manage Categories from the main screen menu. The following screen will appear:
This screen will allow you to view information on each resource category. You can also use this form to add or edit category information. To view information on a category, select the category from the category pull-down list. To edit information on the currently listed category press the Edit button. The fields will now allow changes to them and the Save button will become enabled. After making your changes press the Save button. To add a new category, press the New button. All the fields will become blank allowing you to enter new information. When you are finished entering information press the Save button to add the new category. To delete the current category click the Delete button.
The categories listed here will show up in the Category pull-down list on the main scheduler screen. When a category from this table is chosen from this pull-down list, only the bookings of resources belonging to this category will be shown.
Fields Explained
The Category field must be a unique ID for the category. The Description field is a descriptive name for the category.
Managing Contacts
To manage contacts choose Tools | Manage Contacts from the main screen menu. The following screen will appear:
This screen will allow you to view information on each contact. You can also use this form to add or edit contact information. To view information on a contact, select the contact from the contact pull-down list. To edit information on the currently listed contact press the Edit button. The fields will now allow changes to them and the Save button will become enabled. After making your changes press the Save button. To add a new contact, press the New button. All the fields will become blank allowing you to enter new information. When you are finished entering information press the Save button to add the new client. To delete the current contact click the Delete button.
The names listed here will show up in the Contact pull-down list in the Add Booking screen. When the Contact field in the Add Booking screen is double clicked, the contact's e-mail address will be queried from this table in order to e-mail the booking contact. The e-mail addresses from this table will show up in the Attendees pop-up in the Add Booking screen.
Fields Explained
The Contact field is a unique identifier for the contact. Every different contact must have it's own ID. The Extension field indicates the contact's extension number if any. The LoginID field indicates the contact's network login ID. The Equipment field indicates which equipment this contact is responsible for.
Managing Resources At A Glance
To manage the resources seen when in the resources at a glance view choose Tools | Manage RAAG from the main screen menu. The following screen will appear:
This screen will allow you to view the resources seen when in the resources at a glance. You can also use this form to add or remove resources from the resources at a glance view. To add a resource to the resources at a glance view select the resource in the Available box on the left. Then click the move right button, the button with the right pointing arrow. To make all resources show in the resources at a glance view click the move all right button, the button with the two right pointing arrows. To remove a resource from the resources at a glance view select the resource in the RAAG box on the right and press the move left button.
See also: Schedule Options.
Managing Resources
To manage resources choose Tools | Manage Resources from the main screen menu. The following screen will appear:
This screen will allow you to view information on each resource. You can also use this form to add or edit resource information. To view information on a resource, select the resource from the resource pull-down list. To edit information on the currently listed resource press the Edit button. The fields will now allow changes to them and the Save button will become enabled. After making your changes press the Save button. To add a new resource, press the New button. All the fields will become blank allowing you to enter new information. When you are finished entering information press the Save button to add the new resource. To delete the current resource click the Delete button.
The resources listed here will show up in the Resource pull-down list on the main scheduler screen. When a resource from this table is chosen from this pull-down list, only the bookings of these resources will be shown.
Fields Explained
The Resource field must be a unique ID for the resource. The Description field is a descriptive name for the resource. The Capacity field indicates how many people the particular room can accommodate. The cost field indicates how much it costs to rent out the room. The Security field indicates who can book this resource. The Security field can contain A for Administrator, S for Superuser and blank or U for User. In this case you must be at least a Superusers to book room D4. The Equipment field contains a list of equipment normally found in this room. Separate each piece of equipment with a comma.
If a resource is itself a piece of equipment, you must set the Category field to "Equipment". Only resources flagged as "Equipment" will show up in the Equipment pop-up selector in the Add Booking screen. The E-mail contacts or Attendees are a list of e-mail addresses separated by spaces or commas. If the Notify Attendees option is set, whenever a booking is changed or deleted, a notice will be e-mailed to the e-mail addresses listed in the Attendees booking field.
The DefaultContact field is used to automatically assign a contact when the resource is booked. The DefaultContact field links to the Name field in the Contacts table. The DefaultTopic field is used to automatically assign a topic when the resource is booked. The DefaultTopic field links to the Topic field in the Topics table. The Picture field stores a JPEG image of the resource. To assign a picture to the resource click the Picture button. A dialog will pop up allowing you to choose a JPEG image of the resource. The Active field indicates whether this resource can be booked and have its schedule visible.
Managing Resources Unavailable
To manage resource availability choose Tools | Manage Resources Unavailable from the main screen menu. The following screen will appear:
This screen will allow you to view days, times and day ranges resources are unavailable. You can also use this form to add or edit resource availability information. To view the availability records for a resource, select the resource from the resource pull-down list. All the availability records for the resource will appear in the grid at the bottom of the screen. Double click a record to show its details in the fields. To edit information on the currently listed availability record press the Edit button. The fields will now allow changes to them and the Save button will become enabled. After making your changes press the Save button. To add a new availability record for the current resource, press the New button. All the fields will become blank allowing you to enter new information. When you are finished entering information press the Save button to add the new record. To delete the current record click the Delete button.
Fields Explained
The Day field indicates the day the resource is not available. Sunday is 1, Monday is 2, ... and Saturday is 7. To make a resources unavailable all day long just enter a value for the Day field and leave the From and To fields blank. To make a resource unavailable for a time period every day, leave the Day field blank and enter values for the TimeFrom and TimeTo fields. To make a resources unavailable for a range of days, leave the Day, TimeFrom and TimeTo fields blank and enter date values in the DateFrom and DateTo fields.
Managing Security
To manage user names and passwords choose Tools | Manage Security from the main screen menu. The following screen will appear:
This screen will allow you to view information on each security user name. You can also use this form to add or edit user name information. To view information on a user name, select the login ID from the Login ID pull-down list. To edit information on the currently listed user name press the Edit button. The fields will now allow changes to them and the Save button will become enabled. After making your changes press the Save button. To add a new user name, press the New button. All the fields will become blank allowing you to enter new information. When you are finished entering information press the Save button to add the new user name. To delete the current user name click the Delete button.
The user names listed here will show up in the Login ID pull-down list on the security login dialog.
Fields Explained
The Level field indicates which security level the user has. The Level field can be A for administrator, S for superuser and U or blank for user.
See also: Security
Managing Status
To manage booking status records choose Tools | Manage Status from the main screen menu. The following screen will appear:
This screen will allow you to view information on each booking status record. You can also use this form to add or edit status record information. To view information on a booking status record, select the status from the status pull-down list. To edit information on the currently listed booking status press the Edit button. The fields will now allow changes to them and the Save button will become enabled. After making your changes press the Save button. To add a new status record, press the New button. All the fields will become blank allowing you to enter new information. When you are finished entering information press the Save button to add the new status record. To delete the current status record click the Delete button.
The status records listed here will show up in the Status pull-down list on the Add Booking screen.
Fields Explained
The Status field must be a unique ID for the booking status. The Description field is a descriptive name for the booking status.
Managing Topics
To manage booking topic records choose Tools | Manage Topics from the main screen menu. The following screen will appear:
This screen will allow you to view information on each booking topic. You can also use this form to add or edit topic information. To view information on a booking topic, select the topic from the topic pull-down list. To edit information on the currently listed booking topic press the Edit button. The fields will now allow changes to them and the Save button will become enabled. After making your changes press the Save button. To add a new topic, press the New button. All the fields will become blank allowing you to enter new information. When you are finished entering information press the Save button to add the new topic. To delete the current topic click the Delete button.
The topics listed here will show up in the Topic pull-down list on the Add Booking screen.
Fields Explained
The Topic field must be a unique ID for the booking topic. The Color field indicates which color bookings with this topic will have. The Duration field indicates how long in minutes bookings with this topic normally take. When a number is entered in the Duration field, on adding an booking the end time will automatically be calculated based on the start time and the duration.
Adding a New Booking
Before adding a new booking, select the date and room or resource block where the booking will take place.
There are two ways to add a new booking.
The simplest way to add a new booking is by dragging the mouse on the schedule grid. Click the cell in the scheduler corresponding to the booking start time. Without releasing the mouse button, drag the mouse pointer to the cell corresponding to the booking end time. When the mouse button is released the Add Booking screen will pop up with the start and end times automatically entered.
The second way to add a new booking is to click on the Add Booking button.
This will cause the Add Booking screen to pop up where the booking start and end time will have to be entered manually.
See also: Getting to know the Add Booking screen
Getting to know the Add Booking screen
When adding a new booking the following screen will appear.
Depending on how you add a new booking, the booking start and end time may not have been automatically filled in for you. The booking start time is the time that the booking will begin. The booking end time is the time the booking will end. If this is the case, you will have to populate these fields before adding the booking. If you would like to book more than one resource you can click the ellipsis (...) button to the right of the Resource pull-down list. The pop-up screen will list all resources listed in the Resources table.
The booking topic and the contact name do not have to be entered but the contact extension number is required. The booking topic describes what the booking will be about. The booking contact is the name of the person to contact regarding the booked resource.
New contacts can be added right from the Add Booking screen by clicking on the button to the right of the Contact field. This will bring up the Add Contact screen, which allows you to add new contacts. See also: Getting to know the Add Contact screen
The Notes field is for entering any additional notes about the booking.
The Attendees field is for listing local or Internet e-mails addresses of those attending a meeting. Each e-mail address is separated by a space. If the Notify Attendees option is set in the program, all attendees will be e-mailed a message when the booking is changed in any way. Click the ellipsis (...) button to the right to choose Attendees. The pop-up screen will list all email addresses listed in the Contacts table. To add new contacts use the Manage Contacts feature.
The Equipment field is for listing the equipment to be used for the booking. Press the ellipsis button to the right to select equipment. All resources designated with the "Equipment" category will show up here. To add new equipment resources use the Manage Resources feature.
The catering field lists any catering related notes for this booking. Items added to this field will be added to the catering pull-down list for future bookings. To edit this list you can edit the Catering.txt file in the Meeting Manager data folder.
The status field indicates the current status of the booking.
The color field indicates what color the booking will have when viewed in the scheduler.
The attendance field indicates how many people will be attending the meeting. If the booked resource has a capacity set for it, the booking will not be allowed if the total attendance for the meeting in the selected time period exceeds the resource's capacity.
The Booked by field indicates the loginid of the person who booked the resource. When security is enabled only Administrators can change this field.
Tool Buttons
On the right side of the Add Booking screen are several buttons. These buttons are described below.
Search
Shows all available resources for the given time period. Useful if you need to book a resource at a particular date and time but do not care which room the booking will take place in you can search for available rooms. See also: Searching for Available Resources at Given Time
Details
Shows details about the currently selected room or resource. Details include resource description, capacity and equipment usually found in the room. See also: Viewing Resource Details
E-Mail
Brings up an e-mail window with a default message addressed to the contact for the current meeting. See also: E-mail screen
Confirmation
Prints a confirmation report for the booking. The confirmation report will need to be edited to include your address in it. See Also: Custom Reporting
Save
Saves the booking and exits back to the resource scheduler window.
Cancel
Cancels the booking and exits back to the resource scheduler window.
Booking Frequency
When adding a new booking it is possible to book the resource at a certain recurring frequency.
Resources can be booked with the following frequencies:
One Time
The resource will be booked only on the supplied date.
Daily
Selecting the first option, the resource will be booked every weekday.
Selecting the second option, the resource will be booked every day of the week.
Weekly
Selecting this option, resources will be booked every x weeks on the chosen days. For example, to have your booking recur every two weeks on the same day you would enter a 2 in the edit box.
Monthly
Selecting the first option will cause your booking to recur every x months on the same day as the booking day. So, to book a resource on the same day of the week every quarter, you would enter a 4 in the edit box.
Selecting the second option allows for complex monthly scheduling. Resources can be booked on every First, Second, Third, Fourth or Last weekday of every x months.
End Date
All recurring events may be halted by selecting an "Until" date. This date specifies the last date that bookings will take place for the recurring event. The End Date will default to the Default End Date set in the options. See also: Schedule Options
Adding the New Booking
When all the booking information has been added, press the Save button to save the booking and exit back to the scheduler. If a booking has been added or changed and the Auto notify option has not been set the E-mail window may appear. See also: E-mail screen, E-mail options
Pressing the Cancel button will exit back to the booking scheduler without saving the booking.
E-Mail Screen
When e-mailing the booker of a meeting or the meeting attendees, the following screen will appear:
The E-mail screen has several different fields. Below is a description of each field.
E-Mail Address
This is the e-mail address the message will be sent to.
E-Mail Subject
This is the subject of the e-mail.
E-Mail Carbon Copies
E-mail addresses listed here will get copies of the message. The addresses are separated by carriage returns.
E-Mail Blind Carbon Copies
E-mail addresses listed here will get copies of the message but no one will see these recipients listed. The addresses are separated by carriage returns.
E-Mail Body
The body of the message.
E-Mail Status Messages
Indicates the status of the sent e-mail.
E-Mail File Attachment
The optional attached file to send with the e-mail.
Mail
Send the e-mail.
Close
Closes this screen.
Getting to know the Add Contact screen
The Add Contact screen is used to conveniently add new contacts from the Add Booking screen. After clicking the button to the right of the Contact field on the Add Booking screen, the following screen will appear:
You can view information for any of the existing contacts by clicking on the Contact name pull-down list and selecting a contact. To add a new contact press the New contact button. The fields will clear, allowing you to enter the contact information. First enter a unique contact name in the Contact name field. After exiting this field the Save contact button will appear. Enter any other contact information and press the Save contact button to save the new contact.
To edit an existing contact choose the desired contact from the Contact name pull-down list and press the Edit contact button. You will notice that the New contact button will disappear. Make your changes to the contact information and then press the Save contact button to commit the changes. After doing so the New contact button will re-appear.
Booking an entire day
To book a resource for the entire day simply select Bookings | Book for whole day from the main menu.
Deleting a Booking
To delete a booking, first click on the booking you wish to delete. The booking should turn yellow. Next either click on the delete tool button or right click the mouse and choose Delete from the pop up menu.
If the booking is a recurring event, the following screen will pop up:
If you choose the first option, only the booking on the currently selected day will be deleted. All other bookings within the recurring event will remain.
If the second option is selected the entire recurring event will be deleted.
Only an Administrator or the person who initially booked a resource may delete that booking. See also: Security
Editing a booking
To edit a booking, first click on the booking you wish to edit. The booking should turn yellow. Next either click on the edit button or right click the mouse and choose Edit from the pop up menu.
If the booking is part of a recurring event the Edit Recurring Event dialog will pop up.
If you choose the first option in the dialog, only the booking on the currently selected day will be edited. All other bookings within the recurring event will remain the same.
The edit booking screen will then pop up. This screen is virtually identical to the Add New Booking screen.
Any of the booking fields may be changed. Click on Save to save the edited booking or Cancel to discard changes.
Only an Administrator or the person who originally booked a resource may edit that booking. Superusers may edit others bookings if the Allow Superuser Edits option has been set. See also: Security, Security Options.
Bookings can also be edited to a certain extent directly from the schedule. Booking times can be changed and the entire booking can moved to other times, days or resources. To adjust a booking's time first click on it to select it. Notice the cursor changes to a four-point cross. Move the mouse cursor to the booking edge and drag to start or end time to where you want it. To move a booking just drag the entire booking to another location on the schedule.
Copying a Booking
The copy booking feature is ideal if you have several similar bookings that must be entered. You can enter the first booking and then copy it to different resources or different days.
To copy a booking, first click on the booking you wish to copy. The booking should turn yellow. Next right click the mouse and choose Copy from the pop up menu.
The copy booking screen will then pop up. This screen is virtually identical to the Add Booking screen.
Any of the booking fields may be changed. Click on Save to save the copied booking or Cancel to discard changes.
Week at a Glance
It is possible to view all the week's bookings for the selected resource. The week shown is the week that contains the date in the Date pull-down list.
To see a week at a glance choose View, Week at a Glance from the menu. The following screen should appear.
To see only the weekdays at a glance choose View, Weekdays at a Glance from the menu.
Resources at a Glance
It is possible to view the bookings for all resources on the selected day.
To see all resource bookings at a glance choose View | Resources at a Glance from the menu. The following screen should appear.
Month at a glance
It is possible to view all bookings for the current resource in the current month.
To see a resource's bookings for the month at a glance choose View | Month at a Glance from the menu. The following screen should appear.
Viewing Resource Details
To view details about the currently selected resource choose View | Resource Details from the main menu.
The following screen will then pop up:
The Capacity field indicates how many people the resource can accommodate.
The Cost field indicates the cost or rental of the booking resource.
The Security field indicates the level of security needed to book the resource.
The Category field indicates which category the resource belongs to.
The Equipment field indicates equipment that can normally be found in this meeting room.
The Contacts field lists the e-mail addresses of the people to contact when booking this resource.
Searching for Available Resource at Given Time
If you need to book a room at a particular date and time but do no care which room the booking will take place in you can search for available rooms. To conduct a search, on the main screen in the resource pull-down list choose the last option: Find Available. Now choose the date and select the start and end time. The following screen should appear:
Click on any of the resources in the list box to the left and then click the OK button. This will bring you to the Add Booking Screen where you can continue filling in the booking details. You should notice that the room you selected appears in the resource pull-down list of the Add Booking Screen.
You can also change the start and end dates, the start and end times and even enter a capacity range. Enter a capacity range to locate only those rooms that can hold the number of people you specify. Press the Search button to update the resource list to match the criteria you've entered.
Searching for bookings
To find a particular booking choose Bookings | Find Existing Booking from the main menu. The following screen will pop up:
To conduct a search enter the criteria for the search. The From and To dates specify the period in which to search for. Click the down arrow to the left of the date fields to show a calendar and select a new date.
To refine the search further you can enter text in the Topic, Notes, Contact and Attendees fields. All bookings matching these keywords or phrases in the topic or notes fields will be found.
If the Case sensitive box is checked, only bookings matching the exact case will be found.
After clicking the Find button the main scheduler window will appear and move to the first booking found that matches the search criteria. Choose Bookings | Find Next or F3 to find to the next booking matching the search criteria.
Resolving Booking Conflicts
Inevitably booking conflicts will arise. This is especially the case when using recurring events.
When a conflict arises a message will be shown. Information about the conflicting booking will be displayed at the end of the message. In this example:
the date of the booking the new booking conflicts with is shown along with what type of recurring event the booking is. Here the booking recurs on the third Friday of every month.
Searching for an available time slot
To find the next available time slot for the current resource starting on the current day, choose Bookings | Find Time Slot from the main menu. In the dialog box enter the time slot interval in the following format hh:mm. For example, to find the next available three-hour time slot enter 3:00.
To find the next available time slot press the Shift + F3 key combination or choose Bookings | Find Next Time Slot from the main menu.
Searching for an available time period
To find the next available sequence of days for the current resource starting on the current day, choose Bookings | Find Time Period from the main menu. In the dialog box enter the number of days in the period. For example, to find the next available three-day time period enter 3.
To find the next available time slot choose Bookings | Find Next Time Period from the main menu.
Requesting, Approving and Rejecting Bookings
If security has been enabled and the Require booking approval option has been set, any bookings made by ordinary users will be set to Requested status. The booking shows up in the schedule with a status of Q or Request. On requesting such a booking, the contact for the resource being booked will be sent an e-mail stating that a request has been made to book the resource at a certain date and time. Requested bookings can be approved or rejected by an Administrator or a Superuser. To approve a booking the booking must be edited to changed the status from Requested to Approved. To reject a booking the booking is merely deleted. When a requested booking has been approved or rejected, an e-mail will be sent to the booking contact person.
Schedule report
To print the current state of the schedule select View | Schedule Report from the main menu.
Frequently asked questions
Questions for users new to computers and the Internet
Questions about CyberMatrix Software
Database/Multi-user questions
Questions about Meeting Manager
Questions about Meeting Manager Client/Server
Questions about Meeting Manager Web
Common Questions about Meeting Manager
Q. Is there a way we can have certain users only able to view not edit or add meeting?
A. Yes, just enable security and set the "Login To Book" option. This effectively gives view only rights to most users.
Q. How do I input Attendees so I can use the pull-down list to select them when I go to add a booking?
A. You must populate the Contacts table in the Data Manager.
Q. When we change the name of a resource why are all the current bookings deleted? For example, if Room 42 is renamed to Room 40 all the bookings we made before hand will deleted.
A. The bookings aren't deleted, they are still booked to the old room name. See the Data Manager. If you want to change resource names, you will also have to change the resource name for all the bookings in the Bookings table.
Q. Why is it that when we want to see if there is anything at all booked for a range of time, the Any Resource feature doesn't work, i.e., nothing shows up.
A. The Any Resource feature is a way to search for available resources, it has nothing to do with the schedule display.
Q. I enabled security and now we are always asked for a password. Is there some kind of default password?
A. The default password for all security levels is "magic". To ensure you have a secure system change the passwords immediately. Write down the new passwords and store them in a secure location such as the company safe.
Q. How do we setup Meeting Manager to use the e-mail capabilities? We use Outlook for email. I notice that on the General tab of the Meeting Manager options screen, the SMTP Mail Host is named "mail".
A. Here's how to find the SMTP server using Outlook 5. From the Outlook menu choose Tools | Accounts. Select the mail tab. Click the Properties button. Click the Servers button. Use in Meeting Manager whatever is in the SMTP box.
Q. How can I change the name in the Booked By field?
A1. You can change this field using the Data Manager screen. In Data Manager choose the Bookings radio button on the left. In the grid on the right, navigate down to the record you want to change. Tap the Tab key until you get to the LoginID field. Click once to get into edit mode. Make your changes and click on another record to save the changes to that record.
A2. If you have v4 and are logged in as Administrator you can change the Booked By field from the Edit Booking screen.
Q. How can I make Meeting Manager run faster?
A. You can try the following:
1. Upgrade to v4 or higher.
2. Instead of pointing to a network install have the program installed on every user's machine with the data accessed on the server.
3. Archive old bookings frequently.
4. Set a default end date in the options section to a closer date, for example 2009/01/01.
5. If you use the Auto Refresh feature, set it higher e.g. 300 (5 minutes).
Common Questions about Meeting Manager Client/Server
Q. I install the Client/Server edition of Meeting Manager. However, when I run the client I get a 10061 error. What is wrong?
A. What this means is the client cannot connect to the server application. Ensure that the Meeting Manager Server application is running on a machine on your network and that the IP Address for that machine has been entered and saved in the server options screen. Finally, make sure that the CMMan.Ini containing this IP Address has been copied down to each of the client installs.
Q. When I attempt to install the workstation software, it comes back with a message that it cannot find the server and comes back with a local host address. What am I doing wrong?
A. You need to copy over the server's CMMan.ini file as well. This is how the client knows what the server's IP address is.
Common Questions about Meeting Manager Web
Q. Why does IIS attempt to download the CMMWeb.exe file when I put http://localhost/CMMWeb.exe into my browser?
A. You must give execute permissions to the CGI web folder (for IIS this is the scripts folder). Settings should be:
Read = yes
Execute Permissions = Scripts and Executables
Q. The icon for the "submit" button doesn't work - instead of a picture, we get the "red X".
A. Either you don't have web read permissions set for the MMFiles folder or you are missing the submit.gif file.
Q. I just installed Meeting Manager Web edition onto my NT 4.0 Workstation running PWS. Why am I getting the following error upon visiting "http://localhost/scripts/CMMWeb.exe":
Unhandled Exception: DBISAM Engine Error # 11013 Access denied to table 'D:\Inetpub\scripts\Data\archive.DAT'
A. You must give NTFS R/W access rights for the INET_USER.
Q. When I try to launch Meeting Manager Web from my browser in Windows XP, I see the browser waiting, and in Task-monitor the program runs without consuming CPU. If I cancel it after some minutes the message is "CGI application with incomplete header set". How do I fix this?
A. Set permissions to the folder where the app is running. Add user IUSR_MACHINE read/write/modify (or full control), or on a test machine simply set EVERYONE to full control. To do that simply right click on the folder (ex. c:\inetpub\wwwroot\myappfolder), properties, protection.
Q. We tested Meeting Manager Web using Microsoft's IIS web server. The first day it worked fine. The next day, we started getting CGI Timeout errors. Why is this happening?
A. IIS is not configured properly.
Q. Since the web based edition can't have multiple sites, how is it possible to have two singular sites running on the PC for the web-based edition.
A1. One way of doing it would be to have two different web servers running. One for cars and one for bookings.
A2. You could also create a separate install in a subfolder of your web servers script folder. I.e. if your web server is running in scripts\create scripts\cars and install a second copy of Meeting Manager web in there. Then in the browser just include the cars folder to access that data:
http://127.0.0.1/cgi-bin/cars/CMMWeb.exe
Q. When I run Meeting Manager Web on a Win 2003 Server with IIS6 it always throws the following message:
CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. How can I solve this?
A. Every single exe must be specifically given permission to run in IIS 6. Enabling executables in the web properties for the site is NOT enough. You have to add the specific exe to the Web Applications section.
About Meeting Manager
CyberMatrix Meeting Manager is copyright (C) 1998-2008, by CyberMatrix Corporation, Inc. All rights reserved.
Anything not explicitly allowed below is prohibited.
Please note that Meeting Manager is not free software. You may freely evaluate the trial edition for the period of 30 days. After that period; you must purchase a license to use the software from CyberMatrix or completely removed from your network and all your computers.
This software is provided "as is". In no event shall CyberMatrix be liable for any consequential, special, incidental or indirect damages of any kind arising out of the delivery, performance or use of this software. This software has been written with great care but CyberMatrix does not warrant that the software is entirely error free.
You may not attempt to reverse compile, modify, translate or disassemble the software in whole or in part.
You may freely distribute the trial edition of Meeting Manager, provided that all the files are included and are unmodified and that no files have been added to the package. Please distribute it by copying the original distribution file. You may not ask any money for the distribution.
If you want to put this application on a CD-ROM or other software compilation, please contact CyberMatrix before doing so. This is to ensure that old or incomplete files are not included in the compilation.
Administering Meeting Manager Data
Getting to know the Data manager
Viewing and Editing Table Data
Deleting records
Inserting Records
Color Coding Bookings
Meeting Manager Table Details
Viewing SQL Queries
Avoiding Database Corruption
Re-indexing Tables
Archiving Old Bookings
Backing Up Data
Restoring Data
Importing and Exporting CSV Data
Getting to know the Data Manager
The Meeting Manager program uses several data files. The Data Manager screen allows viewing and editing of all Meeting Manager data. To bring up this screen select View | Data Manager from the main menu. 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 following screen should appear:
See also: General Options
Note that in Meeting Manager Client/Server the Data Manager is only accessible from the Server application.
The Data Manager consists of three parts. The menu, the data navigation toolbar and the data view. The menu contains several data related functions. The data navigation toolbar is used to navigate through the different tables. The data view shows the data of a single table.
The Data navigator Bar
The bar at the top is the data navigator. The data navigator is for navigating the records of the current table. The first button |< will move to the first record of the current table. The second button < will move to the previous record. The third button > will move to the next record. The fourth button >| will move to the last record. The + button will add a new record. The - button will delete the current record. The button with the 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.
The Data Tabs
The data tabs show all the tables used in Meeting Manager and allow you to view and edit the data in them. See the Viewing and Editing Table Data section for more details.
Menu
The menu consists of four sections File, Search, Records and Help. See below for descriptions of the different functions found within these sections.
File
Export to CSV - Exports the current table to text (CSV) format. See also: Importing and Exporting Data in CSV Format
Import CSV File - Imports a text file in comma separated variable (CSV) format into the current table. See also: Importing and Exporting Data in CSV Format
Import Contacts from Outlook - Imports any new contacts from Microsoft Outlook. See also: Import Contacts from Outlook
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.
Re-index Table - Re-index the currently selected table. See also: Re-indexing Tables
Close - Closes the Data Manager screen.
Search Section
The Search section allows you to find records when in the detail tab view. To search for a record you must first click in or tab over to the field in which you want to search. Then choose Find from the Search menu. In the dialog that pops up, enter the text you want to search for then press the Find Next button. To find the next occurrence of that text press the Find Next button again.
Records Section
The Records section contains the following functions:
Insert - Inserts a new record above the selected record. See also: Inserting records
Delete Selected Records - Delete all the selected records. See also: Deleting records
Delete All Records - Deletes all the records in the current table.
Archive Inactive Bookings - Deletes expired bookings from Meeting Manager and saves them in the Archive table. See also: Archiving Old Bookings
Backup Data - Makes a time-stamped backup file of all tables. See also: Backing up Data
Restore Data - Replaces your existing data with the tables from a previous data backup. See also: Restoring data
Viewing and Editing Table Data
There are two ways to enter table data: form view and detail view.
Entering data in form view
To enter data by form view choose the tab corresponding to the table for which you wish to enter data. A form will appear showing all the fields in that table. The screen should look like this:
To add a new record press the + button on the data navigator bar. A blank record field will appear. Enter data in the fields and press the check mark on the data navigator bar. This saves the record changes.
Entering data in detail view
To view a table's data in detail view first choose the Detail tab. The screen should look like this:
To view the data for a table choose the table's radio button in the left box. The table's data should then appear in the grid to the right. The data may now be edited directly in the grid. After editing a record, the changes will be saved after you move off the edited record.
Currently, data from SQL queries may not be edited in this way.
You can cancel any changes you made to a record by either clicking the Cancel button (the big X) on the Database Navigator at the top of the screen or by simply hitting the ESC key.
See also: Deleting records, Inserting Records
Deleting records
To delete one or more records, select the records to delete. To select multiple records, click on the first record then hold down the [Ctrl] Key and click to select individual records or hold down the [Shift] key to select a range of records. To delete the selected records either press the [Ctrl]+[D] key combination or choose File | Delete Selected Records from the menu. To delete all the records in the current table choose File | Delete All Records from the menu.
Inserting Records
To insert a record click on the record above which you wish to insert a record. Then either press the [Ctrl]+[I] key combination or choose File | Insert Record from the menu.
Color Coding Bookings
There are many ways bookings can be color coded. You can assign a color to the booking itself, to the resource that is booked, to the booking topic or to the person who made the booking. If you have set the "Show current time" colored bar will be shown across the schedule grid indicating the current time. If you have set the "Show current items options" then the bookings taking place right now will be colored green.
Note that the color black is actually not used. Black is interpreted as having no color. By default everything starts as "black".
The different color options have a priority. The priority listing is as follows:
Booking
Resource
Topic
User
Meeting Manager Table Details
Manager has 14 tables: Archived Bookings, Audit, Bookings, Booking Topics, Categories, Contacts, Deleted Recurring Events, Equipment Bookings, Resources, Resources at a Glance, Resources, Unavailable, Status, Waiting List, Users and Security.
Archived Bookings
This table lists all the expired bookings that have been purged from the main booking table. Here are the field sizes and descriptions:
ID - Integer
Date - Date
StartTime - TimeStamp
EndTime - TimeStamp
Resource - String - 15
Description - String - 250
Contact - String - 50
Extension - String - 15
Freq - String - 10
LoginID - String - 30
Notes - String - 250
Attendees - String - 250
EndDate - Date
Equipment - String - 100
Catering - String - 100
Status - String - 1
Color - String - 1
Attendance - Integer
LastModified - TimeStamp
Chargeable - Boolean
Audit
This table maintains a log of all booking changes. Here are the field sizes and descriptions:
LoginID - String - 30
Timestamp - TimeStamp
BookingID - Integer
ChangeType - Unsigned Integer
Details - String - 250
The BookingID fields link to the corresponding ID field in the Bookings table. The ChangeType field indicates which kind of change was made: 0-add, 1-edit, 3-delete.
Bookings
This table lists all the active bookings. Here are the field sizes and descriptions:
ID - AutoInc - unique
Date - Date
StartTime - TimeStamp
EndTime - TimeStamp
Resource - String - 15
Description - String - 250
Contact - String - 50
Extension - String - 15
Freq - String - 10
LoginID - String - 30
Notes - String - 250
Attendees - String - 250
EndDate - Date
Equipment - String - 100
Catering - String - 100
Status - String - 1
Color - String - 1
Attendance - Integer
LastModified - TimeStamp
Chargeable - Boolean
The Resource field links to the Resource field in the Resources table. The Status field links to the Status field in the Status table.
The Freq field can have the following values:
s - single event.
d1 - every weekday.
d - every day.
wx-y - every x weeks. y corresponds to an 8 bit represendation of the weekdays (Sunday is 1, Monday is 2, Tuesday is 4...Saturday is 64).
mdx - every x months.
mx-y-z - the xth y of every z months. x can be first (0), second (1), third (2), fourth (3) or last (4). y corresponds to the weekday (Sunday is 1, Monday is 2,...Saturday is 7).
The Chargeable field indicates whether this booking is to be charged or not.
Booking Status
This table lists booking status codes that will show up in the booking status pull-down list in the Add Booking screen. Here are the field sizes and descriptions:
Status - String - 1 - unique
Description - String - 15
Booking Topics
This table lists all the booking topics that will show up in the booking topic pull-down list for the Add Meeting screen.
Here are the field sizes and descriptions:
Topic - String - 250 - unique
Color - Integer
Duration - Integer
The duration field indicates how long a booking with this topic will take. When the topic is chosen from the Topic pull-down list in the Add Booking screen, the end time will automatically adjust according to the duration time.
Categories
This table lists all the resource categories. The names listed in this table will show up in the Category pull-down list on the main scheduler screen. When a category from this table is chosen from this pull-down list, only the bookings of resources belonging to this category will be shown.
Here are the field sizes and descriptions:
Category - String - 15 - unique
Description - String - 20
The Category field links to the Category field in the Resources table.
Contacts
This table lists all the default booking contacts. The names listed in this table will show up in the Contact pull-down list in the Add Booking screen. When the Contact field in the Add Booking screen is double clicked, the contact's e-mail address will be queried from this table in order to e-mail the booking contact.
The e-mail addresses from this table will show up in the Attendees pop-up in the Add Booking screen.
Here are the field sizes and descriptions:
Name - String - 25 - unique
Extension - String - 25
EMail - String - 40
LoginID - String - 30
Phone - String - 15
Address1 - String - 20
Address2 - String - 20
Deleted Recurring Events
This table lists all the individually deleted bookings from a recurring event. Here are the field sizes and descriptions:
ID - Integer - unique
RecurDate - Date
The ID fields link to the corresponding ID field in the Bookings table. The RecurDate field indicates which day in the recurring event was deleted.
Equipment Bookings
This table lists all the equipment that is booked to other resources. Here are the field sizes and descriptions:
BookingID - Integer - unique
Resource - String - 15
The BookingID fields link to the corresponding ID field in the Bookings table.
Resources
This table lists all the bookable resources. Here are the field sizes and descriptions:
Resource - String - 15 - unique
Description - String - 50
Capacity - Integer
Security - String - 1
Equipment - String - 250
Cost - Currency
Category - String - 15
EmailContacts - String - 100
Color - String - 1
DefaultContact - String - 25
DefaultTopic - String - 15
Picture - Blob
Active - Boolean
The Resource field links to the Resource field in the Bookings table. The Category field links to the Category field in the Categories table. The Equipment field contains a list of equipment normally found in this room. Separate each piece of equipment with a comma.
If a resource is itself a piece of equipment, you must set the Category field to "Equipment". Only resources flagged as "Equipment" will show up in the Equipment pop-up selector in the Add Booking screen.
The DefaultContact field is used to automatically assign a contact when the resource is booked. The DefaultContact field links to the Name field in the Contacts table. The DefaultTopic field is used to automatically assign a topic when the resource is booked. The DefaultTopic field links to the Topic field in the Topics table. The Picture field stores a JPEG image of the resource. The Active field indicates whether this resource can be booked and have its schedule visible.
Resources at a Glance
This table lists all the resources that will appear when the Resources-At-A-Glance view is chosen. It contains only one field: Topic - Resource - 15. This field links to the Resource field in the Resources table.
Resources Unavailable
This table lists all the days and times resources are unavailable. Here are the field sizes and descriptions:
Resource - String - 15
Day - Integer
TimeFrom - Time
TimeTo - Time
DateFrom - Date
DateTo - Date
The Day field indicates the day the resource is not available. Sunday is 1, Monday is 2, ... and Saturday is 7. To make a resources unavailable all day long just enter a value for the Day field and leave the From and To fields blank. To make a resource unavailable for a time period every day, leave the Day field blank and enter values for the TimeFrom and TimeTo fields. To make a resources unavailable for a range of days, leave the Day, TimeFrom and TimeTo fields blank and enter date values in the DateFrom and DateTo fields.
Security
This table keeps track of all the user names and passwords used for the security features. Here are the field sizes and descriptions:
LoginID - String - 30 - unique
Password - String 10
Level - String - 1
Color - String - 1
The Level field indicates which security level the user has. The Level field can be A for administrator, S for superuser and U or blank for user. See also: Security.
Users
This table lists all the users of the software. Here are the field sizes and descriptions:
LoginID - String - 30 - unique
LastIn - TimeStamp
LastOut - TimeStamp
Waiting List
This table lists all the waiting list appointments. Here are the field sizes and descriptions:
RequestDate - Date
StartTime - TimeStamp
EndTime - TimeStamp
TimeLength - Float
Description - String - 250
Contact - String - 25
Resource - String - 15
The TimeLength field is the time in hours of the appointment. e.g. for 45 minutes you would enter 0.75 in this field. The Resource field links to the Resource field in the Resources table. The Contact field links to the Name field in the Contacts table.
Viewing SQL Queries
It is possible to view the results of simple SQL statements stored in external text files. SQL stands for Structured Query Language; it is a way to communicate with databases using English-like commands.
To create a new SQL file either create one using any text editor or choose File | New SQL File from the menu. Save the SQL file to a folder, usually the Meeting Manager Data folder.
To open a previously saved SQL file choose File | Open SQL File from the menu. A file select dialog will pop up allowing you to choose a SQL file. After selecting a file, you should see the results of the query in the data grid.
Note that currently only simple SQL Select queries are supported. Here is an example:
SELECT Resource, StartTime, EndTime
FROM Bookings
WHERE Resource = '1A' And StartTime Between TIMESTAMP '2008-03-09' And TIMESTAMP '2008-04-03'
ORDER BY StartTime
This query shows all bookings, sorted by StartTime for the resource "1A" between March 09 and April 03.
Note that when using the Order By and Group By clauses you must assign a name to the grouped by fields using the As token. Naming fields in this ways also gives the data grid columns a descriptive name.
For more information on SQL, consult a good introductory database textbook. There is also some documentation on the supported SQL calls in the database engine manual. To read this manual choose Help | DB Engine Manual from the Data Manager menu.
Executing SQL Queries
It is possible to execute simple SQL statements stored in external text files. SQL stands for Structured Query Language; it is a way to manipulate information from databases using English-like commands.
To create a new SQL file, either create one using any text editor or choose File | New SQL File from the menu. Save the SQL file to a folder, usually the Meeting Manager Data folder. Remember to save with the .SQL extension.
To open a previously saved SQL, file choose File | Open SQL File from the menu. A file select dialog will pop up allowing you to choose a SQL file. After selecting a file, the query will be executed and make changes to the database.
Here is an example of a simple SQL Update query:
UPDATE Bookings SET Resource='4D' WHERE Resource='4C'
This query will update all time records where the Resource is "4C". For these records, the Resource will be renamed to "4D".
For more information on SQL, consult a good introductory database textbook. There is also some documentation on the supported SQL calls in the database engine manual. To read this manual, choose Help | DB Engine Manual from the Data Manager menu.
Preventing Database Corruption
Note that corruption is very unlikely to occur in the client/server and web-based editions of Meeting Manager.
Meeting Manager Standard uses a local database to store its data. Unfortunately, local databases are susceptible to corruption if the computer is shut down abnormally. Corruption occurs while the program is in the middle of writing to the database and the program is prevented from completing the write. For this reason, you should always perform proper shutdowns. You should never shut off the computer or reset it while Windows is still running. Perform a proper shutdown by choosing Shut Down and either Restart or Shutdown from the start menu. If your system starts to act abnormally, try to exit Meeting Manager first and then perform a proper shutdown.
If your system appears frozen first try hitting the Ctrl + Alt + Delete key combination. This should bring up a task list. You may be able to end the task that is no longer responding. Sometimes the system will crash so hard that you cannot even bring up the task list. If this happens reset the machine and repair any corrupted Meeting Manager tables if necessary.
Note that it would be extremely rare for tables to become corrupted when using Meeting Manager C/S, Meeting Manager Enterprise or Meeting Manager Web.
See Also: Re-indexing Tables
Re-indexing Tables
Over time, one of your tables may become corrupted. This is not as bad as it sounds. When a table becomes corrupted, it just means that it requires re-indexing before it can be properly used again. See the section Avoiding Database Corruption to learn more about table corruption. Usually when a table requires re-indexing you will see an error message such as:
DBISAM Engine Error #9217 Error reading From Data File I:\MeetingManager\data\Bookings.dat
Re-indexing the table is simple. Just select the affected table in the data selector and then choose File | Re-index Table from the Data Manager menu. It does no harm to re-index a non-corrupt table.
DBSys
If you are unable to open the application to do a re-index you can get the DBSys utility. DBSys is a utility from Elevate Software, the makers of the database engine used in Meeting Manager. Use this program to re-index the affected table.
Last Resort
If after trying all these solutions you still have problems, you can zip up the problem data files and e-mail them to CyberMatrix support.
Archiving Old Bookings
After a time, the Meeting Manager program will have accumulated many old one-time meetings that are no longer useful to retain. Using the Archive Inactive Bookings function will delete these old meetings from Meeting Manager and save them in the Archive table. Occasional archiving in this manner will help to keep the Meeting Manager program running at peak efficiency.
To archive your old booking select Records | Archive Inactive Bookings from the Data Manager menu. The following dialog will appear:
You are able to choose the date range of the bookings to be archived. The date range defaults to include all inactive bookings from the last year. To archive inactive bookings within the date range press OK.
Backing up Data
To manually create a backup of your data choose Records | Backup Data from the menu in the Data Manager screen. Running this function will create a zip file in the Data\Backup folder. The zip file will have a name consisting of the current date and time the archive was completed. If you ever want to restore the data later you will need an unzip program such as WinZip. Alternatively you can use the restore feature.
See also: Restoring Data
Restoring data backups
To restore previously archived data choose Records | Restore Data from the Data Manager menu. A file select dialog will pop up allowing you to choose the archive you would like to restore.
Importing and Exporting CSV Data
Importing Data
Meeting Manager can import data in the form of comma-separated CSV files. If you have existing data from another application, this data can be imported into Meeting Manager provided it is saved in the right format. CSV files used for importing must follow the exact same format as the table into which they will be imported. That is, if you look at a table in the detail view of the Data Manager you will notice the order of the fields in the table. This is the same order that your CSV file must be in. Most spreadsheet programs like Microsoft Excel allow you to easily load in CSV file and move columns around.
See the section Meeting Manager Tables for more details on field types and sizes.
To import a CSV file first select the table you want to import into from the Data Manager. Then choose File | Import From CSV from the Data Manager menu. A wizard will guide you through importing the CSV file.
Note that when running the wizard, your import time format string must be exacty the same as what is in the CSV file. Most people leave in the .zzz in the import format string when their CSV data does not have microseconds. The import is not smart enough to determine what date/time formats you are using. You have to tell it. If the first row of your CSV file contains the field names, the field names in the header must exactly match the field names in the table you are importing into.
Exporting Data
Data can also be exported in CSV file format from Meeting Manager. This data can be imported into other applications that can handle CSV imports.
To export a CSV file first select the table to export from the Data Manager. Then choose File | Export To CSV from the menu. A file select dialog will allow you to select the CSV file to export.
Import Contacts from Outlook
Contacts from Microsoft Outlook can be imported into the Meeting Manager Contacts table. To import Outlook contacts choose FIle | Import Contacts from Outlook from the Data Manager menu. This import will only retrieve new contacts, that is contacts whose name is not already in the Contacts table. If you want these contacts updated from Outlook you will have to delete the contacts you want to update from the Contacts table. Note that the business contact information will take precedence. If there is no business contact information the home information will be used.
Installing Meeting Manager
Installing Meeting Manager Standard
Installing Meeting Manager Client/Server
Installing Meeting Manager Enterprise
Installing Meeting Manager Web
Installing Meeting Manager Standard
There are three ways Meeting Manager Standard can be installed:
On a single user's machine.
On a shared network location where the program and data is accessed by all users.
On every user's machine with only the data stored on the network.
Note: if installing this software for use by multiple people, all people must have read/write access to the Data folder on the shared drive.
Installing Meeting Manager on a single user's machine or a fully shared network location
Use the setup program to make the initial install on a local drive for a single-user. When prompted for an installation type choose the first option, Standard. The data will be stored in the user Application Data\CyberMatrix\MeetingManager folder. E.g. C:\Documents and Settings\Administrator\Application Data\CyberMatrix\MeetingManager. If you want to use a data folder in another location, you should choose the Client Only option when at the installation type selection screen. Otherwise, you will have to change the Data Path setting in the options screen.
Installing Meeting Manager on one or more machines with network-shared data
There are two ways Meeting Manager can be installed in order to share data with multiple people: fully-shared and shared-data-only. In a fully-shared setup the program and all data are installed on a shared network location. Users will use icons to access the software. To tell the program where the shared data is located you will need to either:
1) Enter the data path when you see the file missing message after trying to run the software on each client or
2) Copy over a CMMan.ini file containing the DataPath setting to each client's C:\Documents and Settings\[UserName]\Application Data\CyberMatrix\ folder.
3) Install the shared data folder in a folder called "Data" off the shared program folder. That is, if you installed Meeting Manager into a folder called I:\Shared\CMM, just install the data to I:\Shared\CMM\Data.
In a shared-data-only setup, just the data resides on a shared network location. The software and other support files reside on the user's own computer. Installing Meeting Manager in this way will generally be faster since the program executable will not always be pulled down through the network. However, installation and applying updates will involve significantly more work.
To install only the data on the network and install Meeting Manager on one or machines with network-shared data do the following:
Run the setup program on a single machine.
Choose the Data Only option when at the installation type selection screen.
Install Meeting Manager on all the machines that need to use the software. If you are sharing the entire application on the network just install to this machine.
Choose the Client Only option when at the installation type selection screen.
At the Enter Network Data Location prompt screen, enter the network data folder where you installed the data previously.
Installing Meeting Manager in this way will generally be faster since the program executable will not always be pulled down through the network. However, installation and applying updates will involve significantly more work.
Setting up the User's Workstations
In a fully shared multi-user setup, the Meeting