Search found 306 matches
- Thu May 24, 2018 7:18 am
- Forum: Main Forum
- Topic: *Syncthing* FREE PC to PC sync between multiple offices
- Replies: 6
- Views: 31473
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.
- Wed May 23, 2018 8:30 am
- Forum: Main Forum
- Topic: Patient appointment QR code
- Replies: 3
- Views: 19450
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...
- Wed May 23, 2018 7:48 am
- Forum: Main Forum
- Topic: *Syncthing* FREE PC to PC sync between multiple offices
- Replies: 6
- Views: 31473
Re: *Syncthing* FREE PC to PC sync between multiple offices
Looks like this handles the A-Z folder. How do you handle the database?
- Tue May 22, 2018 11:54 am
- Forum: Sharing
- Topic: Automation
- Replies: 6
- Views: 48936
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...
- Tue May 15, 2018 7:29 am
- Forum: Sharing
- Topic: Automation
- Replies: 6
- Views: 48936
Re: Automation
I'm sure it could, you would just have to write the script that performs the actions.
- Fri Mar 30, 2018 2:39 pm
- Forum: Advanced Topics
- Topic: TLS versions and DB engines
- Replies: 7
- Views: 17719
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...
- Mon Mar 19, 2018 11:45 am
- Forum: Main Forum
- Topic: Dr. Old and Dr. Young
- Replies: 2
- Views: 7438
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.
As far as I know, there is no tool or functionality that would allow for doing it yourself.
- Fri Feb 16, 2018 12:26 pm
- Forum: Main Forum
- Topic: Advanced features- what are your favorites?
- Replies: 6
- Views: 17230
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.
- Wed Feb 14, 2018 3:06 pm
- Forum: Advanced Topics
- Topic: Stability of OD in virtualized environments
- Replies: 9
- Views: 25217
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.
- Wed Feb 14, 2018 10:52 am
- Forum: Main Forum
- Topic: Advanced features- what are your favorites?
- Replies: 6
- Views: 17230
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...
- Tue Feb 13, 2018 6:27 am
- Forum: Advanced Topics
- Topic: Stability of OD in virtualized environments
- Replies: 9
- Views: 25217
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...
- Thu Feb 08, 2018 3:13 pm
- Forum: Main Forum
- Topic: Warning of inactive pation
- Replies: 6
- Views: 17038
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 ...
- Wed Feb 07, 2018 12:43 pm
- Forum: Advanced Topics
- Topic: Stability of OD in virtualized environments
- Replies: 9
- Views: 25217
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...
- Tue Feb 06, 2018 2:58 pm
- Forum: Advanced Topics
- Topic: Stability of OD in virtualized environments
- Replies: 9
- Views: 25217
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...
- Tue Jan 23, 2018 1:04 pm
- Forum: Main Forum
- Topic: Multiple copies of OD on same workstation?
- Replies: 5
- Views: 12043
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).
- Tue Jan 23, 2018 10:57 am
- Forum: Main Forum
- Topic: Dentrix vs. Open Dental
- Replies: 16
- Views: 52671
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...
- Thu Jan 18, 2018 12:48 pm
- Forum: Main Forum
- Topic: File path too long to copy
- Replies: 7
- Views: 17419
Re: File path too long to copy
Glad you got it resolved. Good luck with the rest of your migration!
- Thu Jan 18, 2018 9:34 am
- Forum: Main Forum
- Topic: File path too long to copy
- Replies: 7
- Views: 17419
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...
- Thu Jan 18, 2018 9:13 am
- Forum: Main Forum
- Topic: File path too long to copy
- Replies: 7
- Views: 17419
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.
- Thu Jan 18, 2018 7:58 am
- Forum: Main Forum
- Topic: File path too long to copy
- Replies: 7
- Views: 17419
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...
- Tue Jan 16, 2018 8:28 am
- Forum: Main Forum
- Topic: Wrong patient's name on Pan
- Replies: 1
- Views: 5367
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.
- Tue Dec 19, 2017 10:16 am
- Forum: Main Forum
- Topic: Measuring endo files on images
- Replies: 2
- Views: 6608
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.
- Tue Dec 19, 2017 10:13 am
- Forum: Main Forum
- Topic: Thank you OD staff
- Replies: 2
- Views: 6065
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?
- Fri Jul 21, 2017 3:31 pm
- Forum: Main Forum
- Topic: Looking for ideas for a better practice merge solution
- Replies: 6
- Views: 20997
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...
- Tue Jul 11, 2017 8:36 am
- Forum: Main Forum
- Topic: Windows 10 or 7 for new practice
- Replies: 6
- Views: 20555
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 ...
- Fri Jul 07, 2017 8:30 am
- Forum: Main Forum
- Topic: Best practices
- Replies: 8
- Views: 26238
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...
- Wed Jul 05, 2017 4:39 pm
- Forum: Main Forum
- Topic: Best practices
- Replies: 8
- Views: 26238
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...
- Wed May 17, 2017 1:27 pm
- Forum: Main Forum
- Topic: X ray system with OD
- Replies: 6
- Views: 23521
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...
- Thu May 11, 2017 7:45 am
- Forum: Main Forum
- Topic: Open Dental on a domain controller
- Replies: 2
- Views: 7981
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.
- Fri Jan 20, 2017 9:58 am
- Forum: Main Forum
- Topic: Search for openings.
- Replies: 1
- Views: 6143
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.
- Thu Jan 12, 2017 12:22 pm
- Forum: Main Forum
- Topic: OD, Win10 and PDF
- Replies: 3
- Views: 10047
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...
- Wed Oct 05, 2016 10:02 am
- Forum: Main Forum
- Topic: dummy codes?
- Replies: 7
- Views: 21449
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.
- Wed Jul 13, 2016 2:40 pm
- Forum: Main Forum
- Topic: Open Dental being shut down by virus scanner?
- Replies: 3
- Views: 10419
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...
- Wed Jun 22, 2016 4:54 pm
- Forum: Main Forum
- Topic: virtual s/w
- Replies: 7
- Views: 31968
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...
- Wed Jun 22, 2016 4:28 pm
- Forum: Main Forum
- Topic: NEED URGENT HELP FOR FINDING A FEW SPECIFIC REPORTS!!!
- Replies: 3
- Views: 9825
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.
This page describes how to run the query http://www.opendental.com/manual/queryrun.html.
Good luck.
- Fri Jun 10, 2016 7:44 am
- Forum: Main Forum
- Topic: Backup Software Recommendations
- Replies: 1
- Views: 6590
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
viewtopic.php?f=1&t=5544
- Thu Apr 21, 2016 7:25 am
- Forum: Main Forum
- Topic: HW - PC Stick
- Replies: 2
- Views: 8042
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 ...
- 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: 29000
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 ...
- Tue Apr 05, 2016 4:35 pm
- Forum: Main Forum
- Topic: Inventory control
- Replies: 3
- Views: 9101
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?
- Mon Apr 04, 2016 8:27 am
- Forum: Advanced Topics
- Topic: Romexis Error
- Replies: 2
- Views: 17246
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...
- Mon Apr 04, 2016 8:21 am
- Forum: Main Forum
- Topic: server died, back up works,next step
- Replies: 1
- Views: 5612
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...
- 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: 29000
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...
- 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: 29000
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 ...
- Tue Mar 22, 2016 2:53 pm
- Forum: Main Forum
- Topic: Mapped Drives Lost when Updating Open Dental
- Replies: 5
- Views: 13701
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...
- Tue Mar 22, 2016 2:39 pm
- Forum: Main Forum
- Topic: Patient Info Custom Fields
- Replies: 4
- Views: 11399
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...
- Tue Mar 15, 2016 1:28 pm
- Forum: Main Forum
- Topic: OD calendar sync with Google
- Replies: 5
- Views: 17378
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 ...
- 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: 17245
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.
- Tue Mar 15, 2016 8:45 am
- Forum: Main Forum
- Topic: OD calendar sync with Google
- Replies: 5
- Views: 17378
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...
- 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: 17245
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 %...
- Thu Feb 25, 2016 9:29 am
- Forum: Advanced Topics
- Topic: Any purge tool developed in the last 6 years?
- Replies: 4
- Views: 11664
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...
- Thu Feb 25, 2016 8:48 am
- Forum: Advanced Topics
- Topic: Any purge tool developed in the last 6 years?
- Replies: 4
- Views: 11664
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.
- Thu Feb 25, 2016 7:49 am
- Forum: Main Forum
- Topic: Open dental, assistant, clinician and assistant time
- Replies: 1
- Views: 5400
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.
- Tue Feb 23, 2016 7:32 am
- Forum: Main Forum
- Topic: Backups
- Replies: 2
- Views: 9352
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...
- Tue Feb 23, 2016 7:23 am
- Forum: Main Forum
- Topic: Exporting all of my employees timesheets
- Replies: 3
- Views: 9584
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...
- Tue Feb 23, 2016 7:16 am
- Forum: Main Forum
- Topic: Missing Claim
- Replies: 2
- Views: 7000
Re: Missing Claim
Try running the database maintenance tool to see if that helps fix he problem. (Tools/Database Maintenance)
- Tue Feb 23, 2016 7:12 am
- Forum: Main Forum
- Topic: Dentrix Ascend to Open Dental
- Replies: 6
- Views: 19160
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 ...
- Wed Dec 23, 2015 7:54 am
- Forum: Main Forum
- Topic: Dentrix Ascend to Open Dental
- Replies: 6
- Views: 19160
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...
- Thu Nov 19, 2015 3:10 pm
- Forum: Main Forum
- Topic: Slow initial delay(Network) on workstation
- Replies: 14
- Views: 30210
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...
- Tue Nov 17, 2015 9:11 am
- Forum: Main Forum
- Topic: Slow initial delay(Network) on workstation
- Replies: 14
- Views: 30210
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?
- Thu Nov 12, 2015 6:57 am
- Forum: Main Forum
- Topic: Slow initial delay(Network) on workstation
- Replies: 14
- Views: 30210
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...
- Tue Nov 03, 2015 7:10 am
- Forum: Main Forum
- Topic: Recall for two cleaning per 12 months
- Replies: 1
- Views: 5714
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 ...
- Tue Nov 03, 2015 6:59 am
- Forum: Main Forum
- Topic: Patient portion on schedule
- Replies: 1
- Views: 5655
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 ...
- Mon Nov 02, 2015 7:44 am
- Forum: Advanced Topics
- Topic: Appointment QR code idea.
- Replies: 2
- Views: 8737
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...
- Fri Oct 30, 2015 4:43 pm
- Forum: Main Forum
- Topic: Viewing .pdf's in Images module
- Replies: 12
- Views: 23116
Re: Viewing .pdf's in Images module
Well it looks like there is already an issue 

- Thu Oct 08, 2015 10:45 am
- Forum: Advanced Topics
- Topic: Appointment QR code idea.
- Replies: 2
- Views: 8737
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...
- Thu Oct 08, 2015 9:38 am
- Forum: Main Forum
- Topic: Viewing .pdf's in Images module
- Replies: 12
- Views: 23116
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.
- Thu Oct 08, 2015 9:16 am
- Forum: Main Forum
- Topic: Viewing .pdf's in Images module
- Replies: 12
- Views: 23116
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?
- Thu Oct 08, 2015 8:00 am
- Forum: Main Forum
- Topic: Viewing .pdf's in Images module
- Replies: 12
- Views: 23116
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.
- Tue Sep 15, 2015 8:42 am
- Forum: Main Forum
- Topic: Computers for a startup
- Replies: 15
- Views: 30852
Re: Computers for a startup
We backup the whole virtual server but it wouldn't hurt to do a separate data only backup.
- Wed Aug 19, 2015 3:42 pm
- Forum: Main Forum
- Topic: ScanX Imaging software
- Replies: 13
- Views: 31339
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.
- Mon Jul 27, 2015 7:48 am
- Forum: Main Forum
- Topic: List of Links to TWAIN Drivers for All Sensors
- Replies: 1
- Views: 5256
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...
- Fri Mar 06, 2015 8:50 am
- Forum: Main Forum
- Topic: Report - separate cash from credit card for patient income
- Replies: 6
- Views: 10797
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.
Have a good day.
Code: Select all
select paytype, sum(payamt) from payment where paydate = '2015-02-24' group by paytype
- Fri Mar 06, 2015 8:04 am
- Forum: Main Forum
- Topic: Creating a Claim with Bilateral Space Maintainers
- Replies: 4
- Views: 10387
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.
- Fri Feb 27, 2015 3:12 pm
- Forum: Main Forum
- Topic: Report - separate cash from credit card for patient income
- Replies: 6
- Views: 10797
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 ...
- Fri Feb 27, 2015 6:36 am
- Forum: Main Forum
- Topic: Report - separate cash from credit card for patient income
- Replies: 6
- Views: 10797
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.
If you can't find a query that does what you want, it is possible to write one or have one written for you.
- Thu Jan 29, 2015 7:53 am
- Forum: Main Forum
- Topic: Notes signing or not
- Replies: 5
- Views: 10704
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.
- Wed Jan 28, 2015 8:48 am
- Forum: Main Forum
- Topic: Notes signing or not
- Replies: 5
- Views: 10704
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.
- Wed Jan 28, 2015 8:43 am
- Forum: Main Forum
- Topic: Open Dental Localization and Calendar
- Replies: 10
- Views: 19634
Re: Open Dental Localization and Calendar
That is great news and I hope it comes through quickly for you.
- Wed Jan 28, 2015 7:46 am
- Forum: Main Forum
- Topic: Prevent Employees From Clocking-in Too Early
- Replies: 7
- Views: 17356
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...
- Tue Jan 27, 2015 1:35 pm
- Forum: Main Forum
- Topic: Prevent Employees From Clocking-in Too Early
- Replies: 7
- Views: 17356
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.
- Mon Jan 26, 2015 10:00 am
- Forum: Main Forum
- Topic: keeping track of stock we are retailing
- Replies: 1
- Views: 4662
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...
- Wed Jan 14, 2015 7:09 am
- Forum: Main Forum
- Topic: Integration with US Postal Service (USPS) address checking
- Replies: 6
- Views: 32852
Re: Integration with US Postal Service (USPS) address checki
Is there a reason not to just use USPS? https://www.usps.com/business/web-tools ... mation.htm
- Tue Jan 13, 2015 8:13 am
- Forum: Main Forum
- Topic: Integration with US Postal Service (USPS) address checking
- Replies: 6
- Views: 32852
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.
- Mon Dec 22, 2014 9:10 am
- Forum: Main Forum
- Topic: Creating a Claim with Bilateral Space Maintainers
- Replies: 4
- Views: 10387
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.
- Tue Sep 30, 2014 8:27 am
- Forum: Main Forum
- Topic: Panoramic images printing with office/patient info
- Replies: 3
- Views: 6758
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...
- Fri Sep 19, 2014 4:27 pm
- Forum: Main Forum
- Topic: Panoramic images printing with office/patient info
- Replies: 3
- Views: 6758
Re: Panoramic images printing with office/patient info
Are you capturing the panos into Open Dental or using other imaging software for patient images?
- Thu Aug 07, 2014 5:03 pm
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
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...
- Wed Aug 06, 2014 5:00 pm
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
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...
- Wed Aug 06, 2014 2:14 pm
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
Re: Backing up with IDRIVE.COM!
idrive handles online only. We have a different backup for local backup.
- Tue Aug 05, 2014 9:26 am
- Forum: Main Forum
- Topic: Keyboard shortcuts - Add to Manual and Search
- Replies: 10
- Views: 15611
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.
- Tue Aug 05, 2014 9:12 am
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
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...
- Thu Jul 31, 2014 8:52 am
- Forum: Main Forum
- Topic: Truecrypt to Bitlocker now?
- Replies: 12
- Views: 18453
Re: Truecrypt to Bitlocker now?
You should decrypt with truecrypt first and then you can use bitlocker.
- Mon Jul 28, 2014 6:53 am
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
Re: Backing up with IDRIVE.COM!
Sorry Justin, what is BAA?
- Fri Jul 25, 2014 10:06 am
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
- Fri Jul 25, 2014 9:45 am
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
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...
- Wed Jul 23, 2014 5:03 pm
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
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...
- Wed Jul 23, 2014 7:47 am
- Forum: Main Forum
- Topic: Backing up with IDRIVE.COM!
- Replies: 22
- Views: 55032
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 ...
- Thu Jul 10, 2014 8:14 am
- Forum: Advanced Topics
- Topic: Locating incorrect Ins Estimate Remaining
- Replies: 3
- Views: 8301
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...
- 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: 5958
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...
- Tue Jul 08, 2014 7:00 am
- Forum: Main Forum
- Topic: unscheduled apointment list
- Replies: 6
- Views: 10534
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.
- Thu Jun 26, 2014 3:09 pm
- Forum: Main Forum
- Topic: Open Dental Localization and Calendar
- Replies: 10
- Views: 19634
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.
- Wed Jun 25, 2014 5:17 pm
- Forum: Sharing
- Topic: Automation
- Replies: 6
- Views: 48936
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...
- Wed Jun 25, 2014 5:10 pm
- Forum: Main Forum
- Topic: Visix any good?
- Replies: 10
- Views: 23651
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...
- 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: 9947
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...
- Tue May 20, 2014 7:48 am
- Forum: Main Forum
- Topic: Standard lab instructions
- Replies: 7
- Views: 12420
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...
- Mon May 19, 2014 10:42 am
- Forum: Main Forum
- Topic: Standard lab instructions
- Replies: 7
- Views: 12420
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.
http://www.opendental.com/manual/autonotes.html
If that doesn't fit the bill then reply back and I'll offer another solution.
- Mon May 19, 2014 10:39 am
- Forum: Advanced Topics
- Topic: XP and HIPAA and Virtual Machines?
- Replies: 10
- Views: 37713
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.
- Tue Apr 15, 2014 9:56 am
- Forum: Main Forum
- Topic: ControlScan
- Replies: 2
- Views: 5709
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...
- Tue Apr 15, 2014 9:52 am
- Forum: Main Forum
- Topic: Label maker
- Replies: 8
- Views: 14903
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.
- Tue Apr 15, 2014 9:50 am
- Forum: Main Forum
- Topic: Root tip
- Replies: 1
- Views: 4786
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
To learn more about feature request's, see this page:
http://www.opendental.com/manual/featurerequests.html
- Mon Apr 07, 2014 8:07 am
- Forum: Main Forum
- Topic: Windows 7 chart
- Replies: 8
- Views: 13352
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...
- Wed Mar 26, 2014 12:05 pm
- Forum: Advanced Topics
- Topic: New Install
- Replies: 3
- Views: 8343
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.
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.
- Thu Mar 20, 2014 3:35 pm
- Forum: Main Forum
- Topic: Holiday List
- Replies: 1
- Views: 4765
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...
- Fri Mar 07, 2014 7:05 am
- Forum: Main Forum
- Topic: sort on tooth # and date?
- Replies: 1
- Views: 4450
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.
- Fri Mar 07, 2014 6:51 am
- Forum: Main Forum
- Topic: Report for patient conversion rate
- Replies: 1
- Views: 4296
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.
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.
- Fri Mar 07, 2014 6:49 am
- Forum: Main Forum
- Topic: Potential new user seeks users near San Francisco or Marin
- Replies: 1
- Views: 4430
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.
- Fri Feb 07, 2014 9:33 am
- Forum: Main Forum
- Topic: When ins. pays via credit card instead of check
- Replies: 9
- Views: 16575
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.
- Wed Jan 29, 2014 6:32 am
- Forum: Main Forum
- Topic: Built in Backup Question
- Replies: 7
- Views: 16117
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...
- Thu Jan 23, 2014 7:26 am
- Forum: Main Forum
- Topic: When ins. pays via credit card instead of check
- Replies: 9
- Views: 16575
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.
- Thu Jan 23, 2014 7:23 am
- Forum: Main Forum
- Topic: Linking website to database in the office
- Replies: 13
- Views: 20430
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...
- Mon Jan 13, 2014 3:06 pm
- Forum: Main Forum
- Topic: New to OD
- Replies: 2
- Views: 4916
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...
- Thu Dec 12, 2013 12:25 pm
- Forum: Main Forum
- Topic: back up
- Replies: 13
- Views: 21952
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.
- Thu Dec 12, 2013 8:45 am
- Forum: Main Forum
- Topic: back up
- Replies: 13
- Views: 21952
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...
- Tue Nov 19, 2013 11:52 am
- Forum: Sharing
- Topic: Some icons
- Replies: 3
- Views: 41412
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...
- Tue Nov 19, 2013 6:05 am
- Forum: Main Forum
- Topic: back up
- Replies: 13
- Views: 21952
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!
- Mon Nov 18, 2013 9:42 am
- Forum: Main Forum
- Topic: back up
- Replies: 13
- Views: 21952
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...
- Mon Nov 04, 2013 6:34 am
- Forum: Sharing
- Topic: Some icons
- Replies: 3
- Views: 41412
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.
- Thu Oct 17, 2013 11:01 am
- Forum: Main Forum
- Topic: Check when appointment was made
- Replies: 1
- Views: 4324
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...
- Tue Oct 08, 2013 3:43 pm
- Forum: Main Forum
- Topic: Only one person can enter payment in at a time?
- Replies: 2
- Views: 5567
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...
- Mon Oct 07, 2013 10:36 am
- Forum: Main Forum
- Topic: What are you guys using for data encryption?
- Replies: 45
- Views: 105394
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...
- Mon Oct 07, 2013 7:35 am
- Forum: Main Forum
- Topic: Be Afraid, Be Very Afraid... Ransomware
- Replies: 25
- Views: 60334
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...
- Fri Oct 04, 2013 4:41 pm
- Forum: Main Forum
- Topic: Be Afraid, Be Very Afraid... Ransomware
- Replies: 25
- Views: 60334
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 ...
- Tue Sep 24, 2013 3:07 pm
- Forum: Main Forum
- Topic: Need a Positive Review of Open Dental
- Replies: 15
- Views: 33272
- Mon Sep 23, 2013 12:07 pm
- Forum: Main Forum
- Topic: Be Afraid, Be Very Afraid... Ransomware
- Replies: 25
- Views: 60334
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...
- Fri Sep 20, 2013 2:02 pm
- Forum: Main Forum
- Topic: Be Afraid, Be Very Afraid... Ransomware
- Replies: 25
- Views: 60334
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.
- Tue Sep 17, 2013 2:26 pm
- Forum: Main Forum
- Topic: Dentrix to Open Dental Conversion tips and ideas wanted
- Replies: 2
- Views: 7153
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...
- Tue Sep 10, 2013 10:36 am
- Forum: Main Forum
- Topic: multiple provider office, different fees?
- Replies: 6
- Views: 10217
Re: multiple provider office, different fees?
If you go to "Lists/Providers" you can change what fee schedule is used for that provider.
- Thu Aug 29, 2013 10:24 am
- Forum: Main Forum
- Topic: Tracking a group of patients
- Replies: 5
- Views: 8285
Re: Tracking a group of patients
My apologies Dr Hersh. I obviously miss read your original post. Tracking by referral would obviously work great.
- Thu Aug 29, 2013 7:09 am
- Forum: Main Forum
- Topic: Tracking a group of patients
- Replies: 5
- Views: 8285
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...
- Wed Aug 21, 2013 11:48 am
- Forum: Main Forum
- Topic: Keep payments away from RDH
- Replies: 2
- Views: 5767
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...
- Wed Aug 21, 2013 11:09 am
- Forum: Main Forum
- Topic: DirectX 11 & Video Card
- Replies: 18
- Views: 33992
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.
- Tue Aug 20, 2013 2:28 pm
- Forum: Main Forum
- Topic: DirectX 11 & Video Card
- Replies: 18
- Views: 33992
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...
- Tue Aug 20, 2013 1:03 pm
- Forum: Main Forum
- Topic: DirectX 11 & Video Card
- Replies: 18
- Views: 33992
Re: DirectX 11 & Video Card
"Access denied."
No dice yet.
No dice yet.
- Tue Aug 20, 2013 12:46 pm
- Forum: Main Forum
- Topic: Windows Server 2008R2 Backup Question
- Replies: 3
- Views: 7457
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...
- Tue Aug 20, 2013 11:18 am
- Forum: Main Forum
- Topic: DirectX 11 & Video Card
- Replies: 18
- Views: 33992
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?
- Thu Aug 15, 2013 10:26 am
- Forum: Main Forum
- Topic: Picasa integrated to manage images
- Replies: 5
- Views: 8965
Re: Picasa integrated to manage images
Does tagging on computer 1 propagate to computer 2?
- Wed Aug 14, 2013 1:45 pm
- Forum: Main Forum
- Topic: Picasa integrated to manage images
- Replies: 5
- Views: 8965
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.
- Thu Aug 08, 2013 5:01 pm
- Forum: Main Forum
- Topic: Using the Wireless Camera Card
- Replies: 9
- Views: 19175
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...
- Thu Aug 08, 2013 9:38 am
- Forum: Main Forum
- Topic: Switching to Open Dental
- Replies: 7
- Views: 15615
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?
- Thu Aug 08, 2013 9:23 am
- Forum: Main Forum
- Topic: Using the Wireless Camera Card
- Replies: 9
- Views: 19175
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...
- Wed Jul 31, 2013 2:51 pm
- Forum: Main Forum
- Topic: Insurance payment
- Replies: 2
- Views: 5426
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...
- Mon Jul 29, 2013 7:43 am
- Forum: Advanced Topics
- Topic: virtualbox question
- Replies: 23
- Views: 44720
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...
- Wed Jul 24, 2013 2:57 pm
- Forum: Main Forum
- Topic: Best practices for PPOs with OD
- Replies: 10
- Views: 15848
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...
- Tue Jul 23, 2013 12:15 pm
- Forum: Main Forum
- Topic: Best practices for PPOs with OD
- Replies: 10
- Views: 15848
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...
- Wed Jul 17, 2013 1:59 pm
- Forum: Main Forum
- Topic: Insurance payment
- Replies: 2
- Views: 6266
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
- Fri Jul 12, 2013 9:35 am
- Forum: Main Forum
- Topic: Cigna HMO setup.
- Replies: 8
- Views: 17539
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...
- Wed Jul 10, 2013 8:10 am
- Forum: Main Forum
- Topic: Changing pt statuses HELP!
- Replies: 2
- Views: 5608
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...
- Thu Jun 20, 2013 8:05 am
- Forum: Main Forum
- Topic: CRM - Customer relationship management?
- Replies: 12
- Views: 29516
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...
- Thu Jun 20, 2013 7:52 am
- Forum: Main Forum
- Topic: Updating hardware and also need a good back up solution
- Replies: 9
- Views: 19578
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 ...
- Wed Jun 19, 2013 12:26 pm
- Forum: Main Forum
- Topic: Huge CBCT file storage
- Replies: 3
- Views: 7827
- Mon Jun 17, 2013 9:32 am
- Forum: Main Forum
- Topic: Updating hardware and also need a good back up solution
- Replies: 9
- Views: 19578
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.
- Mon Jun 17, 2013 8:29 am
- Forum: Main Forum
- Topic: Huge CBCT file storage
- Replies: 3
- Views: 7827
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 ...
- Fri Jun 14, 2013 8:04 am
- Forum: Main Forum
- Topic: Start Time End Time
- Replies: 2
- Views: 4902
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
From http://www.opendental.com/OpenDentalDoc ... ocedurelog
- Thu Jun 13, 2013 8:50 am
- Forum: Main Forum
- Topic: Best way to transfer files?
- Replies: 9
- Views: 15060
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...
- Thu Jun 13, 2013 8:01 am
- Forum: Main Forum
- Topic: Best way to transfer files?
- Replies: 9
- Views: 15060
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...
- Wed Jun 12, 2013 3:35 pm
- Forum: Main Forum
- Topic: Best way to transfer files?
- Replies: 9
- Views: 15060
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 ...
- Wed Jun 12, 2013 3:19 pm
- Forum: Main Forum
- Topic: 16 weeks using TRS, not a single broken appt
- Replies: 27
- Views: 44450
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...
- Wed Jun 12, 2013 8:24 am
- Forum: Main Forum
- Topic: 16 weeks using TRS, not a single broken appt
- Replies: 27
- Views: 44450
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...
- Tue Jun 11, 2013 12:35 pm
- Forum: Main Forum
- Topic: RAID 0 or 1
- Replies: 8
- Views: 16357
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.
- Tue Jun 11, 2013 12:13 pm
- Forum: Main Forum
- Topic: Steriliser batch tracking
- Replies: 1
- Views: 4398
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...
- Tue Jun 11, 2013 12:04 pm
- Forum: Main Forum
- Topic: Practical use of Task Lists
- Replies: 1
- Views: 4286
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...
- Tue Jun 11, 2013 11:55 am
- Forum: Main Forum
- Topic: How can I learn to write my own query's
- Replies: 3
- Views: 6462
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 ...
- Fri May 31, 2013 4:23 pm
- Forum: Main Forum
- Topic: Gingival graft paint type
- Replies: 2
- Views: 5767
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.
- Fri May 31, 2013 1:31 pm
- Forum: Main Forum
- Topic: Open Dental missed some completed procedures for billing
- Replies: 7
- Views: 10995
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'...
- Fri May 31, 2013 11:41 am
- Forum: Main Forum
- Topic: Open Dental missed some completed procedures for billing
- Replies: 7
- Views: 10995
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?
- Fri May 31, 2013 10:38 am
- Forum: Main Forum
- Topic: Open Dental missed some completed procedures for billing
- Replies: 7
- Views: 10995
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?
- Fri May 31, 2013 8:26 am
- Forum: Main Forum
- Topic: Trying to build 12.4 in Release mode
- Replies: 2
- Views: 5082
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.
- Thu May 30, 2013 2:37 pm
- Forum: Main Forum
- Topic: Open Dental Dexis issue on one laptop only
- Replies: 3
- Views: 7405
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.
- Thu May 30, 2013 11:17 am
- Forum: Main Forum
- Topic: Preventing internal theft.
- Replies: 6
- Views: 11389
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 ...
- Wed May 29, 2013 7:44 am
- Forum: Main Forum
- Topic: Addresses on envelopes - can it be done?
- Replies: 6
- Views: 11015
Re: Addresses on envelopes - can it be done?
Why does the consent form work better than a custom sheet or something else?
- Wed May 29, 2013 6:45 am
- Forum: Main Forum
- Topic: Addresses on envelopes - can it be done?
- Replies: 6
- Views: 11015
Re: Addresses on envelopes - can it be done?
Perfect, that is a great solution. Thank you boboffice.
- Fri May 17, 2013 11:01 am
- Forum: Main Forum
- Topic: Addresses on envelopes - can it be done?
- Replies: 6
- Views: 11015
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.
- Wed May 15, 2013 2:26 pm
- Forum: Main Forum
- Topic: ISO tooth numbering
- Replies: 4
- Views: 8064
Re: ISO tooth numbering
Those test patients can take a lot of abuse.
- Tue May 14, 2013 4:37 pm
- Forum: Main Forum
- Topic: Wiki
- Replies: 10
- Views: 23842
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...
- Tue May 14, 2013 1:47 pm
- Forum: Main Forum
- Topic: Hygiene List
- Replies: 2
- Views: 4805
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 ...
- Fri Apr 19, 2013 11:18 am
- Forum: Main Forum
- Topic: Bitcoin payments!!!
- Replies: 7
- Views: 13331
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...
- Thu Apr 11, 2013 2:41 pm
- Forum: Main Forum
- Topic: Computers for a startup
- Replies: 15
- Views: 30852
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...
- Thu Apr 11, 2013 11:25 am
- Forum: Main Forum
- Topic: Eaglesoft Integration Questions - XDR, Sopro, ICON
- Replies: 4
- Views: 10300
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...
- Thu Apr 11, 2013 7:57 am
- Forum: Main Forum
- Topic: 12.4.54 takes so long to load up
- Replies: 19
- Views: 31833
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.
- Thu Apr 11, 2013 7:41 am
- Forum: Main Forum
- Topic: 12.4.54 takes so long to load up
- Replies: 19
- Views: 31833
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...
- Thu Apr 11, 2013 7:10 am
- Forum: Main Forum
- Topic: 12.4.54 takes so long to load up
- Replies: 19
- Views: 31833
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?
- Wed Apr 10, 2013 2:30 pm
- Forum: Main Forum
- Topic: 12.4.54 takes so long to load up
- Replies: 19
- Views: 31833
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...
- Thu Mar 21, 2013 7:48 am
- Forum: Main Forum
- Topic: Need a Query
- Replies: 9
- Views: 11200
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 ...
- Wed Mar 20, 2013 2:07 pm
- Forum: Main Forum
- Topic: Need a Query
- Replies: 9
- Views: 11200
- Wed Mar 20, 2013 11:48 am
- Forum: Main Forum
- Topic: treatment plan
- Replies: 1
- Views: 4267
Re: treatment plan
Go to Setup/Modules and then click the tab "Treat' Plan". From there you can permanently change your treatment plan wording.
- Thu Mar 14, 2013 2:52 pm
- Forum: Main Forum
- Topic: Bug in Pt's w/ apt search (#247) and #290
- Replies: 3
- Views: 6610
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.
- Thu Mar 07, 2013 6:53 am
- Forum: Main Forum
- Topic: Lab slips to be automatically saved to images?
- Replies: 5
- Views: 9140
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.
- Wed Mar 06, 2013 8:34 am
- Forum: Advanced Topics
- Topic: virtualbox question
- Replies: 23
- Views: 44720
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...
- Tue Mar 05, 2013 10:30 am
- Forum: Main Forum
- Topic: Need help: "piress" MySQL virus
- Replies: 2
- Views: 6298
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 ...
- Thu Feb 28, 2013 6:52 pm
- Forum: Main Forum
- Topic: Disabled Recall
- Replies: 14
- Views: 21365
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
SELECT patient.FName, patient.LName, recall.IsDisabled, recall.Note
FROM patient, recall
INNER JOIN patient.PatNum ON recall.PatNum
WHERE recall.IsDisabled = TRUE