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\usera\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 files that end in .EDB (i.e. *.EDB*).
To find out what is locking the file your can use Process Explorer. Go to Find > Find Handle or DLL. In the "Handle or DLL substring:" text box, type the path to the file (e.g. "C:\path\to\file.txt") and click "Search". All processes which have an open handle to that file should be listed.
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.
Q. Q1. When I Start Program X why does the following error message appear:
ElevateDB Error #601 The table Users is corrupt
Q2. When I Start Program X why does the following error message appear:
DBISAM Engine Error #9217 Error reading From Data File C:\Program Files\Cyber App\data\ATable.dat
A. This is a database corruption error and it sounds worse than it is.
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
(or File | Repair table).
There is a video available that shows how to do a backup and repair. Click here.
If after trying all these solutions you still have problems, you can
zip up the data files and e-mail them to CyberMatrix. We'll repair them
and send them back.
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. You need to get everyone off the system (shutdown their machines if necessary) and try re-indexing again.
Q. How can I backup the data in your software?
A. All CyberMatrix software that uses shared data folders, (Pro Schedule Standard, Meeting Manager Standard, Timesheets Standard, Project Clock Standard/Pro, Employee Project Clock, Class Scheduler, Employee Scheduler, In Out Scheduler and Point Of Sale) have a backup feature in the Data Manager. To backup your software simply choose Records | Backup data from the Data Manager menu.
If you are using a Client/Server, Enterprise or Web edition, You will have to use third party software such as Microsoft's included backup software.
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 database 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. For non-Enterprise editions, 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 v4+, Point Of Sale, Project Clock v5.10+, Pro Schedule v3+, Timesheets) we have an ODBC driver available. See: ODBC
A2. For older versions of our software there is an ODBC driver available that others have used to access database tables from Crystal Reports. Click here to download
. We do not offer any support for this older driver.
Q. Where can I learn how to use SQL?
Q. I have a single license for Program X. I logged in as someone else, 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 copy 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 (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.