Search found 711 matches

by cmcgehee
Tue Oct 20, 2020 1:36 pm
Forum: Developers
Topic: Plugins update-in-place
Replies: 2
Views: 5547

Re: Plugins update-in-place

Once plugins are loaded, there isn't any way to reload them without restarting the program.
by cmcgehee
Tue Oct 20, 2020 1:34 pm
Forum: Developers
Topic: plugin reference woes
Replies: 6
Views: 15472

Re: plugin reference woes

When I have this issue, sometimes it helps to remove the project references and re-add them.
by cmcgehee
Mon Oct 05, 2020 2:00 pm
Forum: Developers
Topic: API to update appointment status
Replies: 19
Views: 24416

Re: API to update appointment status

Thanks, I'll have one of our engineers look into this issue.
by cmcgehee
Mon Sep 28, 2020 5:19 pm
Forum: Developers
Topic: API to update appointment status
Replies: 19
Views: 24416

Re: API to update appointment status

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.
by cmcgehee
Mon Sep 28, 2020 8:22 am
Forum: Developers
Topic: API to update appointment status
Replies: 19
Views: 24416

Re: API to update appointment status

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
by cmcgehee
Mon Sep 21, 2020 10:57 am
Forum: Developers
Topic: API to update appointment status
Replies: 19
Views: 24416

Re: API to update appointment status

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".
by cmcgehee
Tue Sep 08, 2020 7:21 am
Forum: Developers
Topic: Creating an Appointment through API call
Replies: 6
Views: 9154

Re: Creating an Appointment through API call

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...
by cmcgehee
Mon Aug 17, 2020 7:06 am
Forum: Advanced Topics
Topic: Middle Tier + DropBox = Unhandled Exception?
Replies: 9
Views: 18363

Re: Middle Tier + DropBox = Unhandled Exception?

Would you mind posting the error you're getting in a new thread?
by cmcgehee
Mon Jun 29, 2020 2:28 pm
Forum: Advanced Topics
Topic: Image module error
Replies: 2
Views: 9063

Re: Image module error

Do you have the full details from the error?
by cmcgehee
Mon Jun 22, 2020 7:10 am
Forum: Developers
Topic: update patient medication
Replies: 2
Views: 4408

Re: update patient medication

Yes, currently the recommended best practice is to use queries to update these tables.
by cmcgehee
Thu Jun 18, 2020 6:54 am
Forum: Developers
Topic: OpenDental.Thinfinity;
Replies: 2
Views: 4204

Re: OpenDental.Thinfinity;

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...
by cmcgehee
Tue Jun 16, 2020 12:21 pm
Forum: Main Forum
Topic: Web Schedule recall limited to 60 days?
Replies: 2
Views: 3922

Re: Web Schedule recall limited to 60 days?

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.
by cmcgehee
Tue Jun 16, 2020 12:13 pm
Forum: Advanced Topics
Topic: sparks3d.dll not working...
Replies: 5
Views: 12022

Re: sparks3d.dll not working...

On my computer it also says Sparks3D.dll not found, so it might not be ready for everyone.
by cmcgehee
Mon Jun 15, 2020 7:51 am
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32080

Re: Critical error "String was not recognized as a valid DateTime."

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.
by cmcgehee
Mon Jun 15, 2020 7:12 am
Forum: Developers
Topic: Custom SMS Implementations
Replies: 3
Views: 6612

Re: Custom SMS Implementations

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 ...
by cmcgehee
Tue Jun 09, 2020 12:31 pm
Forum: Developers
Topic: Test server keeps disconnecting? (eConnector not running)
Replies: 5
Views: 6382

Re: Test server keeps disconnecting? (eConnector not running)

It is running now. Let me know if you experience any issues with it.
by cmcgehee
Tue Jun 09, 2020 11:52 am
Forum: Developers
Topic: Test server keeps disconnecting? (eConnector not running)
Replies: 5
Views: 6382

Re: Test server keeps disconnecting? (eConnector not running)

I should be able to get it running this afternoon, maybe 3 or 4 PM PT.
by cmcgehee
Tue Jun 09, 2020 9:32 am
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32080

Re: Critical error "String was not recognized as a valid DateTime."

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,...
by cmcgehee
Mon Jun 08, 2020 5:18 pm
Forum: Developers
Topic: changing server name
Replies: 2
Views: 3830

Re: changing server name

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.
by cmcgehee
Mon Jun 08, 2020 7:14 am
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32080

Re: Critical error "String was not recognized as a valid DateTime."

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.
by cmcgehee
Mon Jun 08, 2020 7:11 am
Forum: Developers
Topic: Read or Writing Patient Forms to/from Open Dental?
Replies: 1
Views: 3135

Re: Read or Writing Patient Forms to/from Open Dental?

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
by cmcgehee
Thu Jun 04, 2020 10:56 am
Forum: Developers
Topic: Test server keeps disconnecting? (eConnector not running)
Replies: 5
Views: 6382

Re: Test server keeps disconnecting? (eConnector not running)

It looks like our test server has a failing hard drive. I'll post here once we get it fixed.
by cmcgehee
Wed Jun 03, 2020 9:42 am
Forum: Developers
Topic: Writing to the db is discouraged, but the API is very barebones, what do I do?
Replies: 15
Views: 20003

Re: Writing to the db is discouraged, but the API is very barebones, what do I do?

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...
by cmcgehee
Mon Jun 01, 2020 7:10 am
Forum: Developers
Topic: Hook event for - FormClaimPayEdit Load_end
Replies: 8
Views: 9113

Re: Hook event for - FormClaimPayEdit Load_end

Thanks, we'll get that added.
by cmcgehee
Thu May 28, 2020 7:02 am
Forum: Developers
Topic: Hook event for - FormClaimPayEdit Load_end
Replies: 8
Views: 9113

Re: Hook event for - FormClaimPayEdit Load_end

Please list the exact line of code you would like us to add, and we will add it if it is possible.
by cmcgehee
Wed May 27, 2020 9:51 am
Forum: Developers
Topic: Hook event for - FormClaimPayEdit Load_end
Replies: 8
Views: 9113

Re: Hook event for - FormClaimPayEdit Load_end

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?
by cmcgehee
Tue May 26, 2020 7:35 am
Forum: Developers
Topic: Hook event for - FormClaimPayEdit Load_end
Replies: 8
Views: 9113

Re: Hook event for - FormClaimPayEdit Load_end

Hi pid_user, would you like us to pass any additional fields or variables as arguments to the FormClaimPayEdit hook?
by cmcgehee
Thu May 21, 2020 10:26 am
Forum: Developers
Topic: windows.winmd error
Replies: 5
Views: 6211

Re: windows.winmd error

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...
by cmcgehee
Thu May 21, 2020 7:32 am
Forum: Developers
Topic: windows.winmd error
Replies: 5
Views: 6211

Re: windows.winmd error

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...
by cmcgehee
Wed May 20, 2020 5:14 pm
Forum: Developers
Topic: windows.winmd error
Replies: 5
Views: 6211

Re: windows.winmd error

What version of Windows are you publishing on? I believe Windows.winmd only works on Windows 8 and later.
by cmcgehee
Mon May 11, 2020 3:43 pm
Forum: Developers
Topic: FormOpenDental.cs design view error
Replies: 3
Views: 5361

Re: FormOpenDental.cs design view error

When I get designer errors like these, usually some combination of cleaning the solution, rebuilding the solution, and closing Visual Studio does the trick.
by cmcgehee
Mon Apr 27, 2020 7:05 am
Forum: Developers
Topic: GetMessage() function modification
Replies: 3
Views: 5081

Re: GetMessage() function modification

Mihn,

This has been fixed in 19.4.39 and 20.1.17.
by cmcgehee
Mon Apr 27, 2020 6:56 am
Forum: Developers
Topic: FormOpenDental.cs design view error
Replies: 3
Views: 5361

Re: FormOpenDental.cs design view error

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...
by cmcgehee
Tue Apr 21, 2020 7:31 am
Forum: Developers
Topic: Hook request
Replies: 3
Views: 4940

Re: Hook request

We will get that added.
by cmcgehee
Tue Apr 21, 2020 7:06 am
Forum: Developers
Topic: GetMessage() function modification
Replies: 3
Views: 5081

Re: GetMessage() function modification

Yes, we will fix this especially because it is an SQL injection vulnerability.
by cmcgehee
Wed Apr 15, 2020 7:11 am
Forum: Developers
Topic: Test environment connection
Replies: 4
Views: 5807

Re: Test environment connection

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.
by cmcgehee
Tue Apr 14, 2020 4:54 pm
Forum: Developers
Topic: Test environment connection
Replies: 4
Views: 5807

Re: Test environment connection

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'
by cmcgehee
Tue Apr 14, 2020 7:22 am
Forum: Sharing
Topic: Exporting sheets to WebMail
Replies: 2
Views: 13849

Re: Exporting sheets to WebMail

I think what you could do is print the referral sheet to a pdf, then attach it to the WebMail message.
by cmcgehee
Mon Apr 13, 2020 8:11 am
Forum: Developers
Topic: LaunchToolbarButton being called multiple times
Replies: 5
Views: 6160

Re: LaunchToolbarButton being called multiple times

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?
by cmcgehee
Mon Apr 06, 2020 7:58 am
Forum: Main Forum
Topic: Plugin to open vip.invisalign.com
Replies: 5
Views: 8534

Re: Plugin to open vip.invisalign.com

Can the website accept the patient name via URL arguments?
by cmcgehee
Thu Mar 26, 2020 10:01 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

Re: FHIR with trial version

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...
by cmcgehee
Wed Mar 25, 2020 3:45 pm
Forum: Developers
Topic: What does keydata do (SignatureBoxWrapper)?
Replies: 4
Views: 6551

Re: What does keydata do (SignatureBoxWrapper)?

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...
by cmcgehee
Wed Mar 25, 2020 3:38 pm
Forum: Developers
Topic: Request: Move hook for Open Dental 20.1
Replies: 9
Views: 25122

Re: Request: Move hook for Open Dental 20.1

Justin, the change for this hook has been backported to 20.1.5.
by cmcgehee
Wed Mar 25, 2020 8:14 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

Re: FHIR with trial version

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...
by cmcgehee
Wed Mar 25, 2020 8:03 am
Forum: Developers
Topic: Request: Move hook for Open Dental 20.1
Replies: 9
Views: 25122

Re: Request: Move hook for Open Dental 20.1

I'll take care of getting this changed.
by cmcgehee
Mon Mar 23, 2020 9:08 am
Forum: Developers
Topic: Bug in SignatureBoxWrapper
Replies: 2
Views: 4695

Re: Bug in SignatureBoxWrapper

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 ...
by cmcgehee
Mon Mar 23, 2020 9:00 am
Forum: Developers
Topic: What does keydata do (SignatureBoxWrapper)?
Replies: 4
Views: 6551

Re: What does keydata do (SignatureBoxWrapper)?

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...
by cmcgehee
Mon Mar 23, 2020 8:43 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

Re: FHIR with trial version

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.
by cmcgehee
Mon Mar 16, 2020 10:02 am
Forum: Developers
Topic: Command line login
Replies: 3
Views: 12767

Re: Command line login

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
by cmcgehee
Mon Mar 16, 2020 8:03 am
Forum: Developers
Topic: API not updating appointment status to "CONFIRMED"
Replies: 9
Views: 11190

Re: API not updating appointment status to "CONFIRMED"

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.
by cmcgehee
Mon Mar 16, 2020 7:56 am
Forum: Developers
Topic: Command line login
Replies: 3
Views: 12767

Re: Command line login

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...
by cmcgehee
Mon Mar 09, 2020 7:30 am
Forum: Developers
Topic: FHIR - Appointment status
Replies: 1
Views: 4237

Re: FHIR - Appointment status

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...
by cmcgehee
Thu Feb 20, 2020 10:22 am
Forum: Developers
Topic: Creating Payments
Replies: 4
Views: 6567

Re: Creating Payments

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...
by cmcgehee
Wed Feb 19, 2020 4:12 pm
Forum: Developers
Topic: Creating Payments
Replies: 4
Views: 6567

Re: Creating Payments

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
by cmcgehee
Tue Feb 18, 2020 2:27 pm
Forum: Developers
Topic: VS2019 designer issue
Replies: 2
Views: 5240

Re: VS2019 designer issue

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.
by cmcgehee
Tue Feb 11, 2020 1:29 pm
Forum: Developers
Topic: Calculate a/r as of a certain date
Replies: 2
Views: 5363

Re: Calculate a/r as of a certain date

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...
by cmcgehee
Thu Feb 06, 2020 2:27 pm
Forum: Main Forum
Topic: Dental Training School Applications for OpenDent.
Replies: 4
Views: 8947

Re: Dental Training School Applications for OpenDent.

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.
by cmcgehee
Thu Feb 06, 2020 8:22 am
Forum: Main Forum
Topic: Scheduled production per proveder
Replies: 1
Views: 5057

Re: Scheduled production per proveder

Mike, I don't believe we have that functionality.
by cmcgehee
Thu Feb 06, 2020 8:16 am
Forum: Main Forum
Topic: Appt Procs Quick Add Invalid Procedure Code
Replies: 1
Views: 5363

Re: Appt Procs Quick Add Invalid Procedure Code

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.
by cmcgehee
Thu Feb 06, 2020 8:11 am
Forum: Main Forum
Topic: Query -Financial Urgent Note
Replies: 2
Views: 6747

Re: Query -Financial Urgent Note

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...
by cmcgehee
Thu Feb 06, 2020 8:06 am
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 6392

Re: Adjustment types

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
by cmcgehee
Thu Feb 06, 2020 8:01 am
Forum: Main Forum
Topic: Dental Training School Applications for OpenDent.
Replies: 4
Views: 8947

Re: Dental Training School Applications for OpenDent.

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...
by cmcgehee
Thu Feb 06, 2020 7:49 am
Forum: Developers
Topic: API to update appointment status
Replies: 19
Views: 24416

Re: API to update appointment status

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 ...
by cmcgehee
Tue Jan 28, 2020 9:00 am
Forum: Developers
Topic: Middle Tier error question
Replies: 9
Views: 14624

Re: Middle Tier error question

I don't have any further ideas without remote connecting to your environment. I would recommend calling support next.
by cmcgehee
Tue Jan 28, 2020 8:19 am
Forum: Developers
Topic: Middle Tier error question
Replies: 9
Views: 14624

Re: Middle Tier error question

Can you post the result of this query:
SHOW VARIABLES LIKE 'max_connect_errors'
by cmcgehee
Mon Jan 27, 2020 2:26 pm
Forum: Developers
Topic: Middle Tier error question
Replies: 9
Views: 14624

Re: Middle Tier error question

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
by cmcgehee
Mon Jan 27, 2020 11:41 am
Forum: Developers
Topic: Middle Tier error question
Replies: 9
Views: 14624

Re: Middle Tier error question

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.
by cmcgehee
Wed Jan 15, 2020 10:54 am
Forum: Developers
Topic: FHIR - Resource (Subscription)
Replies: 1
Views: 4399

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 10:51 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

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 1:54 pm
Forum: Developers
Topic: Enums
Replies: 2
Views: 4789

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 7:40 am
Forum: Developers
Topic: Convert.ToBoolean in OD 19.4
Replies: 5
Views: 8532

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 7:51 am
Forum: Developers
Topic: Convert.ToBoolean in OD 19.4
Replies: 5
Views: 8532

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 8:01 am
Forum: Developers
Topic: Convert.ToBoolean in OD 19.4
Replies: 5
Views: 8532

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 8:12 am
Forum: Developers
Topic: Compiled Version Patient Limited to 30?
Replies: 9
Views: 11667

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 8:18 am
Forum: Developers
Topic: Compiled Version Patient Limited to 30?
Replies: 9
Views: 11667

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 12:39 pm
Forum: Developers
Topic: ODGrid.Rows update
Replies: 2
Views: 4823

Re: ODGrid.Rows update

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

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 4:25 pm
Forum: Developers
Topic: Long load time Middle Tier
Replies: 2
Views: 5218

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 1:50 pm
Forum: Developers
Topic: Compiled Version Patient Limited to 30?
Replies: 9
Views: 11667

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 7:44 am
Forum: Developers
Topic: Newtonsoft.JSON hates me...
Replies: 1
Views: 4843

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 7:40 am
Forum: Developers
Topic: Middle Tier deployment issue
Replies: 2
Views: 5638

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 7:33 am
Forum: Sharing
Topic: Medication List
Replies: 4
Views: 17071

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 7:38 am
Forum: Advanced Topics
Topic: Requiring MYSQL passwords in Open Dental.
Replies: 7
Views: 21293

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 5:09 pm
Forum: Advanced Topics
Topic: Requiring MYSQL passwords in Open Dental.
Replies: 7
Views: 21293

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 5:38 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 7:20 am
Forum: Developers
Topic: Custom SMS Implementations
Replies: 3
Views: 6612

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 12:47 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 7:27 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 2:30 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 9:17 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 8:48 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 1:36 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 11:18 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

Re: Middle Tier plugin issues

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

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 7:36 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 5:50 pm
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 5:48 pm
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

Re: FHIR with trial version

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

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 8:11 am
Forum: Developers
Topic: FHIR API server errors
Replies: 11
Views: 14689

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 7:48 am
Forum: Developers
Topic: Middle Tier plugin issues
Replies: 27
Views: 37754

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 7:38 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

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 9:38 am
Forum: Advanced Topics
Topic: Edit patient window: Provider doesn't get populated
Replies: 2
Views: 9919

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 8:59 am
Forum: Developers
Topic: FHIR API server errors
Replies: 11
Views: 14689

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 4:50 pm
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

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

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

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

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

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: 7
Views: 21293

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: 3
Views: 8366

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

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

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: 5
Views: 14398

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: 10
Views: 22029

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: API
Topic: FHIR with trial version
Replies: 34
Views: 41552

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

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

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

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

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

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

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