Search found 59 matches

by fdscadmin
Mon Jun 14, 2021 3:39 pm
Forum: Advanced Topics
Topic: DB DEFAULT VALUES
Replies: 6
Views: 11447

Re: DB DEFAULT VALUES

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?
by fdscadmin
Mon Jun 14, 2021 12:05 pm
Forum: Advanced Topics
Topic: DB DEFAULT VALUES
Replies: 6
Views: 11447

Re: DB DEFAULT VALUES

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 ...
by fdscadmin
Mon Jun 14, 2021 10:42 am
Forum: Advanced Topics
Topic: DB DEFAULT VALUES
Replies: 6
Views: 11447

Re: DB DEFAULT VALUES

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...
by fdscadmin
Mon Jun 14, 2021 9:41 am
Forum: Advanced Topics
Topic: DB DEFAULT VALUES
Replies: 6
Views: 11447

DB DEFAULT VALUES

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'...
by fdscadmin
Thu Feb 28, 2013 3:05 pm
Forum: Developers
Topic: Anyone try this?
Replies: 0
Views: 3454

Anyone try this?

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!!
by fdscadmin
Fri Dec 10, 2010 5:46 am
Forum: Advanced Topics
Topic: parameterized reports
Replies: 8
Views: 14444

Re: parameterized reports

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 ...
by fdscadmin
Thu Dec 09, 2010 12:01 pm
Forum: Advanced Topics
Topic: parameterized reports
Replies: 8
Views: 14444

Re: parameterized reports

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...
by fdscadmin
Tue Jul 06, 2010 11:19 am
Forum: Advanced Topics
Topic: Crystal Reports
Replies: 8
Views: 15286

Re: Crystal Reports

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.
by fdscadmin
Tue Feb 02, 2010 9:56 am
Forum: Developers
Topic: Claim Table.....
Replies: 5
Views: 6087

Re: Claim Table.....

Are there any guidelines to this "plugin architecture"?
by fdscadmin
Mon Feb 01, 2010 4:17 pm
Forum: Developers
Topic: Claim Table.....
Replies: 5
Views: 6087

Re: Claim Table.....

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?
by fdscadmin
Mon Feb 01, 2010 9:28 am
Forum: Developers
Topic: Claim Table.....
Replies: 5
Views: 6087

Claim Table.....

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...
by fdscadmin
Mon Feb 01, 2010 9:23 am
Forum: Main Forum
Topic: primary pulp on 3d graphic
Replies: 5
Views: 5757

Re: primary pulp on 3d graphic

Yes, perfect. (Pulps) For the space maint, I'll try the drawing method for now.
by fdscadmin
Wed Jan 27, 2010 4:54 pm
Forum: Main Forum
Topic: primary pulp on 3d graphic
Replies: 5
Views: 5757

Re: primary pulp on 3d graphic

Bump....

I think this would be an awesome feature along with graphically showing a space maintainer. Is this even on the radar right now?
by fdscadmin
Fri Nov 06, 2009 11:42 am
Forum: Advanced Topics
Topic: ANSI 835....
Replies: 3
Views: 6807

ANSI 835....

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...
by fdscadmin
Mon Aug 31, 2009 7:44 am
Forum: Developers
Topic: Roll your own....
Replies: 6
Views: 7202

Re: Roll your own....

Well I'm still stuck on this. I don't know why it can't update. Can anyone else compile and then update?
by fdscadmin
Thu Aug 27, 2009 8:37 pm
Forum: Developers
Topic: Roll your own....
Replies: 6
Views: 7202

Re: Roll your own....

Definitely no db changes.

No, I have never tried this before. I am using VS C# Express if that makes any difference.
by fdscadmin
Wed Aug 26, 2009 9:56 pm
Forum: Developers
Topic: Roll your own....
Replies: 6
Views: 7202

Re: Roll your own....

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"
by fdscadmin
Wed Aug 26, 2009 9:49 pm
Forum: Developers
Topic: Roll your own....
Replies: 6
Views: 7202

Roll your own....

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?
by fdscadmin
Wed Aug 26, 2009 1:17 am
Forum: Developers
Topic: Patch...
Replies: 6
Views: 6456

Re: Patch...

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.
by fdscadmin
Wed Aug 26, 2009 1:15 am
Forum: Developers
Topic: DB conversion error...
Replies: 7
Views: 8313

Re: DB conversion error...

Never mind...if i just hit continue it eventually converted.
by fdscadmin
Wed Aug 26, 2009 12:31 am
Forum: Developers
Topic: DB conversion error...
Replies: 7
Views: 8313

DB conversion error...

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?
by fdscadmin
Wed Aug 26, 2009 12:12 am
Forum: Developers
Topic: Patch...
Replies: 6
Views: 6456

Re: Patch...

OK, I fixed the tab to space conversion and did the commit. Is 6.8 going to be rolled out soon?
by fdscadmin
Tue Aug 25, 2009 7:49 pm
Forum: Developers
Topic: Receivables Report
Replies: 16
Views: 16008

Re: Receivables Report

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...
by fdscadmin
Tue Aug 25, 2009 7:16 pm
Forum: Developers
Topic: Patch...
Replies: 6
Views: 6456

Re: Patch...

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...
by fdscadmin
Tue Aug 25, 2009 4:09 am
Forum: Developers
Topic: Patch...
Replies: 6
Views: 6456

Patch...

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...
by fdscadmin
Thu Jul 09, 2009 5:27 am
Forum: Developers
Topic: ProcFee source/update
Replies: 3
Views: 4483

Re: ProcFee source/update

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?
by fdscadmin
Thu Jul 09, 2009 1:33 am
Forum: Developers
Topic: ProcFee source/update
Replies: 3
Views: 4483

ProcFee source/update

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 "...
by fdscadmin
Fri Dec 12, 2008 7:10 am
Forum: Advanced Topics
Topic: Linux + smb.conf
Replies: 17
Views: 24845

Re: Linux + smb.conf

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...
by fdscadmin
Thu Dec 11, 2008 8:55 am
Forum: Advanced Topics
Topic: Linux + smb.conf
Replies: 17
Views: 24845

Re: Linux + smb.conf

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...
by fdscadmin
Tue Dec 09, 2008 9:08 am
Forum: Developers
Topic: 6.2 Beta Release...
Replies: 2
Views: 5546

Re: 6.2 Beta Release...

Thanks....I'll download it and see if my changes made it in there.
by fdscadmin
Mon Dec 08, 2008 6:13 am
Forum: Developers
Topic: 6.2 Beta Release...
Replies: 2
Views: 5546

6.2 Beta Release...

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...
by fdscadmin
Thu Feb 14, 2008 12:02 pm
Forum: Developers
Topic: Best way to deploy....
Replies: 3
Views: 8825

Awesome. Even better.

thanks again.
by fdscadmin
Thu Feb 14, 2008 10:00 am
Forum: Developers
Topic: Best way to deploy....
Replies: 3
Views: 8825

Best way to deploy....

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...
by fdscadmin
Wed Feb 13, 2008 8:25 am
Forum: Developers
Topic: 5.6 ETA??
Replies: 5
Views: 7966

Got it. Thanks for the commit.
by fdscadmin
Tue Feb 12, 2008 9:21 am
Forum: Developers
Topic: 5.6 ETA??
Replies: 5
Views: 7966

Any thoughts on this?
by fdscadmin
Mon Feb 11, 2008 9:33 am
Forum: Developers
Topic: 5.6 ETA??
Replies: 5
Views: 7966

Awesome...

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.
by fdscadmin
Thu Feb 07, 2008 12:07 pm
Forum: Developers
Topic: 5.6 ETA??
Replies: 5
Views: 7966

5.6 ETA??

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

thanks
by fdscadmin
Wed Jan 16, 2008 4:13 pm
Forum: Advanced Topics
Topic: Production Query....
Replies: 0
Views: 2609

Production Query....

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...
by fdscadmin
Thu Sep 27, 2007 10:48 am
Forum: Developers
Topic: Bug fix beta's
Replies: 1
Views: 3990

Bug fix beta's

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 ...
by fdscadmin
Thu Sep 27, 2007 10:40 am
Forum: Developers
Topic: 5.3b ?
Replies: 4
Views: 7543

5.3b ?

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...
by fdscadmin
Wed Sep 26, 2007 10:38 am
Forum: Developers
Topic: Miscellaneous Setup.
Replies: 2
Views: 5029

Miscellaneous Setup.

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.
by fdscadmin
Mon Sep 24, 2007 2:11 pm
Forum: Developers
Topic: Procedure.UnitQty
Replies: 3
Views: 6036

Open Files.

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.
by fdscadmin
Mon Sep 24, 2007 1:37 pm
Forum: Developers
Topic: Procedure.UnitQty
Replies: 3
Views: 6036

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.
by fdscadmin
Mon Sep 24, 2007 1:32 pm
Forum: Developers
Topic: Missing File.
Replies: 1
Views: 4125

Missing File.

Seem to be missing file FormReferralsPatient.cs after my last update
by fdscadmin
Wed Sep 19, 2007 2:19 pm
Forum: Developers
Topic: Billing Puzzle.
Replies: 2
Views: 4987

Yes.

I like that idea. I think that will also make neater code. I will give it a shot.
by fdscadmin
Wed Sep 19, 2007 8:19 am
Forum: Developers
Topic: Billing Puzzle.
Replies: 2
Views: 4987

Billing Puzzle.

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...
by fdscadmin
Wed Sep 19, 2007 7:31 am
Forum: Developers
Topic: Appointment pop-ups.
Replies: 5
Views: 9188

Thanks.

I have been swamped.
by fdscadmin
Mon Sep 10, 2007 8:47 am
Forum: Developers
Topic: Appointment pop-ups.
Replies: 5
Views: 9188

Appointment pop-ups.

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.
by fdscadmin
Thu Aug 30, 2007 3:55 pm
Forum: Developers
Topic: A project with an Output Type of Class Library cannot be s..
Replies: 2
Views: 5114

That did it.

Thanks. Worked like a charm.
by fdscadmin
Thu Aug 30, 2007 3:53 pm
Forum: Developers
Topic: FormClaimEdit...
Replies: 6
Views: 9303

Yes.

Yes.
by fdscadmin
Thu Aug 30, 2007 2:54 pm
Forum: Developers
Topic: A project with an Output Type of Class Library cannot be s..
Replies: 2
Views: 5114

A project with an Output Type of Class Library cannot be s..

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...
by fdscadmin
Thu Aug 30, 2007 2:03 pm
Forum: Developers
Topic: FormClaimEdit...
Replies: 6
Views: 9303

Yep.

Should I commit this to 5.1 also? Probably for clarity. How to I commit to 5.1?
by fdscadmin
Thu Aug 30, 2007 9:44 am
Forum: Developers
Topic: FormClaimEdit...
Replies: 6
Views: 9303

Done.

Done.
by fdscadmin
Wed Aug 29, 2007 11:03 pm
Forum: Developers
Topic: Wrap up 5.1
Replies: 7
Views: 11277

Hmm..

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...
by fdscadmin
Mon Aug 27, 2007 9:51 am
Forum: Developers
Topic: FormClaimEdit...
Replies: 6
Views: 9303

FormClaimEdit...

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?
by fdscadmin
Wed Aug 22, 2007 9:40 am
Forum: Developers
Topic: Currency Format
Replies: 3
Views: 6503

One thought

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.
by fdscadmin
Wed Aug 22, 2007 9:04 am
Forum: Developers
Topic: Currency Format
Replies: 3
Views: 6503

Currency Format

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...
by fdscadmin
Wed Aug 22, 2007 8:51 am
Forum: Developers
Topic: Missing file?
Replies: 2
Views: 5535

Update..

I just noticed that too. Thanks for the placeholder.
by fdscadmin
Thu Aug 09, 2007 2:46 pm
Forum: Advanced Topics
Topic: Asterisk
Replies: 21
Views: 29654

Fun tinkering....

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