Note: This section applies only to existing
Canada customers or developers.
Import Claim Form
If you are already using DentOffice and wish to add the Canadian claim form, use this file: CanadianClaimForm.xml. After downloading it, go to Setup, Claim Forms (Claim Forms) and import it. You will also need to place the background gif into your A to Z Folder as described in Install Database below.
To download the new claim form background use this file: Canada.zip. It also includes a version 6.8.39 database should you need it.
Install Database
- Right click on the Canada.zip link and select Save Target As[...]. Save the file to a new folder on your C drive or on your desktop.
- Right click on the file and select Extract All to unzip it. It will contain a database folder as well as the claim form image.
- Stop the MySQL service: Right click My Computer, Manage, Services and Applications, Services, then look for MySQL in the list. Highlight it, and stop the service.
- Rename the old database at C:\mysql\data\DentOffice\. For example, rename the DentOffice folder to something meaningful like DentOfficeoldusa or DentOffice_2009_11_30. Now there should not be a folder named DentOffice in C:\mysql\data\.
- Copy the downloaded database folder called canada into C:\mysql\data\, and rename it to DentOffice. Now, when you open C:\mysql\data\DentOffice\, you should see about 500 files, starting with account.frm, account.MYD, etc.
- Copy the claim form gif into C:\DentOfficeData\. When you open C:\DentOfficeData\, you should see all 26 A-Z folders, the gif you just added, and a few other files and folders.
- Restart the MySQL service.
- Run DentOffice.
Changes to the Database
This is a list of changes that we will make to the posted database. Until we make the changes, new users will make these changes themselves.
- Insurance Categories have better defaults.
- At least one provider should be entered and should have a fee schedule assigned.
- Practice setup set to use that provider.
- Verify that IsProsth is set for all crowns, bridges, ortho appliances, and dentures.
- Shorten procedure descriptions and abbreviations.