Search found 1550 matches

by jsalmon
Fri Mar 01, 2024 9:13 am
Forum: Main Forum
Topic: Where are the OpenDentalCloud local backups stored?
Replies: 3
Views: 294

Re: Where are the OpenDentalCloud local backups stored?

...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 ...
by jsalmon
Thu Feb 15, 2024 9:26 am
Forum: Main Forum
Topic: Changing Interface Icons in Opend Dental
Replies: 3
Views: 3006

Re: Changing Interface Icons in Opend Dental

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...
by jsalmon
Fri Feb 09, 2024 3:09 pm
Forum: Main Forum
Topic: Auto fill Sheets Based on Previous Answers
Replies: 5
Views: 2600

Re: Auto fill Sheets Based on Previous Answers

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
by jsalmon
Thu Feb 08, 2024 11:17 am
Forum: Developers
Topic: Update Estimates Only bug in v. 23.3.20?
Replies: 10
Views: 1815

Re: Update Estimates Only bug in v. 23.3.20?

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
by jsalmon
Fri Feb 02, 2024 1:01 pm
Forum: Developers
Topic: Update Estimates Only bug in v. 23.3.20?
Replies: 10
Views: 1815

Re: Update Estimates Only bug in v. 23.3.20?

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...
by jsalmon
Thu Feb 01, 2024 3:51 pm
Forum: Developers
Topic: Update Estimates Only bug in v. 23.3.20?
Replies: 10
Views: 1815

Re: Update Estimates Only bug in v. 23.3.20?

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...
by jsalmon
Fri Jan 26, 2024 9:14 am
Forum: Developers
Topic: Update Estimates Only bug in v. 23.3.20?
Replies: 10
Views: 1815

Re: Update Estimates Only bug in v. 23.3.20?

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 ...
by jsalmon
Tue Jan 23, 2024 9:21 am
Forum: Developers
Topic: Custom Software + Open Dental Cloud
Replies: 4
Views: 1016

Re: Custom Software + Open Dental Cloud

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...
by jsalmon
Tue Jan 23, 2024 9:09 am
Forum: Developers
Topic: A little help with password hashes
Replies: 2
Views: 492

Re: A little help with password hashes

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...
by jsalmon
Thu Jan 18, 2024 9:42 am
Forum: Developers
Topic: Update Estimates Only bug in v. 23.3.20?
Replies: 10
Views: 1815

Re: Update Estimates Only bug in v. 23.3.20?

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.
by jsalmon
Thu Jan 18, 2024 9:22 am
Forum: Developers
Topic: Custom Software + Open Dental Cloud
Replies: 4
Views: 1016

Re: Custom Software + Open Dental Cloud

Such a 3rd party application / integration is not supported when using Open Dental Cloud. It should consider using the API instead.
by jsalmon
Fri Dec 01, 2023 10:11 am
Forum: Developers
Topic: Schedule Module Error in OD Beta v. 23.3.11.0
Replies: 3
Views: 2807

Re: Schedule Module Error in OD Beta v. 23.3.11.0

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
by jsalmon
Fri Dec 01, 2023 9:15 am
Forum: Developers
Topic: Schedule Module Error in OD Beta v. 23.3.11.0
Replies: 3
Views: 2807

Re: Schedule Module Error in OD Beta v. 23.3.11.0

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...
by jsalmon
Tue Nov 28, 2023 4:46 pm
Forum: Advanced Topics
Topic: Slow appointment module
Replies: 2
Views: 1866

Re: Slow appointment module

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
by jsalmon
Tue Nov 28, 2023 4:38 pm
Forum: Advanced Topics
Topic: Custom query pop up for dates
Replies: 1
Views: 1123

Re: Custom query pop up for dates

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 ...
by jsalmon
Wed Nov 22, 2023 12:59 pm
Forum: Developers
Topic: Building without CDT codes
Replies: 2
Views: 1196

Re: Building without CDT codes

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...
by jsalmon
Fri Oct 20, 2023 9:30 am
Forum: Developers
Topic: Can you open Open Dental from a URL?
Replies: 1
Views: 1235

Re: Can you open Open Dental from a URL?

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
by jsalmon
Mon Oct 16, 2023 4:53 pm
Forum: Developers
Topic: Unable to build WpfControlsOD.dll
Replies: 2
Views: 1301

Re: Unable to build WpfControlsOD.dll

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.
by jsalmon
Mon Oct 16, 2023 4:47 pm
Forum: Developers
Topic: Error compiling 22_3 in release mode
Replies: 1
Views: 1239

Re: Error compiling 22_3 in release mode

...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...
by jsalmon
Thu Sep 28, 2023 8:54 am
Forum: Developers
Topic: Long startup times with plugin
Replies: 3
Views: 1592

Re: Long startup times with plugin

...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...
by jsalmon
Wed Sep 27, 2023 3:40 pm
Forum: Developers
Topic: Long startup times with plugin
Replies: 3
Views: 1592

Re: Long startup times with plugin

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...
by jsalmon
Thu Sep 14, 2023 3:10 pm
Forum: Developers
Topic: Migration script for Version 23.2 - benefit/frequency
Replies: 3
Views: 1577

Re: Migration script for Version 23.2 - benefit/frequency

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...
by jsalmon
Mon Sep 11, 2023 9:23 am
Forum: Developers
Topic: Migration script for Version 23.2 - benefit/frequency
Replies: 3
Views: 1577

Re: Migration script for Version 23.2 - benefit/frequency

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...
by jsalmon
Wed Aug 30, 2023 10:33 am
Forum: Developers
Topic: Loading plugins in second instance of OD
Replies: 8
Views: 2941

Re: Loading plugins in second instance of OD

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
by jsalmon
Thu Aug 24, 2023 12:05 pm
Forum: Developers
Topic: Missing WpfcontrolsOD.dll in the 23_2 version
Replies: 1
Views: 1378

Re: Missing WpfcontrolsOD.dll in the 23_2 version

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
by jsalmon
Thu Aug 24, 2023 12:03 pm
Forum: Developers
Topic: OD keeps crashing when loading ApptBook
Replies: 5
Views: 2198

Re: OD keeps crashing when loading ApptBook

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...
by jsalmon
Mon Aug 21, 2023 12:10 pm
Forum: Developers
Topic: OD keeps crashing when loading ApptBook
Replies: 5
Views: 2198

Re: OD keeps crashing when loading ApptBook

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.
by jsalmon
Fri Aug 18, 2023 11:30 am
Forum: Developers
Topic: OD keeps crashing when loading ApptBook
Replies: 5
Views: 2198

Re: OD keeps crashing when loading ApptBook

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.
by jsalmon
Fri Aug 18, 2023 11:25 am
Forum: Developers
Topic: Loading plugins in second instance of OD
Replies: 8
Views: 2941

Re: Loading plugins in second instance of OD

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
by jsalmon
Thu Jul 20, 2023 2:12 pm
Forum: Developers
Topic: Loading plugins in second instance of OD
Replies: 8
Views: 2941

Re: Loading plugins in second instance of OD

That is certainly an elaborate way to confirm my theory. Glad we were able to figure out the exact issue you were running into.
by jsalmon
Wed Jul 19, 2023 8:45 am
Forum: Developers
Topic: Loading plugins in second instance of OD
Replies: 8
Views: 2941

Re: Loading plugins in second instance of OD

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...
by jsalmon
Tue Jul 18, 2023 5:10 pm
Forum: Developers
Topic: Loading plugins in second instance of OD
Replies: 8
Views: 2941

Re: Loading plugins in second instance of OD

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...
by jsalmon
Wed Jul 12, 2023 2:43 pm
Forum: Developers
Topic: Voice command with Perio Chart
Replies: 4
Views: 2213

Re: Voice command with Perio Chart

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...
by jsalmon
Tue Jul 11, 2023 1:16 pm
Forum: Developers
Topic: Voice command with Perio Chart
Replies: 4
Views: 2213

Re: Voice command with Perio Chart

.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?
by jsalmon
Thu May 11, 2023 10:32 am
Forum: Developers
Topic: Critical error in GetTableConAlreadyOpen
Replies: 1
Views: 2978

Re: Critical error in GetTableConAlreadyOpen

What is the client version of Open Dental and what is the server version of Middle Tier being used?
by jsalmon
Sat Apr 29, 2023 7:32 am
Forum: Developers
Topic: Field not found: 'OpenDentBusiness.X12object.Segments'
Replies: 1
Views: 3233

Re: Field not found: 'OpenDentBusiness.X12object.Segments'

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?
by jsalmon
Sat Apr 29, 2023 7:25 am
Forum: Developers
Topic: Unable to build Version 23.1 - Platform Toolset cannot be found
Replies: 4
Views: 3474

Re: Unable to build Version 23.1 - Platform Toolset cannot be found

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
by jsalmon
Fri Mar 31, 2023 2:18 pm
Forum: Developers
Topic: Keyboard shortcuts for GM
Replies: 5
Views: 19047

Re: Keyboard shortcuts for GM

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...
by jsalmon
Fri Mar 24, 2023 11:04 am
Forum: Main Forum
Topic: Account Balance Bug
Replies: 6
Views: 4739

Re: Account Balance Bug

...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...
by jsalmon
Fri Mar 24, 2023 10:43 am
Forum: Developers
Topic: Keyboard shortcuts for GM
Replies: 5
Views: 19047

Re: Keyboard shortcuts for GM

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...
by jsalmon
Fri Mar 17, 2023 11:00 am
Forum: Developers
Topic: VS2019 still used? C++ v143 code tools indicated in project
Replies: 3
Views: 3496

Re: VS2019 still used? C++ v143 code tools indicated in project

It will be set to Visual Studio 2022 (v143) in the '23_1' branch.
by jsalmon
Wed Feb 15, 2023 4:10 pm
Forum: Developers
Topic: Designer errors in VS 2022 with 32 bit VirtualWeb.dll
Replies: 4
Views: 4257

Re: Designer errors in VS 2022 with 32 bit VirtualWeb.dll

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).
by jsalmon
Mon Feb 06, 2023 9:52 am
Forum: Developers
Topic: ReportingForRDL folder missing
Replies: 10
Views: 5273

Re: ReportingForRDL folder missing

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.
by jsalmon
Fri Feb 03, 2023 3:47 pm
Forum: Developers
Topic: ReportingForRDL folder missing
Replies: 10
Views: 5273

Re: ReportingForRDL folder missing

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...
by jsalmon
Mon Jan 30, 2023 9:51 am
Forum: Developers
Topic: Method not found with 5 parameters in OD 22.3
Replies: 3
Views: 8426

Re: Method not found with 5 parameters in OD 22.3

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...
by jsalmon
Mon Jan 30, 2023 9:45 am
Forum: Developers
Topic: No longer allowed to send sql directly.
Replies: 1
Views: 3067

Re: No longer allowed to send sql directly.

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...
by jsalmon
Fri Jan 27, 2023 4:36 pm
Forum: Developers
Topic: Method not found with 5 parameters in OD 22.3
Replies: 3
Views: 8426

Re: Method not found with 5 parameters in OD 22.3

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...
by jsalmon
Fri Jan 06, 2023 2:54 pm
Forum: Main Forum
Topic: Emailmessage Table Size
Replies: 1
Views: 3291

Re: Emailmessage Table Size

Sounds like you just want Feature Request #3276 - "Incoming Email IMAP Access"
https://www.opendental.com/manual/featurerequests.html
by jsalmon
Fri Nov 25, 2022 2:51 pm
Forum: Developers
Topic: Integration accessing SQL DB or middle tier
Replies: 1
Views: 3578

Re: Integration accessing SQL DB or middle tier

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
by jsalmon
Fri Nov 11, 2022 4:13 pm
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5572

Re: Web Forms retrieval locale issue

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
by jsalmon
Wed Nov 09, 2022 9:26 am
Forum: Main Forum
Topic: Setting up Email - requires running Services?
Replies: 1
Views: 1351

Re: Setting up Email - requires running Services?

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 ...
by jsalmon
Mon Sep 26, 2022 12:43 pm
Forum: Main Forum
Topic: When I click on eServices on open dental gives error
Replies: 1
Views: 1210

Re: When I click on eServices on open dental gives error

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:...
by jsalmon
Thu Sep 22, 2022 10:49 am
Forum: Developers
Topic: ReportingForRDL folder missing
Replies: 10
Views: 5273

Re: ReportingForRDL folder missing

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.
by jsalmon
Wed Sep 14, 2022 4:40 pm
Forum: Main Forum
Topic: print labels for insurance carrier
Replies: 1
Views: 1265

Re: print labels for insurance carrier

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 ...
by jsalmon
Wed Sep 14, 2022 4:26 pm
Forum: Main Forum
Topic: Multiple currencies
Replies: 1
Views: 1235

Re: Multiple currencies

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
by jsalmon
Wed Sep 07, 2022 1:54 pm
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5572

Re: Web Forms retrieval locale issue

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) ...
by jsalmon
Fri Sep 02, 2022 1:39 pm
Forum: Developers
Topic: Plugin won't load in debugger (customer db)
Replies: 7
Views: 5062

Re: Plugin won't load in debugger (customer db)

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.
by jsalmon
Fri Jul 29, 2022 5:23 pm
Forum: Advanced Topics
Topic: Billing Prov NPI must be a 10 digital number error
Replies: 4
Views: 13208

Re: Billing Prov NPI must be a 10 digital number error

Cause certain formats require certain things. Not all formats have the same requirements.
by jsalmon
Fri Jul 29, 2022 5:15 pm
Forum: Developers
Topic: Strategies to improve Middle Tier performance
Replies: 2
Views: 4343

Re: Strategies to improve Middle Tier performance

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...
by jsalmon
Fri Jul 29, 2022 4:57 pm
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5572

Re: Web Forms retrieval locale issue

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 ...
by jsalmon
Wed Apr 06, 2022 12:46 pm
Forum: Developers
Topic: Visual Studio 2022 Designer won't load
Replies: 1
Views: 4140

Re: Visual Studio 2022 Designer won't load

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...
by jsalmon
Wed Mar 31, 2021 1:28 pm
Forum: Developers
Topic: Multiple Hook Requests
Replies: 6
Views: 14375

Re: Multiple Hook Requests

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...
by jsalmon
Tue Mar 30, 2021 3:51 pm
Forum: Developers
Topic: Multiple Hook Requests
Replies: 6
Views: 14375

Re: Multiple Hook Requests

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). ...
by jsalmon
Tue Dec 17, 2019 9:07 am
Forum: Sharing
Topic: File Sharing Re-enabled
Replies: 1
Views: 14250

Re: File Sharing Re-enabled

File sharing has been turned back on as of December 17th, 2019.
by jsalmon
Wed Dec 04, 2019 9:14 am
Forum: Sharing
Topic: File Sharing Re-enabled
Replies: 1
Views: 14250

File Sharing Re-enabled

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.
by jsalmon
Wed Jun 19, 2019 10:06 am
Forum: Main Forum
Topic: Appointment book printing
Replies: 2
Views: 4871

Re: Appointment book printing

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
by jsalmon
Fri Jun 14, 2019 10:20 am
Forum: Main Forum
Topic: Auto Code Exit Logic Bug
Replies: 1
Views: 3834

Re: Auto Code Exit Logic Bug

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...
by jsalmon
Mon Jun 10, 2019 3:14 pm
Forum: Main Forum
Topic: Colors
Replies: 2
Views: 4309

Re: Colors

It sounds like you are referring to what we call Proc Appt Colors.
https://www.opendental.com/manual/apptv ... olors.html
by jsalmon
Fri Jun 07, 2019 9:09 am
Forum: Advanced Topics
Topic: OneDrive
Replies: 3
Views: 8458

Re: OneDrive

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.
by jsalmon
Fri Jun 07, 2019 9:06 am
Forum: Advanced Topics
Topic: OneDrive
Replies: 3
Views: 8458

Re: OneDrive

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...
by jsalmon
Thu Jun 06, 2019 5:02 pm
Forum: Main Forum
Topic: Perio exam/charting showing "DOC" instead of hygienist
Replies: 2
Views: 4453

Re: Perio exam/charting showing "DOC" instead of hygienist

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...
by jsalmon
Thu Jun 06, 2019 4:42 pm
Forum: Developers
Topic: Document.Import with a document description
Replies: 2
Views: 7330

Re: Document.Import with a document description

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...
by jsalmon
Tue May 28, 2019 6:43 am
Forum: Main Forum
Topic: Importing emails from gmail.
Replies: 5
Views: 8089

Re: Importing emails from gmail.

Correct, POP3 is currently supported while IMAP is feature request #3276
https://www.opendental.com/manual/featurerequests.html
by jsalmon
Thu May 23, 2019 9:25 am
Forum: Main Forum
Topic: OD crashes when importing scanned documents
Replies: 5
Views: 7906

Re: OD crashes when importing scanned documents

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...
by jsalmon
Tue May 21, 2019 2:21 pm
Forum: Developers
Topic: Bad Database Design Spotlight
Replies: 8
Views: 17134

Re: Bad Database Design Spotlight

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.
by jsalmon
Tue May 21, 2019 9:08 am
Forum: Developers
Topic: Bad Database Design Spotlight
Replies: 8
Views: 17134

Re: Bad Database Design Spotlight

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 ...
by jsalmon
Mon May 13, 2019 2:03 pm
Forum: Developers
Topic: DB Export of QueryList Examples
Replies: 3
Views: 6116

Re: DB Export of QueryList Examples

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).
by jsalmon
Thu May 09, 2019 9:01 am
Forum: Main Forum
Topic: How often do I need to update
Replies: 5
Views: 8002

Re: How often do I need to update

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...
by jsalmon
Wed May 08, 2019 8:59 am
Forum: Main Forum
Topic: How often do I need to update
Replies: 5
Views: 8002

Re: How often do I need to update

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...
by jsalmon
Thu May 02, 2019 9:36 am
Forum: Main Forum
Topic: Importing emails from gmail.
Replies: 5
Views: 8089

Re: Importing emails from gmail.

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:...
by jsalmon
Fri Apr 26, 2019 8:16 am
Forum: Main Forum
Topic: Multiple Cell numbers
Replies: 1
Views: 3669

Re: Multiple Cell numbers

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
by jsalmon
Fri Apr 19, 2019 9:11 am
Forum: Developers
Topic: Need Help with HL7 out bound message
Replies: 1
Views: 3862

Re: Need Help with HL7 out bound message

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/
by jsalmon
Wed Apr 17, 2019 11:36 am
Forum: Developers
Topic: Link on New Patient Reminder Text to fill forms
Replies: 1
Views: 3709

Re: Link on New Patient Reminder Text to fill forms

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
by jsalmon
Mon Apr 15, 2019 12:36 pm
Forum: Advanced Topics
Topic: nonhumans submitting webforms
Replies: 3
Views: 7808

Re: nonhumans submitting webforms

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...
by jsalmon
Mon Apr 15, 2019 9:11 am
Forum: Advanced Topics
Topic: nonhumans submitting webforms
Replies: 3
Views: 7808

Re: nonhumans submitting webforms

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...
by jsalmon
Thu Apr 11, 2019 12:33 pm
Forum: Developers
Topic: Dental KPI & Metrics
Replies: 2
Views: 5381

Re: Dental KPI & Metrics

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
by jsalmon
Wed Apr 10, 2019 9:37 am
Forum: Developers
Topic: Integration Clinic Data with Central Datastore
Replies: 1
Views: 3839

Re: Integration Clinic Data with Central Datastore

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...
by jsalmon
Fri Mar 22, 2019 5:00 pm
Forum: Advanced Topics
Topic: 19.1 beta exception on AWS EC2 server
Replies: 10
Views: 14918

Re: 19.1 beta exception on AWS EC2 server

Try building in Release mode? Looks like demo credentials were sent over.
by jsalmon
Fri Mar 22, 2019 1:57 pm
Forum: Advanced Topics
Topic: 19.1 beta exception on AWS EC2 server
Replies: 10
Views: 14918

Re: 19.1 beta exception on AWS EC2 server

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
by jsalmon
Mon Mar 18, 2019 2:55 pm
Forum: Advanced Topics
Topic: Debugging mySQL Error
Replies: 1
Views: 5080

Re: Debugging mySQL Error

Modify the sql_mode parameter to either a blank string or NO_AUTO_CREATE_USER.
by jsalmon
Mon Mar 18, 2019 9:57 am
Forum: Advanced Topics
Topic: "Server Time" for timeclock
Replies: 4
Views: 8242

Re: "Server Time" for timeclock

I'll see about getting this information into the following page in our manual.
https://www.opendental.com/manual/manage.html
by jsalmon
Mon Mar 18, 2019 9:16 am
Forum: Advanced Topics
Topic: "Server Time" for timeclock
Replies: 4
Views: 8242

Re: "Server Time" for timeclock

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...
by jsalmon
Thu Feb 28, 2019 10:51 am
Forum: Main Forum
Topic: My Hygienist Deleted a Perio Exam Chart and...
Replies: 6
Views: 9018

Re: My Hygienist Deleted a Perio Exam Chart and...

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. :D
https://www.opendental.com/manual/permissions.html
by jsalmon
Thu Feb 28, 2019 9:21 am
Forum: Main Forum
Topic: My Hygienist Deleted a Perio Exam Chart and...
Replies: 6
Views: 9018

Re: My Hygienist Deleted a Perio Exam Chart and...

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?
by jsalmon
Thu Feb 28, 2019 9:17 am
Forum: Main Forum
Topic: My Hygienist Deleted a Perio Exam Chart and...
Replies: 6
Views: 9018

Re: My Hygienist Deleted a Perio Exam Chart and...

We typically ask the user if they are sure first before deleting things, I'll create a ticket for this.
by jsalmon
Tue Feb 12, 2019 5:00 pm
Forum: Advanced Topics
Topic: human readable in MySQL
Replies: 5
Views: 9233

Re: human readable in MySQL

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...
by jsalmon
Tue Feb 12, 2019 9:28 am
Forum: Main Forum
Topic: Security - Only edit insurance adjustments for current day?
Replies: 3
Views: 5374

Re: Security - Only edit insurance adjustments for current d

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...
by jsalmon
Tue Feb 12, 2019 9:10 am
Forum: Advanced Topics
Topic: human readable in MySQL
Replies: 5
Views: 9233

Re: human readable in MySQL

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#.
by jsalmon
Mon Feb 11, 2019 10:07 am
Forum: Main Forum
Topic: Query- Partial Signature
Replies: 2
Views: 4426

Re: Query- Partial Signature

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".
by jsalmon
Mon Feb 11, 2019 10:03 am
Forum: Main Forum
Topic: Security - Only edit insurance adjustments for current day?
Replies: 3
Views: 5374

Re: Security - Only edit insurance adjustments for current d

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
by jsalmon
Tue Feb 05, 2019 9:08 am
Forum: Main Forum
Topic: Suggestions for general email usage through Open Dental?
Replies: 4
Views: 5829

Re: Suggestions for general email usage through Open Dental?

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...
by jsalmon
Tue Feb 05, 2019 8:59 am
Forum: Main Forum
Topic: Invalid Backup Path Error
Replies: 1
Views: 3448

Re: Invalid Backup Path Error

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...
by jsalmon
Wed Jan 30, 2019 8:59 am
Forum: Main Forum
Topic: Emails not working.
Replies: 4
Views: 6661

Re: Emails not working.

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...
by jsalmon
Tue Jan 29, 2019 4:35 pm
Forum: Main Forum
Topic: Emails not working.
Replies: 4
Views: 6661

Re: Emails not working.

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...
by jsalmon
Mon Jan 28, 2019 10:49 am
Forum: Advanced Topics
Topic: CEMT over Middle Tier
Replies: 12
Views: 15840

Re: CEMT over Middle Tier

Let me know what action you were taking prior to getting that error if you need any help tracking it down.
by jsalmon
Mon Jan 28, 2019 10:29 am
Forum: Advanced Topics
Topic: CEMT over Middle Tier
Replies: 12
Views: 15840

Re: CEMT over Middle Tier

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...
by jsalmon
Mon Jan 28, 2019 10:14 am
Forum: Advanced Topics
Topic: Windows update caused problems
Replies: 3
Views: 8197

Re: Windows update caused problems

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...
by jsalmon
Mon Jan 28, 2019 10:10 am
Forum: Advanced Topics
Topic: CEMT over Middle Tier
Replies: 12
Views: 15840

Re: CEMT over Middle Tier

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
by jsalmon
Fri Jan 25, 2019 9:00 am
Forum: Developers
Topic: Add Patient Fields in Date data type
Replies: 1
Views: 3842

Re: Add Patient Fields in Date data type

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
by jsalmon
Tue Jan 22, 2019 12:28 pm
Forum: Developers
Topic: Open Dental V16
Replies: 1
Views: 3583

Re: Open Dental V16

Hello test,
There was no trial version for v16.
by jsalmon
Sun Jan 13, 2019 7:14 am
Forum: Advanced Topics
Topic: Avoiding server conflicts
Replies: 13
Views: 16663

Re: Avoiding server conflicts

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...
by jsalmon
Tue Jan 08, 2019 10:04 am
Forum: Advanced Topics
Topic: Avoiding server conflicts
Replies: 13
Views: 16663

Re: Avoiding server conflicts

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.
by jsalmon
Tue Jan 08, 2019 9:26 am
Forum: Main Forum
Topic: Changing deceased account Guantor
Replies: 5
Views: 6927

Re: Changing deceased account Guantor

...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 ...
by jsalmon
Mon Jan 07, 2019 9:08 am
Forum: Advanced Topics
Topic: Avoiding server conflicts
Replies: 13
Views: 16663

Re: Avoiding server conflicts

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 ...
by jsalmon
Thu Jan 03, 2019 9:25 am
Forum: Advanced Topics
Topic: Possible bug 18.4.10 beta
Replies: 2
Views: 6078

Re: Possible bug 18.4.10 beta

I see how this could happen sometimes. I'll create a bug ticket and get someone on it ASAP.
by jsalmon
Wed Jan 02, 2019 2:18 pm
Forum: Developers
Topic: OD 18.4 beta runtime error
Replies: 8
Views: 14205

Re: OD 18.4 beta runtime error

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).
by jsalmon
Wed Jan 02, 2019 1:59 pm
Forum: Developers
Topic: OD 18.4 beta runtime error
Replies: 8
Views: 14205

Re: OD 18.4 beta runtime error

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.
by jsalmon
Wed Jan 02, 2019 12:28 pm
Forum: Developers
Topic: OD 18.4 beta runtime error
Replies: 8
Views: 14205

Re: OD 18.4 beta runtime error

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...
by jsalmon
Fri Dec 28, 2018 5:16 pm
Forum: Main Forum
Topic: 2019 CDT Codes...Cleanings Category and Space Maintainers?
Replies: 5
Views: 7349

Re: 2019 CDT Codes...Cleanings Category and Space Maintainer

I'll have someone look into this. What version of Open Dental are you using?
by jsalmon
Tue Dec 18, 2018 2:53 pm
Forum: Developers
Topic: Compiler errors in the latest code online.
Replies: 7
Views: 9197

Re: Compiler errors in the latest code online.

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...
by jsalmon
Mon Dec 17, 2018 2:16 pm
Forum: Developers
Topic: Compiler errors in the latest code online.
Replies: 7
Views: 9197

Re: Compiler errors in the latest code online.

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...
by jsalmon
Sun Dec 16, 2018 7:16 am
Forum: Developers
Topic: Compiler errors in the latest code online.
Replies: 7
Views: 9197

Re: Compiler errors in the latest code online.

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...
by jsalmon
Fri Dec 14, 2018 4:24 pm
Forum: Developers
Topic: Compiler errors in the latest code online.
Replies: 7
Views: 9197

Re: Compiler errors in the latest code online.

What's one of the errors (or several of them)?
by jsalmon
Fri Dec 14, 2018 4:22 pm
Forum: Main Forum
Topic: Appointment views - problem
Replies: 4
Views: 6082

Re: Appointment views - problem

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
by jsalmon
Fri Dec 14, 2018 9:05 am
Forum: Developers
Topic: 18.4 Conversion corrupted DB
Replies: 5
Views: 7903

Re: 18.4 Conversion corrupted DB

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...
by jsalmon
Thu Dec 13, 2018 4:18 pm
Forum: Developers
Topic: SVN Guest Credentials
Replies: 0
Views: 11940

SVN Guest Credentials

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
by jsalmon
Thu Dec 13, 2018 9:16 am
Forum: Main Forum
Topic: Login required for OD SVN server?
Replies: 3
Views: 5201

Re: Login required for OD SVN server?

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
by jsalmon
Thu Dec 13, 2018 9:07 am
Forum: Main Forum
Topic: Appointment views - problem
Replies: 4
Views: 6082

Re: Appointment views - problem

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.
by jsalmon
Wed Dec 12, 2018 3:04 pm
Forum: Main Forum
Topic: Appointment views - problem
Replies: 4
Views: 6082

Re: Appointment views - problem

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...
by jsalmon
Thu Dec 06, 2018 2:43 pm
Forum: Developers
Topic: Question about Appointment table
Replies: 2
Views: 4484

Re: Question about Appointment table

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...
by jsalmon
Tue Dec 04, 2018 9:47 am
Forum: Developers
Topic: Backward Compatible-Issue PrefC.GetString & PrefC.GetInt
Replies: 3
Views: 5407

Re: Backward Compatible-Issue PrefC.GetString & PrefC.GetInt

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...
by jsalmon
Mon Dec 03, 2018 10:30 am
Forum: Developers
Topic: Backward Compatible-Issue PrefC.GetString & PrefC.GetInt
Replies: 3
Views: 5407

Re: Backward Compatible-Issue PrefC.GetString & PrefC.GetInt

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...
by jsalmon
Fri Nov 30, 2018 1:28 pm
Forum: Main Forum
Topic: Unable to view images
Replies: 1
Views: 3545

Re: Unable to view images

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
by jsalmon
Mon Nov 26, 2018 4:19 pm
Forum: Main Forum
Topic: Getting error while fetching data by query from middletier
Replies: 2
Views: 4752

Re: Getting error while fetching data by query from middleti

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...
by jsalmon
Fri Nov 23, 2018 9:43 am
Forum: Main Forum
Topic: Getting error while fetching data by query from middletier
Replies: 2
Views: 4752

Re: Getting error while fetching data by query from middleti

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
by jsalmon
Fri Nov 23, 2018 9:11 am
Forum: Developers
Topic: Plugins and middle tier
Replies: 1
Views: 3958

Re: Plugins and middle tier

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
by jsalmon
Sun Nov 18, 2018 10:32 am
Forum: Developers
Topic: Plugin access to forms
Replies: 2
Views: 4603

Re: Plugin access to forms

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 ...
by jsalmon
Sat Nov 17, 2018 7:51 am
Forum: Developers
Topic: Plugin access to forms
Replies: 2
Views: 4603

Re: Plugin access to forms

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...
by jsalmon
Tue Nov 13, 2018 4:28 pm
Forum: Main Forum
Topic: Add column for assistant busy or not?
Replies: 1
Views: 3366

Re: Add column for assistant busy or not?

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
by jsalmon
Wed Nov 07, 2018 2:32 pm
Forum: Developers
Topic: Security permissions
Replies: 2
Views: 4739

Re: Security permissions

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...
by jsalmon
Fri Nov 02, 2018 11:18 am
Forum: Developers
Topic: ImageFolder sometimes empty
Replies: 1
Views: 3665

Re: ImageFolder sometimes empty

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 (...
by jsalmon
Fri Nov 02, 2018 11:14 am
Forum: Developers
Topic: Minimum target Open Dental/Windows versions
Replies: 1
Views: 3773

Re: Minimum target Open Dental/Windows versions

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...
by jsalmon
Mon Oct 29, 2018 9:36 am
Forum: Developers
Topic: Access to Open Dental 18.1 (or other builds)
Replies: 9
Views: 11259

Re: Access to Open Dental 18.1 (or other builds)

...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 ...
by jsalmon
Fri Oct 26, 2018 1:36 pm
Forum: Advanced Topics
Topic: Upgrading to MySQL 8.0
Replies: 5
Views: 9279

Re: Upgrading to MySQL 8.0

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
by jsalmon
Fri Oct 26, 2018 8:57 am
Forum: Advanced Topics
Topic: Upgrading to MySQL 8.0
Replies: 5
Views: 9279

Re: Upgrading to MySQL 8.0

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 :D
by jsalmon
Fri Oct 26, 2018 8:54 am
Forum: Advanced Topics
Topic: Upgrading to MySQL 8.0
Replies: 5
Views: 9279

Re: Upgrading to MySQL 8.0

...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...
by jsalmon
Sun Oct 21, 2018 7:06 am
Forum: Developers
Topic: Access to Open Dental 18.1 (or other builds)
Replies: 9
Views: 11259

Re: Access to Open Dental 18.1 (or other builds)

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...
by jsalmon
Tue Oct 16, 2018 12:55 pm
Forum: Main Forum
Topic: eservices scheduler
Replies: 2
Views: 4681

Re: eservices scheduler

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...
by jsalmon
Tue Oct 16, 2018 12:48 pm
Forum: Main Forum
Topic: eservices scheduler
Replies: 2
Views: 4681

Re: eservices scheduler

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...
by jsalmon
Thu Oct 11, 2018 11:48 am
Forum: Developers
Topic: Cannot connect to databse
Replies: 5
Views: 7286

Re: Cannot connect to databse

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 ...
by jsalmon
Thu Oct 11, 2018 9:23 am
Forum: Developers
Topic: Cannot connect to databse
Replies: 5
Views: 7286

Re: Cannot connect to databse

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 ...
by jsalmon
Thu Oct 11, 2018 8:57 am
Forum: Developers
Topic: Cannot connect to databse
Replies: 5
Views: 7286

Re: Cannot connect to databse

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...
by jsalmon
Wed Oct 10, 2018 8:53 am
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 7933

Re: Create template database

We have done it multiple times. We are on monthly support. Check with the conversions department. There is a cost involved but they were able to give us just what you want when we opened satellites. drtmz I did not know that was a thing. Very cool: https://www.opendental.com/site/conversionssplit.h...
by jsalmon
Tue Oct 09, 2018 4:40 pm
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 7933

Re: Create template database

Right, there is no "export settings" or "create template database from live database" currently. That would be a feature request.
https://www.opendental.com/manual/featurerequests.html
by jsalmon
Fri Oct 05, 2018 11:01 am
Forum: Advanced Topics
Topic: UPDATED VER 18
Replies: 1
Views: 5163

Re: UPDATED VER 18

Do you by chance have your year set to only show two digits in your region and language settings? If so then you'll want to keep an eye on the bug that was just reported to us: Providers, blankTerm Dates and Birthdates set to 01/01/2001 if region settings use a two digit year format. http://opendent...
by jsalmon
Tue Oct 02, 2018 5:57 pm
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 7933

Re: Create template database

I would just take the blank database from the trial, don't enter any registration key into it, set it up however you want and then distribute copies of that database to anyone in the world.
by jsalmon
Tue Oct 02, 2018 9:01 am
Forum: Main Forum
Topic: Win 7 problems
Replies: 3
Views: 5390

Re: Win 7 problems

We're a 32bit application. We don't even have a 64bit version of the software to even release to customers so there is something else going on. Feel free to call support and we can look into it for you.
https://www.opendental.com/contact.html
by jsalmon
Wed Sep 26, 2018 9:09 am
Forum: Main Forum
Topic: New OD feature?
Replies: 3
Views: 5150

Re: New OD feature?

Block a Number To block incoming text messages from a specific mobile number, right click on the text message, then click Block Number. The sender will see the text message as delivered, but it will not appear in Open Dental. Blocked messages cannot be recovered. https://www.opendental.com/manual/t...
by jsalmon
Tue Sep 25, 2018 1:19 pm
Forum: Main Forum
Topic: Win 7 problems
Replies: 3
Views: 5390

Re: Win 7 problems

Clicking on a user within Open Dental only sets the focus of the form to the Password text box so that you can instantly start typing in your password. I highly doubt that is taking up all of your CPU so it is probably something else running in the background (e.g. filling up cached items, something...
by jsalmon
Mon Sep 24, 2018 8:58 pm
Forum: Developers
Topic: Access to Open Dental 18.1 (or other builds)
Replies: 9
Views: 11259

Re: Access to Open Dental 18.1 (or other builds)

That is correct. We don't have a public repository that hosts every version in executable format if that is what you're looking for.
by jsalmon
Sun Sep 23, 2018 4:19 pm
Forum: Main Forum
Topic: Automatic Lab slip?
Replies: 2
Views: 4682

Re: Automatic Lab slip?

Agreed, that would be a nice feature request addition to the "automation" functionality built into Open Dental.
https://www.opendental.com/manual/automation.html
https://www.opendental.com/manual/featurerequests.html
by jsalmon
Sun Sep 23, 2018 4:17 pm
Forum: Main Forum
Topic: home Back up
Replies: 3
Views: 6175

Re: home Back up

Which you have to turn your MySQL service back on in order to do so. Another way would be to open up your Windows "Service Manager" > find the MySQL service in the list of services > right click > Properties > the "Path to executable" value should start with a path to a .exe file followed by a space...
by jsalmon
Sun Sep 23, 2018 4:11 pm
Forum: Main Forum
Topic: school exuse slips
Replies: 3
Views: 6750

Re: school exuse slips

I highly recommend using the sheets framework. I think our new trial version has a built-in "patient excuse form" so you might want to check that out and consider using it as a starting point for your school excuse form. The sheets framework is getting more and more robust (in the middle of adding a...
by jsalmon
Sun Sep 23, 2018 4:02 pm
Forum: Developers
Topic: Access to Open Dental 18.1 (or other builds)
Replies: 9
Views: 11259

Re: Access to Open Dental 18.1 (or other builds)

Every version of Open Dental is publicly available. If you are looking into building your own stable or beta versions then I highly recommend checking out a revision that has a specific version as the commit log. These are officially released builds of Open Dental that are safe to use (not in the mi...
by jsalmon
Fri Sep 21, 2018 1:59 pm
Forum: Main Forum
Topic: altered progress notes
Replies: 3
Views: 5539

Re: altered progress notes

The only thing that I'm aware of that does that is the Audit Trail: Integrity of Data: In version 14.1 and greater, Open Dental checks to verify the integrity of the audit trail data. Black log entries indicate trusted entries; meaning Open Dental has checked and no changes have been made to the log...
by jsalmon
Tue Sep 11, 2018 10:22 am
Forum: Main Forum
Topic: Tooth chart on treatment plan
Replies: 1
Views: 3865

Re: Tooth chart on treatment plan

Yes, you can customize your printed treatment plans by using our sheets framework.
https://www.opendental.com/manual/sheetstreatplan.html
by jsalmon
Tue Aug 28, 2018 12:41 pm
Forum: Main Forum
Topic: HTML code in emails
Replies: 7
Views: 9711

Re: HTML code in emails

The build portion of the version ([major].[minor].[build]) is a poor judge of where a version is within the "cycle". A better indicator would be the date that a version was released in comparison to right now. E.g. v18.2.1 was released on 7/16/2018 which means that v18.2 has been released to the pub...
by jsalmon
Mon Aug 27, 2018 11:12 am
Forum: Main Forum
Topic: Backing up the A-Z folder
Replies: 7
Views: 12618

Re: Backing up the A-Z folder

Feels like a file is in use and waiting for the resource to be "released" but that kind of issue wouldn't typically happen every time you tried to make a backup...
by jsalmon
Mon Aug 27, 2018 9:12 am
Forum: Advanced Topics
Topic: Office Network Build series
Replies: 3
Views: 8231

Re: Office Network Build series

That would be most generous of you to share. There are countless people that attempt what you described and you could save many hours of headache by sharing your experience. Commended.
by jsalmon
Wed Aug 22, 2018 11:21 am
Forum: Main Forum
Topic: HTML code in emails
Replies: 7
Views: 9711

Re: HTML code in emails

HTML templates are not integrated with the new HTML code in emails that was implemented in version 18.2. However, now that we have implemented the technology behind allowing HTML in emails feature requests like #7575 "eReminders & eConfirmations use HTML email", which are template related, can be co...
by jsalmon
Thu Aug 16, 2018 4:29 pm
Forum: Main Forum
Topic: Space maintainer graphics
Replies: 1
Views: 3719

Re: Space maintainer graphics

That would be feature request #2528. I recommend voting on it so that you are notified when it becomes available.
https://www.opendental.com/manual/featurerequests.html
by jsalmon
Wed Aug 01, 2018 9:21 am
Forum: Main Forum
Topic: Order/Inventory management
Replies: 1
Views: 4359

Re: Order/Inventory management

Just noting that we have a built-in supply / inventory system within Open Dental if that is what you are looking for.
https://www.opendental.com/manual/supplyinventory.html
by jsalmon
Fri Jul 20, 2018 9:02 am
Forum: Advanced Topics
Topic: Resetting ok to Text Field
Replies: 3
Views: 6639

Re: Resetting ok to Text Field

Open Dental doesn't give out queries that manipulate data. All data manipulation should be within the program for security purposes. Therefore a feature request would be required for a tool within the software to do it.
http://www.opendental.com/manual/featurerequests.html
by jsalmon
Thu Jul 19, 2018 2:52 pm
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29236

Re: Opening OpenDental.sln errors

Tried creating an sgen.exe.config file and placed it in every folder where there is an sgen.exe file... still same error showed up. Did you also try the quick fix from that section as well? The quick fix for this error is to right click the OD project, properties, build tab, and at the bottom, chan...
by jsalmon
Thu Jul 19, 2018 9:33 am
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29236

Re: Opening OpenDental.sln errors

The entire purpose of the Build section at the bottom of that page is to help developers get past common build errors. I'd say it's a good idea to try it out. What have you got to lose?
by jsalmon
Wed Jul 18, 2018 8:52 am
Forum: Developers
Topic: Opening OpenDental.sln errors
Replies: 17
Views: 29236

Re: Opening OpenDental.sln errors

The "Error: Mixed mode assembly" section on this page might help you. http://www.opendental.com/manual/sourcecode.html Sometimes this error happens when the target framework is not compatible. We did upgrade to .NET 4.5.2 in v18.2 and up, maybe that's giving you grief for some reason. I would expect...
by jsalmon
Mon Jul 16, 2018 11:22 am
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

Re: Strange Unhandled Exception

...If using a 3rd party software to make backups of Open Dental database files, make sure to stop the MySQL service in order to get a guaranteed good backup (tables won't be in use). Backups made from within Open Dental will not have this problem because they utilize MySQL in order to make the back...
by jsalmon
Tue Jul 10, 2018 10:20 am
Forum: Main Forum
Topic: override context menu and add new menuItem
Replies: 15
Views: 27629

Re: override context menu and add new menuItem

You shouldn't override it, you need to use the object "Sender" and loop through all it's controls and find "menuApt" and then add to it's MenuItems. Know that your new menu item will get wiped out when the user clicks the Appts module button so you'll probably need to add code that first checks to ...
by jsalmon
Mon Jul 09, 2018 12:49 pm
Forum: Developers
Topic: Find the User Who's Currently Logged In
Replies: 11
Views: 17000

Re: Find the User Who's Currently Logged In

You need to implement some sort of complicated Windows messaging system so the two "free standing" applications can talk to each other because how you are trying to user OpenDentBusiness isn't how applications talk to each other. You can't ask a standalone library (OpenDentBusiness.dll) who the curr...
by jsalmon
Mon Jul 09, 2018 9:36 am
Forum: Developers
Topic: Find the User Who's Currently Logged In
Replies: 11
Views: 17000

Re: Find the User Who's Currently Logged In

...The following code returns null for user and the second line throws and exception about being unable to connect to any of the specified MySQL hosts. Apparently there is more that I need to know... OD is running and I am logged in... All of those errors point to you not actually being logged into...
by jsalmon
Mon Jun 25, 2018 2:49 pm
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

Re: Strange Unhandled Exception

Although I did not stop mysql noone was logged in at the time of the backup. Open Dental doesn't technically need to be logged in to run queries, it simply needs to be running (e.g. a computer set as the "Computer Name to Receive New Email from" can download emails while no user is logged in). http...
by jsalmon
Mon Jun 25, 2018 2:46 pm
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

Re: Strange Unhandled Exception

Would it be possible for the back-up function to automatically stop the necessary services, back up, then restart them? Better for the average user. Yes, MySQL is just a typical service (on any Operating System) so whatever application you are using as the "back-up function" simply needs to get pri...
by jsalmon
Mon Jun 25, 2018 10:05 am
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

Re: Strange Unhandled Exception

A lot of "hot backups" will have this problem because the tables are still being used which runs the risk of having the tables flagged as corrupt. If using a 3rd party software to make backups of Open Dental database files, make sure to stop the MySQL service in order to get a guaranteed good backup...
by jsalmon
Mon Jun 25, 2018 9:52 am
Forum: Advanced Topics
Topic: bug not scrolling to bottom - view patient appts window
Replies: 2
Views: 5372

Re: bug not scrolling to bottom - view patient appts window

There is actually no scrolling functionality upon switching between family members so the scroll bar performs our default behavior of simply trying to stay at the last known value (sticks in the middle is the most accurate description of the current behavior). The bar will look like it's jumping to ...
by jsalmon
Fri Jun 22, 2018 9:00 am
Forum: Advanced Topics
Topic: Replication error in my.ini
Replies: 3
Views: 7453

Re: Replication error in my.ini

I'm most curious as to what your simultaneous connections are doing; Can you run the following query in MySQL Workbench when it's grinding to a halt and provide us the results? SHOW PROCESSLIST Also, maybe you simply just have that many workstations needing to connect and need to increase the amount...
by jsalmon
Thu Jun 14, 2018 9:08 am
Forum: Advanced Topics
Topic: Dictionary bug 18.1.20
Replies: 7
Views: 11168

Re: Dictionary bug 18.1.20

It only stops showing up for me when I don't right click on a misspelled word.
by jsalmon
Wed Jun 13, 2018 4:57 pm
Forum: Developers
Topic: mySQL connection problems
Replies: 3
Views: 16983

Re: mySQL connection problems

It's most likely your data connector. I just installed v8.0.11 the other day for testing purposes and I had to include "SslMode=none" in my connection args. You probably have to do the same plus remove something that is no longer supported (since your error is about an invalid argument).
by jsalmon
Wed Jun 13, 2018 8:36 am
Forum: Main Forum
Topic: StatementMainGrid
Replies: 1
Views: 3906

Re: StatementMainGrid

What version of Open Dental are you using? I hope you just need to update for the bug fix "Sheet Printing, Windows 10 update 1803 caused fonts on sheets to be incorrect sometimes." that was released with v17.4.70 and v18.1.11.
http://opendentalsoft.com:1942/ODBugTra ... .aspx#17.4
by jsalmon
Tue Jun 12, 2018 4:45 pm
Forum: Developers
Topic: mySQL connection problems
Replies: 3
Views: 16983

Re: mySQL connection problems

Quite a bit of people have been having MySQL problems after a Windows update: http://opendentalsoft.com/forum/viewtopic.php?f=1&t=6811 However, "An invalid argument was supplied" makes it sound like a MySQL change of sorts. What is the exact version of MySQL that you are using and what are the argum...
by jsalmon
Fri Jun 08, 2018 9:11 am
Forum: Developers
Topic: Plugin Distribution/Upgrade
Replies: 3
Views: 6106

Re: Plugin Distribution/Upgrade

1) How does that Plugin's assemblies get onto the machine (e.g. are all of the Plugins under Setup -> Program Links shipped with OD?)? Stock Program Links, or Program Bridges, are treated on a case by case basis. Some don't require any assemblies and just monitor files on the harddrive so all the u...
by jsalmon
Thu May 31, 2018 11:08 am
Forum: Advanced Topics
Topic: Turn Off Auto Planned Appt Prompt beta 18.1
Replies: 2
Views: 5425

Re: Turn Off Auto Planned Appt Prompt beta 18.1

Setup > Chart > Chart Preferences > Chart tab > Behavior subtab > "Prompt for Planned Appointment" check box at the very bottom.
by jsalmon
Mon May 28, 2018 2:26 pm
Forum: Main Forum
Topic: Supernumeraries
Replies: 1
Views: 4468

Re: Supernumeraries

Procedures for supernumerary teeth do not show on the Graphical Tooth Chart, but they do get billed to insurance. To show a supernumerary tooth on the Graphical Tooth Chart, use the Draw tool to draw in a tooth.
http://www.opendental.com/manual/supern ... teeth.html
by jsalmon
Mon May 28, 2018 7:01 am
Forum: Main Forum
Topic: Faster backup?
Replies: 1
Views: 3799

Re: Faster backup?

That script is fine as long as all of your tables are of type MyISAM (which Open Dental prefers). The stopping of the mysql service is important so that you do not run the chance of getting a corrupt table (good job including the stop and start commands). The following query will show you a list of ...
by jsalmon
Mon May 21, 2018 11:02 am
Forum: Main Forum
Topic: can't connect to mysql host after windows update
Replies: 19
Views: 39355

Re: can't connect to mysql host after windows update

For whatever reason my MySQL service didn't automatically start after the most recent Windows Update and I had to manually go into my Services and start the MySQL service.
by jsalmon
Tue Apr 24, 2018 3:56 pm
Forum: Advanced Topics
Topic: Beta v 17.4.59 Error - Reports -pref
Replies: 10
Views: 17914

Re: Beta v 17.4.59 Error - Reports -pref

The foolproof way would be to use a backup that you have prior to the version with which you are partially upgraded to. The hard and dangerous way would be to look at each query that gets run in each of our version methods and determine if you need that query to be run or not and then manually run t...
by jsalmon
Tue Apr 24, 2018 1:51 pm
Forum: Advanced Topics
Topic: Beta v 17.4.59 Error - Reports -pref
Replies: 10
Views: 17914

Re: Beta v 17.4.59 Error - Reports -pref

If you're tired of getting this problem, a workaround would be to always utilize the SVN Update to Revision option instead of the normal Update option and then always choose a revision that has Version X.X.X.X as the commit log. That is an official release commit which would make it so that you aren...
by jsalmon
Fri Apr 20, 2018 1:52 pm
Forum: Main Forum
Topic: Web Forms not filling out static text
Replies: 1
Views: 3560

Re: Web Forms not filling out static text

That is a neat idea! Traditionally static text fields have their "tags" replaced just prior to displaying to the user. Thus we've always told our customers to type them out by hand for sheets that are designed to be Web Forms because we don't have a way to communicate back to the office in order to ...