Search found 55 matches

by jfd2
Fri Jun 10, 2022 4:00 pm
Forum: Main Forum
Topic: email not working
Replies: 7
Views: 3169

Re: email not working

@Gary, it might be easier to just add the outlook application to the 3rd party access list.
by jfd2
Fri Jun 10, 2022 2:45 pm
Forum: Main Forum
Topic: email not working
Replies: 7
Views: 3169

Re: email not working

As jmazzie said, this is due to the feature change of security. To solve it, login to your email from a browser: 1) turn on 2-factor. Goto your account (manage your account) and then click on secrity recommendations to set it up. 2) click on security on left menu and then click on App passwords. the...
by jfd2
Thu May 05, 2022 5:35 pm
Forum: Developers
Topic: Urgent: need help on the latest MYSQL connector dll tobe compiled
Replies: 1
Views: 3955

Re: Urgent: need help on the latest MYSQL connector dll tobe compiled

Hello all, I finally downgraded my mysql to 8.0.28 with manually installing of it. This is going to be an issue with the trend of dropping the current UTF8 (utf8mb3) inplementation. I think the latest mysql/mariadb are all using the utf8mb4 as the default and eventually opendental need to have a sol...
by jfd2
Wed May 04, 2022 12:33 pm
Forum: Developers
Topic: Urgent: need help on the latest MYSQL connector dll tobe compiled
Replies: 1
Views: 3955

Urgent: need help on the latest MYSQL connector dll tobe compiled

Hello All, I got into a situation that none of opendental works now. after investigating, I found that my Ubuntu server upgrade the mySQl server to the latest 8.0.29 from 8.0.28. which for some reason it errors out with "The Given Key Was Not Present In The Dictionary" Exception. They are certain pe...
by jfd2
Fri Sep 17, 2021 10:06 am
Forum: Main Forum
Topic: OD-Insight: A New Analytics and Intelligence Application with Opendental
Replies: 4
Views: 6454

Re: OD-Insight: A New Analytics and Intelligence Application with Opendental

@docholiday,

Hello Doc,

You can right click on any image and open in a new tab, it will be a full picture with all the details.

Thanks for your interest. It actually pretty easy to install and let me know if I can help.
by jfd2
Wed Sep 08, 2021 6:10 pm
Forum: Main Forum
Topic: OD-Insight: A New Analytics and Intelligence Application with Opendental
Replies: 4
Views: 6454

Re: OD-Insight: A New Analytics and Intelligence Application with Opendental

I am pleased to announce that OD-Insight 0.11 has been released and is available for download. This is a major release from 0.10 that adds a significant number of new features and improvements. If you have a previous release, here is a good time to upgrade!

Thanks for your interest and support!
by jfd2
Mon Aug 23, 2021 5:29 pm
Forum: Main Forum
Topic: Network freeze
Replies: 14
Views: 16348

Re: Network freeze

Hello Bak2 and all others have performance issues with mysql server, As these 2 weeks I have helped some offices to solve the mysql performance issues and I found out that the major problem is the mysql installation. In both 2 cases, they are using mysql 5.5 32bit on a powerful 64bit machine. The is...
by jfd2
Fri Aug 20, 2021 4:05 pm
Forum: Main Forum
Topic: Network freeze
Replies: 14
Views: 16348

Re: Network freeze

i think the parameter for key_buffer_size is wrong for your configuration and you need to change it ASAP to harness the machine power you have. you put it as key_buffer, i searched my db and there is no key_buffer variable (i am using 8.x through, use this to check: show variables like "key_buffer%"...
by jfd2
Thu Aug 19, 2021 4:11 am
Forum: Main Forum
Topic: OD-Insight: A New Analytics and Intelligence Application with Opendental
Replies: 4
Views: 6454

Re: OD-Insight: A New Analytics and Intelligence Application with Opendental

Hello all,

Just released a new version(v0.10). Major changes include the generation of PDFs for lab case, receipt, invoice and referral, in addition to lots of minor changes in UI.

Please download the latest if you are using OD-insight.

Thank you very much.
by jfd2
Tue Aug 17, 2021 7:32 pm
Forum: Main Forum
Topic: Network freeze
Replies: 14
Views: 16348

Re: Network freeze

Another thing might be quick for you is to tune your mysql if you have never done so. Most people use the default parameters which are only for minimum hardware settings and with current box setting there are lot of leeway if you tune it to increase the query performance. the following three made a ...
by jfd2
Mon Aug 16, 2021 9:46 pm
Forum: Main Forum
Topic: Network freeze
Replies: 14
Views: 16348

Re: Network freeze

I would say the 2nd server will make a difference if you put all the reporting related functions on the 2nd server. This is like the practice to put OLAP in another server in the industry. Of course, if you can identify the long running application then you might save the 2nd server. Basically: 1) s...
by jfd2
Sat Aug 07, 2021 11:03 am
Forum: Main Forum
Topic: OD-Insight: A New Analytics and Intelligence Application with Opendental
Replies: 4
Views: 6454

OD-Insight: A New Analytics and Intelligence Application with Opendental

Hello Opendental communities, With tons of data to parse through, it can be difficult to navigate patient history and understand your clinic's growth. That's why we'd like to introduce OD-Insight , an analytics and intelligence tool to streamline clinic operations . We have been developing OD-Insigh...
by jfd2
Wed Jan 13, 2021 4:50 pm
Forum: Developers
Topic: Opendental with mysql 8.x -- 1st try
Replies: 5
Views: 11974

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

Hello Everybody, After running 2 months of the OD 20.3.x with mysql 8.0.x, there are something to be noted in case anyone else going to try the new version of mysql: 1) We use lighthouse before for appointment reminders etc. It was working smoothly. Due to the upgrade of the mysql, the lighthouse wa...
by jfd2
Tue Nov 24, 2020 7:01 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

The schema change is a discipline, once starts, it might have some cry during the first 1-2 releases, but late on will smooth out. for the git move, I would think it would be better if done earlier since it will enhance your release strategies in addition to other benefits. I might be able to help i...
by jfd2
Tue Nov 24, 2020 6:13 pm
Forum: Developers
Topic: Opendental with mysql 8.x -- 1st try
Replies: 5
Views: 11974

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

Thanks for the reply. I noticed that while I was playing with it with inno engine. But if backup is the concern here, do we think the copy of db is the best way? I would think that with lots of unused databases must have some performance hits, in addition to the diskspace and fragmentation. In my ca...
by jfd2
Sun Nov 22, 2020 5:36 pm
Forum: Developers
Topic: Opendental with mysql 8.x -- 1st try
Replies: 5
Views: 11974

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

I checked the table type, they are still myisam types. long time ago I converted all tables to inno and opendental converted back automatically. Should I keep the myisam type or innoengine is supported?

Thanks.
by jfd2
Sat Nov 21, 2020 5:50 pm
Forum: Developers
Topic: Opendental with mysql 8.x -- 1st try
Replies: 5
Views: 11974

Opendental with mysql 8.x -- 1st try

Hello all, I have an initial try today with the opendental 20.3.44 to connect with the mysql8.0 (ubuntu 20lts default installation). here are the findings: 1) when using the native code without any changes, there is an error message "Retrieval of the RSA public key is not enabled for insecure connec...
by jfd2
Fri Nov 20, 2020 2:57 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

Some thoughts on the DB corruption since Dr Sparks mentioned that the maintenance time consumed. As myself an engineer in the bay area, have done lots of releases. It might be better to adopt a different release strategies to reduce the dev debt. Looks like you are on the quarterly release trains. i...
by jfd2
Fri Nov 20, 2020 10:39 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

Thank you both for the replies. good point that from now on if I checked out version, I will try to use the tag to avoid this issue. right now my next step is let the doctor play for several days with the new version and I will try to connect it to the mysql 8.0.
by jfd2
Fri Nov 20, 2020 8:33 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

Ok, I pulled the latest code 20.4.22 and then recompiled it. the issue magically gone. Is this due to some odd/even version strategies?
thanks.
by jfd2
Fri Nov 20, 2020 7:53 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

I reproduced this again using 20.4.21.0, which is the latest code I pulled as of yesterday. here are the observation: When db upgrade start, the message clearly stated that the upgrade is to 20.4.21.0, but as it finished, it bumped up to 20.4.22.0. So resetting or auto-increasing this number during ...
by jfd2
Thu Nov 19, 2020 10:32 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

Ok, did more on this today and got very puzzled. Basically I pulled the 20.4 branch and compiled it. then running it got the database upgrade. unfortunately the same thing happened. the error message is "app 20.4.21.0 less than db 20.4.22.0". I am wonder if my db has some issues previously exist tha...
by jfd2
Wed Nov 18, 2020 8:45 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

Actually I did not do anything unusual to come to that. after compiling and I run it directly from the release dir to test. then it started the db upgrade as expected, which is from 17.3.x to 20.3.x. At the end, it throws the version mismatch message and out. I guess if it is not a bug, then might b...
by jfd2
Tue Nov 17, 2020 8:57 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

thanks! that solved the compile issue and all dlls comiled. then it bumps into the app version lower than the db version (43 < 44 as it indicated).
by jfd2
Tue Nov 17, 2020 6:09 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

Looks like this error message is critical: Severity Code Description Project File Line Suppression State Error Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. OpenDentBusiness I:\dev\opende...
by jfd2
Mon Nov 16, 2020 5:41 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

thanks, I tried that and removed all unloadables and added all required dlls to the reference. but still got some complaints. looks like some of the required dlls not checked in.
by jfd2
Sat Nov 14, 2020 2:24 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

Repulled everything using a clean repo, here is what I got from the loading. Looks like I am missing some of the sub-projects in the code. anything I missed? Thanks! D:\Work\Shared Projects Subversion\EHR\EHR_20_3\EHR\xEHR.csproj : error : The project file could not be loaded. Could not find a part ...
by jfd2
Tue Nov 10, 2020 6:50 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

Re: compile 20.3 under VS2019

just pulled the code, no changes at all, but the Vs2019 made some changes to the project automatically. I did not digging to what it did. Thanks.
by jfd2
Tue Nov 10, 2020 3:27 pm
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26489

compile 20.3 under VS2019

Hello All, Sorry to bother everyone. Right now I am trying to compile and upgrade my systems and got some compiling errors. notably are all dlls not found, like codebase.dll, dataconnectbase,dll etc, total eight of them. I guess something wrong with the setup. here is my system info: windows 7 64 bi...
by jfd2
Sat Oct 28, 2017 8:50 pm
Forum: Developers
Topic: Unhandled exception from ProgramEntry
Replies: 1
Views: 4430

Unhandled exception from ProgramEntry

Hello All, WE got this once in a while, once it happened, we restarting OD and it will be fine for a while. then randomly this error will be thrown. we are on 17.2.30: Unhandled exception from ProgramEntry: There is no row at position 130. System.IndexOutOfRangeException at System.Data.RBTree`1.GetN...
by jfd2
Thu Sep 27, 2012 12:38 pm
Forum: Advanced Topics
Topic: help on the mysql version issue after upgraded ubuntu
Replies: 3
Views: 6947

help on the mysql version issue after upgraded ubuntu

Hello all,

we used to use the 10.04 LTS as our mysql server and today I upgraded it to 12.04. the issue is that the mysql version is upgraded to 5.5 and looks like the opendental is complaining and ask to "upgrade" it to 4.1. how should I by pass this?

Thanks very much for your help.

jfd
by jfd2
Sun Feb 06, 2011 2:33 pm
Forum: Main Forum
Topic: Help on insurance est
Replies: 4
Views: 4932

Re: Help on insurance est

thanks, I verifed that is 100 and still not working.

Also, I got another issue with the ins est. that there is a allowed amount for certain code was there. and I have no idea where was this was set. can you tell me which way to get ride of the allowed amount?

thanks

Jfd
by jfd2
Fri Jan 28, 2011 3:31 pm
Forum: Main Forum
Topic: Help on insurance est
Replies: 4
Views: 4932

Re: Help on insurance est

Thanks, Dr. Sparks. I checked all insurance categories and benefit cateogories. and looks like fine. but they are some code still zero, like D9110 (palliative) the percentage is always zero due to the percentage is zero. but I do not know where to change the percentage. i tried the code, cat etc and...
by jfd2
Thu Jan 27, 2011 7:28 pm
Forum: Main Forum
Topic: Help on insurance est
Replies: 4
Views: 4932

Help on insurance est

Hello all,

I just found out that some of the code the insurance estimate is always zero. and then cause the ins rem calculation wrong. please help on how to solve this?

thanks very much

jfd
by jfd2
Wed Jan 12, 2011 8:05 am
Forum: Advanced Topics
Topic: Help with the upgrade to 7.5
Replies: 5
Views: 6078

Re: Help with the upgrade to 7.5

thanks. I did that. for some reason, the directX is not working on those computers.
by jfd2
Thu Dec 23, 2010 12:07 pm
Forum: Advanced Topics
Topic: Help with the upgrade to 7.5
Replies: 5
Views: 6078

Re: Help with the upgrade to 7.5

Thank you very much, Dr. Sparks. That makes sense now.

As for the disappearance of the tooth chart on the left corner, is there anything related to the optimizing of the tooth chart? Any place that I can reset that?

Best Regards,

jfd
by jfd2
Wed Dec 22, 2010 3:36 pm
Forum: Advanced Topics
Topic: Help with the upgrade to 7.5
Replies: 5
Views: 6078

Help with the upgrade to 7.5

Hello all, Our office upgraded to 7.5 and it has been running for 2 days now. since we came from 5.x and we are trying to get familiar with all the new features. Here we have several thing got confused and please help. 1) in the claim insurance payment dialog. most of the time the "Total" button is ...
by jfd2
Tue Dec 21, 2010 11:45 am
Forum: Developers
Topic: Issue with the insurance payment in 7.5
Replies: 2
Views: 4159

Re: Issue with the insurance payment in 7.5

Sorry I just found out that this is due to the secruty setup. and just set it up and fixed.

Thanks a lot.

Jfd
by jfd2
Tue Dec 21, 2010 10:09 am
Forum: Developers
Topic: Issue with the insurance payment in 7.5
Replies: 2
Views: 4159

Re: Issue with the insurance payment in 7.5

Actually a lot of more button on that screen got the same message. like create check, supplemental etc. Could this be related to the new feature of insurance merge? AS i got another issue when I tried to delete a patient. it complained that there was an insurance, but clearly we did not attach any i...
by jfd2
Tue Dec 21, 2010 8:39 am
Forum: Developers
Topic: Issue with the insurance payment in 7.5
Replies: 2
Views: 4159

Issue with the insurance payment in 7.5

Hello, all, I just upgraded the clinic to 7.5 and started to using it today. one thing comes up that I am confused. In the claim, we usually enter the insurance payment by total. but with the 7.5 version. It seems that we cannot enter the payment. The error message we got is "Not authorized for insu...
by jfd2
Fri Dec 17, 2010 4:37 pm
Forum: Developers
Topic: Help on env/compile issue
Replies: 7
Views: 8363

Re: Help on env/compile issue

Ok, finally got this off. it is the directX versions on all those machines that are different. so I reinstalled the directX on all machines and recompiled the code. looks like it is fine now.

thanks.

jfd
by jfd2
Fri Dec 17, 2010 3:00 pm
Forum: Developers
Topic: Help on env/compile issue
Replies: 7
Views: 8363

Re: Help on env/compile issue

Another dummy question, do we need anything else, except the dotnet and all the compiled solution dir from the opendental. anything else did I miss?
by jfd2
Fri Dec 17, 2010 11:42 am
Forum: Developers
Topic: Help on env/compile issue
Replies: 7
Views: 8363

Re: Help on env/compile issue

i tried by changing all projects to targeting 3.5 and still make no difference when move to another machine.
by jfd2
Fri Dec 17, 2010 11:29 am
Forum: Developers
Topic: Help on env/compile issue
Replies: 7
Views: 8363

Re: Help on env/compile issue

Ok, I get little more. although not sure about the cause of my problem. since vs10 let you chose the target .net platform to run. i found out that 5 of the projects (rdlengine, rdlview, reportdesigner, xcodebase, xdatabaseIntegritycheck) aare all targeted 2.0 but all others are targeting 3.5? is thi...
by jfd2
Thu Dec 16, 2010 4:35 pm
Forum: Developers
Topic: Help on env/compile issue
Replies: 7
Views: 8363

Re: Help on env/compile issue

thanks for the reply, I actually copied the who dir from the dev machine to other machines. But I did a fold comparison and there was no difference between these OD folders. so if the dll is missing or wrong version, then must be some common ones somewhere.
by jfd2
Thu Dec 16, 2010 12:59 pm
Forum: Developers
Topic: Help on env/compile issue
Replies: 7
Views: 8363

Help on env/compile issue

Hello all, I compiled the 7.5 tree with vs express 2010 and it can be run on the dev machine. when I moved to two other machines, the opendental crashed right away. i even tried the debug version and still cannot see any message except the OS saying "the opendental is crashed etc". here are my env f...
by jfd2
Wed Sep 15, 2010 7:13 pm
Forum: Developers
Topic: Cannot compile in express 2010
Replies: 3
Views: 5157

Cannot compile in express 2010

Hello there, I just grabbed the 7.2 from the svn source and tried to compile it using C# express 2010 and failed. this is largely due to I do not have the 2008 studio on any of my machines now. the errors are: Warning 1 The referenced component 'CDT' could not be found. Warning 2 Could not resolve t...
by jfd2
Thu May 29, 2008 4:01 am
Forum: Main Forum
Topic: two offices in one OD db
Replies: 10
Views: 9095

Re: two offices in one OD db

that would be nice.

thanks.

jfd
by jfd2
Wed May 28, 2008 1:01 pm
Forum: Main Forum
Topic: two offices in one OD db
Replies: 10
Views: 9095

Re: two offices in one OD db

Looks like the clinic is now display in the patient/family module in the first screen. only when displayed in the edit mode. do we have anyway to add it there? we are still using 5.5 at this moment.

thanks a lot,

Jfd
by jfd2
Mon May 26, 2008 10:29 am
Forum: Main Forum
Topic: two offices in one OD db
Replies: 10
Views: 9095

Re: two offices in one OD db

Thanks a lot. It works great. I never know that was there.

jfd
by jfd2
Sun May 25, 2008 6:25 pm
Forum: Main Forum
Topic: two offices in one OD db
Replies: 10
Views: 9095

two offices in one OD db

Hello all, we have two office using the same database for a fewe days now, everything works fine except that we cannot send claim using the new office address since there is only place for practice. is this supposed only use for one office only and another office should use another db? how do we add...
by jfd2
Sun Apr 27, 2008 2:59 pm
Forum: Main Forum
Topic: Save images to OD
Replies: 1
Views: 2853

Save images to OD

Hello all, I have some questions related to pano ad scanx images. here is the context, we opened a new office and the patient could go both offices for treatment, how do I sync these images between these two offices? the only way I can think of is to put all the images into OD a-z directories. Is th...
by jfd2
Sun Apr 20, 2008 3:45 pm
Forum: Main Forum
Topic: OD on .net framework 3.5
Replies: 1
Views: 2898

OD on .net framework 3.5

Hello all,

Anybody tested it on the .net 3.5? I am downloading the C# 2008 which is bundled with the dotnet 3.5. Anybody tried this? I am on vista right now.

Thanks alot.

JFD
by jfd2
Sun Feb 17, 2008 3:01 pm
Forum: Main Forum
Topic: Claim form not visible afte the upgrade from 4.8 to 5.5
Replies: 2
Views: 3507

it worked.

Thanks a lot, Dr. Sparks.

jfd
by jfd2
Sun Feb 17, 2008 4:01 am
Forum: Main Forum
Topic: Claim form not visible afte the upgrade from 4.8 to 5.5
Replies: 2
Views: 3507

Claim form not visible afte the upgrade from 4.8 to 5.5

Hello all,

last night, I upgraded from 4.8 to 5.5. Everything looked ok except that the form background is not visible in the claim preview and printing. we are still using ADA2002 and I can see the image file in the image directory. Any setup I need to do?

thanks a lot for your help.

jfd