Search found 711 matches

by cmcgehee
Mon May 13, 2019 7:58 am
Forum: Developers
Topic: Missing form FormWebChatTool.cs
Replies: 3
Views: 5690

Re: Missing form FormWebChatTool.cs

I don't see any reason why this should cause an error. The class FormWebChatTools does exist in the Open Dental project. Maybe you could try reloading the Open Dental project or relaunching Visual Studio.
by cmcgehee
Tue Apr 30, 2019 6:04 pm
Forum: Advanced Topics
Topic: Middle Tier Security
Replies: 1
Views: 6302

Re: Middle Tier Security

1. By default every IIS request is logged, typically in the %SystemDrive%\inetpub\logs\LogFiles folder. The information logged will be very bare boned so you probably won't be able to distinguish login attempts. Middle tier does not have the ability to do any additional logging. 2. I would say secur...
by cmcgehee
Tue Apr 30, 2019 7:59 am
Forum: Main Forum
Topic: Grid in Edit claims window only shows one row
Replies: 2
Views: 4077

Re: Grid in Edit claims window only shows one row

It looks like we fixed this issue in 18.3.40. You should be able to update and see the proc grid better in that window.
by cmcgehee
Tue Apr 30, 2019 7:56 am
Forum: Main Forum
Topic: Unscheduled in chart
Replies: 1
Views: 3292

Re: Unscheduled in chart

In this case, you can probably delete the unscheduled appt and perhaps also delete the procedures attached to the appt. If you haven't upgraded to version 18.4, you might want to; it will prompt the user when trying to schedule an appointment if there is an unscheduled appointment for that patient.
by cmcgehee
Mon Apr 29, 2019 8:03 am
Forum: Main Forum
Topic: Kilograms
Replies: 2
Views: 4126

Re: Kilograms

There is not a way to input as kilograms. You are welcome to add that as a feature request.
https://www.opendental.com/manual/featurerequests.html.
by cmcgehee
Wed Apr 24, 2019 1:53 pm
Forum: Developers
Topic: C# 7 is now necessary
Replies: 0
Views: 14391

C# 7 is now necessary

Recently, we developers at Open Dental moved to Visual Studio 2019. We have started committing code that utilizes features from C# 7. So in order to compile Open Dental, you will need to use the compiler for C# 7. There are two ways you can do this: 1) Upgrade to Visual Studio 2017 or later; or 2) I...
by cmcgehee
Tue Apr 23, 2019 8:36 am
Forum: Advanced Topics
Topic: Export Statement to Excel?
Replies: 1
Views: 5842

Re: Export Statement to Excel?

Theoretically, you could run a user query and then export the results to Excel. There are a lot of complex queries that are run to generate the patient account history, so there may not be one that does that on our Query Examples page.
https://opendentalsoft.com:1943/ODQuery ... yList.aspx
by cmcgehee
Mon Apr 22, 2019 8:33 am
Forum: Developers
Topic: Integration of Open Dental Database
Replies: 3
Views: 6731

Re: Integration of Open Dental Database

Hi Kiran, You can test out our API using the API key uTCUIGl4sTWfvKWO with the endpoint https://api.opendental.com. Our documentation explains in more detail: https://www.opendental.com/resources/OpenDentalFHIR19-1Spec.pdf . If you think that the API has everything you need for your integration, we ...
by cmcgehee
Mon Apr 08, 2019 3:16 pm
Forum: Main Forum
Topic: recall frequency limit issue
Replies: 2
Views: 4099

Re: recall frequency limit issue

The best way to submit a bug report is to call our support line at 503-363-5432.
by cmcgehee
Mon Apr 08, 2019 3:15 pm
Forum: Main Forum
Topic: oryx integration v19.1
Replies: 2
Views: 6550

Re: oryx integration v19.1

It's not completely finished yet, but when it is, you will be able to launch Oryx from Open Dental, it will pull the patient info from Open Dental to create the patient in Oryx, you'll choose the procedures you want to treatment plan, then Oryx will push those new procedure into Open Dental. Oryx wi...
by cmcgehee
Thu Mar 28, 2019 6:01 pm
Forum: Developers
Topic: Open Dental - OmniDefend: Hook Request
Replies: 9
Views: 10012

Re: Open Dental - OmniDefend: Hook Request

Our company policy is to only backport hook requests to the beta version, and I'm hesitant to make an exception here because the app.config change we made is more intrusive than a typical hook.
by cmcgehee
Tue Mar 26, 2019 12:17 pm
Forum: Developers
Topic: Open Dental - OmniDefend: Hook Request
Replies: 9
Views: 10012

Re: Open Dental - OmniDefend: Hook Request

We changed several app.config files to this: <dependentAssembly> <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral"/> <bindingRedirect oldVersion="0.0.0.0-12.0.0.0" newVersion="9.0.0.0"/> </dependentAssembly> This should allow any third-party dll that you us...
by cmcgehee
Tue Mar 26, 2019 11:10 am
Forum: Advanced Topics
Topic: FreeDentalConfig.xml obfuscation
Replies: 2
Views: 5829

Re: FreeDentalConfig.xml obfuscation

It might be a bit overkill for your situation, but the best way would be set up Middle Tier and then you just give the outsiders a URL and an Open Dental username and password.
https://www.opendental.com/manual/middletier.html
by cmcgehee
Mon Mar 25, 2019 2:21 pm
Forum: Advanced Topics
Topic: 19.1 beta exception on AWS EC2 server
Replies: 10
Views: 14918

Re: 19.1 beta exception on AWS EC2 server

Here's our internal documentation about what to do when you encounter this issue: Solution 1: Close the eRx window and Open Dental. Clear the cache and cookies out of Internet Explorer. Re-open Open Dental and try eRx again. Solution 2: Add NewCrop to the trusted sites in Internet Explorer. From Wit...
by cmcgehee
Mon Mar 25, 2019 8:28 am
Forum: Advanced Topics
Topic: 19.1 beta exception on AWS EC2 server
Replies: 10
Views: 14918

Re: 19.1 beta exception on AWS EC2 server

You might need to set the "Update Server Name" to the name of the computer where your eConnector is running. This can be set in Setup -> Miscellaneous. If that isn't it, there should be a folder named "Logger" in the eConnector installation folder that should tell you why the eConnector isn't starti...
by cmcgehee
Thu Mar 21, 2019 7:58 am
Forum: Developers
Topic: Open Dental - OmniDefend: Hook Request
Replies: 9
Views: 10012

Re: Open Dental - OmniDefend: Hook Request

I think we'll probably be able to make those changes.
by cmcgehee
Wed Mar 13, 2019 2:46 pm
Forum: Developers
Topic: Open Dental - OmniDefend: Hook Request
Replies: 9
Views: 10012

Re: Open Dental - OmniDefend: Hook Request

These hooks have been added to 18.4.30. I did change a couple of them slightly to match our patterns a little better.
by cmcgehee
Tue Mar 12, 2019 7:52 am
Forum: Main Forum
Topic: How to automate printing of reports?
Replies: 6
Views: 8911

Re: How to automate printing of reports?

Open Dental on its own doesn't have the capability to run queries automatically. I believe that some 3rd-party vendors that integrate with Open Dental have this feature like Divergent Dental or Practice by Numbers.
by cmcgehee
Tue Mar 12, 2019 7:49 am
Forum: Main Forum
Topic: Fee Schedule comparison by procedure codes
Replies: 6
Views: 7359

Re: Fee Schedule comparison by procedure codes

When working with the fee table, you wouldn't want to use the OldCode column at all. Instead use the CodeNum column to join on the procedurecode table. Then you can filter on procedurecode.ProcCode.
by cmcgehee
Mon Mar 11, 2019 8:56 am
Forum: Main Forum
Topic: Fee Schedule comparison by procedure codes
Replies: 6
Views: 7359

Re: Fee Schedule comparison by procedure codes

Would you describe in a little more detail the question that you're asking?
by cmcgehee
Mon Mar 11, 2019 8:54 am
Forum: Developers
Topic: Open Dental - OmniDefend: Hook Request
Replies: 9
Views: 10012

Re: Open Dental - OmniDefend: Hook Request

Softex DEV team, I'm excited to hear that someone is doing biometric authentication. That's something I've been wanting to see happen for a while. We will get these hooks added to the program. I would like to make a suggestion for changing one hook. For hook #5 in ContrChart.Tool_eRx_Click I would r...
by cmcgehee
Thu Mar 07, 2019 8:00 am
Forum: Main Forum
Topic: Fee Schedule comparison by procedure codes
Replies: 6
Views: 7359

Re: Fee Schedule comparison by procedure codes

I looked for a query on https://opendentalsoft.com:1943/ODQuery ... yList.aspx but didn't find any that matched what you're asking for. You can submit a query request for us to write a custom report for you.
by cmcgehee
Mon Feb 25, 2019 8:02 am
Forum: Main Forum
Topic: eServices and a logged in user
Replies: 1
Views: 3164

Re: eServices and a logged in user

That is not required. As long as your eConnector service is running on one computer, nobody needs to be logged on.
by cmcgehee
Mon Feb 18, 2019 8:15 am
Forum: Advanced Topics
Topic: CEMT over Middle Tier
Replies: 12
Views: 15842

Re: CEMT over Middle Tier

I think that when you're hosting two different middle tier instances on the same machine, you might need to change the ApplicationName node in the OpenDentalServerConfig.xml to be unique for each instance. Here's how my file looks: <?xml version="1.0"?> <ConnectionSettings> <DatabaseConnection> <Com...
by cmcgehee
Mon Feb 18, 2019 8:10 am
Forum: Main Forum
Topic: Edit Ins Window
Replies: 3
Views: 4719

Re: Edit Ins Window

It looks like there is an existing feature request for this. It is #2207. https://opendental.com/manual/featurerequests.html shows how you can add votes to feature requests.
by cmcgehee
Thu Feb 14, 2019 5:49 pm
Forum: Advanced Topics
Topic: CEMT over Middle Tier
Replies: 12
Views: 15842

Re: CEMT over Middle Tier

Sometimes my middle tier server doesn't get changes I made from editing the config file. Restarting the app pool or the entire IIS server usually takes care of it.
by cmcgehee
Thu Feb 14, 2019 10:04 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41561

Re: FHIR with trial version

Yes, I will get you a registration key.

However, starting in version 18.4, it will no longer be possible to enable FHIR with a trial version. You will need the full version of Open Dental to use FHIR. Now if you have a developer registration key, you can download the full version and set up FHIR.
by cmcgehee
Wed Feb 13, 2019 7:47 am
Forum: Advanced Topics
Topic: human readable in MySQL
Replies: 5
Views: 9233

Re: human readable in MySQL

I believe that in the program we display the carrier name in the insplan.PlanNum column. So you would use the insplan.CarrierNum to join to the carrier table to get the CarrierName.
by cmcgehee
Wed Feb 13, 2019 7:43 am
Forum: Main Forum
Topic: Edit Ins Window
Replies: 3
Views: 4719

Re: Edit Ins Window

That ability is not currently available, however, it will be in version 19.1 when it's released.
by cmcgehee
Tue Feb 12, 2019 7:45 am
Forum: Advanced Topics
Topic: human readable in MySQL
Replies: 5
Views: 9233

Re: human readable in MySQL

To show that in MySQL Workbench, you would either need to join onto the table that has the name of item or you would have to hand code a case statement to translate enum values into English names. For example with appointment status, https://www.opendental.com/OpenDentalDocumentation18-3.xml#appoint...
by cmcgehee
Tue Feb 12, 2019 7:40 am
Forum: Main Forum
Topic: Using AFTERPAY or ZIPPAY
Replies: 2
Views: 4186

Re: Using AFTERPAY or ZIPPAY

It is not. You could still probably use those companies; you would just have to manually enter payments into Open Dental.
by cmcgehee
Tue Jan 15, 2019 5:29 pm
Forum: Main Forum
Topic: Voice Perio Charting
Replies: 5
Views: 6592

Re: Voice Perio Charting

I would submit a feature request to improve the speed of voice perio charting.
https://opendental.com/manual/featurerequests.html
by cmcgehee
Tue Jan 15, 2019 7:39 am
Forum: Main Forum
Topic: Voice Perio Charting
Replies: 5
Views: 6592

Re: Voice Perio Charting

You could try turning off feedback and see if that improves the speed. When you open the perio chart and click the mic, say the command "stop giving feedback". More commands can be found at https://www.opendental.com/manual/perio ... voice.html.
by cmcgehee
Mon Jan 14, 2019 6:01 pm
Forum: Main Forum
Topic: Getting rid of insurance write-offs
Replies: 1
Views: 3014

Re: Getting rid of insurance write-offs

If you're wanting to see your expected production on each appointment in the Appointment module, you can edit the appointment view to not display "Production" and instead display "Net Production". Details on how to do this can be found https://www.opendental.com/manual/appointmentvieweditwindow.html .
by cmcgehee
Thu Jan 10, 2019 1:39 pm
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 10688

Re: Automation Event Trigger

It will not. Our plugin system is designed so that we can add new parameters to an existing hook without affecting other developers who are already using that hook.
by cmcgehee
Wed Jan 09, 2019 7:47 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 10688

Re: Automation Event Trigger

I have added trigger type to the existing AutomationL.Trigger_CreateCommlog_start hook. It will be available in 18.4.14.
by cmcgehee
Tue Jan 08, 2019 7:43 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 10688

Re: Automation Event Trigger

We will implement the hook in 18.4.

The ScheduledProcedure and CompletedProcedure are not designed to pass in the AptNum since they are concerned directly with procedures, not appointments.
by cmcgehee
Mon Jan 07, 2019 8:36 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 10688

Re: Automation Event Trigger

For each time that I triggered an automation event for the CreateAppt and CreateApptNewPat triggers, the patnum and the aptnum were passed in properly. Can you detail the steps that you took where the aptnum was 0?
by cmcgehee
Mon Jan 07, 2019 8:05 am
Forum: Advanced Topics
Topic: Avoiding server conflicts
Replies: 13
Views: 16670

Re: Avoiding server conflicts

Our recommendation is to use a database that has 0 real patient data present. If you do decide to develop against a copy of your live data, I would say to do it on a VM that has no internet access, and to never run the Open Dental Service or the eConnector against that database.
by cmcgehee
Mon Jan 07, 2019 8:01 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 10688

Re: Automation Event Trigger

We can create a new hook that includes the trigger type for you. Are there any other parameters you would like us to pass in to the hook?

I'll look into why the AptNum is 0 in certain cases.
by cmcgehee
Thu Jan 03, 2019 3:26 pm
Forum: Advanced Topics
Topic: Avoiding server conflicts
Replies: 13
Views: 16670

Re: Avoiding server conflicts

Yes, we do issue developer registration keys. Throw an email over to vendor.relations@opendental.com and include your name, the name of our company, and what type of software you're creating. However, developer registration keys are not meant to be used with live patient data. Once you get a develop...
by cmcgehee
Wed Dec 26, 2018 7:50 am
Forum: Developers
Topic: 18.4 Conversion corrupted DB
Replies: 5
Views: 7904

Re: 18.4 Conversion corrupted DB

This is not an actual bug. The original poster probably installed Open Dental incorrectly on a computer.
by cmcgehee
Mon Dec 17, 2018 8:14 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 10688

Re: Automation Event Trigger

Sure, are you trying to override only the Create Commlog action when creating a new patient appointment, or are you trying to override all actions from the new patient appointment trigger?
by cmcgehee
Thu Dec 13, 2018 8:16 am
Forum: Main Forum
Topic: Login required for OD SVN server?
Replies: 3
Views: 5201

Re: Login required for OD SVN server?

We just switched to a new SVN server, and we are working on allowing source code download without login.
by cmcgehee
Wed Dec 12, 2018 7:54 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41561

Re: FHIR with trial version

1. Is there any API endpoint which provides patient's treatment plan containing procedures codes(CDTs)? There is not, although one of my coworkers just started writing the code for this. 2. Is there any API endpoint which provides patient's insurance details such as subscriber_id, insurance provide...
by cmcgehee
Tue Dec 11, 2018 2:07 pm
Forum: Developers
Topic: Hook Requests
Replies: 6
Views: 7090

Re: Hook Requests

I have added these two hooks and made SelectTreeNode public. These will be available in version 18.4.3.
by cmcgehee
Mon Dec 10, 2018 8:31 am
Forum: Developers
Topic: Hook Requests
Replies: 6
Views: 7090

Re: Hook Requests

Yep, I can add those, too.
by cmcgehee
Mon Dec 10, 2018 8:11 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41561

Re: FHIR with trial version

I'll send you a private message as well.
by cmcgehee
Wed Nov 28, 2018 7:50 am
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 5314

Re: Raw email tool

That makes sense. My guess is that the rest of the rows in your emailmessage table are emails that don't have anything in the RawEmailIn column. The raw email tool is only meant to clean up that column; it doesn't clear out the BodyText column because you would be losing communication data if it did.
by cmcgehee
Mon Nov 26, 2018 12:26 pm
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 19364

Re: Daily Production goals

Irfan, in order for Clinic 1 to not include your provider on the goal when you are only scheduled at Clinic 3, you should go the Appointment Module preferences and check "Appointment module production use operatories".
by cmcgehee
Mon Nov 26, 2018 8:10 am
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 19364

Re: Daily Production goals

Let me look into this some more and get back to you.
by cmcgehee
Mon Nov 26, 2018 7:52 am
Forum: Developers
Topic: Hook Requests
Replies: 6
Views: 7090

Re: Hook Request: FormConfirmationSetup

Sure, I'll work on getting that added.
by cmcgehee
Thu Nov 15, 2018 7:24 am
Forum: Main Forum
Topic: Create Planned Appointment with Highest priority - Pop-up
Replies: 3
Views: 5095

Re: Create Planned Appointment with Highest priority - Pop-u

I apologize for the annoyance. Many other users have found this feature disruptive. You can turn it off in Setup -> Chart -> Chart Preferences with the "Prompt for Planned Appointment" check box.
https://opendental.com/manual/modulesetupchart.html
by cmcgehee
Wed Nov 14, 2018 8:49 am
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 5314

Re: Raw email tool

Those emails will still show up on the patients' charts. It's just that OD won't be able to link those emails to a row in the email address for the sender. From what I can think of, I don't think it will cause an noticeable problem. What is your motivation for deflating the email message table? Are ...
by cmcgehee
Mon Nov 12, 2018 8:03 am
Forum: Main Forum
Topic: Statement Note
Replies: 2
Views: 3427

Re: Statement Note

On the Billing Options window, click the Defaults button in the center right. In this window you can set the Statement Note. It's labeled as "General Message".
by cmcgehee
Sat Nov 10, 2018 9:10 am
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 5314

Re: Raw email tool

My guess is that you have a lot of email messages that do not have a matching email address. If that's the case, this query would return a high number:
SELECT COUNT(*)
FROM emailmessage m
LEFT JOIN emailaddress a ON a.EmailUsername=m.RecipientAddress
WHERE a.EmailAddressNum IS NULL
by cmcgehee
Tue Nov 06, 2018 10:09 am
Forum: Main Forum
Topic: Frequency Limitations
Replies: 3
Views: 4654

Re: Frequency Limitations

My guess is that when we originally programmed this feature years ago, most insurance companies considered FMX and Pano frequencies together. You can add votes to feature request #1916 if you would like to be able to separate them.
https://www.opendental.com/manual/featurerequests.html
by cmcgehee
Sun Nov 04, 2018 11:11 am
Forum: Developers
Topic: What triggers Patient balance update
Replies: 1
Views: 3213

Re: What triggers Patient balance update

You could update the patient balance from a plugin. Once you have your plugin running, all you would need to do is call the method OpenDentBusiness.Ledgers.ComputeAging().
by cmcgehee
Sun Nov 04, 2018 11:08 am
Forum: Main Forum
Topic: Frequency Limitations
Replies: 3
Views: 4654

Re: Frequency Limitations

My guess is that you are on an older version of Open Dental. Most of these frequency categories were added in 18.2.
by cmcgehee
Thu Nov 01, 2018 9:36 am
Forum: Developers
Topic: Show Popup Alert
Replies: 3
Views: 4834

Re: Show Popup Alert

You could make a popup come up when a new appointment is created. See https://www.opendental.com/manual/automation.html for details. You can create a popup to show whenever a patient is selected https://www.opendental.com/manual/popups.html.
by cmcgehee
Wed Oct 24, 2018 7:42 am
Forum: Developers
Topic: Test Database
Replies: 2
Views: 3869

Re: Test Database

We do not have a large test database available anywhere.
by cmcgehee
Thu Oct 18, 2018 1:36 pm
Forum: Main Forum
Topic: Pay periods semi-monthly
Replies: 4
Views: 4979

Re: Pay periods semi-monthly

There is not that option. Its feature request number is 5029 if you want to add votes to it.
by cmcgehee
Mon Oct 08, 2018 11:43 am
Forum: Advanced Topics
Topic: Forum PMs sitting in outbox?
Replies: 2
Views: 5493

Re: Forum PMs sitting in outbox?

A private message in your Outbox means that the message has been sent, but the other user has not read it yet.
by cmcgehee
Mon Oct 08, 2018 10:49 am
Forum: Main Forum
Topic: Premedicate Flag
Replies: 1
Views: 3070

Re: Premedicate Flag

There is not a way to change that to something other than "Premedicate".
by cmcgehee
Thu Oct 04, 2018 10:45 am
Forum: Main Forum
Topic: APPOINTMENT SCHEDULE
Replies: 2
Views: 3682

Re: APPOINTMENT SCHEDULE

It appears that other customers are having this issue as well. If your Windows settings for Short Date format is "yy-MM-dd", then changing it to "yyyy-MM-dd" should fix this. You may need to make this change on your workstations and your server. After you make this change, open the Provider Edit win...
by cmcgehee
Thu Oct 04, 2018 8:16 am
Forum: Main Forum
Topic: APPOINTMENT SCHEDULE
Replies: 2
Views: 3682

Re: APPOINTMENT SCHEDULE

If term date is giving you problems, you can simply clear it out in the Provider Edit window.
https://www.opendental.com/manual/provi ... indow.html
by cmcgehee
Thu Oct 04, 2018 8:14 am
Forum: Advanced Topics
Topic: Query Help - Production by Insurance Plan
Replies: 5
Views: 9173

Re: Query Help - Production by Insurance Plan

In query 227 the $Patient column is calculated as your office fees minus your insurance estimates. So it will not be the true patient portion if you use writeoffs. In query 1045 the $Prod value is the fees billed to insurance which means that it will include less procedures than the $TotalProd colum...
by cmcgehee
Wed Oct 03, 2018 11:37 am
Forum: Advanced Topics
Topic: Query Help - Production by Insurance Plan
Replies: 5
Views: 9173

Re: Query Help - Production by Insurance Plan

A couple queries from our examples page might give you what you're looking for, particularly 227 or 1045.
http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
by cmcgehee
Mon Oct 01, 2018 5:33 pm
Forum: Main Forum
Topic: 18.3
Replies: 3
Views: 4792

Re: 18.3

As long as you're on support, you should be able to see 18.3 as an update option.
by cmcgehee
Mon Oct 01, 2018 4:58 pm
Forum: Main Forum
Topic: 18.3
Replies: 3
Views: 4792

Re: 18.3

Yes, we released it as the newest beta version about a week and a half ago. It will likely be a couple months until we release it as stable.
by cmcgehee
Mon Oct 01, 2018 2:50 pm
Forum: Main Forum
Topic: Deleting Pre-d?
Replies: 3
Views: 4491

Re: Deleting Pre-d?

It will be in the Treatment Plan module in the Pre Authorizations grid.
by cmcgehee
Mon Oct 01, 2018 12:15 pm
Forum: Main Forum
Topic: Deleting Pre-d?
Replies: 3
Views: 4491

Re: Deleting Pre-d?

Change the status to something other than 'Received' and click 'Delete'.
by cmcgehee
Thu Sep 27, 2018 8:05 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41561

Re: FHIR with trial version

I'll send you a private message, Daniel.
by cmcgehee
Wed Sep 26, 2018 8:00 am
Forum: Main Forum
Topic: New OD feature?
Replies: 3
Views: 5151

Re: New OD feature?

Are you getting texts messages from numbers that are not your dental patients?
by cmcgehee
Thu Sep 20, 2018 4:34 pm
Forum: Main Forum
Topic: Ext in the phone #s
Replies: 1
Views: 3005

Re: Ext in the phone #s

You can put that directly into the end of Work Phone field in the patient in the Edit Information window. This should be fine as long as you don't have any 3rd-party services that use the patient's work phone.
by cmcgehee
Thu Sep 20, 2018 4:32 pm
Forum: Main Forum
Topic: altered progress notes
Replies: 3
Views: 5539

Re: altered progress notes

I don't know that I've heard of such a place. You could probably edit an existing query on http://opendentalsoft.com:1942/ODQueryL ... yList.aspx to get what you want.
by cmcgehee
Thu Sep 20, 2018 8:06 am
Forum: Main Forum
Topic: category percentage vs PPO percentage
Replies: 7
Views: 10463

Re: category percentage vs PPO percentage

It depends on how you have your fee schedules set up on the insurance plan. Suppose your UCR fee on a procedure is $100, the PPO allowed price is $60, and insurance covers 80%. If you attach a fee schedule to your insurance plan and enter $60 for the procedure, then the procedure fee will be reduced...
by cmcgehee
Thu Sep 20, 2018 7:58 am
Forum: Main Forum
Topic: ADOBE READER HELL
Replies: 5
Views: 16181

Re: ADOBE READER HELL

Yes, as of 17.1 we switched to using an embedded Internet Explorer browser for displaying PDFs. Internet Explorer's default PDF reader is Adobe Reader, but you can turn off that plugin and install a different PDF reader. I think at one point I was using Foxit Reader to view PDFs.
by cmcgehee
Wed Sep 19, 2018 10:37 am
Forum: Main Forum
Topic: home Back up
Replies: 3
Views: 6177

Re: home Back up

If you're having trouble finding the location of the database, you can run this query in Open Dental to find where your database is located:
SHOW GLOBAL VARIABLES LIKE '%datadir%';
by cmcgehee
Wed Sep 19, 2018 7:58 am
Forum: Main Forum
Topic: Complete from drop down menu
Replies: 5
Views: 6644

Re: Complete from drop down menu

One of my fellow engineers made it so setting the dropdown to Complete will not add the default note. Will be in version 18.2.25 (which will be stable soon).
by cmcgehee
Mon Sep 17, 2018 10:22 am
Forum: Main Forum
Topic: Complete from drop down menu
Replies: 5
Views: 6644

Re: Complete from drop down menu

Our friend Jason Salmon decided that we will revert behavior back to 17.3 so setting the dropdown to Complete will not add the default note.
by cmcgehee
Mon Sep 17, 2018 9:12 am
Forum: Main Forum
Topic: category percentage vs PPO percentage
Replies: 7
Views: 10463

Re: category percentage vs PPO percentage

There are several benefits to tracking writeoffs: 1) It helps you decide if you want to drop a carrier that you are in network with. If after a couple years, you find that Carrier X is only paying you 30% of your UCR fees, it might save you money to stop accepting patients from that carrier. 2) When...
by cmcgehee
Mon Sep 17, 2018 8:47 am
Forum: Main Forum
Topic: daily production
Replies: 1
Views: 3208

Re: daily production

I would call our support line at 503-363-5432 so we can investigate why your writeoffs are not calculating.
by cmcgehee
Mon Sep 17, 2018 8:45 am
Forum: Main Forum
Topic: Complete from drop down menu
Replies: 5
Views: 6644

Re: Complete from drop down menu

I've started an internal discussion voicing your concern. I'll get back to you once we come to a decision on this topic.
by cmcgehee
Mon Sep 17, 2018 8:21 am
Forum: Main Forum
Topic: Automatic Lab slip?
Replies: 2
Views: 4682

Re: Automatic Lab slip?

I have not seen a feature request for it yet. Feel free to add it yourself.
by cmcgehee
Mon Sep 17, 2018 8:06 am
Forum: Main Forum
Topic: Daily reports showing adjustments
Replies: 3
Views: 4492

Re: Daily reports showing adjustments

You can set this up in Open Dental by restricting user permissions to not be able to edit anything older than 1 day.
by cmcgehee
Tue Sep 11, 2018 9:13 am
Forum: Main Forum
Topic: Changing lab slip due time.
Replies: 4
Views: 6067

Re: Changing lab slip due time.

No, you would have to recompile the Open Dental source code to change this. Or submit a feature request to have us change it. :)
by cmcgehee
Tue Sep 11, 2018 7:41 am
Forum: Main Forum
Topic: Changing lab slip due time.
Replies: 4
Views: 6067

Re: Changing lab slip due time.

Are you asking how to make all lab cases default to be due at 10 AM? It turns out that the 5 PM due time is hard-coded into the program.
by cmcgehee
Mon Sep 10, 2018 3:26 pm
Forum: Main Forum
Topic: Daily reports showing adjustments
Replies: 3
Views: 4492

Re: Daily reports showing adjustments

When you attach a fee schedule to a patient, then when a procedure is charted, the procedure's fee will be pulled from the patient's fee schedule instead of UCR fees. It will not create an adjustment for it. It sounds like Eaglesoft represents in-network fee schedules different than Open Dental. In ...
by cmcgehee
Mon Sep 10, 2018 3:04 pm
Forum: Main Forum
Topic: Scaning EOBS when posting payments
Replies: 4
Views: 6276

Re: Scaning EOBS when posting payments

You can find the EOB by opening up the claim, double-clicking on the Insurance Payment, then clicking on the View EOB button in the lower left.
by cmcgehee
Mon Sep 10, 2018 3:02 pm
Forum: Main Forum
Topic: Making an appointment
Replies: 2
Views: 3789

Re: Making an appointment

There is a preference in Appointment Module Preferences to require a procedure on all appointments: "Appointments require procedures". You can uncheck that preference if you want to be able to make appointments without procedures attached.
by cmcgehee
Mon Sep 10, 2018 2:59 pm
Forum: Main Forum
Topic: category percentage vs PPO percentage
Replies: 7
Views: 10463

Re: category percentage vs PPO percentage

We recommend using category percentage for an insurance plan that you are not in network with. We recommend using PPO play types when you are in network with a carrier. In this situation, PPO is better than category percentage because PPO will calculate write-offs on procedures where you are contrac...
by cmcgehee
Tue Aug 28, 2018 11:43 am
Forum: Main Forum
Topic: HTML code in emails
Replies: 7
Views: 9713

Re: HTML code in emails

You can send any HTML code that you want. And you will need to be on version 18.2 which is currently in beta.
by cmcgehee
Mon Aug 27, 2018 8:57 am
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 19364

Re: Daily Production goals

Yes, the manual is updated with a description of Production Goals: https://opendental.com/manual/productiontotals.html.
Irfan, the provider should only be included in goal calculating for the hours that are scheduled. Can you explain in more detail a situation where the calculation is incorrect?
by cmcgehee
Wed Aug 22, 2018 10:49 am
Forum: Main Forum
Topic: HTML code in emails
Replies: 7
Views: 9713

Re: HTML code in emails

As of 18.2 the only place that has HTML capabilities is the Edit Email Message window. The email templates that are used in this window can be set up as HTML; you would just have to copy some HTML text into the template. Other templates throughout the program (eConfirmations, Web Sched Recall, etc.)...
by cmcgehee
Thu Aug 16, 2018 7:52 am
Forum: Main Forum
Topic: tie recall to urgent med information?
Replies: 2
Views: 4662

Re: tie recall to urgent med information?

I believe the only places the program shows premedicate are the Chart module patient information grid and on appointments if you add that to your appointment view.
by cmcgehee
Thu Aug 09, 2018 5:26 pm
Forum: Main Forum
Topic: Recommended contact list
Replies: 1
Views: 3041

Re: Recommended contact list

We populate that list from addresses from previous emails, so there's not a simple way to remove a contact from that list. If you really wanted it gone, you would have to delete all email messages to or from that address.
by cmcgehee
Tue Aug 07, 2018 3:14 pm
Forum: Main Forum
Topic: Statements
Replies: 4
Views: 8672

Re: Statements

You could remove the "statementReceiptInvoice" field from the Statement sheet and replace it with just "Statement". If you do that, then your invoices and receipts will also say "Statement".
by cmcgehee
Tue Aug 07, 2018 8:32 am
Forum: Developers
Topic: Automatically add pdf to images
Replies: 3
Views: 4888

Re: Automatically add pdf to images

The more our software works like magic the better. :D
by cmcgehee
Mon Aug 06, 2018 2:32 pm
Forum: Developers
Topic: Automatically add pdf to images
Replies: 3
Views: 4888

Re: Automatically add pdf to images

The only way that would be possible is to make your program like a plug-in and include a dependency to OpenDentBusiness.dll and call the necessary methods to save an image.
by cmcgehee
Mon Jul 30, 2018 4:28 pm
Forum: Main Forum
Topic: Correcting ins pymt error after claim is finalized
Replies: 1
Views: 3987

Re: Correcting ins pymt error after claim is finalized

The correct way to fix this is to delete the bulk check and recreate it with the correct claims attached. It's not the quickest way to fix this, but it will leave your accounts in the cleanest positions.
by cmcgehee
Mon Jul 30, 2018 4:20 pm
Forum: Main Forum
Topic: insurance plan types
Replies: 2
Views: 4469

Re: insurance plan types

This is useful when you have multiple locations where the PPO allowed fee differs by location but each procedure receives the same reimbursement rate at each location. Suppose that I have 3 locations and each location has a slightly different contract with the same carrier. At each location, the UCR...
by cmcgehee
Sat Jul 28, 2018 11:24 am
Forum: Advanced Topics
Topic: Importing basic insurance information into OD
Replies: 1
Views: 6605

Re: Importing basic insurance information into OD

I would contact our Conversions department to see if they will be able to help import your patient record from your other PMS: conversions@opendental.com
https://opendental.com/site/conversions.html
by cmcgehee
Wed Jul 25, 2018 7:55 am
Forum: Main Forum
Topic: Exception when Emails functionality on new beta
Replies: 2
Views: 3603

Re: Exception when Emails functionality on new beta

Congrats on jumping on to the beta version. We have fixed this error in 18.2.5: "Email, loading the inbox caused a UE."
by cmcgehee
Thu Jul 19, 2018 5:26 pm
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29238

Re: Opening OpenDental.sln errors

I would set it to its default path.
by cmcgehee
Thu Jul 19, 2018 2:30 pm
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29238

Re: Opening OpenDental.sln errors

I would try uninstalling the Microsoft Visual C++ redistributable and reinstalling it. If that doesn't help, you might try installing one of the Topaz SigPlus drivers. I guess you should pick one of the options from https://www.sigpluspro.com/ and install it.
by cmcgehee
Thu Jul 19, 2018 1:47 pm
Forum: Main Forum
Topic: Error connecting client to MiddleTier
Replies: 2
Views: 4302

Re: Error connecting client to MiddleTier

We released a new trial version that contains the bug fix. You can re-download the trial version and set middle tier up again.
http://www.opendental.com/trial.html
by cmcgehee
Thu Jul 19, 2018 8:11 am
Forum: Developers
Topic: TRIALONLY conditional compilation constant (symbol)
Replies: 4
Views: 6713

Re: TRIALONLY conditional compilation constant (symbol)

I guess you want "Allow unsafe code" to be checked. Apparently I 've had that checked, and I don't think it's caused any problems.
by cmcgehee
Thu Jul 19, 2018 8:04 am
Forum: Main Forum
Topic: Error connecting client to MiddleTier
Replies: 2
Views: 4302

Re: Error connecting client to MiddleTier

This is a bug that we fixed in 17.4.86. Right now our trial version is 17.4.83 so the bug is going to be present in it. I'll see if we can release an updated trial version.
by cmcgehee
Wed Jul 18, 2018 5:49 pm
Forum: Developers
Topic: Feature request: Differentiate Major, Minor and Build
Replies: 2
Views: 4733

Re: Feature request: Differentiate Major, Minor and Build

I'll work and see if I can get this implemented.
by cmcgehee
Wed Jul 18, 2018 5:43 pm
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29238

Re: Opening OpenDental.sln errors

The results from the debug build are not safe to run when connecting to a database with live patient data. We put all sorts of things in the debug build to make our lives as developers easier that will cause the program to behave in strange ways.
by cmcgehee
Wed Jul 18, 2018 12:03 pm
Forum: Main Forum
Topic: Posterior Composite downgrade
Replies: 1
Views: 3413

Re: Posterior Composite downgrade

As it turns out, I completed this feature just a few weeks ago! There was a duplicate feature request 6731 which asked for the same thing. 6731 got attached to the job and marked completed. I appreciate you bringing this up because it enables me to mark 5570 completed as well! This feature will be a...
by cmcgehee
Tue Jul 17, 2018 5:05 pm
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29238

Re: Opening OpenDental.sln errors

There's an open bug job that we're working on concerning the SigPlusNet.dll not loading, but it occurs as a runtime exception. I would make sure that your target build platform is x86 (as opposed to Mixed Platforms or Any CPU). If that isn't it, you may need to install the Visual C++ Redistributable...
by cmcgehee
Tue Jul 17, 2018 7:42 am
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29238

Re: Opening OpenDental.sln errors

If you want to avoid the errors, you could just create three empty projects that have the same name and file path. But if it were me, I would just ignore the errors unless they cause any actual problems.
by cmcgehee
Mon Jul 16, 2018 7:53 am
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29238

Re: Opening OpenDental.sln errors

That's just fine that you don't have those projects. Those three projects are within our internal repository and we simply included them in our main solution so that we can see where they reference our open source code. You will still be able to compile Open Dental without these projects.
by cmcgehee
Mon Jul 16, 2018 7:50 am
Forum: Developers
Topic: Best way to compile Open Dental
Replies: 1
Views: 3721

Re: Best way to compile Open Dental

This webpage describes the process: http://opendental.com/manual/sourcecode.html.
by cmcgehee
Mon Jul 16, 2018 7:49 am
Forum: Developers
Topic: TRIALONLY conditional compilation constant (symbol)
Replies: 4
Views: 6713

Re: TRIALONLY conditional compilation constant (symbol)

Inside Visual Studio in the Solution Explorer, you'll want to right-click on the OpenDental project and select 'Properties'. Then select the Build tab and remove "TRIALONLY" from the Conditional compilation symbols textbox.
by cmcgehee
Mon Jul 16, 2018 7:44 am
Forum: Main Forum
Topic: Middle Tier Experience?
Replies: 14
Views: 20645

Re: Middle Tier Experience?

Middle Tier is a way that you have each Open Dental program talk to a service instead of directly to the database. The primary advantages to this are that it makes it easier to access the same database from multiple locations and it also enhances security because you don't have to store the MySQL pa...
by cmcgehee
Wed Jul 11, 2018 12:36 pm
Forum: Main Forum
Topic: override context menu and add new menuItem
Replies: 15
Views: 27632

Re: override context menu and add new menuItem

I just now committed the change to the hook. It will be available in 18.1.35.0. Sorry about giving you faulty advice before.
by cmcgehee
Tue Jul 10, 2018 9:40 am
Forum: Main Forum
Topic: override context menu and add new menuItem
Replies: 15
Views: 27632

Re: override context menu and add new menuItem

Can you share the whole method where you have this line of code?
by cmcgehee
Mon Jul 09, 2018 8:42 am
Forum: Main Forum
Topic: override context menu and add new menuItem
Replies: 15
Views: 27632

Re: override context menu and add new menuItem

Can you share the snippet of code where you're trying to find the menuApt object via Controls.Find? Maybe I can spot why it's not working.
by cmcgehee
Tue Jul 03, 2018 7:45 am
Forum: Developers
Topic: Custom Bridge question
Replies: 1
Views: 3756

Re: Custom Bridge question

The message "TheNameIChose is unavailable" is just a generic message we show when something goes wrong. It could occur for one of these reasons: the program was unable to write to the output path, the path to the executable could not be found, the executable could not launch properly. That is just f...
by cmcgehee
Tue Jul 03, 2018 7:39 am
Forum: Main Forum
Topic: Future date a payment
Replies: 1
Views: 3446

Re: Future date a payment

Yes, it is possible. To allow it, you will need to turn on the preferences "Allow Future Payments" in the Insurance tab in the Account module preferences and "Allow future dated transactions" in the Misc Account tab.
by cmcgehee
Mon Jul 02, 2018 8:52 am
Forum: Main Forum
Topic: Possibly a bug in reports.
Replies: 4
Views: 6029

Re: Possibly a bug in reports.

I suspect this issue will be too complicated to troubleshoot via the forums. Go ahead and call in to support and show them the issue.
by cmcgehee
Wed Jun 27, 2018 8:02 am
Forum: Main Forum
Topic: Possibly a bug in reports.
Replies: 4
Views: 6029

Re: Possibly a bug in reports.

To clarify, are talking about the Production and Income reports?
by cmcgehee
Mon Jun 25, 2018 4:50 pm
Forum: Main Forum
Topic: Can I automatically get a completed proc code with appt
Replies: 3
Views: 4514

Re: Can I automatically get a completed proc code with appt

Go to Setup -> Appointments -> Appointment Types and create a few appointment types for some common types of appointments that you do: New Patient Exam, Regular Cleaning, etc. Make sure that your 000 code is attached to each of these types. Create one more appointment type called something like "Uns...
by cmcgehee
Mon Jun 25, 2018 4:43 pm
Forum: Main Forum
Topic: A list of patients to follow up, TLC calls
Replies: 1
Views: 3029

Re: A list of patients to follow up, TLC calls

I would create a task list named "TLC" and send a task to it that is attached to the patients that you want to call.
http://www.opendental.com/manual/tasksarea.html
by cmcgehee
Mon Jun 25, 2018 4:40 pm
Forum: Main Forum
Topic: override context menu and add new menuItem
Replies: 15
Views: 27632

Re: override context menu and add new menuItem

Ashok, I have added this hook for you. I gave it the name "ContrAppt.MouseDownAppointment_menuApt_right_click" because this section of code has changed since when I originally suggested this hook. You shouldn't need menuApt to be public. You can access it like this: OpenDental.ContrAppt contrAppt=(O...
by cmcgehee
Mon Jun 25, 2018 9:43 am
Forum: Advanced Topics
Topic: Replication error in my.ini
Replies: 3
Views: 7454

Re: Replication error in my.ini

I've seen some offices get stuck at the login screen when their primary key range has been used up in the securitylog table. Are you using random primary keys and if so, can you post the result of these two queries?
SELECT * FROM replicationserver;
SELECT COUNT(*) FROM securitylog;
by cmcgehee
Mon Jun 25, 2018 8:22 am
Forum: Main Forum
Topic: Open Dental client Freezing - MySQL Tperformance tuning
Replies: 8
Views: 24825

Re: Open Dental client Freezing - MySQL Tperformance tuning

I wouldn't downgrade MySQL. Often MySQL 5.6 is much faster than 5.5.
by cmcgehee
Mon Jun 25, 2018 8:20 am
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

Re: Strange Unhandled Exception

With this sort of error, you can make a backup of the database, run the REPAIR TABLE command for the table that is crashed, and that should usually take care of it. I would still recommend calling support in this situation because sometimes the REPAIR TABLE command doesn't completely work.
by cmcgehee
Wed Jun 20, 2018 12:46 pm
Forum: Main Forum
Topic: Add service notes to appointment view
Replies: 3
Views: 4969

Re: Add service notes to appointment view

To get it to show in the Chart module, go to Setup -> Display Fields -> Chart Patient Information and move "PatFields" into the grid on the left.
by cmcgehee
Thu Jun 14, 2018 4:27 pm
Forum: Main Forum
Topic: Add service notes to appointment view
Replies: 3
Views: 4969

Re: Add service notes to appointment view

There is not a way to add the service notes (the textbox beneath the tooth chart in the Chart module). If you want to write a note that will appear on a patient's every appointment, you could create a Patient Field named "Notes for Appts" and add that Patient Field to show on your appointment view.
by cmcgehee
Thu Jun 14, 2018 4:17 pm
Forum: Advanced Topics
Topic: Dictionary bug 18.1.20
Replies: 7
Views: 11169

Re: Dictionary bug 18.1.20

The spell check runs on a timer, so the squiggly red line should go away after 0.5 seconds.
by cmcgehee
Thu Jun 14, 2018 8:02 am
Forum: Advanced Topics
Topic: Dictionary bug 18.1.20
Replies: 7
Views: 11169

Re: Dictionary bug 18.1.20

Hmmm, I haven't been able to get this to happen for me. If none of my co-workers who read this forum are able to reproduce this, can you call our support and show them the steps involved with the problem?
by cmcgehee
Tue Jun 12, 2018 11:04 am
Forum: Developers
Topic: Hook Request
Replies: 6
Views: 7179

Re: Hook Request

Your first hook has been added to 18.1.23. I will be happy to add your second hook if you still need it.
by cmcgehee
Tue Jun 12, 2018 10:50 am
Forum: Main Forum
Topic: Why no ScheduleProcedure automation for planned appointment
Replies: 5
Views: 7295

Re: Why no ScheduleProcedure automation for planned appointm

Fixed and will be released in 18.1.23: "Placing a planned appt on the schedule did not trigger the ScheduleProcedure automation"
by cmcgehee
Tue Jun 12, 2018 9:29 am
Forum: Developers
Topic: Hook Request
Replies: 6
Views: 7179

Re: Hook Request

I can hopefully get this in by the end of the week. As mentioned in another forum post, I am going to change the code so that planned appointments placed on the schedule do trigger the ScheduleProcedure automation. If I change the code to this: try { ODTuple<Appointment,bool> aptTuple=Appointments.S...
by cmcgehee
Tue Jun 12, 2018 9:24 am
Forum: Main Forum
Topic: Why no ScheduleProcedure automation for planned appointment
Replies: 5
Views: 7295

Re: Why no ScheduleProcedure automation for planned appointm

After talking with the engineer who originally wrote this feature, we decided that it is a bug that the ScheduleProcedure automation does not happen when placing a planned appointment on the schedule. I will get this fixed and backported soon.
by cmcgehee
Mon Jun 11, 2018 8:01 am
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 19364

Re: Daily Production goals

That's the way it's designed. That Daily Prod and Daily Goal are for the providers that are shown in the provider bars.
by cmcgehee
Mon Jun 11, 2018 7:59 am
Forum: Main Forum
Topic: Lab Case
Replies: 1
Views: 3495

Re: Lab Case

We don't currently have this feature, but it is an outstanding feature request. Feel free to add your votes to #5150.
http://www.opendental.com/manual/featurerequests.html
by cmcgehee
Mon Jun 11, 2018 7:56 am
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14716

Re: Duplication in security log table

Can you show me the query that you're running?
by cmcgehee
Sat Jun 09, 2018 11:54 am
Forum: Main Forum
Topic: Why no autonote on appointment screen?
Replies: 6
Views: 8928

Re: Why no autonote on appointment screen?

Great! Is this for 18.2 I assume? I'm hoping to get this in to 18.2, but it looks like it's going to be tough to make the cutoff with this feature. Great news. I hope you can put the health history/things-you-really-need-to-know-about-this-patient in that area. (don't lean way back! needs neck pill...
by cmcgehee
Sat Jun 09, 2018 11:48 am
Forum: Main Forum
Topic: Why no ScheduleProcedure automation for planned appointment
Replies: 5
Views: 7295

Re: Why no ScheduleProcedure automation for planned appointm

I'll look into this and see if I can find an answer.
by cmcgehee
Sat Jun 09, 2018 11:33 am
Forum: Developers
Topic: Hook Request
Replies: 6
Views: 7179

Re: Hook Request

I will get these added sometime next week. :D
by cmcgehee
Sat Jun 09, 2018 11:16 am
Forum: Developers
Topic: Find the User Who's Currently Logged In
Replies: 11
Views: 17010

Re: Find the User Who's Currently Logged In

Sure, you can call OpenDentBusiness.Userods.GetAdminUser. If the password on that user is blank, you can tell that everyone is logging in as the admin user.
by cmcgehee
Thu Jun 07, 2018 2:49 pm
Forum: Main Forum
Topic: Why no autonote on appointment screen?
Replies: 6
Views: 8928

Re: Why no autonote on appointment screen?

I'm currently writing up a feature where you can put a patient dashboard on the right side of the screen where you can choose pieces of information to show in all the modules.
by cmcgehee
Thu Jun 07, 2018 2:43 pm
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 19364

Re: Daily Production goals

You can check back in with the manual in a few weeks. Our rule for ourselves is to document all features before they go to a stable release, so documentation for beta features is hit and miss.
by cmcgehee
Wed Jun 06, 2018 7:39 am
Forum: Main Forum
Topic: Can I automatically get a completed proc code with appt
Replies: 3
Views: 4514

Re: Can I automatically get a completed proc code with appt

I can't think of a way to accomplish this. The closest you could come is to use appointment types for all your appointments and add the 000 code to all appointment types. If that doesn't suffice for your needs, you can submit a feature request.
http://opendental.com/manual/appointmenttypes.html
by cmcgehee
Wed Jun 06, 2018 7:37 am
Forum: Developers
Topic: Find the User Who's Currently Logged In
Replies: 11
Views: 17010

Re: Find the User Who's Currently Logged In

You can identify the currently logged in user from OpenDentBusiness.Security.CurUser. This is guaranteed to be set when running the Open Dental program. If you are not using authentication, the first Admin user with no password will be set as the current user.
by cmcgehee
Wed Jun 06, 2018 7:32 am
Forum: Developers
Topic: Identifier for Open Dental Installation
Replies: 3
Views: 5460

Re: Identifier for Open Dental Installation

1) What's the best way to uniquely identify an Open Dental Installation (e.g. instance of a database)? The way to uniquely identify a database is by the registration key. You can use this query: SELECT * FROM preference WHERE PrefName = 'RegistrationKey'; 2) Is there an identifier or a label (e.g. ...
by cmcgehee
Tue Jun 05, 2018 12:22 pm
Forum: Main Forum
Topic: Why no autonote on appointment screen?
Replies: 6
Views: 8928

Re: Why no autonote on appointment screen?

The best way to do this would be to create a group note that is attached to all six procedures.
http://opendental.com/manual/procgroupnote.html
by cmcgehee
Tue Jun 05, 2018 10:17 am
Forum: Main Forum
Topic: Patients only visible to certain providers?
Replies: 1
Views: 3232

Re: Patients only visible to certain providers?

One approach you could try is to assign your wife's patients to their own clinic, and then restrict all other users to not be able to see that clinic. Splitting off the patients into a different database may be preferable instead.
by cmcgehee
Mon Jun 04, 2018 8:30 am
Forum: Advanced Topics
Topic: Beta 18.1 Bug when deleting sheet from chart
Replies: 1
Views: 3720

Re: Beta 18.1 Bug when deleting sheet from chart

This has been fixed in 18.1.18: "Deleting a patient exam sheet could cause an error".
by cmcgehee
Mon Jun 04, 2018 8:24 am
Forum: Main Forum
Topic: Changing tooth number
Replies: 2
Views: 5993

Re: Changing tooth number

The way to fix this is to delete the deposit, delete the claim, change the tooth number, and recreate the claim. That may not be a simple fix, but it should be doable. I would take screenshots before you delete things so that you can recreate them accurately.
by cmcgehee
Wed May 30, 2018 7:46 am
Forum: Main Forum
Topic: Reminders to staff, not patients?
Replies: 4
Views: 8315

Re: Reminders to staff, not patients?

There is not a natural way to do this, but one approach you could try is to set up eReminders for texts or emails and then when you schedule an appointment at a time before the hygienist normally comes in, you create an additional appointment in a special operatory and set the hygienist as the patie...
by cmcgehee
Wed May 23, 2018 7:54 am
Forum: Main Forum
Topic: Customizing Recall Postcards
Replies: 1
Views: 3393

Re: Customizing Recall Postcards

There are a few adjustments you can make for postcards under Setup -> Appointments -> Recall. In the Postcards per Sheet field, entering "1" will fit the postcard to a 5x7 size. You can also adjust the margins for the postcard in this window.
by cmcgehee
Tue May 22, 2018 8:13 am
Forum: Main Forum
Topic: Breaking appointment - Must attach a procedure to adjustment
Replies: 1
Views: 3276

Re: Breaking appointment - Must attach a procedure to adjust

When you break an appointment, you have the option to always attach an adjustment. If you don't desire that, you can go to Appointment Module Preferences in the Behavior tab and uncheck "Make broken appointment Adjustment". If you want to create an adjustment but don't want to attach a procedure to ...
by cmcgehee
Mon May 21, 2018 8:12 am
Forum: Main Forum
Topic: prineer no found
Replies: 1
Views: 3045

Re: prineer no found

I would install a simple PDF printer. That should probably take care of this error.
http://www.cutepdf.com/Products/CutePDF/writer.asp
by cmcgehee
Mon May 14, 2018 7:59 am
Forum: Main Forum
Topic: Request/Idea for a New Patient and Referral Dashboard
Replies: 4
Views: 19432

Re: Request/Idea for a New Patient and Referral Dashboard

"Back end developer" has more to do with managing databases and servers. I would look for someone with the skill set "client side application developer". Someone who has C#/.NET experience would be ideal since they could utilize our existing codebase.
by cmcgehee
Thu Apr 26, 2018 10:24 am
Forum: Main Forum
Topic: Billing Format
Replies: 4
Views: 6208

Re: Billing Format

It's good to hear that intermingle family members will work for you guys. It's hard to say why the pay splits are assigning the way the are without looking at them. I do know that we have been working hard lately to improve auto splits. I would recommend updating to 17.4 when it comes out in a few d...
by cmcgehee
Thu Apr 26, 2018 9:09 am
Forum: Main Forum
Topic: Billing Format
Replies: 4
Views: 6208

Re: Billing Format

There is not a way to only apply payments to a family. Let me say a couple reasons why that might not be as nice as it sounds. Firstly, your production and income reports would not be able to report at a patient level since the income is not linked to a patient. Secondly, if you have a split a famil...
by cmcgehee
Tue Apr 24, 2018 3:25 pm
Forum: Developers
Topic: Fatal error encountered during command execution in C#
Replies: 4
Views: 8760

Re: Fatal error encountered during command execution in C#

You are welcome to upgrade your own office to MySQL 8.0 although we will not support that version immediately. If you do, I would be interested in hearing your experience, especially if you hit any snags.
by cmcgehee
Mon Apr 23, 2018 1:16 pm
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41561

Re: FHIR with trial version

As you have found, a valid registration key is needed to setup a FHIR API. We can possibly give you a developer registration key. I'll PM to get that rolling.
by cmcgehee
Thu Apr 19, 2018 12:17 pm
Forum: Main Forum
Topic: query crash
Replies: 5
Views: 5874

Re: query crash

This error looks like the kind where hardware or the operating system is corrupted. Something that might fix this is having your IT reinstall the .NET framework.
by cmcgehee
Thu Apr 19, 2018 7:52 am
Forum: Main Forum
Topic: query crash
Replies: 5
Views: 5874

Re: query crash

Can you share the full text of the exception that you get when Open Dental crashes?
by cmcgehee
Wed Apr 18, 2018 8:00 am
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 14136

Re: Time card reports specifics

Oh I see why that's happening. Whenever a column name starts with 'Date', Open Dental will try to format the entire column as a date. I edited my previous post to get around this feature.
by cmcgehee
Tue Apr 17, 2018 1:20 pm
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 14136

Re: Time card reports specifics

Do you mean that the Date Range column is empty?
by cmcgehee
Tue Apr 17, 2018 9:06 am
Forum: Developers
Topic: Fatal error encountered during command execution in C#
Replies: 4
Views: 8760

Re: Fatal error encountered during command execution in C#

It is on our roadmap to upgrade our offices to MySQL 5.6 or 5.7 although it could require a significant amount of work because we will have to upgrade the databases of our existing customers to work with the newer version of MySQL.
by cmcgehee
Mon Apr 16, 2018 12:40 pm
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 14136

Re: Time card reports specifics

Yeah sure, that's an easy modification. /*Weekly hours worked for all Employees. First day of the week is Sunday.*/ /*Query code written/modified: 04/16/2018*/ SET @FromDate='2016-01-01' , @ToDate='2016-07-31'; SET @EmployeeFirstName='Alan'; SET @EmployeeLastName='Turing'; SELECT CONCAT(e.LName,', '...
by cmcgehee
Wed Apr 11, 2018 12:48 pm
Forum: Main Forum
Topic: e-Claims, which clearinghouse to choose?
Replies: 3
Views: 5651

Re: e-Claims, which clearinghouse to choose?

Here's a modification of 491 that shows electronic claims sent in a date range. It doesn't look like we have any more detailed reports available. /*491 Find eclaims sent in date range */ SET @FromDate='2010-07-01' , @ToDate='2010-07-31'; SELECT c.PatNum, c.DateSent, c.DateService, e.Etype, e.DateTim...
by cmcgehee
Tue Apr 10, 2018 7:43 am
Forum: Main Forum
Topic: old version 17.2.32
Replies: 1
Views: 3043

Re: old version 17.2.32

Yes, you can call in to support and we can give you the link for 17.2.32. However, if you are currently on 17.3, it will be impossible to go back to 17.2; each upgrade is irreversible unless you are willing to use a backup of your database from the time that you updated.
by cmcgehee
Tue Apr 10, 2018 7:38 am
Forum: Main Forum
Topic: DUAL BRIDGE
Replies: 2
Views: 3969

Re: DUAL BRIDGE

Yes, that is possible. You simply set up a program link for each imaging program and then you can add a button for each program that launches it.
by cmcgehee
Mon Apr 09, 2018 7:58 am
Forum: Main Forum
Topic: Could not find path to A-Z folder upon version upgrade. Bug?
Replies: 4
Views: 7959

Re: Could not find path to A-Z folder upon version upgrade.

It sounds like there's something fishy going on there with permissions. I'm personally not familiar enough with Samba Share to give a more educated response.
by cmcgehee
Thu Apr 05, 2018 1:57 pm
Forum: Main Forum
Topic: Ohio requiring ICD10 or procedure code on opioid Rx
Replies: 7
Views: 13873

Re: Ohio requiring ICD10 or procedure code on opioid Rx

From what I've heard, the ICD10 code is supposed to override the ProcCode if it is present on the procedure. If that isn't happening for you, call in to support and we'll take a look at it.
by cmcgehee
Thu Apr 05, 2018 10:53 am
Forum: Main Forum
Topic: Ohio requiring ICD10 or procedure code on opioid Rx
Replies: 7
Views: 13873

Re: Ohio requiring ICD10 or procedure code on opioid Rx

Right, I see that is will only print the D code and not the ICD10 code. I will look into this and get back to you.
by cmcgehee
Thu Apr 05, 2018 8:44 am
Forum: Main Forum
Topic: REMINDERS OF SOME FORMS
Replies: 7
Views: 12252

Re: REMINDERS OF SOME FORMS

Yes, you can create a popup if you only want it on certain patients, or you can create an automation trigger to show the reminder on all patients or patients that need a certain sheet.
http://opendental.com/manual/popups.html
http://opendental.com/manual/automation.html
by cmcgehee
Wed Apr 04, 2018 5:12 pm
Forum: Main Forum
Topic: INSURANCE BENEFITS HISTORY
Replies: 2
Views: 4518

Re: INSURANCE BENEFITS HISTORY

There is currently not a way to add a manual entry for a benefit check. You could add that as a feature request.
by cmcgehee
Wed Apr 04, 2018 7:41 am
Forum: Advanced Topics
Topic: Admin Account not in Admin Group
Replies: 1
Views: 4062

Re: Admin Account not in Admin Group

There is a requirement that at least one user has the Security Admin permission. You likely had another user in the Admin group or a different group had the Security Admin permission.
by cmcgehee
Tue Apr 03, 2018 3:05 pm
Forum: Main Forum
Topic: Ohio requiring ICD10 or procedure code on opioid Rx
Replies: 7
Views: 13873

Re: Ohio requiring ICD10 or procedure code on opioid Rx

I believe this has been completed in version 17.4.33 of Open Dental. That version is currently beta, but you may update to it if you critically need this feature.
by cmcgehee
Tue Apr 03, 2018 12:59 pm
Forum: Advanced Topics
Topic: Issues with new scanner
Replies: 1
Views: 4030

Re: Issues with new scanner

Can you share your version of Open Dental along with the specific spot in the program that tells you that you are not authorized?
by cmcgehee
Sat Mar 31, 2018 11:16 am
Forum: Advanced Topics
Topic: TLS versions and DB engines
Replies: 7
Views: 13096

Re: TLS versions and DB engines

I suggest you try to run an update against an ISAM database. You might see the same error we (me, and your support techs with whom I was sharing the client computer) saw: this DB is MyISAM; fix it to InnoDB if you want this update to run. After I updated it to InnoDB using the code above, the updat...
by cmcgehee
Wed Mar 28, 2018 8:27 am
Forum: Advanced Topics
Topic: TLS versions and DB engines
Replies: 7
Views: 13096

Re: TLS versions and DB engines

In regards to TLS, Open Dental will support TLS 1.3 once it becomes widely adopted. We will have to wait at least until Microsoft includes TLS 1.3 in the .NET framework. To give a little bit of explanation on why we did not support TLS 1.2 sooner, doing so required that we upgrade to .NET 4.5. This ...
by cmcgehee
Wed Mar 28, 2018 8:04 am
Forum: Developers
Topic: OpenDental Install Location
Replies: 8
Views: 18385

Re: OpenDental Install Location

Was there no registry key entered under HKLM\Software\MakeMSI\PersistingProperties\OpenDental\INSTALLDIR?
by cmcgehee
Sat Mar 24, 2018 11:57 am
Forum: Main Forum
Topic: Online appointment booking???
Replies: 1
Views: 4227

Re: Online appointment booking???

Yes, you can add to your website a place where new patients can schedule an appointment and where old patients can schedule their recall appointments. See http://opendental.com/manual/websched.html for more details.
by cmcgehee
Thu Mar 15, 2018 5:19 pm
Forum: Advanced Topics
Topic: Help migrating away from gotomypc to network environment
Replies: 6
Views: 10790

Re: Help migrating away from gotomypc to network environment

I don't know if this is Jerry's reason, but connecting to your Open Dental database via a VPN is the slowest way to setup Open Dental. The reason for this is that most user actions within Open Dental make many database calls, so you will get slowed down many times by your latency. We solve this with...
by cmcgehee
Thu Mar 15, 2018 8:14 am
Forum: Developers
Topic: Guidance for Plugin Settings (.config, Prefs, etc...)
Replies: 3
Views: 5607

Re: Guidance for Plugin Settings (.config, Prefs, etc...)

The recommended way is to create your own database table(s) within the Open Dental database. You can then use the class OpenDentBusiness.DataCore to read and write to these tables. Be sure to name your table something highly unique such as tholmes_connectionsettings.
by cmcgehee
Wed Mar 14, 2018 5:15 pm
Forum: Main Forum
Topic: Setting up Insurance plans
Replies: 1
Views: 3616

Re: Setting up Insurance plans

Here is the documentation for setting up insurance http://opendental.com/manual/insurance.html. Let me know if you're looking for something for specific and I can help you find it.
by cmcgehee
Wed Mar 14, 2018 12:35 pm
Forum: Main Forum
Topic: Way to see if all prompts in notes are filled out?
Replies: 3
Views: 5323

Re: Way to see if all prompts in notes are filled out?

This query might work. /*404 Procedures with key word in note for date range*/ SET @FromDate= '2009-01-01', @ToDate='2010-07-31'; /*change dates here*/ SELECT procedurelog.ProcDate,procedurelog.ProvNum, CONCAT(patient.LName,', ',patient.FName) AS 'PatientName', procedurecode.ProcCode,procedurecode.A...
by cmcgehee
Wed Mar 14, 2018 10:15 am
Forum: Main Forum
Topic: Way to see if all prompts in notes are filled out?
Replies: 3
Views: 5323

Re: Way to see if all prompts in notes are filled out?

What are you referring to when you say "patient notes"? Are you referring to the appointment-like objects that are placed on the appointment schedule?
by cmcgehee
Mon Mar 12, 2018 2:42 pm
Forum: Main Forum
Topic: Login window out of focus. Bug?
Replies: 7
Views: 11720

Re: Login window out of focus. Bug?

Does this happen only when Open Dental is starting up, or does it also happen after clicking the "Log Off" menu item?
by cmcgehee
Sat Mar 10, 2018 1:45 pm
Forum: Main Forum
Topic: Could not find path to A-Z folder upon version upgrade. Bug?
Replies: 4
Views: 7959

Re: Could not find path to A-Z folder upon version upgrade.

When you open Open Dental, do you typically run it as an administrator? Perhaps when Open Dental relaunches after upgrading, it does not have high enough permissions to read your A-Z folder.
by cmcgehee
Sat Mar 10, 2018 1:08 pm
Forum: Main Forum
Topic: Login window out of focus. Bug?
Replies: 7
Views: 11720

Re: Login window out of focus. Bug?

That would be a bug if it happens consistently. I haven't been able to get this to happen, so why don't you call in to support to see if we can figure out what's causing this.
by cmcgehee
Tue Mar 06, 2018 4:12 pm
Forum: Main Forum
Topic: Which surgery are my patients currently in??
Replies: 2
Views: 4198

Re: Which surgery are my patients currently in??

There is not a way to do this currently. If you like you could submit a feature request to add this.
http://opendental.com/manual/featurerequests.html
by cmcgehee
Mon Mar 05, 2018 8:08 am
Forum: Advanced Topics
Topic: Send Ins Claim bug. v 17.4.34
Replies: 3
Views: 6064

Re: Send Ins Claim bug. v 17.4.34

It's hard to say generally how to fix a problem like this. I would have to get connected and run a few queries to get an idea how it should be fixed.
by cmcgehee
Wed Feb 28, 2018 7:51 am
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 5965

Re: Add Insurance Plan to Query #164

Here it is with the patient's primary insurance showing as the last column. /*164 Returns all treatment planned procedures for active patients without a scheduled OR planned apt, who were last seen in a given date range with phone numbers, useful for those transitioning to planned appointments (this...
by cmcgehee
Tue Feb 27, 2018 4:05 pm
Forum: Advanced Topics
Topic: Send Ins Claim bug. v 17.4.34
Replies: 3
Views: 6064

Re: Send Ins Claim bug. v 17.4.34

Based on that error message, it looks like these claims are pointing to subscribers that do not exist in the patient table. Something like this generally looks like data corruption.
by cmcgehee
Tue Feb 27, 2018 9:31 am
Forum: Main Forum
Topic: manual conversion from dialog dental software
Replies: 5
Views: 10026

Re: manual conversion from dialog dental software

What I've heard other dentists recommend in a situation like this to start with a fresh Open Dental database and manually enter the patients as they call in, schedule an appointment, etc. It's not worth entering every single patient from your old software when some patients haven't come to the offic...
by cmcgehee
Tue Feb 27, 2018 9:27 am
Forum: Main Forum
Topic: Missing new CDT code D5612
Replies: 6
Views: 10647

Re: Missing new CDT code D5612

Note that once you are on this version, you will need to run the D-Codes tool to get D5612 into its proper category.
http://opendental.com/manual/procedurecodetools.html
by cmcgehee
Mon Feb 26, 2018 12:35 pm
Forum: Advanced Topics
Topic: 17.4.34 Procedure fee x7 in account & appt window
Replies: 8
Views: 14023

Re: 17.4.34 Procedure fee x7 in account & appt window

I believe that when the procedure is created it will have its base units set to whatever the procedure code's base units was at the time. The procedure would then keep those base units when it is completed even if the procedure code has changed its base units.