Search found 644 matches

by cmcgehee
Wed Jan 15, 2020 11:54 am
Forum: Developers
Topic: FHIR - Resource (Subscription)
Replies: 1
Views: 57

Re: FHIR - Resource (Subscription)

Go ahead and send an email to vendor.relations@opendental.com. They can help you with any setup you'll need for FHIR.
by cmcgehee
Wed Jan 15, 2020 11:51 am
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

Re: FHIR with trial version

If you would like to use our test environment, you can find the developer key in https://www.opendental.com/resources/OpenDentalFHIR19-4Spec.pdf . Our test environment is currently on version 19.4. If you would like to connect to your own database, we will need to issue you a developer API key. You ...
by cmcgehee
Tue Jan 07, 2020 2:54 pm
Forum: Developers
Topic: Enums
Replies: 2
Views: 76

Re: Enums

We have a policy to not modify enums for plugins. What you could do is create a new database table that links to the TreatPlan table. In this table, you could put any custom enum values that you want.
by cmcgehee
Mon Jan 06, 2020 8:40 am
Forum: Developers
Topic: Convert.ToBoolean in OD 19.4
Replies: 5
Views: 334

Re: Convert.ToBoolean in OD 19.4

I don't think so. We store bools as tinyints as well.
by cmcgehee
Thu Jan 02, 2020 8:51 am
Forum: Developers
Topic: Convert.ToBoolean in OD 19.4
Replies: 5
Views: 334

Re: Convert.ToBoolean in OD 19.4

When I run Convert.ToBoolean("1") in C# 7.3 using .NET Framework 4.5.2 in Visual Studio 2019, it gives a FormatException. I cannot vouch for its behavior in older versions of C# or .NET.
by cmcgehee
Wed Jan 01, 2020 9:01 am
Forum: Developers
Topic: Convert.ToBoolean in OD 19.4
Replies: 5
Views: 334

Re: Convert.ToBoolean in OD 19.4

Did you used to store AddEnhancedMenuItems as "true" and now you're storing it at "1"?
by cmcgehee
Tue Dec 24, 2019 9:12 am
Forum: Developers
Topic: Compiled Version Patient Limited to 30?
Replies: 9
Views: 302

Re: Compiled Version Patient Limited to 30?

The way our update process works is that when a workstation updates the database, it copies all its files from the Open Dental directory and uploads them to the server. Then any other workstation that connects to the database will update its Open Dental files to match what was uploaded to the server...
by cmcgehee
Thu Dec 19, 2019 9:18 am
Forum: Developers
Topic: Compiled Version Patient Limited to 30?
Replies: 9
Views: 302

Re: Compiled Version Patient Limited to 30?

If it's there, then yes. I'm thinking though that this issue was originally caused by something else. If you downloaded the trial version from our website and installed it, then you would also get this behavior.
by cmcgehee
Tue Dec 17, 2019 1:39 pm
Forum: Developers
Topic: ODGrid.Rows update
Replies: 2
Views: 133

Re: ODGrid.Rows update

Yes, you can replace all your references to ODGrid.Rows with ODGrid.ListGridRows.
by cmcgehee
Tue Dec 17, 2019 8:18 am
Forum: Developers
Topic: Compiled Version Patient Limited to 30?
Replies: 9
Views: 302

Re: Compiled Version Patient Limited to 30?

In Visual Studio when you open up the Properties for a project, there is a place to enter compilation symbols:
Image
by cmcgehee
Mon Dec 16, 2019 5:25 pm
Forum: Developers
Topic: Long load time Middle Tier
Replies: 2
Views: 136

Re: Long load time Middle Tier

We struggle with this sometimes too where Middle Tier takes much longer than a direct connection. Usually it's because someone introduced a call to Middle Tier inside a loop. A call to Middle Tier can often take 100 ms, so repeated calls really add up. My guess is that you are making a Middle Tier c...
by cmcgehee
Mon Dec 16, 2019 2:50 pm
Forum: Developers
Topic: Compiled Version Patient Limited to 30?
Replies: 9
Views: 302

Re: Compiled Version Patient Limited to 30?

It sounds like you compiled the source code using the TRIALONLY compilation symbol. If you remove that from the OpenDental and/or CodeBase projects, you should be able to use it like normal.
by cmcgehee
Mon Dec 09, 2019 8:44 am
Forum: Developers
Topic: Newtonsoft.JSON hates me...
Replies: 1
Views: 216

Re: Newtonsoft.JSON hates me...

To fix this, you probably will have to make sure that just the Anesthesia19.3.dll is in your bin folder on the Middle Tier server. I believe that when IIS loads an application, it will load every assembly in the bin folder, so having multiple Anesthesia dlls will likely cause problems when it comes ...
by cmcgehee
Mon Dec 09, 2019 8:40 am
Forum: Developers
Topic: Middle Tier deployment issue
Replies: 2
Views: 205

Re: Middle Tier deployment issue

You don't need all OD files, only ones that the OpenDentalServer project use. If you build just that project and go to its bin folder, those are the files you'll need to copy to your live machine's bin folder.
by cmcgehee
Wed Dec 04, 2019 8:33 am
Forum: Sharing
Topic: Medication List
Replies: 4
Views: 880

Re: Medication List

It looks like this medication list was exported before we fixed the import/export tool to work with descriptions that span multiple lines.

Richard, can you update to a version later than 19.2.25 and export the list again?
by cmcgehee
Tue Dec 03, 2019 8:38 am
Forum: Advanced Topics
Topic: Requiring MYSQL passwords in Open Dental.
Replies: 6
Views: 1261

Re: Requiring MYSQL passwords in Open Dental.

Yeah, so few of our customers use InnodDB that our techs usually don't think to ask about it. We recently transitioned to InnoDB here at HQ, and it involved some difficulties for us as well.
by cmcgehee
Mon Dec 02, 2019 6:09 pm
Forum: Advanced Topics
Topic: Requiring MYSQL passwords in Open Dental.
Replies: 6
Views: 1261

Re: Requiring MYSQL passwords in Open Dental.

Dr. Qadri,

I'm glad it was "almost" and not a complete loss. We are currently at the research phase for migrating to MariaDB. We might decide not go through with it, or we might decide we'll support both MariaDB and MySQL going forward.
by cmcgehee
Wed Nov 20, 2019 6:38 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

My guess is that in the class in which Load_end_DatabaseWork lives, there is a static field that contains an ActiveX control. Try putting Load_end_DatabaseWork in its own class with nothing else and see if you still get the error.
by cmcgehee
Tue Nov 19, 2019 8:20 am
Forum: Developers
Topic: Custom SMS Implementations
Replies: 1
Views: 257

Re: Custom SMS Implementations

The only way you'd be able to implement Twilio is by writing a plugin for Open Dental. These are a few hooks you would want to implement: FormSmsTextMessaging.butReply_Click_sendSmsSingle FormTxtMsgEdit.SendText_Start SmsToMobiles.SendSmsSingle_start You would not be able implement any automated tex...
by cmcgehee
Mon Nov 18, 2019 1:47 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

The middle tier server sees "C:\Program Files (x86)\Open Dental" as equivalent to "C:\MySolution\opendental19.3\OpenDentalServer". Yes, Debug_Web is the right build configuration for what you're doing. When you're debugging, your "C:\MySolution\opendental19.3\OpenDentalServer\bin" should have OpenDe...
by cmcgehee
Mon Nov 18, 2019 8:27 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

From the stack trace, it looks like you have Anesthesia.dll present in the folder "C:\Program Files (x86)\Open Dental\bin". When the first middle tier request comes in, it will try to load every dll in the bin folder. If you instead put the dll in "C:\Program Files (x86)\Open Dental", the code in Pl...
by cmcgehee
Thu Nov 14, 2019 3:30 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

Would you mind adding the stack trace where you're getting "Could not load file or assembly"? I have committed the fix for the bug regarding AnesthesiaXX.XX.dll not copying on middle tier. It will be available in 19.2.46 and 19.3.24. The problem was that on line 83 of Plugins.cs we were using Applic...
by cmcgehee
Thu Nov 14, 2019 10:17 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

Our philosophy toward NuGet packages is to make a copy of the dll in our "Required dlls" folder and reference that dll directly. My guess is that in your plugin you're referencing Newtonsoft.Json that is a different version than the one the rest of Open Dental is referencing. If that's the case, I w...
by cmcgehee
Wed Nov 13, 2019 9:48 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

If you're on the middle tier server, you can use this to get the physical path:

Code: Select all

System.Web.HttpContext.Current.Server.MapPath(null)
I think I've found the bug in our code that is preventing the renaming of Anesthesia19.3.dll to Anesthesia.dll. I'll get it fixed.
by cmcgehee
Tue Nov 12, 2019 2:36 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

Ok, 1. In the Open Dental solution, in the solution properties, set multiple startup projects to include OpenDental and OpenDentalServer. 2. In the properties for the OpenDentalServer, change the drop down that says "IIS Express" to "Local IIS". You will need to be running VS as admin. You'll also n...
by cmcgehee
Tue Nov 12, 2019 12:18 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

Yes, you can use HTTP.
by cmcgehee
Tue Nov 12, 2019 11:23 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

Ok, that means you're definitely getting an error on the middle tier server side. As you can see, our middle tier errors are not very informative, unfortunately. To troubleshoot this, I would run the middle tier service in debug and put a breakpoint at DtoProcessor.ProcessDto to figure out what's ca...
by cmcgehee
Tue Nov 12, 2019 8:36 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

It looks like you may be encountering two separate issues. When you get Error loading Plugin:Anesthesia[VersionMajMin].dll}. Object reference not set to an instance of an Object You would get that message if your plugin dll exists and it either doesn't have a class named "Plugin" in the "Anesthesia"...
by cmcgehee
Mon Nov 11, 2019 6:50 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

Sure, you can look at OpenDentBusiness.Patients.Delete as an example. if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),pat); return; } The important thing is to include the return after the GetVoid line. If you don't, you will get a runtime excepti...
by cmcgehee
Mon Nov 11, 2019 6:48 pm
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

Re: FHIR with trial version

Yes, 19.2. The beta version 19.3 is also available for download.
by cmcgehee
Mon Nov 11, 2019 9:15 am
Forum: Main Forum
Topic: Exocad??
Replies: 1
Views: 327

Re: Exocad??

We don't have any documentation on Exocad, so I can't say if it works with Open Dental. If Exocad can be launched with command line parameters, you can set up a custom bridge in Open Dental to launch it with a click of a button from OD.
https://opendental.com/manual/bridgecustom.html
by cmcgehee
Mon Nov 11, 2019 9:11 am
Forum: Developers
Topic: FHIR API server errors
Replies: 11
Views: 1006

Re: FHIR API server errors

Can you send me your full request including your API key in a private message? I can check to make sure the API key is still valid.
by cmcgehee
Mon Nov 11, 2019 8:48 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 1418

Re: Middle Tier plugin issues

If you have a method that makes a database call, you will need to put what we call a "remoting role check" at the beginning of the method. For example in OpenDentBusiness.Patients.GetPat, there is: if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { return Meth.GetObject<Patient>(MethodBase.Ge...
by cmcgehee
Mon Nov 11, 2019 8:38 am
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

Re: FHIR with trial version

One of the only differences between the compiled version and the version we distribute is that the version we distribute includes CDT codes in one of the dlls. If you have a developer key, you can download the version that we distribute and therefore obtain the newest CDT codes.
by cmcgehee
Thu Nov 07, 2019 10:38 am
Forum: Advanced Topics
Topic: Edit patient window: Provider doesn't get populated
Replies: 2
Views: 298

Re: Edit patient window: Provider doesn't get populated

If you're able to reproduce this, would you mind calling in to support to show us?
by cmcgehee
Tue Nov 05, 2019 9:59 am
Forum: Developers
Topic: FHIR API server errors
Replies: 11
Views: 1006

Re: FHIR API server errors

Your PHP script is close. If you just change "x-auth-token: FHIRAPIKey=XXXYYYZZZ" to ""Authorization: FHIRAPIKey=XXXYYYZZZ", then the request should work.
by cmcgehee
Mon Nov 04, 2019 5:50 pm
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

Re: FHIR with trial version

There is no time limit for developer keys. It should work indefinitely. To update to the newest CDT codes, you can run the "D Codes" tool: https://opendental.com/manual/procedurecodetools.html.
by cmcgehee
Thu Oct 31, 2019 3:07 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 913

Re: Error in home backup

After you reinstall, can you right-click on these two files, select "Properties", and tell me the version numbers?
C:\Program Files (x86)\Open Dental\DataConnectionBase.dll
C:\Program Files (x86)\Open Dental\OpenDental.exe
by cmcgehee
Thu Oct 31, 2019 12:35 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 913

Re: Error in home backup

Judging by the error you're getting, it looks like your home is half on 19.3 and half on 19.2. I would reinstall Open Dental on your home computer.
by cmcgehee
Thu Oct 31, 2019 7:23 am
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 913

Re: Error in home backup

Do you compile your own Open Dental?
by cmcgehee
Thu Oct 17, 2019 7:27 am
Forum: Developers
Topic: cellFontSize private to public on ODGrid?
Replies: 13
Views: 10645

Re: cellFontSize private to public on ODGrid?

We did a big refactor in ODGrid in 19.3. It looks like cellFont was renamed to _fontCell. The fastest way to fix this for you would be to use reflection to set it. If you don't want to do that, I can initiate the process to get it changed to public.
by cmcgehee
Wed Oct 16, 2019 9:08 am
Forum: Advanced Topics
Topic: Requiring MYSQL passwords in Open Dental.
Replies: 6
Views: 1261

Re: Requiring MYSQL passwords in Open Dental.

I do agree we should do this. I've submitted a job to implement this.
by cmcgehee
Thu Oct 10, 2019 3:48 pm
Forum: Advanced Topics
Topic: Bridge for Carestream
Replies: 1
Views: 375

Re: Bridge for Carestream

Have you set the Storage Path property in the Program Link window?
by cmcgehee
Tue Oct 01, 2019 12:13 pm
Forum: Advanced Topics
Topic: Enabling Messaging Buttons in Tight Integration w/ eCW
Replies: 1
Views: 366

Re: Enabling Messaging Buttons in Tight Integration w/ eCW

The way the program currently works, if you're using the eCW tight integration, the messaging buttons are disabled. There is not a way to turn these on.
by cmcgehee
Thu Sep 26, 2019 3:31 pm
Forum: Advanced Topics
Topic: Critical Error No Fee Cache
Replies: 3
Views: 583

Re: Critical Error No Fee Cache

When you get a critical error, there should be a "Details" that you can click on to expand. Can you paste those details here?
by cmcgehee
Mon Sep 23, 2019 7:28 am
Forum: Advanced Topics
Topic: Error on Appt Book Refresh
Replies: 2
Views: 546

Re: Error on Appt Book Refresh

This is currently in our bugs list. We can update this forum once we fix it.
by cmcgehee
Mon Sep 23, 2019 7:25 am
Forum: Developers
Topic: Book appointment leads to unexplainable result
Replies: 10
Views: 1009

Re: Book appointment leads to unexplainable result

There are not any updates on this. I can update this forum post if/when we complete this.
by cmcgehee
Mon Sep 23, 2019 7:22 am
Forum: Developers
Topic: programmatic access to SMS via FHIR?
Replies: 1
Views: 366

Re: programmatic access to SMS via FHIR?

That is not possible with the API as it currently is. We have many other improvements we want to do for FHIR, so this probably would be low on the list.
by cmcgehee
Tue Sep 17, 2019 6:57 am
Forum: Main Forum
Topic: eRx on eServices
Replies: 2
Views: 566

Re: eRx on eServices

I would think this is probably some setting that needs to be modified. If you call support, they should be able to figure it out.
by cmcgehee
Mon Sep 16, 2019 7:26 am
Forum: Developers
Topic: New Hooks
Replies: 5
Views: 696

Re: New Hooks

We generally release a new version in September of October. I haven't heard anything official about when we'll release, but it should be in the next few weeks.
by cmcgehee
Thu Sep 12, 2019 10:18 am
Forum: Advanced Topics
Topic: Archive vs. inactive
Replies: 11
Views: 7488

Re: Archive vs. inactive

"Approved" simply means we have determined this to be a valid feature request. A feature request typically arrives at this status a week or two after it is created. When the status is "Completed", that means it will be a part of the next major update. You can add the votes from your office to a requ...
by cmcgehee
Mon Sep 09, 2019 3:27 pm
Forum: Advanced Topics
Topic: v19.2.18 Graphic Report Error
Replies: 6
Views: 852

Re: v19.2.18 Graphic Report Error

If the issue isn't caused by anything Patrick mentioned, I would suspect compiler shenanigans. The code where you're getting the error is in a different dll, OpenDentalGraph.dll, so if that didn't get recompiled when OpenDentBusiness got recompiled, then the PrefName enum could be pointing to a diff...
by cmcgehee
Mon Sep 09, 2019 3:09 pm
Forum: Developers
Topic: EDS Statement Email
Replies: 3
Views: 527

Re: EDS Statement Email

Ah, that makes sense. Would you mind emailing me so we can discuss this a little more? chris@opendental.com.
by cmcgehee
Mon Sep 09, 2019 11:07 am
Forum: Developers
Topic: EDS Statement Email
Replies: 3
Views: 527

Re: EDS Statement Email

I don't think we would want to change this to always send the email. I don't know what the ramifications would be of always sending the email to EDS. EDS might perform different actions based on whether or not that email field is present.
by cmcgehee
Mon Sep 09, 2019 8:22 am
Forum: Developers
Topic: Hook Request
Replies: 3
Views: 441

Re: Hook Request

We should be able to get this added for you. To clarify, do you only want it added to FormClaimsSend.FormClaimsSend_Load?
by cmcgehee
Mon Sep 09, 2019 8:20 am
Forum: Developers
Topic: FHIR API server errors
Replies: 11
Views: 1006

Re: FHIR API server errors

Well, your eConnector is definitely shutting down and restarting. The eConnector logs generally don't say why it's starting or stopping, so you'll have to figure that out yourself. Maybe the computer is restarting, maybe the eConnector service does not have a startup type of automatic.
by cmcgehee
Tue Sep 03, 2019 8:02 am
Forum: Developers
Topic: Book appointment leads to unexplainable result
Replies: 10
Views: 1009

Re: Book appointment leads to unexplainable result

You make a good point that you don't have any way to find which operatory the appointment should be scheduled in. I have submitted a job proposal to add the information about which provider is assigned to which operatory in the API.
by cmcgehee
Tue Sep 03, 2019 7:44 am
Forum: Developers
Topic: Visual Studio 2017 / 2019?
Replies: 1
Views: 454

Re: Visual Studio 2017 / 2019?

We are using Visual Studio 2019.
by cmcgehee
Tue Sep 03, 2019 7:43 am
Forum: Developers
Topic: FHIR API server errors
Replies: 11
Views: 1006

Re: FHIR API server errors

In the location where the eConnector is installed, there is a folder named "Logger". There should be some files in there that help show what is going on, particularly the ProxyRemoteImmortal, EConnectorService, and LogWeb folders.
by cmcgehee
Tue Sep 03, 2019 7:36 am
Forum: Advanced Topics
Topic: Drag and drop PDFs to Image model as Administrator
Replies: 1
Views: 539

Re: Drag and drop PDFs to Image model as Administrator

This is expected behavior, and it happens with all programs in Windows, not just Open Dental. Basically, the medium privilege process (File Explorer) isn't allowed to send messages to the high privilege process (Open Dental). This article has more details: https://blogs.msdn.microsoft.com/patricka/2...
by cmcgehee
Wed Aug 28, 2019 4:50 pm
Forum: Advanced Topics
Topic: SFTP for images
Replies: 2
Views: 494

Re: SFTP for images

How are the SFTP credentials protected? The username is stored the the Open Dental database in plain text. The password is obfuscated and also stored in the database. Are there any plans for (or is it currently possible but undocumented) implementing key based authentication with the SFTP server? W...
by cmcgehee
Mon Aug 26, 2019 9:49 am
Forum: Developers
Topic: Book appointment leads to unexplainable result
Replies: 10
Views: 1009

Re: Book appointment leads to unexplainable result

You can find the name of the practitioner by

Code: Select all

GET https://api.opendental.com/fhir/v2/practitioner/3
I see in your appointment create request there is

Code: Select all

"actor": {
    "reference": "Location/1"
},
You can find the name of the operatory (location) by

Code: Select all

GET https://api.opendental.com/fhir/v2/location/1
by cmcgehee
Mon Aug 26, 2019 9:40 am
Forum: Developers
Topic: FHIR API server errors
Replies: 11
Views: 1006

Re: FHIR API server errors

Giovanni, it looks like your eConnector is not running. Once you turn it on, this error should go away.
by cmcgehee
Thu Aug 22, 2019 3:21 pm
Forum: Developers
Topic: Book appointment leads to unexplainable result
Replies: 10
Views: 1009

Re: Book appointment leads to unexplainable result

In your screenshot "Dr. Brian Albert" is the name of the operatory the appointment is in. The provider on the actual appointment is "DOC1". It may be that you scheduled an appointment with one provider in another provider's operatory. In the Edit Appointment window, the procedures grid lists all tre...
by cmcgehee
Thu Aug 22, 2019 3:16 pm
Forum: Developers
Topic: FHIR practitioners speciality nomenclature discrepancies
Replies: 3
Views: 500

Re: FHIR practitioners speciality nomenclature discrepancies

The demo API key is connecting to a personal database that I used for a couple years. At some point, I must have changed "General" to "Generalist".
by cmcgehee
Thu Aug 22, 2019 2:21 pm
Forum: Advanced Topics
Topic: Image Module Error v19.2.6
Replies: 1
Views: 455

Re: Image Module Error v19.2.6

I think we have fixed this error. Try updating to 19.2.18 and see if that helps.
by cmcgehee
Thu Aug 22, 2019 7:27 am
Forum: Developers
Topic: FHIR practitioners speciality nomenclature discrepancies
Replies: 3
Views: 500

Re: FHIR practitioners speciality nomenclature discrepancies

Correct me if I'm wrong, but I believe the only place in FHIR that uses practitioner specialties is in the Practitioner resource. These specialties can be custom set by the office, so there is no standardized nomenclature.
by cmcgehee
Tue Aug 20, 2019 4:04 pm
Forum: Advanced Topics
Topic: v19.2.6 Double Payment Posting
Replies: 6
Views: 1029

Re: v19.2.6 Double Payment Posting

We do have a Database Maintenance method to fix this: PaymentMissingPaySplit. It will delete these phantom payments when you run it.
by cmcgehee
Tue Aug 20, 2019 8:33 am
Forum: Developers
Topic: FHIR API: book appointment with procedure possible?
Replies: 13
Views: 1704

Re: FHIR API: book appointment with procedure possible?

Here is an example POST request to create a ServiceRequest. It will create a treatment planned procedure for a filling on tooth 18 on the distal lingual surface for patient 5 with practitioner 1. { "status": "active", "intent": "proposal", "code": { "coding": [{ "system": "http://hl7.org/fhir/us/sid...
by cmcgehee
Mon Aug 19, 2019 8:41 am
Forum: Developers
Topic: FHIR API: book appointment with procedure possible?
Replies: 13
Views: 1704

Re: FHIR API: book appointment with procedure possible?

First, why does it work when I use your FHIR key and not when I use my personal key? Are you getting the same errors you were getting in the post from Aug 12, 2019 7:09 am? If so, it sounds like the Location resource you're including on the appointment does not exist. First, perform a GET request a...
by cmcgehee
Mon Aug 19, 2019 8:26 am
Forum: Main Forum
Topic: Larger font
Replies: 3
Views: 867

Re: Larger font

There is not. You could vote on feature request #1592 if you would like to see everything with a larger font. Alternatively, you could submit a new feature request to show a larger font on just the appointment schedule display.
https://opendental.com/manual/featurerequests.html
by cmcgehee
Mon Aug 19, 2019 8:23 am
Forum: Main Forum
Topic: More than one e-mail address or phone number in a field
Replies: 2
Views: 630

Re: More than one e-mail address or phone number in a field

It doesn't really work to enter multiple emails or phone numbers in those fields because when we programmatically try to text or email, it wouldn't work. The best place to put these would probably be in the Address and Phone Notes field.
by cmcgehee
Mon Aug 19, 2019 8:21 am
Forum: Main Forum
Topic: Remote support on machines with SRP
Replies: 3
Views: 754

Re: Remote support on machines with SRP

Could you make sure GoToAssist gets installed to the same location on everyone's computer and then whitelist that location?
by cmcgehee
Wed Aug 14, 2019 2:13 pm
Forum: Advanced Topics
Topic: Error on Database Maint
Replies: 3
Views: 588

Re: Error on Database Maint

Thanks for letting us know. We'll get that fixed.
by cmcgehee
Tue Aug 13, 2019 4:48 pm
Forum: Advanced Topics
Topic: Potential bug in XVweb integration
Replies: 9
Views: 1692

Re: Potential bug in XVweb integration

Ardavan,

We were able to fix this bug in 19.1.46 and 19.2.15: "Images Module, downloading Apteryx XVWeb images caused an error sometimes."

Let us know if you have any more problems once you update.
by cmcgehee
Tue Aug 13, 2019 7:50 am
Forum: Developers
Topic: Sample JSON for practitioner with multiple specialties?
Replies: 4
Views: 689

Re: Sample JSON for practitioner with multiple specialties?

The "specialty" is an array because we are following the FHIR standard which dictates this field should be formatted as a list. We, Open Dental, then have a business rule that the practitioner can have only one specialty.
by cmcgehee
Mon Aug 12, 2019 5:03 pm
Forum: Main Forum
Topic: How Imaging Bridges Work
Replies: 1
Views: 496

Re: How Imaging Bridges Work

That is how most imaging software works with Open Dental. There are a few that are more advanced that allow you to view images inside Open Dental; XVWeb is one that I know of.
by cmcgehee
Mon Aug 12, 2019 11:25 am
Forum: Developers
Topic: FHIR API: book appointment with procedure possible?
Replies: 13
Views: 1704

Re: FHIR API: book appointment with procedure possible?

Here's an example. I'm using the test API key (JAvSDW5ezml37elr) on v2. First you'll need to create the procedures (unless you want to use ones that are already existing). I make a POST to https://api.opendental.com/fhir/v2/procedure with this body: { "status": "completed", "code": { "coding": [{ "s...
by cmcgehee
Mon Aug 12, 2019 11:08 am
Forum: Developers
Topic: Sample JSON for practitioner with multiple specialties?
Replies: 4
Views: 689

Re: Sample JSON for practitioner with multiple specialties?

In the Open Dental program, it is possible to set the provider's specialty to a single specialty only, so the API does not support multiple specialties.
by cmcgehee
Wed Aug 07, 2019 2:03 pm
Forum: Advanced Topics
Topic: Archive vs. inactive
Replies: 11
Views: 7488

Re: Archive vs. inactive

There is not. The Patient Status Setter can change active patients to inactive. https://opendental.com/manual/patientstatussetter.html
by cmcgehee
Wed Aug 07, 2019 1:46 pm
Forum: Main Forum
Topic: Finance charges added to production??
Replies: 1
Views: 404

Re: Finance charges added to production??

The finance charges do get added to the Dr's net production since adjustments are included in net production. There is not a way to have the charges go on a different provider; they always go on the guarantor's primary provider. You can add votes to feature request #3482 to help get this feature add...
by cmcgehee
Wed Aug 07, 2019 7:47 am
Forum: Main Forum
Topic: Provider field on the statements.
Replies: 2
Views: 545

Re: Provider field on the statements.

There is a feature request #4034 you could vote on, although this one includes NPI and license number as well. If you wanted just the provider name, you can add a new feature request.
by cmcgehee
Tue Aug 06, 2019 10:13 am
Forum: Developers
Topic: Integration of Open Dental Database
Replies: 3
Views: 855

Re: Integration of Open Dental Database

It depends from practice to practice. We have some large practices that have dozens or hundreds of different locations in one database. There are also many practices where each physical location has their own database. You can access all these different databases from our API endpoint, but you will ...
by cmcgehee
Thu Aug 01, 2019 2:52 pm
Forum: Developers
Topic: Implementation Question
Replies: 1
Views: 470

Re: Implementation Question

The way this process works, you identify the locations you want the hooks and post those hook requests to this forum. Then we will commit the hooks ourselves. Your customers will then be able to download the normal version of Open Dental and it will have all the hooks you need for your program. This...
by cmcgehee
Thu Aug 01, 2019 2:49 pm
Forum: Advanced Topics
Topic: v19.2.6 Double Payment Posting
Replies: 6
Views: 1029

Re: v19.2.6 Double Payment Posting

If you were able to identify the steps to consistently produce this behavior, we would look into it.
by cmcgehee
Tue Jul 30, 2019 3:30 pm
Forum: Advanced Topics
Topic: potential bug: CEMT Sync on middle tier
Replies: 3
Views: 670

Re: potential bug: CEMT Sync on middle tier

I've spent some time digging into this, and the behavior you're describing would happen if the user you've logged in to CEMT doesn't exist or has a different password in the database you're syncing to. Are you able to log in to all middle tier connections using your CEMT credentials?
by cmcgehee
Thu Jul 25, 2019 12:08 pm
Forum: Advanced Topics
Topic: v 19.2 Pt Dashboard/Database Efficiency
Replies: 4
Views: 773

Re: v 19.2 Pt Dashboard/Database Efficiency

We will keep an ear out for other customers that have slowness, and we might look into another round of enhancements.
by cmcgehee
Thu Jul 25, 2019 8:53 am
Forum: Advanced Topics
Topic: v 19.2 Pt Dashboard/Database Efficiency
Replies: 4
Views: 773

Re: v 19.2 Pt Dashboard/Database Efficiency

We did put quite a bit of work into the dashboard efficiency for 19.2. Are you on version 19.1 or 19.2?
by cmcgehee
Thu Jul 25, 2019 8:14 am
Forum: Developers
Topic: Refreshing Apptbook programmatically
Replies: 7
Views: 906

Re: Refreshing Apptbook programmatically

Could you use reflection to invoke it?
by cmcgehee
Wed Jul 24, 2019 12:53 pm
Forum: Advanced Topics
Topic: potential bug: CEMT Sync on middle tier
Replies: 3
Views: 670

Re: potential bug: CEMT Sync on middle tier

I've created a ticket for us to look into this. We'll get back to you once we have an answer.
by cmcgehee
Wed Jul 24, 2019 10:23 am
Forum: Main Forum
Topic: Signatures in OD
Replies: 1
Views: 426

Re: Signatures in OD

There is an option to not allow patients to type their signature. If you select this option, the patient would only be able sign an actual signature in the form. To do this, in the Web Forms setup window, check "Disable typed signatures", then copy the URL it generates, and send that URL in your ema...
by cmcgehee
Tue Jul 23, 2019 12:11 pm
Forum: Developers
Topic: Refreshing Apptbook programmatically
Replies: 7
Views: 906

Re: Refreshing Apptbook programmatically

This might be due to the patient dashboard we added in 19.1. Instead of adding the module controls directly to FormOpenDental, we now add them to FormOpenDental.splitContainerNoFlickerDashboard.Panel1.
by cmcgehee
Tue Jul 23, 2019 11:30 am
Forum: Developers
Topic: Refreshing Apptbook programmatically
Replies: 7
Views: 906

Re: Refreshing Apptbook programmatically

We've been rewriting the appointment module to improve its performance. There is now a class named ContrApptJ which is the new appointment module. There is a preference 'ApptModuleUses2019Overhaul'; if true, ContrApptJ will be used. If false, ContrAppt will be used. I believe you'll have to look for...
by cmcgehee
Tue Jul 23, 2019 11:24 am
Forum: Main Forum
Topic: WYSIWYG HTML and Open Dental
Replies: 9
Views: 1027

Re: WYSIWYG HTML and Open Dental

Sorry I didn't mention that before, but that checkbox is available starting in 19.2 which is currently in beta.
by cmcgehee
Tue Jul 23, 2019 7:47 am
Forum: Main Forum
Topic: WYSIWYG HTML and Open Dental
Replies: 9
Views: 1027

Re: WYSIWYG HTML and Open Dental

It appears to me that the one thing that is not working is images. It looks like we don't have a way to include images in "raw HTML" mode. I'll look into to see if we can get that added.

Image
by cmcgehee
Mon Jul 22, 2019 4:55 pm
Forum: Advanced Topics
Topic: Using artificial intelligence in dentistry
Replies: 4
Views: 968

Re: Using artificial intelligence in dentistry

My take on "AI-powered" chatbots is that they are still too brittle to do much useful work. At this point, an online form would be more effective for scheduling appointments. I do agree that machine image recognition is ready to start diagnosing dental caries, but I don't think Open Dental is the ri...
by cmcgehee
Mon Jul 22, 2019 4:40 pm
Forum: Main Forum
Topic: Patients schedule appointments automatically via voice
Replies: 1
Views: 502

Re: Patients schedule appointments automatically via voice

Open Dental does have one part of the program that does use voice: the perio chart. If you're interested in looking at the source code for it, download it following the instructions on https://www.opendental.com/site/sourcecode.html and search for FormPerioVoice.cs. Just adding voice control to this...
by cmcgehee
Mon Jul 22, 2019 7:52 am
Forum: Main Forum
Topic: WYSIWYG HTML and Open Dental
Replies: 9
Views: 1027

Re: WYSIWYG HTML and Open Dental

Ideally, we would like our users to be able to paste WYSIWYG HTML into the Open Dental email, but there may be some kinks to work out first. First, I would like to ask, in the HTML Email Editor in Open Dental, do you have "Use Raw HTML" checked? If yes, and you're getting this error, can you paste t...
by cmcgehee
Wed Jul 17, 2019 11:27 am
Forum: Main Forum
Topic: Mobile web appointment deleted not logged in audit log!
Replies: 2
Views: 284

Re: Mobile web appointment deleted not logged in audit log!

There is an outstanding feature request (#7759) for adding permission levels to users in Mobile Web. You can add votes to make that request a higher priority. I don't see a request to add logging when deleting an appointment in Mobile Web, so you may want to add that as a new feature request. https:...
by cmcgehee
Mon Jul 15, 2019 3:12 pm
Forum: Developers
Topic: FHIR API: book appointment with procedure possible?
Replies: 13
Views: 1704

Re: FHIR API: book appointment with procedure possible?

Giovanni, This is available if your Open Dental database is on 19.2. The Appointment resource has two new fields: reasonReference and basedOn. To link completed procedures to a completed appointment, include those procedures in the reasonReference field. To link treatment planned procedures to a sch...
by cmcgehee
Mon Jul 15, 2019 2:33 pm
Forum: Advanced Topics
Topic: (Betav19) Appt Book View Flashes Blank then Shows the Appts
Replies: 3
Views: 643

Re: (Betav19) Appt Book View Flashes Blank then Shows the Ap

You should keep it at 0. We're not ready to switch it to 1 yet.

If this happens with other customers on 19.2, we'll collect their database and see if we can pinpoint where the slowness is coming from.
by cmcgehee
Mon Jul 15, 2019 10:43 am
Forum: Advanced Topics
Topic: (Betav19) Appt Book View Flashes Blank then Shows the Appts
Replies: 3
Views: 643

Re: (Betav19) Appt Book View Flashes Blank then Shows the Ap

I don't think we changed anything major in the Appointment module in 19.2. We're on the same version here at OD HQ and the Appointment module is snappy. Just out of curiosity, what is the result of this query for you?

Code: Select all

select * from preference where prefname like 'ApptModuleUses2019Overhaul'
by cmcgehee
Mon Jul 15, 2019 8:39 am
Forum: Developers
Topic: Direct Database Modifications
Replies: 1
Views: 458

Re: Direct Database Modifications

Based on your description, the actions you are performing can be accomplished through our FHIR API: https://www.opendental.com/manual/fhir.html . That is the only manner in which modifying data is supported. There are vendors out there who run SQL statements against customer databases'. Open Dental ...
by cmcgehee
Mon Jul 15, 2019 8:33 am
Forum: Developers
Topic: Detail against Specific Procedure
Replies: 3
Views: 557

Re: Detail against Specific Procedure

If you mean adjustment.AdjNum, then yes, that is maintained by Open Dental since it is the primary key of that table.
by cmcgehee
Mon Jul 15, 2019 7:50 am
Forum: Main Forum
Topic: Progress Notes Width Help
Replies: 2
Views: 546

Re: Progress Notes Width Help

This can be changed in the Show tab of the Chart module: https://www.opendental.com/manual/showtabchart.html.
by cmcgehee
Wed Jul 10, 2019 12:20 pm
Forum: Main Forum
Topic: Hipaa and HITECH Requirements for Cloud hosting on AWS
Replies: 2
Views: 517

Re: Hipaa and HITECH Requirements for Cloud hosting on AWS

I would recommend detailing how data in transit would be encrypted. You would want to use either TLS with MySQL or set up an SSH tunnel for MySQL traffic. This page goes into detail about encryption: https://dev.mysql.com/doc/refman/5.5/en ... tions.html.
by cmcgehee
Wed Jul 10, 2019 12:11 pm
Forum: Main Forum
Topic: Statements
Replies: 1
Views: 256

Re: Statements

The best way to do this would be to mark these patients as a special billing type and then exclude that billing type when you create statements.
by cmcgehee
Wed Jul 10, 2019 7:46 am
Forum: Developers
Topic: Detail against Specific Procedure
Replies: 3
Views: 557

Re: Detail against Specific Procedure

Yes, the description of all columns for all tables in the database can be found on https://www.opendental.com/OpenDentalDocumentation19-1.xml . - Transaction ID for Procedure Production This would be procedurelog.ProcNum. - Patient Payment collection or deposit Date You can link use the paysplit tab...
by cmcgehee
Tue Jul 09, 2019 4:15 pm
Forum: Developers
Topic: Hook Request
Replies: 5
Views: 939

Re: Hook Request

coolprep25,

Could you write out the code for the hook, including several lines before and after the hook? This will help us make sure we get the exact form that will be helpful to you.
by cmcgehee
Tue Jul 09, 2019 10:29 am
Forum: Main Forum
Topic: Finance Charges
Replies: 1
Views: 295

Re: Finance Charges

You can add finance charges to those accounts, but it isn't totally automated. You would go into the Finance Change window once a month to add the charges to the overdue accounts. This page explains it: https://opendental.com/manual/financecharges.html.
by cmcgehee
Mon Jul 08, 2019 5:13 pm
Forum: Advanced Topics
Topic: HL7 between OD instances
Replies: 2
Views: 614

Re: HL7 between OD instances

I have not heard of anyone using HL7 to sync OD databases, but I like the creativity in the idea. This setup would be very limited; it would only automatically send appointments and patient information. It could send procedures, but you have to manually click a button the in the Chart module to do t...
by cmcgehee
Mon Jul 08, 2019 7:45 am
Forum: Main Forum
Topic: Open Dental on the Cloud using Amazon Server AWS
Replies: 16
Views: 2113

Re: Open Dental on the Cloud using Amazon Server AWS

That is a good step to restrict traffic to and from your office's IP addresses, but that still leaves a security problem in that that traffic is unencrypted. A third party who was able to collect packets between your office and your cloud could read large amounts of patient information.
by cmcgehee
Wed Jun 26, 2019 1:55 pm
Forum: Developers
Topic: FHIR API: how to get a list of available procedures?
Replies: 3
Views: 633

Re: FHIR API: how to get a list of available procedures?

There is not a way to get available procedures through the API.
by cmcgehee
Wed Jun 26, 2019 1:53 pm
Forum: Advanced Topics
Topic: Potential bug in XVweb integration
Replies: 9
Views: 1692

Re: Potential bug in XVweb integration

19.1 will be stable in the nearish future.
by cmcgehee
Tue Jun 25, 2019 8:18 am
Forum: Developers
Topic: FHIR API: how to get a list of available procedures?
Replies: 3
Views: 633

Re: FHIR API: how to get a list of available procedures?

You are correct that in order to meet this use case you (the API consumer) would need to store a list of possible procedure and categorize them when presenting to a patient.
by cmcgehee
Mon Jun 24, 2019 7:48 am
Forum: Developers
Topic: FHIR API: book appointment with procedure possible?
Replies: 13
Views: 1704

Re: FHIR API: book appointment with procedure possible?

Coming soon in 19.2: attach procedures to appointments through FHIR.
by cmcgehee
Mon Jun 24, 2019 7:46 am
Forum: Main Forum
Topic: Cyber Security, etc.
Replies: 3
Views: 698

Re: Cyber Security, etc.

Gene, that's good to see your thinking about this sort of thing. Here are some practices to follow for best security: -Set a MySQL password -Make sure your database is not exposed to the public internet -Make sure the database files on your server are not shared to your internal network -Don't use y...
by cmcgehee
Mon Jun 17, 2019 8:54 am
Forum: Main Forum
Topic: Patient Dashboard - 19.1 Version
Replies: 5
Views: 984

Re: Patient Dashboard - 19.1 Version

Kezian,

Can you submit a feature request to only show the patient dashboard on certain modules? This is how we know what is high priority for our offices so we can fix.
https://www.opendental.com/manual/featurerequests.html
by cmcgehee
Wed Jun 12, 2019 11:57 am
Forum: Developers
Topic: FHIR API: booking appointment "Unscheduled status" none ...
Replies: 6
Views: 1056

Re: FHIR API: booking appointment "Unscheduled status" none

There are a couple ways you can do this. The first way is to change "status" to "noshow". This will change the appointment to a Broken appointment in Open Dental and I believe it will stay on the appointment book. The other way is to change "status" to "pending". This will send the appointment to th...
by cmcgehee
Wed Jun 12, 2019 8:34 am
Forum: Developers
Topic: FHIR API: booking appointment "Unscheduled status" none ...
Replies: 6
Views: 1056

Re: FHIR API: booking appointment "Unscheduled status" none

When booking an appointment, you should leave the Unscheduled Status as none. You only need to set that when the appointment is unscheduled and you want to indicate why it is unscheduled. To set the Confirmed field to Appointment Confirmed, set the "status" field on the patient participant to "accep...
by cmcgehee
Wed Jun 12, 2019 8:26 am
Forum: Developers
Topic: FHIR API: appointment date range search gives wrong results
Replies: 7
Views: 1043

Re: FHIR API: appointment date range search gives wrong resu

The FHIR standard stipulates that for the appointment date search parameter, the date should only apply to the "start" field. https://www.hl7.org/fhir/appointment.html My interpretation of the FHIR standard leads me to believe that le2019-06-11 is equivalent to le2019-06-11T23:59:59. From https://ww...
by cmcgehee
Thu Jun 06, 2019 10:53 am
Forum: Developers
Topic: RESTful API error
Replies: 6
Views: 984

Re: RESTful API error

The link you mentioned is the best documentation I know of for the capability statement. If you're looking for the practice name, use: https://api.opendental.com/fhir/organization/0 We've decided to represent clinics as Organization resources and we represent the practice as an Organization with an ...
by cmcgehee
Thu Jun 06, 2019 8:34 am
Forum: Developers
Topic: FHIR use-case appointments for date
Replies: 2
Views: 578

Re: FHIR use-case appointments for date

In your snapshot, there are no appointments scheduled. What you are seeing is times where the provider is scheduled to work in an operatory. * Why some times the GET parameter value has the form `organization/0` and for location `1,2,3,etc`? I suspected a mistake in the document and tried with `loca...
by cmcgehee
Thu Jun 06, 2019 8:18 am
Forum: Developers
Topic: NP scheduling link request
Replies: 1
Views: 482

Re: NP scheduling link request

Where would you like the prompt to log into the patient portal located?
by cmcgehee
Thu Jun 06, 2019 8:13 am
Forum: Developers
Topic: RESTful API error
Replies: 6
Views: 984

Re: RESTful API error

Yes, you can find that in the capability statement: https://api.opendental.com/fhir/capabilitystatement. There is a software.version field that will tell you the version of Open Dental. This capability statement will tell you information specific for the office linked to the API key you include.
by cmcgehee
Wed Jun 05, 2019 3:46 pm
Forum: Developers
Topic: RESTful API error
Replies: 6
Views: 984

Re: RESTful API error

Giovanni, I think I've found your account, and it looks like you're on version 18.3 of Open Dental. To access the API via https://api.opendental.com/ you need to be on at least 18.4. We added some new resources in 19.1 so if you have a test database, you might want to update to that version. I think...
by cmcgehee
Tue May 28, 2019 9:04 am
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

Re: FHIR with trial version

Giovanni,

Go ahead and email vendor.relations@opendental.com to request a developer registration key.
by cmcgehee
Thu May 16, 2019 8:10 am
Forum: Main Forum
Topic: Importing emails from gmail.
Replies: 5
Views: 986

Re: Importing emails from gmail.

Yes, you can set this up by following the links Jason posted above.
by cmcgehee
Wed May 15, 2019 12:02 pm
Forum: Advanced Topics
Topic: Database Merge
Replies: 2
Views: 765

Re: Database Merge

Database merges are handled by our Conversions department, and I don't think they look at this forum. You could email them at conversions@opendental.com with your questions.
by cmcgehee
Tue May 14, 2019 3:19 pm
Forum: Developers
Topic: Individual and Family Insurance Summary
Replies: 1
Views: 538

Re: Individual and Family Insurance Summary

It is dynamically calculated each time it is viewed. It is not stored in the database anywhere.
by cmcgehee
Tue May 14, 2019 7:19 am
Forum: Developers
Topic: Missing form FormWebChatTool.cs
Replies: 3
Views: 605

Re: Missing form FormWebChatTool.cs

I see that the class FormWebChatTools is in the file FormWebChatSessions.cs in 18.4, but that shouldn't cause a problem compiling.
by cmcgehee
Mon May 13, 2019 12:55 pm
Forum: Developers
Topic: DB Export of QueryList Examples
Replies: 3
Views: 619

Re: DB Export of QueryList Examples

We do not have a way to distribute this list as a dump file.
by cmcgehee
Mon May 13, 2019 8:07 am
Forum: Main Forum
Topic: OD WiFi Implementation, Feasible?
Replies: 3
Views: 743

Re: OD WiFi Implementation, Feasible?

Open Dental works pretty well over a wireless connection. As long as you have decent bandwidth and a reliable router, it should work all right. It is very important that you encrypt all traffic traveling over WiFi since traffic to and from the database is not encrypted. WiFi isn't encrypted by defau...
by cmcgehee
Mon May 13, 2019 7:58 am
Forum: Developers
Topic: Missing form FormWebChatTool.cs
Replies: 3
Views: 605

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: 722

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: 533

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: 415

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: 534

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: 698

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: 616

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: 855

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: 529

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: 1
Views: 398

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: 1218

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: 1218

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: 733

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: 1486

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: 1486

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: 1218

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: 1218

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: 1048

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: 859

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: 859

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: 1218

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 9:00 am
Forum: Main Forum
Topic: Fee Schedule comparison by procedure codes
Replies: 6
Views: 859

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 9:02 am
Forum: Main Forum
Topic: eServices and a logged in user
Replies: 1
Views: 399

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 9:15 am
Forum: Advanced Topics
Topic: CEMT over Middle Tier
Replies: 12
Views: 1855

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 9:10 am
Forum: Main Forum
Topic: Edit Ins Window
Replies: 3
Views: 654

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 6:49 pm
Forum: Advanced Topics
Topic: CEMT over Middle Tier
Replies: 12
Views: 1855

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 11:04 am
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

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 8:47 am
Forum: Advanced Topics
Topic: human readable in MySQL
Replies: 5
Views: 1043

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 8:43 am
Forum: Main Forum
Topic: Edit Ins Window
Replies: 3
Views: 654

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 8:45 am
Forum: Advanced Topics
Topic: human readable in MySQL
Replies: 5
Views: 1043

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 8:40 am
Forum: Main Forum
Topic: Using AFTERPAY or ZIPPAY
Replies: 2
Views: 799

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 6:29 pm
Forum: Main Forum
Topic: Voice Perio Charting
Replies: 5
Views: 912

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 8:39 am
Forum: Main Forum
Topic: Voice Perio Charting
Replies: 5
Views: 912

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 7:01 pm
Forum: Main Forum
Topic: Getting rid of insurance write-offs
Replies: 1
Views: 553

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 2:39 pm
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 1425

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 8:47 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 1425

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 8:43 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 1425

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 9:36 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 1425

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 9:05 am
Forum: Advanced Topics
Topic: Avoiding server conflicts
Replies: 13
Views: 1564

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 9:01 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 1425

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 4:26 pm
Forum: Advanced Topics
Topic: Avoiding server conflicts
Replies: 13
Views: 1564

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 8:50 am
Forum: Developers
Topic: 18.4 Conversion corrupted DB
Replies: 5
Views: 918

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 9:14 am
Forum: Main Forum
Topic: Automation Event Trigger
Replies: 10
Views: 1425

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 9:16 am
Forum: Main Forum
Topic: Login required for OD SVN server?
Replies: 3
Views: 676

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 8:54 am
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

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 3:07 pm
Forum: Developers
Topic: Hook Requests
Replies: 6
Views: 947

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 9:31 am
Forum: Developers
Topic: Hook Requests
Replies: 6
Views: 947

Re: Hook Requests

Yep, I can add those, too.
by cmcgehee
Mon Dec 10, 2018 9:11 am
Forum: Developers
Topic: FHIR with trial version
Replies: 23
Views: 3820

Re: FHIR with trial version

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

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 1:26 pm
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 5565

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 9:10 am
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 5565

Re: Daily Production goals

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

Re: Hook Request: FormConfirmationSetup

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

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 9:49 am
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 1028

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 9:03 am
Forum: Main Forum
Topic: Statement Note
Replies: 2
Views: 558

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 10:10 am
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 1028

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 11:09 am
Forum: Main Forum
Topic: Frequency Limitations
Replies: 3
Views: 890

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 12:11 pm
Forum: Developers
Topic: What triggers Patient balance update
Replies: 1
Views: 509

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 12:08 pm
Forum: Main Forum
Topic: Frequency Limitations
Replies: 3
Views: 890

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: 672

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: 631

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: 1002

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: 755

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: 769

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: 854

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: 854

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: 2648

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...