Search found 5739 matches

by jordansparks
Fri Oct 01, 2021 7:01 pm
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8758

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

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

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

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

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

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

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

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

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

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

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

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

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: Main Forum
Topic: Writing data to database
Replies: 1
Views: 11455

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

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

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

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

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

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

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

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: 27
Views: 26547

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

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: 27
Views: 26547

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

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

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

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

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

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

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

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

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: 22
Views: 18074

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

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: 22
Views: 18074

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: 27
Views: 26547

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

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

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

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

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.

And here's a link to the documentation for developers: https://www.opendental.com/site/apispecification.html
by jordansparks
Wed Jun 16, 2021 7:16 pm
Forum: Developers
Topic: About Plug-ins
Replies: 0
Views: 13668

About Plug-ins

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

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

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

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

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

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

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

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

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

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: Developers
Topic: Make FillCharges method public
Replies: 3
Views: 10149

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

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

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

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

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

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

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

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: 12
Views: 12940

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

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

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

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

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

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

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

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

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

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: Developers
Topic: Plugin distribution issue - .NET assembly problem
Replies: 2
Views: 10661

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: 12
Views: 12940

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

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

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: 12
Views: 12940

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: 12
Views: 12940

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: 12
Views: 12940

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: 12
Views: 12940

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: 12
Views: 12940

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: 27
Views: 26547

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

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

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

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

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

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

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

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: 6
Views: 11610

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: 56
Views: 112390

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

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

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

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

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

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

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

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: 56
Views: 112390

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
Fri Mar 12, 2021 11:07 pm
Forum: Main Forum
Topic: Plugin for a new tab in Open dental
Replies: 1
Views: 4460

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
Fri Mar 12, 2021 11:01 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

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 4:36 pm
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 9228

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 7:28 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 9228

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 7:24 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

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 1:38 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

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 7:32 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

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 10:40 pm
Forum: Developers
Topic: New API
Replies: 10
Views: 14283

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 10:38 pm
Forum: Developers
Topic: Extracting data from OpenDental server via API
Replies: 4
Views: 9901

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 8:35 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

Re: Radiographs and Intraoral Cameras

About 2 weeks
by jordansparks
Wed Feb 17, 2021 7:55 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

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 10:48 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

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 10:34 pm
Forum: Developers
Topic: Bug in ProgramEntry.cs
Replies: 6
Views: 10295

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 12:00 pm
Forum: Developers
Topic: Log in using OD password
Replies: 2
Views: 7466

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 11:56 am
Forum: Main Forum
Topic: Fonts are too large/ graphics messed up
Replies: 3
Views: 8357

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.
by jordansparks
Thu Feb 11, 2021 3:45 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

Re: Radiographs and Intraoral Cameras

1. Well, where do they save the image? Go find the image. Copy/paste into Open Dental. There are lots of ways to paste/import. 2. Not yet, sorry. 3. Yes, you can do literally any photo montage layout, with any combination of image sizes, into a mount. 4. We do allow dragging into mounts from windows...
by jordansparks
Thu Feb 11, 2021 3:22 pm
Forum: Developers
Topic: Appointment API requirements and questions
Replies: 5
Views: 9523

Re: Appointment API requirements and questions

Customer does not need to be on support to use the API. The API isn't intended for direct customer use, but is only intended for 3rd party companies that are building integrations. Keeping that in mind, we probably won't have anything for free. We're probably looking at $10/month to cover a variety ...
by jordansparks
Thu Feb 11, 2021 11:15 am
Forum: Developers
Topic: Appointment API requirements and questions
Replies: 5
Views: 9523

Re: Appointment API requirements and questions

I've been thinking really hard about how to charge for this. Flat fee is easier to manage. Low/free is obviously better if we can figure out how. Adding a few appointments would be a very low load on our servers, but I can also see how someone might start hitting us with read requests at a furious p...
by jordansparks
Thu Feb 11, 2021 11:09 am
Forum: Developers
Topic: Appointment API requirements and questions
Replies: 5
Views: 9523

Re: Appointment API requirements and questions

They don't need to be on e-services. I think they might need to be on support, and I think we charge a little bit for use of the API. It just doesn't seem possible to expect a customer to maintain their own web server. This was the only way we could think of to make it a really smooth experience. I ...
by jordansparks
Wed Feb 03, 2021 7:13 pm
Forum: Main Forum
Topic: Plug-ins Forum Topics
Replies: 8
Views: 24536

Re: Plug-ins Forum Topics

Locking this topic.
by jordansparks
Wed Feb 03, 2021 7:11 pm
Forum: Developers
Topic: 404 errors from new api endpoint
Replies: 3
Views: 7271

Re: 404 errors from new api endpoint

Soon. It can't be live until 21.1 is released, because the office must be on 21.1. Also, the coding is actually a bit ahead of the posted documentation at the moment. We'll try to rectify that shortly.
by jordansparks
Wed Feb 03, 2021 7:07 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

Re: Radiographs and Intraoral Cameras

20.5
by jordansparks
Thu Jan 28, 2021 8:36 pm
Forum: Main Forum
Topic: Log In to OD Via RFID
Replies: 1
Views: 3446

Re: Log In to OD Via RFID

Maybe someday. We all have cards, too. It would be handy.
by jordansparks
Wed Jan 27, 2021 2:44 pm
Forum: Developers
Topic: New API
Replies: 10
Views: 14283

Re: New API

Just do the API. It's so much easier. Plugins are for when you want to make a whole new window in the UI that only talks to your own tables in the db and not any of the other tables. We'll eventually need to clamp down on queries from within plugins, so don't waste your time. Look at all the methods...
by jordansparks
Fri Jan 22, 2021 10:45 am
Forum: Developers
Topic: API to update appointment status
Replies: 19
Views: 24540

Re: API to update appointment status

I don't like the logic in the FHIR API for this. It assumes that you have attached a schedule to an operatory, which is not how most users do it. Usually, you attach a schedule to a provider and then a provider to an operatory. So the FHIR API will miss those. The new non-FHIR API will get it right ...
by jordansparks
Fri Jan 22, 2021 8:58 am
Forum: Advanced Topics
Topic: Database corrupted because a conversion failed
Replies: 5
Views: 11460

Re: Database corrupted because a conversion failed

Ah, that makes more sense. Our business model is centered on a recurring monthly fee. Being outside the US, that might not make as much sense for you. You could get on support for long enough to convert and stabilize. I honestly don't know what the minimum number of months is.
by jordansparks
Sun Jan 17, 2021 1:54 pm
Forum: Developers
Topic: Dutch Dental Claims and Bookkeeping plug-in
Replies: 1
Views: 10021

Re: Dutch Dental Claims and Bookkeeping plug-in

No, don't let them make any changes to the db with queries. Our API should be ready soon for that sort of thing.
by jordansparks
Sun Jan 17, 2021 1:50 pm
Forum: Advanced Topics
Topic: Database corrupted because a conversion failed
Replies: 5
Views: 11460

Re: Database corrupted because a conversion failed

I searched through the code and couldn't find a match for that text. With a version that old, we would probably have to help you. Not sure what the problem is. I'm surprised that you are still able to get by with it. Seems like the biggest problem would be submitting claims in the newer formats. The...
by jordansparks
Sun Jan 17, 2021 1:42 pm
Forum: Advanced Topics
Topic: Using artificial intelligence in dentistry
Replies: 10
Views: 22189

Re: Using artificial intelligence in dentistry

I looked at their flow: https://hyggasolutions.com/en/solutions/functional-dental-care/ Seems like their push is to gain efficiency by doing all the cleaning and restorations at the first visit right after the exam. But their flow assumes that this patient doesn't go to the dentist every 6 months. I...
by jordansparks
Sun Jan 17, 2021 12:14 pm
Forum: Advanced Topics
Topic: MariaDB
Replies: 5
Views: 15210

Re: MariaDB

It's complicated. We're currently lukewarm about MariaDB. We were more enthusiastic last year, but then our hopes were tempered a bit. We are continuing to research it. The setbacks we've had have been with very large customers pushing it hard. Some queries are inexplicably slower than MySQL. For th...
by jordansparks
Sun Jan 17, 2021 12:09 pm
Forum: Main Forum
Topic: Win 10 - Windows Snapping while dragging OD not working?
Replies: 1
Views: 3383

Re: Win 10 - Windows Snapping while dragging OD not working?

Yeah, that's gone now. See https://www.opendental.com/manual/zoom.html You'll see on that page that the dragging should work, but just not with the animation. I think there might be a bug that's preventing the dragging from working at the moment, though. We'll probably be able to get the dragging wo...
by jordansparks
Sun Jan 17, 2021 12:06 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

Re: Radiographs and Intraoral Cameras

As I said in another post, we did just add support for DICOM in version 20.5. We load the DICOM file right into OD. The idea is that you could apply windowing (brightness/contrast) to the 12 bit image in real time with a slider. This wouldn't be possible if we used Orthanc to get a PNG from the DICO...
by jordansparks
Sun Jan 17, 2021 12:03 pm
Forum: Main Forum
Topic: Sharing CBCTs
Replies: 5
Views: 6149

Re: Sharing CBCTs

It's not nagging. I'm eager to talk about it. We just added support for native DICOM in version 20.5, so I'm not sure Orthanc would add much.
by jordansparks
Mon Jan 11, 2021 12:50 pm
Forum: Advanced Topics
Topic: Long Page Load Using Remote Database
Replies: 1
Views: 7502

Re: Long Page Load Using Remote Database

You aren't worried about exposing a MySQL database port to the world? That's too scary for me. That's why we have not optimized for that scenario.
by jordansparks
Mon Jan 11, 2021 7:00 am
Forum: Developers
Topic: New API
Replies: 10
Views: 14283

Re: New API

Well, we'll have to do something about plugins eventually. We need to be able to vet them specifically to avoid the scenario you suggest. Plugins are to add UI elements or for supplemental database tables. They shouldn't be used for an end run around the prohibition against write queries. But first ...
by jordansparks
Sun Jan 10, 2021 8:02 pm
Forum: Developers
Topic: New API
Replies: 10
Views: 14283

Re: New API

For now, we are going to host it. I don't quite follow your suggestion about the alternative. The goal is to make it massively powerful. Even though the connections would go through us, we can still keep costs down by hole punching so that you and the customer are connected directly and the message ...
by jordansparks
Sun Jan 10, 2021 6:34 pm
Forum: Developers
Topic: New API
Replies: 10
Views: 14283

New API

The new API is now functional. That doesn't mean it's been released yet, or that it's very good yet, but it is functional. We'll keep FHIR around, but this new one is where we will put all our effort. FHIR was simply too complicated. By starting over from scratch, we can make an API that people can ...
by jordansparks
Fri Jan 08, 2021 11:05 am
Forum: Developers
Topic: finding a pt name with the API
Replies: 5
Views: 8441

Re: finding a pt name with the API

Right. Now that you mention it, we might add a function to our API to allow a query to be passed in, and a table to be returned. That way, queries could be done through the API, solving a lot of these kinds of issues.
by jordansparks
Fri Jan 08, 2021 11:03 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

Re: Radiographs and Intraoral Cameras

What specific version are you using? Tweaks to the scanning were made.
by jordansparks
Fri Jan 08, 2021 8:25 am
Forum: Developers
Topic: finding a pt name with the API
Replies: 5
Views: 8441

Re: finding a pt name with the API

Queries are far more powerful for read-only than the API will ever be. The purpose of the API is to let users make changes to data in the database without running forbidden Update and Insert commands. We will add as many Select functions as we can, but it's never going to be more than the tip of the...
by jordansparks
Fri Jan 08, 2021 8:19 am
Forum: Main Forum
Topic: Zero out a specific procedure code
Replies: 2
Views: 3989

Re: Zero out a specific procedure code

I don't think our conversion department should touch anything like that. There are other options.
by jordansparks
Fri Jan 08, 2021 8:17 am
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

Re: Radiographs and Intraoral Cameras

It takes a moment to load a FMX from the hard drives, but other than that, it doesn't bog anything down. The disadvantages: -Not mature, so there are likely to be a few annoyances. -Might not have certain features that your current imaging software has. Example: measure distance. -TWAIN works, but w...
by jordansparks
Sun Jan 03, 2021 3:14 pm
Forum: Developers
Topic: Strange behavior using FormODBase
Replies: 2
Views: 6233

Re: Strange behavior using FormODBase

Yes, that's a known issue. Blame MS. If you change a font on a listbox, it clears the selected index. Who could've guessed? We need to change the font when we scale, so just handle it. When your selected index change event fires, just test for -1. We do automatically set the selected index back to w...
by jordansparks
Fri Jan 01, 2021 1:19 pm
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9078

Re: Problem printing forms and letters

This is actually a major bug. Hundreds of bugs, really. If your primary monitor is not set to 100%, then MS tries to "help" by scaling the fonts. This was not caught in beta testing because our testing was generally on a 4k secondary monitor. But now that we know about it, lots of progress is being ...
by jordansparks
Thu Dec 31, 2020 10:50 am
Forum: Developers
Topic: Open Dental runs in background even after quit
Replies: 7
Views: 10848

Re: Open Dental runs in background even after quit

When in VS, there are two ways to terminate a program. You can click stop in VS, or you can close OD itself. Clicking stop in VS should work 100% of the time, so I'm guessing your original screenshot was closing OD itself.
by jordansparks
Thu Dec 31, 2020 9:49 am
Forum: Developers
Topic: finding a pt name with the API
Replies: 5
Views: 8441

Re: finding a pt name with the API

We are working every day on the API. Today, we were finally able to track down your issue. Basically, our documentation does not have good enough examples. I hope to be able to upload better documentation for your issue within a day or two. The "name" parameter that you used would only be for a port...
by jordansparks
Tue Dec 29, 2020 1:34 pm
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9078

Re: Problem printing forms and letters

Also, I think this might only be an issue for older versions of Windows. We are still sorting that out. Try to get all your computers to Windows 10, and I think there will be less issues to deal with.
by jordansparks
Sat Dec 26, 2020 3:07 pm
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9078

Re: Problem printing forms and letters

For general font issues (not quite what you describe), we found a new setting that might help in some situations. We will be posting this on the Zoom page with screenshots. On the shortcut that you use to launch OD, right click, properties, Compatability tab, Change high DPI settings, check "Overrid...
by jordansparks
Sun Dec 20, 2020 7:41 pm
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9078

Re: Problem printing forms and letters

Then maybe the laptops are not 100% Microsoft zoom? There's got to be something different between the normal ones and the ones that are printing too small. Compare the MS zooms, not just the OD zooms.
by jordansparks
Sat Dec 19, 2020 11:22 am
Forum: Main Forum
Topic: Payment Plan
Replies: 3
Views: 4445

Re: Payment Plan

Hard to say without looking at it. Procedures are attached to the payment plan?
by jordansparks
Sat Dec 19, 2020 11:04 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9078

Re: Problem printing forms and letters

Do those workstations have a zoom setting?
by jordansparks
Mon Dec 14, 2020 7:18 am
Forum: Advanced Topics
Topic: Table performance_schema has the wrong structure
Replies: 2
Views: 8493

Re: Table performance_schema has the wrong structure

I was going to suggest that you might install mysql 5.6. Still sounds like it might be related to that.
by jordansparks
Fri Dec 11, 2020 3:11 pm
Forum: Main Forum
Topic: Custom Sheet
Replies: 4
Views: 4768

Re: Custom Sheet

I don't understand. Forms are available in the main toolbar. Any sheet of the correct type should show as a form. That's not the Family toolbar, but isn't it basically the same thing?
by jordansparks
Sat Dec 05, 2020 7:12 am
Forum: Main Forum
Topic: Custom Sheet
Replies: 4
Views: 4768

Re: Custom Sheet

I'm very sorry about the backlog. Covid is really throwing a wrench in our operations. Most people are working from home, but that's slower. It's also difficult to train new employees on a 3-way call instead of looking over a shoulder. Then there's the issue of everyone home schooling, so many emplo...
by jordansparks
Fri Dec 04, 2020 7:26 pm
Forum: Main Forum
Topic: Disabling "Change Length for new provider?"
Replies: 3
Views: 4084

Re: Disabling "Change Lenfth for new provider?"

Just fixed the feature request system so that you can see and vote on #8195.
by jordansparks
Tue Dec 01, 2020 12:19 pm
Forum: Main Forum
Topic: Audit trail time doesn't match computer time
Replies: 3
Views: 4281

Re: Audit trail time doesn't match computer time

Most/all audit trail entries are tied to server time so that they cannot be manipulated by someone changing the local computer time. Have you checked your server time?
by jordansparks
Sat Nov 28, 2020 8:47 am
Forum: Developers
Topic: Zoomify plugin Forms
Replies: 3
Views: 6793

Re: Zoomify plugin Forms

90 is too much. Change your monitor scale in Windows first to be more reasonable, then add a little bit more inside of OD if necessary.
by jordansparks
Sat Nov 28, 2020 8:45 am
Forum: Advanced Topics
Topic: Uploading PDFs to patient's file
Replies: 13
Views: 17513

Re: Uploading PDFs to patient's file

That's a trickier problem. I suppose we could add a pref that creates a folder whenever a patient was created.
by jordansparks
Sat Nov 28, 2020 8:38 am
Forum: Main Forum
Topic: How to handle a patient with 3 dental insurance plans?
Replies: 1
Views: 3154

Re: How to handle a patient with 3 dental insurance plans?

I think you can edit the teriary claim to show that info even though it's not automatic.
by jordansparks
Tue Nov 24, 2020 8:31 pm
Forum: Advanced Topics
Topic: Uploading PDFs to patient's file
Replies: 13
Views: 17513

Re: Uploading PDFs to patient's file

It's been posted. Prefix your files with _#_, where # is the DefNum. It will strip off the prefix and then import to the specified category.
by jordansparks
Tue Nov 24, 2020 8:29 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26350

Re: compile 20.3 under VS2019

Thanks for the ideas. We have to do this ourselves, of course.
by jordansparks
Tue Nov 24, 2020 8:26 pm
Forum: Main Forum
Topic: Sharing CBCTs
Replies: 5
Views: 6149

Re: Sharing CBCTs

I'm not sure. Would you send them to the orthodontist as a DICOM file, or would you export it to some other format?
by jordansparks
Tue Nov 24, 2020 8:24 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 112390

Re: Radiographs and Intraoral Cameras

We're going to alpha in 2 weeks. Beta usually follows a couple of weeks after that. But you don't want to use a beta version until it's been out for a few weeks. So you're looking at about the second week of January, and it will be slightly buggy because it's a beta. I think it does make sense to wa...
by jordansparks
Tue Nov 24, 2020 8:15 pm
Forum: Main Forum
Topic: Changing and upgrading forms with background images
Replies: 2
Views: 3189

Re: Changing and upgrading forms with background images

The backgrounds are saved in OpenDentImages(aka AtoZ)/SheetImages folder: https://www.opendental.com/manual/sheetsstaticimage.html Once you use a form with a patient, it's a copy of the original. Making changes should not affect any existing patient forms. It sounds like you might have accidentally ...
by jordansparks
Tue Nov 24, 2020 8:02 pm
Forum: Developers
Topic: Opendental with mysql 8.x -- 1st try
Replies: 5
Views: 11912

Re: Opendental with mysql 8.x -- 1st try

When we do a db backup during update, you might notice that we create all myisam files. Backups are pointless otherwise.
by jordansparks
Tue Nov 24, 2020 8:00 pm
Forum: Developers
Topic: Writing to the db is discouraged, but the API is very barebones, what do I do?
Replies: 15
Views: 20116

Re: Writing to the db is discouraged, but the API is very barebones, what do I do?

I can't quite figure out why you would want to delete someone's email address, but those do seem pretty safe.
by jordansparks
Mon Nov 23, 2020 12:13 pm
Forum: Developers
Topic: Opendental with mysql 8.x -- 1st try
Replies: 5
Views: 11912

Re: Opendental with mysql 8.x -- 1st try

innodb is supported, but ALL tables should be the same, and it must also be the default engine. The downside is that you can no longer make backups by copying files. That's a deal breaker as far as I'm concerned. Making backups is hugely important, and you should not be doing a single thing that wou...
by jordansparks
Mon Nov 23, 2020 12:07 pm
Forum: Main Forum
Topic: Disabling "Change Length for new provider?"
Replies: 3
Views: 4084

Re: Disabling "Change Lenfth for new provider?"

I'm not positive, but I think there might not be an option to turn that off. I just reviewed feature request 8195, which would cover that.
Actually... There's a technical issue that will prevent you from seeing that request. I'll work on that tonight.
by jordansparks
Mon Nov 23, 2020 11:08 am
Forum: Main Forum
Topic: Sharing CBCTs
Replies: 5
Views: 6149

Re: Sharing CBCTs

I'm assuming they are saved as DICOM files that are managed by the CBCT software?
by jordansparks
Sun Nov 22, 2020 3:42 pm
Forum: Developers
Topic: Zoomify plugin Forms
Replies: 3
Views: 6793

Re: Zoomify plugin Forms

1. Inherit your form from FormODBase. 2. Add InitializeLayoutManager(); just below InitializeComponent(); in the constructor. 3. If you did any control movement or resizing in code, use the LayoutManager.Move for those lines. 4. Test by dragging to resize and by also dragging to a different monitor ...
by jordansparks
Sun Nov 22, 2020 8:19 am
Forum: Advanced Topics
Topic: Uploading PDFs to patient's file
Replies: 13
Views: 17513

Re: Uploading PDFs to patient's file

Beta is 20.4. I saw progress on this Friday, but it's not quite done.
by jordansparks
Sun Nov 22, 2020 8:17 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26350

Re: compile 20.3 under VS2019

No schema changes would be best, of course, but the downside is making customers wait months. We have big discussions about backporting any schema changes, and the benefits must heavily outweigh the costs each time. Yes, we've been trying to move to git for years. But we have a massive private repos...
by jordansparks
Fri Nov 20, 2020 8:55 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26350

Re: compile 20.3 under VS2019

I think I know. We add conversion scripts at random times prior to release. Then, we change the version number upon release. I always work in the head, so I never notice this issue. Go to OpenDental, Program, Properties, Assembly Information. Change the version there to match the version of the conv...
by jordansparks
Fri Nov 20, 2020 8:30 am
Forum: Advanced Topics
Topic: Uploading PDFs to patient's file
Replies: 13
Views: 17513

Re: Uploading PDFs to patient's file

I think we might be able to add that today to the head, and maybe backport to beta if it looks extremely safe.