Search found 117 matches
- Fri Mar 21, 2025 6:38 pm
- Forum: Advanced Topics
- Topic: Bug reporting?
- Replies: 0
- Views: 276
Bug reporting?
For your beta users, is there a way to file a bug report? For example, on 24.4.35.0, in Lists > Insurance Carriers, the Carrier and ElectId filters stopped working. I did not see a bug listed in your 'known bugs' page.
- Fri Mar 21, 2025 6:29 pm
- Forum: Advanced Topics
- Topic: 3Shape Bridge/Program Link Not Functioning
- Replies: 6
- Views: 82085
Re: 3Shape Bridge/Program Link Not Functioning
This issue is a bit old, we've burned through a dozen versions of both since it was posted... I'll need to double check, but I believe the big upgrade of 3shape (the move to the cloud?) resolved the issue. I too created a custom bridge to resolve the issue initially. P.S. I THINK my issue was relate...
- Thu Mar 20, 2025 6:22 pm
- Forum: API
- Topic: API Request | subscriptions.WatchTable == 'Schedule'
- Replies: 3
- Views: 3415
Re: API Request | subscriptions.WatchTable == 'Schedule'
API database events fire whenever something changed in the table you are subscribed to. This includes a new row, or an updated row. However, it is impossible to return a row that has been deleted. We cannot add schedule delete. The schedule table does not contain an operatory field. We are not addi...
- Tue Mar 18, 2025 4:24 pm
- Forum: API
- Topic: API Request | subscriptions.WatchTable == 'Schedule'
- Replies: 3
- Views: 3415
API Request | subscriptions.WatchTable == 'Schedule'
Hello. re: Open Dental v. 24.4.24 Question. Can you please confirm which db events events.Schedule is listening for? As far as I can tell it's only ADD. Two requests 1. Please add the operatories string array to the event. Please also see my notes regarding type inconsistencies. { "ScheduleNum": "24...
- Mon Mar 03, 2025 6:26 pm
- Forum: API
- Topic: API Request | Post/Put Claims - allow InsSubNum2 to be set to 0 when ClaimType == P || S
- Replies: 2
- Views: 474
API Request | Post/Put Claims - allow InsSubNum2 to be set to 0 when ClaimType == P || S
Effectively mimicking the behavior within Open Dental that allows a user to open a claim and set the other insurance plan to 'None'.
- Mon Feb 03, 2025 10:18 am
- Forum: API
- Topic: API Request DELETE treatplans
- Replies: 2
- Views: 2819
API Request DELETE treatplans
By TreatPlanNum
thank you
thank you
- Tue Jan 21, 2025 10:58 am
- Forum: API
- Topic: API Request | ProcedureLogs GET (multiple) by ProcStatus, ProcCode
- Replies: 1
- Views: 2386
API Request | ProcedureLogs GET (multiple) by ProcStatus, ProcCode
Hello -
Requesting you add the following optional parameters to the ProcedureLogs GET (multiple) endpoint:
Requesting you add the following optional parameters to the ProcedureLogs GET (multiple) endpoint:
- Param: ProcStatus (array) - example ['TP', 'C']
- Param: ProcCode (array) - example ['D1110', 'D0120'] alternatively, array of CodeNums
- Mon Jan 13, 2025 8:14 am
- Forum: API
- Topic: API Request | ProcedureLogs GET (multiple) - search by PlannedAptNum
- Replies: 4
- Views: 9954
Re: API Request | ProcedureLogs GET (multiple) - search by PlannedAptNum
Amazing!
Question @RyanH, I seem to only have access to 24.3.n beta. Is this because we are subscribed to eServices and eServices isn't ready for 24.4?
Question @RyanH, I seem to only have access to 24.3.n beta. Is this because we are subscribed to eServices and eServices isn't ready for 24.4?
- Mon Jan 13, 2025 8:11 am
- Forum: API
- Topic: OpenDentalAPIService issues in API Service Version: 24.3.39.0?
- Replies: 1
- Views: 2798
Re: OpenDentalAPIService issues in API Service Version: 24.3.39.0?
Update: After a 2 or 3 re-installations of the APIService and several server reboots, the issue has resolved itself. Outside of the aforementioned Windows Server Events, I've not see any indication of cause.
Should it be useful for debugging, we are running a Middle Tier setup.
Should it be useful for debugging, we are running a Middle Tier setup.
- Fri Jan 10, 2025 4:51 pm
- Forum: API
- Topic: OpenDentalAPIService issues in API Service Version: 24.3.39.0?
- Replies: 1
- Views: 2798
OpenDentalAPIService issues in API Service Version: 24.3.39.0?
After an upgrade to 24.3.39.0, the API service has been dying and then restarting every 1-2 minutes. The restart is via my windows service settings. Here is an excerpt from the APIlogger: 01/10/25 16:46:08:377 Starting Open Dental API Service. 01/10/25 16:46:08:380 Initializing database connection. ...
- Tue Dec 03, 2024 12:42 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
Re: How to retrieve Open Dental's calculated insurance and patient portions?
Thanks. I sent an email. I still stand by my notion that this is a defect within Open Dental and could be resolved any number of ways without taxing the DB. 

- Mon Dec 02, 2024 5:48 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
Re: How to retrieve Open Dental's calculated insurance and patient portions?
Hi there - We've found that patient estimates for recall appointments booked online or via the Book Recall feature within Open Dental are wrong a majority of the time. This is a result of the issues I called out earlier in the thread or because their appointment in 6 months + 1 day and we're calcula...
- Thu Nov 21, 2024 11:18 am
- Forum: API
- Topic: API ProcedureLogs | Add fields request
- Replies: 1
- Views: 4917
API ProcedureLogs | Add fields request
Hello. I'd like to request you please add the following fields to the ProcedureLogs API. The items in bold are the priority. I've attached screenshot for Get vs. Post vs. Put. Get is the priority for my use case. Thank you! ClaimNote DateEntryC DateTP SiteNum HideGraphics ProcTime ProcTimeEnd Billin...
- Tue Nov 19, 2024 4:45 pm
- Forum: Advanced Topics
- Topic: Special prep for 24.2.n upgrade?
- Replies: 5
- Views: 31101
Re: Special prep for 24.2.n upgrade?
I am and thank you!
- Fri Nov 08, 2024 5:14 pm
- Forum: API
- Topic: Question | ProcTPs and 'Estimate as of'
- Replies: 4
- Views: 10486
Re: Question | ProcTPs and 'Estimate as of'
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.
- Thu Nov 07, 2024 3:50 pm
- Forum: API
- Topic: Question | ProcTPs and 'Estimate as of'
- Replies: 4
- Views: 10486
Re: Question | ProcTPs and 'Estimate as of'
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...
- Wed Oct 30, 2024 10:23 am
- Forum: API
- Topic: Question | ProcTPs and 'Estimate as of'
- Replies: 4
- Views: 10486
Question | ProcTPs and 'Estimate as of'
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...
- Fri Oct 25, 2024 11:38 am
- Forum: API
- Topic: Question | After upgrade to 24.2.n, API Event - Appointment ran for every apt in DB
- Replies: 2
- Views: 6467
- Fri Oct 25, 2024 10:13 am
- Forum: API
- Topic: Question | After upgrade to 24.2.n, API Event - Appointment ran for every apt in DB
- Replies: 2
- Views: 6467
Question | After upgrade to 24.2.n, API Event - Appointment ran for every apt in DB
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...
- Fri Oct 25, 2024 10:02 am
- Forum: Advanced Topics
- Topic: Special prep for 24.2.n upgrade?
- Replies: 5
- Views: 31101
Re: Special prep for 24.2.n upgrade?
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...
- Thu Oct 24, 2024 3:55 pm
- Forum: API
- Topic: API Request | ProcedureLogs GET (multiple) - search by PlannedAptNum
- Replies: 4
- Views: 9954
API Request | ProcedureLogs GET (multiple) - search by PlannedAptNum
Requesting the ability to search by 'PlannedAptNum' so we can fetch appointment details for planned appointments. Thank you.
- Fri Sep 13, 2024 6:54 pm
- Forum: Advanced Topics
- Topic: Special prep for 24.2.n upgrade?
- Replies: 5
- Views: 31101
Re: Special prep for 24.2.n upgrade?
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...
- Sat Aug 31, 2024 6:51 pm
- Forum: Advanced Topics
- Topic: Special prep for 24.2.n upgrade?
- Replies: 5
- Views: 31101
Special prep for 24.2.n upgrade?
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...
- Sat Aug 31, 2024 6:35 pm
- Forum: Developers
- Topic: Full GCP migration: Cloud SQL + Storage?
- Replies: 0
- Views: 32186
Full GCP migration: Cloud SQL + Storage?
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...
- Wed Aug 28, 2024 11:03 am
- Forum: API
- Topic: API Request | Referrals GET - Add contact information
- Replies: 2
- Views: 14141
API Request | Referrals GET - Add contact information
Please add address, telephone and email information to the Referrals GET (single and multiple) API. Thank you.
- Mon Aug 12, 2024 10:00 pm
- Forum: API
- Topic: Defect: API Appointments PUT - ProvNum is ignored, does not update
- Replies: 2
- Views: 8662
Re: Defect: API Appointments PUT - ProvNum is ignored, does not update
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...
- Mon Aug 12, 2024 12:31 pm
- Forum: API
- Topic: Defect: API Appointments PUT - ProvNum is ignored, does not update
- Replies: 2
- Views: 8662
Defect: API Appointments PUT - ProvNum is ignored, does not update
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...
- Mon Aug 12, 2024 12:22 pm
- Forum: API
- Topic: API Request | InsPlans GET by PlanNum
- Replies: 4
- Views: 12359
Re: API Request | InsPlans GET by PlanNum
Great - thanks!
- Thu Jul 11, 2024 2:20 pm
- Forum: API
- Topic: GET /treatplans && GET /treatplanattaches returning empty arrays
- Replies: 1
- Views: 6716
Re: GET /treatplans && GET /treatplanattaches returning empty arrays
Disregard. My issue.
- Thu Jul 11, 2024 2:04 pm
- Forum: API
- Topic: GET /treatplans && GET /treatplanattaches returning empty arrays
- Replies: 1
- Views: 6716
GET /treatplans && GET /treatplanattaches returning empty arrays
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...
- Thu Jul 11, 2024 1:57 pm
- Forum: API
- Topic: API Request | GET/POST/PUT/DELETE LAB CASES
- Replies: 5
- Views: 12024
Re: API Request | GET/POST/PUT/DELETE LAB CASES
Hello - checking in on this one. Thank you!
- Thu Jul 11, 2024 1:56 pm
- Forum: API
- Topic: API Request | GET ProcedureLogs
- Replies: 2
- Views: 8451
Re: API Request | GET ProcedureLogs
Hello - just checking in on this. Do you happen to have a public backlog to check on these sorts of requests?
- Thu Jul 11, 2024 1:54 pm
- Forum: API
- Topic: Appointment Summary View
- Replies: 7
- Views: 16339
Re: Appointment Summary View
Got it. Thanks!
- Fri May 31, 2024 4:08 pm
- Forum: API
- Topic: API Request | GET ProcedureLogs
- Replies: 2
- Views: 8451
API Request | GET ProcedureLogs
Request you add DateTP and Discount to the GET return for both single and multiple procedurelogs. Thank you
- Mon May 13, 2024 3:23 pm
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 11664
Re: API Events - Webhooks with append, still an issue?
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.
- Mon May 13, 2024 10:49 am
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 11664
Re: API Events - Webhooks with append, still an issue?
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.
- Mon May 13, 2024 10:15 am
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 11664
Re: API Events - Webhooks with append, still an issue?
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...
- Fri May 10, 2024 6:47 pm
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 11664
API Events - Webhooks with append, still an issue?
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...
- Fri May 10, 2024 5:47 pm
- Forum: API
- Topic: API Request | InsPlans GET by PlanNum
- Replies: 4
- Views: 12359
Re: API Request | InsPlans GET by PlanNum
Yes, thank you that would be great.
- Sat May 04, 2024 12:50 pm
- Forum: API
- Topic: API Request | InsPlans GET by PlanNum
- Replies: 4
- Views: 12359
API Request | InsPlans GET by PlanNum
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 /...
- Mon Apr 29, 2024 9:22 am
- Forum: API
- Topic: API Events | PatFields Events do not fire when PatFieldValue is cleared
- Replies: 2
- Views: 7315
Re: API Events | PatFields Events do not fire when PatFieldValue is cleared
Okay, thanks. Please consider this a request for a PatFields Delete Event API.
Thank you!
Thank you!
- Fri Apr 26, 2024 7:13 pm
- Forum: API
- Topic: API Events | PatFields Events do not fire when PatFieldValue is cleared
- Replies: 2
- Views: 7315
API Events | PatFields Events do not fire when PatFieldValue is cleared
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 ...
- Wed Apr 17, 2024 8:35 am
- Forum: API
- Topic: API Request | GET/POST/PUT/DELETE LAB CASES
- Replies: 5
- Views: 12024
Re: API Request | GET/POST/PUT/DELETE LAB CASES
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.
- Tue Apr 16, 2024 2:38 pm
- Forum: API
- Topic: API Request | GET/POST/PUT/DELETE LAB CASES
- Replies: 5
- Views: 12024
API Request | GET/POST/PUT/DELETE LAB CASES
- 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.
- POST lab case. With ability to optionally include aptnum and plannedaptnum
- PUT lab case. With ability to update aptnum and plannedaptnum
- DELETE lab case.
- Fri Mar 15, 2024 12:46 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
Re: How to retrieve Open Dental's calculated insurance and patient portions?
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...
- Mon Feb 26, 2024 3:29 pm
- Forum: Advanced Topics
- Topic: 3Shape Bridge/Program Link Not Functioning
- Replies: 6
- Views: 82085
3Shape Bridge/Program Link Not Functioning
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...
- Mon Feb 19, 2024 9:34 am
- Forum: Developers
- Topic: Update Estimates Only bug in v. 23.3.20?
- Replies: 10
- Views: 28536
Re: Update Estimates Only bug in v. 23.3.20?
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.
- Fri Feb 09, 2024 3:46 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
Re: How to retrieve Open Dental's calculated insurance and patient portions?
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...
- Thu Feb 08, 2024 5:13 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
Re: How to retrieve Open Dental's calculated insurance and patient portions?
@justine - checking in.
- Fri Feb 02, 2024 2:05 pm
- Forum: Developers
- Topic: Update Estimates Only bug in v. 23.3.20?
- Replies: 10
- Views: 28536
Re: Update Estimates Only bug in v. 23.3.20?
Thanks for the help! Sorry if this ate up too much time!
- Fri Feb 02, 2024 12:12 pm
- Forum: Developers
- Topic: Update Estimates Only bug in v. 23.3.20?
- Replies: 10
- Views: 28536
Re: Update Estimates Only bug in v. 23.3.20?
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)
update procedurelog set
patnum = 2
where patnum not in (select patnum from patient)
- Fri Feb 02, 2024 12:02 pm
- Forum: Developers
- Topic: Update Estimates Only bug in v. 23.3.20?
- Replies: 10
- Views: 28536
Re: Update Estimates Only bug in v. 23.3.20?
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...
- Fri Jan 26, 2024 8:21 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
Re: How to retrieve Open Dental's calculated insurance and patient portions?
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...
- Tue Jan 23, 2024 4:07 pm
- Forum: API
- Topic: Appointment Slots (proposal for API)
- Replies: 9
- Views: 12661
Re: Appointment Slots (proposal for API)
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 ...
- Tue Jan 23, 2024 3:48 pm
- Forum: Developers
- Topic: Update Estimates Only bug in v. 23.3.20?
- Replies: 10
- Views: 28536
Re: Update Estimates Only bug in v. 23.3.20?
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...
- Wed Jan 10, 2024 1:01 pm
- Forum: Developers
- Topic: Update Estimates Only bug in v. 23.3.20?
- Replies: 10
- Views: 28536
Update Estimates Only bug in v. 23.3.20?
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.
- Fri Jan 05, 2024 12:01 am
- Forum: API
- Topic: Appointment Summary View
- Replies: 7
- Views: 16339
Re: Appointment Summary View
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...
- Thu Jan 04, 2024 11:11 pm
- Forum: API
- Topic: Appointment Slots (proposal for API)
- Replies: 9
- Views: 12661
Re: Appointment Slots (proposal for API)
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...
- Wed Dec 06, 2023 5:54 pm
- Forum: API
- Topic: Appointment Summary View
- Replies: 7
- Views: 16339
Re: Appointment Summary View
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 ...
- Tue Dec 05, 2023 6:21 pm
- Forum: API
- Topic: Appointment Summary View
- Replies: 7
- Views: 16339
Appointment Summary View
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...
- Fri Dec 01, 2023 9:22 am
- Forum: Developers
- Topic: Schedule Module Error in OD Beta v. 23.3.11.0
- Replies: 3
- Views: 18103
Re: Schedule Module Error in OD Beta v. 23.3.11.0
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.
- Thu Nov 30, 2023 5:04 pm
- Forum: Developers
- Topic: Schedule Module Error in OD Beta v. 23.3.11.0
- Replies: 3
- Views: 18103
Schedule Module Error in OD Beta v. 23.3.11.0
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...
- Wed Nov 08, 2023 8:59 am
- Forum: API
- Topic: GET/POST/PUT Appointments - Patterns for both dentist and hygienist?
- Replies: 2
- Views: 5213
GET/POST/PUT Appointments - Patterns for both dentist and hygienist?
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...
- Fri Oct 27, 2023 12:56 pm
- Forum: Advanced Topics
- Topic: Calculating Max Remaining using SQL and/or APIs... ???
- Replies: 2
- Views: 15756
Re: Calculating Max Remaining using SQL and/or APIs... ???
You're the best! Dunno how i missed it but thank you!
- Thu Oct 26, 2023 1:12 pm
- Forum: Advanced Topics
- Topic: Calculating Max Remaining using SQL and/or APIs... ???
- Replies: 2
- Views: 15756
Calculating Max Remaining using SQL and/or APIs... ???
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.
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.
- Thu Oct 26, 2023 1:09 pm
- Forum: API
- Topic: Appointments POST (create) does not update/set Recall schedule dates
- Replies: 7
- Views: 9976
- Fri Oct 20, 2023 1:07 pm
- Forum: Developers
- Topic: Calculating Max Remaning w/ Insurance Benefit Adjustments
- Replies: 1
- Views: 15139
Calculating Max Remaning w/ Insurance Benefit Adjustments
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.
- Thu Oct 19, 2023 5:51 pm
- Forum: Developers
- Topic: Can you open Open Dental from a URL?
- Replies: 1
- Views: 14139
Can you open Open Dental from a URL?
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...
- Thu Oct 19, 2023 10:30 am
- Forum: API
- Topic: REQUEST: PUT refattaches
- Replies: 2
- Views: 5206
REQUEST: PUT refattaches
Primary Use Case: User updates ReToStatus
However, it would be helpful to update all the fields on the record:
However, it would be helpful to update all the fields on the record:
- RefDate
- DateProcCompleted
- Transition Of Care
- RefNum
- ReferralType
- ProvNum
- Note
- Tue Oct 03, 2023 12:00 pm
- Forum: API
- Topic: POST DiscountPlanSub defect
- Replies: 4
- Views: 6252
Re: POST DiscountPlanSub defect
woohoo!
- Tue Sep 26, 2023 7:36 pm
- Forum: API
- Topic: POST DiscountPlanSub defect
- Replies: 4
- Views: 6252
Re: POST DiscountPlanSub defect
Thanks!
- Tue Sep 26, 2023 7:34 pm
- Forum: API
- Topic: Appointments POST (create) does not update/set Recall schedule dates
- Replies: 7
- Views: 9976
- Fri Sep 22, 2023 4:44 pm
- Forum: API
- Topic: POST DiscountPlanSub defect
- Replies: 4
- Views: 6252
POST DiscountPlanSub defect
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...
- Wed Sep 20, 2023 5:59 am
- Forum: API
- Topic: Appointments POST (create) does not update/set Recall schedule dates
- Replies: 7
- Views: 9976
Re: Appointments POST (create) does not update/set Recall schedule dates
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.
- Thu Aug 03, 2023 11:10 am
- Forum: API
- Topic: Appointments POST (create) does not update/set Recall schedule dates
- Replies: 7
- Views: 9976
- Thu Aug 03, 2023 9:49 am
- Forum: API
- Topic: Appointments POST (create) does not update/set Recall schedule dates
- Replies: 7
- Views: 9976
Appointments POST (create) does not update/set Recall schedule dates
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...
- Thu Aug 03, 2023 9:42 am
- Forum: API
- Topic: API Issues
- Replies: 5
- Views: 6948
Re: API Issues
Appreciate the clarification, glad you're back up.
- Wed Aug 02, 2023 8:43 pm
- Forum: API
- Topic: API Issues
- Replies: 5
- Views: 6948
Re: API Issues
back up
- Wed Aug 02, 2023 5:31 pm
- Forum: API
- Topic: API Issues
- Replies: 5
- Views: 6948
Re: API Issues
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...
- Mon May 22, 2023 2:13 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
Re: How to retrieve Open Dental's calculated insurance and patient portions?
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...
- Tue May 16, 2023 9:37 am
- Forum: API
- Topic: Appointments GET Slots
- Replies: 7
- Views: 10978
Re: Appointments GET Slots
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...
- Tue May 16, 2023 9:11 am
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 33375
How to retrieve Open Dental's calculated insurance and patient portions?
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...
- Wed Apr 19, 2023 8:27 am
- Forum: Main Forum
- Topic: Checking Frequencies or Issues Before Financial Arrangement
- Replies: 8
- Views: 19904
Re: Checking Frequencies or Issues Before Financial Arrangement
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...
- Tue Apr 18, 2023 12:12 pm
- Forum: Main Forum
- Topic: Checking Frequencies or Issues Before Financial Arrangement
- Replies: 8
- Views: 19904
Re: Checking Frequencies or Issues Before Financial Arrangement
@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 ...
- Wed Feb 01, 2023 9:15 am
- Forum: Developers
- Topic: Navigational bridge to link into the Open Dental app?
- Replies: 1
- Views: 16148
Navigational bridge to link into the Open Dental app?
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...
- Wed Nov 30, 2022 8:31 am
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
Hi Sleon - checking on the status of this update. Has this been finished? Thanks!
- Thu Nov 03, 2022 3:29 pm
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
Amazing... you guys are great. Thanks!
- Fri Oct 28, 2022 9:53 am
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
From Customer.Io support….
- Thu Oct 27, 2022 4:05 pm
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
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...
- Thu Oct 27, 2022 3:28 pm
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
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!
Thanks!
- Thu Aug 25, 2022 6:32 pm
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
Re: API Performance Suggestions
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...
- Wed Aug 24, 2022 4:06 pm
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
Re: API Performance Suggestions
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...
- Wed Aug 24, 2022 11:24 am
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
Re: API Performance Suggestions
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 ...
- Wed Aug 24, 2022 11:09 am
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
Re: API Performance Suggestions
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...
- Tue Aug 23, 2022 7:11 pm
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
Re: API Performance Suggestions
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...
- Tue Aug 23, 2022 5:19 pm
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
Re: API Performance Suggestions
Got it, thank you
- Sat Aug 20, 2022 10:07 am
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
Re: API Performance Suggestions
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' .
- Wed Aug 17, 2022 7:01 pm
- Forum: API
- Topic: API Performance Suggestions
- Replies: 13
- Views: 14614
API Performance Suggestions
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...
- Thu Aug 11, 2022 2:05 pm
- Forum: Main Forum
- Topic: Better/more accurate tracking when Assignment of Benefits is Enrollee (OON Delta Dental)
- Replies: 3
- Views: 5781
Re: Better/more accurate tracking when Assignment of Benefits is Enrollee (OON Delta 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.
- Mon Aug 08, 2022 4:55 pm
- Forum: Main Forum
- Topic: Window server 2022
- Replies: 2
- Views: 5075
Re: Window server 2022
I'm running Open Dental on a Windows Server 2022 without issue. I can't speak to the remainder of your setup.
- Sat Aug 06, 2022 3:54 pm
- Forum: Main Forum
- Topic: Better/more accurate tracking when Assignment of Benefits is Enrollee (OON Delta Dental)
- Replies: 3
- Views: 5781
Better/more accurate tracking when Assignment of Benefits is Enrollee (OON Delta 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...
- Mon Jun 13, 2022 3:01 pm
- Forum: API
- Topic: Scheduling a Planned Appointment
- Replies: 14
- Views: 14871
Re: Scheduling a Planned Appointment
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!
- Sun Jun 12, 2022 9:18 pm
- Forum: API
- Topic: Appointments GET Request to add duration and procedure number(s)
- Replies: 2
- Views: 3522
Appointments GET Request to add duration and procedure number(s)
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 ...
- Sun Jun 12, 2022 9:03 pm
- Forum: API
- Topic: Scheduling a Planned Appointment
- Replies: 14
- Views: 14871
Scheduling a Planned Appointment
Is scheduling a "Planned" appointment as easy as using APPOINTMENTS PUT to assign an available datetime (via GetSlots) and setting the status to "Scheduled"?
- Sun Jun 12, 2022 11:40 am
- Forum: Developers
- Topic: Cloning an installation configuration
- Replies: 2
- Views: 8221
Re: Cloning an installation configuration
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...
- Wed May 18, 2022 10:43 am
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
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...
- Tue May 17, 2022 9:31 am
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
@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?
- Mon May 16, 2022 2:41 pm
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
Boom, got it! Thanks!
- Mon May 16, 2022 12:27 pm
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
Re: How to: Post to public webhook?
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'...
- Mon May 16, 2022 10:07 am
- Forum: API
- Topic: API General Update Request | Include TimeZone on all datetimes
- Replies: 3
- Views: 6928
API General Update Request | Include TimeZone on all datetimes
Would love to see timezone including on all dates, including DateTStamp, serverDateTime, and especially AptDateTime
- Sat May 14, 2022 10:02 am
- Forum: Advanced Topics
- Topic: Where is the DB relationship between definitions/websched and appointmenttype?
- Replies: 3
- Views: 17369
- Sat May 14, 2022 10:00 am
- Forum: API
- Topic: How to: Post to public webhook?
- Replies: 21
- Views: 22766
How to: Post to public webhook?
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...
- Sat May 07, 2022 12:35 pm
- Forum: Advanced Topics
- Topic: Where is the DB relationship between definitions/websched and appointmenttype?
- Replies: 3
- Views: 17369
Where is the DB relationship between definitions/websched and appointmenttype?
A FK relationship doesn't seem to exist on either the definition or appointmenttype table.
- Tue Apr 26, 2022 11:09 am
- Forum: API
- Topic: API Feature Request | Update Allergies/Diseases/Medications
- Replies: 8
- Views: 8834
Re: API Feature Request | Update Allergies/Diseases/Medications
Thanks! When do you expect these to be pushed to a production/non-beta release?
- Wed Apr 13, 2022 10:13 am
- Forum: API
- Topic: API Feature Request | Update Allergies/Diseases/Medications
- Replies: 8
- Views: 8834
- Mon Apr 11, 2022 4:41 pm
- Forum: API
- Topic: API Feature Request | Update Allergies/Diseases/Medications
- Replies: 8
- Views: 8834
Re: API Feature Request | Update Allergies/Diseases/Medications
Amazing - is there a way to get a sense of general timing or where this falls in your backlog?
- Wed Apr 06, 2022 2:39 pm
- Forum: API
- Topic: API Feature Request | Update Allergies/Diseases/Medications
- Replies: 8
- Views: 8834
API Feature Request | Update Allergies/Diseases/Medications
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.