Open Dental Forum

joergzastrau

Interesting. Now I am not sure about ODs policy on advertising, Most of our integrations are posted in this forum for everyone to use. I am only asking if I have to pay the 15$ fee or the higher fees to OD for API access?

With best regards

Joerg

info@american-orthodontics.com

joergzastrau

Ok, so we also run one office "on the side" on Friday and Saturday for fun (and profit) using automation when it makes sense. Most of our patients are on a payment plan and use credit card payments on site and then schedule an appointment with the Frontdesk for the next visit. No automation here. We...

joergzastrau

Then what is the Frontdesk doing? Collect payments only and otherwise read Facebook?

joergzastrau

Dear Dr. Hamilton,

I am wondering if the replies helped? The Topic is coming up again.

With best regards,

Dr.-Ing. Jörg Zastrau

joergzastrau

We are running OD now for 3 years. We run nightly external backups to a secured cloud service and test the backups once a month. By doing so, we have identified that at one point in time our backup system failed in a subtle way for two weeks - everything green but testing failed.... Now, is there a ...

joergzastrau

Is there any way to insert a fixed image (Logo) for mounts? We are switching from another software to OD because it's workflow saves us time. On the downside we are copying and pasting our office logo each single time together with a set of 8 orthodontic photos.

Ideas?

Jörg

joergzastrau

Thanks for the clarification!

This is very comfortable as is the fact that one can have multiple subscriptions for the same event. Well done and well behaved!

Joerg

joergzastrau

Dear all, the workflow has been updated with current nodes for new versions of n8n (tested with version 1.50.1). The Appsmith application is unchanged. { "meta": { "instanceId": "c5bbe0e4dd0c2a71ee01ba0477f0fe876e4ef1ddb06022d07739fda528d4f9f1" }, "nodes": [ { "parameters": { "path": "GetSteriBatchb...

joergzastrau

Dear all, We currently respond to a webhook immediately with 200 (ok) and deal with errors afterwards on our own (polling). However, OD seems to resend the events if there is no response. Will this survive a reboot of OD? If so, I would only want to return a 200 response code if the processing was s...

joergzastrau

This is the code for deletion of Google appointments with n8n. One with webhook and one example for polling (full sync). OD Google Calendar Sync DELETE Appointments Webhook (V2.2) { "meta": { "instanceId": "c5bbe0e4dd0c2a71ee01ba0477f0fe876e4ef1ddb06022d07739fda528d4f9f1" }, "nodes": [ { "parameters...

joergzastrau

Dear all, adding Webhooks (OD API Events for Appointments) to the existing code was easy. The polling version (full sync for future appointments) is still included, specifically an example for one provider. These are needed for initial setup and in case a provider deletes an appointment in google ca...

joergzastrau

Hi, your question is broad. I assume you want to extract all appointments for a single provider without the broken appointments. You could - Use the standard reports under "lists" to export both the appointments and the broken appointments, export them to excel and substract - Use your own SQL Query...

joergzastrau

Dear Dr. Hamilton, We are using Open Dental (OD) since early 2022. Until now, we have relied on ODs manual backup method and local supplemental backups. We have tested a different backup solutions (e.g. bacula, rclone, backup to USB Stick) in parallel. Our setup since last week is: We backup to a se...

joergzastrau

We booked the return as misc and forwarded the problem to the accountant.

joergzastrau

Option 5: Install n8n and get a student to adapt the open source solution provided for free in the open dental forum to your like. Shouldn't take more than a day.

With best regards,

Joerg

joergzastrau

Hi,

We observed slow responses using eClipboard during the last few months (dedicated tablet computer). Today, we falled back to paperwork because the response time dropped to minutes rather than seconds. We're located in Germany (what might contribute to the problem).

With best regards

Joerg

joergzastrau

Dear all, This integration uses curl to call a workflow in n8n to validate a patient E-Mail using the neutrino API (https://www.neutrinoapi.com/). The result will be returned as POPUP. Requirements Open Dental API with Comm permissions for POPUP), tested with Version 24.1.46.0 Curl (Included in Wind...

joergzastrau

2nd Part. Delete Google Evens (Google Sync Part 2/2) V2.1 { "meta": { "instanceId": "c5bbe0e4dd0c2a71ee01ba0477f0fe876e4ef1ddb06022d07739fda528d4f9f1" }, "nodes": [ { "parameters": {}, "id": "1ba8462e-9a46-4d57-9f5d-64b5915711df", "name": "When clicking ‘Test workflow’", "type": "n8n-nodes-base.manu...

joergzastrau

Dear all, these are updates to the worklow. Requirements are Open Dental 22.4.28 Tested with N8N Version 1.50.1 Google Calendar API V3 The posted code has served us now for more than 2 years. However, improvements to the APIs triggered an update. There are basically now only 2 Worklows: One for addi...

joergzastrau

Dear all, We have the following case: The insurance paid their portion in full in advance (1st claim only, invoice, subsequent visits for free). The patient moves to a different country after 3 month of treatment and will continue treatment with a different office. We will no return a certain portio...

joergzastrau

Dear all, Thanks to ChrisD from Open Dental for helping with a SQL Query. This version sends exactly one E-Mail to the comma separated family E-Mail addresses of the guarantor with all future appointments of the family members. iCalendar files are attached to the E-Mail. The confirmation status in O...

joergzastrau

Dear All, please find an an updated version of the integration "as is" for n8n version 1.50.1 with current nodes. The workflow will now E-Mail all future Appointments for each patient to all E-Mail recipients of the patient (comma seperated). For Users: The Code Node after "iCalendar" has to revisit...

joergzastrau

Changes: - return patients with missing sterilization information - return only patients with completed appointments - fixed spelling mistakes Updated Code for n8n: { "meta": { "instanceId": "c5bbe0e4dd0c2a71ee01ba0477f0fe876e4ef1ddb06022d07739fda528d4f9f1" }, "nodes": [ { "parameters": {}, "id": "6...

joergzastrau

I just want to provide a "quick" feedback: The locale issue with Windows is indeed fixed with the provided work-around (which is minor, since this not a production machine). I was hoping that this will also fix the locale issue with our Huawei Matebook tablet (and it didn't). We suspect an issue wit...

joergzastrau

Dear all,

I have learned to include screenshots. After 1 month in operation I would say that 2/3 of mobile phones users are happy with the ical feature (screenshots on MAC in reverse order).

With best regards

Joerg

joergzastrau

Code for n8n: { "meta": { "instanceId": "c5bbe0e4dd0c2a71ee01ba0477f0fe876e4ef1ddb06022d07739fda528d4f9f1" }, "nodes": [ { "parameters": {}, "id": "606d42e8-c133-44e0-90f1-cc1a02d70ac6", "name": "Start", "type": "n8n-nodes-base.start", "typeVersion": 1, "position": [ 180, 80 ] }, { "parameters": { "...

joergzastrau

Dear all, we have introduced an Appt Field to record the batch numbers for autoclave runs used during treatment to support sterilization monitoring (screenshot attached). The n8n workflow provides 3 webhooks to look up - all batch numbers used on all patients during a specific time period - all pati...

joergzastrau

Dear all, more nodes have been added to the following cleaner version of the n8n workflow in order to post a note to the Open Dental Commlog. This requires API write permissions to the Comm group. Edit 202211161621 (2x): Added Node to set Confirmation status to "Confirmed". Joerg { "meta": { "instan...

joergzastrau

Yes, please change the culture to en-US on the server for testing purpose. After checking that everything else in our setup seems to be according to documentation this might not only fix the (minor) Windows 7 issue but also an issue related to eclipboard date conversion (MM/DD/YYYY versus DD/MM/YYYY...

joergzastrau

Dear SLeon,

the program link functionality works. It is only that starting a new instance of the curl cmd is slow.

Joerg

joergzastrau

Our Open Dental Server runs on a Mini PC Core i5-8279U, 127 x 127 x 53.1mm size, with 512 GB SSD 24/7, encrypted and with off-site encrypted Cloud Backup (worth 500 USD). Why bother NAS and all its troubles (speed)?

Joerg

joergzastrau

Dear all, it would be helpful if it would be possible to create a button in the OD GUI to trigger an external webhook manually without using Program Links (see http://opendentalsoft.com/forum/viewtopic.php?f=9&t=7891 ). In this specific case, the next appointment may be changed by frontdesk multiple...

joergzastrau

Dear all,

we have treatment-plans for non-patients sitting in the waiting room that include the inofficial codes N0666 for Espresso and N0667 for cookies.

Joerg

joergzastrau

Dear Arna, the way you describe dynamic payment plans is not how I understand them. Ortho cases take a long time. The new ortho case feature now allows for planned visits and pay per visit. This way procedures may be attributed to providers the usual way (provider payment by production). Another way...

joergzastrau

Dear all, this n8n workflow will send an HTML E-Mail to inform the current selected Patient about his next appointment (with iCal attachment). It is triggered by a webhook, e.g. by creating an Open Dental Program Link to curl.exe with the command line arguments "-X POST http://192.168.1.60:5678/webh...

joergzastrau

Dear all, the following automation n8n code ( https://n8n.io/ ) in connection with home assistant (Smart Home) https://www.home-assistant.io/ reduces the office temperature to 17 degree celsius until two hours before the first appointment and after the last patient has left. 20 degrees celsius durin...

joergzastrau

The error(s) show after hitting the "Retrieve New Forms" button, with OD Version 22.1.56.0 the output is now "Done" instead of "All Patient forms retrieved from server" and the web forms are not retrieved. This happens under Windows 7 but not under Windows 10.

joergzastrau

Hi, we could provide my scans to you next week (STL if you would like). We see it as essential to store 3D scans in OD as traditional model equivalents (and we do) for traditional orthodontic treatment reference (uncolored for braces) as required (no more impressions). The colored versions e.g. for ...

joergzastrau

Dear all, I receive the following error on Web Forms retrieval under Windows 7 All Patient forms retrieved from server Culture is not supported. Parameter name: name en-DE is an invalid culture identifier. Culture is not supported. Parameter name: name en-DE is an invalid culture identifier. Culture...

joergzastrau

Hi, my request it twofold. Situation: We're setting up a new office for a single provider. There are already 3 on-site computers (frontdesk/x-ray and server/3d-scanning), one off-site computer for backup verification and two portable laptops in place - in total 6 computers and counting. Number 7 wou...

joergzastrau

perfect. See http://opendentalsoft.com/forum/viewtop ... f=9&t=7749

joergzastrau

Edited 3x, include setup instructions, Errata as of 03/27/22 Hi Jordan, I am sorry that the code is in a state that I don't consider ready for publication. However, please review and improve. Walkthrough to get this working: Install and setup N8N.io Download n8n Desktop App from http://n8n.io (or in...

joergzastrau

Dear all,

is it possible to perform a GET operation based on ScheduleNum similar to the appointments module, e.g.

Code: Select all

GET /schedules/25888

?

Joerg

joergzastrau

The MAX_SAFE_INTEGER in JS is 2^53-1. Considering the maximum number of possible patients to be equal to the number of persons living on earth then I would like to mention that the AptNum being 64 Bit poses a problem to me.

joergzastrau

Hello, a question about recent appointments in the public OD test installation. The query "https://api.opendental.com/api/v1/appointments?Limit=10&dateStart=2022-03-02&DateTStamp=2017-02-08 09:40:20" returns { "AptNum": 4908068889037505000, "PatNum": 373, "AptStatus": "Scheduled", [..] "AptDateTime"...

Search found 45 matches