Search found 306 matches

by bpcomp
Thu May 24, 2018 7:18 am
Forum: Plug-ins
Topic: *Syncthing* FREE PC to PC sync between multiple offices
Replies: 5
Views: 4952

Re: *Syncthing* FREE PC to PC sync between multiple offices

And the Open Dental data comes through OK? I just know that there are issues with trying to backup a live database and I'm surprised that this would work on a live database.
by bpcomp
Wed May 23, 2018 8:30 am
Forum: Plug-ins
Topic: Patient appointment QR code
Replies: 3
Views: 2113

Patient appointment QR code

So I do not have the programming skill to make this happen, but I know all the parts exist and it could be done. My idea is that you could click on an appointment and your plugin would be able to create a QR code for that appointment which you could display on a kiosk for the patient or be able to p...
by bpcomp
Wed May 23, 2018 7:48 am
Forum: Plug-ins
Topic: *Syncthing* FREE PC to PC sync between multiple offices
Replies: 5
Views: 4952

Re: *Syncthing* FREE PC to PC sync between multiple offices

Looks like this handles the A-Z folder. How do you handle the database?
by bpcomp
Tue May 22, 2018 11:54 am
Forum: Sharing
Topic: Automation
Replies: 6
Views: 8032

Re: Automation

We use it every day. The main thing is it helps us in the front office to save time typing. I can type "lmn" and hit space, autohotkey will expand that shortcut to "Left message for next day reminder." I can hit control + shift + s and autohotkey will focus OpenDental and then click on the select pa...
by bpcomp
Tue May 15, 2018 7:29 am
Forum: Sharing
Topic: Automation
Replies: 6
Views: 8032

Re: Automation

I'm sure it could, you would just have to write the script that performs the actions.
by bpcomp
Fri Mar 30, 2018 2:39 pm
Forum: Advanced Topics
Topic: TLS versions and DB engines
Replies: 7
Views: 4930

Re: TLS versions and DB engines

Using a computer with XP on it for patient data is a HIPAA violation. A vulnerability could be discovered and XP does not receive updates to address new vulnerabilities so it puts you in violation territory. This is also going to be true for Windows 7 and Server 2008 as of January 14, 2020 when they...
by bpcomp
Mon Mar 19, 2018 11:45 am
Forum: Main Forum
Topic: Dr. Old and Dr. Young
Replies: 2
Views: 1760

Re: Dr. Old and Dr. Young

http://www.opendental.com/manual/conversionsmerge.html

As far as I know, there is no tool or functionality that would allow for doing it yourself.
by bpcomp
Fri Feb 16, 2018 1:26 pm
Forum: Main Forum
Topic: Advanced features- what are your favorites?
Replies: 6
Views: 3591

Re: Advanced features- what are your favorites?

I'll throw in a shout out for the built in wiki. We use it for documenting all kinds of things.
by bpcomp
Wed Feb 14, 2018 4:06 pm
Forum: Advanced Topics
Topic: Stability of OD in virtualized environments
Replies: 9
Views: 4003

Re: Stability of OD in virtualized environments

Yeah, we have no issue with our USB intraoral cameras, it's the Schick USB sensor that gives us problems.
by bpcomp
Wed Feb 14, 2018 11:52 am
Forum: Main Forum
Topic: Advanced features- what are your favorites?
Replies: 6
Views: 3591

Re: Advanced features- what are your favorites?

We have all our main referrals as sheets. We can print a referral to Dr Badgums on their referral slip, and it's saved in the patient's chart. No need to scan it in. We use the patient portal to send secure communications to other offices. Make a patient for Dr Orthodude and send secure webmail ever...
by bpcomp
Tue Feb 13, 2018 7:27 am
Forum: Advanced Topics
Topic: Stability of OD in virtualized environments
Replies: 9
Views: 4003

Re: Stability of OD in virtualized environments

Totally agree about the USB stability. The main reason I virtualize the workstations is that it makes recovery SO much easier and faster. If I can copy the VM over the network and then boot with domain joined and everything fully configured, I can have any workstation in the office back up and runni...
by bpcomp
Thu Feb 08, 2018 4:13 pm
Forum: Main Forum
Topic: Warning of inactive pation
Replies: 6
Views: 3697

Re: Warning of inactive pation

I found something that may work for you. If you have a billing type for inactive patients, then you can create an automation that will give a pop-up anytime a patient with the billing status of inactive is selected. This would require you to go through and set all your inactive patients to have the ...
by bpcomp
Wed Feb 07, 2018 1:43 pm
Forum: Advanced Topics
Topic: Stability of OD in virtualized environments
Replies: 9
Views: 4003

Re: Stability of OD in virtualized environments

Lots of good questions. When I say that Windows can't talk to Linux, I don't mean networking, I mean file systems. Unless you install something in windows to allow it to read an EXT4 file system, then Windows can not natively read a Linux hard disk. If the disk can not be read by Windows, it can not...
by bpcomp
Tue Feb 06, 2018 3:58 pm
Forum: Advanced Topics
Topic: Stability of OD in virtualized environments
Replies: 9
Views: 4003

Re: Stability of OD in virtualized environments

We've been running the server and workstations in our office as virtual machines with VMware Workstation and Player for 5 or 6 years. We run Linux as a host and Windows as the guest. The specific virtualization issues I've had have been problems with USB based xrays working in the VM. Those were hit...
by bpcomp
Tue Jan 23, 2018 2:04 pm
Forum: Main Forum
Topic: Multiple copies of OD on same workstation?
Replies: 5
Views: 2685

Re: Multiple copies of OD on same workstation?

I run multiple copies whenever I'm stuck one screen (entering long note, etc) and then need to look up another patient really quickly (phone call comes in).
by bpcomp
Tue Jan 23, 2018 11:57 am
Forum: Main Forum
Topic: Dentrix vs. Open Dental
Replies: 16
Views: 19303

Re: Dentrix vs. Open Dental

The Prolom software appears to be Czech in origin. I have a lot of questions about it. Is it a 300 € site licence or per computer? How does support work? I would need English support, but what language is tech support in? Because the interface is in a different language, it's hard to tell from the v...
by bpcomp
Thu Jan 18, 2018 1:48 pm
Forum: Main Forum
Topic: File path too long to copy
Replies: 7
Views: 6098

Re: File path too long to copy

Glad you got it resolved. Good luck with the rest of your migration!
by bpcomp
Thu Jan 18, 2018 10:34 am
Forum: Main Forum
Topic: File path too long to copy
Replies: 7
Views: 6098

Re: File path too long to copy

Sounds like you are getting out just in time. Copy what you can out of the images folder and then trace which file(s) is giving you the error. If it is just an image for John Doe, try to see if you have a copy of that one file on an older backup and replace just the one file on the new server. If th...
by bpcomp
Thu Jan 18, 2018 10:13 am
Forum: Main Forum
Topic: File path too long to copy
Replies: 7
Views: 6098

Re: File path too long to copy

So you are getting the error on the new server? You should definitely run some disk health utilities and make sure everything is good. If the error originated on the old server then I wouldn't stress to much about it since you are retiring that machine.
by bpcomp
Thu Jan 18, 2018 8:58 am
Forum: Main Forum
Topic: File path too long to copy
Replies: 7
Views: 6098

Re: File path too long to copy

The problem that I'm concerned about is that anytime I've come across an error like this where the file name is a bunch of random characters and is too long, there is usually an underlying disk error leading to disk failure. Please check the health of the disks on your server and see if any scans co...
by bpcomp
Tue Jan 16, 2018 9:28 am
Forum: Main Forum
Topic: Wrong patient's name on Pan
Replies: 1
Views: 824

Re: Wrong patient's name on Pan

Capture a dummy pano in the correct patients chart. Use www.gimp.org and copy the user info from the dummy pano and paste it over the patient info from the correct pano. Save to patient's chart. Gimp gives control over compression rations, file formats, etc.
by bpcomp
Tue Dec 19, 2017 11:16 am
Forum: Main Forum
Topic: Measuring endo files on images
Replies: 2
Views: 1500

Re: Measuring endo files on images

The measurement would be dependent on your sensor size and several other factors. Most xray imaging programs have measurement tools built in. I think you should look at your xray program to see if it has those features.
by bpcomp
Tue Dec 19, 2017 11:13 am
Forum: Main Forum
Topic: Thank you OD staff
Replies: 2
Views: 785

Re: Thank you OD staff

We don't write a lot of scripts in out office, maybe 1 or 2 a week. Can you please explain what makes eRx so helpful for your office?
by bpcomp
Fri Jul 21, 2017 3:31 pm
Forum: Main Forum
Topic: Looking for ideas for a better practice merge solution
Replies: 6
Views: 8848

Re: Looking for ideas for a better practice merge solution

Perhaps it wouldn't be a good fit, but what if you create a custom patient field and custom queries based on that flag. In our office I created a short call list custom patient field and then a query like SELECT p.PatNum, LEFT(WkPhone,16) AS WkPhone, LEFT(HmPhone,16) AS HmPhone, LEFT(WirelessPhone,1...
by bpcomp
Tue Jul 11, 2017 8:36 am
Forum: Main Forum
Topic: Windows 10 or 7 for new practice
Replies: 6
Views: 8020

Re: Windows 10 or 7 for new practice

Windows 7 will hit it's end of life on 01/15/2020. After that point, it will no longer be considered HIPAA compliant because it is not receiving regular security updates. You could use 7 for a couple of years and then switch to a newer OS but why go through the hassle of a conversion that you could ...
by bpcomp
Fri Jul 07, 2017 8:30 am
Forum: Main Forum
Topic: Best practices
Replies: 8
Views: 10582

Re: Best practices

We do use AHK more in the front office where I work but I've also set up things for the back office. Before OD had an option to clone previous perio charting, all the probing depths had to be entered manually. I created an AHK script that would ask how many teeth and then blast out 323 that many tim...
by bpcomp
Wed Jul 05, 2017 4:39 pm
Forum: Main Forum
Topic: Best practices
Replies: 8
Views: 10582

Re: Best practices

We use autohotkey to speed up the front office. I have keyboard shortcuts that will bring up the select patient screen, insert a date and time stamp etc etc. Here is a link to some example code I wrote. https://pastebin.com/LzgXxZ68 We really like text replacement: ::lma::Left message saying I neede...
by bpcomp
Wed May 17, 2017 1:27 pm
Forum: Main Forum
Topic: X ray system with OD
Replies: 6
Views: 9895

Re: X ray system with OD

There are a lot of things that are good about OD, it just depends on what you find important to say what is better about one program vs another. In our case, OD is better than Dentrix because it is so small and doesn't require as much computing power to run. If we had stayed with Dentrix, we would h...
by bpcomp
Thu May 11, 2017 7:45 am
Forum: Main Forum
Topic: Open Dental on a domain controller
Replies: 2
Views: 3335

Re: Open Dental on a domain controller

We have our OD and Domain controller as the same virtual server. Both domain control and OD are mission critical so if either were to go down, the office is down. It is putting all your eggs in one basket but it is also less eggs to worry about. Only one server to update, backup, etc.
by bpcomp
Fri Jan 20, 2017 10:58 am
Forum: Main Forum
Topic: Search for openings.
Replies: 1
Views: 2468

Search for openings.

Is there a way to turn off the search for openings dialog? We have multiple providers and there are too many exceptions for that screen to be of any use when scheduling. As it stands it's just something that pops up and gets in the way and we have to spend a click getting rid of it.
by bpcomp
Thu Jan 12, 2017 1:22 pm
Forum: Main Forum
Topic: OD, Win10 and PDF
Replies: 3
Views: 4582

Re: OD, Win10 and PDF

Jsalmon's solution only works if you have email setup within OpenDental and you aren't concerned about sending the referral insecurely. When we create a PDF from a referral, we have to option to "save as". The keyboard shortcut for save as is Ctrl-Shift-S. If that doesn't work and you want another w...
by bpcomp
Wed Oct 05, 2016 10:02 am
Forum: Main Forum
Topic: dummy codes?
Replies: 7
Views: 6968

Re: dummy codes?

This post makes me tempted to add some codes to our system, like an ID-10T code, but it would probably create more problems than it solves.
by bpcomp
Wed Jul 13, 2016 2:40 pm
Forum: Main Forum
Topic: Open Dental being shut down by virus scanner?
Replies: 3
Views: 3735

Re: Open Dental being shut down by virus scanner?

In almost every virus scanner, there is an option to ignore certain directories which it looks like you are going to do. We have always set our anti-virus to ignore our practice management if for no other reason than preventing slowness. We also limit the antivirus from scanning network drives. Ther...
by bpcomp
Wed Jun 22, 2016 4:54 pm
Forum: Main Forum
Topic: virtual s/w
Replies: 8
Views: 11489

Re: virtual s/w

We use a Linux host with VMWare workstation hosting Windows Server 2008 for our domain and serving up Open Dental and our imaging. I chose Linux for it's stability, low resource usage, it's free, and I'm more familiar with it. I wrote some bash scripts which handle all my backups. It mostly breaks d...
by bpcomp
Wed Jun 22, 2016 4:28 pm
Forum: Main Forum
Topic: NEED URGENT HELP FOR FINDING A FEW SPECIFIC REPORTS!!!
Replies: 3
Views: 3248

Re: NEED URGENT HELP FOR FINDING A FEW SPECIFIC REPORTS!!!

You need custom queries. Look at this page for examples http://opendentalsoft.com:1942/ODQueryL ... yList.aspx.

This page describes how to run the query http://www.opendental.com/manual/queryrun.html.

Good luck.
by bpcomp
Fri Jun 10, 2016 7:44 am
Forum: Main Forum
Topic: Backup Software Recommendations
Replies: 1
Views: 2651

Re: Backup Software Recommendations

There are several discussions throughout the forum on backups. Here is one that goes through our process.
viewtopic.php?f=1&t=5544
by bpcomp
Thu Apr 21, 2016 7:25 am
Forum: Main Forum
Topic: HW - PC Stick
Replies: 2
Views: 2567

Re: HW - PC Stick

I have not tried the PC Stick with Open Dental but one of the selling points for Open Dental is the fact that it will run on our slower and older hardware. This means we only have to replace computers as they die instead of buying all new computers just to be able to run the latest version of other ...
by bpcomp
Tue Apr 12, 2016 8:44 am
Forum: Main Forum
Topic: What should I install? Windows 7, 10 or Windows Server 2012
Replies: 11
Views: 7533

Re: What should I install? Windows 7, 10 or Windows Server

There is no defined "have to" one way for doing any HIPAA security. The way I have heard it and look at it is that if you are doing above and beyond the minimum for protecting your patient's information, if you have a breach of any kind, your penalties will be minimal or not have any penalties. For ...
by bpcomp
Tue Apr 05, 2016 4:35 pm
Forum: Main Forum
Topic: Inventory control
Replies: 3
Views: 2532

Re: Inventory control

We use the supply system built into OpenDental and it meets all of our needs. I'm not familiar with any other systems. Is there something you need that is beyond what OpenDental has built in?
by bpcomp
Mon Apr 04, 2016 8:27 am
Forum: Advanced Topics
Topic: Romexis Error
Replies: 2
Views: 5606

Re: Romexis Error

In your system root should be a file called Dimaxis.ini. This is where you edit Dimaxis and Romexis connection settings. You can usually go to start and then run and type dimaxis.ini to open the file. The usual culprit is the password. Look for this section: [ODBC] DSN=tcpip 192.xxx.xxx.xxx 1313 UID...
by bpcomp
Mon Apr 04, 2016 8:21 am
Forum: Main Forum
Topic: server died, back up works,next step
Replies: 1
Views: 1633

Re: server died, back up works,next step

Everybody is going to have their own opinion on what the "Best" way is and the short answer is whatever works best for you. I would recommend setting your server up as a virtual machine and making a copy of it every night. If your physical server goes down, you can boot the virtual server on any com...
by bpcomp
Mon Apr 04, 2016 7:22 am
Forum: Main Forum
Topic: What should I install? Windows 7, 10 or Windows Server 2012
Replies: 11
Views: 7533

Re: What should I install? Windows 7, 10 or Windows Server

A more correct answer is that it is easier to be HIPAA compliant with a server and a domain but is not specifically a requirement. A server gives the most stable and reliable network and the easiest way to set and administer your security policies on all of your computers from one place but it is no...
by bpcomp
Thu Mar 24, 2016 7:50 am
Forum: Main Forum
Topic: What should I install? Windows 7, 10 or Windows Server 2012
Replies: 11
Views: 7533

Re: What should I install? Windows 7, 10 or Windows Server

Hey vsuite, check out this site and look at the bottom of the page for the section labeled "Designating a Master Browser" http://www.quepublishing.com/articles/article.aspx?p=1247725&seqNum=4 If you don't have a Domain and just have a workgroup, I've seen the domain master browser issue wreak havoc ...
by bpcomp
Tue Mar 22, 2016 2:53 pm
Forum: Main Forum
Topic: Mapped Drives Lost when Updating Open Dental
Replies: 5
Views: 4265

Re: Mapped Drives Lost when Updating Open Dental

The most we would lose is one day of data with the crypto virus. My server is a virtual machine running on a linux host. Every night I have a script that clones our server. From then on our full server with domain and all our patient data and xrays are moved around to a backup server and then an enc...
by bpcomp
Tue Mar 22, 2016 2:39 pm
Forum: Main Forum
Topic: Patient Info Custom Fields
Replies: 4
Views: 3276

Re: Patient Info Custom Fields

If you go to the family module and look in the patient information area, your new feilds should show up there. If they don't, go to (Setup/Display Fields/ChartPatientInformation) and move "patfields" from the available column into the showing column. You can now do custom queries. SELECT * FROM patf...
by bpcomp
Tue Mar 15, 2016 1:28 pm
Forum: Main Forum
Topic: OD calendar sync with Google
Replies: 5
Views: 5741

Re: OD calendar sync with Google

Well from a technical aspect of possibility, OpenDental doesn't have a standard calendar import export function. My best guess is that you'd have to write a custom plugin but it would be possible. I'm trying to think of a work around way that doesn't involve writing a plugin from scratch. In all my ...
by bpcomp
Tue Mar 15, 2016 12:51 pm
Forum: Main Forum
Topic: How to fill out a form and look up patient info?
Replies: 7
Views: 4685

Re: How to fill out a form and look up patient info?

I did not know about the quick paste notes. Thank you for bringing them to my attention. It seems though that the limiting factor is it will work only in text boxes that support it. AutoHotKey will work anywhere on the computer.
by bpcomp
Tue Mar 15, 2016 8:45 am
Forum: Main Forum
Topic: OD calendar sync with Google
Replies: 5
Views: 5741

Re: OD calendar sync with Google

My first biggest concern is this sounds like a huge HIPAA violation. What is to prevent patient A from seeing the personal details of patient B's appointment? Open Dental offers this functionality with security for an additional fee. http://www.opendental.com/manual/fees.html It's called WebSched. W...
by bpcomp
Tue Mar 15, 2016 8:36 am
Forum: Main Forum
Topic: How to fill out a form and look up patient info?
Replies: 7
Views: 4685

Re: How to fill out a form and look up patient info?

I use AutoHotKeys to make my own keyboard shortcuts. One of my favorites is selecting a patient. Control+Shift+s ; Click on the select patient dialog. ^+s:: IfWinExist, Hubrich Open Dental { WinActivate ; Automatically uses the window found above. WinMaximize ; same Click 75,55 return } else { run %...
by bpcomp
Thu Feb 25, 2016 10:29 am
Forum: Advanced Topics
Topic: Any purge tool developed in the last 6 years?
Replies: 4
Views: 3346

Re: Any purge tool developed in the last 6 years?

The requirements on keeping PHI vary from state to state as I understand but after 7 years in most places you are not required to keep records. In a paper office, you would destroy records older than 7 years and most people would argue it's a physical space reason but I'll make an additional argumen...
by bpcomp
Thu Feb 25, 2016 9:48 am
Forum: Advanced Topics
Topic: Any purge tool developed in the last 6 years?
Replies: 4
Views: 3346

Re: Any purge tool developed in the last 6 years?

I hadn't thought about it before but this would be something useful to have and I'll second the question about it a tool could be made.
by bpcomp
Thu Feb 25, 2016 8:49 am
Forum: Main Forum
Topic: Open dental, assistant, clinician and assistant time
Replies: 1
Views: 1769

Re: Open dental, assistant, clinician and assistant time

Go to (Setup/Appointments/Appointment Views) Edit your view and then look at the section labeled "View Provider Bars" on the bottom left. As you select provider bars, they will show up on the left side of the appt schedule with all the x's and /'s.
by bpcomp
Tue Feb 23, 2016 8:32 am
Forum: Main Forum
Topic: Backups
Replies: 2
Views: 2593

Re: Backups

I'll second the virtual machine method. We make nightly clones of our virtual server which are stored in a Linux environment copied over a Linux network to a backup server. The Windows environment does not see or talk to the Linux backup machine so there is no chance of the crypto virus messing with...
by bpcomp
Tue Feb 23, 2016 8:23 am
Forum: Main Forum
Topic: Exporting all of my employees timesheets
Replies: 3
Views: 3015

Re: Exporting all of my employees timesheets

Use custom query #756. Adjust the FromDate and ToDate to match the time period you need. Check out http://www.opendental.com/manual/queryrun.html to help you if you haven't run a custom query. /*756 Time Card summary for all Employees with days worked and avg hours per day*/ SET @FromDate='2013-10-2...
by bpcomp
Tue Feb 23, 2016 8:16 am
Forum: Main Forum
Topic: Missing Claim
Replies: 2
Views: 2256

Re: Missing Claim

Try running the database maintenance tool to see if that helps fix he problem. (Tools/Database Maintenance)
by bpcomp
Tue Feb 23, 2016 8:12 am
Forum: Main Forum
Topic: Dentrix Ascend to Open Dental
Replies: 6
Views: 7058

Re: Dentrix Ascend to Open Dental

One of the big arguments for switching to OpenDental is our office was the much smaller hardware requirements. What this means in practical terms for us is that we didn't need to spend 20K upgrading all the hardware in the office so that it would be powerful enough to run Dentrix G5 (latest version ...
by bpcomp
Wed Dec 23, 2015 8:54 am
Forum: Main Forum
Topic: Dentrix Ascend to Open Dental
Replies: 6
Views: 7058

Re: Dentrix Ascend to Open Dental

If they were using MacPractice then can I assume that all the computers in the office are Macs? If so then you will also need to consider that Open Dental is a Windows program and you will need Parallels, VirtualBox, or something of that nature. I'm sure the Mac users in the forum can give you a bet...
by bpcomp
Thu Nov 19, 2015 4:10 pm
Forum: Main Forum
Topic: Slow initial delay(Network) on workstation
Replies: 14
Views: 9806

Re: Slow initial delay(Network) on workstation

Again the power setting may be set for the wireless but not the wired connection. Might be an IP conflict. Might be a bad cable. Might be a bad wired connection on the laptop. So then you set up experiments to isolate the problem. On the software side, try changing the IP that your laptop uses manua...
by bpcomp
Tue Nov 17, 2015 10:11 am
Forum: Main Forum
Topic: Slow initial delay(Network) on workstation
Replies: 14
Views: 9806

Re: Slow initial delay(Network) on workstation

Is it only the new laptop giving you the slowness problems? If so does it change if you are connected wired vs wireless?
by bpcomp
Thu Nov 12, 2015 7:57 am
Forum: Main Forum
Topic: Slow initial delay(Network) on workstation
Replies: 14
Views: 9806

Re: Slow initial delay(Network) on workstation

There are a couple of things to look at. First is network card sleep. On the properties for the network card, there is an option to allow the computer to put the network card to sleep. http://s16.postimg.org/a9fnotlhh/power_saving.png You want to have that disabled like I do. Next thing I would look...
by bpcomp
Tue Nov 03, 2015 8:10 am
Forum: Main Forum
Topic: Recall for two cleaning per 12 months
Replies: 1
Views: 1814

Re: Recall for two cleaning per 12 months

There is no automated way to do it that I'm aware of. I'm guessing a query could be made that would have to have a special flag for those accounts and then it would check the appointments and list any that don't fit the recall conditions. It would be fairly complex to write that query and beyond my ...
by bpcomp
Tue Nov 03, 2015 7:59 am
Forum: Main Forum
Topic: Patient portion on schedule
Replies: 1
Views: 1720

Re: Patient portion on schedule

As you saw, you can show production on the schedule but there is no easy way to show co-pay. I did think of a work around but it's rather clumsy and inelegant. What you would do is create a patient field by going to (setup/family/patient field defs) and creating a new patient field for currency and ...
by bpcomp
Mon Nov 02, 2015 8:44 am
Forum: Advanced Topics
Topic: Appointment QR code idea.
Replies: 2
Views: 2387

Re: Appointment QR code idea.

I agree that the first go round would be more cumbersome, but every subsequent time would be more streamlined IMO. We've had several instances where a patient had inputted the appointment data into their calendar wrong and showed up on the wrong day or didn't show up for their appointment. I think t...
by bpcomp
Fri Oct 30, 2015 4:43 pm
Forum: Main Forum
Topic: Viewing .pdf's in Images module
Replies: 12
Views: 4510

Re: Viewing .pdf's in Images module

Well it looks like there is already an issue :-)
by bpcomp
Thu Oct 08, 2015 10:45 am
Forum: Advanced Topics
Topic: Appointment QR code idea.
Replies: 2
Views: 2387

Appointment QR code idea.

So I had this idea today that we could have a QR code generated for a specific appointment at checkout so that patients could just scan the appointment directly into the calendar on their phone. I've done a little looking into this and I think the best approach is as a plugin. I haven't looked at th...
by bpcomp
Thu Oct 08, 2015 9:38 am
Forum: Main Forum
Topic: Viewing .pdf's in Images module
Replies: 12
Views: 4510

Re: Viewing .pdf's in Images module

Well it sounds like pdf support needs some looking at because I won't upgrade to the latest Adobe reader in our office until this issue is resolved. Thanks Jason.
by bpcomp
Thu Oct 08, 2015 9:16 am
Forum: Main Forum
Topic: Viewing .pdf's in Images module
Replies: 12
Views: 4510

Re: Viewing .pdf's in Images module

It looks like Adobe is hard coded to be the reader for OpenDental. Any option for choosing an alternate pdf viewer like Mupdf or SumatraPDF?
by bpcomp
Thu Oct 08, 2015 8:00 am
Forum: Main Forum
Topic: Viewing .pdf's in Images module
Replies: 12
Views: 4510

Re: Viewing .pdf's in Images module

I tried your steps Jay but no success. I have to uninstall Reader DC and install the old Reader 11 to get it to work again.
by bpcomp
Tue Sep 15, 2015 8:42 am
Forum: Main Forum
Topic: Computers for a startup
Replies: 15
Views: 7231

Re: Computers for a startup

We backup the whole virtual server but it wouldn't hurt to do a separate data only backup.
by bpcomp
Wed Aug 19, 2015 3:42 pm
Forum: Main Forum
Topic: ScanX Imaging software
Replies: 11
Views: 9263

Re: ScanX Imaging software

I don't know if this would come even close to being an acceptable solution, but you could do twain capture as a scanner directly into OpenDental's imaging module. You wouldn't have mounting or several other "xray imaging software" features, but it would work.
by bpcomp
Mon Jul 27, 2015 7:48 am
Forum: Main Forum
Topic: List of Links to TWAIN Drivers for All Sensors
Replies: 1
Views: 1524

Re: List of Links to TWAIN Drivers for All Sensors

Many vendors charge an extra fee for their twain drivers. They are not considered free use and are thus not freely distributed. I have never heard of any list of twain drivers and I doubt one exists. I'm thinking your best bet is an imaging application like Patterson Imaging that would have links to...
by bpcomp
Fri Mar 06, 2015 9:50 am
Forum: Main Forum
Topic: Report - separate cash from credit card for patient income
Replies: 6
Views: 1537

Re: Report - separate cash from credit card for patient inco

My brother helped me out and came up with this query for getting daily totals.

Code: Select all

select paytype, sum(payamt) from payment where paydate = '2015-02-24' group by paytype
Have a good day.
by bpcomp
Fri Mar 06, 2015 9:04 am
Forum: Main Forum
Topic: Creating a Claim with Bilateral Space Maintainers
Replies: 4
Views: 3237

Re: Creating a Claim with Bilateral Space Maintainers

I poked around a bit and did not find a workaround. I believe that the permanent tooth limitation is coded into the program and you'd have to speak to OpenDental about changing that limitation for that procedure code.
by bpcomp
Fri Feb 27, 2015 4:12 pm
Forum: Main Forum
Topic: Report - separate cash from credit card for patient income
Replies: 6
Views: 1537

Re: Report - separate cash from credit card for patient inco

So if you run the query SELECT * from Payments you will see all the payments in the system. Move the radio button from human readable to raw and look at the PayType column. Our credit payments are 304 and our cash payments are 303. I whipped up two quick queries to give a total for each day. SELECT ...
by bpcomp
Fri Feb 27, 2015 7:36 am
Forum: Main Forum
Topic: Report - separate cash from credit card for patient income
Replies: 6
Views: 1537

Re: Report - separate cash from credit card for patient inco

Yes it is possible. Have you looked through the Query examples yet? http://opendentalsoft.com:1942/ODQueryL ... yList.aspx

If you can't find a query that does what you want, it is possible to write one or have one written for you.
by bpcomp
Thu Jan 29, 2015 8:53 am
Forum: Main Forum
Topic: Notes signing or not
Replies: 5
Views: 1582

Re: Notes signing or not

Like I said, I'm not a lawyer, but it is my understanding based on stories I've heard of court cases etc. If you really want to know the answer then I recommend that you contact your lawyer and find out.
by bpcomp
Wed Jan 28, 2015 9:48 am
Forum: Main Forum
Topic: Notes signing or not
Replies: 5
Views: 1582

Re: Notes signing or not

I am not a lawyer but my understanding is that any automated signature has no chance of standing up in court. Same for being the use logged in etc. The only chance you have is with an actual signature originating from a legally admissible signature device.
by bpcomp
Wed Jan 28, 2015 9:43 am
Forum: Main Forum
Topic: Open Dental Localization and Calendar
Replies: 10
Views: 2793

Re: Open Dental Localization and Calendar

That is great news and I hope it comes through quickly for you.
by bpcomp
Wed Jan 28, 2015 8:46 am
Forum: Main Forum
Topic: Prevent Employees From Clocking-in Too Early
Replies: 7
Views: 5670

Re: Prevent Employees From Clocking-in Too Early

So as for limiting when they can clock in, I looked around but didn't find anything. As for having this problem once a year, you gave your talk and that's final. Next person who violates the rules (even if it's 3 months from now) you give them a write up or however you handle personnel issues. No mo...
by bpcomp
Tue Jan 27, 2015 2:35 pm
Forum: Main Forum
Topic: Prevent Employees From Clocking-in Too Early
Replies: 7
Views: 5670

Re: Prevent Employees From Clocking-in Too Early

If you have employees who are doing time theft, then restricting when they can clock in is not your main issue. You main issue is time theft and I would present it to them as that and explain that if they break the rules then they will get a warning etc until they are let go.
by bpcomp
Mon Jan 26, 2015 11:00 am
Forum: Main Forum
Topic: keeping track of stock we are retailing
Replies: 1
Views: 673

Re: keeping track of stock we are retailing

There is no built in automated system for keeping track of inventory of items you sell. There is a section for supplies and inventory but it's not tied to sales and quantity wouldn't update when selling to a patient. After thinking of workarounds, my best thought is to have someone make it in a plug...
by bpcomp
Tue Jan 13, 2015 9:13 am
Forum: Main Forum
Topic: Integration with US Postal Service (USPS) address checking
Replies: 6
Views: 6455

Re: Integration with US Postal Service (USPS) address checki

Sounds interesting. I see that USPS has an API for address verification, which I wasn't aware of before. If you do develop this as a plugin, I'd be interested to see it.
by bpcomp
Mon Dec 22, 2014 10:10 am
Forum: Main Forum
Topic: Creating a Claim with Bilateral Space Maintainers
Replies: 4
Views: 3237

Re: Creating a Claim with Bilateral Space Maintainers

Change the treatment area for that code from "Tooth" to "ToothRange" under (lists/procedure codes). Then you can select two teeth and code out for the D1515.
by bpcomp
Tue Sep 30, 2014 8:27 am
Forum: Main Forum
Topic: Panoramic images printing with office/patient info
Replies: 3
Views: 1134

Re: Panoramic images printing with office/patient info

So it looks like you are capturing into OD and not using an external Imaging application. Currently OD's functionality to act as an imaging application is limited. In the newest version of OD, there is the possibility of importing patient images into the sheets framework and you maybe able to create...
by bpcomp
Fri Sep 19, 2014 4:27 pm
Forum: Main Forum
Topic: Panoramic images printing with office/patient info
Replies: 3
Views: 1134

Re: Panoramic images printing with office/patient info

Are you capturing the panos into Open Dental or using other imaging software for patient images?
by bpcomp
Thu Aug 07, 2014 5:03 pm
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

Well I actually considered a cluster and bare metal virtualization, but I wanted a fairly simple setup in terms of being able to walk someone through it over the phone or having any IT company be able to come in and get the office back up and running. Copying and booting a VM from VMware workstation...
by bpcomp
Wed Aug 06, 2014 5:00 pm
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

I run the server as a virtual machine with a Linux host. I have scripts that will suspend the server and clone if over to our backup server which also plays movies for the kids. If the main server ever takes a dump physically, we boot a copy of the virtual server on the backup machine and have the o...
by bpcomp
Wed Aug 06, 2014 2:14 pm
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

idrive handles online only. We have a different backup for local backup.
by bpcomp
Tue Aug 05, 2014 9:26 am
Forum: Main Forum
Topic: Keyboard shortcuts - Add to Manual and Search
Replies: 10
Views: 3051

Re: Keyboard shortcuts - Add to Manual and Search

I re-shared the file for Maye at http://www.adrive.com/public/5fKqEP/Ope ... ortcut.exe. I'll have to find a more permanent solution for hosting the file later.
by bpcomp
Tue Aug 05, 2014 9:12 am
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

https://www.idrive.com/idrive-for-mssql-faq.htm My understanding is that idrive will automate the dump file creation and back it up under windows. It will also do real-time backup using either VSS or something like VSS. With backup of a hot database under VSS, there still exists the possibility of e...
by bpcomp
Thu Jul 31, 2014 8:52 am
Forum: Main Forum
Topic: Truecrypt to Bitlocker now?
Replies: 12
Views: 2171

Re: Truecrypt to Bitlocker now?

You should decrypt with truecrypt first and then you can use bitlocker.
by bpcomp
Mon Jul 28, 2014 6:53 am
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

Sorry Justin, what is BAA?
by bpcomp
Fri Jul 25, 2014 10:06 am
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

by bpcomp
Fri Jul 25, 2014 9:45 am
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

My previous research into Crashplan was that they didn't handle backup of hot sql databases. They recommend to do a sql dump for sql backup. They suggested that it might work but they said it was iffy to try and backup the data hot. That factor may have changed http://support.code42.com/CrashPlan/La...
by bpcomp
Wed Jul 23, 2014 5:03 pm
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

They explicitly state that they can backup hot SQL. I asked about continuous backup of the databases and they said they don't recommend it because you lose the advantage of the versioning (all the versions happen in one day). The versioning is not an issue for me because I have daily backups that sp...
by bpcomp
Wed Jul 23, 2014 7:47 am
Forum: Main Forum
Topic: Backing up with IDRIVE.COM!
Replies: 22
Views: 20108

Re: Backing up with IDRIVE.COM!

So I just did some homework on them and found that they are Hipaa compliant if you set up with the private key encryption. The best answer I was able to get on if it would work with our Patterson Imaging database is that it should work and we can do a 15 day trial to test it out. I'm probably going ...
by bpcomp
Thu Jul 10, 2014 8:14 am
Forum: Advanced Topics
Topic: Locating incorrect Ins Estimate Remaining
Replies: 3
Views: 1787

Re: Locating incorrect Ins Estimate Remaining

This is probably going to be a pain but I would look at each procedure in that account from the account module. When you open up a procedure, there will sometimes be extra entries at the bottom in the "Insurance Estimates and Payments" section. I've seen them generated by starting a claim with one i...
by bpcomp
Tue Jul 08, 2014 3:58 pm
Forum: Main Forum
Topic: A Way to Make the Aging Report more accurate for us
Replies: 3
Views: 966

Re: A Way to Make the Aging Report more accurate for us

Another option is to create and set a new billing type (setup/definitions/billing types) for people on financing and then exclude that billing type when running your aging reports. (When running aging report, just uncheck the "all" box under billing types and then select the types you want to run) I...
by bpcomp
Tue Jul 08, 2014 7:00 am
Forum: Main Forum
Topic: unscheduled apointment list
Replies: 6
Views: 1460

Re: unscheduled apointment list

Somewhat of a workaround still but you can have two Open Dental windows open. Have your unscheduled list in one and look up your patients in the other.
by bpcomp
Thu Jun 26, 2014 3:09 pm
Forum: Main Forum
Topic: Open Dental Localization and Calendar
Replies: 10
Views: 2793

Re: Open Dental Localization and Calendar

Given the nature and complexity of your question, I'm going to recommend that you ask over in the advanced section. I don't have the skill but my guess is that you would use a plugin to make it happen. Plugin hook requests can be made in the developers forum.
by bpcomp
Wed Jun 25, 2014 5:17 pm
Forum: Sharing
Topic: Automation
Replies: 6
Views: 8032

Automation

I am constantly trying to find ways to automate and make the day to day tasks just a bit quicker and easier. I've ended up using AutoHotKey to manage a lot of this. The latest addition to our automation is a script that will enter 323 as many times as requested for Perio charting. When you have a ro...
by bpcomp
Wed Jun 25, 2014 5:10 pm
Forum: Main Forum
Topic: Visix any good?
Replies: 10
Views: 7188

Re: Visix any good?

Patterson Imaging has an integration issue with OpenDental. It apparently doesn't link to the patient based on patient ID but on some other combination of data. Long and short of it is that if you have a patient without a SS# (child) and you rename them, then a new patient is created in Patterson Im...
by bpcomp
Thu Jun 12, 2014 1:02 pm
Forum: Main Forum
Topic: What do I need and what will it cost to use Open Dental
Replies: 5
Views: 1634

Re: What do I need and what will it cost to use Open Dental

If you are not comfortable setting up network, xrays, etc.. then you should get an IT professional to help you. The best bet is to go with one that does a lot of Dental offices because they are going to be familiar with setting up digital xrays and what not. This is not the cheapest route but if you...
by bpcomp
Tue May 20, 2014 7:48 am
Forum: Main Forum
Topic: Standard lab instructions
Replies: 7
Views: 1495

Re: Standard lab instructions

Another option is to use AutoHotKey. http://www.autohotkey.com/ All you need is a script that goes like this ^l:: SentInput Bruxzir crown, 4 coats die spacer, very light in occlusion, no occlusal staining return When you load that script up then any time you hit the control key and the letter l, tha...
by bpcomp
Mon May 19, 2014 10:42 am
Forum: Main Forum
Topic: Standard lab instructions
Replies: 7
Views: 1495

Re: Standard lab instructions

Look into autonotes.

http://www.opendental.com/manual/autonotes.html

If that doesn't fit the bill then reply back and I'll offer another solution.
by bpcomp
Mon May 19, 2014 10:39 am
Forum: Advanced Topics
Topic: XP and HIPAA and Virtual Machines?
Replies: 10
Views: 5969

Re: XP and HIPAA and Virtual Machines?

This might be left field but it might be worth a shot to try Wine under Linux for the XP only application. You then gain the security of an actively updated OS. You could still run it as a virtual machine with a private virtual Lan.
by bpcomp
Tue Apr 15, 2014 9:56 am
Forum: Main Forum
Topic: ControlScan
Replies: 2
Views: 792

Re: ControlScan

We have PCI compliance through our CC processor also but it is a different company. The best I've figured out is that if you are taken to court, you have procedures in place to not get you in trouble and you can show how you review and do those things. I think it's also something that possibly limit...
by bpcomp
Tue Apr 15, 2014 9:52 am
Forum: Main Forum
Topic: Label maker
Replies: 8
Views: 1703

Re: Label maker

We just got the Brother QL-710w which is wireless and means that we can print from any computer and don't need a computer to be a print server.
by bpcomp
Tue Apr 15, 2014 9:50 am
Forum: Main Forum
Topic: Root tip
Replies: 1
Views: 802

Re: Root tip

Looks like there is a feature request for that. Look at request #217.

To learn more about feature request's, see this page:
http://www.opendental.com/manual/featurerequests.html
by bpcomp
Mon Apr 07, 2014 8:07 am
Forum: Main Forum
Topic: Windows 7 chart
Replies: 8
Views: 1680

Re: Windows 7 chart

My guess is graphic settings. You can try this: (File/Graphics) Check the button that says use OpenGL. Check the "Hardware Acceleration" box, the Use "Double-Buffering" box and then the "Show All Formats" box. Select option 4 and then say OK. Now test for stability and speed. If this doesn't work th...
by bpcomp
Wed Mar 26, 2014 12:05 pm
Forum: Advanced Topics
Topic: New Install
Replies: 3
Views: 2522

Re: New Install

Read this page for computer requirements.

http://www.opendental.com/manual/comput ... ments.html

You shouldn't need to download mysql. I believe the installer handles getting mysql installed. Windows 7 should be fine for the server with 3 workstations.
by bpcomp
Thu Mar 20, 2014 3:35 pm
Forum: Main Forum
Topic: Holiday List
Replies: 1
Views: 692

Re: Holiday List

Add block outs or define the date as a holiday in the schedule setup. The day will appear a different color on the schedule when viewing appts. As for "pre-defined", your best bet is to write a script and sql query that scapes public holidays off some public calender and then injects blockouts for t...
by bpcomp
Fri Mar 07, 2014 8:05 am
Forum: Main Forum
Topic: sort on tooth # and date?
Replies: 1
Views: 673

Re: sort on tooth # and date?

I think that is something you would need to do a feature request on. I think it's doable but not in the system yet.
by bpcomp
Fri Mar 07, 2014 7:51 am
Forum: Main Forum
Topic: Report for patient conversion rate
Replies: 1
Views: 680

Re: Report for patient conversion rate

Here is a list of Queries and you might find what you want in this list.
http://opendentalsoft.com:1942/ODQueryL ... yList.aspx

If you really can't find what you want then Open Dental can write a custom query for you.
by bpcomp
Fri Mar 07, 2014 7:49 am
Forum: Main Forum
Topic: Potential new user seeks users near San Francisco or Marin
Replies: 1
Views: 679

Re: Potential new user seeks users near San Francisco or Mar

Hi Jeff, I'm located in Tucson Arizona but I happen to know that if you call Open Dental, they can provide you with some names in your area who might not be active on this forum.
by bpcomp
Fri Feb 07, 2014 10:33 am
Forum: Main Forum
Topic: When ins. pays via credit card instead of check
Replies: 9
Views: 2138

Re: When ins. pays via credit card instead of check

If you get the ACH company ID for withdrawl then you can put a block on automatic withdrawls while leaving automatic deposits in place.
by bpcomp
Wed Jan 29, 2014 7:32 am
Forum: Main Forum
Topic: Built in Backup Question
Replies: 7
Views: 3132

Re: Built in Backup Question

You can not do that backup in the middle of the day while anyone is working. Yes it does stop MySql during the process. If you have any open workstations while attempting the backup, it will give you a warning about which workstations are open. It will also error out or crash and lose data for anyth...
by bpcomp
Thu Jan 23, 2014 8:26 am
Forum: Main Forum
Topic: When ins. pays via credit card instead of check
Replies: 9
Views: 2138

Re: When ins. pays via credit card instead of check

We've gotten one credit card payment so far and we sent it back and demanded a check. They grumbled about it taking longer to pay us but sent the payment out via check. We accept credit cards in our office as a convenience for our patients, NOT for the insurance companies.
by bpcomp
Thu Jan 23, 2014 8:23 am
Forum: Main Forum
Topic: Linking website to database in the office
Replies: 13
Views: 2485

Re: Linking website to database in the office

Estan, I'm going to recommend that you not do this yourself. As a complete novice, the danger of opening access from your patient database to internet access without being something of an expert in security is a disaster waiting to happen. I am not said expert and would not know how to do it but I k...
by bpcomp
Mon Jan 13, 2014 4:06 pm
Forum: Main Forum
Topic: New to OD
Replies: 2
Views: 857

Re: New to OD

You've already answered 1 so I'll move on to question 2. The long and short of it is that there is a plan to integrate with Lexicomp in the future but that hasn't been implemented yet so as of right now an no guess on the time frame either. If you do a conversion then all your meds from that databas...
by bpcomp
Thu Dec 12, 2013 1:25 pm
Forum: Main Forum
Topic: back up
Replies: 13
Views: 2890

Re: back up

Fair enough on getting sleep. They are correct that the data is encrypted end to end for Mozy and Crashplan but I'm fairly sure that if an employee (of Mozy or Crashplan) wanted to get access to your files, then they could. With Truecrypt it's pretty much just the NSA who can get your data.
by bpcomp
Thu Dec 12, 2013 9:45 am
Forum: Main Forum
Topic: back up
Replies: 13
Views: 2890

Re: back up

Do you run a domain in this setup or peer to peer? Also for step 4 I think it's unneeded to have one of the pieces on a flashdrive because the data is contained in a truecrypt container. Having a trucrypt container is more secure in my opinion that the Mozy and Crashplan backups, unless those are al...
by bpcomp
Tue Nov 19, 2013 12:52 pm
Forum: Sharing
Topic: Some icons
Replies: 3
Views: 9190

Re: Some icons

OK so to use some of these icons you would create your own custom procedure buttons. In Open Dental click (Setup/Procedure Buttons). In the window that pops up you can edit categories to add new ones that fit your needs or add a button to an existing category. Select the "Add" button, this will brin...
by bpcomp
Tue Nov 19, 2013 7:05 am
Forum: Main Forum
Topic: back up
Replies: 13
Views: 2890

Re: back up

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!
by bpcomp
Mon Nov 18, 2013 10:42 am
Forum: Main Forum
Topic: back up
Replies: 13
Views: 2890

Re: back up

There are many ways to backup and protect your data. The answer I always give to this question is how many ways can you afford? If you can manage more than 1 way to backup your data then you should. Typically raid 1 is not considered a backup but is more a reliability measure. When you say "switchin...
by bpcomp
Mon Nov 04, 2013 7:34 am
Forum: Sharing
Topic: Some icons
Replies: 3
Views: 9190

Re: Some icons

We just got back from the ADA and I have a lot to catch up on. Once things have settled down I'll make a quick how to for the icons.
by bpcomp
Thu Oct 17, 2013 11:01 am
Forum: Main Forum
Topic: Check when appointment was made
Replies: 1
Views: 631

Re: Check when appointment was made

In the appointment view, look on the right side for the button labeled audit trail and click that. As long as OpenDental was in use when the appointment was created then the audit trail will tell you when the appointment was created and which logged in user was the one who did it. If you are using c...
by bpcomp
Tue Oct 08, 2013 3:43 pm
Forum: Main Forum
Topic: Only one person can enter payment in at a time?
Replies: 2
Views: 742

Re: Only one person can enter payment in at a time?

I don't believe there is a limitation that only one person can enter checks at a time. It's not as easy or convenient if one person does it but I think it's doable. When you enter bulk checks then all the amounts of claims that don't have checks get pooled into one group check amount. If multiple gr...
by bpcomp
Mon Oct 07, 2013 10:36 am
Forum: Main Forum
Topic: What are you guys using for data encryption?
Replies: 45
Views: 27987

Re: What are you guys using for data encryption?

There is no encryption that helps when a workstation has been hacked on a live environment. As long as your database is network accessible then there is a vulnerability that files could be copied. This is why security should be approached from a site wide viewpoint instead of concentrating only on t...
by bpcomp
Mon Oct 07, 2013 7:35 am
Forum: Main Forum
Topic: Be Afraid, Be Very Afraid... Ransomware
Replies: 25
Views: 12768

Re: Be Afraid, Be Very Afraid... Ransomware

So if I take files that have been encrypted and move them to a separate non-infected computer and I'm unable to access them because they are ENCRYPTED then how is this an "unreal alert". Why would I "just remove this virus"? Why would I take any advice from this website you keep linking to which giv...
by bpcomp
Fri Oct 04, 2013 4:41 pm
Forum: Main Forum
Topic: Be Afraid, Be Very Afraid... Ransomware
Replies: 25
Views: 12768

Re: Be Afraid, Be Very Afraid... Ransomware

No matter what, if your data is encrypted then taking a stand and not paying the criminals for the sake of not paying them is just silly if your office data is encrypted and you have no backup or recent backup. Removing the Trojan is just silly when all your data is still encrypted. The only way it ...
by bpcomp
Tue Sep 24, 2013 3:07 pm
Forum: Main Forum
Topic: Need a Positive Review of Open Dental
Replies: 15
Views: 10847

Re: Need a Positive Review of Open Dental

I'm available also.

520-886-7575

We are Arizona time. Ask for Benji.
benji@hubrichdental.com
by bpcomp
Mon Sep 23, 2013 12:07 pm
Forum: Main Forum
Topic: Be Afraid, Be Very Afraid... Ransomware
Replies: 25
Views: 12768

Re: Be Afraid, Be Very Afraid... Ransomware

Fogproject looks very nice. I haven't done a comparison but from a quick glance through the main thing that I think separates Clonzilla and Fogproject is that to clone a machine with Fogproject, you need a cloning server on your network. With Clonezilla all you need is a burned CD and a USB drive to...
by bpcomp
Fri Sep 20, 2013 2:02 pm
Forum: Main Forum
Topic: Be Afraid, Be Very Afraid... Ransomware
Replies: 25
Views: 12768

Re: Be Afraid, Be Very Afraid... Ransomware

If you are looking for disk cloning and wanting to stick with open source, take a look at Clonezilla. It's worked well for me the couple of times I've used it.
by bpcomp
Tue Sep 17, 2013 2:26 pm
Forum: Main Forum
Topic: Dentrix to Open Dental Conversion tips and ideas wanted
Replies: 2
Views: 2178

Re: Dentrix to Open Dental Conversion tips and ideas wanted

I remember going through a very similar time with the database conversion as you seem to be going through. I found several things with OD seemed to have as a feature but did not transfer in our test conversion. I took note of every issue I found and worked with the conversion team to get most of tho...
by bpcomp
Tue Sep 10, 2013 10:36 am
Forum: Main Forum
Topic: multiple provider office, different fees?
Replies: 6
Views: 1572

Re: multiple provider office, different fees?

If you go to "Lists/Providers" you can change what fee schedule is used for that provider.
by bpcomp
Thu Aug 29, 2013 10:24 am
Forum: Main Forum
Topic: Tracking a group of patients
Replies: 5
Views: 1103

Re: Tracking a group of patients

My apologies Dr Hersh. I obviously miss read your original post. Tracking by referral would obviously work great.
by bpcomp
Thu Aug 29, 2013 7:09 am
Forum: Main Forum
Topic: Tracking a group of patients
Replies: 5
Views: 1103

Re: Tracking a group of patients

Typically the insurance companies would not play well with any modifications to the code. A D1100.1 would probably be rejected. Dr Hersh's suggestion of having a different provider might work depending on how you do it. If you submit to the insurance under a different provider then that creates it's...
by bpcomp
Wed Aug 21, 2013 11:48 am
Forum: Main Forum
Topic: Keep payments away from RDH
Replies: 2
Views: 1162

Re: Keep payments away from RDH

It really depends on what what you are trying to track. There are several ways to configure the recalls for different situations. The places I would look at to try and change the behavior is (Lists/Procedure Codes), in there is a check box on each procedure that can change the default "Is Hygiene Pr...
by bpcomp
Wed Aug 21, 2013 11:09 am
Forum: Main Forum
Topic: DirectX 11 & Video Card
Replies: 18
Views: 12713

Re: DirectX 11 & Video Card

Catalyst may be at version 12 but the driver number maybe different when you really dig down. It's thrown me off before so I thought I'd throw it out there.
by bpcomp
Tue Aug 20, 2013 2:28 pm
Forum: Main Forum
Topic: DirectX 11 & Video Card
Replies: 18
Views: 12713

Re: DirectX 11 & Video Card

Ok, I can see the screen shots now. This is probably a really long shot but I wonder if 32bit DirectX 11 vs 64bit would make any difference. Another crazy idea is to try changing the resolution of your screen to 1024x768 or 1280x1024 and see if that makes any changes. Last idea is to try a different...
by bpcomp
Tue Aug 20, 2013 1:03 pm
Forum: Main Forum
Topic: DirectX 11 & Video Card
Replies: 18
Views: 12713

Re: DirectX 11 & Video Card

"Access denied."

No dice yet.
by bpcomp
Tue Aug 20, 2013 12:46 pm
Forum: Main Forum
Topic: Windows Server 2008R2 Backup Question
Replies: 3
Views: 1031

Re: Windows Server 2008R2 Backup Question

If you are running Server 2008R2 then you almost certainly have a domain. I would NOT recommend only backing up folders like Open Dental ONLY, this will not retain any changes to your domain. Manny has a good suggestion with the physical to virtual (P2V). That being said, Teethdood's suggestion of b...
by bpcomp
Tue Aug 20, 2013 11:18 am
Forum: Main Forum
Topic: DirectX 11 & Video Card
Replies: 18
Views: 12713

Re: DirectX 11 & Video Card

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?
by bpcomp
Thu Aug 15, 2013 10:26 am
Forum: Main Forum
Topic: Picasa integrated to manage images
Replies: 5
Views: 1428

Re: Picasa integrated to manage images

Does tagging on computer 1 propagate to computer 2?
by bpcomp
Wed Aug 14, 2013 1:45 pm
Forum: Main Forum
Topic: Picasa integrated to manage images
Replies: 5
Views: 1428

Re: Picasa integrated to manage images

How does Picasa work in a networked environment? I know that adobe lightroom does organization and tagging but it can't run over the network and is only designed to run on a single system.
by bpcomp
Thu Aug 08, 2013 5:01 pm
Forum: Main Forum
Topic: Using the Wireless Camera Card
Replies: 9
Views: 6265

Re: Using the WIRELESS CAMERA CARD

I agree Jay, automatic assignment is custom written software. I think it's possible with a plugin, but I'm not a software developer to say what is or is not easily done. The biggest issue I see is getting the plugin to recognize that the images that just showed up in the wireless upload folder shoul...
by bpcomp
Thu Aug 08, 2013 9:38 am
Forum: Main Forum
Topic: Switching to Open Dental
Replies: 7
Views: 5317

Re: Switching to Open Dental

We switched away from Dentrix almost 2 years ago and it's been the best software move. Out of curiosity, what is prompting the switch away from Ace? Are there certain features or aspects about Open Dental that look good or is there something annoying about Ace?
by bpcomp
Thu Aug 08, 2013 9:23 am
Forum: Main Forum
Topic: Using the Wireless Camera Card
Replies: 9
Views: 6265

Re: Using the WIRELESS CAMERA CARD

We use the eyefi in our office. It downloads the images to a folder on our server and then we manually import those images into the patient. This saves the steps of having to pull the memory card out of the camera and importing the images. We can start pulling up images with the patient in the chair...
by bpcomp
Wed Jul 31, 2013 2:51 pm
Forum: Main Forum
Topic: Insurance payment
Replies: 2
Views: 646

Re: Insurance payment

Depending on what wasn't paid you can either split the claim or do a supplemental payment. If you already have the extra payment then I would just do a supplemental payment. If there is part of the claim that needs to be resent because it didn't pay then you can split the claim and resend the part t...
by bpcomp
Mon Jul 29, 2013 7:43 am
Forum: Advanced Topics
Topic: virtualbox question
Replies: 23
Views: 12213

Re: virtualbox question

The bat file would be easiest to run from the guest where all the data resides. I think it's possible to run from the host but I'm not 100% that it would all work. Either way the bat files needs access to the files in question AND the USB drive, so you either hook the USB drive up to the guest or co...
by bpcomp
Wed Jul 24, 2013 2:57 pm
Forum: Main Forum
Topic: Best practices for PPOs with OD
Replies: 10
Views: 3509

Re: Best practices for PPOs with OD

I am not a lawyer nor am I an insurance expert. All opinions expressed below are my own. I believe that I understand your point but I don't think I agree with your interpretation. If you send your full fees to both insurance companies, then how is it fraud to receive greater than the contracted rate...
by bpcomp
Tue Jul 23, 2013 12:15 pm
Forum: Main Forum
Topic: Best practices for PPOs with OD
Replies: 10
Views: 3509

Re: Best practices for PPOs with OD

Our office is almost entirely FFS and we are not in network with any (except a few state plans) insurance so if my thoughts are incorrect, that would be why. If $800 is your regular fees and Primary only allows a contracted rate of $700 and they pay $350 on that that does not mean that $700 is the r...
by bpcomp
Wed Jul 17, 2013 1:59 pm
Forum: Main Forum
Topic: Insurance payment
Replies: 2
Views: 851

Re: Insurance payment

You can delete the original claim and create two new claims. One will be marked as received and the other can be resubmitted. bdp
by bpcomp
Fri Jul 12, 2013 9:35 am
Forum: Main Forum
Topic: Cigna HMO setup.
Replies: 8
Views: 6224

Re: Cigna HMO setup.

I apologize in advance, I did not thoroughly read your post but glanced over it. If your issue is only for this one procedure then... In the code setup for composite filling on posterior teeth there is an option to apply the alternate benefit of an amalgam restoration. You can over ride this setting...
by bpcomp
Wed Jul 10, 2013 8:10 am
Forum: Main Forum
Topic: Changing pt statuses HELP!
Replies: 2
Views: 1010

Re: Changing pt statuses HELP!

Take a look at this page. http://www.opendental.com/manual/appointments.html That gives a good over view of how to handle appointments in Open Dental. For our office we set up appointment views to show patient status. First go to (setup/definitions/appt confirmed) Select the colors you want for each...
by bpcomp
Thu Jun 20, 2013 8:05 am
Forum: Main Forum
Topic: CRM - Customer relationship management?
Replies: 12
Views: 8083

Re: CRM - Customer relationship management?

Much of the functionality you want is in Open Dental. If you go to the Appts screen and then look over on the top right hand side, you will see two icons. One icon looks like a pad of paper with the corner folded up and is labeled "Appointment Lists" if you hover over it. The other icon looks like a...
by bpcomp
Thu Jun 20, 2013 7:52 am
Forum: Main Forum
Topic: Updating hardware and also need a good back up solution
Replies: 9
Views: 6029

Re: Updating hardware and also need a good back up solution

I have the odd position of having been on both sides of this discussion. I worked for an IT company that serviced dental offices almost exclusively. I now work at a dental office but not in the IT capacity. I've seen the gamut from very IT savvy Dr's to the ones who didn't know how to turn on their ...
by bpcomp
Wed Jun 19, 2013 12:26 pm
Forum: Main Forum
Topic: Huge CBCT file storage
Replies: 3
Views: 931

Re: Huge CBCT file storage

by bpcomp
Mon Jun 17, 2013 9:32 am
Forum: Main Forum
Topic: Updating hardware and also need a good back up solution
Replies: 9
Views: 6029

Re: Updating hardware and also need a good back up solution

Server 2012 SMB is the devil. Rule of thumb for me is anything that is Small Business from Microsoft is something to avoid like the plague.
by bpcomp
Mon Jun 17, 2013 8:29 am
Forum: Main Forum
Topic: Huge CBCT file storage
Replies: 3
Views: 931

Re: Huge CBCT file storage

You could run a separate virtual file server and only back it up once a week. One solution I've seen but don't really recommend is a robotic tape library backup. If you aren't concerned with offsite backup then I would go with a virtual server cloned to another machine in your office once a week on ...
by bpcomp
Fri Jun 14, 2013 8:04 am
Forum: Main Forum
Topic: Start Time End Time
Replies: 2
Views: 720

Re: Start Time End Time

"Used to be part of the ProcDate, but that was causing reporting issues."

From http://www.opendental.com/OpenDentalDoc ... ocedurelog
by bpcomp
Thu Jun 13, 2013 8:50 am
Forum: Main Forum
Topic: Best way to transfer files?
Replies: 9
Views: 1600

Re: Best way to transfer files?

Yeah, I was referring to digital xrays. As for restoring the backup from Crashplan, you will have to look at your internet speed and the size of the data set to restore. If you don't have any scanned documents or patient images in your database then it might work to pull the back up data from Crashp...
by bpcomp
Thu Jun 13, 2013 8:01 am
Forum: Main Forum
Topic: Best way to transfer files?
Replies: 9
Views: 1600

Re: Best way to transfer files?

Definitely stay away from windows easy transfer. Do a clean install by all means. I would even go so far as to recommend that you do a clean install of windows 7 to try and remove as much of the crap they send computers out the door with these days. Any chance you get with windows to have a clean in...
by bpcomp
Wed Jun 12, 2013 3:35 pm
Forum: Main Forum
Topic: Best way to transfer files?
Replies: 9
Views: 1600

Re: Best way to transfer files?

Which files do you mean when you say everything. You should transfer your data only and install all the programs from scratch on the new server. If you have a lot of patient data to copy can can do it over the network or with a portable hard drive. If you are asking for guidance on the mechanics of ...
by bpcomp
Wed Jun 12, 2013 3:19 pm
Forum: Main Forum
Topic: 16 weeks using TRS, not a single broken appt
Replies: 27
Views: 5527

Re: 8 weeks using TRS, not a single broken appt

Well the staff is here during those hours if we have an external reminder system or not, so having them do the recall does not really cost any extra. (I anticipate that one might counter that we reduce the cost of post cards and I would counter with the fact that we've done a survey and we have abou...
by bpcomp
Wed Jun 12, 2013 8:24 am
Forum: Main Forum
Topic: 16 weeks using TRS, not a single broken appt
Replies: 27
Views: 5527

Re: 8 weeks using TRS, not a single broken appt

I always hesitate over a monthly cost thing. I think there is a danger in saying it only needs to do X to pay for itself. I think it's better stated that it only needs to do X to break even. If you string together enough of those services then you might end up with a LOT of X to break even before yo...
by bpcomp
Tue Jun 11, 2013 12:35 pm
Forum: Main Forum
Topic: RAID 0 or 1
Replies: 8
Views: 2935

Re: RAID 0 or 1

I second everything teethdood said. I would however say that having a RAID 1 WITH a virtual server is not necessarily a horrible thing, but is probably unnecessary if you have a solid backup plan and approach.
by bpcomp
Tue Jun 11, 2013 12:13 pm
Forum: Main Forum
Topic: Steriliser batch tracking
Replies: 1
Views: 568

Re: Steriliser batch tracking

I have a possible solution but I haven't tried it so I don't know how it would work for you. If you go to (setup/patient field defs) you can add a custom patient field called Sterilizer record number (or whatever you want to call it). Then every time a you use a sterilizer bag, you add it's record n...
by bpcomp
Tue Jun 11, 2013 12:04 pm
Forum: Main Forum
Topic: Practical use of Task Lists
Replies: 1
Views: 617

Re: Practical use of Task Lists

The work flow in our office for the tasklist is to think of post-it notes. You can put a post-it on your own desk for something you need to remember to do but not at this moment. If you want to leave a note for someone else about a phone call or reminder to do something you send the task to them. Tr...
by bpcomp
Tue Jun 11, 2013 11:55 am
Forum: Main Forum
Topic: How can I learn to write my own query's
Replies: 3
Views: 1057

Re: How can I learn to write my own query's

I started out by modifying existing queries and then asking for help when I didn't understand why it didn't work. It helps to have an understanding of how a database is built so that book you have may be brief but it will probably help with some key concepts. Once you start to try and make your own ...
by bpcomp
Fri May 31, 2013 4:23 pm
Forum: Main Forum
Topic: Gingival graft paint type
Replies: 2
Views: 755

Re: Gingival graft paint type

Because Open Dental doesn't have a built in paint type to handle gum grafts, I would just draw on the chart manually.
by bpcomp
Fri May 31, 2013 1:31 pm
Forum: Main Forum
Topic: Open Dental missed some completed procedures for billing
Replies: 7
Views: 1560

Re: Open Dental missed some completed procedures for billing

Well it could be. Many of the codes for fillings on posterior teeth are setup to insert a substitute code (amalgam). You can see with the same patient if it will repeat the process and not que to send to insurance. Then edit the insurance and look for the check box on the middle left that says "Don'...
by bpcomp
Fri May 31, 2013 11:41 am
Forum: Main Forum
Topic: Open Dental missed some completed procedures for billing
Replies: 7
Views: 1560

Re: Open Dental missed some completed procedures for billing

Is there anything done differently, new person up front etc? Are the restorations only for posterior teeth?
by bpcomp
Fri May 31, 2013 10:38 am
Forum: Main Forum
Topic: Open Dental missed some completed procedures for billing
Replies: 7
Views: 1560

Re: Open Dental missed some completed procedures for billing

Was the NoBillIns flag set on those procedures and secondly was it different procedures or the same ones across multiple patients?
by bpcomp
Fri May 31, 2013 8:26 am
Forum: Main Forum
Topic: Trying to build 12.4 in Release mode
Replies: 2
Views: 678

Re: Trying to build 12.4 in Release mode

Hey Don, your questions are probably better directed to the developer forum. I'm sorry I don't have any answers but that is the place where source code questions are handled.
by bpcomp
Thu May 30, 2013 2:37 pm
Forum: Main Forum
Topic: Open Dental Dexis issue on one laptop only
Replies: 3
Views: 999

Re: Open Dental Dexis issue on one laptop only

Video drivers issue. You can try to see if there is an update for the video drivers. You can also try switching Open Dental's graphic preferences. Go to File and then Graphics and then switch the modes around.
by bpcomp
Thu May 30, 2013 11:17 am
Forum: Main Forum
Topic: Preventing internal theft.
Replies: 6
Views: 1623

Re: Preventing internal theft.

Right now in our office the only person who can edit further than 2 days (other than the Dr's) is our financial coordinator which is myself. Ultimately you need to trust at least one person to manage finances or you need to do it yourself. Any time you delegate the finances there is a risk that the ...
by bpcomp
Wed May 29, 2013 7:44 am
Forum: Main Forum
Topic: Addresses on envelopes - can it be done?
Replies: 6
Views: 1320

Re: Addresses on envelopes - can it be done?

Why does the consent form work better than a custom sheet or something else?
by bpcomp
Wed May 29, 2013 6:45 am
Forum: Main Forum
Topic: Addresses on envelopes - can it be done?
Replies: 6
Views: 1320

Re: Addresses on envelopes - can it be done?

Perfect, that is a great solution. Thank you boboffice.
by bpcomp
Fri May 17, 2013 11:01 am
Forum: Main Forum
Topic: Addresses on envelopes - can it be done?
Replies: 6
Views: 1320

Re: Addresses on envelopes - can it be done?

To the best of my knowledge that is not currently a feature of Open Dental. You can vote for feature request #203 to move this up the priority list.
by bpcomp
Wed May 15, 2013 2:26 pm
Forum: Main Forum
Topic: ISO tooth numbering
Replies: 4
Views: 1047

Re: ISO tooth numbering

Those test patients can take a lot of abuse.
by bpcomp
Tue May 14, 2013 4:37 pm
Forum: Main Forum
Topic: Wiki
Replies: 10
Views: 6933

Re: Wiki

Here is the brief over view page. http://www.opendental.com/manual/wiki.html We are not on the beta so we don't have the feature yet but I have many plans for it already. I plan on putting out employee hand book on there. Any time we have to figure something out we should make a wiki page describing...
by bpcomp
Tue May 14, 2013 1:47 pm
Forum: Main Forum
Topic: Hygiene List
Replies: 2
Views: 681

Re: Hygiene List

On the appointment screen, look on the upper right hand side for an icon that looks like a pad of paper with the bottom right corner folded. Click that icon then select recall. All you need to do is change the settings (like date) to find all the patients who are due for a recall. You can print the ...
by bpcomp
Fri Apr 19, 2013 11:18 am
Forum: Main Forum
Topic: Bitcoin payments!!!
Replies: 7
Views: 2222

Re: Bitcoin payments!!!

It's interesting but it's not backed by any country or solid assets. I can think of several examples throughout history where a currency rapidly lost value and rampant inflation took over. I think it's rather like the Eurozone in that it looks great until something comes along that it wasn't designe...
by bpcomp
Thu Apr 11, 2013 2:41 pm
Forum: Main Forum
Topic: Computers for a startup
Replies: 15
Views: 7231

Re: Computers for a startup

Spend some money on a beefy server and implement multiple backups. I've come to the conclusion that you should have as much back up as you can afford because you can't afford not to have a backup. If you have a domain, then you'll want to have a backup that gets the whole server and not just the pat...
by bpcomp
Thu Apr 11, 2013 11:25 am
Forum: Main Forum
Topic: Eaglesoft Integration Questions - XDR, Sopro, ICON
Replies: 4
Views: 3355

Re: Eaglesoft Integration Questions - XDR, Sopro, ICON

If you have the twain drivers for the XDR sensors then you can capture xray images into Patterson Imaging by selecting the scanner dialog box and then selecting the appropriate XDR twain driver. I have not used the XDR twain interface so I can not speak for how the actual mechanics of capturing work...
by bpcomp
Thu Apr 11, 2013 7:57 am
Forum: Main Forum
Topic: 12.4.54 takes so long to load up
Replies: 19
Views: 4948

Re: 12.4.54 takes so long to load up

My next guess is to look at the SQL database connection but I'm not sure what to look for.
by bpcomp
Thu Apr 11, 2013 7:41 am
Forum: Main Forum
Topic: 12.4.54 takes so long to load up
Replies: 19
Views: 4948

Re: 12.4.54 takes so long to load up

Just on a lark, check this registry key on the workstations: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Browser\Parameters\IsDomainMaster True or False Should be false on the workstations and if it is not then that workstation might be conflicting with the server over who is the Master Bro...
by bpcomp
Thu Apr 11, 2013 7:10 am
Forum: Main Forum
Topic: 12.4.54 takes so long to load up
Replies: 19
Views: 4948

Re: 12.4.54 takes so long to load up

Those kinds of coincidences have led me wrong before but I'll take your word that we arn't looking at a network issue. Are you running a domain or peer to peer network?
by bpcomp
Wed Apr 10, 2013 2:30 pm
Forum: Main Forum
Topic: 12.4.54 takes so long to load up
Replies: 19
Views: 4948

Re: 12.4.54 takes so long to load up

Try going to (tools/misc tools/test latency) and see what results you get. For reference my results are: Min round trip to database 3ms Average round trip to database 7.9ms Max round trip to database 17ms If you have high latency then you probably have an issue with your network communication somewh...
by bpcomp
Thu Mar 21, 2013 7:48 am
Forum: Main Forum
Topic: Need a Query
Replies: 9
Views: 1795

Re: Need a Query

As a quick tutorial for anyone wanting to use this query in your own office, you need to run two other queries first to gather some information. First run: SELECT * FROM provider Change format from "human-readable" to "raw" and you will see the ProvNum. Next query to run is: SELECT * FROM operatory ...
by bpcomp
Wed Mar 20, 2013 11:48 am
Forum: Main Forum
Topic: treatment plan
Replies: 1
Views: 436

Re: treatment plan

Go to Setup/Modules and then click the tab "Treat' Plan". From there you can permanently change your treatment plan wording.
by bpcomp
Thu Mar 14, 2013 2:52 pm
Forum: Main Forum
Topic: Bug in Pt's w/ apt search (#247) and #290
Replies: 3
Views: 961

Re: Bug in Pt's w/ apt search (#247) and #290

I was able to replicate and see that it does not return any results for patients who don't have insurance. I wasn't able to figure out why though.
by bpcomp
Thu Mar 07, 2013 7:53 am
Forum: Main Forum
Topic: Lab slips to be automatically saved to images?
Replies: 5
Views: 1156

Re: Lab slips to be automatically saved to images?

You could create a pdf from the edit lab slip screen and then import that pdf into the patient's images. It's not a one button smooth way to do it, but it is a way.
by bpcomp
Wed Mar 06, 2013 9:34 am
Forum: Advanced Topics
Topic: virtualbox question
Replies: 23
Views: 12213

Re: virtualbox question

I have done some research on this and we are using VMware to virtualize on top of Linux. After all my research, the conclusion I came to is that it is not a good idea to depend on snapshots for backup. They are a very useful feature when testing updates or trying new software but are not reliable fo...
by bpcomp
Tue Mar 05, 2013 11:30 am
Forum: Main Forum
Topic: Need help: "piress" MySQL virus
Replies: 2
Views: 1822

Re: Need help: "piress" MySQL virus

It may be a pain but my method would be to format and reinstall the test computer at home. Since we don't know how the virus got in or how it may come back. I spend less time overall by doing that rather than trying to clean the system out because I usually end up having to go back to that computer ...
by bpcomp
Thu Feb 28, 2013 7:52 pm
Forum: Main Forum
Topic: Disabled Recall
Replies: 14
Views: 2762

Re: Disabled Recall

I'm unable to test the query at the moment but you can try it. If it doesn't work then I'll have to debug it later.

SELECT patient.FName, patient.LName, recall.IsDisabled, recall.Note
FROM patient, recall

INNER JOIN patient.PatNum ON recall.PatNum

WHERE recall.IsDisabled = TRUE