Open Dental Forum

OK, thanks, Jason.

Is it possible to see the source code of the sql queries on the standard report screen? I'd like to modify some of them as user queries.

We ran servers on Ubuntu for several years. When OD went with a newer version of Mysql Ubuntu did not upgrade for a while so we had to go to Win7 servers. We gained significant aggravation and annoyance for our trouble.

We run two identical rack servers. Each is RAID 5 with 6 hard drives. The production server backs up to the other nightly and also to a muscular work station elsewhere in the office. Both rack servers are Linux running character based only with MySQL. The images files are shared to workstations with...

When adding a drug for a patient it is very easy to click on the Lexicomp box. It is very annoying to have a browser fire up when adding a long list of meds for a patient. It is somewhat aggravating to have to enter each drug one-at-a-time anyway. Can this box be moved to the other side at the top s...

New Mexico has taxed all medical services for years and food as well. It is cleverly called Gross Receipts Tax. The problem is that insurance companies will not cover tax so it is embedded into the fees. I use a simple query to calculate what gets sent to the governor monthly.

It would be a big help to me to have a referral familiar name field on the referral sheet. It would need a field added to the table, though.

The sheets feature isn't difficult to program and is quite flexible. With an additional few fields out of the database there would not have to be any editing for routine automatic letters. One downside, though, on a letter that has a lot of hand entered text, there is no spell check. I prefer to hav...

Sure, there are queries to identify the number of referrals and the income from each referral. I can send screen shots of the sheets setup for some of the letters we use. I'm not sure how to export the actual setup of a sheet.

I've been using OD in my perio practice for a couple of years. Most parts work well for us. The letters to referring docs is still sort of primitive. I've a number of semi-automatic letters in the sheets format and they work OK with some minor editing. It would smooth out a lot once the referring do...

Although reinstalling from the older Setup.exe allowed normal operation from the update workstation, Open Dental on the other workstations will not now start with the reason that there is an update running on the "update workstation". Unfortunately that one is in the basement. How to I get the other...

I tried to update from 6.7.30 to 6.8.32 in the usual way. The download went normally and the database update did as well. When restarting the program I got the following message: Unhandled exception has occurred......... Access to path BatchcheckServiceStatus.bat is denied. I had to rename the backu...

I noticed when a sheets letter is posted to the progress notes, the letter type is posted instead of the letter description. For referral letters we have 17 different ones. It would be good to have the letter description posted so it would not be necessary to open each one to see what letter was sen...

Is there a place to see the code for the queries on the report page without wading through all the source code? I am particularly interested in the payments report. New Mexico has sales tax on medical treatment but not all payments. I need only totals for PayTypes with two PayTypes combined in one a...

A followup on this. The prescription sheet will allow a reprint. We are using a custom prescription sheet as well a custom letter to referral sheet. Trying to reprint the custom letter to referral crashes Open Dental. It does it on all the workstations.

I'm using version 6.3.8.0 When trying to print a second copy of a letter to a referral sometime after printing the first copy. I am getting a unhandled exception crash. The detail of the error is: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog...

I've been somewhat frustrated with this as well. The field does not seem to grow at all. Say if you put 5 lines in the setup and type 7 lines, the field does not grow but only scrolls and the last two lines do not print. If you put 10 lines in the setup and only need to type 2 lines then there is a ...

It could have been doing this on previous versions. Most of the letters are short and may not have exceeded the 7 lines I had on the notes window. I suppose the notes window could be made much taller but then the "sincerely" would be at the very bottom and look odd if there were only a few lines of ...

I just upgraded to 6.0.11.0. Now the sheet function for referral slip will only print the first few lines that are visible on the entry form. If the entry exceeds that number of lines and has to scroll, the subsequent lines do not print. It does not matter to what printer it is sent.

I've been on OD for 18 months and it is a great product. The correspondence features are weak for specialty offices, though. I'm a periodontist and about 20% of my time is dealing with correspondence with referring offices. The quick notes aren't much help as each letter is pretty much unique and ar...

Hmmm. I did not notice the update made all previously entered scripts controlled. Thanks

I've noticed after upgrading to 5.9.9 that the printer for prescriptions defaults to the windows default printer even though a different printer is selected as prescription default. I have not tried any of the other printers like postcards or such.

Ours is a perio office and we do a LOT of correspondence to the referring offices. The letters feature is good but I usually have to edit each letter with particulars about the case. If these could be saved to A-Z when printing, we would not have to print, copy and place in the paper file -or more c...

I got it working OK by mounting the server A-Z directory on the workstation with nfs.

I noticed a choice to put the images in the database. I have liked the idea of having everything in one place. Backup size does not seem to be critical to me. Are there any other negatives to this? It would solve the connection of the Linux workstations to images a lot easier.

Hmmmm. Spoke too soon.

I got it sorted out. Thanks for the suggestions.

I saw that. It does seem best to connect to the production A-Z on the actual server though.

The IP address worked fine on the connection to the database. The images folder did not seem to work. I had to assign the images folder on the local Linux workstation but it changed it for the other (Window) workstations. What is the format for specifying the images file on the Linux server? Samba i...

I have an Ubuntu workstation configured and have mono running OK using Justin Shaefer's suggestions. I get Opendental going up to the database chooser screen. At that point I get the "cannot connect to the specified database server" message. Does the format for the database server need to be differe...

I'm trying to get OD 5.1.22 to run on Ubuntu 7.10. Mono 1.2.4 came preloaded on the image I installed. I installed MySQL and copied the OpenDental directory from a working Windows workstation to /usr/local/bin. With the command mono /usr/local/bin/opendental/OpenDental.exe I get: ** (OpenDental.exe:...

I just updated to 5.1.22 and I sort of remember some traffic about turning the pop up balloons on the scheduler off on some of the workstations. The ladies up from like them but we find them annoying in the back. I can't find where to deselect them. Thanks