Open Dental Forum

cmcgehee

Once plugins are loaded, there isn't any way to reload them without restarting the program.

cmcgehee

When I have this issue, sometimes it helps to remove the project references and re-add them.

cmcgehee

Thanks, I'll have one of our engineers look into this issue.

cmcgehee

Would you mind telling me the version of Open Dental the database is on that you are sending requests to? In 20.2.29 we fixed an issue that had to do with Slots.

cmcgehee

Poonam,

You should be able to use commas to include multiple schedules to get slots for multiple operatories in one request. For example:

Code: Select all

https://api.opendental.com/fhir/v2/slot?schedule=20200921L1,20200921L2,20200921L3&status=free

cmcgehee

We've committed the fix for this error. It will be available in 20.2.44 and 20.3.27. We still might have some more work to do after this because we noticed that when using the status "cancelled" it will give the appointment a status of "noshow".

cmcgehee

Hi poonam, When querying for https://api.opendental.com/fhir/v2/slot?schedule=20200923L1&status=free, it will return any slots in operatory 1 for the date 2020-09-23. First thing I would check is if you have an operatory where OperatoryNum=1. You can run this user query to check: SELECT * FROM opera...

cmcgehee

Would you mind posting the error you're getting in a new thread?

cmcgehee

Do you have the full details from the error?

cmcgehee

Yes, currently the recommended best practice is to use queries to update these tables.

cmcgehee

You can follow the step at the end of https://opendental.com/site/sourcecode.html : Error: The name 'OpenDental.Thinfinity' does not exist in the current context - In the OpenDental project, remove the VirtualWeb reference. Then right-click on "References" -> "Add Reference". Select the Browse dropd...

cmcgehee

We do have a pending enhancement to allow Web Sched to schedule further in the future. I've put a note on that job to update this forum post once it's complete.

cmcgehee

On my computer it also says Sparks3D.dll not found, so it might not be ready for everyone.

cmcgehee

I think we are going to need to collect a copy of your database to locate the bug. Would you mind calling support again?

I made a change on our side to remove your eConnector from the blacklist. Try restarting it again.

cmcgehee

This only difference between those two is that one causes FormTxtMsgEdit.SendText to return false and the other causes it to return true. I actually would recommend implementing both of them. In FormTxtMsgEdit.SendText_Start, I would attempt to send the text message, and if you are successful, have ...

cmcgehee

It is running now. Let me know if you experience any issues with it.

cmcgehee

I should be able to get it running this afternoon, maybe 3 or 4 PM PT.

cmcgehee

I've created a task internally to fix the error you're getting with DBM. The reason why we make backups as MyISAM is because creating the backup is much faster that way. I think we would have to look at the rest of your log files to figure out why your eConnector is not working. If you call support,...

cmcgehee

I think you're seeing the alert that was created before you changed the update server name. You can just delete the alert as long as the eConnector is running fine now.

cmcgehee

An error like this is likely due to corruption in your database. I would run Database Maintenance on 19.3 and then try updating again. If you still get the error, call in to our support, and we'll hunt down the source.

cmcgehee

You would have to connect to the database directly. The table that contains patient forms is the Sheet table.
https://www.opendental.com/OpenDentalDo ... .xml#sheet

cmcgehee

It looks like our test server has a failing hard drive. I'll post here once we get it fixed.

cmcgehee

We understand that the API is limited in its utility. Because we have had instances where 3rd party developers have violated the integrity of the Open Dental database, we have begun to discourage directly writing to the database. Currently this is not more than a recommendation, but in the future we...

cmcgehee

Thanks, we'll get that added.

cmcgehee

Please list the exact line of code you would like us to add, and we will add it if it is possible.

cmcgehee

It doesn't look like PatNum exists in this class. Would you mind writing out the exact like of code you would like us to insert?

cmcgehee

Hi pid_user, would you like us to pass any additional fields or variables as arguments to the FormClaimPayEdit hook?

cmcgehee

I see. I tried to publish the OpenDental project and got the same error as you. When I try to do a simple build, it continues giving me the same error. I would recommend downloading the source code to a new folder and trying to build (not publish). You can ignore all the warnings. They won't prevent...

cmcgehee

We never use the Publish feature for the OpenDental project, so I don't think we'll be able to help you. StackOverflow would be a better source of assistance. I believe the Windows.winmd file is only used to store user credentials for middle tier. If you don't need that feature, you can remove the r...

cmcgehee

What version of Windows are you publishing on? I believe Windows.winmd only works on Windows 8 and later.

cmcgehee

When I get designer errors like these, usually some combination of cleaning the solution, rebuilding the solution, and closing Visual Studio does the trick.

cmcgehee

Mihn,

This has been fixed in 19.4.39 and 20.1.17.

cmcgehee

I'm not exactly sure what could be causing that error. Do have .NET 4.7.2 installed? Recently we updated all our projects to that version. Are you able to build the OpenDentalProject? The other day one of our developers committed some code that made OpenDental dependent on one of our private reposit...

cmcgehee

We will get that added.

cmcgehee

Yes, we will fix this especially because it is an SQL injection vulnerability.

cmcgehee

We do not have that information available through our API. I know that they sent you here, but you can talk to vendor.relations@opendental.com if you are interested in us adding that.

cmcgehee

Try including the accept header:

Code: Select all

curl --location --request GET 'https://api.opendental.com/fhir/v2/capabilitystatement' --header 'Authorization: ODFHIR NFF6i0KrXrxDkZHt/VzkmZEaUWOjnQX2z' --header 'Accept: application/json'

cmcgehee

I think what you could do is print the referral sheet to a pdf, then attach it to the WebMail message.

cmcgehee

dcrider,

I'm not seeing a mechanism that would cause LaunchToolbarButton to be called more than once. If you put a breakpoint at

Code: Select all

if (DataCheck.TableExists("rd_location"))

does it get hit more than once with different patNums?

cmcgehee

Can the website accept the patient name via URL arguments?

cmcgehee

The main reason we need to issue a testing registration key is because the CDT codes are proprietary. We have to pay a royalty for each registration key we give out. Open Dental as the company follows an open core model ( https://en.wikipedia.org/wiki/Open-core_model ) where the main software is fre...

cmcgehee

The best way would be to set your keyData based on each control that takes input from the form. This way your signature would also be invalidated if someone did an UPDATE statement directly on the database. I don't believe their is any limitation to the length of keyData. We use the entire proc note...

cmcgehee

Justin, the change for this hook has been backported to 20.1.5.

cmcgehee

I admit it can be a little confusing how we have developer registration keys, developer API keys, and customer API keys. I'm going to try to start referring to developer registration keys as testing registration keys. If you want to download the CDT codes, you will need a testing registration key in...

cmcgehee

I'll take care of getting this changed.

cmcgehee

Our approach to signatures is that when the user changes something in the form, we simply clear the signature but don't display "Invalid signature". So from our perspective, the behavior you're describing is not a bug. If you would like to clear it and display "Invalid signature", I would recommend ...

cmcgehee

The purpose of keyData is to ensure the signature is for the data it was originally signed for. For example, if I signed an ortho chart that had fields set to "Strong", "Clean", and "Tight", but someone modified the database to change the fields to "Strong", "Clean", and "Loose", the hash of the key...

cmcgehee

To use the D codes tool, you need to enter a valid registration key (this is different from a developer API key). You can email vendor relations if they have not given you one.

cmcgehee

My apologies, I led you astray. The PassHash argument only works if you are using the eCW integration. If you want to be able to launch Open Dental without making the user log in, you could set up login based on the Windows user: https://opendental.com/manual/singlesignon.html

cmcgehee

Dr. Chokshi,

You will need to log in to Open Dental with a user that has the 'eServices Setup' permission and open this window. Then you'll be able to change the Accepted setting from 'Emailed Confirmation' to something else.

cmcgehee

Ed, I believe you need to send the hash of the user's password instead of the actual password: var odArgs = new string[] { "UserName=admin", "PassHash=fjk3alvkajka3ljkfalja3kwg54898q32jha==", "PatNum=11" }; You can find the value of the hash by running this query in OD: SELECT Password FROM userod W...

cmcgehee

Within Open Dental, can you take a screenshot of the Automated eReminders & eConfirmations tab of the EServices setup window? https://opendental.com/manual/econfirmationsetup.html Can you also take a screenshot of the Appointment Edit window for this appointment? https://opendental.com/manual/aptedi...

cmcgehee

There isn't one particular method for creating a payment because each place in our program that makes a payment does something unique. You'll want to call OpenDentBusiness.Payments.Insert at the very least. For an example on what to pass to this method, you could look at OpenDentBusiness.RecurringCh...

cmcgehee

It sounds like the best way to accomplish this would be to create a plugin. You can then call our methods to create payments.
https://opendental.com/manual/plugins.html

cmcgehee

BtnShape was a property in OpenDental.UI.Button, but it no longer is. It sounds like your plugin is referencing an older version of OpenDentBusiness.dll. I would rebuild the OpenDentBusiness.dll, and copy that dll to the file location where your plugin references OpenDentBusiness.dll.

cmcgehee

I looked through our query examples but I didn't see one that would accomplish this. Our query team could write something for you, I'm sure: https://opendentalsoft.com:1943/ODQueryRequest/QueryRequestForm.aspx . The program doesn't really have the concept of an opening balance. Sometimes when we con...

cmcgehee

1. Yes, the demo version will work with imaging bridges.
2. This page lists all the imaging software that Open Dental bridges with: https://opendental.com/site/programbridges.html.

cmcgehee

Mike, I don't believe we have that functionality.

cmcgehee

Strange, I don't know why it would be giving you that error. I would call our support line to get another pair of eyes on this.

cmcgehee

The "where" clause is optional, so this particular query doesn't have one. If you wanted to add it, it would go after the "join" clauses: /*987 List of insured patients with a scheduled appointment in date range, with Name, PatNum, and FamFinUrgNote listed.*/ /*Query code written/modified: 07/09/201...

cmcgehee

Yes, you can join on the definition table. Here's a little example:

Code: Select all

SELECT d.ItemName AS AdjTypeName,a.*
FROM adjustment a
LEFT JOIN definition d ON d.DefNum=a.AdjNum

cmcgehee

Hi Doug, I wish you luck on your training school. To answer your question about a central server, yes, Open Dental requires a MySQL server and a network share that all workstations can access . Most offices set that up on a Windows machine in their local office, but you could run it on Linux or in t...

cmcgehee

When you GET an appointment, you will see there is a participant where the actor is a patient. One of the fields on the participant object is "status". This will be "needsaction" when the patient has not confirmed the appointment and will be "accepted" once the patient has confirmed. You can send a ...

cmcgehee

I don't have any further ideas without remote connecting to your environment. I would recommend calling support next.

cmcgehee

Can you post the result of this query:
SHOW VARIABLES LIKE 'max_connect_errors'

cmcgehee

What version of MySQL are you using? If it's >= 5.6, can you run this query and show the results?
select * from performance_schema.host_cache

cmcgehee

We see this MySQL error every so often for various offices. Our solution is to add:

max_connect_errors=999999999

to your my.ini file and restart MySQL.

cmcgehee

Go ahead and send an email to vendor.relations@opendental.com. They can help you with any setup you'll need for FHIR.

cmcgehee

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

cmcgehee

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.

cmcgehee

I don't think so. We store bools as tinyints as well.

cmcgehee

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.

cmcgehee

Did you used to store AddEnhancedMenuItems as "true" and now you're storing it at "1"?

cmcgehee

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

cmcgehee

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.

cmcgehee

Yes, you can replace all your references to ODGrid.Rows with ODGrid.ListGridRows.

cmcgehee

In Visual Studio when you open up the Properties for a project, there is a place to enter compilation symbols:

cmcgehee

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

cmcgehee

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.

cmcgehee

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

cmcgehee

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.

cmcgehee

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?

cmcgehee

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.

cmcgehee

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.

cmcgehee

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.

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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.

cmcgehee

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

cmcgehee

Yes, you can use HTTP.

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

Yes, 19.2. The beta version 19.3 is also available for download.

cmcgehee

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

cmcgehee

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.

cmcgehee

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

cmcgehee

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.

cmcgehee

If you're able to reproduce this, would you mind calling in to support to show us?

cmcgehee

Your PHP script is close. If you just change "x-auth-token: FHIRAPIKey=XXXYYYZZZ" to ""Authorization: FHIRAPIKey=XXXYYYZZZ", then the request should work.

cmcgehee

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.

cmcgehee

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

cmcgehee

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.

cmcgehee

Do you compile your own Open Dental?

cmcgehee

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.

cmcgehee

I do agree we should do this. I've submitted a job to implement this.

cmcgehee

Have you set the Storage Path property in the Program Link window?

cmcgehee

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.

cmcgehee

When you get a critical error, there should be a "Details" that you can click on to expand. Can you paste those details here?

cmcgehee

This is currently in our bugs list. We can update this forum once we fix it.

cmcgehee

There are not any updates on this. I can update this forum post if/when we complete this.

cmcgehee

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.

cmcgehee

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.

cmcgehee

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.

cmcgehee

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

cmcgehee

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

cmcgehee

Ah, that makes sense. Would you mind emailing me so we can discuss this a little more? chris@opendental.com.

cmcgehee

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.

cmcgehee

We should be able to get this added for you. To clarify, do you only want it added to FormClaimsSend.FormClaimsSend_Load?

cmcgehee

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.

cmcgehee

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.

cmcgehee

We are using Visual Studio 2019.

cmcgehee

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.

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

Giovanni, it looks like your eConnector is not running. Once you turn it on, this error should go away.

cmcgehee

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

cmcgehee

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

cmcgehee

I think we have fixed this error. Try updating to 19.2.18 and see if that helps.

cmcgehee

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.

cmcgehee

We do have a Database Maintenance method to fix this: PaymentMissingPaySplit. It will delete these phantom payments when you run it.

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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.

cmcgehee

Could you make sure GoToAssist gets installed to the same location on everyone's computer and then whitelist that location?

cmcgehee

Thanks for letting us know. We'll get that fixed.

cmcgehee

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.

cmcgehee

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.

cmcgehee

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.

cmcgehee

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

cmcgehee

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.

cmcgehee

There is not. The Patient Status Setter can change active patients to inactive. https://opendental.com/manual/patientstatussetter.html

cmcgehee

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

cmcgehee

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.

cmcgehee

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

cmcgehee

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

cmcgehee

If you were able to identify the steps to consistently produce this behavior, we would look into it.

cmcgehee

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?

cmcgehee

We will keep an ear out for other customers that have slowness, and we might look into another round of enhancements.

cmcgehee

We did put quite a bit of work into the dashboard efficiency for 19.2. Are you on version 19.1 or 19.2?

cmcgehee

Could you use reflection to invoke it?

cmcgehee

I've created a ticket for us to look into this. We'll get back to you once we have an answer.

cmcgehee

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

cmcgehee

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.

cmcgehee

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

cmcgehee

Sorry I didn't mention that before, but that checkbox is available starting in 19.2 which is currently in beta.

cmcgehee

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.

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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.

cmcgehee

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'

cmcgehee

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

cmcgehee

If you mean adjustment.AdjNum, then yes, that is maintained by Open Dental since it is the primary key of that table.

cmcgehee

This can be changed in the Show tab of the Chart module: https://www.opendental.com/manual/showtabchart.html.

cmcgehee

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.

cmcgehee

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.

cmcgehee

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

cmcgehee

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.

cmcgehee

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.

cmcgehee

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

cmcgehee

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.

cmcgehee

There is not a way to get available procedures through the API.

cmcgehee

19.1 will be stable in the nearish future.

cmcgehee

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.

cmcgehee

Coming soon in 19.2: attach procedures to appointments through FHIR.

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

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

cmcgehee

Where would you like the prompt to log into the patient portal located?

cmcgehee

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.

cmcgehee

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

cmcgehee

Giovanni,

Go ahead and email vendor.relations@opendental.com to request a developer registration key.

cmcgehee

Yes, you can set this up by following the links Jason posted above.

cmcgehee

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.

cmcgehee

It is dynamically calculated each time it is viewed. It is not stored in the database anywhere.

cmcgehee

I see that the class FormWebChatTools is in the file FormWebChatSessions.cs in 18.4, but that shouldn't cause a problem compiling.

cmcgehee

We do not have a way to distribute this list as a dump file.

cmcgehee

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

Search found 711 matches