Open Dental Forum

alkhaef

Thanks for the advice Jason. Well noted, and I understand completely that it wouldn't be supported. Regarding the reserved keywords, you're right that they added a few. I just checked the schema against the new ones listed at the bottom of http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-...

alkhaef

Hi everyone!

I'm wondering if anyone has tried OD on mysql 5.6+. I'm guessing it's currently not supported, since the most recent stable comes with 5.5x?

GTIDs in 5.6 have made master/slave replication a lot less miserable, so has anyone tried it?

alkhaef

Hi guys, I downloaded the most recent 12.3 and noticed it wasn't in there yet. So I decided to give it a try locally first to make sure it allows my extension, and it turned out to be a good thing, because I'd like to ask for one more parameter ;). Could I add payTypes to the array like the followin...

alkhaef

I just realized 12.2 just went stable

. Did this hook get into 12.2 before that? Or will it just go into 12.3?

Thanks,
Al

alkhaef

HookAddCode request in "OpenDentBusiness/Data Interface/Payments.cs" Hello. I just opened a feature request (#2464) for a robust solution to this, but in the meantime I'd like to throw my own little hack together. Unfortunately, the parameter "command" is a string that I'd like to be able to manipul...

alkhaef

Hi guys, Just wanted to report a few issues I've had in regards to X-Charge / its bridge. I'm not sure if much of this is probably stuff that should be reported to them, not you guys, but I thought I'd mention it here anyway, in case you have any pointers / workarounds. 1. Permissions - underprivile...

alkhaef

Yeah I saw this too... SUPER annoying and wasted HOURS of my time with Symantec's overseas deflection-ninjas they call "support" until finally talking to a real support person. Note, I'm not calling it "Norton", because I think the current company has become a disgrace to the Norton name. OpenDental...

alkhaef

Hi all. I'm trying to build 11.1 (in Debug configuration), but I'm having troubles related to EHR... 1. Here are some of the errors: a) Error 19 Metadata file '...\opendental11.1\OpenDental\bin\Debug\OpenDental.exe' could not be found TestCanada b) Error 27 The type or namespace name 'FormEHR' could...

alkhaef

Hi Dr. Sparks, That was what I thought (and tried) too, but it didn't seem to work. Here's what happened after the hook was invoked: My Plugin.cs's parameter[0]: correct updated value OD's Plugins.cs's parameter[0]: correct updated value OD's Claims.cs's boxedCommand: incorrect original value OD's C...

alkhaef

Thanks guys! I did notice, however, that strings in c#, although reference types, are immutable. So for me to be able to touch the string in my plugin, we'd have to use a string builder, or do something like the following: command+="ORDER BY carrier.Phone,insplan.PlanNum, carrier.Phone,insplan.PlanN...

alkhaef

Hello friends. I'd like to request a HookAddCode type of hook in "OpenDental\Forms Reports\formRpOutstandingIns.cs" in butRefresh_Click(). private void butRefresh_Click(object sender,EventArgs e) { // PLEASE ADD HOOK HERE - NO PARAMETERS NECESSARY :-D. FillGrid(); } ...and also another HookAddCode t...

alkhaef

Thanks!

I've gotta pull the v11 source then I'll give it a shot

.

Best regards,
Al

alkhaef

Hello Dr. Sparks, Thanks for the reply. >> #1 and #2: We will add code to block people from making such changes. We will tell them why they are being blocked. Yes, that's a great idea - that would keep us from shooting ourselves in the foot :). >> #3a. I think the point is to view a date range in th...

alkhaef

EDIT: Added more gems I'd discovered through trial and error and talking to support (#4 and #5).

alkhaef

Hello all, I recently gave my second shot at trying to set up the Recalls feature of OpenDental and making it compatible with our scheduling protocols, and this time I made quite a bit of progress, and I'm almost there! In the process, however, I ran into a few gotchas where the behavior wasn't quit...

alkhaef

Prudent decision

.

Yes. I'm the one that originally requested it, so it should only break my code

.

Thanks,
Al

alkhaef

Hello again OD Developers! On the following hook: Plugins.HookAddCode(this,"ContrAppt.ShowSearch_end",listProviders); Could we please add the following to the end of the list: PIn.Long(pinBoard.SelectedAppt.DataRoww["AptNum"].ToString()) So that it reads: Plugins.HookAddCode(this,"ContrAppt.ShowSear...

alkhaef

Hello Dr. Thomas,

Honestly, it's been too long for me to remember how I got out of it, but I can tell you this much - Express should be just fine. I've built OD with express plenty.

Good luck!

Best,
Al

alkhaef

Hi Dr. Sparks, Cool. Both options seems like the right direction to go. Indeed, the numbers after writeoffs are what would be meaningful for us. However, the reason I couldn't discern what "net" meant is that the 7.5.22 "net" is nowhere near what the 7.5.11 production would have been, and it appears...

alkhaef

Also, now there's an amount and a "net" on the right side of the accounts module. Not sure what that means...

alkhaef

Hi.

My favorite feature looks to have rolled back...

I updated from 7.5.11? to 7.5.23, and the production estimates are back to UCR-based instead of reflecting writeoffs... Did I somehow botch my upgrade, or was that change rolled back?

Thanks,

alkhaef

FYI for any later viewers...

A reboot made corflags appear

. Then, the ResGen fix on the OD site worked

.

alkhaef

Just FYI to any going through http://opendental.com/manual/sourcecode.html who got hung up on the section titled "http://opendental.com/manual/sourcecode.html" ... In Visual Studio 2010, to get the debug -> exceptions menu item to even appear, I found that I had to first activate the following menu ...

alkhaef

Wow, Doc! I'm not used to seeing the words "userland" or "kernel" come from a Doctor... Something to be proud of ;). Anyway, thanks for taking the time to help me understand your approach. I actually didn't know that virtualization software these days can do snapshotting. Your approach seems pretty ...

alkhaef

Hi Dr. Doan, Thanks for your quick reply. Yes, virtualization is a powerful thing indeed :). I guess the big reason I first wanted to ask was that I myself have been looking for a way to address disaster recovery and fault tolerance simultaneously (and hopefully with less complexity than any alterna...

alkhaef

Hey there guys...

I'm curious because I never considered any setups like these. I keep thinking about it, but I can't see any obvious advantages to doing any virtualization for an OD server. Other readers may be wondering too. Anyone care to enlighten me/us?

Thanks,

alkhaef

Thanks anyway. I already googled till I ran out of keywords... Maybe I'll ask Microsoft.

alkhaef

Hi Doc,

Thanks for the quick reply.

Yes, I have .net 3.5 - i believe SP1 (not at that machine now). I have the entire path. It's just that the executable is missing. I even tried a deep search in "Program Files" and "Program Files (x86)", but couldn't find it.

Best,

alkhaef

Hi all... Does anyone know where on earth to find the corflags executable? I'm trying to build on my 64-bit machine, and it's not in the path "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin". I've tried reinstalling SDKs, but no luck :(. Alternately, does anyone know of another workaround? ...

alkhaef

Well, I looked at the documentation and I was afraid you were gonna reply with the term RDL :lol: ... I'd looked at the docs, and I got a bit overwhelmed because I'm not familiar with it. Plus, figuring out how to define a query in some intermediate language looked a bit heavy for the simple usage I...

alkhaef

I've built some user queries that we're manually changing "inputs" on to get the info we want (for example, dates, providers, etc).

Is there any way to parameterize reports?

Thanks,
Al

alkhaef

Hi. Quick question - Two interrelated ones, actually... 1. How well does OpenDental work with running multiple instances attached to the same server? I'm thinking about keeping a spare instance going for taking incoming calls while front desk is in the middle of something... 2. In the event that the...

alkhaef

Dr. Sparks, I think this is a great idea, even in its most basic sense. This may not be simple enough for the first iteration of it, but if you could give us the ability to impose some kind of per-field data type enforcement (string vs integer vs real) on the person leaving the notes, as well as som...

alkhaef

Ping?

alkhaef

Whoops... This was probably better suited in the "Developers" forum... I probably misposted it when looking for a duplicate report...

Oh well

alkhaef

Woah, cool!!

I didn't even know about that very useful checkbox!!

alkhaef

This has been a much anticipated feature for us! Thanks! I ran into something when testing it though... It doesn't respect the WriteOffEstOverride ... Here are the relevant code sections in "Data Interface\Appointments.cs": Line 646+... command="SELECT AptNum,PlannedAptNum,"//AbbrDesc,procedurecode....

alkhaef

Looks like you guys took the plunge!

My update process has gotten MUCH simpler now... THANK YOU!

-Al

alkhaef

Hi. I just finally got some time to use my plugin against the new hook location so I can move to 7.4, and I realized it stops working at this new location, because at that line strBtime has been digested and is no longer relevant: if(strBTime.Length>39) { strBTime.Remove(39,strBTime.Length-39); } st...

alkhaef

Hello. I'd like to: I: Request a feature that will give the option of setting all providers instead of just one by default when doing an appointment search. II: Request a hook so I can do it myself in the meantime - - HookAddCode type - ContrAppt.ShowSearch_end - listProviders as a parameter - Just ...

alkhaef

Hmm... As far as I remember, the PluginExample had the outline for the "cleaner way" you're referring to...

Namely, by tracking the version of the current schema, you can alter the table only when you have to "upgrade" to a given version.

Best regards,

alkhaef

Did this ever happen (the move to .net 4)? I just spent an hour or two struggling with a bug in .net 3.5 that MS is refusing to backport for some reason. https://connect.microsoft.com/VisualStudio/feedback/details/478521/cookiecontainer-domain-handling-issue I'm assuming since you said days, it's al...

alkhaef

Great!

Thanks,

alkhaef

Hello. I had previously requested the hook: Plugins.HookAddCode(this,"FormApptEdit.CalculateTime_end",strBTime,provDent,provHyg,codeNums);//set strBTime, but without using the 'new' keyword. ...and it works wonderfully... BUT: 1. I never realized that Appointments.CalculatePattern() is called from o...

alkhaef

Thanks for the feedback! Hmm... I'm on 7.2.43.0, but I'm not seeing it anymore either. Maybe it was a security/permissions issue because I made some changes to the security setup. I guess I'll keep an eye out if it comes back, because I no longer have an example of this :-/. For now, case closed :)....

alkhaef

Nifty... Didn't know about that one

alkhaef

Hello OD team,

It appears that when double-clicking the appointment from the chart module, not all info is loaded. For example, the time arrived / seated / etc are blank in cases where clicking on it from the appointment module shows it.

Thanks!

alkhaef

OP,

I had the same problem. You could do as others suggest and install 2008, but in case you don't want to, see this thread:

viewtopic.php?f=3&t=2833

Best of luck,

alkhaef

Just wanted to give a quick update on this... I tried out a slightly modified version of the sequence above, and it works great. Soooo much less painful to roll out an update! FYI for anyone that lands on this thread later, I just did it slightly different in the following ways: a) I forgot to put t...

alkhaef

Just checked 7.2.40 and it works like a charm

Thanks,

alkhaef

Works like a charm!

Thanks,

alkhaef

Hmm... Too bad, but I guess I'll just roll out my plugin against 7.2 and make it forward-compatible to head. I'll just tell the staff to select two providers when searching in the meantime and take advantage of the "bug" ;). Anyway, thanks a bunch for the hooks. Speaking of which... Cool! 7.3 is on ...

alkhaef

But patNum is an available variable, and it's impossible for it to be null because it's a value type. Ah. Indeed. Didn't notice it was a passed-in variable, and not PatCur.PatNum. As for ModuleUnselected, patNum is irrelevant. Well... I'm not using that parameter yet (in fact, I'm not using it for ...

alkhaef

Thanks Michael. Great point. Even better. FYI though - I just looked at head, and noticed that you only made this change to LayoutToolbars, although your concern probably also applies to the ModuleSelected, and ModuleUnselected too. Actually, ModuleUnselected isn't passing anything. Anyway, I just w...

alkhaef

During testing of the search functionality, I found that the search functionality always incorrectly reports one extra block of time at the tail end of a schedule because of the function below: ///<summary>Only used in GetSearchResults. All times between start and stop get set to true in provBarSche...

alkhaef

Ah! Great idea. That makes the syntax quite cleaner. I tested it and revised the patch below: --- AppointmentL.cs.head-2010-09-10 2010-09-10 14:55:08.643210100 -0700 +++ AppointmentL-allowoverride.cs 2010-09-10 15:51:14.571302200 -0700 @@ -82,8 +82,11 @@ //step through day, one increment at a time, ...

alkhaef

Hello Dr. Sparks, Thanks for clarifying. I initially reported this because I noticed the following behavior: - When multiple providers are selected, you usually get multiple slots per day. - When a single provider is selected, you only get one. I had to guess which one was intended, and the one that...

alkhaef

So via experimentation and rethinking, I've been able to work around question 1 by myself. I'm still wondering about question 2 below, though. Is this a possibility? I really would like 5 minute granularity, but I'd also like to see the whole day's schedule in one screen... 2. Once it's set to 5 min...

alkhaef

Hi.

I've hand-hacked my local copy and it looks like the hook as described with that parameter set would work for me. Will this hook go in?

Thanks,

alkhaef

alkhaef wrote:Hi,

Could we add the following to the hook parameter set? provDent,provHyg,codeNums

Thanks,
Al

Hi. I just checked head, and it looks like the additional parameters are still not there. Any update on this?

Thanks,

alkhaef

When the appointment search results group box shows, it hides all the widgets that used to be underneath from view, but they still respond to click events. For example, try clicking where "Lab Cases" or "View" should be.

Best,

alkhaef

Lines ~ 127-135 from AppointmentL.cs read: //match found ALresults.Add(dayEvaluating+timeFound); }//for p if(aptIsMatch){ break; } } dayEvaluating=dayEvaluating.AddDays(1);//move to the next day I'm not sure what the break statement is trying to achieve, but I'm guessing the idea is to stop trying o...

alkhaef

Setup -> Appointment Field Defs

Text reads "...you can set up for appointmentss"

PS - Appointment field defs are useful!! Sslick!

Best regards,

alkhaef

Hi Michael and Dr. Sparks, Took the plunge and moved to 7.2, and noticed the ModuleSelected/ModuleUnselected hooks (thanks! :D), but not the LayoutToolbar hooks. I thought I'd forgotten to ask for them, so I opened up a new thread at http://opendentalsoft.com/forum/viewtopic.php?f=3&t=2978&p=12786#p...

alkhaef

Just wanted to clarify a bit, so this doesn't look like a dupe request... I noticed that 7.2 has a hook like the following in each of the main modules, and another respective one in ModuleUnselected: Plugins.HookAddCode(this,"ContrChart.ModuleSelected_end",patNum);//Hook added to allow adding button...

alkhaef

A little bit of explanation is at http://opendentalsoft.com/forum/viewtopic.php?f=3&t=2881 I'd like to request hooks at the end of the LayoutToolbar calls in the modules (just before the call to invalidate), because it would allow toolbar changes that don't get clobbered later (LayoutToolbar is ofte...

alkhaef

I'm sure this is something that's been discussed in the past, but I couldn't find any keywords that would get me any relevant threads... Getting every facet of Open Dental customized to our office was a LOT of work, with each bit of work giving huge returns in smoothness of operation. Configuring op...

alkhaef

Sandi, Thanks for agreeing. About the padding, I'm referring to how Open Dental calculates an appointment time pattern when combining multiple procedures (for example, 2 fillings, or an FMX and a CompPerioEval). OD team, please correct me if I'm misrepresenting this, but basically it works like this...

alkhaef

Hello... Can I get a HookAddCode called AppointmentL.GetSearchResults_postfilter where the HOOK HERE comment is? So far I think the parameters I need are ALresults, providers[p], apt if(beforeTime!=TimeSpan.Zero && timeFound>beforeTime) { aptIsMatch=false; continue; } //match found ALresults.Add(day...

alkhaef

Hello, We haven't started using the "search" functionality yet, but if we get all our procedure patterns right, it would be a SLICK tool, so I would like to start soon. Just flipping through the code, though, it looks like it's looking for free provider slots, but not looking for free ops for the wh...

alkhaef

Hi,

Could we add the following to the hook parameter set? provDent,provHyg,codeNums

Thanks,
Al

alkhaef

Open Dental 7.2 now has 5 minute increments... Awesome! I flipped it on, and noticed a couple of things: 1. Procedure time patterns all use 5-minute blocks now. Fantastic! That's what I wanted. But - now the combined-procedures-padding is 5 minutes, which I don't want. Would it be reasonable to requ...

alkhaef

I remember the version tracking in the demo for DB updates. Fortunately, my plugins haven't started touching the DB yet, but I'll look into it again in the context of file updates. Hmm... What you're describing sounds like a good idea. I'll have to think about it a little more to see if it achieves ...

alkhaef

Dr. Sparks, Great explanation. Thanks for all the details and feedback! Yes, I expected the update sequence to be nontrivial to work as well as it does, but wow :P My sequence re-ordered as you described looks like would work, but IMO it would be a little error-prone (especially if I'm not the one a...

alkhaef

Dr. Sparks, Sorry to jump in, but if I'm understanding correctly, I *almost* had the same request. I think he's referring to adding a HookAddcode (_end) to the end of ContrAppt.InitializeOnStartup (similar to the one in ContrAccount) as you mentioned, so he can add the menu items. Please feel free t...

alkhaef

Dr. Sparks, I think your suggestion is the "right way" to go (unnumbered dll name, using the "file copy" routine). However, I didn't see any mention of how that works, so I had originally put off doing that for later. How exactly does it work? Does any file in "OpenDentImages\UpdateFiles" get copied...

alkhaef

Hello, I just started using the VersionMajMin functionality and I found out that it doesn't play too well with XmlSerializer. Particularly, when using code like the following: XmlSerializer serializer = new XmlSerializer(typeof(CalmSchema)); calmDataSet = (CalmSchema)serializer.Deserialize(reader); ...

alkhaef

Good to know. I'll wait a week or so, try to qualify 7.2 as best as I can, and skip 7.1 entirely then.

Thanks.

alkhaef

Dr. Sparks,

Thanks for the clarifications. I'll make some specific requests within the boundaries you've laid out.

Best,
Al

alkhaef

Ah... By the way... Under what circumstances do you guys backport hooks to the stable branch?

Thanks,
Al

alkhaef

Fantastic! Thanks!

alkhaef

Hi Dr. Sparks, I'm pretty sure I wasn't able to communicate my message too well, so I wanted to wait until I understood a bit more about the overall intended architecture of OpenDental before replying. It should be easier to get my question across with my laser-pointer below ;). I'm sorry if this po...

alkhaef

Contr*.ModuleSelected_end -> to allow hooking into the switch to each module ... maybe ModuleUnselected too
FormOpenDental.LayoutToolbar_end (just before the call to Invalidate()) -> to allow adding buttons to the toolbar and having them not be clobbered

Thanks!

alkhaef

Thanks in advance!

alkhaef

Hi. Lately I've been running into a side-effect of how "Save TP" works quite often. Namely, when one saves a TP, what happens is that all the dollar amounts get copied over verbatim to the saved TP rather than being recalculated based on the subset of treatments on the saved TP. The issue I run into...

alkhaef

Hi all. Conceptual question here... I've looked through some threads as well as contacted support for some good answers to this, but couldn't really find any. I see some references to "conditions" which sounds right for what I'm looking for, but it doesn't appear to be. Anyway, I decided to throw th...

alkhaef

OpenDental\Misc\ClassesShared.cs

alkhaef

Sorry for my ambiguous wording... What I meant by "restore" was restoring the database from the backup/restore functionality.

Best,
Al

alkhaef

Sure. GotoModule.GotoAppointment is at around line 180 in head.

Thanks again,
Al

alkhaef

Thanks Dr. Sparks.

Sorry if I was unclear, but I meant for the request to be a HookAddCode-type hook with a _start suffix at that same location, not a HookMethod-type.

Thanks again,
Al

alkhaef

Just wanted to give another example (also related to treatment plans)... I'm trying to spit out summary information on the most recent treatment plan out to a text file. My only solution I see so far is to duplicate lots of code in ContrTreat.FillMain() (TP totals, patient portions, etc. aren't stor...

alkhaef

Hello, Please let me know if I'm just missing something and there's another way I should be looking at all this... I'd like my plugins to call upon some methods in OpenDental that I can't access in some cases. One example of this I'll use is for my plugin to create treatment plans automatically base...

alkhaef

Hi.

I see GotoModule.Goto* for a few of the modules, but none for TreatmentPlan. Can we add this? I couldn't find any other way for plugin developers to switch the current module.

Thanks,

alkhaef

Thanks for the updates

Best Regards,

alkhaef

Hi.

I recall having the same problem initially, and following the steps in http://www.opendental.com/manual/programmersrefs.html solved it.

Best regards,

alkhaef

Hello.

It appears that not everything fully refreshes upon restoring - the example I found was the operatories shown in the appointment module.

Thanks!

alkhaef

Dr. Sparks, Thanks for the clarifications! I strayed off-topic from the original post a bit, so I'm sorry for that... I'll try to start a new thread later for the methodology-related stuff after putting some visuals together based on your feedback. Regarding the original post, I posted it seeing it ...

alkhaef

Hello all, I just finally got my toolchain setup. But while going through it, I ran into some bumps that I hadn't seen documented anywhere. Here are some specifics of my setup: Windows XP Professional Microsoft Visual C# 2010 Express - 10.0.30319.1 RTMRel Microsoft .NET Framework 4.0.30319 RTMRel Ne...

alkhaef

Hello Doctor Sparks. Thanks for the reply. In fact, what you've mentioned is exactly what I'm referring to when I say "contribution guidelines" - a huge part of this is the boundaries of community member individuals. I'd like to stay within those boundaries, so before I decide on a methodology for h...

alkhaef

That was easy

... Thanks!

Enjoy your weekend!
-Al

alkhaef

Guess this is why it's a bad idea to submit premature patches :-S... Looks like all the quadCount=0; statements should actually be quadCount=1;

Thanks,
Al

alkhaef

Dr. Sparks, Thanks for the quick reply. Actually, I wasn't proposing any changes. The hooks system as-written is quite elegant, and I'm excited to start using it. I was just curious about the thinking behind the implementation choice. Anyway, since code for using c# events as hooks instead would be ...

alkhaef

Sorry for the tongue-twister title ;) Right now, the automated-quadrant code is limited to one such procedure. If you want a two four-quad procedures, it begins duplicating UR on the second procedure. The following simple patch against the current head should* change this behavior to allow multiple ...

alkhaef

Just a curiosity question...

Events built into c# / .net could be seen as a possible alternative to the hooking approach taken, correct?

I'm sure you guys had good reasons for the choice, so I'm curious if you can elaborate on the advantages to the current approach.

Thanks and best regards,
Al

alkhaef

Hello. I'd like to request a hook to be fired at the end of FormApptEdit.CalculateTime() ("FormApptEdit.cs" line 1599 of 2135 in head). This would allow plugin developers to customize how the total appointment time is recalculated. This is my first such request, and I tried to be as verbose as possi...

Search found 105 matches