Open Dental Forum

3shape provided the exe in my latest update. bridge works basically. 2 issue: patient ID is not added in 3shape. not sure if this is open dental or 3shape issue. 3shape removes any space in names, this causes no match found and duplicate entries There was a bug fix in Open Dental v23.2.73, v23.3.74...

... I am missing the path on our workstation: C:\Program Files\3Shape\Dental Desktop\Plugins\ThreeShape.PMSIntegration\DentalDesktopCmd.exe I do have the folder: C:\Program Files\3Shape\Dental Desktop\Plugins\ with other plugins, but missing "ThreeShape.PMSIntegration.." There was a bug fix back in...

I'll never forget when we solved a slowness issue here at HQ that plagued us for a really long time. It ended up being a bad cable. To our dismay, it wasn't simple like the cable that is easy to access from the back of the computer. Hopefully it's just a bad cable for you between your NIC / MOBO and...

Kind of sounds like you are a Middle Tier user; We fixed a similar sounding issue in v24.2.45 and v24.3.11

Middle Tier - upgrade from old version can cause crash

https://opendentalsoft.com:1943/ODBugTr ... sions.aspx

Would you be so kind as to answer Kristian3S questions then? That way users don't have to do what you did by writing a new bridge as a plug-in.

Kristian3S wrote: ↑
Fri Jul 26, 2024 2:40 am
What version of 3Shape software do you have and what version of Open Dental?

No. You'll be interested in voting on Feature Request #14215 or creating a new one explicitly for importing pharmacy information from sheets.

Manually updating them would probably yield the fastest results. Voting for Feature Request #8835 is my technical response.

How are you providing this information Medicaid in the first place? What makes you want to put all this information into the Progress Notes in the first place? Are you printing the Progress Notes and sending that to them or something? E.g. It would be far easier to enhance something like the Print b...

I believe you are interested in Image Categories.

Medicaid; Say no more. This would be extremely difficult; You basically need a breakdown at an Audit Trail level of the entire patient encounter / appointment IMO. This would be a Feature Request that would need to be extremely detailed in regard to what you need in order to jump through the hoops b...

That specific information cannot be directly gleaned from a query because it is part of our software and not stored in the database. Odds are that there are several patient related audit trail entries made by your Open Dental user so you might just launch the Audit Trail window and take a quick peek...

Everything you mentioned, age, problems, allergies, show in the Patient Info grid just to the left of the Progress Notes grid. The difficulty of auto-importing (and significantly cluttering) said information into notes seems superfluous. Maybe my definition of Progress Notes is different than yours?...

If you need Open Dental to utilize a service endpoint then you'll need to contact vendor.relations@opendental.com and we can start talking about how we can start integrating with each other. If you prefer to continue down the plug-in route then your hundreds of offices will have to start installing ...

Open Dental can already process ERAs by monitoring a report directory so you wouldn't need to augment anything if that is all you desire. You'd just create a clearinghouse and point it at the right directory where the ERAs will eventually show up. What custom functionality do you require?

SheetFields use this color field to know how to display within the program as well as print. An "empty" color within the database is unacceptable to the program thus it shows up in the results of your database maintenance. Highlight that DBM entry and click the Fix button. That'll fix it by changing...

The Open Dental Service needs to be installed and running. Then check the "Receive Reports by Service" box within the Clearinghouses window. If the Send Claims window is more desirable then you might have to use the dropdown next to the "Send E-Claims" button within the Insurance Claims window? I'm ...

My stab in the dark would be that the server is having trouble turning itself into a local API listener or is doing that part just fine but then running into trouble with processing incoming API payloads (if in use).

Call support for critical issues that require urgent assistance.

Oh, you mentioned that the user is getting the message but just no log. Probably just file I/O problems. Odds are they are falling into your catch block which just has a "do nothing" comment. Maybe do something there so you can tell if they are falling into that block of code?

I remember having trouble catching some exceptions when I wrote the HookException() paradigm. It's why I wrote this gnarly summary on the virtual method down in PluginBase: ///<summary>This method will get called if there is an exception when this plugin has an exception thrown. ///This will allow t...

My best advice is to become a complete guru on a specific version of Open Dental so that you completely understand how the software interacts with the database that way you will have a shot at trying to take information in completely unknown formats (aka from other companies) and come up with a way ...

Based on the documentation https://www.opendental.com/manual/clearinghouses.html, it sounds like we could become an ERA provider by adding ourselves as a clearinghouse. Is that correct? The answer is yes but this could be quite the journey you are about to embark on depending on the next steps you ...

I'm not sure what format you need to export in nor do I know what you are referring to when you mention that you can go in every day and "copy and paste" the thing you're needing to export. But if you just want a date range of appointments in an exportable report fashion you can check out our Appoin...

Sounds like the internet trolled you. Those methods do very different things.

This sounds like a limitation of Windows (they only allow paths up to 256 characters if memory serves). What is the actual path that is causing the error?
Odds are you have an impressively long A to Z data path or debugging environment (aka the path to your bin folder).

No. A singular vote was applied to that feature request over the years.

Now that you have it downloaded, it looks like you're running into compile errors. The Open Dental solution does not build out of the box. See Source Code for getting Open Dental to build. https://github.com/OpenDental Performing the steps like Error: The name 'OpenDentalHelp' does not exist in the ...

It's publicly available on GitHub if you are used to using that to download source code.

Nope. It would be a Feature Request to customize it.

The terminology that you'll want to search for is "iFrame" aka "inline frame". You would then set the URL for said iFrame to your "Patient Facing URL" found within the eServices Patient Portal window . If WordPress, or Drupal, or any such site hosting entity doesn't support iFrames then just having ...

Your 10 years experience will be more than sufficient for making this plug-in. Also, I do not believe you need to worry about utilizing the API to pull off what you described. Our PluginExample project should be more than enough for you to get the gist on how to go about creating a plug-in library (...

Do you have a roadmap as to where OD is headed with their MariaDB support? I'm not aware of any kind of roadmap. I remember that there was an Oracle option a while back that fell out of favor. One of my friends asked why there was no support for PostgreSQL too. Is the SQL code specific to MySQL/Mar...

What is the default storage engine for the opendental database on new OD installs? MyISAM. It is simple and easy to support. It is also easy to make and restore backups with. Any thoughts on what version of MariaDB OD is moving to? What are other people using? Current version that Open Dental suppo...

When the Open Dental application inserts a row and then immediately selects it, does that operation occur within the same database connection as the insert or does OD run that select using a separate connection? That decision is left up to the MySQL connector. The connection is often reused but a n...

Sure. There are things like Middle Tier and MariaDB SkySQL.

It will only work if the proxy can give you a 100% money-back guarantee that the non-writing server it chose for you will have the record that was just written. So far, it hasn't worked like that. You'll get instances of Open Dental that will insert a row, immediately attempt to select that row back...

I have only heard of problems when splitting database reads and writes. It would be a hefty Feature Request to overhaul the framework of Open Dental to support that paradigm. We have been slowly exposing specific parts of our software (e.g. reports) to read-only servers (e.g. one-way replication) fo...

It can indeed; Heed the Build section of our Source Code page: IDE - Use Visual Studio 2019 on MS Windows computers. (there are some versions around 17 and 18 that use VS 2017) Open Dental versions 15.3 and greater, use Visual Studio 2012 or 2015. Open Dental versions 12.4 to 15.2, use Visual Studio...

Branch 22_1 compiled just fine for me. Also, OpenDentBusiness.Tooth.GetToothLabelGraphic() seems to be in place:
https://github.com/OpenDental/opendenta ... th.cs#L195

Can't say I know what GHL is. Maybe reach out to them about the integration?

Typical use would be to have simple links to your Web Sched URLs on your website somewhere. If you are looking to embed Web Sched into your site then I would point the website designer to our Web Sched Advanced page.

Apparently this has already been addressed. You need to be at or above the following versions: v23.1.60, v23.2.30, or v23.3.5

What version of Open Dental are you using?

There is a way to export and import fees. See the Export/Import sections on our Fee Tools page: https://www.opendental.com/manual/feescheduletools.html Which will refer you to Fees Export: https://www.opendental.com/manual/feesexport.html And Fees Import: https://www.opendental.com/manual/feesimport...

So are the workstations that connect to the Middle Tier server accessing this file, or their local copy? It would seem to be the former, or does this .dll just need to be there on the server for everything to work properly? The answer is both, potentially. It all depends on what methodology your pl...

...I very much need to know where I can find them on my systems (which systems, which directories). Open Dental Software manages all cloud backups. If you want them on your local systems then you need to perform the last sentence on that page: "Copies of backups can be requested by contacting Open ...

If using v18.4 through v19.4 you can find Theme in the Miscellaneous Setup window. If using v20.1 and above you can vote for FR #14191 - "bring back OD theme". Starting in v20.3 you can change the 'Main Border', 'Main Border Outline', and 'Main Border Text' colors via Definitions: Misc Colors. https...

Patient Forms can be pre-filled but I don't think Exams can. See the "Pre-Fill Logic" section of the following page in our online manual: https://www.opendental.com/manual/patientform.html

Apparently you just need to execute the 'Patient Missing' tool within the Tools tab the Database Maintenance window.
https://www.opendental.com/manual/datab ... tools.html

I don't want to screw anything up but would this fix my issue? Even if that would fix your issue I would not recommend running a manual query on a live database that manipulates data. Especially over something this trivial. These 'invalid' patients only have TP procedures associated with them. Ther...

Good news: The Update Estimates tool is updating your procedures just fine even though it says 97% Strange news: The unknown 3% is coming from the fact that you have invalid TP procedures in your database. Invalid as in associated with patients that do not exist. There are 6,604 TP procedures, of wh...

One of the support members told me that this is a known issue and quoted the following text to me: ...For estimates to calculate correctly you must chart the procedure from the Chart Module then attach them to the appointment. If procedures are added directly to the appointment, you must click into ...

If a customer moves to OD cloud, is their database just moved to the cloud and are they able to connect to that from either the OD Windows Client or a Web Application? If they move their database to their own cloud, then yes. We have been working on adding features to allow users to do just that. F...

Back around 2018 or 2019 someone made an external application that used our libraries to get the MySQL password from the FreeDentalConfig.xml file like you are requesting and a lot of people got hot and bothered by that. You can no longer use our libraries like this in order to get access to the MyS...

I tested two different databases using v23.3.24 (which I would imagine is the same as v23.3.20) and both made it to 100% just fine.
There might be something unique with your database. I would recommend calling support and giving us a copy of your database so that we can inspect it.

Such a 3rd party application / integration is not supported when using Open Dental Cloud. It should consider using the API instead.

The bug "Middle Tier, Schedule window, clicking Paste or Repeat was crashing the program" has been fixed and will be released with v23.3.13

This is a fine place to report such issues. I was able to confirm the bug with all of the information you provided, thank you for being so thorough. I will add this to our bug tracker as "Middle Tier, Schedule window, clicking Paste or Repeat crashes the program" and will report back once it has bee...

I typically start by using the slow query logger on MySQL to help categorize the slowness; whether it stems from query or software changes.
https://www.opendental.com/manual/slowquerylog.html

It sounds like you are referring to the "Prompt for SET statements" feature behind Query Favorites. Check out the "Run a Favorite Query" section at the bottom of https://www.opendental.com/manual/queryfavorites.html It might be as simple as needing to change your query to start using SET statements ...

The 'stub' version of the CDT.dll can be found in the 'Required dlls' folder. https://github.com/OpenDental/opendental/tree/23_3/Required%20dlls You'll want to follow similar steps that are required for OpenDentalHelp (drop the CDT reference and add it back): Error: The name 'OpenDentalHelp' does no...

If your web dashboard can pull off launching Notepad.exe or something similar then it should be able to launch OpenDental.exe and you would just provide it with the desired Command Line Arguments: https://www.opendental.com/manual/commandline.html

Did you first drop the reference to OpenDentalHelp before trying to add it? The current reference is pointing at the project, which you need to drop. Then you should be able to add the reference to the DLL.

...I am trying to compile in release configuration from branch 22_3 and I am getting the same error as mentioned here https://www.opendentalsoft.com:8085/forum/viewtopic.php?f=3&t=7297&p=32355&hilit=winmd#p32350 the windows.winmd error If I understand correctly, I can exclude the file "windows.winm...

...Should I be checking the Preference table and skipping those versions below the plugin version in the db? Assuming your scripts do not need to be run every single time your plug-in loads / launches, yes, that's what I would do. ...I always assumed that OD was checking the script against the runn...

Version your DB conversion scripts if they aren't already. That way the plug-in loads up in 45-60 seconds once and then subsequent times it'll see that it has already updated to the latest version and load right up. From the 'Hints for Programmers' section: 4. If managing your own database tables, r...

Could you provider some details on the deprecated preferences? where do I find those information? They just held a comma delimited list of procedure codes. They all started with "InsBen..." For Example: ///<summary>Comma delimited list of procedure codes that represent bitewing codes. Defaults to D...

No. Wouldn't you just need to change your integration from looking at the deprecated preferences to looking at the new codegroup table? Before: An arbitrary preference dictated a group of codes for very specific benefits (based on how they were set up). After: A structured link is made between the b...

The bug "Plug-ins were not loading in additional instances of Open Dental when using the update sequence" has been fixed and will be released with v23.1.45 and v23.2.15.
https://opendentalsoft.com:1943/ODBugTr ... sions.aspx

Reference the project itself. Or is it not compiling for you and thus not putting the dll into the bin folder?
https://github.com/OpenDental/opendenta ... ControlsOD

Our testing department was not able to duplicate this as well. The only thing I can think of to do is start hammering you with questions: 1. What OS is being used? 2. What graphics card is being used? 3. What graphics drivers are currently installed? (a lot of times the drivers are old) 4. Is the OS...

I am unable to duplicate this on my machine but will forward this information to our testing department to see if they have better luck.

My monitor can do some pretty outlandish resolutions (e.g. 3840 x 2160) so I'll play around with them and see if I can duplicate your errors. What kind of cable does your monitor use? Is it HDMI?
Mine is a DisplayPort cable which then goes through a converter into a mini DisplayPort plug.

Added the bug "Plug-ins are not loading in additional instances of Open Dental when using the update sequence" to our tracker and I'm training another engineer in the ways of plug-ins.
https://opendentalsoft.com:1943/ODBugTr ... sions.aspx

That is certainly an elaborate way to confirm my theory. Glad we were able to figure out the exact issue you were running into.

I have a theory based on the description from our website: ...For example, if using version 14.3.23, it would look for MyPlugin14.3.dll. If that file is found, it would replace MyPlugin.dll with the contents of MyPlugin14.3.dll, and then it would load MyPlugin.dll as normal. In a typical setting, th...

Not that I'm aware of. I just wrote a 'hello world' plug-in and it loaded up in both instances I just tested. using OpenDentBusiness; using System.Windows.Forms; namespace PluginHelloWorld { public class Plugin : PluginBase { public override bool HookAddCode(object sender,string hookName,params obje...

Then it should work for you in theory. Maybe provide more information about the exact PlatformNotSupportedException you are getting by changing the catch to something like catch(PlatformNotSupportedException pnse) { and then providing as much detail from the 'pnse' variable as possible from a debugg...

.NET is throwing a PlatformNotSupportedException. We have found that this is most common with RDP sessions but it could also be with whatever platform you are using Open Dental with. What version of Windows are you using? Are you using a Virtual Machine or anything along those lines of note?

What is the client version of Open Dental and what is the server version of Middle Tier being used?

It is no longer a field and is instead a virtual property now. Maybe provide a little more information regarding how you're using it?

You'll need to use Visual Studio 2022 for version 23.1 or you can use version 22.4 with Visual Studio 2019.
https://www.opendentalsoft.com:8085/for ... f=3&t=7981

We took a look at the repo on Github, it looks like the function to move to the GM line already exists, the function just needs to be linked to a keypress as bleeding etc. are. If we were to fork the code, make the change and request a merge, is this something you would be open to? Not via that ave...

...Something must have changed between version 20.1 and version 20.3 on the backend calculations or conversion script that is throwing this off on a few accounts. The change was "Account Module, NotReceived claim procedures associated to treatment planned procedures were impacting the estimated bal...

Our supported keyboard entry methods are documented on our Perio Chart page: Number Entry: Press the numbers on screen or use your keyboard. On the screen: For numbers greater than 9, click 10 button followed by the second digit (10 + 9 = 19). On your keyboard: For numbers greater than 9, press Ctrl...

It will be set to Visual Studio 2022 (v143) in the '23_1' branch.

We have just been getting used to editing designer changes in Any CPU (64-bit) mode and running the program in x86 mode (since we are still a 32-bit application).

The attempted bug fix "Custom Reports that require the ODR library were failing to execute" will be released with v22.3.47 and v22.4.19.

The code that was being used from the ODR library was moved/baked into the program (FormRpAccountingGenLedg.cs). So the screenshot you took must be a non-Open Dental entity needing it? I'll go ahead and distribute the ODR.dll with our installer again so that the library is present for anyone that ne...

public static DataTable GetTableConAlreadyOpen(int serverThread,string command,bool wasSqlValidated,bool isSqlAllowedReportServer=false,bool hasStackTrace=false,bool suppressMessage=false,bool useReportServer=false) https://github.com/OpenDental/opendental/blob/22_3/OpenDentBusiness/Db/DataConnecti...

The purpose of Middle Tier (MT) is to run all queries on the MT server. CRUD methods do not have code present that will cause the MT server to run the query for them. You need to use a method that has the code present to pass the query along to the MT server. E.g. Prefs.UpdateInt(), Prefs.UpdateBool...

The most recent version of v22.3 no longer has that method with 5 params; it is now 7 params. It sounds like your version of Open Dental on the workstation does not match the version of your Middle Tier server. It is most commonly the Middle Tier server that is left behind in version. But you should...

Sounds like you just want Feature Request #3276 - "Incoming Email IMAP Access"
https://www.opendental.com/manual/featurerequests.html

Sounds like you probably want to make your integration with the API instead of directly to the database. Less for you to worry about.
https://www.opendental.com/site/apispecification.html

I put you into en-US mode. Your Windows 7 boxes might be able to retrieve Web Forms now.

Sounds like you might want to create a feature request to have us treat the 'en-DE' culture like DD/MM/YYYY for both eClipboard and Web Forms instead of how we are currently treating it; MM/DD/YYYY

You should be able to send emails without the service but you will need to have the Open Dental Service running in order to have the Inbox Receive Interval feature work correctly. Inbox Receive Interval : Set the time, in minutes, to automatically check for and download new emails using Open Dental ...

Make sure you entered your registration key correctly in the Registration Key window. You can also call support and have them get connected with you and they'll enter the key for you to make sure it has been entered correctly. https://www.opendental.com/manual/updatefullversion.html This is because:...

The bug "Custom Reports, brought back the custom RDL reporting system." has been committed and will be released with v22.1.60, v22.2.40, and v22.3.9.

There isn't a quick way that I can think of from within the program. I can only think of running a report like the Insurance Plans Report (or one of the many custom query examples) to get a list of patients that need to be contacted. Then print out a single label for each individual patient on that ...

That is not currently possible. Changing the Region and Language settings on the local computer will let you display the different currency symbols but no exchange rates will be applied.
https://www.opendental.com/manual/regio ... tings.html

I finally see where the invalid 'name' parameter is coming from. Allen is right on the money, we are asking the Operating System to create us a CultureInfo object out of the string 'en-DE' and the parameter that the OS needs just happens to be called 'name'. E.g. new CultureInfo(webFormPrefCulture) ...

We have code like this sprinkled throughout the program on purpose; So that we don't automatically connect to our live services when we are developing. Your users should never run into this problem since they should be using a version of Open Dental that was compiled in Release mode.

Cause certain formats require certain things. Not all formats have the same requirements.

Controls have no impact on Middle Tier performance. Methods that have RemotingRole (now known as MiddleTierRole) checks at the top of them are typically methods that run queries against the database which are what cause Middle Tier slowness. You want to minimize the number of times you invoke such m...

I've not seen output like that after retrieving web forms from with Open Dental. Web Forms should support the en-DE culture (which should just act like the en-US culture since we don't do anything specific for it). I've never heard of the parameter name of 'name' before. What version of Open Dental ...

Short answer: Set your active solution platform to Any CPU and make sure to clean or rebuild the solution. Older versions of Open Dental may also have the 'Prefer 32-bit' check box checked within the project properties Build tab which needs to be unchecked. Restart Visual Studio if forms are still n...

Functionality of the "Payment Plan Procedures and Credits" window - didn't change from the user's perspective. Functionality of the HookAddCode() - only changed the 3rd parameter's type. Functionality of the new PaymentEdit.ConstructResults Type - drastically different than the previous LoadData typ...

dcrider, I just overhauled the "Payment Plan Procedures and Credits" window (FormPayPlanCredits.cs) in the head (projected to be 21.2.1 ATM). The 'loadData' parameter that was being passed into the "FormPayPlanCredits.Load_end" hook no longer exists (I deleted both the field and the class it used). ...

File sharing has been turned back on as of December 17th, 2019.

Uploading attachments has been temporarily disabled. This thread topic will be updated as soon as file sharing has been turned back on. Sorry for the inconvenience.

There isn't an official way to print the appointment schedule in landscape. This is a good opportunity to let you know about our feature request system:
https://www.opendental.com/manual/featurerequests.html

We've actually had a few complaints about this over the years. Way back in 2012 we had an engineer explicitly code it this way as a bug fix "Auto code edit window now prevents you from setting up dysfunctional auto codes." because we were getting far more support calls for users having set them up i...

It sounds like you are referring to what we call Proc Appt Colors.
https://www.opendental.com/manual/apptv ... olors.html

However, this is only helpful if each of these unique OneDrive paths on each computer point to the same OneDrive account. If each doctor / computer has a different OneDrive account you have defeated the purpose. I just assumed this was not the case.

Maybe you could go to each computer and make a symbolic link from a folder path that all three computers know about to the corresponding folder of unique path. E.g. create a "C:\Custom\OpenDental\Path" on each computer and then utilize the mklink command to link them to their corresponding "C:\users...

It gets set to the patient's primary provider which is set via the Edit Patient Information window. https://www.opendental.com/manual/patientedit.html It would be a feature request to override the patient provider with the provider linked to the user currently logged in (if the user is even linked t...

There is no such thing as a Document.Import method. Are you referring to ImageStore.Import()? That method returns a Document object which is the object that should have the Description field set after Import is invoked. I don't fully understand your FYI, are you trying to say that the "Item Info" wi...

Correct, POP3 is currently supported while IMAP is feature request #3276
https://www.opendental.com/manual/featurerequests.html

Do you get an error message before it crashes? If so, what does it say? If not, can you go into your Windows Event Viewer and look for any Application Errors that are for Open Dental and report what information that has? Also, what is the exact version of Open Dental that you are using? We release s...

We have been wanting to release a 64 bit version of Open Dental (and thus would package the 64 bit version of MySQL with it) but have been focusing on other necessities. E.g. making a smooth and semi-automated MySQL upgrade tool so we can get all of our users off of MySQL 5.5.

We're not perfect, but we try really hard to keep the "waste" down. On top of that we try and clean up after ourselves when we discover that it would take too much time to rewrite a wasteful system to be more efficient. E.g. we clean up the signalod table after a while because the data is no longer ...

The main page that loads (with no filters) should be every query that we have available (hence it takes so long to load). I have not verified this information recently so it might be wrong but was true back in the day (8 years ago).

I am not sure what version is beta version?... Our home page will shows a brief description of our latest versions along with links to a more detailed breakdown of what is new in each corresponding version. (beta) - Version 19.1 - Dynamic Chart module. Patient Dashboard. Help Feature. https://www.o...

We debug the software every single day (sans holidays). You can keep track of what we are doing at all times via our Bug Tracker: https://opendentalsoft.com:1943/ODBugTracker/PreviousVersions.aspx If you are on the Beta version of our software then you should update often. If you are on older versio...

There isn't a way to copy and paste email from GMail but you can sync your entire GMail account with Open Dental so that incoming emails automatically show up within Open Dental. Incoming Email Settings https://www.opendental.com/manual/emailbyuser.html and then set the Inbox Receive Interval https:...

I can only speak for Open Dental integrated texting which will not honor comma delimited numbers for texting multiple recipients. That would be a feature request.
E.g. FR #5967 - Multiple Wireless phone numbers for text reminders
https://www.opendental.com/manual/featurerequests.html

Download the HL7 standard for the types of messages you need to pull out and parse any pertinent data for your separate database.
http://www.hl7.org/

You want to use Web Forms.
https://www.opendental.com/manual/webforms.html

Once setup, the URL that you should use on your web site will be available via the Web Form Setup window.
https://www.opendental.com/manual/webformsupload.html

I would want to create some sort of API for a new web service (kind of like FHIR) that you could call in order to upload said data so that we could scrub it first. I can't have data coming into my database that doesn't adhere to the arbitrary rules that we expect because it could destabilize the web...

The POST-able entity that you need to communicate with is not publicly available. Why not skip the middle man (Open Dental) and make your script directly insert sheets into the database (essentially what Web Forms do in the long run)? Or is there a specific reason that you want to use Web Forms in a...

Our Query Examples page has over 1,000 entries that have been added over the years from requests made by users. I recommend checking that list out if you haven't already done so.
https://opendentalsoft.com:1943/ODQuery ... yList.aspx

The only solution we provide that I can think of would be a database merge. https://www.opendental.com/site/conversionsmerge.html We provide a tool that lets you easily access multiple location databases and do small operations against them which is called the Central Enterprise Management Tool (CEM...

Try building in Release mode? Looks like demo credentials were sent over.

That error makes it sound like your database didn't quite finish the 19_1_1 script. Does your preference table contain rows for the following PrefNames? ThemeSetByUser, GlobalUpdateWriteOffLastClinicCompleted

Modify the sql_mode parameter to either a blank string or NO_AUTO_CREATE_USER.

I'll see about getting this information into the following page in our manual.
https://www.opendental.com/manual/manage.html

The "Server Time" is a reflection of the time reported by your MySQL server. You can run the following query manually and it should match what is displayed within the Manage module: SELECT NOW() If you need to adjust your server time, or have already done so, then you should restart your MySQL servi...

You could restrict your less than perfect employees by putting a date restriction on the PerioEdit permission so that they have to ask a perfect user, such as yourself, before deleting historic exams.

https://www.opendental.com/manual/permissions.html

Correction, apparently we already ask the question "Delete Exam?" and have since before Open Dental 4.7
I only looked at the Delete button from within the Perio Chart window, is there another way your hygienist is deleting exams?

We typically ask the user if they are sure first before deleting things, I'll create a ticket for this.

Thanks guys, to clarify for appointment status and insplan.PlanNum there are no tables to join. Status is an enum so no JOIN needed. However, PlanNum is the primary key of a table so odds are you need to JOIN to it from other tables. Basic rule of thumb will be any column that starts with "FK to [t...

Correct, the InsWriteOffEdit permission controls the ability to enter write-offs and write-off estimates. The current logic in the program allows you to have a set amount of days (or a specific date) after the DateEntryC (automatically updated when the procedure gets created and when it gets set com...

And if you like to peruse source code you could check out FormQuery.MakeReadable() which contains our monster switch statement that takes raw query results and translates them to the Human Readable version that is displayed to the user via C#.

Agreed.
Side note: A much easier query would be a report that shows any sheets that have a signature field that is not signed. However, that would include sheets with no signature boxes signed, not just the desired "partials".

Write-offs aren't technically stored as adjustments in the eyes of Open Dental so they got their own category:
The InsWriteOffEdit permission is what you care to restrict.
https://opendental.com/manual/permissions.html

At minimum, does anyone know if it is possible to do an auto-reply through Open Dental? I suppose as an alternative I could set it up through the google side since our email are through G Suite. This may be better anyway so auto-replies don't clutter the OD charting and inbox? Most email service pr...

Maybe the path is correct and you just forgot to run Open Dental as an administrator and so you don't have access to it? Call in to support and we can help you locate your database and get the backup system working. Or, if you're feeling froggy, you can do it yourself by opening up your Windows "Ser...

From the link you posted: Protocol detection only succeeded in one direction. For FTP and SMTP this is expected. So if you have been using these protocols from your network then you will see these alerts. Email within Open Dental is typically sent via SMTP so I guess this is expected behavior with S...

Email clients usually give more descriptive errors. I'll see about making a ticket for getting as much raw data as possible and putting it in a different output format but that won't help you tonight. Because it's such a generic error I can only suggest generic things like make sure your firewall is...

Let me know what action you were taking prior to getting that error if you need any help tracking it down.

Verified that v18.4 allowed me to connect to a Middle Tier CEMT. I didn't have time to click around at all so you might stumble upon some bugs (not very many people use the CEMT via MT). The config file logic is written in a strange way in the sense that it requires the other XML nodes to be present...

From our Customer Announcements on the home page: https://www.opendental.com/index.html 01/15/2019 - Windows has released a fix for the error below. See: https://support.microsoft.com/en-us/help/4487345/update-for-windows-7-sp1-and-windows-server-2008-r2 ^which will eventually make it to our announc...

I need to do some testing to make sure Middle Tier is working correctly but assuming that it is, you need to make sure you have an XML node called "MiddleTierAddr" which is where you'll enter your URL / URI for the CEMT Middle Tier web service.
https://www.opendental.com/manual/cemtsetup.html

That bug, "Patient Fields, date and currency types were not being saved to the database", was fixed and released with v18.4.19 and will be released with v18.3.46
https://opendentalsoft.com:1943/ODBugTr ... .aspx#18.3

Hello test,
There was no trial version for v16.

Uninstalling OD does not remove the services it installs. I have no idea if they phone home once OD is uninstalled. As a precaution, I have blocked internet access for the VM at the router level. JLM That's because the installer doesn't install the services. More of a head's up to let you know your...

JLM wrote:Uninstalling OD does not remove the services it installs. I have no idea if they phone home once OD is uninstalled. As a precaution, I have blocked internet access for the VM at the router level.

JLM

That's because the installer doesn't install the services.

...looking for a script/SQL to create a list of deceased patients set as account Guarantors. Getting a list of deceased patients that are set as the guarantor is a very simple query that might even be helpful for other users some day in the future. I'd recommend filling out a query request so that ...

For manual Recall reminders:
https://www.opendental.com/manual/recallsetup.html

For Web Sched Recall reminders:
https://www.opendental.com/manual/webschedverify.html

Can I simply uninstall OpenDental from my copy of the server but leave mysql running and serving the opendental DB? ie. Does opendental itself have to be installed on the server for the workstations to operate? Open Dental is not required to be installed for MySQL to run / serve the database (lots ...

I see how this could happen sometimes. I'll create a bug ticket and get someone on it ASAP.

You don't need to have any MySQL connector installed (at least I don't have any installed) but it doesn't hurt if you do. I found where we had too much specificity in our reference to the MySql.Data.dll and fixed it (revision 21616).

There must be something hard-coded to our directory setup because it works fine for me until I create a brand new checkout in a strange location. I'll see if I can't find where the path assumption is being made instead of using a relative path.

Your solution is acting like it doesn't have the "xDataConnectionBase" project... That or it can't access it for whatever reason. Double check that you have that project and that it can compile. DataConnectionBase .DataConnection.NonQ(System.String, Boolean, System.String, System.String, Boolean, My...

Issue verified and added to our bug tracker.
https://opendentalsoft.com:1943/ODBugTr ... sions.aspx

I'll have someone look into this. What version of Open Dental are you using?

My NuGet Manager for the OpenDental solution says: MySql.Data by Oracle (v8.0.13) <= I don't think this is necessary but doesn't hurt Newtonsoft.Json by James Newton-King (v12.0.1) <= this is a known requirement ^ However, the actual version of JSON installed is v9.0.1 so I don't know why the manage...

Severity Code Description Project File Line Suppression State Error CS0246 The type or namespace name 'CodeBase' could not be found (are you missing a using directive or an assembly reference?) OpenDentalCloud X:\ceysoft\CeysoftUI\OpenDental\OpenDental18_3_1\OpenDentalCloud\Storage\Dropbox.cs 1 Act...

That error is due to the version of C# you are using which is not able to understand the null-conditional operator. You simply need to upgrade to at least C# version 6.0 https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/language-specification/expressions#null-conditional-operator I'l...

What's one of the errors (or several of them)?

The bug "Appointment module, appointment grid didn't redraw properly when changing the view sometimes." has been fixed and will be released with v18.3.35 and v18.4.5.
http://opendentalsoft.com:1942/ODBugTra ... sions.aspx

Looks like you need to reinstall the Open Dental v18.4 or try from a different computer. I double checked that v18.4.4 can successfully upgrade a database. If you continuously get this error, please call in to support and we'll troubleshoot or get a copy of your database for closer inspection. Are w...

The latest update to our SVN Server has removed the ability to have an anonymous user in order to checkout source code. The following credentials should be used in order to download our source code:

username: guest
password: od123

https://www.opendental.com/site/sourcecode.html

We had to upgrade our SVN server and it seems VisualSVN removed the ability to have an anonymous user. Use the following credentials:
UserName: guest
Password: od123

That's very helpful information, I'll forward that to the engineer that is working on the basic redraw bug that he found and have him make sure the vertical monitor scenario works as well.

What version of Open Dental are you using? Although I can't duplicate an exception there does seem to be a problem with redrawing an appointment view that changes the rows per increment value. We'll create a bug ticket and get working on that. http://opendentalsoft.com:1942/ODBugTracker/PreviousVers...

Hi, if an appointment is changed, e.g. scheduled time changed, AptNum should still be the same, right? Correct, the AptNum will stay the same in this and most other scenarios when editing the appointment. If I need to cancel an appointment, then simply delete the row with AptNum=XXX, right? No. Whe...

There is a possibility that our multiple clients are using a different version. They will have different business layers, right? That is correct. How do you think is the best approach to maintain backward compatibility. Should we stop using the business layer? Open Dental does not honor backward co...

There was a couple of versions where large customers were having significant slowness with caching data and we had a temporary bug fix in place that took an optional parameter (dictionary of prefs). The bug was finally fixed the correct way and the optional parameter was removed. Thus you need to si...

What version of Open Dental are you currently using and how are you storing images (found in Edit Paths window)?
https://www.opendental.com/manual/paths.html

The bug "Middle Tier, invoking Meth.GetTableLow() from a plug-in was causing an error" is fixed and will be released with v18.2.48 and v18.3.27. Your users need to update their version of Open Dental in order for your plug-in to start working in a Middle Tier environment again. http://opendentalsoft...

I verified that this is an issue and will create a bug ticket for it and get back to you once I know more.
http://opendentalsoft.com:1942/ODBugTra ... sions.aspx

As long as they are at or above v14.3 plug-ins should 'just work' for Middle Tier users.

Code: Select all

Plug-ins now supported in Middle Tier.

https://www.opendental.com/manual/version14_3.html

I read your post again but this time slowly, carefully chewing on every word and I think I understand your specific conundrum. Your plugin project must not have a reference to CodeBase thus it must not know what an ODForm even is in the first place. Simply add a reference to CodeBase in your plugin ...

All Open Dental forms are technically "System.Windows.Forms.Form"s by way of inheritance; FormPatientEdit > ODForm > ODFormAbs > Form Therefore, you must not have told the compiler what your local "formPatientEdit" is so it has no idea how to treat it, thus it treats it like Object (the father of us...

I believe you can add a provider bar for the assistant: View Operatories / View Provider Bars
https://www.opendental.com/manual/appoi ... reate.html
https://www.opendental.com/manual/timebars.html

Laser Labels
https://www.opendental.com/manual/laserlabels.html
https://www.opendental.com/manual/labels.html

Are security permissions now read/written from/to usergroupattach or userod? Security permissions are linked to user groups and the userod.UserGroupNum was deprecated in favor of the usergroupattaches table. userod.UserGroupNum : Deprecated. Use UserGroupAttaches to link Userods to UserGroups. http...

We dynamically create them on the fly. You will be interested in invoking OpenDentBusiness.ImageStore.GetPatientFolder(). I would recommend calling that method instead of trying to do what it does on your own cause you could cause some angry doctors if you mess with the image folders in an odd way (...

We see all kinds of versions of Windows out in the wild. From an Open Dental perspective we try and support all versions of Windows that Microsoft supports. We don't hesitate to drop support for an OS (e.g. Window XP) when Microsoft drops support for it. https://www.opendental.com/site/computerrequi...

...Cheap copies are similar to hard links in Unix, which means that instead of making a complete copy in the repository, an internal link is created, pointing to a specific tree/revision. As a result branches and tags are very quick to create, and take up almost no extra space in the repository. I ...

There are several default settings that MySQL has chosen that slow the system down significantly.
e.g. setting eq_range_index_dive_limit to 0 would probably speed up your system.
https://dev.mysql.com/doc/refman/8.0/en ... dive_limit

You're quite lucky that we upgraded our MySQL connector recently otherwise you wouldn't have been able to even connect to a MySQL 8.0 service

...to get from 5.5 to 8.0 is pretty complicated and time consuming. Utilizing the mysql community installer makes the process easier. I had to upgrade from 5.5 to 5.6, and mysql_upgrade the databases. Then to 5.7, and then to 8.0. That's the main reason right there. We're still trying to figure out...

I've been pulling from the same label/tag (opendental18.1)...but in continues to change (new files, version# changes). It also shoots holes in the earlier conversation. Problem : How do I reproduce a specific version of Open Dental? If the About->Help reads "Open Dental 18.1.55"...how would one rep...

Finally found what I was looking for in the "Other Interface Options" on the "Web Sched New Patient" page. https://www.opendental.com/manual/webschednewpatsetup.html Open Dental would have to provide an interface to dictate the color for Web Sched recalls since those URLs are emailed / texted to the...

The color theme can be changed for our Web Sched solutions via the URL. I'm trying to find where we talk about that specifically in our manual. Also, we allow users to use Web Sched in an "embedded" fashion so that it looks like your website. Here is an example of what I'm talking about: http://pati...

I suggest calling in to support so they can help you get your Trial up and running (e.g. so that you can connect to your database). https://www.opendental.com/contact.html Once you are allowed to connect to the database with the Trial version then we can start having the conversation as to what you ...

There is no script to run (unless you run our Unit Tests which will technically create a database for you automatically). I highly suggest you read the following page on our website in detail. The second sentence on the page says: REQUIREMENT: You must first install the Trial Version so you can see ...

You probably just want to invoke DataConnection.SetDb() if you are doing custom coding. Otherwise; just use the Choose Database window when it shows up after launching Open Dental. If you are having a MySQL error then you'll need to provide the specific error so that we can help you with that. If th...

Search found 1595 matches