Open Dental Forum

fdscadmin

Sounds good to me...in the interim (and to avoid direct altering of data in tables) is it recommended to add custom tables to existing db or add another db entirely?

fdscadmin

Sooo was looking at the Plugin option thinking we could use the DB interface already built by OpenDent, but it also looks like that is frowned up also? So if I'm understanding this correctly the only supported way to update the DB is through the API being developed? It also looks like there will be ...

fdscadmin

Ok that makes more sense if you have your own logic on the application side. Yes I've browsed the API but it doesn't have the features we need yet. We are dealing with some unique scenarios of importing 835 files. I didn't know INSERTS and UPDATES were considered dangerous to the application....I'll...

fdscadmin

Is there any particular reason that many of the tables do not have default values set for all the columns? I'm just wondering if this is by design or mostly because they weren't setup when the DB was designed. I'm working on some integration stuff and having to address every column is cumbersome. I'...

fdscadmin

This is really cool...anyone else try this? I swap db connections a lot (for testing and dev) and I wish I had this a long time ago.

http://www.opendent-utils.com

and it's free!!

fdscadmin

The report spec is actually open so if someone REALLY wanted to do this in C# they could, but I think it would be easier to just embed the java. I have written so many reports for this engine I would love this feature, but I think the biggest benefit would be the ability to share these reports with ...

fdscadmin

You should really look into iReports... http://jasperforge.org/projects/ireport . I have spent many hours looking for a good reporting solution and this is the best one I have found. It's not perfect, but it does do the job. The reporting engine can probably be embedded into OD if someone cared to d...

fdscadmin

Try iReports (download from sourceforge). I have written a *lot* of reports with iReports and it only gets better. I would be happy to help if needed.

fdscadmin

Are there any guidelines to this "plugin architecture"?

fdscadmin

I like the idea, but I think it would be too much work for a few additional fields on a claim form. Any other thoughts?

fdscadmin

I would like to add another ProvNum to the Claim Table called "ProvAttend". The user will select this provider in the claim edit window. The user will be selecting the "Attending Provider" commonly used to bill for anesthesia services on the UB04. Any comments? Edit: How do I Commit code now? I have...

fdscadmin

Yes, perfect. (Pulps) For the space maint, I'll try the drawing method for now.

fdscadmin

Bump....

I think this would be an awesome feature along with graphically showing a space maintainer. Is this even on the radar right now?

fdscadmin

Oh boy. I just had the strangest conversation with Emdeon. I had signed up for ERA thinking I could download the 835 file from their website and parse and post myself, but no dice. Apparently I don't have access to that information directly and it seems that I need to have the file downloaded from w...

fdscadmin

Well I'm still stuck on this. I don't know why it can't update. Can anyone else compile and then update?

fdscadmin

Definitely no db changes.

No, I have never tried this before. I am using VS C# Express if that makes any difference.

fdscadmin

One issue I have found so far is that when I click "Check for Updates" I get the error

"Error: Unable to connect to the remote server"

fdscadmin

In an effort to deliver "patches" quickly to my facility I would like to install my own compiled version, but still be able to update through main. I have no desire to stray from the main branch, I just want to deploy these things faster. Will I run into any issues doing this?

fdscadmin

You know I can't answer a question like that.

Oh, I didn't know. I'm not on the boards a lot so I am a bit out of the loop.

fdscadmin

Never mind...if i just hit continue it eventually converted.

fdscadmin

I am trying to test the latest build, but there are troubles when it try to convert my test db. The db is version 6.3.4.0->6.8.0.0. I get the following error:

"ContextSwitchDeadlock was detected"

anyone else with this problem? Solutions? Thoughts?

fdscadmin

OK, I fixed the tab to space conversion and did the commit. Is 6.8 going to be rolled out soon?

fdscadmin

Oh boy, I love a good A/R report discussion. I have been writing reports for OD for quite a while, but I have been using iReports and querying the DB direct. A good A/R report should be broken down by payer. This is so you can see who your problem payers are. Additionally if you are on an accrual ba...

fdscadmin

Ok, I will re-submit the patch with the formatting corrected. I just wasn't exactly sure of the commit process anymore. I was also working with the latest stable version (6.6.25). I will create a patch from HEAD. Is there any way to "deploy" a stable (6.6.25) version with a patch and still stay inli...

fdscadmin

Where do I send a proposed patch? This will pull fees from the medical ins if it is a medical procedure...thanks. I know the formatting is ugly, and I can correct it. I just want to get an idea of the process. I used to have commit priv, but don't think I still do. Index: OpenDental/Main Modules/Con...

fdscadmin

No problem...looks like tortoise creates a nice patch. However before I submit it I would like to test it. I just updated my source directory from head and I can't compile without a raft of errors. Are there major changes in the works?

fdscadmin

I was doing some looking through the code and I was wondering if I could make a change regarding the calculation of the ProcFee? Currently it appears to get the fee from the priinsplan, patient, then provider. I would like to add a check for the type of code (IsMedical) and return the fee from the "...

fdscadmin

You don't have problems on Linux getting all the dependencies installed correctly when you upgrade a program? It's a messy messy chain of dependencies. If you don't get just the right version of such-and-such package installed correctly, none of the other dependent programs will work. And every tim...

fdscadmin

I've left my Windows server running for many many months. It never crashes or requires a restart. The only reason I initially explored Linux was to avoid licensing hassles and connection limits. But I now know, years later, that there is no connection limit to a port. So a simple Windows workstatio...

fdscadmin

Thanks....I'll download it and see if my changes made it in there.

fdscadmin

Is there any thoughts of a 6.2 beta coming out anytime soon? There is a bug fix that I need to distribute, but I always try to stick to the official distribution as much as I can. On that same thought, is there an official time line or release calendar that I can follow? I think it would be really h...

fdscadmin

Awesome. Even better.

thanks again.

fdscadmin

There were some code commits to the 55 branch on 2-12 that I would like to deploy, but I notice that the "official" update was released on 2-8. Can anyone help me with the best way to deploy (or create msi) from the source. I currently use VC# Express 2008 and I'm not too familiar with how to create...

fdscadmin

Got it. Thanks for the commit.

fdscadmin

Any thoughts on this?

fdscadmin

I tried d/l the 5.5 branch, but I didn't have permissions to make the commit. Specifically lines 107 - 114 in Ledgers.cs were changed to correct the ageing not including unit qty's. If you back ported those lines that would be great.

Thanks.

fdscadmin

Is there a roadmap/ETA for 5.6? There are some bug fixes that I am dying to deploy.

thanks

fdscadmin

I am working on a custom "Production" report and I am stuck on the patient income issue. It seems that we can post payments to an account without "having" to attach the payment to claimprocs. The problem with this is that it is difficult to query for total-production-after-payments when all payments...

fdscadmin

I know that once a beta is rolled out there are no more public commits (which makes sense). However, is it possible to have an alpha release that is packaged from a branch that the devs can still commit to? I would love to be able to roll out fixes over-night while still staying in the main upgrade ...

fdscadmin

A few things finished: 1. Box 57 and 58 of the UB04 are now functional which should allow some facilities to start billing for facility fees (YES!) 2. Procedure codes now support base units with the ability to include them on the 1500 if the payer wants to see them (Display does not affect billed am...

fdscadmin

If there are no objections I would like to add a "Billing" group in the Miscellaneous Setup screen to put all the billing related widgets.

fdscadmin

I'm mostly working on adding base unit support to the procedure table and procedure log. I might need to update the "total" fee and estimate calculations to include base units if they are assigned.

fdscadmin

Yes. That would make sense for it to be an int. The same for BaseUnits. I am working on that section now, so I will make the changes.

fdscadmin

Seem to be missing file FormReferralsPatient.cs after my last update

fdscadmin

I like that idea. I think that will also make neater code. I will give it a shot.

fdscadmin

One of the things I love about coding is solving interesting problems. Here is one that I am currently working on. Anesthesia billing: All anesthesia is billed by units. A unit in this example will be 15min. So if you administer anesthesia for 60min you would need to bill for 4 units. In addition to...

fdscadmin

I have been swamped.

fdscadmin

Is there an option (or one in the works) to disable the appointment pop-ups?

If not, would anyone be opposed to me making one? I can put it in the "User Interactions" group in the Miscellaneous Setup options.

fdscadmin

Thanks. Worked like a charm.

fdscadmin

fdscadmin

I am now getting this message when I go to run/debug from C# Express. " A project with an Output Type of Class Library cannot be started directly. In order to debug this project, add an executable project to this solution which referenced the library project. Set the executable project as the startu...

fdscadmin

Should I commit this to 5.1 also? Probably for clarity. How to I commit to 5.1?

fdscadmin

Done.

fdscadmin

I just noticed something interesting with the UnitQty field in the procedure log. When a procedure has a number of units (like anesthesia) the fee for that procedure needs to be multiplied by the # of units for it to make sense. I started to make the changes, but I wanted to bring this up in case an...

fdscadmin

Oops. I didn't realize that I messed things up for smaller screens. I was just trying to make it clear that those sections of the claim aren't just for dental so I moved them off the 'dental' tab.

Could I re-arrange them again if I make sure the tabbed pane is reduced vertically?

fdscadmin

I know this is a little hackish, but we could just multiply the number by 100 right before we display it. We could enter "NoDec" as the FormatString and use it in an if-then or case to trigger the multiplication.

fdscadmin

I thought I had this figured out, but..... I have some currency claim form fields that need to be displayed without the decimal. I had thought that setting the FormatString to 0'00' was doing this until I realized that it was not including cents. Example: 340.25 is showing as 34000 when is should be...

fdscadmin

I just noticed that too. Thanks for the placeholder.

fdscadmin

I can say from experience that asterisk is fun to tinker with...HOWEVER.... I have installed three asterisk based phone systems sold and supported by a prominent vendor and this is my experience. 1. ALWAYS get your phone cards with HARDWARE echo cancellation technology..ESPECIALLY when using analog ...

Search found 59 matches