Open Dental

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 4626 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 75 matches