Open Dental

I'm starting to integrate your code. Get a copy of the head on your computer, and frequently update it as I go along.

I just updated the website with our new strategy for multiple offices. http://www.open-dent.com/manual/multiplelocations.html Replication support would be better than the current daisy chain replication option. Also see http://dev.mysql.com/doc/refman/5.1/en/ ... leout.html

I just updated the coding styles page with this: If you are using C# Express Edition, and you don't see the "Tabs" group under Text Editor, C#, look down a little bit and find the checkbox to show all groups. The "Tabs" group will then be visible. The problem here with you committing is that you see...

You realize that our software already does this, right? http://www.open-dent.com/manual/messages.html I'm guessing ours just doesn't have the right mix of features for you?

Sure.

I looked it up on their website to jog my memory. Just so we have the terminology correct, their software is called ProImage. Our bridge should allow you to quickly jump to the same patient.

I still don't understand the basic problem. When they click OK from within the autonote, the text should just go back into the textbox of the FormProcEdit. No events. No reload. Nothing fancy. It's quite simple. Specifically, you have a public string in the autonote form. Once the form is closed, yo...

Well, you would generally just leave them in EVO.

It should just go in as a note for now. We've laid some groundwork for that functionality, but have not yet taken it to that level of detail.

We do not have any window in our program with the text "after installation" or "click next". I just did a text search. Are you sure it's an OD window?

Oh that's right. We just released the production version of 5.0. But I forgot to put that on the bug list. I've just added it, and we'll work on it.

When they click OK from within the autonote, wouldn't the text just go back into the textbox of the FormProcEdit that's already open? Why do you need to "start FormProcEdit" if it's already open?

Ah, you haven't purchased them yet. Well, probably the next sensor that interests me is the Schick because they have such excellent and public documentation on their website. The problem with the e2v is that they do not sell retail. And each retailer generally creates their own hardware controller, ...

We can't get our phones to talk to the server. So we have to pay someone to come in to fix it. We'll just look over their shoulder while they work, and then we can do it next time.

The parameters in the FormProcEdit.cs constructor are simply to pass in the current patient objects. They are clumsy and a relic from earlier versions. Obviously, it would be better if FormProcEdit.cs obtained those objects internally for better encapsulation. But it seems like low priority. Just lo...

Ha ha. Ok, I'll bite. What brand is it?

I'm really not sure what popup you are referring to. I could not find any window called "After Installation". Are you talking about the one that says this?: "Download succeeded. Setup program will now begin. When done, restart the program on this computer, then on the other computers." It's just rem...

It's not another paint type we need. It's another status. When we add a "condition" status, there will be two additional colors for you to customize: a light and dark version for that status. It's been planned for quite some time. But it's competing with a few other features that have a higher wow f...

If you look on your old server, you will find C:\Program Files\OpenDentalInstaller\ which contains the old trial version. Install that first. Then use the Setup.exe in your A-Z folder to upgrade to your current version. Normally, you would install the current trial version posted on our website as a...

Well, we use Captivate from Adobe and it goes straight to Flash format. Sort of spendy for a small project, though.

Option #2 depends on your email program. I use Outlook (not Outlook Express), and it pastes just fine onto my outgoing email.

I would consider this a request for a new feature that we don't yet have. Improvements are planned to the medical history section.

No, you didn't install it wrong. That's the pleasure of using Vista. We will be making some changes to the program to stop it from doing that, but it's not simple.

Right. I'm aware of that request. But I was thinking the other day... Your database is replicated within a few seconds, right? So both databases are always identical, right? So why would it be a problem to set a backup program to keep the image folders synchronized? Yes, the first time you get both ...

We are aware of it. We plan to look at it in a few days. Derek recently worked hard on trying to render it behind the scene. It's impossible. But we should still be able to get it to render faster than it is, because it was faster previously.

Or you could just tighten down the staff procedures. There should be one assistant for a given procedure. That assistant is responsible for creating the planned appointment. They can't be on two computers at once. Go ahead and add that feature it you want, but I would consider it a very low priority.

Try the link at the bottom of this page: http://www.open-dent.com/manual/vista.html Vista computers have trouble finding shared network folders. Now, you say it's a "mapped" network drive. Does that mean it looks like "F:\" or "G:\"? Or does it look more like "\\SERVER\"? I'm not saying I'm even clo...

No... David, the bug you are talking about is more of a "feature by design". It's always been that way, and nobody notices. But the bug james was talking about was much more obvious and was quickly fixed.

New VixWin bridge, or the old one?

It always tends to be a problem if you have the exact same window open for the exact same patient, such as the patient edit window, or one procedure edit window. The last person to click OK will be the one who has their changes saved. (except chart notes, which always perfectly record all changes). ...

OK, then to 4.9.11. My point is that this bug was fixed a long time ago.

OK, then to 4.9.11. My point is that this bug was fixed a long time ago.

First of all, move to a bigger monitor. 22" widescreen with speakers are available for $230. Or splurge for a 28" 1900?x1200 for about $650. OK, now you will have space to run two copies of OD side by side. Pull up the same patient in both copies. It has always been planned right from the beginning ...

It worked for me just now in 5.0. Launched Open Office. Check your file type associations. From any folder, Tool | Folder Options | File Types.

That sounds fine. Also, I assume you are using the stationary feature, so you would notice if it had any bugs? I've never tested it.

I've finally had a moment to review the stationary feature. I have the following comments: 1. The word processor path should be eliminated. Windows can use the extension .doc to figure out which program to use to launch it. 2. You can't use @"\" to join paths. That won't work on Linux. 3. Please don...

james,
I still think he's talking about a different bug than the one you were talking about. I just want to make sure you have upgraded to 5.0.2.

David, I'm looking over that feature, and I have some comments. But I will take them to the developer's forum.

Yes, there are lots of books. The book I use most is called the MySQL Cookbook. It's meant for programmers, but you still might find it very useful if you ignore the programming part. I like the Cookbook, because each "chapter" is about 5 pages long and addresses one specific practical need. Kind of...

Run database maintenance. Also, did you compile? Is your version of MySQL mismatched possibly? In other words, did you transfer the database from one computer to another? You might have a different version of MySQL on each computer. It works ok to move up a version, but not down a version.

Yes, of course that's planned. There are at least two different possible approaches.
1. Type in text.
2. Freehand annotations.
But the space below the graphical chart is very efficient in the meantime.

SELECT Zip,COUNT(*)
FROM patient
WHERE PatStatus!=4
GROUP BY Zip

http://www.open-dent.com/manual/queryexamples.html #19.

When I wrote Free Dental version 1.0, I used what I thought were reasonable field lengths. I was proven wrong many many times. That's why all the fields keep ending up bigger. Keep in mind that, for ISAM tables, the field length is nearly meaningless, having zero performance penalty. Even as recentl...

I don't think such a script should be included in the core program necessarily. It's just a series of SQL statements that could just as easily reside in a text file. I'm having trouble envisioning where, exactly, we might put such a script in the user interface.

Yes, Derek has been working hard on it. He almost had it running today, but we had to put out some other fires. That's why we have been letting some of the bugs languish. We thought it was more important to get the bug tracking built. It's a big deal for us, so it will certainly be posted when there...

I am already planning for the day when the patient will have access to their own "chart" online. This means we don't put embarrassing comments in the procedure notes, only professional tone entries. Comments about the patient that we don't wish them to see belong in the Commlog for now because I dou...

Well, I wanted to keep on using the sensor, not just evaluate it. I don't want to be beholden to them or pressured to market their sensors to our users. As we add more sensors, I think we will probably do it by temporarily "borrowing" sensors from the manufacturers for testing purposes only. That wo...

Are you using Oracle or MySQL? Try: SELECT COUNT(*) AS repetitions, LName, FName, Birthdate FROM patient WHERE PatStatus!=4 GROUP BY LName,FName,Birthdate HAVING repetitions > 1 The reason I ask about Oracle is that, when you use a GROUP BY clause, it might require you to include all 4 columns (??)....

Version 5.0 is still beta. We haven't actually been using it with real patients yet, since we had to order sensor holders, etc. To my eye, the image looks the same as when captured in Apteryx. There will undoubtedly still be some bugs or annoyances in the program flow that will be discovered when we...

Reduction of white space isn't to save space in the compiled program. Instead, it serves these purposes: 1. Consistency. The more similar all the code in the program is, the more efficient it is for us. 2. Readability. If blank lines are left in methods, it makes it hard to tell where the divisions ...

I think I understand what you are saying. It's not that the child prophy procedure itself was still there. Instead, the problem was that the description of the appointment still included the child prophy, right? That would make sense to me as a bug.

Derek insists there was no change to the graphics between 5.0.6 and 5.0.9. Integrated graphics chips are frequently not powerful enough to handle the 3D tooth chart, but I'll let Derek make further comments on that. Try updating the driver. If that does not work, purchase a graphics card. They don't...

Right.

No. Just put your NEA# in the comment box when sending the claim.

Or maybe it works fine to have the NUnit test project not be part of the solution. Either way seems like it would be fine.

Good to know that you'll be away.

It already exists. See http://www.open-dent.com/manual/medicalservice.html There's a checkbox for PAC, and a textbox for MedUrgent. Both of these can be set to display on an appointment in http://www.open-dent.com/manual/appointmentviews.html. You can also set them to red from that window.

The industry is still at the very beginning of what it will become. This is going to be huge some day. We're talking about eliminating at least one fulltime staff person in each dental office. No time spent on the phone trying to verify benfits. No waiting for EOBs to come back a month later. Everyt...

You mean you fixed it in 5.1, right? I think you have a typo.

One further problem is that we still don't know how many carriers will actually accept the e-attachment. NEA is going to be better in that regard. Possibly much better.

1. Date Completed in your example would be May 16th. Date would be May 15th. This is for legal reasons and auditing. 2. TP date would be a fourth date. We're thinking about it, but for now, you should have saved that TP from May 1st. If you did not, then why not? 3. There are some queries on our web...

I would stick with NEA or whatever you set up. It's total vaporware at this point. Planned for version 5.1. It will take months.

Great. Glad it worked for you.

David,
Were you going to finish off the bubble delay by making it optional? I still don't like it because it interferes with my efficiency.

That's the plan. Just to be fair, all the clearinghouses are working on real-time claims. But Tesia has a unique blend of features that we found very attractive, incuding: 1. Medical claims 2. Inexpensive attachments ($15/month) 3. Inexpensive eligibility and benefits ($15/month) This means that alm...

It's not in the source code. It's copyrighted, so we can't include it. The only way to get it is to use 5.0 and to be on a support contract with us.

http://www.open-dent.com/manual/graphics.html
If that doesn't work, let me know.

You should never have to worry about the grant tables again. Once is all it takes, and you had never done it initially.

We have been considering image path settings on a per-computer basis. I'll take this as another request for that feature. It would also come in very useful for multilocation setups where you want users at each location to point to a local path. So yes, this seems to be a hot request right now.

Yes, terribly sorry about the loss. I don't remember anything very important on this thread. There was a link to the MySQL website for conversions from Pervasive, but we can find that again if we need to.

You're right. Tasks don't really show outside the task list itself. So many object types... But it kind of seems like low priority, doesn't it? I mean aren't there other higher priorities with tasks? Like having the task lists be assignable to a specific user and popup in a startup window for that u...

You're using MySQL 5.0, right? Fix the grant tables using our installer. Honestly. I don't need you to list the queries where it fails. That's irrelevant. The MySQL installation is the problem.

My comment about Email was not well thought out. The real solution there is to include email in the Progress Notes. And now that I think about it, my main complaint is that your solution cluttered one of the main modules. If the clutter was buried 3 windows deep inside the recall list, then I wouldn...

From what I've heard, the quality is fine. They are more comfortable. But you still have to wait for them to "process", so some of the convenience of digital is lost. Finally, the plates will tend to get scratched over time, so they need to be replaced frequently. But sensors also tend to fail over ...

After spending the last 3 weeks learning Asterisk, learning about IP phones, ordering parts, adding more wiring, etc, I have a few more comments to make. I can clearly see that Asterisk is not designed for end users in a dental office. But a prebuilt and professionally installed Asterisk system woul...

This is a continuation of an ongoing discussion that was lost due to the forum malfunction. It's complex. I'm not interested in people posting messages like, "yeah, it would be great to see everything". That's not the point. The discussion is about HOW we do this. Here's what the debate is about. Th...

I'm honestly not even sure if they're still in business. And I'm not sure the bridge has been tested on the newest versions. It wouldn't hurt to try it I suppose.

I posted this a few weeks ago, but the post is now lost. Look in your my.ini file. You did a custom installation of MySQL instead of using our installer. Comment out all the options you have added to the my.ini file. Essentially, you've set mysql to throw an error at a higher sensitivity level. I on...

Man, I am seriously pissed off right now. The boneheads who host this forum had a hard drive failure, and their most recent good backup was a month old. Yet another example of why it's going to be best for us to get this on our own server.

We ordered our new Asterisk server yesterday. For those who are unfamiliar, it's a software that runs on a Linux computer that lets the computer act as a phone PBX. We will have analog phone lines running in, and then IP phones hooked up to it via our LAN. I'm going to be flying tomorrow and again a...

I came up today with a new strategy for multiple offices. Connect them all with highspeed internet or even a dedicated T1. Each office would run its own database for its own patients. Now let's say that you want to be able to see all patients for all offices. We could add a feature that lets you set...

I don't have much of an opinion. I think it sort of depends on how much multipage scanning you want to do and your comfort level. I don't know which way we'll take the programming.

1. Indefinitely. Defaults were very problematic because if you change a default, then what date range should the change apply to? Repeating for something like 500 weeks is certainly an option that you could currently use and would be equivalent to "forever". 2. Type it in. The dropdown doesn't restr...

What specific version are you using?

Go ahead and use text files. Once you get it working, I can quickly adapt it to the database so nobody has to mess with the text files anymore.

Ask away.

I would create a column in the database, and simply dump all the text into it. One "cell" in the database can store an entire novel if needed. I assume you already have a database row that you're working with, right? So the "text file" is just one more column in that row now.

If you use version 5.0, you will notice that the area at the lower right of the Appt module does indeed now have schedule info in it. but currently it's only schedule info for the employees. That's a perfect place to also show schedule notes. I'll keep that enhancement in mind.

So was your program a stand alone which got launched externally to Open Dental, or did you customize OD by altering the source code and recompiling? In either case, once you get it working again, you could submit the code for inclusion. We would have to edit it somewhat, especially to use MySQL inst...

The front desk should not be deciding the procedures for the next appointment. That's the job of the chairside assitant. At least that's the way the program was optimized.

I have noticed slowness printing from Vista computers regardless of the OD version. I think Vista is slower at navigating the network to communicate with a printer hooked to XP.

Sure it is. When a version goes out of beta, it's our way of saying that we think it's ready for prime time. There are still a couple of bugs, but that's true of any version. They only remain because they are hard to duplicate or track down.

Really? I haven't noticed this. On daily view or weekly? There shouldn't be any difference at all. Is it when you click and perform actions on certain appointments, or is it when you simply refresh the appointments module using the button at the left? On all days, or only those with appointments? I ...

The Emdeon medical claims section is pretty much a separate company, despite the same name. So we have to start all over with contacting them, figuring out the upload process, etc. A better bet might be Tesia, which uses one clearinghouse to do both medical and dental. We're just coming on line with...

Yes, some users would like to do this. I think everyone understands the goal. I have some technical questions about the implementation. For each object on the form, you need to store at least these properties: xpos ypos width height text objecttype (checkbox, textbox, label, etc) picklist (for some ...

Would you believe it's one of those details that we haven't quite gotten around to? At this point, I would consider it high priority, so it will probably be added soon.

Well, that field is an obvious omission. I'll be happy to add it, but it will have to wait until next week, since we're right in the middle of the 5.0 rollout.

I think he just wants to be able to minimize. Many computer users expect to be able to minimize an open program to see what's underneath even though there are other ways to achieve the same thing.

I don't see any reason to allow a checkbox at all or to save it in the config file. If a user is hidden, then they certainly should not be allowed to log in. Of course, there is not yet an "IsHidden" field for users. That's what's really missing.

Version 5.0 will be released today. Please stop adding features immediately, and wrap up any bugs.

They are putting together a website with more details. Yes, a swiper. I think it's the typical swiper that plugs into USB and costs about $30. They are recommending a dedicated $100 dymo label printer for the signatures, but I know we won't have the functionality to print to it. The whole thing work...

Nope. If you get an error, then that means it didn't go through. It's because I added dummy jpg files and committed them so that it would continue to compile for everyone. So now, you should copy your two files to a safe location, do an update, which will overwrite your jpg with mine, and then copy ...

Looks like you forgot to SVN Add this file: Resources\stationary sample.jpg

Set up two different columns. In a few years, we'll add that level of control.

Looks fine. The long term solution to all of these appointment indicators is probably going to be to set up a symbol framework. Maybe there would be 15 different flags that could be set per appointment, including NewPatient, Billing type, premed, confirmed, etc. Each flag would correspond to a symbo...

Not right now.

Receiving email is obviously planned. It's a higher priority that your idea of sending OL appointment files.

You've probably noticed that the business layer has been overhauled for appointments. So you'll put it in the business layer, right? I don't have time to think about the queries involved, but I'm hoping you aren't going to slow down the query.

I can think of a few separate printouts which would provide most of the info, and screenshots which would provide the rest. Good idea, though.

I'm glad it worked for you. I didn't quite think it would be in the ini file. That's easy to reinstall using our installer. We recommend using our installer for both the grant tables and the ini file to avoid such issues. I'll keep this in mind for the next time it comes up.

5.0 won't go into beta before Monday morning, so it's OK to add features that you think can be ready for beta by then. The timing of this beta is a bit unusual since we're waiting for some things that are beyond our control. There would not normally be such a long pause in development as there has b...

I can't quite tell if you installed mysql using our installer. If you use our installer and our grant tables, then that's the standard installation. Did you use our grant tables or did you configure it yourself? Anyway, that's my best guess as to the problem. Like I said, it ran fine on my computer.

The latest commit puts to rest my concern about fcarlier not understanding the existing code.

fcarlier certainly wasn't suggesting replacing the current default image storage method. I actually never even thought of abstracting it the way you suggest. I'm interested to see how you do it.

We just got our T1 line installed, and we're configuring the new firewall right now. So we're going to move this forum over to the new server fairly soon. It will be more reliable and faster.

The burden of deciding which direction to go is beginning to weigh very heavily on me. I just looked at the Patient class, which is now 1000 lines vs its original 250 lines. So adding a new table with, for example, 10 fields, would not be much simpler than it currently is. It would take about 130 li...

I support moving this to the head as soon as we move to 5.1. Derek is responsible for that module, and it will be under active development for a while, so it may be a little bit of a dance if you're both working on the same area of the program. But it will be nice to have two sets of eyes looking at...

I'm a bit fanatical about getting the indentation correct. So if it's not right someplace, then explicitly fixing it is the thing to do. And also informing whoever got it wrong.

Keep in mind that we did, in the not so distant past, already have the database access logic inside the same class as the "TableDef"/"DataObjectBase"/"TableType". I went to great effort to get away from this model, and I really don't think I'm quite ready to go back to it quite so soon. It's very cl...

Production and income report can be run separately for each provider. It doesn't summarize all providers on one page. As for showing it by procedure, that's part of the procedure code report. That report doesn't split it out by provider.

Sorry to hear about the viruses. An entry level business grade server is in the $800 price range. If you get one with Linux preinstalled, and if your computer person sets it up, then I think it's doable. So I think it's worth it to do this for the server, but I would go slowly if moving to Linux or ...

After you pointed me in the right direction, I read the MySQL manual for that section, and now I understand. A simple script could shorten a number of columns. And we'll keep in mind the 120 col limit because we're over half way there on the patient table.

When it works, it's great, but when it's slow, this forum is driving me nuts. As soon as our T1 line is installed, we'll move to our own server, and all this slowness will go away. Sorry.

Not possible yet. He's talking about a customized version that he was using. You can't do it without knowing how to program.

Thanks. I was already aware of it.

In r430, fcarlier comments, "Ran CTRL+K,CTRL+D on this document. This auto-updates the lay-out." The result seems to be an increase in white space. I'm OK with this. (of course, I don't think it's his intention to apply such a sweeping change to our trunk). I'll be rewriting the Coding Style page to...

Reducing field sizes will reduce the memory footprint? I'm not familiar with the ndbcluster table type, so I'm basing the following comments on how the MyISAM tables work. Changing the allowed length on varchar fields should have no effect at all on the diskspace because they only take up exactly as...

Nope. Can't duplicate it. Works just fine. So in a situation like this, we usually just convert it for the customer ourselves. I am also using MySQL 5.0, so my only guess as to what's going on is that you have customized some of your server variables, resulting in MySQL being more likely to give err...

Your database converted just fine on my system. I'm going to look into a few more things to try to make it crash, but I just wanted to let you know what was going on in case you were curious.

Someone has suggested that OD could be better optimized for clustering by having smaller tables. They also said clustering would help with multi-office scenarios. Both statements are false. Unless the people involved with this particular cluster setup can possibly clarify where these comments might ...

Not yet.

Thanks.

I'm just going to post issues as I run across them. 1. Why are you comparing all field values when deleting? I've always just used the primary key. 2. The reason for only sending the changed values to the database is not to enhance performance. It's to prevent mulituser concurrency issues. http://ww...

I've been reading the actual code now, and I have to say it's very elegant. The only part that's starting to scare me is the provider factory. I know it needs to be done, but there are just so many details involved. There are so many parts of the program that depend on the current code. There are so...

Are you kidding me? Tell me at least that it's a fairly new method that MS snuck in when I wasn't looking. Yes, of course we should move to that and simply get rid of the whole Copy thing altogether. Except there are a few rare situations where I think it's doing just a bit more, and I would worry a...

6. I think I tried to do a Data Object Factory a few years ago before we had generics. Couldn't figure it out. I avoid tools like NHibernate because I don't want to get locked in to their framework. Our random keys is a perfect example of why we need more flexibility than any such framework can prov...

No. I assumed they would not be annoying once you got used to them.

Did you ever call us to upload a copy of your database? This is very hard to do without a test database.

Yes, what you suggest works fine for almost all of the simpler smaller forms in the entire program. But it does not work well for the main pages of the main modules. It is much better in those complex windows to get back from the business layer one or a few simple tables which can just be tossed ont...

Thank you - Thank you - Thank you

You have done in one day what I have been attempting to do since day one. I strongly support inclusion of your changes in our trunk. But not right now. Please wait until 5.0 goes to beta, and the trunk moves to 5.1.

(sorry I did not intend to allow replies to my sticky post, so I had to move this)
DonDDS writes

We are back... and I am one of the first poster.... keep up the good work, Jordan. I hope your attorney bill is "open-source" too.
_________________
ex-Mogo, soon-to-be ex-Dentrix

I just talked on the phone with Dan, a longtime user who has spent the last 8 months branching out on his own code, and is now trying to merge back into the main version without losing all the functionality he built. The main feature he worked on was FIFO patient payments split by provider. (this is...

Hi, I've been, rather for the first time, having a deeper look at the architecture of Open Dental. One thing I'd like to propose is a further separation of the Data & UI Logic. The goal would somewhat be to end up with one DLL (OpenDentBusiness) that only contains the data logic (eg no references t...

Open Dental

Search found 5741 matches

New strategy for multiple offices

Stationary

Appointment bubble delay

Asterisk

Multiple offices

Version 5.0

5.0 beta timing

This forum is slow

Coding Style - White space

Clustering

RE: Wecome Back

FIFO provider splits

Further separation of Data & UI Logic