Open Dental

KevinRossen

I've searched the documentation page and can't find where/if the dentist name or practice title from setup>practice is stored? Is it kept in the database or somewhere else?

KevinRossen

Well, until I see that there is indeed a vulnerability in TCs encryption, I don't think it's an issue I'm going to worry about. There is a known back door into BitLocler's encryption designed for law enforcement, but it won't take long for that to get out into other's hands if it hasn't already.

KevinRossen

I'm usually not a conspiracy theory guy, but something seems fishy about this. It's out of character for the open source community to say something is not secure without elaborating on exactly what is insecure.

KevinRossen

Yup. I was happy to get a SCSI Denoptix running with Windows 7 and zero virtual machines with Dexis 10, but I think the USB version (single speed) would need.. A virtual machine, as the driver does not seem to work in Windows 7, period. Nor vista, if I recall. So we would need to use XP in a virtua...

KevinRossen

I'm guessing I'll need to order a custom query for this, but I'd like be able to export the data for A/R for the past 12 months, grouped by month. Basically I'd like to export the data to CSV so I can play with it in Excel.

Anyone have something like that? I didn't see one in the query examples.

KevinRossen

Why not add all the specialists in OD as patients. This way you will be able to email them and you have an automatic record of all the correspondences. We use the referred out stratus to do just this. I typed up a wiki page for our staff to use. Here are the steps: Chart the needed procedure as "Re...

KevinRossen

The times I've see this happen it has always been user error, buy your mileage may vary.

KevinRossen

Here's a screenshot of one of the reports I've built that's probably what you're looking for. If anyone is interested in how it's done you can PM me.

KevinRossen

A customer complained that the cursor always defaults into the Note field on an adjustment, unlike a payment, where it jumps right into the Amount field. She finds herself typing the amount into the Note field. I haven't heard this complaint before, and wonder if anyone else finds this to be annoyi...

KevinRossen

I have wished for such a function for a long time. I wish there were a way for a pop-up to occur every single time we make an appointment that would allow us to send an email (if one exists) detailing the next appointment with "add to calendar" capabilities. Essentially this is the modern day versi...

KevinRossen

Can you anyone recommend postcards for appointment reminders and birthday cards? I have been using those from Medical Arts Press. The price is great, but they look very dated. I need something more refreshing and different. Thanks. Check out PracticeMojo. They have a great integrated plan for email...

KevinRossen

This doesn't answer your question, but according to the manual: "The AgeOver18 condition is non-functional and should not be used."

KevinRossen

boboffice wrote:A nice thing to do with the large monitor is run OD twice at once.... one on each half of the screen.. lots of things you can do this way.

That's a really good idea. I'll sometimes run the program twice when generating reports. I didn't really think about the Idea of half & half screens. Good tip.

KevinRossen

I actually expanded the report to include a lot more procedures. But to make all this even better I would like to replace Pan with 3310 in the column heading and do this with all the ADA procedure codes in the report. It would be easer to read in it's expanded form. Changing the field declarations ...

KevinRossen

Almost anything is possible for sure. I think a report can be built with that information, but it would take me a little while to put that all together. I know you can order custom reports from Open Dental for a small fee. I'll look at what I have and see if there's something close to get started wi...

KevinRossen

Kevin, That is exactly what I was looking for. Thank you, drtmz You're welcome. You could also customize the report to search for other codes. Here's a modified version showing a few other recall type procedures: SET @FromDate='2013-03-01' , @ToDate='2014-02-28'; DROP TABLE IF EXISTS t1,t2; CREATE ...

KevinRossen

Need some help with a query for the number of pans, D0330, taken for a year totaled by month. Thanks drtmz Here you go: /* Count Various KPI Stats */ SET @FromDate='2013-02-01' , @ToDate='2014-01-31'; DROP TABLE IF EXISTS t1,t2; CREATE TABLE t1(Month VARCHAR(10) NOT NULL, PanX DOUBLE NOT NULL); /* ...

KevinRossen

We have been using Open Dental since 09/2010. Is the Supply Inventory section something that is worth utilizing? Our dental supply staff member uses sticky notes and a clip board and seems to perform her task well. Thoughts, opinions please.... Thanks, Gene Brabston I'm using it and I like it. Defi...

KevinRossen

Kevin, that is EXACTLY what I was looking for! I was working on a very similar setup, except your query groups procedures, combines the three date ranges (we use last week/3weeks/3 months), shows next appt, is in general much more elegant. Thank you so much!!! steve The other step that I do for thi...

KevinRossen

Here's a report I made that sounds similar to what you're looking to do. It pulls unscheduled treatment based on three time ranges: 2 weeks ago, 8 weeks ago, and 18 weeks ago. It's setup relative to the day it's run and you don't have to change the dates. I run it every Monday morning. It only finds...

KevinRossen

You may be over-thinking the situation here. The only time the morning huddle information is useful is on the day of the huddle. No need for a change of dates capacity as the information in the appointments may change between the time you print the report and the time of the actual huddle. It is a ...

KevinRossen

Scenario: A patient arrives, a staff member highlights that patient's status as having arrived. That patient's name now appears in the "Waiting Room", with the "Waited" timer timing. But, oops, the staff member misidentified the patient, and therfore has erroneously enteedr the wrong patient as hav...

KevinRossen

I changed this line, WHERE DATE(a.AptDateTime) = CURDATE()+1 AND AptStatus=1 and it worked for tomorrow. drtmz Ah, thanks. That actually helped me reevaluate my code. I left out the quotations around the date when I was using the SET function. I've got the updated code below still using the current...

KevinRossen

...would be if I could figure out how to set it for a future date (the next day, for example) MySQL's ADDDATE method is pretty sweet. I bet you could use it: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_adddate I started trying out using the SET @FromDate=2014-02-26 ...

KevinRossen

After fine-tuning and tweaking various reports, I've finally put together a report that I'm very happy with for our morning huddles. It lists the current day's scheduled appointments with the following info: Op, Apt Time, shows "NP" if they're a new patient, the patient's name, Age, the family's bal...

KevinRossen

Hersheydmd wrote:I also noted that they stay in the Outbox for a while. I could be wrong, but I have the impression that they stay there until the recipient reads it. I think they are actually sent, even though they stay in the Outbox.

Ah, ok. I guess that makes sense.

KevinRossen

I have three messages that I've tried to send from the private messages on this forum, but they're stuck in the outbox. Is anyone else having this problem?

KevinRossen

Out of curiosity, if the procedure code never appeared in the procedurelog, would anything happen to the Open Dental program if you deleted the code using a MySQL query? I know that's frowned upon, but was wondering what would happen?

KevinRossen

How long is does it take to get an approval or a denial? Per http://opendental.com/manual/featurerequests.html : 10/29/2013 - Feature Request Status We encourage our customers to continue to submit feature requests, and we look forward to continuing to integrate many of the great suggestions into O...

KevinRossen

Anyway to run the production report without the scheduled entity? I just learned that any apps that were not set complete are altering my production reports. I like the idea of scheduled income showing up for future days but I do not see the purpose of it being there for the past. Any way have the ...

KevinRossen

Over the past month or so, I've setup an automated process for generating reports sent to me as a spreadsheet attachment. What I wanted was a daily email with the relevant numbers that I use at our team morning huddle. We track adjusted production, scheduled production, collection, new patients, and...

KevinRossen

We created a separate db for the Open Dental mobile app. However, the patient portal app that we created uses the same database as what the full application talks to. Could you elaborate a little on these two databases? Are they hosted on the practice server or OD? How are they secured? If this inf...

KevinRossen

Thanks for the feedback. I'm still researching what I'm wanting to do, so your thoughts are very helpful.

KevinRossen

To my knowledge, as long as the SSL connection is FIPS compliant (uses TLS 1.2) then it's secure enough for HIPAA. At least that is what the ONC has as their requirement for EHR softwares and they better be HIPAA compliant otherwise I've got a bone to pick with them. :? I'm looking into setting up ...

KevinRossen

So, what you're saying is Open Dental can do anything, right?

KevinRossen

My initial thoughts are that scenario A is possible with a few caveats. The biggest problem I can see has to do with Primary Keys in the procedurelog. I'm by no means an expert on how the database is structured, but I do understand that EVERY procedure gets a unique key, which I assume goes in numer...

KevinRossen

What is the best interface for the staff to access the wiki page? By just going to tools --> wiki or is there some other way as I dont want them to change it. The only way I know is through Tools > Wiki. It tracks changes and keeps old versions of pages, so you don't really need to worry about staf...

KevinRossen

bump to the top.. any updates? I really would like to be able to sync my open dental with google calendar. Or at least have that option. I have an idea on how to do it, but not completely sure how to automate it. You can create MySQL queries that save to csv (spreadsheet) files. You can then update...

KevinRossen

How do you setup a wiki page with links and user names for each of your logins? Starting in version 13.1 it's built right into the software under Tools > Wiki. Check out Open Dental's documentation on how it works. It's pretty easy to use after you understand the layout of the editing page. Here's ...

KevinRossen

In Texas we have a service called Insurance Answers Plus which gives an extremely detailed report on group plans for employers with 50 or more employees. It's incredibly useful. We also use ClaimX for our claims, which has an electronic eligibility request feature that works pretty well (when we use...

KevinRossen

I figured it out. I left of the WHERE clause when joining t1 & t2 together. Here is the query that works: SET @FromDate='2014-01-01' , @ToDate='2014-01-31'; DROP TABLE IF EXISTS t1,t2; CREATE TABLE t1( Date date, Seen int NOT NULL DEFAULT 0, Sched int NOT NULL DEFAULT 0, Rate CHAR(4) NOT NULL DEFAUL...

KevinRossen

irfan wrote:currently the route slips since that's my current project. Also had this frustration with treatment finder though.

Are you using the default route slip? I made a custom one that shows all unscheduled treatment.

KevinRossen

We aren't using planned appointments yet, but I'm planning on utilizing it for scheduling purposes soon.

Is your main frustration with reports and route slips in regards to them? Or finding unscheduled treatment in general?

KevinRossen

One of the metrics we track in our morning huddles is our reappointment rate. It's simply the % of patients we saw in a given day who left the office with an appointment of any kind scheduled in the future. Here's the query, which works as expected, I've built based on a single date: SET @DateDone='...

KevinRossen

Did run this query on our results for 2013. Problem is $DrProd, $DRDay and $DRHr columns were all '0' . It basically gives all the production and collections to hygiene. Is it something in the query or the way we have things coded internally? I am able to differentiate dr and hyg production in othe...

KevinRossen

Here's an update. I was able to pour through a bunch of different resources over the past couple months and figure out a lot of how MySQL queries work. I was able to build a query that gives me exactly what I'm looking for. The report for my practice is very specific to us, but I figured the main id...

KevinRossen

My "server" is only another desktop I built myself for a dedicated server, so unlikely it has tpm. TPM looks to be proprietary to intel? My dedicated server is an amd based box. What does tpm do with bitlocker? I was under the assumption I could just use bitlocker with any box with win8 pro. I just...

KevinRossen

The more I've read, I think I'm going to just get Win8.1 pro and use bitlocker to encrypt the mysql and A-Z folders. I have to upgrade my server from xp anyway, so this will kill two birds with one stone. As long as your server has a Trusted Platform Module BitLocker is the easiest way to go. I've ...

KevinRossen

fishdrzig wrote:Where do you find these numbered reports in OD??

http://opendentalsoft.com:1942/ODQueryL ... yList.aspx

KevinRossen

How can I run a report in OD to show me the number or % of patients without insurance coverage and/or with insurance that I do not par with? Thanks If you're a PPO office this one might help, too: /*317 Show count of active patients using each fee schedule whether through primary insurance, patient...

KevinRossen

How can I run a report in OD to show me the number or % of patients without insurance coverage and/or with insurance that I do not par with? Thanks Query example #69 looks like it might get you part way there: /*69 Count of patients by Carrier with procedures completed in date range*/ SET @FromDate...

KevinRossen

There are a lot of variables based on how your network is setup. If it's a network share that's on a domain you should be able to limit access to the folder to only users on your domain. If it's a basic Windows share you'll have to set other safeguards. One of the most secure ways to lock down your ...

KevinRossen

My initial guess is that your query using SUM( HOUR ... it's probably just not considering MINUTES. That's exactly what it was. I got the code from Query Example #640. Below is the code that I came up with that does what I need it to do, rounded to 1 decimal point (to account for half hours). SET @...

KevinRossen

I'm having an issue trying to calculate the number of hours worked for our providers. We don't use the timecard (our providers are paid salary), but I do have the schedule setup with individual providers' schedules. We stagger our lunches, so one provider may have a lunch break starting at say 12:20...

KevinRossen

I am surprised you removed the code. Considering that this is in Advanced Topics, you should be more trusting of the members who use this forum. I understand the concern that someone who doesn't know what they are doing can get in trouble. But that shouldn't stop everyone else from benefiting. An a...

KevinRossen

I'm having an internal battle over removing your post. Running update, insert, or delete statements on any database should absolutely never be encouraged... I removed the code from my post just to be safe. I've only done it a few times after watching Spike from conversions work his magic. I ALWAYS ...

KevinRossen

I'll add a hint. When setting up the medication list, I wish I would have paid better attention when entering the generic names and brand names. Entering generic with lowercase and Brand with uppercase would have been better (atorvastatin and Lipitor). The same goes for correct spelling of meds. On...

KevinRossen

But my main question is having the Syncback Pro run every 15 minutes, does it in anyway compromise the main server data base? I was thinking not but wanted to be sure. Thanks for the help. As mentioned above there will be occasions when not everything will be backed up, but most often everything sh...

KevinRossen

Are you all using CrashPlan's cloud-based backup? If so, are you only backing up the MySQL database? How are you handling images and x-rays? My experience with cloud-based backups is that they work fine for the data, but the images and x-rays are another story. When you would need to restore those f...

KevinRossen

From my experience, the reason you turn off MySQL on the backup server is to make sure the backups are copied properly. I don't think the files would copy properly to the backup server if it's still running there.

KevinRossen

Kevin, that is a really awesome report. Tremendous amount of information all in one place. What do you do with all that information? BTW, have you looked at the graphical dashboard in OD? It has everything I'm looking for. I find it easier to look at than a spreadsheet of numbers. It shows you tren...

KevinRossen

Ok, I have been doing some reading and can't we just upgrade a computer to Windows Ultimate 7 or 8 and enable encryption of all the patient data that way, rather than installing a third party encryption software program? You can encrypt a whole drive with TrueCrypt or BitLocker (Windows' built-in t...

KevinRossen

That always seems to be the simple route when wanting seemingly unrelated data to show all at once. We offer a service here at HQ for writing all kinds of complex queries for $90 an hour. You can always give us a call and put in a query request and get a quote on how hard our query department deems...

KevinRossen

Good luck. Typically when people try to make "one query to rule them all" they get so complicated that the data results never really seem to be quite right. If you ever need help trying to figure out where to grab data from or what tables to join together, I'll be able to help you in that aspect. O...

KevinRossen

Hi Everyone, We are recent converts to Open Dental (as of Nov 1, 2013). I had a report that I made in our old software PracticeWorks that pulled together a number of different types of data to create one nice report with a bunch of different metrics that I like to track each year. Here's what the fi...

KevinRossen

exactly. I know it can be done. weave system is a voip hosted asterisk. I use the same phones they use and they told me because my phones are not "programed" to work with their pbx they would not reprogram my phone and I would need to purchase new phones. Their system is not integrated with open de...

KevinRossen

weave is not integrated to the level im looking for and its an asterisk box that uses voip. im looking for a dialer HUD interface that pulls in information from open dental and writes notes back to the com log What are you currently using for phones? We have an asterisk-based FreePBX system with de...

KevinRossen

I used to do many of these....then I contacted a company (well known) that set me up with a back up of my server and offsite back up. I don't have to rotate drives, take anything home, worry about taking encrypted data with me anywhere, etc. If something goes down, I have a fireproof onsite back up...

KevinRossen

Since we allow storing phone numbers in practically any format, I'd recommend trying to use a regular expression in your query if you start running into odd problems with not finding matching phone numbers etc. http://dev.mysql.com/doc/refman/5.1/en/regexp.html I looked into regular expressions, bu...

KevinRossen

Does any know of any applications or plug ins for OD that can send you a text message for certain "events" throughout the day from OD a program link? Would be great for a doc with 2 offices Anything? I have strong feeling this can be easily achieved but wouldn't know who to ask or where to start wi...

KevinRossen

Well, I got a start at it this weekend being iced in the house here in Dallas. I'm on a FreePBX system, which is really easy to setup. I have a dedicated computer for the phone server and there's an option to setup a Caller ID lookup source via MySQL. So far, I'm querying the Open Dental database to...

KevinRossen

Are you guys connecting your existing phone system to some internet phone system such that when call comes in.. the internet phone software queries the OD database, pulls all the relevant customer record and displays it on the computer screen for front desk receptionist? If so what are you success ...

KevinRossen

We use a separate spreadsheet to enter treatment and payment options. It's something I modified from Breakaway Seminars, so I can't really share the document. It's much easier to use that and only takes about 2-3 minutes to enter info and print.

KevinRossen

I'll do my best to answer each of your questions based on my experiences: 1)Can you still back up the entire encrypted hard drive? Yes. An encrypted drive functions in Windows exactly the same as a normal drive in regards to features. The only difference might be how you handle "mounting" the drive....

KevinRossen

Maybe all my other questions should be posted to Dental Town to get more insight on the encryption process for the computer or encrypted hard drives. But I hope someone from OpenDental can answer at least this question: Can OpenDental simply create an encryption of the Open Dental Data folders? Is ...

KevinRossen

I've had experience with the virus. The only way you're safe is if you have backups offsite that are not attached to your server or network. The best course of action is to have three external hard drives that you rotate daily. As long as you don't have two drives attached at the same time you shoul...

KevinRossen

No matter how much backup you have, there is always the perfect storm that can over come all of your protective measures. The idea is to have so much protection that it would take a mighty big storm to overcome all of your protection. For KevinRossen I say good job sir. Keep it up! Thanks for the f...

KevinRossen

I agree with the above that more than 1 backup strategy is essential!!! We had a server crash last year and lost about 4 months of data (we were running a different software at that time). We had a backup strategy in place . . . or so we thought. We didn't ever test out a restore/recovery of our dat...

KevinRossen

I had a feeling that was the case. Thanks for the reply. Feature request submitted.

KevinRossen

I haven't been able to find an option or code to sort the print order of the routing slips. By default it prints only by appointment time. I'd like to first order it by ops, then appointment time. Is there a code I can add to the sheet to make that happen?

KevinRossen

Take a look at this article. it covers most of the basics of what you are asking:
http://opendental.com/manual/networksecurity.html

KevinRossen

Sorry if this is annoying but I found this to be an obvious problem some people had in the past. Did you actually highlight and select one of the options in the numbered list of Available Graphics Formats at the bottom of the Graphics window? I found that working your way down that list is often th...

KevinRossen

I'd like to see something like this, too. Does anyone have a report they have created?

KevinRossen

Well, we are going live on Monday with Open Dental, so I'm finishing up getting everything set the way we want. Just an update that I got one of OP computers working with DirectX, but I don't remember what exactly made that happen. I know I'll figure it out, but for the life of me I don't know what ...

KevinRossen

bpcomp wrote:"Access denied."

No dice yet.

Ugh. Stupid Evernote permissions. I've moved the photos to my webhost, so they SHOULD be viewable now.

KevinRossen

bpcomp wrote:Your screenshots require us to log in to our Evernote account (which I don't have). Could you please share the screen shots a different way?

Sorry about that. I've fixed the images to where they should be viewable now.

KevinRossen

Ok, I've double checked on a second computer going through all the steps and I'm still not able to get the DirectX chart to work. I've tried updating the graphics driver, the DirectX end user softer, the SDK, etc, all in the suggested order. I'm still not able to get that graphics option to work, wh...

KevinRossen

FYI, I'm still double-checking that I'm having the problem on different computers following the above steps. So far I'm not able to get DirectX to work, which seems to only affect the perio chart. Not a huge deal, but we'd like to use that view as a patient education tool for our perio patients.

KevinRossen

Yes, I have gone through the steps. I'll try it another time, just curious if maybe DirectX 11 is more finicky than 9.

KevinRossen

Hi Everyone, I have video cards in all of our ops that support DirectX 11. I've attempted to upgrade the driver and the DirectX software, but I'm still not able to use the graphical perio chart. The posts that I've read seem to be consistent in that users that are having problems with the graphical ...

KevinRossen

We use Lighthouse 360 and absolutely love it. We were with Smile Reminder / SolutionReach, but had some problems with it. The support at Lighthouse is phenomenal and our patients love it!

http://www.lh360.com/

KevinRossen

Hi, I am in the process of evaluating OD. Would be switching from PracticeWorks. We have done the test conversion and I've found most of the data will translate smoothly. There are two features, however, in the PW appointment book that I don't see as options (yet) in Open Dental that we currently us...

KevinRossen

Hi Aussie, I'm not (yet) a user of OpenDental, but I would imagine you could build a query to accomplish what you're wanting to do. Check out the list of 600+ example queries at the link below. Example #78 might be close to what you're wanting: http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx

Search found 293 matches