Search found 23 matches

by joergzastrau
Tue Dec 20, 2022 4:26 am
Forum: API
Topic: Sterilization Monitoring using n8n and Appsmith 1/2
Replies: 2
Views: 1163

Re: Sterilization Monitoring using n8n and Appsmith 1/2

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...
by joergzastrau
Sat Dec 10, 2022 6:27 am
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5603

Re: Web Forms retrieval locale issue

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...
by joergzastrau
Wed Nov 30, 2022 8:43 am
Forum: API
Topic: Program Link Triggered E-Mail for Next appointment using n8n
Replies: 8
Views: 2394

Re: Program Link Triggered E-Mail for Next appointment using n8n

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
by joergzastrau
Wed Nov 30, 2022 2:37 am
Forum: API
Topic: Sterilization Monitoring using n8n and Appsmith 1/2
Replies: 2
Views: 1163

Sterilization Monitoring using n8n and Appsmith 2/2

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": { "...
by joergzastrau
Wed Nov 30, 2022 2:35 am
Forum: API
Topic: Sterilization Monitoring using n8n and Appsmith 1/2
Replies: 2
Views: 1163

Sterilization Monitoring using n8n and Appsmith 1/2

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...
by joergzastrau
Tue Nov 15, 2022 10:21 am
Forum: API
Topic: Program Link Triggered E-Mail for Next appointment using n8n
Replies: 8
Views: 2394

Re: Program Link Triggered E-Mail for Next appointment using n8n

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...
by joergzastrau
Thu Nov 10, 2022 7:11 am
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5603

Re: Web Forms retrieval locale issue

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...
by joergzastrau
Tue Nov 08, 2022 7:03 am
Forum: API
Topic: How to: Post to public webhook?
Replies: 21
Views: 5810

Re: How to: Post to public webhook?

Dear SLeon,

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

Joerg
by joergzastrau
Mon Nov 07, 2022 8:25 am
Forum: Advanced Topics
Topic: Open Dental DB on a NAS
Replies: 1
Views: 3274

Re: Open Dental DB on a NAS

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
by joergzastrau
Mon Nov 07, 2022 3:50 am
Forum: API
Topic: How to: Post to public webhook?
Replies: 21
Views: 5810

Re: How to: Post to public webhook?

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...
by joergzastrau
Mon Nov 07, 2022 3:39 am
Forum: Main Forum
Topic: Fake Procedure Codes
Replies: 2
Views: 2063

Re: Fake Procedure Codes

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
by joergzastrau
Mon Nov 07, 2022 3:12 am
Forum: Main Forum
Topic: Ortho Cases
Replies: 3
Views: 2186

Re: Ortho Cases

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...
by joergzastrau
Sun Nov 06, 2022 10:40 am
Forum: API
Topic: Program Link Triggered E-Mail for Next appointment using n8n
Replies: 8
Views: 2394

Program Link Triggered E-Mail for Next appointment using n8n

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...
by joergzastrau
Sat Nov 05, 2022 12:58 pm
Forum: API
Topic: Energy Savings with Open Dental using n8n/Home Assistant
Replies: 0
Views: 2695

Energy Savings with Open Dental using n8n/Home Assistant

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...
by joergzastrau
Sun Sep 04, 2022 1:01 am
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5603

Re: Web Forms retrieval locale issue

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.
by joergzastrau
Thu May 12, 2022 8:44 am
Forum: Main Forum
Topic: Intraoral scanner
Replies: 3
Views: 2476

Re: Intraoral scanner

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 ...
by joergzastrau
Thu Apr 28, 2022 2:28 am
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5603

Web Forms retrieval locale issue

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...
by joergzastrau
Mon Mar 28, 2022 5:10 am
Forum: API
Topic: API Request: Version Number of Open Dental
Replies: 1
Views: 1637

API Request: Version Number of Open Dental

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...
by joergzastrau
Fri Mar 25, 2022 7:53 am
Forum: API
Topic: Schedules with google
Replies: 1
Views: 2446

Re: Schedules with google

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...
by joergzastrau
Fri Mar 25, 2022 3:35 am
Forum: API
Topic: API Request-Blockouts
Replies: 8
Views: 4330

Re: API Request-Blockouts

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
by joergzastrau
Sun Mar 06, 2022 10:25 am
Forum: API
Topic: API: high/duplicate AptNum returned by Appointments GET (multiple)
Replies: 4
Views: 3015

Re: API: high/duplicate AptNum returned by Appointments GET (multiple)

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.
by joergzastrau
Wed Mar 02, 2022 12:30 am
Forum: API
Topic: API: high/duplicate AptNum returned by Appointments GET (multiple)
Replies: 4
Views: 3015

API: high/duplicate AptNum returned by Appointments GET (multiple)

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