Search found 36 matches

by ajhalls
Thu Dec 29, 2022 9:49 am
Forum: Main Forum
Topic: Emailmessage Table Size
Replies: 1
Views: 3291

Emailmessage Table Size

I could use a little help understanding the emailmessage table. I was helping an office yesterday, and noticed their emailmessage table was 1.5GB, largest in the database by far, twice the size of the securitylog table. As I looked at the data there, I found messages that were up to 22MB in size, bu...
by ajhalls
Thu Dec 29, 2022 9:30 am
Forum: Advanced Topics
Topic: Open Dental Crashing after Database Selection - OpenGL Related
Replies: 0
Views: 4907

Open Dental Crashing after Database Selection - OpenGL Related

I had a customer that couldn't open Open Dental on their server and after several hours troubleshooting with tech support, it was blamed on my software, ReminderDental. The reason was because there was a failed MySQL query in the system event logs with our software's name on it. Anyway, it worked on...
by ajhalls
Tue May 04, 2021 9:21 am
Forum: Advanced Topics
Topic: Suggested Reports - Feature Idea
Replies: 2
Views: 9488

Re: Suggested Reports - Feature Idea

It took a little time, but here is a sample of the output. It has been sanitized to remove practice or patient specific data, so there are only 177 results. On the result sets, they were trimmed as well to the first 20 results, just so we could evaluate the type of data we would be looking at for ea...
by ajhalls
Thu Apr 29, 2021 9:43 am
Forum: Advanced Topics
Topic: Suggested Reports - Feature Idea
Replies: 2
Views: 9488

Suggested Reports - Feature Idea

Playing with the reports here: https://opendentalsoft.com:1943/ODQueryList/QueryList.aspx It would be pretty cool if there was a way to know which ones were used most often, creating a way to filter them by "Most Popular" For what it is worth, there are 901 out of 1329 that run, AND return results, ...
by ajhalls
Mon Jan 11, 2021 10:53 am
Forum: Advanced Topics
Topic: Long Page Load Using Remote Database
Replies: 1
Views: 7467

Long Page Load Using Remote Database

A customer asked if I would host their database on one of my servers in the data center, I figured to give it a try. Here is what I did: In Mysql: create database someuser_od; create user 'someuser'@'%' identified by 'SomeSuperSecurePassword'; grant all on someuser_od\%.* to 'someuser'@'%'; # allows...
by ajhalls
Fri Aug 21, 2020 10:45 am
Forum: Developers
Topic: New Basic Example Plugin
Replies: 2
Views: 11675

Re: New Basic Example Plugin

Thank you for the ideas. The batch file is a good idea, and I could write a command line compile command for the plugin to be part of the OpenDental project's build. Something like: "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\MSBuild\Current\Bin\MSBuild.exe" "C:\OpenDentalPlugin\...
by ajhalls
Wed Aug 19, 2020 3:25 pm
Forum: Developers
Topic: Open Patient Family (or other view) from external app?
Replies: 1
Views: 3947

Re: Open Patient Family (or other view) from external app?

Nevermind, I found it. Unless there is a better way, I will set up a bidirectional socket connection between the plugin and my app and then should be able to get there using: var patient = FormOpenDental.CurPatNum; // or setting it from the external app OpenDental.GotoModule.GotoChart(patient);
by ajhalls
Wed Aug 19, 2020 3:08 pm
Forum: Developers
Topic: Open Patient Family (or other view) from external app?
Replies: 1
Views: 3947

Open Patient Family (or other view) from external app?

I have a 2 way texting application and am setting up a plugin to be able to pull up the active Open Dental patient in the texting application and wondered if it was possible to go the other way? Can I put a button within my app that can launch an Open Dental view? https://www.reminderdental.com/imag...
by ajhalls
Wed Aug 19, 2020 12:39 pm
Forum: Developers
Topic: New Basic Example Plugin
Replies: 2
Views: 11675

New Basic Example Plugin

The default example plugin is really old, and while it has some great things in there, I had to comment out a ton to get it to compile. Here is a new basic plugin in a single file that has the following features: Gets current selected patient PatNum into `patient` variable. Executes database queries...
by ajhalls
Wed Aug 19, 2020 10:36 am
Forum: Developers
Topic: 20.4 Compiliation Errors
Replies: 4
Views: 6797

20.4 Compiliation Errors

I downloaded HEAD this morning and tried to compile. I did the steps with Corflags, VirtualWeb, and OpenDentHelp and have the following errors. Missing Namespace: OpenDental.Forms After commenting out the `using` statements, I get: 'Browser' does not contain a definition for 'GetComputerNameCookie' ...
by ajhalls
Mon May 11, 2020 2:11 pm
Forum: Developers
Topic: Unknown column 'cp.payplannum' in 'field list'
Replies: 2
Views: 10691

Re: Unknown column 'cp.payplannum' in 'field list'

I would assume so, but it isn't my practice. I only know that when I connected remotely that the current installed version was 19, and that those tables were missing. I asked them to contact OD Support to fix it. They were out of contract with their support, but I encouraged them to fix it.
by ajhalls
Thu May 07, 2020 4:10 pm
Forum: Developers
Topic: Unknown column 'cp.payplannum' in 'field list'
Replies: 2
Views: 10691

Unknown column 'cp.payplannum' in 'field list'

I am getting an odd error of "Unknown column 'cp.payplannum' in 'field list'". I was working with an office using 19.4 and their paysplit table was missing along with the updatehistory table. Looking at their DB backups that go back to 2017, they have been missing for some time. How are tables and c...
by ajhalls
Fri Aug 30, 2019 3:33 pm
Forum: Developers
Topic: Visual Studio 2017 / 2019?
Replies: 3
Views: 8366

Visual Studio 2017 / 2019?

Curious if you guys are still using the old 2015 or have updated to 2017 or 2019? I am trying to compile the 19.2 and having trouble with it. I had to manually specify to use C# 7.2 language version, Default latest didn't work even though 7.3 was there. I was getting the mixed mode errors, even thou...
by ajhalls
Tue May 21, 2019 2:37 pm
Forum: Developers
Topic: Bad Database Design Spotlight
Replies: 8
Views: 17141

Re: Bad Database Design Spotlight

Ah crap, then what will I complain about? I mean, I have to kinda appear non-biased :)
by ajhalls
Tue May 21, 2019 12:56 pm
Forum: Developers
Topic: Bad Database Design Spotlight
Replies: 8
Views: 17141

Re: Bad Database Design Spotlight

I have spent the last year and a half going through the databases of Eaglesoft, Dentrix, Practiceworks, Easy Dental, Softdent and Open Dental and have some major gripes with the design of all of them with the exception of Open Dental. My only complaint with Open Dental is that by default it installs...
by ajhalls
Tue May 21, 2019 6:25 am
Forum: Developers
Topic: Bad Database Design Spotlight
Replies: 8
Views: 17141

Bad Database Design Spotlight

I hate bad database design. Today's spotlight is on Eaglesoft. I was dumping the database to SQLite and noticed that after a few tables, it stopped at one called "daily_patient_productivity_view". It spent hours dumping this one table, so I went home for the day. Interested to see what it was, turns...
by ajhalls
Mon May 13, 2019 8:33 pm
Forum: Developers
Topic: DB Export of QueryList Examples
Replies: 3
Views: 6117

Re: DB Export of QueryList Examples

Here is the data formatted for insert into a table. I am still working out the tags. Data order is (ID, Description, Warnings, Query Body) https://ufile.io/etmc2vln At some point I think it would be nice to have a preview of the output of each query so people can quickly see whether it is what they ...
by ajhalls
Mon May 13, 2019 10:25 am
Forum: Developers
Topic: DB Export of QueryList Examples
Replies: 3
Views: 6117

DB Export of QueryList Examples

Any chance of getting a SQL / CSV dump of the table used to build this page? https://opendentalsoft.com:1943/ODQueryList/QueryList.aspx I would like to incorporate some of these queries into my software and while I can get them all by going into each category, there then ends up over 6000 because a ...
by ajhalls
Tue Sep 25, 2018 2:44 pm
Forum: Developers
Topic: Off Topic, Help With Softdent Data
Replies: 1
Views: 3473

Off Topic, Help With Softdent Data

I realize this is a little off topic, but after integrating our reminder service with OpenDental, Dentrix and Eaglesoft, I thought I would tackle Softdent... There are no integration tools available from Softdent or Faircom (the vendor that designed the database) and so, to the best of my knowledge ...
by ajhalls
Wed Aug 08, 2018 8:00 am
Forum: Main Forum
Topic: 4 Months Free for ReminderDental Appointment Reminder
Replies: 0
Views: 8973

4 Months Free for ReminderDental Appointment Reminder

Save yourself $3,000 this year and switch to ReminderDental. The first 10 to use coupon "OpenDental" will get a credit of $200 on their account. While that doesn't sound like a lot when you are used to paying $300-$500/month for your appointment reminder system, since we are only $50/month and inclu...
by ajhalls
Fri Jul 27, 2018 11:03 am
Forum: Main Forum
Topic: Geolocating Multiple Practices Patients for Patient Outreach
Replies: 0
Views: 8927

Geolocating Multiple Practices Patients for Patient Outreach

I was playing around today with our Geolocation feature (beta) on ReminderDental and thought, what would it look like to see the patients of 2 offices? So I put it together: https://www.reminderdental.com/images/onlineposts/2OfficesGeo.png These are 2 offices owned by the same dentist that are about...
by ajhalls
Wed Jun 20, 2018 9:38 am
Forum: Advanced Topics
Topic: Ideal My.cnf for InnoDB
Replies: 0
Views: 16070

Ideal My.cnf for InnoDB

I was working on optimizing a server with dual core 2.4GHz with 8GB RAM where the workstations are lagging just a little. After updating to InnoDB I was looking at some settings that I typically use on my Linux servers and wondering why we don't set more of these during install / switchover to InnoD...
by ajhalls
Tue Jun 19, 2018 11:00 am
Forum: Developers
Topic: How Unsupported is MySQL 5.7?
Replies: 1
Views: 4006

How Unsupported is MySQL 5.7?

Just out of curiosity, I had an office that I connected my connector on where the server was a bit under-powered which resulted in some queries taking longer than it should have. With MyISAM as the engine, it was also resulting in table locking which was disruptive to the workstations. It seemed the...
by ajhalls
Mon Jun 11, 2018 3:22 pm
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14717

Re: Duplication in security log table

Here are 2 such records: SecurityLogNum, PermType, UserNum, LogDateTime, LogText, PatNum, CompName, FKey, LogSource, DefNum, DefNumError, DateTPrevious "758434" "25" "17" "2018-03-19 08:11:37" "03/21/2018 2:00:00 PM, PeriodicX, PA1st, PAadd, PAadd, 4BWX, TestMucAb, ProphyAd, TopFlApp, OralHygIn, HHX...
by ajhalls
Mon Jun 11, 2018 10:15 am
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14717

Re: Duplication in security log table

Thank you Travis, I don't have a lot of info on how and where the appointments were created, it was just an interesting issue that was breaking my application because it was creating duplicate appointments, which broke foreign key constraints. I can adjust my query, but this is the first time I had ...
by ajhalls
Mon Jun 11, 2018 8:01 am
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14717

Re: Duplication in security log table

It is a pretty basic query, here you go: SELECT aptnum AS reference_id, appointment.patnum AS patient_reference_id, aptstatus AS reference_state, pattern AS end_at, confirmed AS reference_status, CASE WHEN (IsHygiene = 1 and ProvHyg != 0) THEN ProvHyg ELSE provnum END AS provider_reference_id, Date_...
by ajhalls
Mon Jun 11, 2018 7:31 am
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14717

Duplication in security log table

I have a query that joins on the securitylog table, but there is some duplication, in particular the Permtype 25 which is the type for "Appointment Creation". How can there be multiple appointment creation records mere seconds apart from each other? "758434" "25" "17" "2018-03-19 08:11:37" "03/21/20...
by ajhalls
Tue Apr 17, 2018 8:40 am
Forum: Developers
Topic: Fatal error encountered during command execution in C#
Replies: 4
Views: 8766

Re: Solved

I found a number of problems and solutions. Since I didn't hear anything from here, I posted on StackOverflow (https://stackoverflow.com/questions/49820961/fatal-error-encountered-during-command-execution-only-in-c-sharp) and got some help. The issue was that it was taking about 60 seconds to run, a...
by ajhalls
Thu Apr 12, 2018 11:02 am
Forum: Developers
Topic: Fatal error encountered during command execution in C#
Replies: 4
Views: 8766

Fatal error encountered during command execution in C#

I am having trouble with running this query. On my personal computer I had upgraded MySQL to 5.7 to do some better logging and this query works just fine. When I put it into production on 5.5 it works, but only sometimes. Using HeidiSQL it works but takes 50 seconds to run (only takes 2.6 seconds on...
by ajhalls
Tue Mar 20, 2018 1:08 pm
Forum: Developers
Topic: Insurance Info Per Patient, Grouped by Service Year?
Replies: 1
Views: 3615

Re: Insurance Info Per Patient, Grouped by Service Year?

Got it working in ~140 lines of MySql :) I am in the first stages of integrating it into https://www.ReminderDental.com to allow actual "Use it or Lose it" emails to patients that don't just go out to all patients, but targets them with a fully customized email with their available unused balance. G...
by ajhalls
Mon Mar 19, 2018 2:01 pm
Forum: Developers
Topic: Insurance Info Per Patient, Grouped by Service Year?
Replies: 1
Views: 3615

Insurance Info Per Patient, Grouped by Service Year?

I am trying to output a table with the following columns to match Dentrix info: plan_id patient_id current_year_benefits patient_count family_deductible_met family_preventive_deductible_met family_benefits_last_year family_deductible_last_year family_preventive_deductible_last_year max_family_covera...
by ajhalls
Fri Feb 23, 2018 2:43 pm
Forum: Developers
Topic: Get Currently Selected Patient
Replies: 3
Views: 6474

Re: Get Currently Selected Patient

Thanks guys, I will work on that.
by ajhalls
Thu Feb 22, 2018 12:22 pm
Forum: Developers
Topic: Get Currently Selected Patient
Replies: 3
Views: 6474

Get Currently Selected Patient

I have an app that is monitoring the mysql database, is there anything in the DB that changes when a patient is "Selected" or do I have to build a plugin?
by ajhalls
Sun Jan 12, 2014 3:23 pm
Forum: Developers
Topic: Visual Studio 2013
Replies: 3
Views: 5344

Re: Visual Studio 2013

Thanks, I was going through it step by step, the only thing I differed on was using Visual Studio 2013. I can switch if I need to, I just didn't know if someone else had already found a way to make it work in 2013.
by ajhalls
Fri Jan 10, 2014 1:49 pm
Forum: Developers
Topic: Visual Studio 2013
Replies: 3
Views: 5344

Visual Studio 2013

Anyone try compiling with 2013? I am fairly new to this and not sure if I need to go back and get the 2012 version. This refers to version OpenDental_13_3 When just loading it I get these 3 warnings: Warning 1 The referenced project '..\..\..\Shared Projects Subversion\EHR\EHR_13_3\EHR\xEHR.csproj' ...