Search found 172 matches

by nathansparks
Wed Mar 15, 2023 12:42 pm
Forum: API
Topic: The API and HIPAA compliance
Replies: 1
Views: 1188

Re: The API and HIPAA compliance

This is my position, and loosely, the position of Open Dental at this time, and is not legal advice. As a third party, whether the patnum (by itself with no medical information) is PHI or not isn't really the point, the fact is that ALL third parties using the API should know they are acting as a Bu...
by nathansparks
Thu Feb 03, 2022 6:32 pm
Forum: API
Topic: Local API
Replies: 3
Views: 2911

Re: Local API

I was asked about this post and wanted to clarify, as the person was concerned about opening a port on their server. The opened port for the planned econnector version would be opened only to your local network (like for MySQL or MariaDb). Even this is not required to call the API on the econnector ...
by nathansparks
Thu Nov 05, 2020 10:33 am
Forum: Main Forum
Topic: New Care Credit Integration Setup Problem
Replies: 13
Views: 12918

Re: New Care Credit Integration Setup Problem

No, it is not currently part of eServices. It is a third party program link available to customers with proprietary third party code that is not Open Source. We may add eServices that offer Care Credit functions in the future (I like the idea).
by nathansparks
Wed Nov 04, 2020 12:01 pm
Forum: Main Forum
Topic: New Care Credit Integration Setup Problem
Replies: 13
Views: 12918

Re: New Care Credit Integration Setup Problem

so, the open source model for "Open Dental" is no longer the case? Good question! This answer to the question is that Open Dental is still Open Source, nothing has changed. This 'program link' content, in this case, is protected by a licensing agreement with a third party. Third party/program link ...
by nathansparks
Mon Aug 24, 2020 1:21 pm
Forum: Developers
Topic: Writing to the db is discouraged, but the API is very barebones, what do I do?
Replies: 15
Views: 20013

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

I have researched with our engineers at Open Dental and you can already set an appointment status (like scheduled) and appointment confirmation status. However, right now you are limited on appointment confirmation status to unconfirmed (like all new appointments) and confirmed (default in Open Dent...
by nathansparks
Mon Aug 24, 2020 9:48 am
Forum: Developers
Topic: Writing to the db is discouraged, but the API is very barebones, what do I do?
Replies: 15
Views: 20013

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

I would add that editing appointment confirmation status for patient arrival, confirmed (which is what started the thread) is allowed with the API but I think it needs to be improved, because it was designed to match the FHIR specification, and instead we need to expand it to allow for more custom s...
by nathansparks
Wed Oct 23, 2019 9:40 am
Forum: Main Forum
Topic: Charting Slider, setting original existing condition dates
Replies: 2
Views: 5879

Re: Charting Slider, setting original existing condition dat

This is not an issue unless you are manually entering paper charting from previous times. If a customer ever calls in about this we might change it, we have not had a call about this before but you make a good point. It was designed this way on purpose, to show EO and EC on the date they were entere...
by nathansparks
Wed Oct 23, 2019 9:34 am
Forum: Main Forum
Topic: Update taking a long time (getting longer)
Replies: 3
Views: 5963

Re: Update taking a long time (getting longer)

Updates are not taking longer than they did before in general, but only because as you suggest, your database is larger. The reason we have you call in is to prevent people from doing this who maybe should not.
by nathansparks
Wed Oct 02, 2019 9:31 am
Forum: Main Forum
Topic: Moving away from plug-ins
Replies: 10
Views: 26316

Re: Moving away from plug-ins

We are not discouraging plugins at this point and do not have plan to end support. For many of the things third parties want to do, plugins make the most sense. For some cases, FHIR will make more sense. At this point, plugins are the most powerful way to change or add on to how Open Dental works in...
by nathansparks
Tue Aug 20, 2019 3:17 pm
Forum: Main Forum
Topic: Security in the cloud and why moving to the cloud is best fo
Replies: 4
Views: 6814

Re: Security in the cloud and why moving to the cloud is bes

I will answer this question: Question: I love Open Dental and I feel every penny I pay for support is well worth it. However, when I look into my crystal ball at 5-10 years down the road, the "open" part of Open Dental seems to be deteriorating and this saddens me. It's extremely frustrating that th...
by nathansparks
Wed Dec 19, 2018 9:23 am
Forum: Main Forum
Topic: TSI Collection Agency BAD experience reporting
Replies: 14
Views: 15466

Re: TSI Collection Agency BAD experience reporting

Happysapiensdental: In fact, if you connect to TSI outside of Open Dental (which is fine), you will have the same issue with the insurance payments unless you violate your agreement with TSI. You must report the insurance payments whether automatically or through TSI's portal or some other way. It i...
by nathansparks
Fri Dec 14, 2018 11:43 am
Forum: Main Forum
Topic: TSI Collection Agency BAD experience reporting
Replies: 14
Views: 15466

Re: TSI Collection Agency BAD experience reporting

Dear Happysapiensdental, I take two issues here that we can address, one from your original post and one from your follow-up. 1. Insurance payments should not be considered as payments form the patient. Perhaps expected insurance payments should also be subtracted from patient balance sent to TSI? B...
by nathansparks
Wed Jul 11, 2018 3:47 pm
Forum: Advanced Topics
Topic: Debugging password exposure
Replies: 3
Views: 6573

Re: Debugging password exposure

The MySQL password is not stored in the database. The OD admin password is not stored in the database. But, do not use one the same exact password for both, or in general for any two applications where security is important. There is a possibility that your clearinghouse password may be the same and...
by nathansparks
Tue Oct 31, 2017 1:01 pm
Forum: Advanced Topics
Topic: NewCropRx failing to send eRx
Replies: 3
Views: 6302

Re: NewCropRx failing to send eRx

NO, do NOT call them directly, Chris is incorrect, we are not supposed to have anyone call them, we will call them.
by nathansparks
Tue Jun 06, 2017 3:31 pm
Forum: Main Forum
Topic: making new appointments set confirm to 'arrive
Replies: 1
Views: 4907

Re: making new appointments set confirm to 'arrive

Easy to fix, not related to version of Open Dental, not new. Just go to setup, definitions, Appt Confirmed and move the one you want to use as the default to the top using the Up and Down buttons. Someone edited that order, that is the only explanation. You will need to pay even more attention to th...
by nathansparks
Fri Nov 04, 2016 12:10 pm
Forum: Main Forum
Topic: SMS from Unassigned Patient
Replies: 5
Views: 11776

Re: SMS from Unassigned Patient

I like these ideas, I will have our engineers write these up into feature requests that you can vote on. Putting just one vote on a feature request will mean you get notified when we add the feature. I will treat most of these with high priority.
Nathan Sparks (CEO Open Dental)
by nathansparks
Tue Oct 04, 2016 2:35 pm
Forum: Advanced Topics
Topic: Recall Interval
Replies: 4
Views: 8677

Re: Recall Interval

Mifa, I know it has been a while, but in case you still care, this will pull your values, for recall type table SELECT DefaultInterval, (DefaultInterval>> 24) AS Years, (DefaultInterval>>16<<16)-(DefaultInterval>>24<<24)>>16 AS Months, (DefaultInterval>>8<<8)-(DefaultInterval>>16<<16)>>8 AS Weeks, D...
by nathansparks
Fri Sep 09, 2016 5:02 pm
Forum: Main Forum
Topic: EOB images and rotating image
Replies: 4
Views: 7873

Re: EOB images and rotating image

We have just never had that requested. Good idea. Put in a Feature Request and send me an email with the feature request number to nate.sparks@opendental.com and I will have that feature added.
by nathansparks
Thu May 19, 2016 9:25 am
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42975

Re: Backup files have large size.

We should begin working on an archive protocol for tables, and add functionality within the program for each one as we add it. Unfortunately, while there are some groups that could be considered, many tables will have distinct archive functionality. Clinical items (think procedures , prescriptions e...
by nathansparks
Tue May 10, 2016 10:24 am
Forum: Main Forum
Topic: Web version
Replies: 23
Views: 37571

Re: Web version

They will certainly work from the same database. My hope is to add limited tablet functionality first, as duplicating the entire program in a browser is more difficult and having some tablet functionality sooner makes more sense to me right now.
by nathansparks
Fri May 06, 2016 12:34 pm
Forum: Main Forum
Topic: Web version
Replies: 23
Views: 37571

Re: Web version

A browser based version (as opposed to the current middle tier web connection) cannot have plugins 'just work' because it won't even have hooks, and is coded from scratch in another language. There won't (can't be) be plugins. But the main Open Dental version is not going anywhere, and this is not a...
by nathansparks
Fri Feb 19, 2016 9:40 am
Forum: Developers
Topic: HookAddCode Request
Replies: 6
Views: 14350

Re: HookAddCode Request

I would caution that this may not the best place for a hook. If you are not using the Open Dental built in texting, this form is not the right place to be putting your text messages. You should hook in to the patient level send text button perhaps, but this form is specific to Open Dental two way te...
by nathansparks
Wed Nov 04, 2015 9:04 am
Forum: Main Forum
Topic: Email to patient after a referral
Replies: 8
Views: 13585

Re: Email to patient after a referral

I will investigate how this happened and back port a fix if possible.
by nathansparks
Mon Aug 17, 2015 4:49 pm
Forum: Main Forum
Topic: text reminders
Replies: 15
Views: 21122

Re: text reminders

Thanks for being a beta tester on this Rick. The issue you had with some texts not going through seems to have been related to the outbound number: we do not have control over previous 'abuse' of a number (most numbers have some history at this point) that may have caused issues with carriers, but w...
by nathansparks
Mon Aug 17, 2015 4:29 pm
Forum: Main Forum
Topic: Encrypting Open Dental on the cloud
Replies: 12
Views: 22305

Re: Encrypting Open Dental on the cloud

Latency and speed are both possible issues. Latency can be caused by speed issues (ie you have 1000 packets lined up to traverse your gateway and time elapses while they take turns) or can exist simply due to the nature of your connection. In Open Dental you can use the Tools>Misc Tools>Test Latency...
by nathansparks
Tue Jul 15, 2014 3:31 pm
Forum: Main Forum
Topic: Issues with how procedures are assigned to providers
Replies: 3
Views: 4310

Re: Issues with how procedures are assigned to providers

I (Open Dental Staff) had another customer call in about this and point me here. You may just need to make the hygienist the 'dentist' for any appointments where you want all of the procedures to go to the hygienist, so to default the behavior that way on the schedule (others should use the operator...
by nathansparks
Tue Mar 12, 2013 12:30 pm
Forum: Main Forum
Topic: G5 Conversion..
Replies: 7
Views: 7644

Re: G5 Conversion..

Dentrix can perform the decryption for you, and if that ever changes we will attempt to provide an Open Dental internal solution.
by nathansparks
Tue Mar 12, 2013 12:24 pm
Forum: Main Forum
Topic: XDR and MySQL
Replies: 4
Views: 6309

Re: XDR and MySQL

When a software company supports a client, there may be (and have been) database version specific behaviors. For instance, Open Dental generally requires a specific version of MySQL: you can use another version, but then we cannot address any issues you have related to behavior of that MySQL instanc...
by nathansparks
Tue Mar 12, 2013 12:13 pm
Forum: Main Forum
Topic: Patient collections
Replies: 3
Views: 4522

Re: Patient collections

sarrahlynn, I think you should call Open Dental and talk this over with me (Nathan). The amount that insurance is expected to pay you on the customer's behalf is still their debt, and so as part of the account balance it ages. The aging report does show and subtract the expected insurance for the pa...
by nathansparks
Tue Jul 31, 2012 3:10 pm
Forum: Main Forum
Topic: Sharing
Replies: 7
Views: 7564

Re: Sharing

I would post a request for content here.
by nathansparks
Tue Jul 31, 2012 3:07 pm
Forum: Main Forum
Topic: Referred Procedure Tracking
Replies: 3
Views: 3973

Re: Referred Procedure Tracking

create one referral per procedure, they can both be attached to the same referral slip, but each referred procedure has a distinct connection to the referral.
by nathansparks
Tue Jul 31, 2012 3:00 pm
Forum: Main Forum
Topic: Superfamily
Replies: 1
Views: 2524

Re: Superfamily

Normal families are account based, so they share an account balance (although there are also patient balances within) and generally get one statement. Say you have a married couple that wants separate accounts and statements. Just have two families and put them in a superfamily, that way you know th...
by nathansparks
Wed Mar 28, 2012 12:54 pm
Forum: Main Forum
Topic: Report Help
Replies: 1
Views: 2720

Re: Report Help

What browser and operating sytem are you using? There are invisible characters at the end of each line that are being stripped by whatever method you are grabbing the query, try copying this and see if you have the same result, it works fine for me: /*303 List of active patients with no appointments...
by nathansparks
Thu Mar 01, 2012 4:01 pm
Forum: Main Forum
Topic: PracticeWorks vs Open Dental
Replies: 4
Views: 5176

Re: PracticeWorks vs Open Dental

The first Lighthouse Open Dental demonstration had a rocky start due to Open Dental not expecting the quantity of attendees that showed, and that exceeded the number that our GoToMeeting software could accomodate. Within a few minutes we switched to 'GoToWebinar' which has a 200 attendee limit vs 20...
by nathansparks
Fri Feb 10, 2012 9:18 pm
Forum: Main Forum
Topic: Insurance Rollover Maximums
Replies: 5
Views: 5407

Re: Insurance Rollover Maximums

You can simply add an 'adjustment to insurance benefits' in the upper right of the edit insurance plan window http://opendental.com/manual/insplan.html. I have not seen a request for an automation for this, probably because it is not too common and perhaps because it might not be accurate unless you...
by nathansparks
Mon Dec 12, 2011 4:24 pm
Forum: Main Forum
Topic: Popups for Tasks
Replies: 5
Views: 4744

Re: Popups for Tasks

You have to subscribe to the tasklists that you want to pop up for you (right click on task or tasklist, subscribe). Are you subscribed?
by nathansparks
Wed Oct 26, 2011 10:23 am
Forum: Main Forum
Topic: Wireless Signature Pad
Replies: 4
Views: 6947

Re: Wireless Signature Pad

Jordan, it has been well over a year and I thought you could elaborate or update? Would a feature request be the next step (like adding a diffferent brand) or contacting Topz to sort out any issues?
by nathansparks
Mon Oct 17, 2011 9:49 am
Forum: Main Forum
Topic: A "Dashboard" stats view in 11.1?
Replies: 6
Views: 6527

Re: A "Dashboard" stats view in 11.1?

Jordan will answer your question authoritatively, but it would be very difficult to graph custom reports because they are custom, the interface would be complex, so probably no time soon. That feature will need to get more fleshed out first anyhow, allowing custom queries would be premature. But I t...
by nathansparks
Mon Oct 17, 2011 9:44 am
Forum: Main Forum
Topic: Need an Audit Trail note for Lighthouse confirmations
Replies: 9
Views: 14859

Re: Need an Audit Trail note for Lighthouse confirmations

The third party (Lighthouse) is probably putting data directly into Open Dental, so there is no user logged in, Open Dental client is not even involved, so no way for Open Deental to put entry in audit trail. The only way to do it would be to have lighthouse change how it 'talks' to open dental, Lig...
by nathansparks
Tue Aug 30, 2011 10:10 am
Forum: Main Forum
Topic: Automation Conditions
Replies: 1
Views: 2578

Re: Automation Conditions

All conditions must be met, so like an 'and'. For now just make multiple automations instead of 'OR'.
by nathansparks
Tue Aug 30, 2011 10:06 am
Forum: Main Forum
Topic: Scan my form into sheets
Replies: 9
Views: 8216

Re: Scan my form into sheets

look in your shared folder, what we call the A-z folder, there is a sub folder called SheetImages. It is in there.
by nathansparks
Thu Apr 28, 2011 7:58 am
Forum: Main Forum
Topic: How not to print the history in perio charts
Replies: 3
Views: 4055

Re: How not to print the history in perio charts

It is feature request #1206.
by nathansparks
Thu Apr 28, 2011 7:55 am
Forum: Main Forum
Topic: Direct X tooth charting continues fail despite upgrade.
Replies: 20
Views: 15237

Re: Direct X tooth charting continues fail despite upgrade.

We will try and purchase a similar machine for our next desktop workstation, this might not be in time for you, so you probably should try an nVidia card (keep receipt in c ase it does not work). Call me once you have the card if it seems to not work and you are on support and I can try various mode...
by nathansparks
Wed Apr 27, 2011 6:28 am
Forum: Main Forum
Topic: Direct X tooth charting continues fail despite upgrade.
Replies: 20
Views: 15237

Re: Direct X tooth charting continues fail despite upgrade.

*Other than my last post above, I would note that I have seen situations where some display modes did not allow directX to work properly. I have even had an adjustment of the refresh rate (from 60hz to 70hx I think) 'make' directx work. **I would try put the display in native mode (highest resolutio...
by nathansparks
Wed Apr 27, 2011 6:19 am
Forum: Main Forum
Topic: Direct X tooth charting continues fail despite upgrade.
Replies: 20
Views: 15237

Re: Direct X tooth charting continues fail despite upgrade.

This: Operating System: Windows 7 Professional 32-bit (6.1, Build 7600) (7600.win7_gdr.101026-1503) Language: English (Regional Setting: English) System Manufacturer: Dell Inc. System Model: OptiPlex 380 BIOS: Phoenix ROM BIOS PLUS Version 1.10 A01 Processor: Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93G...
by nathansparks
Mon Apr 25, 2011 11:09 am
Forum: Main Forum
Topic: mysql version
Replies: 6
Views: 6606

Re: mysql version

You can remain on 5.0.22, and we would have said indefinitely, but upwards of 25% (maybe higher, it is hard to measure) of users start getting MySQL Error 17 or other error codes from MySQL starting in version 7.7 (really 7.8 now since 7.7 was moved back into beta and never moved out again). The use...
by nathansparks
Mon Apr 25, 2011 10:55 am
Forum: Main Forum
Topic: copayment calculation
Replies: 1
Views: 2827

Re: copayment calculation

Yes, just put in 0% for your insurance percentages in the edit benefits window insidet the claim edit window (go to claim edit window in accoutn module, then double ckick on the right hand side 'benefits', set all benefits to zero % for each patient as they come in. YOu could do it in the edit insur...
by nathansparks
Tue Mar 29, 2011 8:50 am
Forum: Main Forum
Topic: How to get forms to the Kiosk
Replies: 2
Views: 3437

Re: How to get forms to the Kiosk

Jordan can we add this to web page http://www.opendental.com/manual/patien ... minal.html?
by nathansparks
Wed Mar 23, 2011 6:59 am
Forum: Main Forum
Topic: Server Specification
Replies: 6
Views: 6898

Re: Server Specification

My 2cents: You should still use peer to peer, a domain is nice for larger networks where you want to be able to control the permissions of multiple user/groups centrally, or distribute software to many clients without having to physically go to the machine, but requires more IT knowledge and there i...
by nathansparks
Wed Mar 23, 2011 6:56 am
Forum: Main Forum
Topic: Database Access
Replies: 5
Views: 5674

Re: Database Access

There will always be an option to turn off the 'do not show window on startup' while logged in to Open Dental, then restart. YOu can do this now, and you will be able to in the future. A very nice feature would be to be able to specify the database as a command line argument so you could have icons ...
by nathansparks
Wed Mar 23, 2011 6:53 am
Forum: Main Forum
Topic: new server
Replies: 3
Views: 4350

Re: new server

If you are on stable version (7.6.x) you should use mysql 5.0.22, otherwise use 5.5.x ( I thinki it is 5.5.9) if you are using Open Dental 7.8.x.
by nathansparks
Wed Mar 23, 2011 6:49 am
Forum: Main Forum
Topic: Problem downloading updates
Replies: 3
Views: 4074

Re: Problem downloading updates

I am not sure why an MSI is involved at all. Do you have the 'show buttons for MSI' checkbox checked in help>update>setup? Next time you update, try it with me. My hours are 9-5 pacific, but I can always stay late. Email me at nate.sparks@opendental.com so we can set up an appointment or call our ma...
by nathansparks
Wed Jan 19, 2011 3:33 pm
Forum: Developers
Topic: Need a trial version > 6.9.22
Replies: 1
Views: 3283

Re: Need a trial version > 6.9.22

Dr Stark, sorry no reply to your question, probably because there is no good news for you. We update the trial version about every six months, with no intention to increase the frequency. Unfortunately it looks like you have a valid need, but we just do not have the bandwidth to do it more often. Al...
by nathansparks
Wed Jan 19, 2011 3:24 pm
Forum: Main Forum
Topic: Sheets, Webforms. Submit Button?
Replies: 9
Views: 7536

Re: Sheets, Webforms. Submit Button?

Thanks for the pointer on that, I will let our staff know too.
by nathansparks
Wed Jan 19, 2011 3:23 pm
Forum: Main Forum
Topic: Quickbooks Deposit slip
Replies: 16
Views: 21462

Re: Quickbooks Deposit slip

Jordan will have to answer, I saw you also have an open issue with our staff on this, I would put my 50 cents that it is a feature request. The key question for me is whether the quickbooks deposit slip will be accepted by the bank if that subtotal for cash is absent in a deposit including cash.
by nathansparks
Fri Jan 14, 2011 1:10 pm
Forum: Main Forum
Topic: Address on the claim form.
Replies: 1
Views: 2617

Re: Address on the claim form.

Thanks for your post, I don't think shrinking the font will help anything, and the second line for the treating dentist should not matter because nothing should be sent back from the insuance company to the treating dentist: that treating dentist address is superfluous I think. The electronic claim ...
by nathansparks
Tue Jan 11, 2011 7:03 am
Forum: Main Forum
Topic: Real production numbers rolled back?
Replies: 16
Views: 12649

Re: Real production numbers rolled back?

It appears that while the production numbers shown in the appointment module used to take into account only the production shown on the schedule, a programming mistake caused the new numbers to not take that into consideration. It will be fixed shortly.
by nathansparks
Tue Dec 28, 2010 7:31 am
Forum: Main Forum
Topic: New to Open Dental - Need Help
Replies: 6
Views: 5936

Re: New to Open Dental - Need Help

Yes, as Jordan said it is easy to add your own no fee codes, and then use a procedure button http://www.opendental.com/manual/procedurebuttons.html to tp all of the grouped 'steps' together, then set them complete as they are completed.
by nathansparks
Tue Dec 28, 2010 7:25 am
Forum: Main Forum
Topic: Credit card merchants
Replies: 4
Views: 5080

Re: Credit card merchants

You enter the credit card payment into your merchant portal like normal. Then go to patient account in Open Dental, click payment button, choose 'credit card' from payment type (or you could call us to show you how to add new payment type if you want to track this type of transaction seperately) and...
by nathansparks
Mon Dec 20, 2010 1:53 pm
Forum: Main Forum
Topic: Daily production base on insurance
Replies: 10
Views: 8460

Re: Daily production base on insurance

There appears to be two threads of conversation here, mostly (2) below, but just to clarify for the entry where the doctor is comparing production numbers from this year to last, usually a report (1) would be used rather than (2). 1) production and income reports: if there is a problem with producti...
by nathansparks
Tue Nov 09, 2010 12:46 pm
Forum: Main Forum
Topic: New to Open Dental
Replies: 1
Views: 2775

Re: New to Open Dental

VR for notes, what software are you using/planning on using for the voice recognition?
by nathansparks
Tue Nov 09, 2010 12:44 pm
Forum: Main Forum
Topic: Chart Module --Enter Treatment Tab
Replies: 3
Views: 4065

Re: Chart Module --Enter Treatment Tab

Fixed bug [Chart module tab behaved wrong when clicking]. Released in 7.4.8 and 7.3.9
by nathansparks
Fri Nov 05, 2010 12:20 pm
Forum: Main Forum
Topic: line item payments
Replies: 4
Views: 4466

Re: line item payments

Well, it is grouped by procedure date and by patient in the family (you must provide the guarantors PatNum, which you can show on title bar of Open Dental) so grouping by claim is not needed, usually claims are for one procedure date and always for one patient, try this and comment back if it is not...
by nathansparks
Fri Oct 22, 2010 1:44 pm
Forum: Advanced Topics
Topic: how difficult is the install?
Replies: 3
Views: 6210

Re: how difficult is the install?

I am trying to do a setup here with 1 Dell Server 3 Work stations 1 laptop (mobile) I am doing a pediatric dental practice. I have 5 questions below. I was a computer programmer before dentistry and so I wanted to find how hard it is to install this program? I have done MySQL programming etc in the...
by nathansparks
Fri Oct 22, 2010 1:01 pm
Forum: Advanced Topics
Topic: how difficult is the install?
Replies: 3
Views: 6210

Re: how difficult is the install?

As to the first question...If you are compiling it yourself see http://www.opendental.com/manual/programmers.html where it says "There is no included installation program with the source code (yet). You can run Open Dental on your development computer without an installation program. Play with the i...
by nathansparks
Fri Oct 22, 2010 12:57 pm
Forum: Main Forum
Topic: Appointment module
Replies: 1
Views: 2672

Re: Appointment module

It will default to the scrolled position where the first time there is a scheduled provider if you populate the schedule(setup, schedule). SInce that might be a waste of time, you are looking at the blank database and there is also a small demo database distributed with the trial version. From insid...
by nathansparks
Fri Oct 22, 2010 12:54 pm
Forum: Main Forum
Topic: Electronic Health Records
Replies: 6
Views: 5608

Re: Electronic Health Records

There are rumors that The Office of the National Coordinator of Health IT (ONC) will publish guidelines for dental certification in mid 2011, we shall see.
by nathansparks
Fri Oct 22, 2010 12:48 pm
Forum: Main Forum
Topic: Sharing Sheets forms?
Replies: 4
Views: 5106

Re: Sharing Sheets forms?

Great idea to have a place for users to share their sheets, Jordan will probably comment.
by nathansparks
Fri Oct 22, 2010 12:44 pm
Forum: Main Forum
Topic: Chart Module --Enter Treatment Tab
Replies: 3
Views: 4065

Re: Chart Module --Enter Treatment Tab

to the first issue, Yes, bug, submitting now, thx
by nathansparks
Fri Oct 22, 2010 12:41 pm
Forum: Main Forum
Topic: Portrait mode?
Replies: 2
Views: 3201

Re: Portrait mode?

1024 x 768 is the minimum, so 900 x 1600 probably will not work, right hand side will be cut off. But just install trial version to see.
by nathansparks
Thu Sep 30, 2010 1:33 pm
Forum: Main Forum
Topic: Procedure button icons
Replies: 1
Views: 2724

Procedure button icons

Can anyone remember a thread with a link to some great icons for people to use on their procedure buttons? I cannot find it...
by nathansparks
Thu Sep 23, 2010 8:26 am
Forum: Advanced Topics
Topic: Appointment Card
Replies: 2
Views: 4835

Re: Appointment Card

In the mean time, if you have a stack of preprinted cards, you print to the label maker and stick the label onto the card. The reason why this is fairly popular and folks are not clamoring too hard for your proposed feature is that a 4.5 inch square sheet is not likely to last in my wallet until my ...
by nathansparks
Thu Sep 23, 2010 8:17 am
Forum: Main Forum
Topic: Pre-sales Questions
Replies: 2
Views: 3339

Re: Pre-sales Questions

Josh, I called schick and their hardware is only compatible with their products and with Dentrix Imaging, which is an integrated dentrix product and is perhaps what you are currently using some version of. They do have a twain driver that they said worked with their bitewing sensors, I am not super ...
by nathansparks
Fri Aug 27, 2010 9:58 pm
Forum: Main Forum
Topic: Really Slow Appointment Book
Replies: 9
Views: 7658

Re: Really Slow Appointment Book

You could check to see if it is the patient fields, check the size of the table patfield , compare it to a backup from a week ago or more. The size should be very similar. It should also have less than 10,000 rows I would guess for nearly any office. We should be able to do a fix in less than 15 min...
by nathansparks
Fri Aug 27, 2010 9:47 pm
Forum: Main Forum
Topic: Appointment getting "stuck" on my mouse
Replies: 6
Views: 5236

Re: Appointment getting "stuck" on my mouse

Yes, like Rick says, find out exactly what you are doing when it happens. It is possible that you can characterize it so that we can replicate it and fix it. There has been more than one mouse related bug that was hard to replicate and thus hard to fix, but you should be able to characterize it if y...
by nathansparks
Mon Jul 26, 2010 12:31 pm
Forum: Main Forum
Topic: bug or behavior in email recall list?
Replies: 6
Views: 6086

Re: bug or behavior in email recall list?

js I consider this to be a bug and will add it as soon as I can. dg/Assigned to me. Added to bug list. dg/Not a bug. I tested a fake family on my machine where each of the two family members had different email addresses and I was not able to duplicate the issue. I tested in versions 7.0.41 and our ...
by nathansparks
Fri Jul 02, 2010 3:53 pm
Forum: Advanced Topics
Topic: GACOrthoplex
Replies: 1
Views: 3752

Re: GACOrthoplex

I have the documentation in front of me to do it right now, I don't think you will need us to do any programming changes. I just had not had time to call you back yet. But you can call me and I can setup your bridge. You will simply add a generic (custom) bridge and it is the fullinstallationpath\or...
by nathansparks
Fri Jul 02, 2010 3:44 pm
Forum: Main Forum
Topic: Progam Link Question
Replies: 2
Views: 3119

Re: Progam Link Question

Jordan will answer this,
Debbie and I tried to figure this out when you (or someone else, I did not take the call) called this week, we thought it was in the send claims window of the manage module, but we saw no result. I do not know if the issue was escalated into our issue tracking system.
Nathan
by nathansparks
Thu Jun 17, 2010 8:20 am
Forum: Main Forum
Topic: Error checking and staffing question
Replies: 6
Views: 5134

Re: Error checking and staffing question

I have long been in favor of a feature with office specified error/omission checking. Maybe a default setting, but then each office can turn on or off certain checks. It could prompt user if they forget a step (like if there is no planned apt but there are non-recall treatment planned procedures), i...
by nathansparks
Wed Jun 16, 2010 10:07 am
Forum: Main Forum
Topic: Completed Procedure Edit Security
Replies: 4
Views: 4635

Re: Completed Procedure Edit Security

There is absolutely no connection between file user permissions, database user permissions and OD program user permissions. Three sets of users, three sets of permission, no relationships. Now to your issue. When a procedure is deleted, it is simply marked as deleted, it is not really deleted. While...
by nathansparks
Wed Jun 16, 2010 10:00 am
Forum: Main Forum
Topic: "Restore Down" bug
Replies: 2
Views: 3100

Re: "Restore Down" bug

Dr Hollinger, this issue is still open here at Open Dental. Dr Sparks is out of town. As I recall, we have had a call on this before and Dr sparks classifies it as a known annoyance. We will leave the issue open here until Dr Sparks decides whether or not it should be considered a bug. IT would help...
by nathansparks
Wed Jun 16, 2010 9:51 am
Forum: Main Forum
Topic: switching from ES to go chartless
Replies: 4
Views: 4595

Re: switching from ES to go chartless

Similar bridging behavior, images that are stored in OD are not stored in the database, but in a shared file folder. The folder will be exactly the same size as the sum of the sizes of the individual files.
by nathansparks
Wed Jun 16, 2010 9:44 am
Forum: Main Forum
Topic: Amount to currency-word utility.
Replies: 1
Views: 2718

Re: Amount to currency-word utility.

Not that I am aware of, where do you want this functionality?
by nathansparks
Wed Jun 16, 2010 9:38 am
Forum: Main Forum
Topic: bug or behavior in email recall list?
Replies: 6
Views: 6086

Re: bug or behavior in email recall list?

We will evaluate this.
by nathansparks
Wed Jun 16, 2010 9:37 am
Forum: Main Forum
Topic: ? security level for edit payment plan charge
Replies: 5
Views: 5561

Re: ? security level for edit payment plan charge

I do not see the issue really. It does appear to be a weakness in the audit trail, but I do not quite see a viable embezzlement plan. The patient balance would be incorrect, wouldn't it? Editing a scheduled payment amount is just editing the amount of the loan. Does not provide an embezzelment oppor...
by nathansparks
Wed Jun 16, 2010 9:20 am
Forum: Main Forum
Topic: website down?
Replies: 8
Views: 8177

Re: website down?

Sorry about the website being down, godaddy is really a poor choice for hosing our website it turns out. They tell me now that 48-72 hours is reasonable downtime, thought their website state 99.9% guaranteed uptime.

Website is up now, locally hosted at our HQ until we find something redundant.
by nathansparks
Wed Jun 16, 2010 9:17 am
Forum: Main Forum
Topic: Show all commlog entried
Replies: 3
Views: 4219

Re: Show all commlog entried

There is an option in the show tab in the account module, check it to show family commlog entries. Call us if that does not make sense. Sorry for the delay in answering- Nathan
by nathansparks
Tue Apr 27, 2010 5:00 pm
Forum: Main Forum
Topic: Plugin Release for Statements/Payment Plans
Replies: 1
Views: 2650

Re: Plugin Release for Statements/Payment Plans

I can't wait to try, also use http://opendental.com/manual/plugins.html (the ending 'l' was left off on previous post) for the opendental plugin page.
by nathansparks
Tue Apr 27, 2010 4:45 pm
Forum: Main Forum
Topic: Topaz Signature Pad Stopped working
Replies: 10
Views: 15398

Re: Topaz Signature Pad Stopped working

ns tested R-L460-HSB with version 7.0.20.0 of OD with 32 bit Vista, Usually when it 'works' with office but not with OD we are simply needing to install (reinstall in this case) the drivers from the disk that came with the topaz pad. I did not have to take any action when I upgraded from 6.9 to 7.0....
by nathansparks
Tue Apr 27, 2010 4:36 pm
Forum: Main Forum
Topic: Topaz Signature Pad Stopped working
Replies: 10
Views: 15398

Re: Topaz Signature Pad Stopped working

testing now in version 7.0.20.0
nathan
by nathansparks
Fri Apr 09, 2010 3:00 pm
Forum: Main Forum
Topic: Overlapping display items
Replies: 3
Views: 4052

Re: Overlapping display items

Yeah, everything looks bad, as if the program is wearing shoes that are too small and toes are poking through the leather...right? Well, you might have a very large display where you have the resolution very high (or in native resolution, which by itself is great) and so you set your DPI set to a gr...
by nathansparks
Thu Apr 08, 2010 5:30 pm
Forum: Main Forum
Topic: Query to see complex accounts more clearly
Replies: 9
Views: 13227

Re: Query to see complex accounts more clearly

drtech- Fixed, I only found the paysplit as PaySplit, thanks for the find.
by nathansparks
Wed Apr 07, 2010 5:46 pm
Forum: Main Forum
Topic: Canadian e-claim/EDI bridge
Replies: 19
Views: 15879

Re: Canadian e-claim/EDI bridge

Yeah, while this is our current focus and we are hopeful, please do not promise your patients anything. We certainly we do not wish to consider users' patients as having any hopes pinned on our development, so again, keep this under your cap with your patients.
by nathansparks
Wed Apr 07, 2010 5:36 pm
Forum: Main Forum
Topic: Query to see complex accounts more clearly
Replies: 9
Views: 13227

Query to see complex accounts more clearly

This query is designed to see patient account information more by visit date than by accounting date, much like old accounting module. This may be useful when answering a patient who asks 'why is my balance $52.32?' Note that by default it will run summed by date, but can be easily expanded by runni...
by nathansparks
Wed Mar 24, 2010 1:19 pm
Forum: Advanced Topics
Topic: Query 237 - Annual Production
Replies: 2
Views: 4897

Re: Query 237 - Annual Production

ns/updated, thank you for your keen eye, let me know if there is still an issue /*Annual production and income report For all providers*/ DROP TABLE IF EXISTS t1,t2; SET @FromDate='2010-01-01' , @ToDate='2010-12-31'; CREATE TABLE t1( Month int NOT NULL, $Production double NOT NULL, $Adjustments doub...
by nathansparks
Fri Mar 19, 2010 3:16 pm
Forum: Main Forum
Topic: End of day accounting : Day Sheets
Replies: 23
Views: 40974

Re: End of day accounting : Day Sheets

thanks, fixed, updated published query at website and the one published above
by nathansparks
Fri Feb 19, 2010 1:09 pm
Forum: Main Forum
Topic: Crashplan
Replies: 15
Views: 12920

Re: Crashplan

You would never want to restore 'everything' from your old machine to your new machine, you just want the data, the documents, images etc.. IF you have been organized, it is VERY simple, just copy the documents from your old machine ovver the network was brentwood ended with, they are already in one...
by nathansparks
Fri Feb 19, 2010 1:04 pm
Forum: Main Forum
Topic: Which is the best E-claim service w/ OpenDental
Replies: 4
Views: 8092

Re: Which is the best E-claim service w/ OpenDental

They also have great customer service, they go the extra mile, never any passing of the buck when they should not.
by nathansparks
Fri Feb 19, 2010 11:10 am
Forum: Main Forum
Topic: End of day accounting : Day Sheets
Replies: 23
Views: 40974

Re: End of day accounting : Day Sheets

Sorry, fixed capitalization in post above there were 5 places where I used Patient instead of patient, also published on our web site under query examples
by nathansparks
Thu Feb 18, 2010 3:06 pm
Forum: Main Forum
Topic: End of day accounting : Day Sheets
Replies: 23
Views: 40974

Re: End of day accounting : Day Sheets

You could try this, it corresponds with some other 'day sheet' expectations. IT gives you a little bit of trend and alot of information in one place. As it is it will automatically adjust to 'today' Use it in the reports, User query... it may be the longest SQL query I have written so make sure you ...
by nathansparks
Tue Jan 12, 2010 12:41 am
Forum: Main Forum
Topic: Fee increase
Replies: 10
Views: 8905

Re: Fee increase

Before adding the feature request, could the poster explicitly state that the global fee update has been considered, and let us know the circumstances where that would not suffice?
by nathansparks
Fri Jan 08, 2010 2:20 pm
Forum: Main Forum
Topic: 'Unsent' Statements
Replies: 2
Views: 3264

Re: 'Unsent' Statements

OK, Looks like I can just point people to that discussion and make it a feature request for now, acknowledging that there is controversy over calling it a feature request rather than a bug as there is no category for 'known annoyance'
by nathansparks
Fri Jan 08, 2010 11:01 am
Forum: Main Forum
Topic: Phasing out backup/restore?
Replies: 35
Views: 25724

Re: Phasing out backup/restore?

Fantastic Jordan! Those ideas actually go along way toward relieving the burden of data backup from the dentist who just wants to 'dent' :) As to those who have >32GB of data (images of course) the ironkey may not be the solution, I just like the iron key because it self destructs and I think that i...
by nathansparks
Thu Jan 07, 2010 5:03 pm
Forum: Main Forum
Topic: 'Unsent' Statements
Replies: 2
Views: 3264

'Unsent' Statements

Dr Verharen's office manager Diana is one of several customers who take issue with the 'unsent' showing on billing statements for their patients. In her case, her patients actually have actually said they do not have to pay their bill because it says 'unsent'. The dr also says it does not look profe...
by nathansparks
Mon Jan 04, 2010 4:26 pm
Forum: Main Forum
Topic: Phasing out backup/restore?
Replies: 35
Views: 25724

Re: Phasing out backup/restore?

I always advise OD users have secure, pw protected media for backups if they use the included OD backup/restore. Isn't that HIPAA compliant? For instance the IronKey product, it is also waterproof and, for added fun, the chip self destructs if it is physically tampered with. Yet once you unlock it, ...
by nathansparks
Mon Jan 04, 2010 4:12 pm
Forum: Main Forum
Topic: We need more video tutorials on Open Dental
Replies: 9
Views: 15622

Re: We need more video tutorials on Open Dental

IT is good to get the feedback, I will look into adding some more... any particular tasks that you are interested in?
by nathansparks
Fri Nov 13, 2009 8:51 am
Forum: Main Forum
Topic: Change of Primary Insurance
Replies: 2
Views: 3259

Re: Change of Primary Insurance

Also, if you have submitted a claim for that particular procedure, you cannot submit a primary claim again, of course, as it would be secondary, unless you delete the first claim (if it is invalid). Call us up if you cannot clear it up. Make sure not to DELETE the original insurance, as indicated in...
by nathansparks
Fri Nov 13, 2009 8:48 am
Forum: Main Forum
Topic: Tx entering chart bug with image open
Replies: 2
Views: 3111

Re: Tx entering chart bug with image open

I am getting an error that prevents me from testing this potential bug... patient 247 in Training DB, try to open image in scanned FMX:' specified cast is invalid. Entering as bug.
Version 6.8.13. We will take a look at your issue soon Dr Fuchs- nathan
by nathansparks
Thu Sep 03, 2009 8:44 am
Forum: Developers
Topic: Small change to FormPayPeriods.cs proposed
Replies: 2
Views: 3616

Re: Small change to FormPayPeriods.cs proposed

I would add a payperiod default rules setup form, along with a multiple period add tool.
by nathansparks
Thu Sep 03, 2009 8:40 am
Forum: Main Forum
Topic: Posting letter types
Replies: 4
Views: 4707

Re: Posting letter types

Yeah, vote for it... I agree, should not be a difficult change and appears to be a design oversight.
by nathansparks
Thu Sep 03, 2009 8:38 am
Forum: Main Forum
Topic: Insurance claims showing outstanding on report
Replies: 5
Views: 5413

Re: Insurance claims showing outstanding on report

Confirm that not only payment has been recieved, but that the claim is recieved, with a date and satus indicating such. Sometimes I see people enter payments and then click cancel on the claim, so then the claim procedures are recieved but the claim is still 'sent' status. Otherwise we would need to...
by nathansparks
Fri Jul 10, 2009 2:05 am
Forum: Main Forum
Topic: Sliding Fee
Replies: 3
Views: 3630

Re: Sliding Fee

That is the solution that I would use, I forsee no difficulty. Cheers,
Nathan
by nathansparks
Fri Jul 10, 2009 1:59 am
Forum: Main Forum
Topic: tracking patients by assistants
Replies: 9
Views: 6873

Re: tracking patients by assistants

try something like this, if you want to include writeoffs (as negative production) it gets a little more involved, but really as the assistant has no control over what insurance the patient has (PPO), including the PPO writeoff will just create tension over who 'gets' the non-PPO appoointments, so t...
by nathansparks
Fri Jul 10, 2009 1:55 am
Forum: Main Forum
Topic: Promoting OD
Replies: 2
Views: 3496

Re: Promoting OD

Great idea, we put that together and post back here
by nathansparks
Tue Jun 16, 2009 9:56 pm
Forum: Main Forum
Topic: Eliminated feature - deductible before/after percent
Replies: 5
Views: 5369

Re: Eliminated feature - deductible before/after percent

It seems to be regional, I have worked with some offices who have mostly deductible before % and others who have mostly % then deductible. Where did we get the information that it is universal?
by nathansparks
Mon Jun 15, 2009 5:12 am
Forum: Main Forum
Topic: "AGE in the patient field
Replies: 7
Views: 6456

Re: "AGE in the patient field

I would try this for age in word, supposing you bring in birth date as BirthDate, I have not tried it, if it does not work, postback (or email you, I emailed this to you also). I guarantee nothing, but I would say 85% chance it will work, if not I have a typo { = INT({ DATE \@ "yyyy" } + { DATE \@ "...
by nathansparks
Thu Apr 16, 2009 6:45 am
Forum: Main Forum
Topic: Lab Cases Attached to Procedure Codes
Replies: 3
Views: 4299

Re: Lab Cases Attached to Procedure Codes

Sounds great, please enter it as a feature request!

Cheers,
Nathan
by nathansparks
Wed Apr 15, 2009 3:22 pm
Forum: Main Forum
Topic: Monitor Resolution/size
Replies: 2
Views: 3209

Re: Monitor Resolution/size

I don't think so right now, I would get a bigger monitor. (i know that sounds crazy, but either that or some new eyes).
by nathansparks
Wed Apr 15, 2009 3:20 pm
Forum: Main Forum
Topic: Fuji Scansnap S510
Replies: 12
Views: 15546

Re: Fuji Scansnap S510

In general, if we were to build a bridge, the other softwware would have to publish specifications on bridging. IN this case, we would have to launch the Fuji software and send it the path to save the file to. IF the software accepts such an argument, then it is possible, and would be a request.
by nathansparks
Tue Mar 31, 2009 7:10 am
Forum: Main Forum
Topic: Entering PPO Insurance Claims
Replies: 5
Views: 5706

Re: Entering PPO Insurance Claims

If you enter payments by total, rather than by procedure, for primary insurance there are problems with reporting, as jordan indicated. The whole point of having the PPO type is to keep track of the difference between the UCR and the PPO fee (called discount in tp module, writeoff in account module ...
by nathansparks
Mon Mar 23, 2009 1:20 pm
Forum: Main Forum
Topic: Incomplete USB Backup
Replies: 5
Views: 5258

Re: Incomplete USB Backup

Donn't know if this issue is still a problem, but this problem is usually because a file has some weird permissions at the point where it stopped copying (the next file). The reason I suspect this is that deleting the existing backup makes it go away. You see, there is a read only or locked file in ...
by nathansparks
Mon Feb 23, 2009 6:39 pm
Forum: Main Forum
Topic: Security settings
Replies: 6
Views: 6013

Re: Security settings

Have you 1. Created different 'users' for each of your staff, and then 2. Associated 'employees' with each user 3. Had each employee login with the now associated user account If the user, logged in as himself cannot edit his own timecard, then the maybe 'users cannot edit their own timecards' box i...
by nathansparks
Mon Feb 23, 2009 1:26 pm
Forum: Main Forum
Topic: Finance Charges
Replies: 2
Views: 3569

Re: Finance Charges

Finance charges typically do not add much to an account balance. For instance, a 2.5% APR translates to roughly .2% monthly, so if Bob the BadPayer owes you $500, this woul be a finance charge of about $1. Soooo, the .5% changes the finance charge on a $500 debt by about 20 cents. ... your time is m...
by nathansparks
Mon Feb 23, 2009 1:19 pm
Forum: Main Forum
Topic: Income Based on Catagory of Dental Services
Replies: 3
Views: 4509

Re: Income Based on Catagory of Dental Services

A little more on this topic: There is no income based on category of dental services unless you split patient payments to procedures, which is difficult. The query shown is great (if I do say so myself) but only applies to production (expected revenue, whether collected or not). Income (revenue) is ...
by nathansparks
Thu Jan 29, 2009 10:34 pm
Forum: Main Forum
Topic: Query question
Replies: 4
Views: 4526

Re: Query question

Yeah, sorry, got distracted. It was missing an @ sign on a variable try this SET @StartDate='2008-01-24', @EndDate='2009-01-24',@GuarantorNumber=1223; SELECT p.PatNum, ps.DatePay, ps.SplitAmt FROM patient p INNER JOIN paysplit ps ON p.PatNum=ps.PatNum WHERE DatePay BETWEEN @StartDate AND @EndDate AN...
by nathansparks
Mon Jan 26, 2009 9:57 pm
Forum: Main Forum
Topic: Query question
Replies: 4
Views: 4526

Re: Query question

Yeah, though a statement from the last year is the only way to show the context of the payments, otherwise it is not a ledger. something like SET @StartDate='2008-01-24'; SET @EndDate='2009-01-24'; SET @PatientNumber=1223; SELECT p.Patnum, DatePay, SplitAmt FROM patient p INNER JOIN paysplit ps ON p...
by nathansparks
Mon Jan 19, 2009 2:35 pm
Forum: Main Forum
Topic: Non-Calender Year Benefits Not Working?
Replies: 2
Views: 3195

Re: Non-Calender Year Benefits Not Working?

Should work, put the full date in, it will just look at the month and day, make sure you have both the from and to date filled out. Each benefit can be calendar year or service year, so check that too. To make sure you have it set up right I would call customer support at 866 239 0469.
by nathansparks
Wed Jan 07, 2009 3:47 pm
Forum: Main Forum
Topic: Editing Referrals
Replies: 2
Views: 3477

Re: Editing Referrals

From one nate to another, I can solve the mystery, although perhaps the answer is not too helpful. When you add a patient as a referral, OD copies some of that patient information to the referral table. The patient's identifying 'PatNum' is stored in ther referral table, so there could be some synch...
by nathansparks
Wed Dec 31, 2008 3:11 pm
Forum: Main Forum
Topic: insurance not sent
Replies: 2
Views: 3266

Re: insurance not sent

Yeah, usually this is caused by an estimate attached to the procedure in question. It can happen if you create a procedure and then drop an insurance. You can get it off the list by double clicking the procedure and deleting the estimate.
by nathansparks
Tue Dec 30, 2008 9:55 am
Forum: Main Forum
Topic: recall recare reminders
Replies: 6
Views: 6965

Re: recall recare reminders

Close to the votes? Well, there is no magic number (by that I mean there is no number of votes that guarantees the feature will be added immediately), but there are only 5 votes total for this feature. With each customer able to use 100 votes per office, that means that 1/20 of one customer wants th...
by nathansparks
Wed Dec 24, 2008 10:43 am
Forum: Main Forum
Topic: Availability and usage in Oz
Replies: 14
Views: 20132

Re: Availability and usage in Oz

We have several users who we support in austrailia... it is $89 month US, you could prepay in 12 month increments and recieve a 10% discount and also avoid fluctuations (you would know each year what your cost would be). You can call or email, if you call we can return the call to avoid toll charges.
by nathansparks
Wed Dec 24, 2008 10:20 am
Forum: Main Forum
Topic: Ortho INS Used
Replies: 1
Views: 2854

Re: Ortho INS Used

Yeah, that is a request, I think it is #230, there are only 20 vote on it now. So as each Open Dental customer has 100 votes, that means that 1/5 of one customer sees it as a primary need. Get your votes out there! Call if you need help using the feature request system. If you are not a customer, yo...
by nathansparks
Wed Dec 24, 2008 10:09 am
Forum: Main Forum
Topic: Total employee hours
Replies: 1
Views: 2609

Re: Total employee hours

I think you would need a query, someone else may know something I don't on this, call customer service and I will write you a query, that seems like a useful query.
by nathansparks
Wed Dec 24, 2008 10:07 am
Forum: Main Forum
Topic: Insurance co address
Replies: 2
Views: 3338

Re: Insurance co address

When you edit a letter merge you will see threee columns of available fields: the first is patient fields, the second is referral fields the third is entitled 'other' and includes fields called carriername, carrieraddress and carrier city state zip. Use those. For referral letters, you can do the sa...
by nathansparks
Mon Dec 22, 2008 3:25 pm
Forum: Main Forum
Topic: Advanced usage "allowed":
Replies: 16
Views: 11078

Re: Advanced usage "allowed":

Yes, just put in a large amount, 100,000 is often used. The one issue with the copay fee schedule is that it may be complicated to come up with the copay amounts. I wam willing to work with you on this til we get it working right for you, and define any hurdles.
by nathansparks
Thu Dec 04, 2008 12:36 pm
Forum: Main Forum
Topic: Daily and monthly production reports don't match
Replies: 4
Views: 4109

Re: Daily and monthly production reports don't match

check to make sure that you are not comparing production with total production (total production include adjustments and writeoffs)
by nathansparks
Fri Nov 28, 2008 9:34 am
Forum: Main Forum
Topic: Due for...items
Replies: 2
Views: 3330

Re: Due for...items

Yes, and you can see these for all of your patients on the recall list. Read this web page: http://www.open-dent.com/manual/recalllist.html and this one for setting up the type to show or not show on that list: http://www.open-dent.com/manual/recallsetup.html You can call Open Dental for specific he...
by nathansparks
Wed Nov 26, 2008 2:17 pm
Forum: Main Forum
Topic: Search engine for appointments
Replies: 1
Views: 2730

Re: Search engine for appointments

Open time not based on operatory time or chair time, based on provider time. The provider time is set within each appoinment, and is based on default time for each procedure and provider. SEE http://www.open-dent.com/manual/aptedit.html This is because if you have a patient in a chair getting numb, ...
by nathansparks
Wed Nov 19, 2008 4:06 pm
Forum: Main Forum
Topic: Edit procedure buttons
Replies: 9
Views: 16094

Re: Edit procedure buttons

jorge, the bridge is my favorite..nice :) :D
by nathansparks
Fri Nov 14, 2008 4:11 pm
Forum: Main Forum
Topic: SQL query help on appointments
Replies: 3
Views: 4017

Re: SQL query help on appointments

OK, I just wrote it, easier than trying to make you glue two together Patients with appointment in date range who had no procedure completed in the given interval prior to the planned appointment Possible useful to show patients who need an extra reminder in order to show up, not hugely practical (a...
by nathansparks
Fri Nov 14, 2008 3:22 pm
Forum: Main Forum
Topic: SQL query help on appointments
Replies: 3
Views: 4017

Re: SQL query help on appointments

Sure. I would also encourage you to just have an office policy that you set appoinment status to appointment confirmed if you do not need to confirm it (for instance if an appointment is less than three weeks out, confirm it immediately). Then you can just use the confirmation list ( http://www.open...
by nathansparks
Fri Nov 14, 2008 12:09 am
Forum: Main Forum
Topic: Household mailing list
Replies: 1
Views: 2604

Re: Household mailing list

Yes, one example is #35 available at http://www.open-dent.com/manual/queryexamples.html 35. List of families seen in the last three years. Useful for generating a list of patients for Christmas cards. After saving the resulting datafile, you would use the letter merge feature of Word to actually pri...
by nathansparks
Thu Nov 13, 2008 1:03 pm
Forum: Main Forum
Topic: How to create a map of where my patients are from
Replies: 4
Views: 4997

Re: How to create a map of where my patients are from

Yeah, I researched this so we could show Open Dental users on a map, it is expensive to purchase a control that does this programatically. If you find something that just needs an input list (like somone could have written an Excel addon that does this) we can help you query the database to get the ...
by nathansparks
Thu Nov 13, 2008 12:59 pm
Forum: Main Forum
Topic: Recall list bug
Replies: 2
Views: 3480

Re: Recall list bug

yeah, this is an annoyance, but it is not a bug,
it is a feature request. I checked and it has not been requested before or yet.
http://www.open-dent.com/manual/featurerequests.html
by nathansparks
Thu Nov 13, 2008 12:53 pm
Forum: Main Forum
Topic: Which fee schedule should I set up?
Replies: 3
Views: 4088

Re: Which fee schedule should I set up?

I agree with JorgeBon and would add that this (enter fee schedule, use PPO percentage type, select fee sched ininsurance window) is the only way to both charge your patient the correct amount and keep track of the difference between your fee and the PPO fee (PPO writeoff). IF you care not about this...
by nathansparks
Mon Nov 10, 2008 8:21 am
Forum: Main Forum
Topic: hygiene report
Replies: 2
Views: 3729

Re: hygiene report

I don't have one just like that, you would have to request it unless someone else already has it (because of the two or more appointments requirement, this is no longer a garden variety query). It would depend upon the hygiene definition. Usually I would include proceures marked 'IsHygiene', but you...
by nathansparks
Fri Nov 07, 2008 5:04 pm
Forum: Main Forum
Topic: Recalls
Replies: 4
Views: 4911

Re: Recalls

Just a guess, but probably no procedure that triggers the recall has been completed. For instance, if a child prophy triggers the recall, and the child has never had a child prophy, then it will not be due. Alos, when you make any changes, you must allow OD to synchronize patients.
by nathansparks
Fri Nov 07, 2008 4:58 pm
Forum: Main Forum
Topic: transferring Procedure codes folder ???
Replies: 4
Views: 5506

Re: transferring Procedure codes folder ???

The best way to transfer the procedure codes if you do not need procedure descriptions would be to use the fee schedule export/import tool. http://www.open-dent.com/manual/feescheduletools.html If you do need them with descriptions in another OD database, you could just make a divergent copy of the ...
by nathansparks
Mon Nov 03, 2008 9:38 pm
Forum: Main Forum
Topic: Communication Log - Should it be locked down ?
Replies: 3
Views: 4154

Re: Communication Log - Should it be locked down ?

On a similar note, Is there a way to store email communication with patient in open-dental. The work-around of storing it as a document / scanned version / image..is very painful..isnt it ? Well, I would not bother storing the incoming communication in open dental, if you need it it is available in...
by nathansparks
Mon Nov 03, 2008 9:19 pm
Forum: Main Forum
Topic: Communication Log - Should it be locked down ?
Replies: 3
Views: 4154

Re: Communication Log - Should it be locked down ?

Regarding the first part of the question, I did not address the legal aspect that you brought up. If there were some litigation and the communication log was proffered as evidince, by itself it would hold little value, although if sworn upon by the party who created it, that sworn testimony would be...
by nathansparks
Mon Nov 03, 2008 8:57 pm
Forum: Main Forum
Topic: Communication Log - Should it be locked down ?
Replies: 3
Views: 4154

Re: Communication Log - Should it be locked down ?

To the first part of the question: It is a valid request to add some specified security to the communications log, but there may be no connection to any HIPAA requirement (none that I can ascertain) and such added security may not bestow the expected value whatever that is; however, I may be missing...
by nathansparks
Sat Nov 01, 2008 11:50 am
Forum: Main Forum
Topic: Default billing entity
Replies: 5
Views: 4991

Re: Default billing entity

this is just a few clicks...Setup>Practice>Choose default insurance billing provider from dropdown. This would be the entity provider that you have set up to use only as a billing provider.
by nathansparks
Thu Oct 30, 2008 7:39 pm
Forum: Advanced Topics
Topic: .Net 3.5 - update yet?
Replies: 4
Views: 5407

Re: .Net 3.5 - update yet?

Yeah, the 3.5 dowload takes about 7-15 min, so I usually have people save it to server and then run as needed on machines upon which you wish to use the feature voting. there is no danger if that is what you were asking, and it takes another 10-15 minutes per machine to install, you don't have to in...
by nathansparks
Sat Oct 25, 2008 9:46 am
Forum: Main Forum
Topic: Norton
Replies: 3
Views: 4194

Re: Norton

With norton 360, just make sure that you have opened port 3306 for two way communication on both the server and workstations. I find in general that it 'slows' computers down, but that is fairly subjective. Many dentists use norton and OD, I just think the interface for opening ports on the firewall...
by nathansparks
Tue Oct 21, 2008 11:58 pm
Forum: Main Forum
Topic: Time units on the Planned appointment
Replies: 5
Views: 5223

Re: Time units on the Planned appointment

I believe the planned appointment has a length just like any other apt, see the bar on the left in the edit appointment screen when you click on the planned apt from either the chart module or apt module. I will check on this in a few hours but i am pretty sure.

nate
by nathansparks
Tue Oct 21, 2008 11:54 pm
Forum: Main Forum
Topic: Insurance Claim Sent Date
Replies: 5
Views: 4929

Re: Insurance Claim Sent Date

well, the original date sent is not kept when a claim is resubmitted, I usually advise that you would note this in the claim note or comm log if you originally sent the claim on a date different that the service date AND you have to resend a claim.
by nathansparks
Tue Oct 21, 2008 11:46 pm
Forum: Main Forum
Topic: Insurance on Treatment Plans
Replies: 3
Views: 4135

Re: Insurance on Treatment Plans

I would check insurance used relative to annual limit (on lower right), or if it is low on TP then notice that there might be treatment of higher priority that has ins estimates adding up to an amount greater than annual limit. Other things to check would be ins categories and specifics of insurance...
by nathansparks
Fri Oct 17, 2008 3:30 pm
Forum: Main Forum
Topic: query for insurance percentages
Replies: 5
Views: 5821

Re: query for insurance percentages

Use this for the count of patients with each insurance, the unhandled exception eror you got was because there was an error in your SQL, probably you put a date in wrong format, try this exactly as written, save to favorites, THEN change the date each time you run Call me if you have any problems, o...
by nathansparks
Fri Oct 17, 2008 12:51 pm
Forum: Main Forum
Topic: query for insurance percentages
Replies: 5
Views: 5821

Re: query for insurance percentages

OK, the question is, are you wanting to count primary insurance only or any insurance? If you count any insurance then your percentages will be greater than 100% added together. Also it might be more effective if we limit it to a time period where you have seen the patients, typically 2 years or wha...
by nathansparks
Fri Oct 17, 2008 9:46 am
Forum: Main Forum
Topic: query for insurance percentages
Replies: 5
Views: 5821

Re: query for insurance percentages

I will have some queries posted for you within an hour or so
nathan
by nathansparks
Mon Oct 13, 2008 3:44 pm
Forum: Main Forum
Topic: database corrupted
Replies: 2
Views: 3852

Re: database corrupted

Since your conversion failed, be aware that you probably also have a backup in that same directory(that od created), as when OD finds a database to be of an older version than the executable, the first thing it does is make a copy, so look in your c:\mysql\data (or whatever directory you have set) a...
by nathansparks
Mon Oct 13, 2008 3:26 pm
Forum: Main Forum
Topic: installation
Replies: 11
Views: 9699

Re: installation

'I' and 'i' are different characters in the turkish character set, and there is an i in 'userid', I know that does not help much, I would concur with changing from turkish to english and seeing if the problem goes away, then we can look for a solution. "function configure sets names in "latin5" so t...
by nathansparks
Mon Oct 13, 2008 3:21 pm
Forum: Main Forum
Topic: installation
Replies: 11
Views: 9699

Re: installation

I received one email from a user with XP set to turkish who had the same issue, about 3 months ago, no resolution, I will see if I can find anything out on the mysql website.

Nathan
by nathansparks
Fri Sep 05, 2008 8:49 am
Forum: Advanced Topics
Topic: Query Help Needed
Replies: 1
Views: 3444

Re: Query Help Needed

Here you go /*Patient list of Sum of the Fees of all Treatment planned and all scheduled procedures*/ DROP TABLE IF EXISTS tmp1; /*Create a temp table containing summary info by procedure*/ CREATE TABLE tmp1 SELECT patient.PatNum, sum(ProcFee) AS '$Scheduled', 0 AS '$TP' FROM patient INNER JOIN proc...
by nathansparks
Thu Aug 07, 2008 11:38 am
Forum: Main Forum
Topic: xCharge Feedback
Replies: 5
Views: 8014

Re: xCharge Feedback

Savvy, I do not think you will need a card swiper I guess, you did not indicate that you had one: have a Topaz T-L460-HSB Electronic Signature Device and a Cherry MY 7000 USB Keyboard. What else do I need? I currently use CardService Linksys LPAIO processing machine w/ attached model PIN 10 number k...
by nathansparks
Wed Aug 06, 2008 1:11 pm
Forum: Main Forum
Topic: xCharge Feedback
Replies: 5
Views: 8014

Re: xCharge Feedback

Savvy, Additional equipment: you might want a card reader that mounts on your monitor (less than $20, $10 last time I looked), won't need much else. Fees: Sean from X-charge will go over the fees with you, I find he is very upfront and easy to talk to. He may still be on vacation, don't know, just g...
by nathansparks
Wed Aug 06, 2008 12:58 pm
Forum: Main Forum
Topic: New Patient Report List
Replies: 7
Views: 7255

Re: New Patient Report List

If want a count column also of new patients use this custom query New Patients in Date Range with Date of last visit and Procedure Count SET @pos=0, @FromDate='2008-06-01' , @ToDate='2008-06-31'; SELECT @pos:=@pos+1 as 'Count', patient.PatNum, LName, FName, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS '...
by nathansparks
Mon Aug 04, 2008 3:49 pm
Forum: Advanced Topics
Topic: Language Spanish. es-ES
Replies: 10
Views: 10791

Re: Language Spanish. es-ES

Jimmy, there are other users looking for the spanish translation, let me know if you have one
Nathan
by nathansparks
Mon Aug 04, 2008 3:42 pm
Forum: Main Forum
Topic: First Attempt at SQL
Replies: 1
Views: 2990

Re: First Attempt at SQL

Yeah, you can switch the order and add secondary sorting by using
ORDER BY FieldName1 DESC, FieldName2 DESC, FieldName3 ASC

ASC is ascending, DESC is descending

Nathan
by nathansparks
Mon Aug 04, 2008 1:13 pm
Forum: Main Forum
Topic: "Unable to Save Document"
Replies: 25
Views: 20726

Re: "Unable to Save Document"

FYI, the only time I have seen this type of 'Intermittancy' with the images folder was when there was more than one 'server', the Internet service provider had a xxx.yyy.server@zzz that the netwrok sometimes decided to send traffic destined for the local server to. When it does NOT work, try and pin...
by nathansparks
Mon Aug 04, 2008 1:09 pm
Forum: Main Forum
Topic: "Unable to Save Document"
Replies: 25
Views: 20726

Re: "Unable to Save Document"

Savvy's issue that he called and talked to me (and amber) about on July 11 was a file permissions issue, I did not record the exact permission but it was either a read only folder or file or a share or security setting for a particular folder or file. Savvy had not changed anything, unfortunately, W...