Search found 5600 matches

by jordansparks
Thu Dec 02, 2021 7:42 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 19
Views: 1713

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 7:39 pm
Forum: API
Topic: New APIs Needed
Replies: 2
Views: 110

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
Thu Dec 02, 2021 12:02 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 19
Views: 1713

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 11:32 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 19
Views: 1713

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 10:35 am
Forum: Developers
Topic: The host does not support SSL connections
Replies: 1
Views: 577

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 10:32 am
Forum: Advanced Topics
Topic: CDT Codes on different version
Replies: 1
Views: 661

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 3:07 pm
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 755

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 8:12 am
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 755

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 4:54 pm
Forum: Main Forum
Topic: Global Lock
Replies: 2
Views: 524

Re: Global Lock

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

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 1:25 pm
Forum: Main Forum
Topic: USB Camera (MD740) with Open Dental
Replies: 3
Views: 458

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 7:58 am
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 755

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 6:41 pm
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 755

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 5:55 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 19
Views: 1713

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 8:08 am
Forum: API
Topic: PriProv field is 0 in GET Patients & GET Patients/{patientNumber} API
Replies: 5
Views: 1425

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 7:15 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 19
Views: 1713

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

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

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 9:09 am
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 19
Views: 1713

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

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

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 3:33 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 19
Views: 1713

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 8:25 am
Forum: Main Forum
Topic: color procedure changes
Replies: 7
Views: 839

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 1:43 pm
Forum: API
Topic: API Features Requested
Replies: 6
Views: 4326

Re: API Features Requested

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

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 11:47 am
Forum: API
Topic: Customer API Key
Replies: 5
Views: 1380

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 7:34 pm
Forum: Main Forum
Topic: Imaging Improvements
Replies: 5
Views: 1005

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 2:28 pm
Forum: Main Forum
Topic: Imaging Improvements
Replies: 5
Views: 1005

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 8:19 am
Forum: API
Topic: Database Integrity
Replies: 0
Views: 1751

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 8:14 am
Forum: Plug-ins
Topic: Writing data to database
Replies: 1
Views: 5341

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: 1005

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: 5
Views: 1380

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: 46
Views: 67827

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: 1658

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: 9
Views: 12814

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: 933

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: 1658

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: 5550

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: 1658

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: 1658

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: 1039

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: 1001

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: 1658

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: 1658

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: 1658

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: 24
Views: 11126

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: 24
Views: 11126

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: 24
Views: 11126

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: 24
Views: 11126

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: 2412

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: 3273

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: 2412

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: 1647

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: 5550

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: 2412

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: 1647

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: 3273

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: 24
Views: 11126

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: 1382

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: 1614

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: 2224

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: 1606

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: 2456

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: 2456

Re: Multiple clinics as MultiTenant

I think maybe you are looking for this page:
https://www.opendental.com/manual/multitenant.html
by jordansparks
Fri Oct 01, 2021 6:58 pm
Forum: Developers
Topic: Improving SFTP server transaction speed
Replies: 3
Views: 2212

Re: Improving SFTP server transaction speed

Is the SFTP server at your office or off site? I can't quite tell the configuration from your description. I would test it outside of Open Dental. There are tools that you could use to retrieve a file. Is that speed different than from within Open Dental?
by jordansparks
Wed Sep 29, 2021 6:10 pm
Forum: Main Forum
Topic: Phone number in International format
Replies: 9
Views: 3055

Re: Phone number in International format

Ah, I would call that a bug. Good find. One of our engineers will notice this post and add it to the bug list.
by jordansparks
Wed Sep 29, 2021 6:08 pm
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 2456

Re: Multiple clinics as MultiTenant

I don't quite understand the point. It's not hard to just put a few dozen databases on one machine. If we tried to put multiple customers in one database, that's not very organized. I mean, how would you run a report? It would just be a mess. Why would you even want to do that?
by jordansparks
Wed Sep 29, 2021 5:54 pm
Forum: API
Topic: Patients List by Provider
Replies: 3
Views: 2241

Re: Patients List by Provider

Cadence is very fast at the moment. We just added another engineer to this area. I would like to get the turnaround for most requests down to a day or two, but we're not quite meeting that pace yet.
by jordansparks
Thu Sep 23, 2021 6:49 pm
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 2822

Re: API Guidance

Right, plugins should not change the database either directly or indirectly. Plugins also aren't a good tool for read access because you can instead just use queries.
For Rhinogram, that company would be the one to write the integration, not Open Dental. We provide the API, and they use it.
by jordansparks
Thu Sep 23, 2021 6:44 pm
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 2456

Re: Multiple clinics as MultiTenant

We have considered multi tenant many times. No, Open Dental will never do multi tenant in one database. It's the sort of thing that would need to be built in from day one. We can't add it as an afterthought. The clinic feature was added after Open Dental was already mature, and the intent was to all...
by jordansparks
Thu Sep 23, 2021 6:28 pm
Forum: Main Forum
Topic: Phone number in International format
Replies: 9
Views: 3055

Re: Phone number in International format

I don't know the answer to that question. I'm not involved with texting.
by jordansparks
Tue Sep 21, 2021 7:15 am
Forum: Main Forum
Topic: Phone number in International format
Replies: 9
Views: 3055

Re: Phone number in International format

What you see is always how it is in the database so that you can include prefixes, suffixes, extensions, notes, odd spacing, etc. So the trick is to get the format the way you want it as entering. The autoformat feature does add as you type, but only in certain situations. After you hit the 3rd digi...
by jordansparks
Mon Sep 20, 2021 10:44 pm
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 2822

Re: API Guidance

Update, Insert, etc. Any change like to one of the tables that we will start tracking. Examples might be paysplit, patient, and appointment. Anyone is always free to add their own tables.
by jordansparks
Mon Sep 20, 2021 10:38 pm
Forum: Main Forum
Topic: Arrow keys and calendar
Replies: 1
Views: 1790

Re: Arrow keys and calendar

I just tested it in an older version. The behavior is interesting. The arrows move the dark rectangle around, but that doesn't actually change the date showing in the main area. Then, if you hit enter, it does change the date showing. And this only works if the calendar has focus. Since it doesn't a...
by jordansparks
Mon Sep 20, 2021 7:29 pm
Forum: Main Forum
Topic: Same for Entire Family Button Feature Request Vote
Replies: 4
Views: 2232

Re: Same for Entire Family Button Feature Request Vote

A decision was just made that this section should behave like the other sections and prefill from the currently selected patient. We're calling it a bug.
by jordansparks
Fri Sep 17, 2021 1:20 pm
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 2822

Re: API Guidance

If you make changes to the database directly (not with a plugin), starting in version 21.5, that will trigger warnings to the users which could become quite annoying and insistent over time. As a completely separate issue, plugins that make changes to the database are different. There is no technica...
by jordansparks
Fri Sep 17, 2021 10:25 am
Forum: Plug-ins
Topic: Writing data to database
Replies: 1
Views: 5341

Writing data to database

It has come to my attention that there are some plugins that are extensively writing to the database. This abuse needs to end. It's dangerous and unstable. We've clearly stated on the plugin page from day one that plugins should never write to the existing database tables. The API is the only approv...
by jordansparks
Fri Sep 17, 2021 9:59 am
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 2822

Re: API Guidance

We've had a warning posted for a year and a half that we are about to start blocking plugins and external queries from making changes to the database: https://www.opendental.com/manual/plugins.html The reason we've been holding off is that we obviously have to have the API mature enough to be a viab...
by jordansparks
Thu Sep 16, 2021 3:52 pm
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 6132

Re: DLL interaction with OpenDental to change patient selected

It's not just a matter of turning it on. There's some engineering and testing involved. I'm not sure we have time for that right now. Have you tried sending a claim through the clearinghouse option?
by jordansparks
Thu Sep 16, 2021 3:49 pm
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 2822

Re: API Guidance

I'm really not sure. They might be using a plugin of some sort, but I've never heard of that approach. As we move away from plugins and toward API, I would not expect that approach to be future proof. We will likely add some security to prevent that sort of end run. If they just call random methods ...
by jordansparks
Thu Sep 16, 2021 3:43 pm
Forum: Main Forum
Topic: Pedo office digital charting
Replies: 2
Views: 2008

Re: Pedo office digital charting

I've always been a big fan of paper for things like this. Make a form, fill it in pencil, front desk scans it in later. Shred original.
by jordansparks
Thu Sep 16, 2021 3:33 pm
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 3267

Re: Single Sign On

Got it. Yes, that would be extremely quick for us to add. It will be [UserName].
by jordansparks
Wed Sep 15, 2021 4:10 pm
Forum: Main Forum
Topic: Slow response time with loading Mounts
Replies: 11
Views: 3273

Re: Slow response time with loading Mounts

With 231k rows and no index, that's almost certainly the problem. Fix coming soon.
by jordansparks
Wed Sep 15, 2021 2:13 pm
Forum: Main Forum
Topic: Slow response time with loading Mounts
Replies: 11
Views: 3273

Re: Slow response time with loading Mounts

So it's not a size issue. I think it might be a database issue. There don't seem to be any indices on the mount tables, which wouldn't be noticeable until you had hundreds of mounts. We'll add indices, and then you can let us know if that's better.
by jordansparks
Wed Sep 15, 2021 2:07 pm
Forum: Main Forum
Topic: Apteryx
Replies: 24
Views: 11126

Re: Apteryx

Yes, we can do an Apteryx image conversion. It's not posted on this page for some reason:
https://www.opendental.com/site/conversionimages.html
maybe because it's fairly new. I think it's a fairly decent conversion, but not 100%.
by jordansparks
Wed Sep 15, 2021 7:39 am
Forum: Main Forum
Topic: New user questions
Replies: 1
Views: 1863

Re: New user questions

1. It is designed to allow charting of bleeding in a separate pass. There is a triplets checkbox at the upper right. I think it works for bleeding. Turn that on, and then it should enter everything in triplets, so one click gives you three bleeding points. Or, you can use the keyboard for fast compl...
by jordansparks
Wed Sep 15, 2021 7:31 am
Forum: Main Forum
Topic: Apteryx
Replies: 24
Views: 11126

Re: Apteryx

1. Open Dental reads XDR sensors and ScanX plates, so that's an easy option, eventually.
by jordansparks
Wed Sep 15, 2021 7:28 am
Forum: Main Forum
Topic: Slow response time with loading Mounts
Replies: 11
Views: 3273

Re: Slow response time with loading Mounts

It's instantaneous for me. My mount is an FMX that's 10,700 x 3,900 pixels. What size is your mount?
by jordansparks
Tue Sep 14, 2021 5:54 pm
Forum: Main Forum
Topic: Same for Entire Family Button Feature Request Vote
Replies: 4
Views: 2232

Re: Same for Entire Family Button Feature Request Vote

You're talking about the single checkbox for the "Email and Phone" section? Yeah, that seems a bit off. The reasoning was that each family member would typically have a different phone and email. I would assume you would leave it blank for kids, and then it would use the guarantor info when sending ...
by jordansparks
Mon Sep 13, 2021 6:35 pm
Forum: Developers
Topic: API - Documents question
Replies: 5
Views: 2259

Re: API - Documents question

Yeah, that's a pretty old version.
by jordansparks
Mon Sep 13, 2021 6:33 pm
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 3267

Re: Single Sign On

A number of bridges do use a "user id" of some sort, but it's just a shared id for the whole office. You can make the id show up anywhere in your command line string that you want.
by jordansparks
Mon Sep 13, 2021 6:29 pm
Forum: Main Forum
Topic: Slow response time with loading Mounts
Replies: 11
Views: 3273

Re: Slow response time with loading Mounts

When you click on a mount in the tree at the left in the Imaging Module, right? No images on the mount, huh? I'll start looking specifically for slowness there. By "a while", I'm assuming you mean more than about 2 seconds?
by jordansparks
Thu Sep 09, 2021 8:58 am
Forum: Developers
Topic: Program Link Optional Command Line
Replies: 4
Views: 2143

Re: Program Link Optional Command Line

You can include other characters if you want. For example, you could set up your command line argument in OD as follows:
PatNum=[PatNum]
Or, you can just send the number.
by jordansparks
Wed Sep 08, 2021 11:40 am
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 3267

Re: Single Sign On

That seems like an easy field to add to program link command line arguments. Just remember that this would not be entirely secure, as long as that's not critical. Someone could, in theory, write a program that spoofs OD, sending just the user ID across. Your app would successfully log in with that I...
by jordansparks
Wed Sep 08, 2021 10:32 am
Forum: Developers
Topic: Program Link Optional Command Line
Replies: 4
Views: 2143

Re: Program Link Optional Command Line

My guess is that it is getting sent and that you are not capturing it properly. I'm assuming you are selecting a patient in Open Dental before trying to use your button. If you can't get it, then the next step would be for one of our programmers to write a small C# app proving that it is getting sen...
by jordansparks
Wed Sep 08, 2021 9:39 am
Forum: Developers
Topic: Developer Portal Access
Replies: 21
Views: 5112

Re: Developer Portal Access

We have edited the documentation to clarify that you should not leave a blank <UserLow> tag in the config file, because you would then need to add MySQL permission for the blank user @localhost. Either specify an actual UserLow user, or remove the tag entirely.
by jordansparks
Mon Sep 06, 2021 5:58 pm
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 3267

Re: Single Sign On

I don't think we've built anything like that. I'm not quite sure how to go about it.
by jordansparks
Mon Sep 06, 2021 5:56 pm
Forum: Developers
Topic: Developer Portal Access
Replies: 21
Views: 5112

Re: Developer Portal Access

Like I said in the other thread, I consider this a bug. No change to the MySQL user should be necessary.
by jordansparks
Mon Sep 06, 2021 5:54 pm
Forum: Developers
Topic: ShortQuery
Replies: 5
Views: 3068

Re: ShortQuery

I think it's already fixed, but if not, I would consider it a bug and we will fix it. No changes to MySQL users should be required.
by jordansparks
Tue Aug 31, 2021 11:52 am
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 3267

Re: Single Sign On

Open Dental current supports SSO. We use it every day.
https://www.opendental.com/manual/singlesignon.html
by jordansparks
Fri Aug 20, 2021 10:24 am
Forum: Main Forum
Topic: Much more efficient way of charting
Replies: 17
Views: 17679

Re: Much more efficient way of charting

The reason you can't see it is because the original submitter didn't place any votes on it. That's our way of avoiding clutter. If they don't care enough to vote on it themselves, then it must not be important. So you would just submit your own request and vote for it, then make a post here encourag...
by jordansparks
Wed Aug 18, 2021 10:03 pm
Forum: Developers
Topic: Is it possible to change data in Open Dental without port forwarding?
Replies: 3
Views: 2378

Re: Is it possible to change data in Open Dental without port forwarding?

I see that wording in the screenshot. That doesn't seem quite right, but it shouldn't really apply to you anyway. It's our problem to keep the eConnector functional, and you can just assume that it is.
by jordansparks
Tue Aug 17, 2021 6:22 pm
Forum: Developers
Topic: Is it possible to change data in Open Dental without port forwarding?
Replies: 3
Views: 2378

Re: Is it possible to change data in Open Dental without port forwarding?

Try this flow: - your local app wants to write to db. - your local app sends an outbound message to your server. - your server sends an API call - the API call ends up at our HQ (they all do) - we immediately hand off the message to the eConnector for that office because we maintain live connections...
by jordansparks
Tue Aug 17, 2021 6:10 pm
Forum: Developers
Topic: Updating plugins in Middle Tier
Replies: 3
Views: 2488

Re: Updating plugins in Middle Tier

I don't have any brilliant ideas. It would get lost as a feature request because you would be the only one who cared. I sort of thought that if the middle tier computer was the computer where the update was performed, then that computer would be all squared away right after the update. Then, each wo...
by jordansparks
Tue Aug 17, 2021 6:03 pm
Forum: Main Forum
Topic: Network freeze
Replies: 14
Views: 7042

Re: Network freeze

Long term, the API will alleviate issues like this. We'll be able to get simple reports on who is making queries and what kind of load they are causing.
by jordansparks
Sat Aug 14, 2021 10:57 am
Forum: Main Forum
Topic: Imaging Improvements
Replies: 3
Views: 3696

Re: Imaging Improvements

I added it. I consider that pretty high priority.
by jordansparks
Sat Aug 14, 2021 7:34 am
Forum: Main Forum
Topic: Calendar has changed
Replies: 3
Views: 2343

Re: Calendar has changed

Interesting. Well, we do generally have a rule that we should not lose any features when adding new features because it generates phone calls to support, and therefore costs us money. I was just hoping nobody would care. Your photo organization system is not terrible. Whatever works.
by jordansparks
Thu Aug 12, 2021 8:36 pm
Forum: API
Topic: New API functions?
Replies: 1
Views: 2741

Re: New API functions?

Yes, this is the place to request features. Reading can always be done with Queries POST and Queries PUT ShortQuery. Most of our methods are geared toward changing data.
by jordansparks
Thu Aug 12, 2021 8:31 pm
Forum: Main Forum
Topic: Imaging Improvements
Replies: 3
Views: 3696

Re: Imaging Improvements

I will try to add that request to the page. The page is a bit outdated already. We do this sometimes for very hot topics, but not very often. I'll keep it in mind for the future. This might be a good way to organize some of the feature requests.
by jordansparks
Thu Aug 12, 2021 8:28 pm
Forum: Main Forum
Topic: Calendar has changed
Replies: 3
Views: 2343

Re: Calendar has changed

I made the new calendar because the Microsoft one had some serious flaws: 1. I couldn't easily tell the difference between the selected date and today. Now they look different. 2. When you changed months, it inexplicably changed the selected date. I considered this flaw to be fatal. 3. Scaling with ...
by jordansparks
Mon Aug 09, 2021 6:11 pm
Forum: Developers
Topic: Long Middle Tier load time for a listBox
Replies: 2
Views: 2767

Re: Long Middle Tier load time for a listBox

You wouldn't normally call RefreshCache. That's only used if you changed the cache, maybe by adding a new item. The whole point of a cache is to be able to not go back to the database each time. We use lazy loading of cache tables. Each table starts out null. If you ever need a table and it's null, ...
by jordansparks
Thu Jul 29, 2021 7:33 pm
Forum: Main Forum
Topic: Imaging Improvements
Replies: 3
Views: 3696

Imaging Improvements

Here's a page that describes improvements being made to the Imaging module: https://www.opendental.com/manual212/imagingimprovements.html The first item on that list is: Open multiple images at once. Drag to other screen if desired. This is essentially done. The next two are high priority. I just wa...
by jordansparks
Thu Jul 29, 2021 7:19 pm
Forum: Advanced Topics
Topic: Combining all these queries together (from Report) into One
Replies: 4
Views: 3244

Re: Combining all these queries together (from Report) into One

Put the word "union" between all the queries to chain them together. I'm assuming they all return the same column names. If that doesn't work, then also surround each of the queries with parentheses. At the end of it all, you then do an order by on all the unioned result list.
by jordansparks
Thu Jul 29, 2021 7:15 pm
Forum: Developers
Topic: ShortQuery
Replies: 5
Views: 3068

Re: ShortQuery

Hmm. This doesn't seem right. Didn't we change that to use the normal MySQL user? I'm on vacation for a week, but I didn't want to forget to circle back around to this. In other words, the ShortQuery should work out of the box without any additional setup.
by jordansparks
Wed Jul 14, 2021 7:47 am
Forum: Main Forum
Topic: Should I change to Open Dental?
Replies: 4
Views: 3630

Re: Should I change to Open Dental?

We are doing as many image conversions as we can, so there would be no need for an outside programmer. I don't know about trivial. Even if the fundamental algorithm is understood, writing the tools can take quite a long time.
by jordansparks
Wed Jul 07, 2021 7:26 pm
Forum: Main Forum
Topic: Schick camera problem
Replies: 5
Views: 3645

Re: Schick camera problem

I'm very happy to hear that.
by jordansparks
Wed Jun 30, 2021 9:11 am
Forum: Main Forum
Topic: Schick camera problem
Replies: 5
Views: 3645

Re: Schick camera problem

I'm not sure if updating to 21.1 would help, but it seems like a good start. I wasn't aware that any Twain driver was needed for any IO camera. We're basically using a webcam library which has nothing to do with Twain. What you're describing sounds like a memory leak, which makes me suspect a bug in...
by jordansparks
Tue Jun 29, 2021 12:27 pm
Forum: Developers
Topic: Cannot access API forum
Replies: 3
Views: 4246

Re: Cannot access API forum

Well, that explains why nobody was reading the API forum.
by jordansparks
Tue Jun 29, 2021 12:23 pm
Forum: Main Forum
Topic: Set appointment default color
Replies: 3
Views: 2742

Re: Set appointment default color

I'm guessing that the colors you chose are too dark and have too much color. Change your colors to be very light and pastel, all washed out. You need to do this to keep the black text readable.
by jordansparks
Tue Jun 29, 2021 12:20 pm
Forum: Main Forum
Topic: Schick camera problem
Replies: 5
Views: 3645

Schick camera problem

This was originally posted by mking in another thread and I moved it here: Jordan, we recently moved from Eaglesoft to OD. We use schick IO Cameras and most of the time they work great with OD. More recently, when we go to capture either on the sensor or using the mouse, Open Dental will kick us out...
by jordansparks
Mon Jun 28, 2021 3:14 pm
Forum: API
Topic: Appointment slots
Replies: 0
Views: 8351

Appointment slots

I got this request in another forum. I'm answering it here: Can we connect your technical team to know about getting the free slots in one API call? Thanks and regards, Poonam See our documentation: https://www.opendental.com/resources/OpenDentalAPI.pdf You can choose between these two methods: Appo...
by jordansparks
Mon Jun 28, 2021 3:13 pm
Forum: Developers
Topic: API to update appointment status
Replies: 19
Views: 15689

Re: API to update appointment status

I will answer this over in the API forum.
by jordansparks
Mon Jun 28, 2021 3:03 pm
Forum: Main Forum
Topic: Set appointment default color
Replies: 3
Views: 2742

Re: Set appointment default color

Maybe set all your providers to white? I don't think the colors are used for anything except appointments.
by jordansparks
Mon Jun 28, 2021 7:04 am
Forum: Main Forum
Topic: Apteryx
Replies: 24
Views: 11126

Re: Apteryx

They are officially sunsetting their on-premises software:
https://www.planetdds.com/newsroom/suns ... version-4/
This means that the "perpetual" license you thought you bought actually has an end date. There are a LOT of users affected by this decision.
by jordansparks
Thu Jun 17, 2021 6:39 am
Forum: API
Topic: Push Notifications
Replies: 1
Views: 4032

Re: Push Notifications

After sleeping on it, my idea for push notifications seems like too much of a burden for many. I suppose we could do the same thing through a polling strategy, first. Same sorts of events, but you would send a request to our API every few minutes to get your latest events. Push notifications could b...
by jordansparks
Wed Jun 16, 2021 8:33 pm
Forum: API
Topic: Why the API is so critical
Replies: 0
Views: 7376

Why the API is so critical

If we have some customers who move to cloud hosting, then their databases will not be locally accessible to 3rd party tools. No more queries. We do have bridges (program links) working in that scenario, but I feel like plug-ins can't work because no third party will have access to the server to inst...
by jordansparks
Wed Jun 16, 2021 8:21 pm
Forum: API
Topic: Push Notifications
Replies: 1
Views: 4032

Push Notifications

The current API doesn't do push notifications. If you currently want to know about new or changed appointments, you would instead use Appointments GET (multiple), passing a DateTStamp of 5 minutes ago to get any appointments changed or added in the last five minutes. You could also instead use Signa...
by jordansparks
Wed Jun 16, 2021 8:03 pm
Forum: API
Topic: Welcome
Replies: 0
Views: 7456

Welcome

The API is the recommended way of interacting with a customer database. We will continue to add new methods as developers request them here. Here's a link to the manual for what the customer sees: https://opendental.com/manual/fhir.html And here's a link to the documentation for developers: https://...
by jordansparks
Wed Jun 16, 2021 7:16 pm
Forum: Plug-ins
Topic: About Plug-ins
Replies: 0
Views: 8680

About Plug-ins

Most developers should avoid plug-ins and instead use the API.
by jordansparks
Wed Jun 16, 2021 7:15 pm
Forum: Plug-ins
Topic: Plug-ins Forum Topics
Replies: 8
Views: 16694

Re: Plug-ins Forum Topics

Making this topic not sticky so that I can have a simpler sticky topic.
by jordansparks
Mon Jun 14, 2021 11:17 pm
Forum: Advanced Topics
Topic: DB DEFAULT VALUES
Replies: 6
Views: 5119

Re: DB DEFAULT VALUES

Adding custom tables will always be totally fine. Just name them with a prefix that we would never accidentally use. I would throw in an underscore for good luck.
by jordansparks
Mon Jun 14, 2021 12:54 pm
Forum: Advanced Topics
Topic: DB DEFAULT VALUES
Replies: 6
Views: 5119

Re: DB DEFAULT VALUES

Our goal is to make the API so easy and so loaded with features that nobody will ever want to bother again with plugins. But I also don't see us removing plugins in the short term. We are very rapidly adding API methods. We will add any methods that you need. I'll add 835 imports to our todo list, b...
by jordansparks
Mon Jun 14, 2021 9:57 am
Forum: Advanced Topics
Topic: DB DEFAULT VALUES
Replies: 6
Views: 5119

Re: DB DEFAULT VALUES

We have a CRUD layer that we generated that automatically handles all columns for every INSERT and UPDATE, so we don't have to worry about it. But nobody has to worry about it for SELECT queries in any case. That makes me suspect that you are considering doing INSERTS and/or UPDATES. That's not allo...
by jordansparks
Fri Jun 11, 2021 8:07 pm
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 6132

Re: DLL interaction with OpenDental to change patient selected

https://www.opendental.com/manual/programlinkoutputfile.html As you can see, all of the outgoing fields have to do with the current patient. There is nothing for the currently selected claim. But you could set up a Clearinghouse https://www.opendental.com/manual/clearinghouses.html which exports dat...
by jordansparks
Fri Jun 11, 2021 7:55 pm
Forum: Main Forum
Topic: New server - solid state drive or regular disk drive?
Replies: 5
Views: 5019

Re: New server - solid state drive or regular disk drive?

An SSD on the server will make Open Dental run noticeably faster because it won't have to wait as long for data coming from the database.
by jordansparks
Fri Jun 11, 2021 7:53 pm
Forum: Main Forum
Topic: Boldl Text During Typing After Update
Replies: 2
Views: 2983

Re: Boldl Text During Typing After Update

I've been seeing text turn bold ever since we added the zoom feature. I think it might be because of the spell check that tries to draw the squiggly red line. It might also redraw the text, and if it isn't lined up just right, it would look bold. I consider it an annoyance that we will get to soon. ...
by jordansparks
Fri Jun 04, 2021 12:06 pm
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 6132

Re: DLL interaction with OpenDental to change patient selected

A long time ago, we got that feature working by using command line arguments. If there was already a copy of Open Dental running, then it would affect that copy instead of launching a new copy. I think the reason we turned that off was that people were more interested in using command line arguments...
by jordansparks
Thu May 27, 2021 6:59 pm
Forum: Main Forum
Topic: Allocations
Replies: 3
Views: 4154

Re: Allocations

Today, the area for setting the preferences related to allocations got a huge overhaul and its own new window. All staff will be able to see this window and learn from it without going to the manual. We also plan to add functionality in a few places to "fix" old account entries by applying FIFO with...
by jordansparks
Wed May 26, 2021 10:43 pm
Forum: Plug-ins
Topic: Make FillCharges method public
Replies: 3
Views: 4680

Re: Make FillCharges method public

Wow, you're really getting deep into it. Our policy in cases like this is usually to just leave it alone and you can use reflection to do it, just like you are.
by jordansparks
Wed May 26, 2021 7:35 pm
Forum: Main Forum
Topic: Allocations
Replies: 3
Views: 4154

Re: Allocations

This topic just got 41 responses in FaceBook. The problem is that it's nearly impossible to find the responses after a few months. For future reference, here is that conversation: https://www.facebook.com/groups/opendentalusersgroup/permalink/1752985381575330/ I've also edited the feature request to...
by jordansparks
Tue May 25, 2021 7:52 pm
Forum: Main Forum
Topic: Allocations
Replies: 3
Views: 4154

Re: Allocations

It's now feature request 13821.
by jordansparks
Tue May 25, 2021 7:14 pm
Forum: Main Forum
Topic: Allocations
Replies: 3
Views: 4154

Allocations

For those who are frustrated by allocations, would it help to have no allocations? Open Dental didn't used to attach payments to anything. I've been toying with having a mode where it behaved like that again. I'm not sure you would want to turn it off and on sporadically. If you work with this optio...
by jordansparks
Tue May 25, 2021 8:56 am
Forum: Main Forum
Topic: Lab slip Due date and time question
Replies: 2
Views: 3334

Re: Lab slip Due date and time question

I just added feature request 13815 and cleaned up the related requests
by jordansparks
Mon May 24, 2021 3:38 pm
Forum: Main Forum
Topic: Space Maintainer Graphic
Replies: 2
Views: 3121

Re: Space Maintainer Graphic

It's designed to not ever draw in the same space where a tooth already exists. As soon as you fill that space with a permanent tooth by any means, it should disappear. Or, you could edit the procedure and check the box for Hide Graphics. What tooth number is the space maintainer assigned to? I'm esp...
by jordansparks
Mon May 24, 2021 3:34 pm
Forum: Main Forum
Topic: White theme
Replies: 2
Views: 3683

Re: White theme

It's just a move from gray240 to 255. The difference isn't as striking as I was hoping. White isn't really as white as I thought. It's not like it could possibly cause bugs or anything.
by jordansparks
Sun May 23, 2021 6:41 pm
Forum: Main Forum
Topic: White theme
Replies: 2
Views: 3683

White theme

For years, everyone has complained that Open Dental looks outdated. The main reason for this complaint is the gray background that is used throughout. I finally broke down and decided that white would be a better background color. This has a domino effect, of course, so there are lots of other thing...
by jordansparks
Sat May 22, 2021 12:24 pm
Forum: Main Forum
Topic: Radiograph ntdll crash
Replies: 11
Views: 7784

Re: Radiograph ntdll crash

Whew! Yes, it applies to all future versions.
by jordansparks
Fri May 21, 2021 8:23 am
Forum: Developers
Topic: form is not reversed from right to left
Replies: 14
Views: 9390

Re: form is not reversed from right to left

You might not want to do too much work on the mirroring until I've had a chance to see what your strategy is. If you send us a whole bunch of changes, it's unlikely that we'll be able to incorporate them. In other words, I don't want you to do a lot of work all for nothing. It would be better if you...
by jordansparks
Thu May 20, 2021 7:52 am
Forum: Developers
Topic: form is not reversed from right to left
Replies: 14
Views: 9390

Re: form is not reversed from right to left

Interesting. Yes, we can place an Arabic file on our server for anyone to import. You could also supply the file to your customers.
by jordansparks
Thu May 20, 2021 7:01 am
Forum: Developers
Topic: form is not reversed from right to left
Replies: 14
Views: 9390

Re: form is not reversed from right to left

Nice job! How did you mirror things? From the screenshot, it sort of looks like you edited the code to turn off our LayoutManager for that one form. That would be a lot of work to do it for all forms, especially since you would have to reapply the changes with each version. Without knowing exactly w...
by jordansparks
Wed May 19, 2021 8:01 pm
Forum: Developers
Topic: form is not reversed from right to left
Replies: 14
Views: 9390

Re: form is not reversed from right to left

You can go back to an old version if you use an old database. I didn't realize it was that big of a deal. So you've really been using it as a complete mirror image of how it shows in our manual? But it doesn't look like you've translated anything, so why would that be useful? Is it mostly that you l...
by jordansparks
Wed May 19, 2021 3:15 pm
Forum: Developers
Topic: form is not reversed from right to left
Replies: 14
Views: 9390

Re: form is not reversed from right to left

Fix is posted, but not quite released. As I suspected, the fix was to layout from left to right. So it all looks good now. But it can't lay out from right to left like it did in older versions.
by jordansparks
Wed May 19, 2021 6:41 am
Forum: Developers
Topic: form is not reversed from right to left
Replies: 14
Views: 9390

Re: form is not reversed from right to left

It looks like the solution is going to be to force everything to layout left to right. Fixing the right to left layout looks far more complex. I'll know more later today.
by jordansparks
Tue May 18, 2021 4:58 pm
Forum: Developers
Topic: form is not reversed from right to left
Replies: 14
Views: 9390

Re: form is not reversed from right to left

Uh oh. I don't think I considered that. I'll try to duplicate it. If I can't, I might ask for a screenshot.
by jordansparks
Sat May 15, 2021 6:21 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 10469

Re: Realtime Transfer of Updated and Deleted data to Cloud

There are almost no restrictions. Just about the only problem I can think of is if you run a CREATE TABLE command for the same table on both servers. This can happen if a report needs to create a temporary table to store some data and then that table gets deleted at the end of the report. The soluti...
by jordansparks
Fri May 14, 2021 8:06 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 10469

Re: Realtime Transfer of Updated and Deleted data to Cloud

Yeah, it just sounds like replication. It's possible.
by jordansparks
Thu May 13, 2021 7:11 am
Forum: Plug-ins
Topic: Plugin distribution issue - .NET assembly problem
Replies: 2
Views: 5773

Re: Plugin distribution issue - .NET assembly problem

I think that message, in general, has to do with a flag that MS adds to files. This includes pdf, doc, txt, exe, jpg, dll -- whatever. The flag gets added whenever you download any file from the internet, but it's only a problem when the files can have scripting, like doc, exe, and dll. To remove th...
by jordansparks
Tue May 11, 2021 4:50 pm
Forum: Main Forum
Topic: Radiograph ntdll crash
Replies: 11
Views: 7784

Re: Radiograph ntdll crash

Fix is posted
by jordansparks
Tue May 11, 2021 4:48 pm
Forum: Main Forum
Topic: Network freeze
Replies: 14
Views: 7042

Re: Network freeze

No, setting up a second server for reports won't help if you don't even have control over who is running reports.
by jordansparks
Mon May 10, 2021 10:54 pm
Forum: Main Forum
Topic: Network freeze
Replies: 14
Views: 7042

Re: Network freeze

Change your mysql password and turn off plugins. This should entirely block any third party. Also, it should be possible to tell which workstation is running the command (I think).
by jordansparks
Mon May 10, 2021 10:52 pm
Forum: Main Forum
Topic: Radiograph ntdll crash
Replies: 11
Views: 7784

Re: Radiograph ntdll crash

For nearly all bugs, the best was is to call us and let the techs escalate it up through the engineers. But intermittent bugs that do not have any obvious cause or any error message will typically take longer to address that way. I only jumped on your bug report because I suspected a memory leak in ...
by jordansparks
Mon May 10, 2021 6:55 am
Forum: Main Forum
Topic: Radiograph ntdll crash
Replies: 11
Views: 7784

Re: Radiograph ntdll crash

Pretty sure we found the memory leak. Just a matter of testing and releasing.
by jordansparks
Thu May 06, 2021 2:02 pm
Forum: Main Forum
Topic: Radiograph ntdll crash
Replies: 11
Views: 7784

Re: Radiograph ntdll crash

Great report. Thanks! Oh my gosh! You did a lot of troubleshooting. Based on the log, it seems to be an Open Dental issue, not any particular driver or sensor issue. That's good. That means we did not find a brand of sensor that won't work with Open Dental. It seems like there's probably just some l...
by jordansparks
Thu May 06, 2021 1:19 pm
Forum: Main Forum
Topic: Radiograph ntdll crash
Replies: 11
Views: 7784

Re: Radiograph ntdll crash

What sensor are you using when this happens? Is it always the same kind of sensor or is it multiple kinds? This error indicates a memory leak, but we don't know yet if it's in Open Dental or in a sensor driver. If nothing is coming up on the screen to indicate the error, then we will need the error ...
by jordansparks
Thu May 06, 2021 1:17 pm
Forum: Main Forum
Topic: Radiograph ntdll crash
Replies: 11
Views: 7784

Radiograph ntdll crash

This was originally posted by jmazzie: Just wanted to update the ntdll crashes are becoming more consistent in our office 1 in 10 patients which adds up since we usually have about 300-400 patients take xrays a day. What is the best way to work with OpenDental to help solve this issue? I hate to con...
by jordansparks
Thu May 06, 2021 10:10 am
Forum: Main Forum
Topic: Apteryx
Replies: 24
Views: 11126

Apteryx

I just tried to go to the Apteryx website. For those who don't know, that was a well-known independent imaging software that had been around for a long time. I knew they had been bought by PlanetDDS/Denticon for something like $22M last year, but I didn't realize that Denticon planned to close off A...
by jordansparks
Thu May 06, 2021 8:40 am
Forum: Advanced Topics
Topic: EmailAttachments Folder in OpenDentImages
Replies: 1
Views: 5192

Re: EmailAttachments Folder in OpenDentImages

You could test it. Just send an email that includes an image. The image will pop up in one of those folders. Delete the image and see if Open Dental crashes when you look at the email or if it just shows a spot where the missing image should be. I'm hoping the latter, of course. And if that's true, ...
by jordansparks
Thu Apr 29, 2021 2:05 pm
Forum: Advanced Topics
Topic: Suggested Reports - Feature Idea
Replies: 2
Views: 5341

Re: Suggested Reports - Feature Idea

You ran them all? Wow.
by jordansparks
Thu Apr 29, 2021 8:04 am
Forum: Developers
Topic: Retrieving documents/images for patients
Replies: 4
Views: 6810

Re: Retrieving documents/images for patients

Depends on how you're using it. There are lots of different approaches, and we honestly haven't settled on a good one. The main tree is what they are used to, so we tried that, but it's complex. We've tried lists, thumbnails, pasting from clipboard, etc. Sounds like our API will need to optionally i...
by jordansparks
Tue Apr 27, 2021 10:50 pm
Forum: Developers
Topic: Retrieving documents/images for patients
Replies: 4
Views: 6810

Re: Retrieving documents/images for patients

We're working on it. First, we are tackling queries. Then, we can do images. When you submit a request for an image to the API, it will place the image in an FTP folder that you specify. That way, the image won't have to pass through our servers and bog things down.
by jordansparks
Thu Apr 22, 2021 6:24 pm
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 10469

Re: Realtime Transfer of Updated and Deleted data to Cloud

No, that's not true for most other tables. I think it's probably true for definition and provider.
by jordansparks
Wed Apr 21, 2021 4:42 pm
Forum: Developers
Topic: Call back API
Replies: 3
Views: 5764

Re: Call back API

Databases, by nature, are pull instead of push. That's why we use the signalod table to keep track of tables that have changed and need a new pull. The FHIR interface attempted some sort of push, but the new API will just be pull. There are a few other push paradigms that I can think of: -replicatio...
by jordansparks
Wed Apr 21, 2021 4:38 pm
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 10469

Re: Realtime Transfer of Updated and Deleted data to Cloud

It's fine to have your own database on the same server as OD. Each table is different. Rows never get deleted from the patient table, so you don't have to think about that. There's also a table called deletedobject that will get a new row inserted if an appointment is deleted.
by jordansparks
Wed Apr 21, 2021 4:33 pm
Forum: Developers
Topic: The remote server returned an error: (500) Internal Server Error
Replies: 2
Views: 5332

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

That's not a very helpful message. We'll try to improve that. Open Dental must be version 21.1. I suspect that's the main problem.
by jordansparks
Thu Apr 15, 2021 11:58 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

Any graphics card will work. Single images do not overload a graphics card. When I started my practice in '99, the retiring dentist had lots of charts full of radiographs. I put them all the back room and started over. We had to go the the back room to look at older radiographs sometimes, but it was...
by jordansparks
Tue Apr 13, 2021 7:40 pm
Forum: Developers
Topic: Call back API
Replies: 3
Views: 5764

Re: Call back API

I'm sorry, I don't understand. "register with the dental office servers"? You must be talking about some program running on the server. It sounds like you might be asking for specific program suggestions. I can't really think of any. It's totally possible, but I just don't know what program to sugge...
by jordansparks
Tue Apr 13, 2021 1:23 pm
Forum: Developers
Topic: OpenDental on .Net Core
Replies: 3
Views: 5627

Re: OpenDental on .Net Core

One bad thing about WinForms is that each control -- each textbox, label, button, etc -- is a Win32 "Window". Think about that. One form in Open Dental can contain hundreds of Win32 child windows. That's nice sometimes, like if I want to use a completely different technology inside one control. But ...
by jordansparks
Tue Apr 13, 2021 10:31 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 10469

Re: Realtime Transfer of Updated and Deleted data to Cloud

Oh, well that's a lot easier. You would probably install a small program on the MySQL server. It would carefully query the database at certain intervals and pass the information up to your cloud. There are lots of programs that can do this out of the box, or you could write one.
by jordansparks
Tue Apr 13, 2021 10:14 am
Forum: Developers
Topic: OpenDental on .Net Core
Replies: 3
Views: 5627

Re: OpenDental on .Net Core

We already use C# 8.0, which comes with .NET 4.7.2. We already use tuples and nullables. WinForms is a wrapper around C++ Win32, which came out in about 1995. Since then, there have been many new frameworks, but never a replacement for Win32. None of the newer frameworks have enough power. Yes, Win3...
by jordansparks
Mon Apr 12, 2021 3:25 pm
Forum: Developers
Topic: Bad Database Design Spotlight
Replies: 8
Views: 12057

Re: Bad Database Design Spotlight

MySQL could be 64 bit, while OpenDental could be 32 bit.
by jordansparks
Mon Apr 12, 2021 3:16 pm
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 10469

Re: Realtime Transfer of Updated and Deleted data to Cloud

"for the cloud to update the corresponding tables?" That means you are talking about two way transfer. The only way to do that is to use our API.
https://www.opendental.com/manual/fhir.html
by jordansparks
Wed Mar 17, 2021 8:03 pm
Forum: Main Forum
Topic: Separate patients from insurance plans they are no longer attached to
Replies: 12
Views: 7369

Re: Separate patients from insurance plans they are no longer attached to

I think there might be an ironic bug in the feature request system. Trying to get to it.
by jordansparks
Sun Mar 14, 2021 3:48 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

As with any scanner, installing a TWAIN driver would be done on individual workstations and would not have anything to do with the server.
by jordansparks
Sat Mar 13, 2021 12:07 am
Forum: Main Forum
Topic: Plugin for a new tab in Open dental
Replies: 1
Views: 3216

Re: Plugin for a new tab in Open dental

You can currently use a Program Link button in any top toolbar. You can also pass parameters to the other program. You could probably write a very short program that took the parameters and showed a web page. This wouldn't be IN Open Dental, but it would be really fast to build. Try to stay away fro...
by jordansparks
Sat Mar 13, 2021 12:01 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

Oh rats. I think I totally forgot about showing mounts over in the Chart module.
by jordansparks
Wed Mar 10, 2021 5:36 pm
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 5734

Re: Multiple Instances of OpenDental running on server

Finally fixed it. That was a tough one. The fix will be in the next releases of 20.4, 20.5, etc., within a day or two.
by jordansparks
Wed Mar 10, 2021 8:28 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 5734

Re: Multiple Instances of OpenDental running on server

You mean that when you try to close Open Dental, it still shows a background thread running in the Task Manager? This is hard to duplicate, and our attempted fix seems to have failed. We have a brand new fix that we will be testing this morning. I'm cautiously optimistic.
by jordansparks
Wed Mar 10, 2021 8:24 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

If Hamamatsu provides a TWAIN driver, then it will work. They almost certainly do. A slightly better option would be if we could implement a native driver. I've been pestering Hamamatsu for months, to no avail. I will wear them down eventually.
by jordansparks
Tue Mar 02, 2021 2:38 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

Haven't tested with ScanX, but we did add features intended to support it. See manual version 20.5
https://www.opendental.com/manual205/images.html
The Import Automatically feature will pull images into Open Dental as they are scanned in ScanX.
by jordansparks
Thu Feb 25, 2021 8:32 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

Really good question. No. Our DICOM viewer can currently be described as lightweight. It was built to handle single XDR images, which was the only file format example that we had. It can likely handle other similar single DICOM images as well, but it won't know what to do with multi-frame. What soft...
by jordansparks
Tue Feb 23, 2021 11:40 pm
Forum: Developers
Topic: New API
Replies: 10
Views: 9471

Re: New API

Same token, but it will be a new URL. That detail is explained in the link above. Click on the PDF link on that page.
by jordansparks
Tue Feb 23, 2021 11:38 pm
Forum: Developers
Topic: Extracting data from OpenDental server via API
Replies: 4
Views: 6969

Re: Extracting data from OpenDental server via API

The new API doesn't really seem to have a method yet for insurance benefits. Once we add query capability to the API, then you could use that to query for what you need. It's sort of hard for me to imagine why anyone would normally want this info. I assume you are talking about 100-80-50 percentages...
by jordansparks
Tue Feb 23, 2021 9:35 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

About 2 weeks
by jordansparks
Wed Feb 17, 2021 8:55 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

I'm not sure what you mean by automatically. You would take your screenshot with alt-PrtScn, or with Snip-n-sketch, or by any other means. You would then paste into a category in the Imaging module. Your resolution won't be as good with a screenshot, but it might be good enough for what you need. Yo...
by jordansparks
Tue Feb 16, 2021 11:48 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 46
Views: 67827

Re: Radiographs and Intraoral Cameras

Open Dental saves acquired Twain radiographs as TIF. I'm not sure what you mean by "adding image templates". You can edit or add mounts at any time. But you cannot change existing mount layouts yet, if that's what you are asking. For example, if you have a 4BW mount, you can't add a 5th image to it....
by jordansparks
Tue Feb 16, 2021 11:34 pm
Forum: Developers
Topic: Bug in ProgramEntry.cs
Replies: 6
Views: 7265

Re: Bug in ProgramEntry.cs

Right. That entire method is gone as of 20.2. I could backport a 3 line fix, but I'm afraid to, because I have no way to test the necessary scenarios. I didn't write that section, so I don't understand it deeply enough. I don't want to destabilize it.
by jordansparks
Mon Feb 15, 2021 1:00 pm
Forum: Developers
Topic: Log in using OD password
Replies: 2
Views: 5371

Re: Log in using OD password

That's one that we had to obfuscate. So that code isn't available. I just looked at the code. It seems to be based on KeccakNISTInterface.c from http://keccak.noekeon.org/
by jordansparks
Mon Feb 15, 2021 12:56 pm
Forum: Main Forum
Topic: Fonts are too large/ graphics messed up
Replies: 1
Views: 2856

Re: Fonts are too large/ graphics messed up

Windows has a setting in there somewhere to fix it. Look on our Zoom page in the manual. The suggested fixes are not yet specific to remote or virtual machines.