Open Dental Forum

dgraffeo

You'd have to add an AND clause that looks at the procedurelog.ProcStatus - You can see Here: https://opendental.com/OpenDentalDocume ... ocedurelog that a ProcStatus of 2 is complete, for instance.

dgraffeo

It looks like we may be using application/json. I've forwarded this to the developer who coded the integration for her input and awareness.

dgraffeo

Agreed. For smaller offices, another workstation works just fine. Just make sure people know it's the server and that they probably shouldn't shut it off in the middle of the day

dgraffeo

Hey there,

We have a nifty tool to import fee schedules, the details can be found here: https://opendental.com/manual/feesimport.html

dgraffeo

That could be pretty complicated. Your best bet may be to give our query team a call! 503-363-5432

dgraffeo

CEMT over Middle Tier is a tricky beast. The Middle Tier asks for credentials up front - When a query is about to be run the middle tier goes "Hey, what's your credentials?" and we use the currently logged in user which may be DavidCEMT with a password like CEMTPass1234. This is fine, but if those c...

dgraffeo

That will work in most cases, but it will only fetch deceased guarantors from patients who are currently an active patient. If the patient is archived or are also deceased, it won't fetch the guarantor. I think the simplest way to fetch deceased guarantors is to find all patient rows whose PatNum=Gu...

dgraffeo

Yes, this is correct. No patients are ever truly deleted (even if they were just created). They are assigned patient status of Deleted, which is what happens in this case. The reason is that if a patient is ever accidentally deleted somehow, it is still recoverable. Since you can make a new patient ...

dgraffeo

The claim needs to be deleted first.
https://opendental.com/manual/claimedit.html
If the claim is not sent, it can be deleted at any time as long as you have permission. Then you will be able to delete the procedures.

dgraffeo

No problem. The issue is a lack of credentials within the database that is on the middle tier. To run any commands the middle tier checks those, but obviously if you haven't synced the CEMT yet there won't be any credentials to use. I'm going to talk with our other engineers to see if there's a way ...

dgraffeo

Honestly, I'm seeing several different problems using middle tier connections on the CEMT. For instance, invalid credentials. Not being able to sync data to a middle tier connection. Stuff like that. I'd avoid using middle tier in the CEMT for the time being, I'm going to fix it up so middle tier wo...

dgraffeo

What version are you on?

dgraffeo

Interesting. I can look into this, it's most likely that someone changed the ProdInc report column names and didn't update the CEMT to retrieve the data using the new column names.

dgraffeo

Sometimes it really seems that there's some shadowy figure sitting behind a desk at Microsoft laughing maniacally while he flips random switches. These switches control various aspects of how Windows works.

dgraffeo

I'm not quite sure what you mean, but perhaps this would help: http://opendental.com/manual/productiontotals.html

dgraffeo

Hey there! The only way a payment of $0 will show up on the report is if a payment for $0 was made for that patient on that day. If you go into the patient's Account, do you see a payment for $0? If there is one, was it put there on purpose or was it an accident? I am unaware of any way to automatic...

dgraffeo

The sort of replication Jason is talking about would rectify the forks. Of course, if something was edited "in the field" then also "at home" then it'd need to be reconciled, but beyond that the replication mentioned works for spotty internet.

dgraffeo

Ah the monthly P&I report. Yes, that one does include scheduled. As of now, there is not currently a way to remove it from the report but you could send us a feature request and vote on it, or add your votes to an existing one if it is already there!

dgraffeo

The built in P&I reports should do that for you. If you select the "More Options" item, it allows you to select a date range to see the information for things within that date range. It doesn't count treatment planned procedures, only completed procedures, in the totals.

dgraffeo

Mardi Gras photos. Nice touch

dgraffeo

Gargantuan is not an over-estimation. Some things that need to be thought about from an engineering and usability standpoint for each form we change: Is it easy to get to? Is it intuitive for the users? Is all previous functionality still there? If we have to change something, is it going to make th...

dgraffeo

One Payment contains multiple paysplits. The Paysplits are what contains the provider information, and so a single "payment" can have multiple different providers. The query provided will detect paysplits made by a patient that have a provider that aren't the patient's primary provider. To see if th...

dgraffeo

Concurrency issues are a never ending battle. On the one hand, we want to verify information is still present and fresh when a user is editing it, but on the other hand we don't want to make additional database calls to make sure it is in a good state when the user edits it. Most concurrency issues ...

dgraffeo

A really quick one I whipped up: SELECT patient.PatNum, patient.LName, paysplit.DatePay FROM paysplit INNER JOIN patient ON paysplit.PatNum=patient.PatNum WHERE patient.PriProv!=paysplit.ProvNum Should give you all patients that have paysplits that are allocated to providers that aren't their primar...

dgraffeo

I don't see why not.

dgraffeo

Strange. It may be best to call us and let us collect a copy of your database so we can try and troubleshoot it. There isn't too much special about this section, I can't tell what's breaking based on this error message.

dgraffeo

Take a look at request 5741 and vote on it!

dgraffeo

Ah okay. Those seem like pretty good suggestions, I'll see what we can do. It may turn into a feature request in which case I'll post back here and get you (and others) to vote on it.

dgraffeo

Could you clarify what you mean? When you say "Discount plan module" do you mean that for a patient, in the Family Module, you give them a Discount Plan instead of a normal insurance plan? If that is the case, the discount plan doesn't have any sort of date on it. I'm also not sure what you mean by ...

dgraffeo

Hmm well, it is difficult to troubleshoot over the forums here. There could be many issues such as the payments being made to the wrong clinic or historical information affecting the reports. I would suggest giving us a call at 503-363-5432 and one of our techs could probably figure it out in short ...

dgraffeo

Our reports typically have breakdown based on clinic. If you create two clinics, you also need to make sure you assign patients to the correct clinic. The patients from the retiring dentist should be assigned to the clinic you made for the retiring dentist, while your patients should be assigned to ...

dgraffeo

Looks like the query is malformed when there are no paid claims on the etrans message. We'll look into fixing it.

dgraffeo

It is the second scenario. It is only usable for patients that don't have normal insurance. There was demand for it, so it seems people give discounts on even PPO plans (or don't use PPO plans? Not sure how those work). Additionally, when completing a procedure for a patient that is using a discount...

dgraffeo

Perhaps there's a misunderstanding, but the Discount Plans are for people who do not have any regular insurance plans. They are meant to be an entire replacement for an insurance plan so that people without insurance plans can come in, get work done, and then get billed an amount that is a discount ...

dgraffeo

Hey there, tim.
The column and the function have been added to 17.2

dgraffeo

Yep, the issue you are having is related to what was fixed.

dgraffeo

Hello, epicurean. I believe the issue you are experiencing is after editing the supply to how they want it, the user may be pressing the "Cancel" or the "X" button in the parent window. When this happens the changes made in the supply edit sub-window are lost. Just makes sure that "OK" is pressed wh...

dgraffeo

Indeed. When you say "It's a hygiene appointment" around here, we take that to mean that you've checked the "Is Hygiene" checkbox in appointments, so that's what I went off of :) Here is the query modified to look for specific operatories: SELECT patient.PatNum,patient.LName,patient.FName, appointme...

dgraffeo

This may be adequate: SELECT patient.PatNum,patient.LName,patient.FName, appointment.AptDateTime FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum INNER JOIN provider ON patient.PriProv=provider.ProvNum WHERE appointment.ProvNum!=provider.ProvNum AND appointment.IsHygiene=TRUE...

dgraffeo

I have attempted to reproduce this and cannot. Any chance we can nab a copy of your database so we can figure out what's going wrong?

dgraffeo

Hmm.. Would custom patient fields work for this purpose? http://opendental.com/manual/custompatientfields.html
These get displayed at the bottom of the patient information in the Family Module.

dgraffeo

Yes. You can set the text you wish to show up as described in this page: http://opendental.com/manual/ereminderssetup.html

dgraffeo

Images in the Patient Pictures directory (the first in the list, I believe) will show up when appointments are hovered over in the appointment module, and you have it set up to show patient pictures in the bubble that shows. Yeah, it's more for identifying patients or having pictures of them.

dgraffeo

I'm not sure what color you are referring to, but if it's any color set by the Definitions setup window then the change will be reflected on all computers and accounts.

dgraffeo

FLUSH HOSTS should be the only thing in the box. If you give us a call mentioning this forum thread we can probably get it sorted for you

dgraffeo

When you paste the day, go into it and make sure that you have an operatory assigned to that time period. For example, if you have a provider named Prov1 and an operatory named Op1, in the schedule for a particular day you should see Provider of Prov1 and Ops as Op1. When you go back to the Appointm...

dgraffeo

User permissions are loaded when the user logs in and don't change until that user logs out. Their permissions will not change in the middle of their session, as far as I'm aware. I think that's perhaps what you're trying to do? There is a reasoning for this, and that is if they're inside a form or ...

dgraffeo

The date selector in the TP module works by pretending that the date the estimates will be done for is the date selected in the date selector. Prior to this feature, the estimates in the TP module would always calculate based on today's date. However, what if the treatment won't be done for several ...

dgraffeo

There is query 285 on our query examples page ( http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx ) that will list all archived and inactive patients, giving you a way to see which patients need to be changed. If you call in, we can also potentially update patient statuses from archived to i...

dgraffeo

Inactive patients are patients that may some day come back, but for now are not coming to your office. Archived patients are those that are never coming back. They're similar, to be sure, but the Archived patients won't show up in the patient select window.

dgraffeo

As far as treatment plans are concerned, in the most recent versions of Open Dental (16.3) there is a date picker at the top if the "Enable Insurance Frequency Checking in Treatment Plans" preference is set to true. You can select a date with that and press the "Refresh" button and it will update th...

dgraffeo

We're actually currently working on a feature to help alleviate that issue. If a procedure is attached to an appointment and scheduled, it will check frequency information for the procedures and display warnings if there are conflicts.

dgraffeo

On our Query Examples page there are a couple which might meet your needs: Query 590 - List of Patients with balance over 90 days AND Billing Type is "Bad Debt-Sent to collections" Query 1080 - Aging for families with any balance with 90 - 120 and billing type filter Our query examples page can be r...

dgraffeo

Very interesting. It is doable, there are several places in the program such as the appointment reminder text where we substitute entered phrases with certain fields pulled from the program. For instance, we could make it so all instances of [[SelectedPat]] in the query text were replaced with the c...

dgraffeo

Writing queries is complicated, but can be done with a bit of practice. I'm sure there's lots of tutorials out there on how to do things. That being said, for your particular case you'd want an INNER JOIN on the provider table using the patient's PriProv and the provider's ProvNum. Essentially, it w...

dgraffeo

I recommend calling in to get support assistance with cleaning up files. Our support can verify what files are in use and which aren't. That being said, from the descriptions you've given, this is what my impression is: mysql/OpenDental - It seems like it would be safe to move or delete as long as t...

dgraffeo

Not really, no. All of the settings are stored in the same database where the patients are stored.

dgraffeo

When resolution is changed, OD has the ability to automatically resize grids and windows, and so things (generally) stay visible and sized as we intended. When text is set to larger we have no way to scale the grids to compensate for the larger text size, and so text will often be cut off or not vis...

dgraffeo

There is a Windows region and language setting which deals with number of decimal places. Within the Control Panel, in Region and Language settings, you'll see several settings dealing with time formats. If you then click on the "Additional Settings" button, an additional settings window will show w...

dgraffeo

Definitely call support, I think the solution is as simple as clearing out the ApptComm table by changing the ApptComm send preference "days prior", pressing OK, and then going back in and setting it back to the value you had before. The techs will be able to verify if that worked, and if it doesn't...

dgraffeo

Ah okay, the one question I didn't ask

dgraffeo

The fact that you have apptcomm entries means that the logic is working correctly for inserting them. I've spent a bunch of time thinking about it and I believe the issue lies most probably with the e-connector. That is sadly not an area of the program I'm super familiar with so perhaps it'd be a go...

dgraffeo

Automated appointment reminders and automatic confirmations are two separate things. Which are you referring to? Based on your use of the e-connector I'm making an assumption that you are referring to the automated appointment reminders. It needs a few things to work: It's best to be on the latest s...

dgraffeo

Yes the locker type viruses are definitely gained through opening email attachments. Don't open them if you can help it. Or open them on a computer not connected to the rest of the network.

dgraffeo

If I'm understanding what you're asking correctly, you can go to Setup -> Manage -> E-Mail which will bring up a new window. Once there you can press Add to create a new email address and put no information in except for the email address (which can be anything). Then back in the E-mail list window ...

dgraffeo

Nope, just update on one workstation (or the server). It will shut down the rest of the workstation's OpenDentals. Once the update is finished the workstation can start OD and they will go through the update process on startup.

dgraffeo

This likely means the registration key you have entered when you go to Help -> Update (it's about halfway down the window) is entered incorrectly.

dgraffeo

I've set up test cases using the same settings you are and I cannot reproduce the issue; it pulls from the correct fee schedule for me. Arna may have more ideas but it may be a good idea to call in and let us grab a copy of your database so we can see why it's pulling from the wrong fee schedule and...

dgraffeo

I definitely agree that it's a bummer you can't view the patient chart or change patients while you have a form open, but enabling that functionality is one of those things that seems easy but is actually quite difficult. I can't find a feature request dealing with this, and so I urge you to create ...

dgraffeo

I don't believe they do. Auto codes are meant to detect what kind of procedure to create when in the chart module and pressing any of the procedure buttons, or in the procedure edit window and charting a procedure that has multiple forms. For instance if you are doing a composite for tooth 2 and use...

dgraffeo

Ah yep thanks for the heads up! It's been fixed and will be available in 15.4.30

dgraffeo

Yep that is correct, it is placed in the manual as noted in Step 1 on http://opendental.com/manual/eclaimswebmd.html

dgraffeo

Alright it sounds like Emdeon/WebMD setup for the Real-Time Benefits located http://opendental.com/manual/eclaimswebmd.html is what you should make sure is followed. If all steps are followed hopefully it'll work!

dgraffeo

Your statement confuses me to some extent. To use the Request button, Electronic Eligibility and Benefits needs to be set up. It states in our manual ( http://opendental.com/manual/ebenefits.html ) that there are four clearinghouses, ClaimConnect, Emdeon, and two others. You're saying that you deal ...

dgraffeo

So I took a look and there was a bug which has been fixed which came up in the case of a refused response message for benefit information. I looked at the response messages and they state that your security information is incorrect. I'd take a look at your username and password for your dental clear...

dgraffeo

Do you have a particular patient you would like me to view, or will any work?

dgraffeo

Alright thank you for the information. It looks like the message we receive when querying for benefits isn't formatted the way we think it should be. Would you mind contacting us so we can collect a copy of your database? I'll be using it to troubleshoot the issue and getting the error to occur may ...

dgraffeo

Is the message displayed in a normal message box or does it display in a large window-like thing that has a "Copy All" button and a "Print Button" as well as the OK? I'm also assuming you're pressing the "Request" button in the insurance edit window when this occurs, correct?

dgraffeo

Could you supply the text that shows up under that error (if there is any)?

dgraffeo

Switching databases after the program has been started is a tricky and difficult scenario, so we don't support it currently. To have that window show up and choose a server location/database there is a checkbox that says "Do not show this window on startup" and if you uncheck it you'll then be able ...

dgraffeo

Wow, I thought you WERE Jason there for a little bit, that's uncanny! Anyways, what are you backing up? Is it JUST the database files or are you also backing up the OpenDentImages folders? I can tell you the database itself shouldn't really be that big; typically databases even with a lot of informa...

dgraffeo

We've tested the feature internally and it does work on our end, but there are still a number of things that could contribute to not sending reminders. Things to check are if your email is set up correctly and if the eConnector is installed and running correctly. It would probably be easiest to give...

dgraffeo

The fix has been committed and will be released with version 15.4.15. Hopefully this will fix the issues you are having. If not, please let us know!

dgraffeo

Yes, we're in the middle of fixing a tricky bug with the system. It should be fixed today and released sometime this week. Out of curiosity, do you have Clinics enabled?

dgraffeo

Unfortunately I don't think there's a way to "uninstall" Windows 10 to a previous version unless you had that previous version installed prior. Just a quick search of http://www.newegg.com for desktop computers shows that there are many available that have Win 7/Win 8 pre-installed. So, I'm not sure...

dgraffeo

You don't necessarily have to upgrade to Win 10

dgraffeo

You were close. What it means is that the line should literally be:

SET @CarriersToExclude=""; (a blank set of quotation marks)

dgraffeo

It looks like prior to our efficiency upgrade to the window in 15.4 the procedures were sorted in a particular order. I've now included that sorting so everything should look how you expect it to.
Update: Included in version 15.4.8

dgraffeo

This issue has been fixed and will be available in version 15.3.36 and later. We don't know how you have a blank entry in your database, but at least now it will allow you to Recopy which will hopefully solve it.

dgraffeo

After looking into it we discovered that if we attempt to get the UpdateFiles from the database which was introduced in version 15.4.6 and they weren't inserted for whatever reason (maybe you had cleaned out the directory prior or for some reason it's zipping the files of an empty directory?) this e...

dgraffeo

Was there any message attached to this error? I'm expecting something like: "Failed inserting update files into the database. Please call us or have your IT admin increase the max_allowed_packet to 40MB in the my.ini file."

dgraffeo

You're right, that has changed from 15.3 to 15.4. I'll take a closer look at it.

dgraffeo

Then again I don't talk with or work with anyone that opens up obviously malicious ... cat pictures on their lunch break

that you know of

dgraffeo

Yep, Kevin is correct. They're done "just in case" as we can't always trust people to have recent backups. If something goes wrong we at least know we have a snapshot of just prior to the update. As for deleting them, you can simply delete the folder from the mysql directory if you wish, and it also...

dgraffeo

Yeah, the <> means "Does not equal", same as !=

dgraffeo

Yeah, I think you are correct, though there's another date WHERE section down near the bottom. Is this Kevin's query as it originally is? If so, I can see the pattern he's doing. He's making a new table to store the information, fetching it and putting it into the table (t1, t2, etc.) and then showi...

dgraffeo

Yeah, having multiple time periods can be really difficult. One option that I can think of as the simplest is to make multiple copies of the query and put UNION ALL statements between. For each new copy you manually set the @FROM and @TO to different times (essentially using hard coded values instea...

dgraffeo

The OpenDental Database is installed wherever the user specifies when they install the trial version of OpenDental and select the New Server option. The database is a collection of files and so doesn't have a single extension. I have no experience with Access so I can't help you with that one.

dgraffeo

The query running to grab the patients you see in the Select Patient window is a resource hog. Because of this we default searches to the first 40 patients that meet the search criteria, otherwise it would take a long time to do any searching. If your window doesn't display all 40 results it should ...

dgraffeo

Looks like something went wrong with the installation. I would uninstall MySQL, delete all program folders for MySQL, and reinstall it with the default settings. This is, of course, assuming you're using our trial installer to install MySQL.

dgraffeo

Well we can't do much about physical computer security. We have to trust that people set up important computers with restricted access appropriate for what they use them for. The server, for more reasons than just changing the date, should be locked down tight. If they have the know-how and access t...

dgraffeo

No, it doesn't look like it. The closest I can find on our Query Examples page (http://opendentalsoft.com:1942/ODQueryL ... yList.aspx) is query number 633 which will get all group notes and proc notes within a date range, without looking at a specific patient.

dgraffeo

Ah yes. You can try: SELECT PatNum, Note FROM procnote WHERE Note LIKE '%requests topical%'
or like the other variant in my other post: SELECT Note FROM procnote WHERE PatNum=1234
If you want them ordered by date you can also add " ORDER BY EntryDateTime" at the end.

dgraffeo

Well a custom query could get you what you want fairly easy I suppose, though depending on how you want to look for the note it could get pretty complicated. For instance if you wanted to search for a note that contained "California" you could simply do "SELECT PatNum, Note FROM appointment WHERE No...

dgraffeo

The only thing I can really think of is that some of our tables have DateTStamp columns which gets inserted when the row is inserted, then updated any time the information is updated. For instance with the procedurelog table there's the DateTStamp then also the DateEntryC (which is when the procedur...

dgraffeo

Alright. In our latest version of 15.3 you are correct, re-ordering the planned appointments with the up and down arrows is buggy and doesn't work as intended. One of our engineers re-coded that portion of the program for the upcoming release and I tested up to 15 planned appointments and the re-ord...

dgraffeo

Ok, I'll look into it more deeply, thank you for your information. Do you have a particular patient number you can point me to that exhibits this behavior, just to be sure? I still have your database so I can test it and see the exact same thing you see.

dgraffeo

Hey there, I had a look at your database and attempted to reproduce the slowness when moving the planned appointments up and down and it wasn't slow for me at all. Is there anything special you do to move it? Something I may have been doing incorrectly? Anything out of the ordinary, really.

dgraffeo

On our database documentation page (Which I'm sure you have, but just for posterity is here: http://opendental.com/OpenDentalDocumentation15-3.xml ) when you look at the paysplit table you'll notice about halfway down that it has a foreign key called ProcNum which goes to the procedurelog table. Sin...

dgraffeo

Hey there, the issue has been fixed and will be available in versions 15.2.26 and later when they are released.

dgraffeo

We haven't seen any problems with Windows 10 yet.

dgraffeo

Ah, port 3306 is the port that MySQL communicates on.

dgraffeo

Awesome! You're welcome for the explanation, I'm glad it helped. I'm not sure what other fields you would want to add, but as long as you have a way to "daisy chain" the tables together you can filter things with a WHERE clause placed right before the GROUP BY statement for more specific results. Fo...

dgraffeo

We have information about how to fix that here (the solution is towards the bottom):

viewtopic.php?f=3&t=3964

dgraffeo

Seems like there is a mis-spelling and so it'll probably get fixed and backported.

dgraffeo

Alright, so it's understandable that you're having issues getting the insurance information for patients as it requires a bit of a run-around to get at. First, looking through our database documentation (located at: http://opendental.com/OpenDentalDocumentation15-3.xml) you can see that the insuranc...

dgraffeo

In Ewoo.cs from lines 41 to 65 you can see all the patient information that is included (patient last name, first name, chartnumber/patnum, address, etc). These are all created as XML tags with LastName, FirstName, ChartNumber,etc. Is that what you are looking for?

dgraffeo

Hey, this might work for you. It's a slightly modified query on the examples page. Just put the abbreviation of the provider between the quotation marks of @ProvAbbr= (make sure to keep the quotation marks) SET @pos=0, @StartDate='2010-06-01' , @EndDate='2010-12-01', @ProvAbbr=''; SELECT @pos:=@pos+...

dgraffeo

If you attempt to send a claim that has missing information the text will show up on the grid as to what is missing but there should also be a popup that says "Not allowed to send e-claims with missing information." for the first claim with missing information you have selected that it comes across....

dgraffeo

Installation using the express settings will (from what I've read about it, anyways) turn on a bunch of Windows 10 features that can cause security problems. For instance, using the express settings will enable a feature (called WiFi Sense) that can share your WiFi password with contacts you have on...

dgraffeo

What error are you getting? If you have an appointment that's been inserted into the database already, the AptNum will not be 0.

dgraffeo

Another tip in order to see what you need in the Task Manager, (This is for Windows 7), go to the Task Manager -> Processes tab. Then click on View menu button on the top of the window and click on Select Columns. Check the boxes for USER Objects and GDI Objects. If OpenDental.exe starts blowing up ...

dgraffeo

Often that error occurs due to a memory leak in the program. Perhaps the way you're calling the function (or where you're calling it) is causing the program to create many copies of a single type of window in some sort of loop. The way to tell that is when you launch the program look at task manager...

dgraffeo

If they're searching for it you may just want to change the description and abbreviation to something that the search won't figure out. For example if you don't want them to use the perio exam, change it to anyrandomword. It's the only way I know to prevent it from being searchable. I personally thi...

dgraffeo

I've taken a long look and this query expects there to be clock events for this person during the pay period if adjustments are added. If there are no clock events then the adjustments don't get counted either. That dependency is deeply embedded into the query and would take quite some time to get o...

dgraffeo

You would have to join the patplan table using patnum (ex: INNER JOIN patplan ON patplan.PatNum=patient.PatNum) then join inssub table using InsSubNum you got from the patplan (ex: INNER JOIN inssub ON inssub.InsSubNum=patplan.InsSubNum). Then you'd want to show the inssub.SubscriberID. So for insta...

dgraffeo

I'm not sure if this is exactly what you want, but this will show you all completed procedures that have no note text. SELECT procedurelog.* FROM procedurelog WHERE procedurelog.ProcStatus=2 AND procedurelog.ProcNum NOT IN (SELECT procedurelog.ProcNum FROM procedurelog INNER JOIN procnote ON procedu...

dgraffeo

Woah that is weird... What sort of backup software do you use, if any? OpenDental doesn't make any automatic updates, you always have to do them manually.

dgraffeo

I don't know how insurance companies do it, but in my mind there are two ways of doing it. The simple way is going back to the first of the month, adding 6 to the month value, then adding the current day value - 1 to the day. So let's take today 3/16 as an example. We go to 3/1, add 6, which would b...

dgraffeo

Hey there, When you change permissions on a user, you're actually changing permissions on the group that the user belongs to. You were likely a member of this same group so when editing the one member you were also editing your own permissions. An easy way to know who will be affected by the changes...

dgraffeo

Hey there, there might be a couple things I can think of - Do you have a USB 3.0 port you're plugging the USB into? USB 3.0 devices can go into USB 2.0 ports but wouldn't get as much of the speed benefit if that's where they are. If you're using a cable is it a 3.0 cable? Same thing as with the port...

dgraffeo

Hey. There are no date requirements for the planned tracker. The only thing that's required is for the appointment to be marked as "planned" and for there not to be another appointment with the same appointment number. After that what you see is all based off of the filters in the drop down menus ri...

dgraffeo

So modest. Brings a tear to my eye.

dgraffeo

It is the beta version. The safer version would be 14.2. We use 14.3 here in the office and it works well so it's up to you really.

dgraffeo

Hey there,
I just finished up the feature and it will be included in our next release. There will now be a drop down selection box where you can select all the claim types that you want to display in the History window. Yay!

dgraffeo

Hey there, I'm not sure if you've found a way around this but for the most part drives aren't interchangeable between Windows/Mac because of the way the drive's filesystems are formatted. I've read that if you format the drive to use the NTFS file system then Windows can read/write to the drive and ...

dgraffeo

It looks like you may have a duplicate table in your database. My recommendation would be to run the Database Maintenance tool from within Open Dental. It will likely fix that (plus any other) issues you have! If not, feel free to give us a call. Additionally, before messing with the database it's a...

dgraffeo

Hello,
We have a page about some of this in our manual here: http://www.opendental.com/manual/multiplelocations.html
Perhaps some of this will be of use to you!

dgraffeo

Hey there, Everything should be back up and running like normal.

dgraffeo

Indeed! We are aware and are looking into what caused the issue so we can get it fixed asap!

dgraffeo

Yes, Antivirus programs cause a lot of problems when trying to run updating software, sadly.

dgraffeo

Alright, it's been fixed up and should use the appropriate permission type in the next update or so.

dgraffeo

Here's an interesting discussion on the topic that I came across. It may offer some insight into this area of programming that you may not have thought of: http://programmers.stackexchange.com/questions/46434/how-can-software-be-protected-from-piracy TL;DR version: Preventing piracy is impossible un...

dgraffeo

Hi Kevin,
It is indeed a bug! A relic of a bygone era of messing around with the security logging that seems to have been overlooked. It'll get cleaned right up, thanks for pointing it out!

dgraffeo

Hey there, In my experience when you compile the code and distribute it as the executable file with associated DLL's it's very hard to reverse engineer it. After compilation what the computer runs is what's known as "machine code" which is not human read-able and is used directly by the computer. Th...

dgraffeo

Hello, I believe you are correct in that the Payment only has a date of when it is entered and has no hours/minutes information associated with it. Generally we do not keep track of that level of granularity and after researching this issue for you there does not seem to be a way to associate paymen...

dgraffeo

Hello, We use Visual Studio 2012 here. Perhaps you could try using that version and see if that fixes some of the problems. Additionally you will often get errors about "Mixed mode assembly" when trying to compile the project in release mode. Try to compile it in Debug mode to begin with. To do this...

Search found 147 matches