Search found 5693 matches

by jordansparks
Wed Jun 22, 2022 10:33 pm
Forum: Main Forum
Topic: 3D graphics
Replies: 2
Views: 438

Re: 3D graphics

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

3D graphics

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

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

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

Re: Patient Pictures into system quickly

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

Re: Deleting Multiple Existing Procedures

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

Re: Intraoral scanner

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

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

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

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

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

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

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

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

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

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

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

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

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

Intraoral scanner

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

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

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

Ortho brackets

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

Re: Patient notes through API

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

Schedules with google

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

Re: Xray Mount Thumbnails in imaging module

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

Re: Xray Mount Thumbnails in imaging module

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

Re: API Features Requested

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

Re: Sheet - image field max height is 4000

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

Re: Sheet - image field max height is 4000

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

Re: API or short query GET patient profile photo

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

Re: Use WHATSAPP to text your patients from Open Dental

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

Re: Sheet - image field max height is 4000

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

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

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

Re: FHIR with trial version

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

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

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

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

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

Re: mysqladmin flush-hosts

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

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

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

Re: API Issue - Slots

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

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

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

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

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

Re: API Issue - Slots

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

Re: API Keys Tier 2 and Tier 3

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

Re: API Keys Tier 2 and Tier 3

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

Re: API Keys Tier 2 and Tier 3

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

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

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

Re: Tabbing in the Benefit Frequencies Box

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

Re: Crashed table

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

Re: API Request-Blockouts

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

Re: Events

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

Re: Events

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

Re: Crashed table

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

Re: API Features Requested

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

Re: Local API

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

Re: Compile error

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

Re: compile error with 21.4

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

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

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

Local API

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

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

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

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

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

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

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

Re: API Features Requested

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

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

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

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

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

Re: Shifting from a plugin to web services

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

Re: API Features Requested

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

Re: Radiographs and Intraoral Cameras

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

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

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

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

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

Re: Radiographs and Intraoral Cameras

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

Re: Events

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

Re: ShoryQuery Syntax Question

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

Events

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

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

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

Re: Database Integrity

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

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

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

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

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

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

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

Re: Communication, SMS Text messaging API

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

Re: Are there patient GUID's?

Just PatNum. No GUIDs.
by jordansparks
Fri Jan 14, 2022 12:49 pm
Forum: Main Forum
Topic: Scan-X with new integrated x-ray feature
Replies: 46
Views: 11971

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

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

Re: API Request

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

LAN-API

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

Re: Releases stopped being posted and developer emails stopped

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

Re: Database Integrity

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

Re: SMS Texting with Diafaan in Open Dental

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

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

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

Re: Getting The Allowed Column In Treatment Plan

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

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

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

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

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

Re: Radiographs and Intraoral Cameras

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

Re: API Request

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

Re: API Request

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

Re: API Request

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

Re: API change log

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

Re: Patient database missing on a workstation

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

Re: API Features Requested

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

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

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

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: 8
Views: 2846

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: 25
Views: 9510

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

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

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

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

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: 4
Views: 3821

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

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

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

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: 55
Views: 79578

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.