Search found 5738 matches

by jordansparks
Sat Jan 20, 2024 8:04 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

Conversion of the actual Imaging module window is underway in stages. Many controls have been converted, including the image selector at the left, the windowing slider, and the zoom slider. The toolbars have been overhauled again, with more icons. Nobody should be able to see any difference at all w...
by jordansparks
Sat Jan 20, 2024 5:21 pm
Forum: Main Forum
Topic: maximize/minimize new version
Replies: 3
Views: 1112

Re: maximize/minimize new version

What version did you move from? I think it's been that way for a very long time. That's a Windows 11 feature called Snap Layouts. Open Dental uses custom title bars, so it doesn't have support for Snap Layouts. We made our own similar feature from scratch for use in the Imaging module to allow you t...
by jordansparks
Wed Dec 20, 2023 9:39 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I can't believe it's been a month since my last post. The thing I'm most excited about is that I came up with yet another trick to remove the need to convert windows to WPF if they are too hard right now. I'm using a global static event that FormOpenDental subscribes to. Any WPF window can call a me...
by jordansparks
Sat Nov 18, 2023 7:47 pm
Forum: Advanced Topics
Topic: 3D tooth chart under linux
Replies: 26
Views: 42512

Re: 3D tooth chart under linux

I looked into it. The ToolBarOD is pretty solid. I verified that it only repainted when it needed to, like if the mouse is moved to a new hover button. It doesn't repaint if you just move the mouse around on the same button. So that was my main concern. The timer seems harmless, since it's a pretty ...
by jordansparks
Sat Nov 18, 2023 7:15 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

Finished up a lot of details on the ImageSelector. The new one completely replaces the old one already, and I can't tell any difference at all. It admittedly took quite a bit longer than I planned. In the process, I perfected a technique for setting the scale and zoom of these nested WPF controls. T...
by jordansparks
Sat Nov 18, 2023 7:03 pm
Forum: Advanced Topics
Topic: 3D tooth chart under linux
Replies: 26
Views: 42512

Re: 3D tooth chart under linux

I would expect it to draw better in DirectX than in OpenGL. We switched away from OpenGL about 10 years ago after a good solid attempt. Since we're using MS, DirectX is just a better fit. Thank you so much for tracking down that CPU usage in the ToolBar. I have a little down time at the moment, and ...
by jordansparks
Sat Nov 11, 2023 7:53 am
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

We've been working hard on conversion of the Imaging module. I've personally been working on the ImageSelector at the left. It's just about done. This has required a lot of work on peripheral issues like the ToolTip, vector drawing with SVG-style commands, and some threading to load thumbnails quick...
by jordansparks
Sat Nov 11, 2023 7:29 am
Forum: Advanced Topics
Topic: 3D tooth chart under linux
Replies: 26
Views: 42512

Re: 3D tooth chart under linux

As we move to WPF, issues like the fonts should get better. We've already been able to reduce the number of calls to the Windows API, and I can see us being able to get rid of those completely some day. We're still on 32 bit because of all the bridges we have with other software. We'll have to build...
by jordansparks
Sat Oct 28, 2023 11:16 am
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

CustomGPT worked. But by worked, I mean it's about 80% accurate. It can spit out great responses that are relevant to OpenDental. The responses are not word-for-word from our manual, but are reorganized and summarized as only ChatGPT can so elegantly do. The main problem is the 20% that's wrong. You...
by jordansparks
Wed Oct 25, 2023 7:41 pm
Forum: Main Forum
Topic: 23.2 beta period length?
Replies: 6
Views: 2870

Re: 23.2 beta period length?

Looks like we might release 23.3 as beta within a week. 23.2 would then become stable.
by jordansparks
Tue Oct 24, 2023 8:36 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

The steel framework is going up for Bldg H. Always exciting to watch the welders. I've asked ChatGPT questions about how to use Open Dental, and the answers are garbage. I'm going to try CustomGPT, but my expectations are low. We all know what we want, but I just think nobody has been able to build ...
by jordansparks
Mon Oct 16, 2023 10:29 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I've been very productive. Spent a lot of time working with other engineers on interesting and complex jobs. A few examples: -Perio chart refactoring is going nicely. The code is gradually getting more sane and less spaghetti. This is critical before any actual improvements can be made. -FAQ at the ...
by jordansparks
Thu Oct 05, 2023 9:49 am
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

Making some pretty fast progress in lots of little details: -added WebBrowser control -added SplitContainer control -added properties to all windows for ShowMinMax, StartMaximized, HideHelpButton, etc. -finished up translation framework -improved the help button -fixed window icons -context menu sho...
by jordansparks
Sat Sep 23, 2023 8:59 am
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I've been working on more WPF details, including: -added TreeView control with images -added checkboxes to listBox for some situations. -implemented Autonote composition in WPF, including the automatic yellow text selection. -getting closer to finishing up our richText box. This is already starting ...
by jordansparks
Wed Sep 06, 2023 9:05 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I've been working on lots of little things: -Rich text box. Ours is very customized, with a number of dependent popup windows for things like autoNotes and quickPasteNotes. So there are lots of moving parts. It's maybe 50% done. -Filter controls. This is chunk of code that someone wrote about 10 yea...
by jordansparks
Tue Aug 22, 2023 8:02 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I think a lot about what Open Dental might look like in 20 years. I'm pretty certain that users will have the ability to interact with it in ordinary spoken language. This would mostly be useful for new users who don't know where things are or why things look the way they do. Once you understand eve...
by jordansparks
Sun Jul 23, 2023 8:08 pm
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3866

Re: Is it safe to always trust the aging data in the patient table?

I can't tell if you're using the API or not for this other window.
by jordansparks
Sun Jul 23, 2023 7:56 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I think my posts will tend to get a bit more technical from here on out, since that's what consumes most of my time and attention. I've been working on a variety of properties for WPF, like IsEnabled and ReadOnly. I also added a PictureBox control. There are an awful lot of little details that need ...
by jordansparks
Sat Jul 08, 2023 6:39 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I switched to a standing desk. Sitting is an independent risk factor for diabetes, probably because constant muscle work is needed to process sugar. The brand we use is from Autonomous.ai. I'm not the first at the company. We already have hundreds of them. I thought I would get tired, but not as muc...
by jordansparks
Sat Jul 08, 2023 5:14 pm
Forum: Advanced Topics
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 1
Views: 2144

Re: Is it safe to always trust the aging data in the patient table?

This is a duplicate post. I answered the other one.
by jordansparks
Sat Jul 08, 2023 5:12 pm
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3866

Re: Is it safe to always trust the aging data in the patient table?

I thought it was recalculated when a claim was created and pretty much everywhere that it might change. We also need it to be accurate in order to display it, so I'm leaning toward thinking you can always trust it.
by jordansparks
Thu Jun 15, 2023 9:22 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Re: Jordan's blog

I'm on vacation now. That's very exciting because I can get lots of work done on the plane, in the evenings, etc. I'll build and enhance a number of WPF controls so that we can convert some more complex windows in a few weeks. A really complicated one will be the perio chart. It's very old. There ar...
by jordansparks
Thu Jun 08, 2023 3:32 pm
Forum: Advanced Topics
Topic: Jordan's blog
Replies: 14
Views: 9139

Jordan's blog

I think maybe I'll try blogging here for a while just to give people an idea of what I'm personally doing. Maybe about once a week. This week, I finished the conversion tool for switching from WinForms to WPF. We have about 1000 windows to convert, so we're starting with the simple small windows. Th...
by jordansparks
Mon May 22, 2023 12:36 pm
Forum: Main Forum
Topic: EXTRACTION ICON QUESTION
Replies: 1
Views: 4029

Re: EXTRACTION ICON QUESTION

That's a reasonable idea, but it's fighting with all the other requests for prominence. There are some fairly simple workarounds, so it's just not going to be very high priority. One example of a workaround. After extracting the residual root, mark that tooth missing so that you can put a pontic the...
by jordansparks
Sat May 20, 2023 1:01 pm
Forum: Developers
Topic: Keyboard shortcuts for GM
Replies: 5
Views: 19050

Re: Keyboard shortcuts for GM

The perio chart was designed under the assumption that you would have an assistant doing the data entry. That assistant can keep up by using the keyboard and mouse. If you don't have an assistant, then entry was optimized to use touch screen. Mouse and keyboard by the person doing the exam is the la...
by jordansparks
Sat May 20, 2023 12:52 pm
Forum: Main Forum
Topic: Fonts are too large/ graphics messed up
Replies: 3
Views: 8322

Re: Fonts are too large/ graphics messed up

The description for how to add that file is on the Zoom page in the manual. This page:
https://www.opendental.com/manual/zoom.html
by jordansparks
Sat Apr 29, 2023 7:37 am
Forum: Main Forum
Topic: Where is OD going?
Replies: 8
Views: 6102

Re: Where is OD going?

One more thing I should point out is that we spend a huge amount of time rebuilding the same functionality that we already have, except with more modern tools. If we don't do this, then the software becomes more fragile over time. When the Southwest Airlines software choked a few months ago, it was ...
by jordansparks
Wed Apr 19, 2023 11:27 am
Forum: Main Forum
Topic: Where is OD going?
Replies: 8
Views: 6102

Re: Where is OD going?

Hi, Steve. I looked up your account out of curiosity. Looks like you were approximately customer number 30 about 19 years ago. What were you thinking? Who buys software that only has a handful of customers? Anyway, you got lucky, and we're still forging ahead.
by jordansparks
Tue Apr 18, 2023 8:08 pm
Forum: Main Forum
Topic: Spell Check and screen scrolling
Replies: 2
Views: 3856

Re: Spell Check and screen scrolling

I have not yet noticed that, but it sounds like a legitimate bug.
by jordansparks
Mon Apr 10, 2023 6:01 pm
Forum: Main Forum
Topic: When does Open Dental anticipate plugins to be deprecated?
Replies: 7
Views: 12686

Re: When does Open Dental anticipate plugins to be deprecated?

We continue to deprecate plug-ins. A program link button sounds like a perfect fit.
by jordansparks
Mon Apr 10, 2023 5:52 pm
Forum: Advanced Topics
Topic: Any way to export records for maintenance?
Replies: 1
Views: 4401

Re: Any way to export records for maintenance?

Just start fresh and keep them as two separate databases. We don't charge per database. We charge per active office/provider combo.
by jordansparks
Mon Apr 10, 2023 5:45 pm
Forum: Main Forum
Topic: open dental and apteryx conversion
Replies: 5
Views: 4726

Re: open dental and apteryx conversion

1. Never thought about it. I'll add it to the planned features. Yes, it does sound like a good idea. 2. I would think of historical radiographs as nice to have, but I wouldn't count on much. If you don't get your hopes up, you won't be disappointed. I really don't know the answers. The conversions t...
by jordansparks
Thu Apr 06, 2023 6:38 pm
Forum: Main Forum
Topic: open dental and apteryx conversion
Replies: 5
Views: 4726

Re: open dental and apteryx conversion

I think the original developer of Apteryx had a lot of special inside knowledge. Native sensor support is very hard. Kudos to them for a great product. I always thought the independent imaging software companies would be around forever, so we didn't really do any imaging development for the first 15...
by jordansparks
Thu Apr 06, 2023 6:33 pm
Forum: Main Forum
Topic: How OD decides treatment area for procedure codes?
Replies: 2
Views: 3649

Re: How OD decides treatment area for procedure codes?

They are all just recommendations. There's a lot of flexibility and each insurance company also handles them differently. For 'D0140', 'D0145', 'D0150', 'D0160', 'D0170', 'D0310', and 'D0320' ADA - Does not recommend putting anything Open dental - Treatment area to Mouth Well, "nothing" is really sy...
by jordansparks
Sat Apr 01, 2023 7:53 am
Forum: Main Forum
Topic: Where is OD going?
Replies: 8
Views: 6102

Re: Where is OD going?

Having robots do the drilling on patients was definitely not tongue in cheek. I expect that to happen in approximately 80 years, which is only 40 years after I'm dead. To make it feel more plausible, start imagining all the steps that it would take to get from here to there. The roughly half-way poi...
by jordansparks
Fri Mar 31, 2023 2:32 pm
Forum: Main Forum
Topic: Done With Apteryx
Replies: 8
Views: 5386

Re: Done With Apteryx

Your device type was Twain Multi?
https://www.opendental.com/manual/imagingdevices.html
And you were using a fairly new version?

I've added the Insurance ID field to
https://www.opendental.com/site/imaging ... ments.html
by jordansparks
Fri Mar 31, 2023 2:25 pm
Forum: Main Forum
Topic: Where is OD going?
Replies: 8
Views: 6102

Re: Where is OD going?

We are nowhere close to being done with Open Dental. We've barely scratched the surface of what's possible. I'm personally getting to the end of a months long effort to make it work better on very high dpi screens. It's so much nicer at 4k. Some other things that excite me in the short term: -It loo...
by jordansparks
Fri Mar 31, 2023 7:35 am
Forum: Main Forum
Topic: Done With Apteryx
Replies: 8
Views: 5386

Re: Done With Apteryx

The Dexis website for GxTWAIN https://dexis.com/en-us/gxtwain-and-gxpicture says that multiple images are tranferred with the the Get All function. We support multiple image transfer, so it should already work fine. You mentioned not having a "bucket". I think what you are looking for is the Mount f...
by jordansparks
Wed Mar 29, 2023 5:04 am
Forum: Main Forum
Topic: Done With Apteryx
Replies: 8
Views: 5386

Re: Done With Apteryx

> We are still waiting for a couple imaging features to be incorporated
What features do you feel are missing? There's not any active development in the Imaging module at the moment.
by jordansparks
Wed Mar 29, 2023 5:01 am
Forum: Main Forum
Topic: To set up a referral letter
Replies: 3
Views: 6478

Re: To set up a referral letter

In a referral letter sheet, you can indeed add a field for notes that can be edited from patient to patient. It wouldn't be much use otherwise. But there is one gotcha to beware of. If your letter contains a toothchart or a grid, then it gets saved as an uneditable pdf. You can still edit when it fi...
by jordansparks
Wed Mar 29, 2023 4:47 am
Forum: Main Forum
Topic: Major Security Issue with Images
Replies: 1
Views: 3269

Re: Major Security Issue with Images

From all the options you listed, it kind of sounds like enhancing sFTP is the way to go. I wasn't aware that people were running into limitations with that.
by jordansparks
Wed Mar 29, 2023 4:44 am
Forum: Main Forum
Topic: Account Balance Bug
Replies: 6
Views: 4740

Re: Account Balance Bug

There's an undocumented pref called FuchsOptionsOn, which I believe you added a very long time ago. You are the only user who has that pref turned on. We've been gradually stripping those out as we run across them (sorry). So there is also a slight chance that there is some mixed behavior going on. ...
by jordansparks
Sat Jan 07, 2023 8:12 pm
Forum: Advanced Topics
Topic: Mass replace procedure codes
Replies: 1
Views: 4053

Re: Mass replace procedure codes

You can run queries to get data like that out of the database, but you should never run queries that alter the database. In theory, your approach might work. I'm 75% sure it would work, but I just can't be certain. If you corrupt your database, fixing it could be a big hassle. I think someone can fi...
by jordansparks
Sat Jan 07, 2023 8:06 pm
Forum: Advanced Topics
Topic: Death indicator in HL7
Replies: 6
Views: 5877

Re: Death indicator in HL7

Maybe when someone dies, you change the status in Open Dental. Then, if they're a non-patient, they shouldn't come through in the first place. In other words, do the same thing with a different approach. Yes, it will require staff to change the statuses, but it should be easy to run a report to see ...
by jordansparks
Thu Dec 01, 2022 9:01 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

0. Are you sure you have your Imaging Device set up for TWAIN Multi? It sounds like you still have it set up for single images. https://www.opendental.com/manual223/imagingdevices.html 1. That's new functionality that wasn't even a feature prior to 22.2. It's possible that we only tested it for acqu...
by jordansparks
Wed Jun 22, 2022 10:33 pm
Forum: Main Forum
Topic: 3D graphics
Replies: 3
Views: 2710

Re: 3D graphics

Yes, that is one of many goals. Even once we achieve it, it will still get better over many years. It's one of those features that will gradually mature because it's just so open ended. It's going to require some AI to be able to understand what it's seeing. Unlike automobile AI, this does not have ...
by jordansparks
Sun Jun 19, 2022 8:30 pm
Forum: Main Forum
Topic: 3D graphics
Replies: 3
Views: 2710

3D graphics

I've just started on the next iteration of the 3D graphics. I think this is the sixth time I've overhauled the tooth chart. One of the earliest versions, 20 years ago, was a simple jpg that I drew shapes on. Some of the overhauls have been required by updates to graphics cards over the years, and so...
by jordansparks
Mon May 16, 2022 7:25 pm
Forum: API
Topic: API General Update Request | Include TimeZone on all datetimes
Replies: 3
Views: 2306

Re: API General Update Request | Include TimeZone on all datetimes

Including it in the date field seems like a breaking change. On the other hand, everyone is probably parsing the date with a library that could easily handle the change. Still, I think we'll need to make it an option that you intentionally turn on.
by jordansparks
Mon May 16, 2022 6:24 pm
Forum: Main Forum
Topic: Patient Pictures into system quickly
Replies: 13
Views: 11202

Re: Patient Pictures into system quickly

This topic is 10 years old. A lot has changed. I can think of two different ways to do it, and there are probably more. 1. Use our automatic import feature. https://www.opendental.com/manual/images.html About one page down is a section called Import Automatically. You could set the default path to y...
by jordansparks
Sun May 15, 2022 10:07 am
Forum: Main Forum
Topic: Deleting Multiple Existing Procedures
Replies: 5
Views: 3091

Re: Deleting Multiple Existing Procedures

I think it was more important to first add the security. Adding additional ways to delete would be additional features and take additional programming time. So it's just that we don't have unlimited resources. Yes, it sounds like a helpful feature. That's why we have thousands of feature requests. M...
by jordansparks
Sat May 14, 2022 8:26 am
Forum: Main Forum
Topic: Intraoral scanner
Replies: 3
Views: 2470

Re: Intraoral scanner

Yeah, I'll take one sample of each format. jordan{at}opendental{dot}com
by jordansparks
Sat May 14, 2022 7:48 am
Forum: Advanced Topics
Topic: Where is the DB relationship between definitions/websched and appointmenttype?
Replies: 3
Views: 4762

Re: Where is the DB relationship between definitions/websched and appointmenttype?

I just added this to our schema under definition.DefCat enum: Each appointment can be assigned one appointment.AppointmentTypeNum. Multiple AppointmentTypes are linked to this definition through the DefLink table, where deflink.DefNum=definition.DefNum, deflink.LinkType=2, and deflink.FKey=appointme...
by jordansparks
Sun May 08, 2022 1:17 pm
Forum: Main Forum
Topic: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics
Replies: 7
Views: 3626

Re: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics

And now you can show mounts on sheets. A typical example would be showing an FMX or photo collage on a referral letter.
by jordansparks
Sat May 07, 2022 7:27 pm
Forum: Main Forum
Topic: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics
Replies: 7
Views: 3626

Re: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics

OK, you can now double click on an image and you get a new window that lets you pick any other image for that patient. It's still a little rough around the edges. For example, it will take a few more hours to implement this for mounts. But it is at least working. It will be in version 22.2, which sh...
by jordansparks
Sat May 07, 2022 12:07 pm
Forum: Main Forum
Topic: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics
Replies: 7
Views: 3626

Re: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics

I reviewed our current functionality. It's easy to keep track of referral sources and how they are attached to patients. It's easy to create a letter to a specific referral. This part of our software is called "sheets". Once the letter is generated and on the screen, I can edit the text of the lette...
by jordansparks
Fri May 06, 2022 7:54 pm
Forum: Main Forum
Topic: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics
Replies: 7
Views: 3626

Re: Open Dental for Oral and Maxillofacial Surgery (OMS) clinics

Or we could get our act together and improve the referral letters. I thought we already had images on referral letters, but maybe it's time to go back and take another look.
by jordansparks
Fri May 06, 2022 4:39 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

I've tested the ScanX with switching Windows users. I also had an issue, but not the one you described. My issue was that the scanner was not recognized as present, and I had to power cycle it. Then, it worked. I could not get it to lock up for me. I would suggest that you set up a Windows user for ...
by jordansparks
Wed May 04, 2022 10:05 am
Forum: Main Forum
Topic: Intraoral scanner
Replies: 3
Views: 2470

Intraoral scanner

Would anyone be able to send us a few 3D scans from an intraoral scanner so that we could work on showing them inside of Open Dental? Could be any format, like Medit .obj file or 3Shape .dcm file. And, of course, we'll need an .stl file, too. If it's an .obj file, I'm assuming the textures (photos) ...
by jordansparks
Fri Apr 29, 2022 7:51 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

I'm trying to find time to test the Scan-X issue.
by jordansparks
Fri Apr 29, 2022 7:50 am
Forum: Main Forum
Topic: Ortho brackets
Replies: 0
Views: 1784

Ortho brackets

Ortho brackets are successfully drawing, so they will be part of version 22.2.
by jordansparks
Fri Mar 25, 2022 7:11 pm
Forum: Main Forum
Topic: Patient notes through API
Replies: 6
Views: 3308

Re: Patient notes through API

Your endpoint looks wrong. Instead of this:
GET https://api.opendental.com/fhir/patientNotes/13
it should be like this:
GET https://api.opendental.com/api/v1/patientNotes/13
by jordansparks
Fri Mar 25, 2022 7:32 am
Forum: API
Topic: Schedules with google
Replies: 1
Views: 2442

Schedules with google

I got the following as a private msg. Posting it here for everyone: Here is the n8n / Javascript to perform a google calendar update w/o webhooks. I would like to reuse this code for schedules which requires the GET schedules/xxx for deletion. Google calendar will then update calendly. Code below. J...
by jordansparks
Thu Mar 24, 2022 1:28 pm
Forum: Main Forum
Topic: Xray Mount Thumbnails in imaging module
Replies: 2
Views: 2125

Re: Xray Mount Thumbnails in imaging module

Done for version 22.2
by jordansparks
Thu Mar 24, 2022 6:45 am
Forum: Main Forum
Topic: Xray Mount Thumbnails in imaging module
Replies: 2
Views: 2125

Re: Xray Mount Thumbnails in imaging module

It wasn't planned to have separate control of thumbnails for chart vs imaging, but it's a good idea, so it might even get done today. It is not planned to split radiographs into their own module. But we might add better toggles at the top of the list for showing radiographs vs front office documents...
by jordansparks
Wed Mar 16, 2022 2:35 pm
Forum: API
Topic: API Features Requested
Replies: 25
Views: 15866

Re: API Features Requested

32 bit is not helpful. My vote is for RGB. Example "200,100,52". We could later add hex if some people prefer it, but the conversion between the two is really easy.
by jordansparks
Wed Mar 16, 2022 2:30 pm
Forum: Main Forum
Topic: Sheet - image field max height is 4000
Replies: 5
Views: 3217

Re: Sheet - image field max height is 4000

Ah, thanks for researching that. I suspect that your background finally got taller than 4000, and that's why you noticed it. We chose what we thought was a ridiculously tall number that nobody would ever hit. Each page is 1100 tall, so that's almost 4 pages. There might not be a problem with us allo...
by jordansparks
Tue Mar 15, 2022 4:27 pm
Forum: Main Forum
Topic: Sheet - image field max height is 4000
Replies: 5
Views: 3217

Re: Sheet - image field max height is 4000

Someone at Open Dental should research this to find out when it was changed and why. Then, we will know what to do.
by jordansparks
Sun Mar 06, 2022 4:11 pm
Forum: API
Topic: API or short query GET patient profile photo
Replies: 1
Views: 1981

Re: API or short query GET patient profile photo

It sounds like you first need a query to know which document. Then, you could use POST DownloadSftp to get that image. SELECT DefNum FROM definition WHERE Category=18 AND ItemValue LIKE '%P%'; If you get a valid DefNum (190 in this example), then use: SELECT DocNum FROM document WHERE DocCategory=19...
by jordansparks
Sun Mar 06, 2022 1:51 pm
Forum: Main Forum
Topic: Use WHATSAPP to text your patients from Open Dental
Replies: 6
Views: 12607

Re: Use WHATSAPP to text your patients from Open Dental

Plugins are being deprecated for users in the US, so this would only work outside the US.
by jordansparks
Sun Mar 06, 2022 1:50 pm
Forum: Main Forum
Topic: Sheet - image field max height is 4000
Replies: 5
Views: 3217

Re: Sheet - image field max height is 4000

4000 would be 40", but paper is only 11" tall. Does it spill across multiple pages?
by jordansparks
Sun Mar 06, 2022 1:41 pm
Forum: API
Topic: API: high/duplicate AptNum returned by Appointments GET (multiple)
Replies: 4
Views: 3013

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

We settled on this about 15 years ago. It allowed different ranges of PKs for different offices all using the same database with replication, so that there was virtually no chance of collision. Also, many tables such as logs can fill up rather quickly. It's something that must be intentionally turne...
by jordansparks
Thu Mar 03, 2022 10:39 pm
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41575

Re: FHIR with trial version

We just release chart module data, and we could make a method for TP data, if that's what you are asking for. Maybe start a new thread instead of reusing the very old and unrelated thread.
by jordansparks
Thu Mar 03, 2022 10:38 pm
Forum: API
Topic: API: high/duplicate AptNum returned by Appointments GET (multiple)
Replies: 4
Views: 3013

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

But it's always possible for patient databases to have extremely large primary keys. You need to be able to handle them, even if they are large. In C#, the type is long, and in mysql, the same type is called bigint. It can have a max of 9,223,372,036,854,775,807.
by jordansparks
Wed Feb 23, 2022 10:06 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Ah, thank you for the complete explanation. This might be enough for us to be able to duplicate the problem here.
by jordansparks
Wed Feb 23, 2022 10:05 am
Forum: Main Forum
Topic: mysqladmin flush-hosts
Replies: 8
Views: 10898

Re: mysqladmin flush-hosts

So when you were doing testing with HL7, I'm unclear if you were connecting directly to the db. If so, then you were probably the one who created all the extra connections. Instead, try to reuse the same connection.
by jordansparks
Tue Feb 22, 2022 7:04 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

What version are you on?
by jordansparks
Tue Feb 15, 2022 2:00 pm
Forum: API
Topic: API Issue - Slots
Replies: 11
Views: 5084

Re: API Issue - Slots

I think Get Slots is the best right now until we add the new functionality. You could use a little math to generate appropriate individual slots.
by jordansparks
Tue Feb 15, 2022 1:25 pm
Forum: API
Topic: Postman Response - "The server has encountered an error."
Replies: 3
Views: 2573

Re: Postman Response - "The server has encountered an error."

We're reaching out to you by email. We need to know which offices.
by jordansparks
Tue Feb 15, 2022 1:16 pm
Forum: API
Topic: Postman Response - "The server has encountered an error."
Replies: 3
Views: 2573

Re: Postman Response - "The server has encountered an error."

We'll stop working on other things and focus on this problem. There should be no active bugs like this, so we'll work on it aggressively.
by jordansparks
Tue Feb 15, 2022 1:12 pm
Forum: API
Topic: API Issue - Slots
Replies: 11
Views: 5084

Re: API Issue - Slots

This is a good point. The thinking was that if you count each possible time as a slot, then you would just get a bunch of slots for the same day, whereas it might be more useful to get one for each day, and then you could pick any time within that range. Unfortunately, you would need to do a little ...
by jordansparks
Tue Feb 15, 2022 12:54 pm
Forum: API
Topic: API Keys Tier 2 and Tier 3
Replies: 6
Views: 3501

Re: API Keys Tier 2 and Tier 3

Until we get that done, we would be happy to move one customer at a time for you manually. Contact us by email for that.
by jordansparks
Tue Feb 15, 2022 12:08 pm
Forum: API
Topic: API Keys Tier 2 and Tier 3
Replies: 6
Views: 3501

Re: API Keys Tier 2 and Tier 3

Since our permissions are all at the developer level, I think we're going to be stuck with moving a customer key from one developer to another. Permissions at the customer level would be a massive change. It's possible, of course, but just not sure if it makes the most sense. I think I would rather ...
by jordansparks
Tue Feb 15, 2022 10:32 am
Forum: API
Topic: API Keys Tier 2 and Tier 3
Replies: 6
Views: 3501

Re: API Keys Tier 2 and Tier 3

Let me clarify. Do you currently have two separate developer keys? It sounds like this would be the first step, so that each "developer" had different permissions. Then, we need to add a tool to the developer portal to let you move a customer key from one of your developers to the other. Does that s...
by jordansparks
Mon Feb 14, 2022 10:56 am
Forum: API
Topic: Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?
Replies: 5
Views: 3477

Re: Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

Hmm, I don't quite understand. I don't know how much you know about our schema, so I'll start at a very high level, and then you can reply to help me narrow in on what you are asking. Our schema is here: https://www.opendental.com/OpenDentalDocumentation21-4.xml The following tables might be related...
by jordansparks
Mon Feb 14, 2022 10:28 am
Forum: Main Forum
Topic: Tabbing in the Benefit Frequencies Box
Replies: 4
Views: 2733

Re: Tabbing in the Benefit Frequencies Box

I'm assuming this is in the Edit Benefits window:
https://www.opendental.com/manual/benefitinfo.html
by jordansparks
Mon Feb 14, 2022 10:12 am
Forum: Main Forum
Topic: Crashed table
Replies: 9
Views: 5640

Re: Crashed table

The database integrity warnings would be totally unrelated to the issue of this thread, which is restoring a backup. You should never get a false positive on those integrity warnings. What specific version of OpenDental are you using?
by jordansparks
Mon Feb 14, 2022 9:54 am
Forum: API
Topic: API Request-Blockouts
Replies: 8
Views: 4325

Re: API Request-Blockouts

Yes, we will do this. It would be GET schedules.
by jordansparks
Mon Feb 07, 2022 3:13 pm
Forum: API
Topic: Events
Replies: 4
Views: 3271

Re: Events

I did get the first UI event to fire. This event fires every time you change patients, and it tells you who the new patient is.
by jordansparks
Sun Feb 06, 2022 8:51 am
Forum: API
Topic: Events
Replies: 4
Views: 3271

Re: Events

Events are functional and will be in version 22.1. So you subscribe to an event https://www.opendental.com/site/apisubscriptions.html and now it fires off to your chosen end point. It's pretty cool. The next step, which I hope to have done before the end of the weekend, is UI events. Push a button o...
by jordansparks
Sat Feb 05, 2022 6:05 pm
Forum: Main Forum
Topic: Crashed table
Replies: 9
Views: 5640

Re: Crashed table

My thought is that maybe our dataintegritycheck needs to be adapted to maria? I'm skeptical that the suggestions to uninstall and reinstall things would do much. I'm so happy that you are regularly trying to restore your database. You won't go bankrupt when your server crashes. It really should be e...
by jordansparks
Sat Feb 05, 2022 5:53 pm
Forum: API
Topic: API Features Requested
Replies: 25
Views: 15866

Re: API Features Requested

Thank you. Got it. We will look into it.
by jordansparks
Sat Feb 05, 2022 5:51 pm
Forum: API
Topic: Local API
Replies: 3
Views: 2910

Re: Local API

That's correct. Usually, when an IT person hears "open a port", then assume we mean changing a rule on the router to allow incoming traffic from the dangerous web. That's not what we're talking about.
by jordansparks
Thu Feb 03, 2022 3:55 pm
Forum: Main Forum
Topic: Compile error
Replies: 1
Views: 1713

Re: Compile error

Maybe right click on the Solution in the Solution Explorer tab and click Restore NuGet Packages?
by jordansparks
Thu Feb 03, 2022 3:53 pm
Forum: Developers
Topic: compile error with 21.4
Replies: 2
Views: 4530

Re: compile error with 21.4

It's always a bear to learn all the nuances. It can take some work with the configuration manager and with removing and adding references. We give some guidance here: https://www.opendental.com/site/sourcecode.html Also, if you're using it for testing purposes, you can just install the trial version...
by jordansparks
Wed Feb 02, 2022 4:28 pm
Forum: Developers
Topic: is VS2017 ok to use to compile OD 21.3+
Replies: 3
Views: 4886

Re: is VS2017 ok to use to compile OD 21.3+

Various versions of VS2019. It doesn't seem to matter. Some engineers keep it up to date and others don't. I have 3 computers, but at the computer I'm currently sitting at, it seems to be version 16.11.5. It's probably different on my others.
by jordansparks
Wed Feb 02, 2022 7:03 am
Forum: API
Topic: Local API
Replies: 3
Views: 2910

Local API

Local API is complete. It will be part of version 22.1. This lets you send API messages directly to the local running instance of OpenDental.exe on port 30222. Because it's local instead of going through our HQ servers, it's blazing fast. We do quickly plan to add the eConnector port 30223 as a thir...
by jordansparks
Tue Feb 01, 2022 8:22 pm
Forum: Developers
Topic: is VS2017 ok to use to compile OD 21.3+
Replies: 3
Views: 4886

Re: is VS2017 ok to use to compile OD 21.3+

I'm not sure. We use VS2019. It might work.
by jordansparks
Thu Jan 27, 2022 2:48 pm
Forum: Main Forum
Topic: Plugin users - Pop up warnings as of Open Dental v 21.4
Replies: 8
Views: 5161

Re: Plugin users - Pop up warnings as of Open Dental v 21.4

How many offices are we talking about? That's a lot of work for just one office.
by jordansparks
Thu Jan 27, 2022 1:35 pm
Forum: Main Forum
Topic: Plugin users - Pop up warnings as of Open Dental v 21.4
Replies: 8
Views: 5161

Re: Plugin users - Pop up warnings as of Open Dental v 21.4

You developed a plug-in in-house for your own use and you are not distributing it to others? And you are inserting PayPlanCharges? That's interesting. I can't quite figure out why you are doing that, but I can still talk about it. We would encourage you to use the API. This would be especially impor...
by jordansparks
Thu Jan 27, 2022 10:39 am
Forum: API
Topic: API Features Requested
Replies: 25
Views: 15866

Re: API Features Requested

I still don't understand. A windows filename cannot be "cleared". Every file has to have a name. Maybe you mean the document.Description gets cleared. We'll try to duplicate.
by jordansparks
Thu Jan 27, 2022 10:36 am
Forum: Main Forum
Topic: Plugin users - Pop up warnings as of Open Dental v 21.4
Replies: 8
Views: 5161

Re: Plugin users - Pop up warnings as of Open Dental v 21.4

The part of our website that you quoted is not about plugins. There are two different ways that 3rd parties can currently make changes to our db: 1. Plugins, the topic of this thread. 2. Queries, which is what you quoted from our website. Yes, they are related, and the warning timeline might be simi...
by jordansparks
Thu Jan 27, 2022 8:54 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Uncropping and recropping should always fix it. If not, that seems like a completely unrelated bug. I'll set someone on trying to duplicate that issue.
by jordansparks
Wed Jan 26, 2022 1:50 pm
Forum: Developers
Topic: Shifting from a plugin to web services
Replies: 1
Views: 4239

Re: Shifting from a plugin to web services

Our current plan is to not deprecate plug-ins for international customers so that the Mopensoft plugin and other similar plugins will continue to work. Our eServices are tailored to the US, and each country is different.
by jordansparks
Wed Jan 26, 2022 1:48 pm
Forum: API
Topic: API Features Requested
Replies: 25
Views: 15866

Re: API Features Requested

What do you mean by "it changes his name"? File name? Patient name? Description?
by jordansparks
Wed Jan 26, 2022 1:44 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 110520

Re: Radiographs and Intraoral Cameras

The retake button is only present in the middle of a sequence. If you are retaking after completing the sequence, then you would manually unmount the one you were interested in, then recapture. At least for now. I'll begin considering the workflow for a retake after finishing a series.
by jordansparks
Wed Jan 26, 2022 1:37 pm
Forum: Main Forum
Topic: Plugin users - Pop up warnings as of Open Dental v 21.4
Replies: 8
Views: 5161

Re: Plugin users - Pop up warnings as of Open Dental v 21.4

No, there will absolutely be no interruption of any plugin with version 21.4. All plugins are whitelisted. In fact, we also made the decision to let international users continue to use plugins moving forward, regardless of our decision to phase them out in the US. International customers don't have ...
by jordansparks
Wed Jan 26, 2022 1:24 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

I'm very sorry about that. We released a "fix" a week ago, but then realized that the fix was also buggy. We are releasing the real fix in the next few minutes, version 21.4.20. You will want to update to that immediately. Any images that you viewed while using 21.4.17, and which looked bad can no l...
by jordansparks
Mon Jan 24, 2022 11:49 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 110520

Re: Radiographs and Intraoral Cameras

I thought we added a retake button to 21.4, but it is admittedly mediocre. It got reworked slightly in version 22.1. I can't figure out how to make it completely "automatic". I mean you have to tell the software somehow that this is a retake and not the next one in the series. We got it down to 2 cl...
by jordansparks
Fri Jan 21, 2022 7:25 am
Forum: API
Topic: Events
Replies: 4
Views: 3271

Re: Events

We are making good progress on Events. One fundamental problem that I still can't quite figure out is that databases don't inherently generate events that are consumable externally. That means we will still need to poll the db at a certain interval in order to generate database events. But I think w...
by jordansparks
Thu Jan 20, 2022 5:45 pm
Forum: Developers
Topic: ShoryQuery Syntax Question
Replies: 4
Views: 5378

Re: ShoryQuery Syntax Question

We should improve this message to indicate that it's likely a version issue. We might even be able to get fancy about it and check the required version for each API method.
by jordansparks
Thu Jan 20, 2022 10:21 am
Forum: API
Topic: Events
Replies: 4
Views: 3271

Events

Our current API has no events. It has come to my attention that various 3rd parties depend heavily on events for their functionality. So far, I'm aware of two strategies: 1. MySQL triggers added to the db. When a trigger fires, this runs a query or multiple queries. 2. Plug-in that responds to certa...
by jordansparks
Thu Jan 20, 2022 10:14 am
Forum: Main Forum
Topic: When does Open Dental anticipate plugins to be deprecated?
Replies: 7
Views: 12686

Re: When does Open Dental anticipate plugins to be deprecated?

>In addition, OD is planning on charging the developer and the dental office for reading and writing this data.
Not quite. No charge to anyone for reading. If writing, there will be a very small charge to the developer, not to the dental office.
by jordansparks
Thu Jan 20, 2022 9:56 am
Forum: API
Topic: Database Integrity
Replies: 6
Views: 8432

Re: Database Integrity

We are constantly making improvements to this area. I expect the false positives to go away within a week or two in the beta. You would need to update the beta to see the changes.
by jordansparks
Tue Jan 18, 2022 6:41 pm
Forum: Developers
Topic: The remote server returned an error: (500) Internal Server Error
Replies: 6
Views: 11558

Re: The remote server returned an error: (500) Internal Server Error

It's giving them to you in batches of 100 at a time, right? Because there's a hard limit of 100. So are you saying it's 1 minute for each request?
by jordansparks
Tue Jan 18, 2022 6:33 pm
Forum: Main Forum
Topic: Free Open Dental Imaging - "Acquire" Xrays in OD, and Sensor Setup instructions
Replies: 2
Views: 6887

Re: Free Open Dental Imaging - "Acquire" Xrays in OD, and Sensor Setup instructions

We were going to build a separate Imaging module that we would charge separately for. Then Apteryx took a nose dive and Covid hit. I decided that dentists couldn't really afford to pay separately for this, so we just rolled it all into the main program. As part of that compromise, I decided that the...
by jordansparks
Tue Jan 18, 2022 6:11 pm
Forum: Main Forum
Topic: When does Open Dental anticipate plugins to be deprecated?
Replies: 7
Views: 12686

Re: When does Open Dental anticipate plugins to be deprecated?

It's a gradual process that requires constant feedback and adjustment. So it really is impossible to say. The current plan is to start with subtle warnings that don't actually interfere with functionality. The other part of this is that we don't want people to be afraid to update versions of Open De...
by jordansparks
Mon Jan 17, 2022 9:42 am
Forum: API
Topic: Communication, SMS Text messaging API
Replies: 1
Views: 2291

Re: Communication, SMS Text messaging API

I don't think there should be an API method that a 3rd party could call that would cause Open Dental to send an SMS. On the other hand, the API could be used by a 3rd party to get information like cell number, and then to also make an entry into the Db that the text was sent. The 3rd party would do ...
by jordansparks
Fri Jan 14, 2022 12:51 pm
Forum: Developers
Topic: Are there patient GUID's?
Replies: 2
Views: 3874

Re: Are there patient GUID's?

Just PatNum. No GUIDs.
by jordansparks
Fri Jan 14, 2022 11:49 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

The issue with cropping is a bug that I thought would be fixed by now. We should be very close. We never alter the raw image. All brightness, contrast, text, cropping, etc is always just applied as a filter when viewing. This means it's always 100% reversible. Fortunately, we are able to apply these...
by jordansparks
Fri Jan 14, 2022 11:34 am
Forum: API
Topic: API Request
Replies: 19
Views: 8553

Re: API Request

Another user had requested 10 items just before you, so we're still plowing through those. I moved #7 to the top of your group and we'll try to get to it right away.
by jordansparks
Wed Jan 12, 2022 3:19 pm
Forum: API
Topic: LAN-API
Replies: 0
Views: 2092

LAN-API

We're going to start working on a LAN-API. This would avoid the round trip of the API call to our HQ, and your app would instead talk to the eConnector that's already running on the dental office server. This would be faster, and it would also remain running if the internet went down. The message fo...
by jordansparks
Tue Jan 11, 2022 6:24 pm
Forum: Developers
Topic: Releases stopped being posted and developer emails stopped
Replies: 4
Views: 4773

Re: Releases stopped being posted and developer emails stopped

We switched to GIT! The new GIT repository is not public, so our plan is to push copies to a public GIT repository on github. We have not started doing that because nobody was clamoring for it.
by jordansparks
Tue Jan 11, 2022 6:15 pm
Forum: API
Topic: Database Integrity
Replies: 6
Views: 8432

Re: Database Integrity

We will write the APIs that you need. I don't think Flex has asked for any yet, but we've been adding new methods quickly as requests come in.
by jordansparks
Sun Jan 09, 2022 9:34 am
Forum: Sharing
Topic: SMS Texting with Diafaan in Open Dental $89/year
Replies: 2
Views: 27576

Re: SMS Texting with Diafaan in Open Dental

Probably don't. We're deprecating plugins. They are far too dangerous and are causing database corruption. I'm not saying that this plugin is causing database corruption, but I'm explaining why we are deprecating plugins in general. What can Mopensoft do? The plugin should instead be an exe. The but...
by jordansparks
Sat Jan 08, 2022 6:45 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

>So the concept of using Apteryx within OD has been working wonderfully...
I think you meant to say Scan-X, not Apteryx, right?
What specific version are you using?
by jordansparks
Sat Jan 08, 2022 6:42 pm
Forum: Advanced Topics
Topic: Getting The Allowed Column In Treatment Plan
Replies: 7
Views: 7138

Re: Getting The Allowed Column In Treatment Plan

Would BaseEst be close enough? It does already have percentages applied. Notice that in the description of AllowedOverride, ComputeBaseEst is the function where the allowed fee is calculated. BaseEst is very close to allowed fee.
by jordansparks
Sat Jan 08, 2022 6:28 pm
Forum: Developers
Topic: Send Mail Via Token-The host does not support SSL connections
Replies: 4
Views: 5017

Re: Send Mail Via Token-The host does not support SSL connections

Notice in line 482 that this method does an insert to the db. That's not allowed. You cannot ever call a method in Open Dental which alters the database (which means most methods). I'm unclear how you are "referencing" Open Dental, but we have been working hard lately to block all such action. Even ...
by jordansparks
Wed Jan 05, 2022 10:19 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Your first issue is a bug that we are now working on.
by jordansparks
Wed Jan 05, 2022 10:03 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 110520

Re: Radiographs and Intraoral Cameras

Those are both great suggestions and have been added to the top of the priority list in:
https://www.opendental.com/site/imaging ... ments.html
by jordansparks
Wed Jan 05, 2022 9:49 am
Forum: API
Topic: API Request
Replies: 19
Views: 8553

Re: API Request

5. I did think of a way, but it won't be easy. We've been toying with the idea of a "local API" for certain things. Instead of sending an API command to our server, you would send it directly to the local running copy of OD by using local port. OD would act as a web server and respond to your API re...
by jordansparks
Wed Jan 05, 2022 9:27 am
Forum: API
Topic: API Request
Replies: 19
Views: 8553

Re: API Request

We've added all of this to our todo list, and it should be done relatively shortly.
by jordansparks
Tue Jan 04, 2022 9:22 am
Forum: API
Topic: API Request
Replies: 19
Views: 8553

Re: API Request

5. There has to be some way to identify which dental office you are interacting with. The way we came up with is that you create your customer key, and then you paste that into the UI on the customer's end. I can't think of any way to reduce the number of steps, which is what you seem to be trying t...
by jordansparks
Mon Jan 03, 2022 7:07 am
Forum: API
Topic: API change log
Replies: 3
Views: 2838

Re: API change log

The idea is to not "change" anything, but instead to add to it. We indicate the version that each method was added.
by jordansparks
Thu Dec 16, 2021 6:13 pm
Forum: Main Forum
Topic: Patient database missing on a workstation
Replies: 2
Views: 2290

Re: Patient database missing on a workstation

Your database is on your server, not on your workstation. When you open Open Dental, you always connect to that database. So you must have simply connected to the wrong database, probably another one on your server. Go to a workstation that's working, and see which database you are connected to. Tha...
by jordansparks
Wed Dec 08, 2021 6:25 pm
Forum: API
Topic: API Features Requested
Replies: 25
Views: 15866

Re: API Features Requested

>Also, as a side question, what would be your recommendation to discover new/changed appointments via read API in an efficient way?
Appointments GET (multiple). Specify a DateTStamp with your call so that you are only getting the new/changed ones.
by jordansparks
Mon Dec 06, 2021 10:14 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

We provide a conversion service. It involves an export from Apteryx followed by in import into Open Dental.
by jordansparks
Thu Dec 02, 2021 6:42 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

My understanding is that digital panos are easy. That's just a single image.
by jordansparks
Thu Dec 02, 2021 6:39 pm
Forum: API
Topic: New APIs Needed
Replies: 11
Views: 6011

Re: New APIs Needed

#2: There are certain fields that it would not make sense to be able to edit. For example, patplan.PatNum and patplan.InsSubNum. Instead of changing these two fields, you would either POST PatPlans or DELETE PatPlans. The rest of the fields make sense. #3: Similar issue as above with claim.PlanNum, ...
by jordansparks
Wed Dec 01, 2021 11:02 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

This area is developing so quickly that the feature request system is really too slow to keep track of it. I'm tracking it all here: https://www.opendental.com/site/imagingimprovements.html I just haven't had a chance to work in your new suggestions, but they are great. So if the rapid progress slow...
by jordansparks
Mon Nov 29, 2021 10:32 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Thank you so much for all the great feedback. We will work hard to make this smoother. Most of the complaints will need to be added as new features, but one of them is already done: Exporting single images from a mount is better in 21.4. 21.4 also has a lot of other improvements that are unrelated t...
by jordansparks
Tue Nov 23, 2021 9:35 am
Forum: Developers
Topic: The host does not support SSL connections
Replies: 1
Views: 4731

Re: The host does not support SSL connections

You should use our API. Direct inserts to the database are not allowed. If you are using a built-in method, then I'm guessing you're using a plug-in. Plug-ins will fail to load in version 21.4 unless they are white listed, and staying white listed will become harder over time. We would probably not ...
by jordansparks
Tue Nov 23, 2021 9:32 am
Forum: Advanced Topics
Topic: CDT Codes on different version
Replies: 1
Views: 5447

Re: CDT Codes on different version

We usually backport to the stable version. I think the new codes are inserted during the version update. So, we'll at least backport to 21.3. If we don't backport to 21.1, you can add any important code manually.
by jordansparks
Sun Nov 21, 2021 2:07 pm
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6341

Re: Procedure Button in Chart Module for 3 Unit Bridge

Our autocodes do not support one of the conditions resulting in no code. Each condition has to have a code. So your scenario is just a little too complicated for the autocode logic at this point. But as I went through the clicks, you're really only looking at 2 additional clicks.
by jordansparks
Sat Nov 20, 2021 7:12 am
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6341

Re: Procedure Button in Chart Module for 3 Unit Bridge

#3 doesn't belong in the autocode. An autocode is for a set of mutually exclusive criteria. A tooth can be a pontic OR a retainer, and there's one autocode to make that decision. It looks like BU would need to be entered as a separate step. I think what's going on here, and why I didn't catch on soo...
by jordansparks
Fri Nov 19, 2021 3:54 pm
Forum: Main Forum
Topic: Global Lock
Replies: 2
Views: 3069

Re: Global Lock

preference
PrefName=SecurityLockDate
by jordansparks
Fri Nov 19, 2021 2:05 pm
Forum: Main Forum
Topic: USB Camera (MD740) with Open Dental
Replies: 3
Views: 3795

Re: USB Camera (MD740) with Open Dental

We tested on a PD740, which looks pretty much the same as your MD740 and is probably the same hardware inside. Our camera came with driver software that will generate a keyboard button press when the Capture button is pressed. There's a link to the software in our manual. https://www.opendental.com/...
by jordansparks
Fri Nov 19, 2021 12:25 pm
Forum: Main Forum
Topic: USB Camera (MD740) with Open Dental
Replies: 3
Views: 3795

Re: USB Camera (MD740) with Open Dental

Do you mean the live video is laggy or that the single image capture is laggy?
by jordansparks
Fri Nov 19, 2021 6:58 am
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6341

Re: Procedure Button in Chart Module for 3 Unit Bridge

Your autocodes really should already be set up. You can reset them to defaults using Procedure Code Tools. The main reason we allow editing of autocodes is for foreign users who use different coding systems. Keeping that in mind, there's one autocode for pontic vs. retainer. It would have nothing to...
by jordansparks
Thu Nov 18, 2021 5:41 pm
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6341

Re: Procedure Button in Chart Module for 3 Unit Bridge

There should already be a button for bridge. The basic idea is that you set up the button to have the AutoCode for bridge. That assumes that the autocode is set up properly. So then, you go check out the autocode that you used. It should have two procedures in it: one for pontic and another for reta...
by jordansparks
Thu Nov 18, 2021 4:55 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Support has been added for the ScanX. It will be a few days until these changes make their way into version 21.3, and they can't be backported further than that.
by jordansparks
Thu Nov 18, 2021 7:08 am
Forum: API
Topic: PriProv field is 0 in GET Patients & GET Patients/{patientNumber} API
Replies: 5
Views: 5310

Re: PriProv field is 0 in GET Patients & GET Patients/{patientNumber} API

Probably done by the end of today, and then we release about twice a week. It will be backported to 21.3.
by jordansparks
Wed Nov 17, 2021 6:15 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

ScanX machine has arrived, so we've begun troubleshooting.
by jordansparks
Mon Nov 15, 2021 12:50 pm
Forum: Developers
Topic: ThreatLocker
Replies: 1
Views: 4500

Re: ThreatLocker

Let's talk for a moment about how whitelisting works when using Windows Security Policy instead of ThreatLocker. In Windows, you can specify a path, a certificate, or a hash. Both path and certificate would allow Open Dental to run, and only the hash would block our updates. I tried to look for some...
by jordansparks
Fri Nov 12, 2021 8:09 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Sorry about the hassle.
by jordansparks
Thu Nov 11, 2021 8:49 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Someone successfully used ScanX by using their VistaEasy software. http://opendentalsoft.com/forum/viewtopic.php?t=5903 I downloaded VistaEasy and can't get it to work, but that's probably because I don't have a ScanX device connected. I ordered a ScanX on eBay, but that will take a little while to ...
by jordansparks
Thu Nov 11, 2021 2:33 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 50
Views: 36265

Re: Scan-X with new integrated x-ray feature

Our assumption with the ScanX was that it could dump all your images to a folder instead of using Twain. That's why we built the "Import Automatically" feature. Does ScanX not let you do that? If it's using Twain, then it's going to want to send a series of image, which Open Dental can't handle. We ...
by jordansparks
Wed Nov 10, 2021 7:25 am
Forum: Main Forum
Topic: color procedure changes
Replies: 7
Views: 5220

Re: color procedure changes

https://www.opendental.com/manual/defin ... olors.html
I would recommend nice dark colors for both planned and completed because text looks better when dark. But you can choose your colors.
by jordansparks
Tue Nov 09, 2021 12:43 pm
Forum: API
Topic: API Features Requested
Replies: 25
Views: 15866

Re: API Features Requested

So I think that's all of them.
by jordansparks
Tue Nov 09, 2021 12:40 pm
Forum: API
Topic: Customer API Key
Replies: 8
Views: 6272

Re: Customer API Key

We're still trying to find a place in the db to put this info. I think it will probably need a new table. We'll talk about it again tomorrow to try to finalize.
by jordansparks
Mon Nov 08, 2021 10:47 am
Forum: API
Topic: Customer API Key
Replies: 8
Views: 6272

Re: Customer API Key

We talked about it. The key is available in our UI, but not in our database. To show in our UI, it makes a call to our HQ server. For now, you would need to store your own config information using any normal method that you wish, including registry, ini file, xml file, database, web method, etc. We ...
by jordansparks
Sun Nov 07, 2021 6:34 pm
Forum: Main Forum
Topic: Imaging Improvements
Replies: 5
Views: 4789

Re: Imaging Improvements

In Open Dental, we never alter the original image. We apply crop, rotation, contrast, etc. as a programmatic "filter". So the original images will not be changed. With this version, a conversion needs to be applied to the database in order for the old filter strategy to be converted to the new more-...
by jordansparks
Sun Nov 07, 2021 1:28 pm
Forum: Main Forum
Topic: Imaging Improvements
Replies: 5
Views: 4789

Re: Imaging Improvements

It's some matrices, some geometry, and lots of head scratching. We used to crop, then rotate/flip. Now, we have to rotate/flip before we crop. So that gives a totally different result. That's fine, but what do we do about all the existing crop-rotates? They must all be converted. We need eight conve...
by jordansparks
Sun Nov 07, 2021 7:19 am
Forum: API
Topic: Database Integrity
Replies: 6
Views: 8432

Database Integrity

We have started implementing our Database Integrity features:
https://www.opendental.com/site/integrity.html
There will be a few irritated users, but we have to rip that Band-Aid off. We have too much database corruption.
by jordansparks
Sun Nov 07, 2021 7:14 am
Forum: Main Forum
Topic: Writing data to database
Replies: 1
Views: 11371

Re: Writing data to database

Plug-ins must now be whitelisted in order to work.
https://www.opendental.com/site/pluginwhitelisting.html
by jordansparks
Sat Nov 06, 2021 6:24 pm
Forum: Main Forum
Topic: Imaging Improvements
Replies: 5
Views: 4789

Imaging Improvements

https://www.opendental.com/site/imaging ... ments.html
Rotations are being enhanced. Lots of crazy math...
by jordansparks
Sat Nov 06, 2021 6:23 pm
Forum: API
Topic: Customer API Key
Replies: 8
Views: 6272

Re: Customer API Key

I think that sounds about right. But I never really thought about different clients. The way I envisioned this being used was from a database driven server at the HQ of the third party using the API. It sounds like you will be calling the API from software running directly on the customer machine. D...
by jordansparks
Sat Nov 06, 2021 6:14 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 110520

Re: Radiographs and Intraoral Cameras

From https://www.opendental.com/manual/senso ... ility.html
Make sure you have the box checked to show Twain UI. And RESTART Open Dental after you check it. It's designed to only need to click Capture once.
by jordansparks
Thu Nov 04, 2021 6:49 pm
Forum: Main Forum
Topic: Acquire series
Replies: 10
Views: 7563

Re: Acquire series

The unmounted feature is complete.
by jordansparks
Thu Nov 04, 2021 7:14 am
Forum: Advanced Topics
Topic: Using artificial intelligence in dentistry
Replies: 10
Views: 22044

Re: Using artificial intelligence in dentistry

I looked at their website. I honestly don't see the point. There are thousands of cool things that I would love to add to Open Dental. The stuff I saw there did not excite me by comparison. I don't think they have reached out to us, but it would be very easy for them to mine our database for any cus...
by jordansparks
Wed Nov 03, 2021 7:33 pm
Forum: Main Forum
Topic: Remote from Laptop (for hospital/operating room use)
Replies: 2
Views: 3631

Re: Remote from Laptop (for hospital/operating room use)

You can install Open Dental onto that laptop. Install MySQL, demo database, etc. Maybe don't try to get your actual database onto that laptop. Now, you want to take radiographs for John Smith. Create a dummy patient John Smith on the database that's on the laptop. Use your sensor and phosphor plates...
by jordansparks
Wed Nov 03, 2021 7:26 pm
Forum: Main Forum
Topic: Acquire series
Replies: 10
Views: 7563

Re: Acquire series

An unmounted area is being built. It's going pretty well. Looks like it should work fine.
by jordansparks
Mon Nov 01, 2021 6:33 pm
Forum: API
Topic: Cancelling appointments
Replies: 10
Views: 11159

Re: Cancelling appointments

This also handles my situation #3 above, which I think will be by far the most common use of this method. So no fee charged for breaking the appointment, and the appointment goes to the unscheduled list where it can easily be found for later rescheduling.
by jordansparks
Sun Oct 31, 2021 3:49 pm
Forum: Main Forum
Topic: Acquire series
Replies: 10
Views: 7563

Re: Acquire series

So we need a feature to let people change the planned order right before they start. Right now, we assume that everyone can use the same order. It's currently customizable, but only one sequence for the whole office.
by jordansparks
Sun Oct 31, 2021 1:07 pm
Forum: Main Forum
Topic: Acquire series
Replies: 10
Views: 7563

Re: Acquire series

>Many of my assistants will take one x-ray, then rotate and reposition it on the mount
Why on earth would they need to rotate? Rotate is supposed to be automatic.
by jordansparks
Sun Oct 31, 2021 10:12 am
Forum: Main Forum
Topic: Free eServices when you are on Customer Support
Replies: 1
Views: 3357

Re: Free eServices when you are on Customer Support

That post was from a customer, not from a representative of Open Dental.
by jordansparks
Sun Oct 31, 2021 10:11 am
Forum: Main Forum
Topic: Open Dental Employee Training $50/hr and YouTube webinars
Replies: 1
Views: 3398

Re: Open Dental Employee Training $50/hr and YouTube webinars

That post was from a customer, not from a representative of Open Dental.
by jordansparks
Sun Oct 31, 2021 10:09 am
Forum: Main Forum
Topic: Acquire series
Replies: 10
Views: 7563

Re: Acquire series

Clearly, an "unmounted" section is a good solution. I'm going to take your hint and describe a workflow for us to pursue. Let's say you are in position 3 of 18, and you just took a bad radiograph. Ideally, you would want a single button click that would move that bad radiograph down to the unmounted...
by jordansparks
Sat Oct 30, 2021 5:08 pm
Forum: Main Forum
Topic: Acquire series
Replies: 10
Views: 7563

Re: Acquire series

The bug is fixed. It only affected the beta 21.3.
by jordansparks
Sat Oct 30, 2021 4:28 pm
Forum: Main Forum
Topic: Acquire series
Replies: 10
Views: 7563

Acquire series

This comment was from another topic: "...there are some feature that's not available such as... being able to go back to redo previous capture automatically (we have to quit the on-going capture and delete image first)" I've been thinking about that for quite a few days. Originally, I thought it mig...
by jordansparks
Wed Oct 27, 2021 11:39 am
Forum: Main Forum
Topic: Apteryx
Replies: 27
Views: 26264

Re: Apteryx

Yes, we convert from Apteryx, and the files end up in the normal A-Z folder in Open Dental.
by jordansparks
Wed Oct 27, 2021 9:53 am
Forum: Main Forum
Topic: Apteryx
Replies: 27
Views: 26264

Re: Apteryx

I don't see Tuxedo on the list of sensors that users have reported as working successfully. But so far nobody has run across a sensor that won't work. What imaging software are you converting from?
by jordansparks
Wed Oct 27, 2021 9:00 am
Forum: Main Forum
Topic: Apteryx
Replies: 27
Views: 26264

Re: Apteryx

I would focus on the update to the newer version first. Once you get that settled and running smoothly, you would talk to the conversions department. Yes, you could technically do all of that this morning. But you'd be on the phone for a while, and it would probably involve a remote connection to lo...
by jordansparks
Tue Oct 26, 2021 10:33 pm
Forum: Main Forum
Topic: Apteryx
Replies: 27
Views: 26264

Re: Apteryx

1. Until we get that, you could do retakes in a second run, after you were all done with the rest of the capture. 2. Thumbnails just got done. They will be in version 21.4. We tried very hard to implement the native XDR, but it dragged on for months with diminishing returns. So we will come back to ...
by jordansparks
Tue Oct 19, 2021 3:54 pm
Forum: Main Forum
Topic: Does abandoning Patterson imaging mean I have to abandon Open Dental?
Replies: 12
Views: 9323

Re: Does abandoning Patterson imaging mean I have to abandon Open Dental?

As an aside, we do now have popouts and measurements done, so we're whittling down that list. But for the main issue of 12 bit vs 8 bit: 8 bit results in 256 shades of gray, which is surprisingly few. In spite of your monitor being able to display millions of colors, it can only display 256 shades o...
by jordansparks
Mon Oct 18, 2021 6:31 pm
Forum: Main Forum
Topic: Slow response time with loading Mounts
Replies: 11
Views: 8924

Re: Slow response time with loading Mounts

There should be no difference at all between performance of MariaDb and MySQL. I found the problem. There's no key in the document table for MountItemNum. So it loads up the mount blazing fast, but then it takes time for it to find the documents that belong on the mount. Sorry about that. I just pos...
by jordansparks
Fri Oct 15, 2021 5:43 pm
Forum: Main Forum
Topic: Does abandoning Patterson imaging mean I have to abandon Open Dental?
Replies: 12
Views: 9323

Re: Does abandoning Patterson imaging mean I have to abandon Open Dental?

I think we've tried scripting it. This would work by simulating a user clicking on things. I think it breaks after a while for various reasons, so it becomes impractical. The real problem is that they encrypted the files. We can convert from many other kinds of imaging software.
by jordansparks
Fri Oct 15, 2021 7:54 am
Forum: Main Forum
Topic: Information blocking rule
Replies: 3
Views: 4546

Re: Information blocking rule

Good point. I think we will be adding a button that lets you push a CCD to the patient portal upon request. That can be digitally imported by another office. We already generate CCDs, but it's just a matter of making them available at the right time.
by jordansparks
Thu Oct 14, 2021 6:19 pm
Forum: API
Topic: Cancelling appointments
Replies: 10
Views: 11159

Re: Cancelling appointments

https://www.opendental.com/manual/apptbreak.html There are 3 reasons to break an appointment: 1. Missed, no show 2. Less than 24 hrs notice 3. Plenty of notice. The first 2 get procedure codes entered because you generally want to charge the patient. The third one isn't really what I would think of ...
by jordansparks
Thu Oct 14, 2021 6:11 pm
Forum: Main Forum
Topic: Does abandoning Patterson imaging mean I have to abandon Open Dental?
Replies: 12
Views: 9323

Re: Does abandoning Patterson imaging mean I have to abandon Open Dental?

I'm not sure such a thing exists at any price. But since cost doesn't seem to be a major factor, can't you just sit a new employee down for a few months and have them manually move images over with export/import? That would cost about $10k. We've thought about doing something along those lines as a ...
by jordansparks
Thu Oct 14, 2021 4:27 pm
Forum: Main Forum
Topic: Information blocking rule
Replies: 3
Views: 4546

Re: Information blocking rule

Information Blocking isn't something we would work on. It's something we would work to avoid.
by jordansparks
Mon Oct 11, 2021 6:11 pm
Forum: Main Forum
Topic: Slow response time with loading Mounts
Replies: 11
Views: 8924

Re: Slow response time with loading Mounts

Looks like that fix was released on 9/21.
by jordansparks
Mon Oct 11, 2021 6:09 pm
Forum: Main Forum
Topic: Apteryx
Replies: 27
Views: 26264

Re: Apteryx

Start by updating Open Dental to 21.2.
by jordansparks
Mon Oct 11, 2021 6:09 pm
Forum: Main Forum
Topic: Witing list in OD
Replies: 2
Views: 3771

Re: Witing list in OD

It's called the ASAP list.
by jordansparks
Mon Oct 11, 2021 6:07 pm
Forum: API
Topic: Appointment statuses Planned, PtNote and PtNoteCompleted
Replies: 2
Views: 4229

Re: Appointment statuses Planned, PtNote and PtNoteCompleted

Maybe we should not include these by default. We want the API to be easier to use without the vendors needing to learn a bunch of little details. Or we should at least address it in the API documentation.
by jordansparks
Wed Oct 06, 2021 8:30 pm
Forum: Developers
Topic: eServices not launching
Replies: 4
Views: 8203

Re: eServices not launching

What about making a Program Link and using it to send out the PatNum of the current patient? Then, query the database to get the phone number, and use that to send to the twilio API. That's a pretty straightforward bit of code, and far less complex than a custom plugin.
by jordansparks
Sun Oct 03, 2021 9:02 am
Forum: Main Forum
Topic: Where to put scanned forms?
Replies: 2
Views: 4075

Re: Where to put scanned forms?

Yeah, don't try to scan in "decades" of forms all at once. That's overwhelming and I don't think it's feasible. Just scan them a day or two before their appointments.
by jordansparks
Sun Oct 03, 2021 8:56 am
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8681

Re: Multiple clinics as MultiTenant

I suppose that would be a useful improvement, but it would be really complicated. One problem that comes to mind is that this would force all databases to be on the same version. That's a loss of flexibility. It would be harder and more prone to failure to update them all at once instead of one at a...
by jordansparks
Fri Oct 01, 2021 7:01 pm
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8681

Re: Multiple clinics as MultiTenant

I think maybe you are looking for this page:
https://www.opendental.com/manual/multitenant.html