Open Dental Forum

ajhalls

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...

ajhalls

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...

ajhalls

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...

ajhalls

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, ...

ajhalls

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...

ajhalls

This has me worried as well.

ajhalls

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\...

ajhalls

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);

ajhalls

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...

ajhalls

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...

ajhalls

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' ...

ajhalls

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.

ajhalls

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...

ajhalls

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...

ajhalls

Ah crap, then what will I complain about? I mean, I have to kinda appear non-biased

ajhalls

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...

ajhalls

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...

ajhalls

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 ...

ajhalls

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 ...

ajhalls

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 ...

ajhalls

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...

ajhalls

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...

ajhalls

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...

ajhalls

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...

ajhalls

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...

ajhalls

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 ...

ajhalls

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_...

ajhalls

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...

ajhalls

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...

ajhalls

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...

ajhalls

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...

ajhalls

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...

ajhalls

Thanks guys, I will work on that.

ajhalls

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?

ajhalls

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.

ajhalls

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' ...

Open Dental Forum

Search found 36 matches

Emailmessage Table Size

Open Dental Crashing after Database Selection - OpenGL Related

Re: Suggested Reports - Feature Idea

Suggested Reports - Feature Idea

Long Page Load Using Remote Database

Re: Writing to the db is discouraged, but the API is very barebones, what do I do?

Re: New Basic Example Plugin

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

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

New Basic Example Plugin

20.4 Compiliation Errors

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

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

Visual Studio 2017 / 2019?

Re: Bad Database Design Spotlight

Re: Bad Database Design Spotlight

Bad Database Design Spotlight

Re: DB Export of QueryList Examples

DB Export of QueryList Examples

Off Topic, Help With Softdent Data

4 Months Free for ReminderDental Appointment Reminder

Geolocating Multiple Practices Patients for Patient Outreach

Ideal My.cnf for InnoDB

How Unsupported is MySQL 5.7?

Re: Duplication in security log table

Re: Duplication in security log table

Re: Duplication in security log table

Duplication in security log table

Re: Solved

Fatal error encountered during command execution in C#

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

Insurance Info Per Patient, Grouped by Service Year?

Re: Get Currently Selected Patient

Get Currently Selected Patient

Re: Visual Studio 2013

Visual Studio 2013