Open Dental Forum

rinse-dental

Got it. That was my worry. Thanks for checking in on it. To whatever extent this can be considered a feature request to the DB and API teams, I would appreciate it.

rinse-dental

I'm going to research this for you, but if I recall correctly, these estimates are extremely complex and calculated in memory. Sorry if my question wasn't clear. I don't need the calculations. I'm referring to the ProcTP and TreatPlan tables. ProcTP already stores FeeAmt, PriInsAmt, PatAmt, Discoun...

rinse-dental

I noticed Open Dental saves ProcTPs with PriInsAmt and SecInsAmt calculated using the 'Estimates as of' date. Is the 'Estimates as of' date stored in the DB and available via another API? For example, patient has a treatment plan that will exceed max or hit frequency limitations. Treatment plan #1 i...

rinse-dental

Amazing. Thank you!

rinse-dental

After my upgrade to 24.2.44 (from 24.1.n), it appears my API Event - Appointment fired for every appointment in the DB. Is this to accommodate the new ItemOrderPlanned field? Was there any other updates/changes made to the appointments as part of this upgrade? The volume killed my listener and I'm t...

rinse-dental

Update for anyone facing the same issue. In short, after upgrading our server to v. 24.2.44, when we attempted to open the client, the clients would crash during load and before offering the option to upgrade. The work around was to manually upgrade via the setup.exe file found in the AtoZ folder. T...

rinse-dental

Requesting the ability to search by 'PlannedAptNum' so we can fetch appointment details for planned appointments. Thank you.

rinse-dental

Appreciate the response. Realizing this is too generic a question, I'll ask anyway... is there any reason for (or have there been any reports of) the Open Dental client dying after the upgrade? We use planned visits heavily so I'm concerned all those stack trace errors I was receiving was related to...

rinse-dental

I'm an avid user of the Open Dental APIs and have had success frequently updating our server to the latest beta version. Two weeks ago I updated to version 24.2.n (I can't recall the subversion) and everything imploded... stack trace errors galore and any APIs ShortQueries hitting the Planned Apts t...

rinse-dental

I'm running a Windows Server VM + middle tier but suspect a full migration to Cloud SQL and Storage would be faster, cheaper and more scalable. Has anyone successfully made the move? Is it possible? The AtoZ migration seems possible by creating the AtoZ filestore then mounting a drive using FUSE. ht...

rinse-dental

Please add address, telephone and email information to the Referrals GET (single and multiple) API. Thank you.

rinse-dental

I swear... I'll sit and stare at an issue for a week before posting to the forum only to embarrass myself with a dumb oversite. It appears the "issue" is with the 'isHygiene' flag and my setting the ProvNum when I mean to change ProvHyg. I'll confirm in the AM but perhaps you can turn this post into...

rinse-dental

USE CASE : Reschedule an existing scheduled appointment. ISSUE : Appointment AptDateTime and Op is updated; however, the new ProvNum is ignored. EXAMPLE : PUT /api/v1/appointments/[AptNum] { "AptDateTime": [New AptDateTime], "ProvNum": [New ProvNum], "Op": [New OpNum] } https://www.opendental.com/s...

rinse-dental

Great - thanks!

rinse-dental

Disregard. My issue.

rinse-dental

EDIT: Disregard. Issue on my end. You can delete this post if you'd like. See example for Get /treatplans below as well as the corresponding sql query/return. OD version 24.1.44.0 "request": { "url": "http://[---sanitized---]:30223/api/v1/treatplans?PatNum=1", "method": "GET", "body": null, "headers...

rinse-dental

Hello - checking in on this one. Thank you!

rinse-dental

Hello - just checking in on this. Do you happen to have a public backlog to check on these sorts of requests?

rinse-dental

Got it. Thanks!

rinse-dental

Request you add DateTP and Discount to the GET return for both single and multiple procedurelogs. Thank you

rinse-dental

I'm still looking into this but question, does Open Dental store any record of Event responses? That might give me some clues. e.g. HTTP 200, 400, etc.

rinse-dental

Thank you looking into this. I re-tested as well and you are correct - the test case is working as expected. Though I'm still having trouble on the other end - I'll keep digging and let you know if anything crops up. Sorry to waste your time and thanks again for checking.

rinse-dental

Issue : Events are not being received by several long standing webhooks. Context : The long standing webhooks stored in Open Dental include a url param in the endpoint: https://[some URL]/Patients?ApiKey=[some api key] Steps to recreate Issue : Using www.webhook.site , add two subscriptions to Open...

rinse-dental

Hello - I hope you're well! Could there have been a change with version 24.1.24 and newer that reintroduced the issue discussed here: https://www.opendentalsoft.com:8085/forum/viewtopic.php?f=9&t=7783 On 4/29 my Events stopped working and the symptoms reflect the issue re: appending to the webhook U...

rinse-dental

Yes, thank you that would be great.

rinse-dental

Use Case : Return details of an Insurance Plan (e.g. Group Number, Group Name, etc.) Current state : GET /insplans returns a list of plans which requires additional processing and excludes any plans beyond the 1,000 object/row limit. Proposed addition : GET /inssubs/11 -- return specific plan GET /...

rinse-dental

Okay, thanks. Please consider this a request for a PatFields Delete Event API.

Thank you!

rinse-dental

Current behavior : PatField Events do not trigger when a PatFieldValue is cleared or otherwise set to an empty string. At least one char must be in the field in order for an event to trigger. Desired behavior : PatField Events trigger anytime New PatFieldValue != Old PatFieldValue. I haven't fully ...

rinse-dental

Understood. Thank you. In our specific use case and for the sake of prioritization, we're fine with making laboratories and labturnarounds setup within Open Dental an initial dependency to use GET/POST/PUT lab case.

rinse-dental

- GET lab case. If possible, include laboratory description and Provider Abbr
- POST lab case. With ability to optionally include aptnum and plannedaptnum
- PUT lab case. With ability to update aptnum and plannedaptnum
- DELETE lab case.

rinse-dental

Thanks. I understand that generating an estimate can be expensive - that's the entire purpose of this thread, but you didn't address the issue, at least not directly...that is, Open Dental gives several ways to add procedures to an appointment, including the API, but we should assume the estimate g...

rinse-dental

Our 3Shape bridge stopped working a few Beta versions ago - I spent several hours on the phone with Trios/3Shape support; however, they ultimately couldn't get it working. CLI (has been and) is enabled in 3Shape and, as far as I can tell, nothing has meaninfully changed on either side. Has anyone el...

rinse-dental

Nailed it! We're now updating 100% and I now have ~70 inactive patients with the name 'missing-#' back in my DB. Thanks for taking the time - I hope this thread eventually helps others.

rinse-dental

Thanks. I understand that generating an estimate can be expensive - that's the entire purpose of this thread, but you didn't address the issue, at least not directly...that is, Open Dental gives several ways to add procedures to an appointment, including the API, but we should assume the estimate ge...

rinse-dental

@justine - checking in.

rinse-dental

Thanks for the help! Sorry if this ate up too much time!

rinse-dental

I don't want to screw anything up but would this fix my issue?

update procedurelog set
patnum = 2
where patnum not in (select patnum from patient)

rinse-dental

Thanks! I'm ashamed to admit this but early on when we were too small and broke to think about creating a proper dev environment - I was creating patients, running some tests and then used a SQL delete for those patients and appointments. No doubt this is the 'how' to your situation. I wouldn't swea...

rinse-dental

Hey Justin - I've been really struggling with estimates so I'm hoping you might help me devise a strategy to work through or around the problem. PROBLEM: The estimate for a scheduled appointment (claimproc) is wrong if EITHER: The scheduled procedure has a deductible and is created/added to an appoi...

rinse-dental

Are you syncing a local database with API results? If so, how often do you update? My original program accesses the database in real-time, but now I am switching everything to use the APIs...which are slower. Our online booking is kept simple, we just have providers associated with Operatories and ...

rinse-dental

Cool - thanks! I called support initially to resolve an issue with outdated deductibles. They suggested the Update Estimates feature which then led me down this rabbit hole. I called back today at your suggestion and, as it turns out, my deductible issue might not be resolved with the Update Estimat...

rinse-dental

I'm attempting to Update Estimates Only via Fee Tools; however, I can only ever reach 97% before the dialogue reports 'Done' and the Close button is again active.

rinse-dental

Super strange that the query doesn't run for you... 🤷‍♂️ Yes, it would be helpful if you'd consider including the following in your dev list: Add planned priority to Appointments GET (multiple) - I can combine this with AptStatus filter to get a good list of planned apts Add planned priority to Appo...

rinse-dental

I just went through a remodel of my scheduling algorithm as well. I've taken the same approach, using just Apt and Schedule to get to a base set of availability but found that to still be too dumb... at least with respect to maximizing hyg/provider time when that hyg/provider is working across multi...

rinse-dental

Thanks! You're right, caching items that change less frequently will solve some of my issues - or at least some portion of the complexity I'm working through. re: Get Visit Details... Yes, this is the problem I'm attempting to solve. Unfortunately, it appears the API you referenced wouldn't help me ...

rinse-dental

Hello - I have a relatively straight forward set of use cases but it's proven to be quite taxing. That is, to view a summary for a given appointment. For example, for a planned or upcoming visit, I'd like to display the appointment basics (datetime, provider name, apttypename, and duration), a finan...

rinse-dental

Thank you. If it matters for you or your team (or anyone else facing this issue), I was able to copy/paste a schedule on the cloud VM server, where the DB is local.

rinse-dental

This issue was an issue in Beta v. 23.3.7 as well, reporting as I'd hoped it resolved with the newest release. Please advise if this is not the correct place to report issues. MODULE: Schedule TEST CASE: 1. Copy Day with existing provider scheduled 2. Paste on future date RESULT: Please Wait progres...

rinse-dental

Requesting you mimic the windows client and allow get/post/put of dentist and hygienist patterns. Post/put as optional field. Also requesting get/post/put of assistant assignment. Two issues we're working to resolve: 1. More accurate staff assignment to a given appointment . Today, a user books a vi...

rinse-dental

You're the best! Dunno how i missed it but thank you!

rinse-dental

x-post from developer forum.

Hi, how do you calculate max remaining? The issue I'm finding is incorporating the 'Adjustments to Insurance Benefits' record (found on the Edit Insurance Plan screen within the Family Module) which I can't seem to find in the DB or APIs returns.

rinse-dental

woo hoo!

rinse-dental

Hi, how do you calculate max remaining? I can't seem to find the 'Adjustments to Insurance Benefits' record (found on the Edit Insurance Plan screen within the Family Module) in the DB to ensure accuracy.

rinse-dental

A reverse program link so to speak? use case : We have a web dashboard that allows office staff to have a summary view of patients and daily tasks. The web dashboard is powered by Open Dental APIs and augmented by Firebase. When an Admin selects a patient to dive future into a task or issue, we'd li...

rinse-dental

Primary Use Case: User updates ReToStatus

However, it would be helpful to update all the fields on the record:

RefDate
DateProcCompleted
Transition Of Care
RefNum
ReferralType
ProvNum
Note

And... while we're at it, DELETE refattaches but less of a priority

rinse-dental

woohoo!

rinse-dental

Thanks!

rinse-dental

Thanks!

rinse-dental

If posting a discount plan via the API, the Open Dental client does not appear to incorporate the discounts when calculating apt estimates/totals. More specifically, the procedurelog table does not update the DiscountPlanAmt field. EDIT: This appears to be an issue when you do not set the optional D...

rinse-dental

Hello - Checking in on this one. We're finding issues in how we manage recall workflows, specifically reminders, etc. because Open Dental does not recognize an apt booked via the API as a recall apt.

rinse-dental

Thanks!

rinse-dental

I'm not sure if this is a feature or a bug in the current API; however, I'd like to mimic the feature within OD client where if a D1110 (for example) is booked - the 'sched date' on the recall table is updated. Ideally this would occur automatically, if not - perhaps it's allowing a put option for t...

rinse-dental

Appreciate the clarification, glad you're back up.

rinse-dental

back up

rinse-dental

Called and confirmed... eServices are down which impacts the API service. They said to check again in an hour. What's frustrating is that although we run a local API on our hosted GCP server - we're still dependent on the eServices connector and Open Dental availability. Why? To make sure we're payi...

rinse-dental

Thank you. Will this estimate consider date - similar to the Treatment Plan? For example, if a patient is not eligible for a cleaning until [recall date] and the appointment is booked after [recall date] - will the estimate be based on today, the date the estimate was created, or the scheduled appoi...

rinse-dental

Checking in on the write up @Sleon mentioned. Also, for what it's worth... I understand we can use API GET Schedule and API GET Slots, etc. then process our own logic; however, for those of us who let Open Dental manage a majority of our configurations and then leverage the APIs to extend certain fe...

rinse-dental

Is it possible to retrieve Open Dental's calculations for the following: Estimated patient portion as found in the appointment screen in Open Dental Treatment plan cost break down including Insurance portion, Patient portion, writeoff, etc. as found in the Treatment Plan screen If not, is it possibl...

rinse-dental

Okay. So, according to the manual, there is no way to consider a crown or filling limitation on a specific tooth for procedures performed outside our practice. It appears we’ll need to manually check and adjust the estimate. Insurance History accounts for maximums, deductible, and the last date at t...

rinse-dental

@adearmondsattler -- I know this is an old thread but relevant to our situation. Is there a way to consider Existing Other procedures in the patient's chart? In our case, a Delta Dental patient has an existing crown that's 5 years old and the plan has a 7 year limitation. We've entered the EO crown ...

rinse-dental

I'm a web guy so this may be a dumb question, but does Open Dental allow a navigational bridge back to the application? For example, if a user clicks a link, presuming Open Dental is installed locally and the user has access, the link will navigate to a specific patient and section of Open Dental. F...

rinse-dental

Hi Sleon - checking on the status of this update. Has this been finished? Thanks!

rinse-dental

Amazing... you guys are great. Thanks!

rinse-dental

From Customer.Io support….

: E633606C-8967-43F9-AE3B-D8DF5A028B8B.png (668.36 KiB) Viewed 10325 times

rinse-dental

Thanks for the additional info. "Breaks" was a poor choice of words, sorry. I've not been able to make solutions like Zapier and Customer.IO work at all :) They provide a specific URL for which you can POST; however, they don't seem to work with Open Dental and the only conclusion I can come to is t...

rinse-dental

A quick follow-up on this... it seems Open Dental appends "/appointmentevent" to the end of the URL for a WatchTable "Appointment". This appears to break no/low-code services with webhook integrations like Zapier and Customer.IO. Have you found this to be the case or am I missing something?

Thanks!

rinse-dental

API Enabled... confirmed . eConnector service installed and API requests sending to Remote API endpoint, confirmed . OpenDentalAPIService/OpenDentalWebConfig.xml looks similar to yours and matches exactly on the highlighted sections, confirmed . Still not working. API service not starting, logging s...

rinse-dental

Thanks. The Service still does not start. See the steps I followed below. Copy of WebConfig file from C:\Program Files (x86)\Open Dental\OpenDentalEConnector CHECK Paste to C:\Program Files (x86)\Open Dental\OpenDentalAPIService CHECK Add <Note>DentalOffice</Note> to the APIService OpenDentalWebConf...

rinse-dental

Update. I uninstalled 'OpenDent' (the econnector service)...then I installed the OpenDentalAPIService... then I reinstalled the econnector service and rebooted the server as instructed. The good news... all 3 Open Dental services are installed The bad news... the API Service is stopped and will not ...

rinse-dental

It doesn't appear the API service was installed, or if it is... OD isn't picking it up. Here are the 3 services that were installed by default by Open Dental. Screen Shot 2022-08-24 at 10.43.42 AM.png Screen Shot 2022-08-24 at 10.52.12 AM.png Screen Shot 2022-08-24 at 10.44.17 AM.png Here's the vers...

rinse-dental

Alright... re: Service API. Next issue. Unless I'm misunderstanding the instructions, the API service did not install automatically. And, when I try to manually install the service, I get this error message. I took a peak over at Windows Services Admin, I see the services lists in the first screen s...

rinse-dental

Got it, thank you

rinse-dental

Thanks! I think service API is what I'm after, though... for whatever reason, I don't see an option to upgrade to the v22.2 beta. I'm currently running v22.1.54... when I 'check for updates' I get a 'connection successful. no downloads available' .

rinse-dental

We're getting some suspect response times for simple APIs like Get Medications (700-1400 ms) and GetAllergies (500-900 ms), and much higher times for GetAppointments/Slots (1200-2000+ ms). We'd love to see these sub-500ms. We're operating with the middle tier architecture with a VM on GCP. The VM/se...

rinse-dental

Thanks. I'm aware of the feature but it's a work around that creates a lot of room for error and is incredibly inefficient.

rinse-dental

I'm running Open Dental on a Windows Server 2022 without issue. I can't speak to the remainder of your setup.

rinse-dental

I'm submitting claims to Delta Dental as an OON provider. 90% of the time, the payment goes to the enrollee. My goal is to make my patients experience as seamless as possible without selling my soul to Delta. So, for these instances where AOB is the enrollee...I typically write off fees greater than...

rinse-dental

Hey, great! Both the GetPlannedApts and an API to schedule a planned appt would be great. Please let me know where you think this falls in your schedule. Much appreciated!

rinse-dental

Is it possible to add the following to the Appointments GET and GET (multiple) APIs: Duration (int) Procedure Number (string) Planned Apt # (priority set in chart module) Use cases... Get and display duration to patients without pattern conversion Get Planned Apt. duration and op num > Get Slot for ...

rinse-dental

Is scheduling a "Planned" appointment as easy as using APPOINTMENTS PUT to assign an available datetime (via GetSlots) and setting the status to "Scheduled"?

rinse-dental

Thanks; however, what if your production configurations are consistently evolving? In this instance, we're interested in maintaining a "production-like" OD staging environment which would include look/feel like production but have dummy patient, appointment, and claims data. In other words, anything...

rinse-dental

Thanks! Another question... I've set my workstation; however, it appears I get 2, sometimes 3 distinct calls to my hook for each change. The calls appear to be from three different hosts, one from my server and 2 others from what I presume to be other online workstations. I've tried changing my work...

rinse-dental

@SLeon - sorry, quick follow-up question. Does the API Event payload batch all events that occurred between the last call and next call? Or, will it send individual payloads for every event?

rinse-dental

Boom, got it! Thanks!

rinse-dental

Thanks. 2 clarifying question before I keep trying... Does the change to the appointment need to be from the API or will API Events fire regardless of change type (e.g. user changes apt status in Open Dental vs. API changes apt. status)? Does the endpoint need to be local or in a private network? I'...

rinse-dental

Would love to see timezone including on all dates, including DateTStamp, serverDateTime, and especially AptDateTime

rinse-dental

Amazing - thanks!

rinse-dental

Use Case: Send custom email/SMS to patient post visit (thank you, survey, etc.). I use Twilio for customer communication and have created a webhook that listens for an event. Is it possible for Open Dental to post to that webhook when appointment status changes to complete? It seems API Events and A...

rinse-dental

A FK relationship doesn't seem to exist on either the definition or appointmenttype table.

rinse-dental

Thanks! When do you expect these to be pushed to a production/non-beta release?

rinse-dental

Awesome!

rinse-dental

Amazing - is there a way to get a sense of general timing or where this falls in your backlog?

rinse-dental

I'm requesting some ability to update and/or delete a patients allergies, diseases, and medication. For example, when a pregnant patient is no longer pregnant, update to "resolved". If a patient incorrectly reports a medication, ability to delete.

Search found 103 matches