Open Dental Forum

Mifa

We are still using a version 20.1, a version where database integrity popup messages are not yet implemented. I'm reading through the manual and the posts on the forum to understand how this feature could affect us when we decide to upgrade to a newer version. 1. We are using a third party software ...

Mifa

Hi everyone, I need to mass replace some procedure codes in future appointments to accommodate a change in the way we build our hygiene appointments. There are several hundreds of such appointments already scheduled. Needless to say that I am not thrilled with the idea of having to manually edit and...

Mifa

OK, thanks for the answer! So, just to make sure I understand you correctly, there is actually no risk of corrupting the database if we use in our clinic a mix of EN-CA and FR-CA workstations depending on who the end user is then, right?

Mifa

Hi Everyone, We've just hired a new dental assistant who is not fluent in our main business language (French). In order to make her learning curve easrier with OD, I have created a new user with the default windows language set to EN-US instead of or regular FR-CA on each computer she would be worki...

Mifa

Hi Everyone,

We have a lot of custom reports developed with RDLdesigner and I would like to migrate them to something more secure. What do you use for advanced reporting that you can recommand (and does not store the MySQL password in plain text)?

Thanks

Mifa

Mifa

Thanks Allen, this is what I was looing for.

Mifa

Hi everyone, In a previous version of OD I was able to make a small change into FormRpPaySheet.cs in order to have checks in the daily payment report ordered by check number instead of OD's default sorting. I don't seem to find a way to do that in 18.3. I've been looking at FormRpPaySheet and QueryO...

Mifa

Hi, I would like to import into our OD database basic insurance information (insurance company code, policy #, certificate # and division) for about 4,000 patients from another PMS we've been using in parralel with OD for claim processing. Which tables do I need to update in OD? (still using 14.3.35...

Mifa

OK, problem solved. The database maintenance tool has repaired it. We never have problems with OD, that's why it took me so long to think about using it...

Mifa

I've just got a call from my staff, they can't move appointments in the calendar or create new tasks. After the server was powered out mistakenly for a few minutes, they are getting an exception thrown at them every time they try to move an appointment stating OD found a duplicate primary key. I was...

Mifa

Hi Team, I need help. For the past 2½ years, we've been using Crashplan to backup our encrypted OD and XDR data over the internet to remote machines we own, and it's been working like a charm! Apparently, it seems that Crashplan will stop supporting computer-to-computer backup in the next few months...

Mifa

Thanks Nathan, I appreciate the feedback. I have implemented the solution suggested by Jason and it works just fine, so far! And you know the saying: if it's not broken, don't fix it!

Mifa

It turns out that after all these changes, my staff is very creative and is still finding ways to give me completed procedures without a completed appointment... :twisted: :wink: I have found another very simple scenario that leads to this: complete an appointment open the completed appointment dese...

Mifa

I think I found it. I had to change password protected sharing to off on the server in Network and sharing center > advanced sharing settings > All networks > Password protected sharing > Turn OFF password protected sharing. I can't recall how it was in Windows 7. But it seems to solve the problem...

Mifa

I know, this is not an XDR forum, but since many of us use the combo OD/XDR, I'm taking a chance... I have upgraded our workstations to Windows 10 last week. Everything went fine, OD, XDR working as expected the all week. I have now just upgraded our OD/XDR server to Windows 10. OD and XDR work just...

Mifa

I've just seen a demo of their patient communication software at our annual dental meeting. It supports both French and English, which is a must have for us and, on top of that, they claim they integrate with OD! Almost too good to be true! Is anyone using them, I would be interested to read your fe...

Mifa

Thanks Jason!

Which version(s) are you going to implement it in?

Mifa

Mifa

Thanks Jorge, but that is not it. This option is and has always been unchecked, yet, it is still possible to complete an individual procedure. See original post. Here is how to fix it: in FormProcEdit, in comboProcStatus_SelectionChangeCommitted, replace if(comboProcStatus.SelectedIndex==1){//C // M...

Mifa

Hi Joe, Thanks for your reply. I tried it but it does not work, or should I say it works too well as I cannot complete appointments anymore! What I need is just to prevent the status change to complete in the procedit window; I want the user to still be able to manually complete appointments, which ...

Mifa

We use 14.3 in production. OD is configured so that we complete appointments, not individual procedures. However, from time to time, a procedure is mistakenly set complete using the drop-down list in the procedure edit window. That does not trigger any warning at all, and we end up with completed pr...

Mifa

I'm in the process of evaluating supply and inventory control systems. Is anyone on this forum using a system they can (or won't!) recommend?

Thanks.

Mifa

Thanks a lot Jason. On my side, I've been trying to update from 14.4 one version at a time. I've been able to (successfully?) convert our test DB up to 15.3.36. However, when I use OD, the account module, starting with 15.2.29 is crashing (I've sent you a PM with the exception notes). It may be rela...

Mifa

hi Jason, I have downloaded and compiled 15.4.22. I've copied the required dll's (hunspell) to the release and debug directory and run the program. It failed during database conversion: "You have an error in your SQL Syntax; check the manual that corresponds to your MySQL server version for the righ...

Mifa

Another instance of text not being translated (at least until 14.3). In ContrAccount, all the menu items in the context menu statement: Walkout, Email, Receipt, More Options. These menu items get all created using code like this.menuItemStatement***.Text = "***"; lan.g is not used

Mifa

Thanks Jason for your replies. I will follow your guidelines for the message box. We are on version 14.3, sorry I forgot to mention that and I do not have any customization that affects labels or create buttons. If you send me a PM, I will forward you my change log as well as our language and langua...

Mifa

Thanks Jason. There is another thing you may want to look into. In the translation window, sometimes, a translation entry gets duplicated several times. Also some translated text gets listed in the English column as well. I've used the Delete Selected and Delete Unused buttons to get rid of these, b...

Mifa

Wow, thanks a lot Jason! That was fast! Regarding the language option, I understand. I've tried to add the "custom" languages and it works fine. I've seen what you mean about keeping their existing language. We will have to change them all manually (...) or I'll do an update to the language field in...

Mifa

Jason, since you're at it :D :wink: ... Can you look into those one as well? Those preceded by an * are the most important for us In the Chart module * Right-click menu a progress note (Delete, Set Complete...) * Drop-down menu items for Tooth Chart button (Save big, Save to images) - Most grid tabl...

Mifa

Thanks Travis. I don't like this second option either. Maybe I can try a third option, I have these old Motion M1400 Windows XP tablets collecting dust on a shelf, they have an Ethernet port and I have a connection in our waiting room. Can the kiosk be run on a XP machine when everything else is on ...

Mifa

We are slowly but surely moving to paperless. I would like to be able to load the kiosk on tablets or similar portable devices, so that patients can sit in the waiting room when they fill up their forms. However we have a wired network... - is it possible to load the kiosk while the tablet is connec...

Mifa

I understand, but since the list does not reach the bottom of the window, it gives the false impression to the end user that all the results are shown. Maybe a comment saying "showing 40 out 52 results" might be helpful as well.

Mifa

The refresh while typing option seems to limit the number of patients we can scroll through to about 40 names at any time. Is this on purpose? We were looking for a patient by last name in the select patient window. The option "refresh while typing" was checked. This particular patient has a very co...

Mifa

From what I can gather, it does not seem that V for Vestibular (vestibulaire in french) is common in Quebec. I've asked my staff and I've checked documents from ODQ, they mention buccal. Also, while I was checking the source code, I've noticed that these Canadian specific surface button labels are h...

Mifa

Thanks, that's what I meant indeed. Quite frankly, after speaking to the clinical staff, they use the same notations for surfaces (M, O/I, D, B, L, and class V) as you do in the States. I don't know about elsewhere in Canada. Also, they've told me that insurance companies seem to be expecting this n...

Mifa

Thanks, but I meant the surface themselves. There is some code in FormProcEdit.cs that forces surface letters to be updated for Canada. the original F becomes V and V becomes 5 in the progress notes. The procedure is called UpdateSurf. It seems this procedure is not invoked for group notes as the su...

Mifa

I've just noticed that surfaces don't show the same in the progress note and in the group notes windows. It seems to get back to the US spelling in the group notes window. What is the item in the translation list where I can specify the correct French spelling?

Thanks.

Mifa

Do you mean that mysql's root password will not be saved in plain text anymore in freedentalconfig?

Mifa

I think I found where the problem come from: the AVAST antivirus. This machine runs the latest version of AVAST pro (10.4.2233); the other computers are running a previous version and they don't have an issue. When AVAST is turned off, OD starts nicely. When on, it hangs. I've tried to use exception...

Mifa

Just one more detail, OD is working in Windows Safe Mode with networking.

Mifa

OD and VSE 2012 are acting real weird on my development computer with windows7pro (and only this one, the other machines at the clinic do not have any issue). The version of OD (a customized version of 14.3.35) was compiled and installed back in march 2015 and we've been using it without any problem...

Mifa

Just out of curiosity, as I ran into this when I implemented the Diafaan solution a few months ago: how do you handle incoming text messages when several patients share the same cellphone number?

Mifa

Thanks Jason!

Mifa

What's the equation behind the RecallInterval field? The documentation says "The Interval struct combines years, months, weeks, and days into a single integer value." I would like to present the values in this field in a more readable format in one of my custom reports.

Thanks.

Mifa

Sorry to reopen an old thread. Is there a way to prevent users from using "obsolete" codes?

Mifa

I've implemented the solution I was suggesting in this post. It works like a charm for our 2 weeks pay period. viewtopic.php?f=1&t=4830&hilit=FormTimeCardSetup

Mifa

Draluu - I considered this approach as well, but I thought keeping track of our customer's mobile service provider was too much of a burden. Does this allow you to get SMS replies in OD? After about a month working with this, our patients seem to enjoy texting back to us instead of calling, so we ap...

Mifa

Thanks. As mentioned yesterday morning, I believe the problem is when you update the preference table in Prefs.UpdateString(PrefName.MySqlVersion,floatVersion.ToString("f1"). I think, the conversion floatVersion.ToString("f1") may have a culture specific result. (see https://msdn.microsoft.com/en-us...

Mifa

I've checked the preference table this morning and mentioned that 5,5 was stored in the backed-up DB instead of 5.5 (see earlier post). Your query returns 5,5 in the backups done today (5 of them so far) and 5.5 in production so far, but it will change as soon as someones connects on the computer(s)...

Mifa

The query returns:

innodb_version 1.1.8
protocol_version 10
slave_type_conversions
version 5.5.14
version_comment MySQL Community Server (GPL)
version_compile_machine x86
version_compile_os Win32

Mifa

I see that the version number is converted to a float in the code (prefL.cs - floatVersion=PIn.Float(thisVersion.Substring(0,3)) then back to string. I guess this is where we have the problem.

Mifa

I've checked the preference table for the MySQL version and I've found a discrepancy between the production database and the one that was backed up automatically. One reads 5.5 (production) the other 5,5 (backup). Our computers input locale (regional settings) are set to canada french (customized to...

Mifa

The new tables are MyISAM. From what I can see, it happens at startup (but not all the time!). The method CheckMySQLVersion() gets executed and BackupRepairAndOptimize() as well (so the condition Prefs.UpdateString(PrefName.MySqlVersion,floatVersion.ToString("f1")) must be true. The MySQL version we...

Mifa

Jason, we've added 3 extra tables to the DB to handle SMS messages. Do you think that may be the cause?

Mifa

Weird indeed! It seems to be happening once a day for each computer when we first connect to OD. We get a screen about tables being optimized, it seems that the backup happens then. OD 12.4 we were using in production before this one was also showing this screen but not backing up the DB... Our Back...

Mifa

We've recently upgraded to 14.3 (we compiled it ourselves) and I've noticed that our main database is now being copied several times every day and saved under <DBname>backup_MM_DD_YYYY_someIndex. After 2 weeks, I have more than 100 copies. Is Is there a way to stop that?

Mifa

We have a working solution (see post about SMS in Canada in the main forum for details about our setup). Here is the code I ended up adding to the SendText method of FormTxtMsgEdit.cs. A plugin would have been more elegant. using System.Text.RegularExpressions; // MF added ... /* MF remove start if(...

Mifa

We are in production for about a week now and everything is working fine. We are sending and receiving SMS messages directly in OD. Here is the setup we use: [1] We have a dedicated android cellphone that we use for SMS messaging only (and possibly for emergency during a blackout). Just in case, any...

Mifa

OK, I've answered the first part of my question as well. Enabling the callfire bridge (even though we don't have it) makes the "send text" buttons usable and they work fine with our SMS gateway setup. SendText gets called. It works, but it's not really fancy. New question, that may well be a feature...

Mifa

Thanks! In fact, DataCore is working from the OpenDental namespace. I'm fixing the other bugs in my code. Now, what about the first part of my question? regarding enabling the Callfire bridge so that the "send text" buttons in OD become clickable and only changing SendText, would that work?

Mifa

First, I would like to activate the send SMS button everywhere in the program and not reinvent the wheel. I see in the code that this is tied to the callfire bridge being activated. If I activate the bridge but do not provide any reference to a Callfire dll, program key etc. in the bridge window the...

Mifa

I found another application that work the same as Ozeki (2 way SMS directly in the database) for a fraction of the cost. It's called Diafaan SMS Server ( http://www.diafaan.com/ ), the company seems to be located in the Netherlands. As for the plugin, it might take some time, my coding years are way...

Mifa

Jason, I have found a solution that can work for US and non-US practices. It's called Ozeki NG Gateway ( http://www.ozekisms.com ). Do you know it? It seems very flexible and complete. It allows direct read from/write to MySQL tables using MySQL ODBC. They support several types of SMS Gateways, incl...

Mifa

Thanks Jason for your reply. Please let me know if you find something suitable. So far, I've found providers in Australia or the UK that would work in Canada as well but nothing local (with a good reputation).

Mifa

Callfire still does not support SMS messages in Canada. I'm looking for an alternative that would nicely work with OD, any suggestions from fellow Canadian dentists?

Thanks in advance.

Mifa

Mifa

Would the following fix in FormTimeCardSetup.cs work or is there something else to modify? private void butAdd_Click(object sender, System.EventArgs e) { PayPeriod payPeriodCur=new PayPeriod(); if(PayPeriods.List.Length==0){ payPeriodCur.DateStart=DateTime.Today; } else{ payPeriodCur.DateStart=PayPe...

Mifa

Thank you very much Jason! Much appreciated!

Mifa

I believe you will need to deal with the ACDQ (Quebec's dental association) directly. Here is the link to their contact page: http://www.acdq.qc.ca/en/contact-us/. On the member side of their website, they provide a list of approved software vendors, but no guidelines on how to become one.

Mifa

Thanks for your reply. I'm not familiar with other province's procedures codes, but I wouldn't be surprised if Quebec's codes were different... I did not enter the bulk of the procedure codes manually. Back in 2007, I prepared an excel file based on the procedurecode and fee tables structure and pop...

Mifa

Would it be possible to add the Quebec's dental association (ACDQ) Fee schedule to OD? For the past few years, I've been importing it from another PMS we use together with OD, but I'm planning to phase it out this year. Thanks.

Mifa

It's not an issue for us, especially since we use E4D, we are our own lab... Jordan, if you want to implement the removal of 99XXX codes from production/payments reports, could you put a toggle in the setup windows to activate/deactivate this feature?

Mifa

Here is a variation of query 538 I'm using to track paid hours vs. production hours for any given period of time. Code can certainly be improved. Patnum 4031 and 4551 are "special" patients we use to write notes in the agenda (something like a postit), I don't want to count their "appointments" as p...

Mifa

I'd like to get some advice on a situation I cannot figure out. A few years ago we bought another clinic and imported/merged their patients with ours in OD. In order to avoid seeing "their" patients being counted as NP in the new patients report on their first appointment at "our" clinic, I have dev...

Mifa

I was trying to beef up security a few months ago. One of the things I did was to add a root password to MySQL, just to realize last week, that the root password gets stored in plain English in this FreeDentalConfig.xml file on every computer... Is there a chance that it will get somehow encrypted i...

Mifa

Thanks Jordan for your detailed reply. One more question though: What would happen if someone copied one of the database backups for example (or simply copied the Open dental data folder): would it then be possible for them to restore the database on another machine equipped with MySQL and access th...

Mifa

Is there a way to protect a mysql database with a password? I would like to avoid that someone not authorized copy our database on a usb stick for example and leaves with sensible information that can be easily restored and used anywhere. The root password in MySQL seems to be stored at the server l...

Mifa

Thanks Jordan. and yes, I've checked our default values for these two fields in the patient table and will update these fields accordingly.

Mifa

A long time ago, when we imported our data from our old PMS, I had the great idea to create a different "feesched" and "billingtype" for children under 10. Well, it turns out it was not such a bright idea... To undo it, I was thinking of running an "update patient set ... = ..." query for these two ...

Mifa

For a couple of years now, I've been using an elaborate query to gather production statistics from OD that I put in a set of custom temporary tables. Then, using an ODBC connection that links these tables to an Excel spreadsheet, by the push of a button in Excel, I update my practice monitoring spre...

Mifa

Yes I meant convert. Thanks for your reply.

Mifa

I've found out today that OD is now listed as a certified software for Canadian e-claims by CDA and I've seen that the canadian eclaims page in the manual has been updated as well. Thank you so much for this, that's wonderful news for us up North!!!!!! I will be downloading 11.x very soon and start ...

Mifa

That's very good news! I hope it will go well with ITrans. Good luck!

Mifa

That was it. Leaving the column header to toothnum fixed it. That works for me. Thanks!

Mifa

I guess I will have to upgrade to a newer version to get it to work, it definitely does not in 6.7.

Thanks.

Mifa

We're using OD 6.7. I'm building a custom query for the procedurelog table. I need to show the tooth number using the international system numbering, not the US one. Is there a simple way to do that? Has this been addressed in a more recent version?

Thanks

Mifa

I've had a similar problem a few months ago. Transferring data from the old and small HDD to the new and big one can be tricky... I've downloaded clonezilla and the user manual for cloning small drives to bigger ones. It went like a charm, simple, fast and efficient, and it took real nice care of th...

Mifa

We're using 6.7. Is there a way in this version or in newer ones to prevent employees from changing the regular fee in the procedure edit window that opens from the chart? If they want to change this fee for some reason (discount, no-fee...), I would like to force them to use adjustments instead. At...

Mifa

We are using XDR for image management, but we've got the same button issue with ebay cameras as well. The solution we've been using for some time now is a usb foot switch (a pedal if you prefer). You plug it in a USB port, then in the control panel you look for it in the joystick/game controller opt...

Mifa

Is there any way we could help you?

Mifa

Jordan, I've noticed that Canadian e-claims, that had been listed as incomplete in 7.3 for quite some time, have disappeared a few weeks ago from there and do not show up yet in 7.4. Any update on your progress on this? Thanks.

Mifa

We are buying another dentist's practice and merging it into our own. They are using CTRL, a Canadian PMS, we're using OD. I want to import their patients in OD and tag them as being from this clinic. I strongly doubt I will be able to get an HL7 formatted XML file from CTRL. At best, it's gonna be ...

Mifa

One way of doing it would be to write a query that select patients based on these criteria you mention and save the data in a custom table (for example _mytable), always the same table that you will overwrite every time you run the query. Before you can use it for the first time, you need to establi...

Mifa

OpenOffice Writer for 1-month recall cards (user query in OD sends patients' info in a temporary table, accessed by OO through ODBC) OpenOffice Calc for real-time practice performance monitoring (with ODBC link to custom tables generated with a -very long- user query) key performance indicators such...

Mifa

Thanks for the reply. The problem is that we end up with orphan procedures that are set complete without being attached to an appointment. The query select * from procedurelog where procstatus = 2 and aptnum = 0 typically returns 10 to 15 such procedures per month... it does not seem to affect the s...

Mifa

We're using 6.7.31 in production. My understanding is that when I uncheck "allow setting procedure complete" in the modules settings, users shouldn't be allowed to set a procedure complete and must set the appointment complete instead. I indeed get a warning if I try to right-click set complete on a...

Mifa

A few years ago, I looked at a (free) software called Untangle. You may want to check their website (untangle.com), they have several modules, including one for web filtering on a per user base, apparently.

Mifa

Just to clarify, "regular" comm log entries appear in the account and chart module, but questionnaires only show up in the account module: is this how it is supposed to be? This happens for me with both 5.8.8 (in production) and 6.5.5 (in test).

Mifa

I can see a questionnaire filled by a patient in the commlog section of the account module, but I can't find it in the chart module. I have checked/unchecked commlog and family in the "show" tab, but nothing changes. Any suggestion?

Thanks.

Mifa

We have 5.8 in production; it does not work with this one. I've installed 6.5.17 in tests and it's working fine. I should have checked before posting. Sorry!

Mifa

I've fine-tuned appointment labels (right-click on appointment, select 'Print Label') to fit on smaller labels, using Sheets. Where can I specify once and for all the default printer for these labels? At this point, it always prints them on the default printer for OD. I have tried to play with the s...

Mifa

I'm no SQL expert either, there may be a more elegant way to do that. In our case, we use payment plans to track insurance payments. In Canada, when we submit our claim electronically (through another software as OD doesn't work yet for eclaims for us), we know within seconds how much the insurance ...

Mifa

Until it's fixed, you can try to use query #44 (Payment plan information) to extract only those plans with past due payments. I've tailored it to my own needs and it's working just fine, shortening the payment plans report from 60 pages to 3 in our case...

Mifa

We're using OD since june 2007 in QC and tried to bridge it with our previous PMS (Adstra) for eclaims. We thought we had it right, but after a few months in production, it turned out that it was not working with the newest Adstra version. We've switched since to the limited-version of Exceldent (le...

Mifa

Pardon my ignorance: what is the benefit of this setup vs. a cluster of RAID configured network drives hosting OD's MySQL database? Thanks.

Mifa

OK. I was going the other way around (hiding first). I understand now. Thanks.

Mifa

We've had two employees leaving and a couple of new ones joining the practice. I've modified a week manually in our existing schedule to remove/add employees according to these changes. When I copy the week, the new employees appear correctly in the schedule, but the old ones do not disappear from t...

Mifa

No, payments are properly attached to plans. Any idea why paid off plans still show in this report? Also what about my suggestion regarding scrolling?

Mifa

Could it be possible to have the payment grid scrolled by default all the way down, to the most recent entry? That would make our life easier, and also it'll be consistent with what's done in the patient account grid. Regarding the payment plans report, even in 6.1.5, there is no filtering option, s...

Mifa

Dr. Spark, I'm not sure if your answer is for me or Drtech. Anyway, my point is that aging report and account module balance don't include the amount from overdue payment plans. That's all, it had nothing to do with paper claim, Iwas just trying to explain why we use payment plans this way.

Mifa

We've been using payment plans to track insurance claims and payments (eClaims don't work for Canada). Since we upgraded to 5.8 from 4.6 a few months ago, there has been confusion with overdue payment plans. Before the overhaul of the account module, past due payment plans were added to the patient'...

Mifa

I have 5.8.6 in production and 6.1.5 in test. The bug is with both versions. One of our employees exceptionally came in the office for a few hours on a Sunday. This Sunday was the first day of pay period 2 (our two weeks pay period start on a Sunday and end on a Saturday). She clocked out after 1.55...

Mifa

This seems to be working, it certainly can be improved as it's kind of "brute force"... Also date format is for Canada. This query will return the time worked per day for a given employee over the period of time between startdate and enddate SET @startdate := "2008-06-01"; SET @enddate := "2008-06-3...

Mifa

I know! That's why I was hoping someone had already built one... I'll give it a shot anyway. Thanks.

Mifa

The database documentation for version 5.6.13 (which is the most recent one I've been able to find) says that the clock in/out events will be soon combined in a single row, making it easier to build queries about attendance. My question is simple: is this improvement available yet? If it isn't, has ...

Mifa

I tried to use the feature request module in 5.9. Couldn't get through. I understand this is for paying customers only. From a business standpoint it makes sense: your effort should be focused on their priorities first. However, the other members of the OD community may provide good contribution as ...

Mifa

Has this bug been fixed? I have recently upgraded to 5.7 in production and have 5.8 in test. In both, I see some strange things when a payment is split between patients with payment plans. The balance and printed statements are OK. The payment plan pane in the account window is not: it shows a negat...

Mifa

This is a problem I've been having since day 1 that has to do with character encoding I believe. Until now, it was a minor inconvenient, but as we want to use more features (incl. letter merge), it's now geting in the way big time. It's once again related to those special characters ("e" with an acc...

Mifa

Thanks! I look forward to using this new feature (BTW, why 2 delete buttons? 1 per column?). Will the delete take care of the French entries in the Language table as well or will I have to edit the table with Navicat?

Mifa

Here are some cases - in ContrAccount, the FR-CA translation of items Label, Email, Merge, Show entire history, Fam Urgent Fin note (actually 2 entries in the English column for this one, that don't even correspond to the latest translation) ... - in Form Aging, the long description's (This tool rec...

Mifa

I'm in the process of updating to 5.7 from 4.6. We are a French speaking practice, so I'm also updating the translation of OD's menus and forms. I love the translation utility but at the same time would like to see some improvements/corrections, here is a list of the most important ones IMHO: 1. Som...

Mifa

Even better: in addition to the monthly graph, have daily production goals by dentist/hygienist showing in the calendar (numbers only, no need for a graph here) along with current (daily) planned/completed production. This would help the front-desk better find quickly which openings must be filled i...

Mifa

Not sure this is what your looking for, but try this link http://www.open-dent.com/OpenDentalDocumentation56.xml.

Mifa

Thanks Mowgli! I'll try this as soon as I get a chance.

Mifa

One last thing. Go wireless and run WEP or the newer security. Saves money for wiring. I did and office 10 years ago and tried to foresee the furture for upgrading. WRONG! I had each room wired with a Cat5 hook up and placed some extras here and there. My data requirements have far out stripped my ...

Mifa

To follow in the trend "My wife is a Dentist", here is an account of our experience with OD. My wife bought her clinic in Q2 2006 and we are in production with OD since june 2007; before that date, there was only 1 computer at the front desk used for processing eClaims... To select our PMS, I prepar...

Mifa

Maybe you should add another condition in the WHERE section, to check if the patient is still active: SET @pos=0; SELECT @pos:=@pos+1 as numberofpatients, patient.LName,patient.FName,patient.Address,patient.Address2,patient.City,patient.State,patient.Zip, MAX(procedurelog.procdate) FROM patient,proc...

Mifa

I'm trying to use RDLDesigner for the first time. I want to make some custom queries (Favorites) we've developped more easily available when we upgrade from 4.6 to 5.6. I'm stuck on the first screen for connecting to the database. The default phrase is Server=(local)\VSDotNet;DataBase=Northwind;Inte...

Mifa

Regarding the automatic adjustment of the appointment duration when one changes the treatments: would it be possible to have an option to disable it (in the miscellaneous setup window for example)? If checked, any change to the contents of an appointment would not affect the duration of the appointm...

Mifa

Greeetings everyone, I'm considering a tool to simplify the chair-side data input. I've seen a few mentions in this forum (and the old forum as well) about EasyNotesPro, there's also the new Auto Note feature in OD and someone even hinted using MS Word's autocorrect feature. While EasyNotesPro seems...

Mifa

Just a quick comment from a member of the foreign-speaking club (who's also eagerly waiting for this improvement). Please be kind enough to program all those fields/comments/column headers so that it will be possible for us to translate them all through the translation menu/table.
Thanks!

Mifa

My dentists are complaining about the daily procedures report that shows US teeth numbers even though we're setup for int'l. This should be an easy fix. There may be other reports with the same problem, but I haven't heard any other complaint so far... We, of course, have the same problem with user ...

Mifa

tdong, kdherami,

I'm (finally) ready to send you the bridge program. I could not find a way to attach a zip file to a private message in the forum, so could you both send me an email to mfabre@cp3int.com and I'll attach it to my reply.

Mifa

Bonjour Sabine, J'ai traduit OD en franÃƒÂ§ais pour la clinique de mon ÃƒÂ©pouse. Elle et son ÃƒÂ©quipe l'utilisent depuis bientÃƒÂ´t 1 an sans problÃƒÂ¨mes. Il reste cependant quelques boutons/entÃƒÂªtes/menus qui ne sont pas traduits car ils ne sont pas rÃƒÂ©fÃƒÂ©rencÃƒÂ©s dans le dictionnaire, ma...

Mifa

Wow! Amazing... It works!!! From now on, I'll put the server in a dark room with lead walls to keep it away from these nasty cosmic rays

Thanks a lot!

Mifa

Justin, Jordan, I've tried using MySQL admin. Backup and restore were successful (I even restored under a new name). No errors detected. The restored database works fine in 4.6 but, when converted to 5.4 leads to the same problem. I've even tried a 2 step conversion first from 4.6 to 5.3 (which work...

Mifa

KDherami, TDong, I've just sent you the specs via a private message. Since it's the first time I'm using PMs, let me know if you don't receive it.

Mifa

I didn't use MySQL Admin. I'll follow your advise and see if it solves the problem.

Thanks for replying!

Mifa

Since it seems I'm the only one having this problem, it must be a data problem, which is kind of unsettling since I'm using a backup of our live database that works fine with 4.6 in production and 5.3 in test. To be more specific about the error, it happens whenever I try to access directly or indir...

Mifa

Kderhami, Tdong, I will forward to you both the specs for the bridge so that you assess if it works for you. Unfortunately, I don't have it on my laptop, I will need to dig it up from a backup when I will be back in town next week.

Mifa

I've just downloaded and built 5.4.19 and cannot get it to run. I'm getting an exception 'cannot convert System.SByte to System.Byte' that makes OD crash whenever I click on an appointment in the agenda. Using the debugger, it stops on line 204, in dataObjectFactory.cs. Just to be sure, I've downloa...

Mifa

The first step for you both is to check with Adstra if they still offer the eClaims as a stand alone (it's basically their full package with only the patients, insurance and cdanet functionalities activated). It's not for free of course, but it's still less expensive than the full package.

Mifa

Since eClaims are mandatory for our business, we have had a one-way bridge between OD and Adstra PMP developed for us (frankly speaking, I would have gladly given this same money to help the development of Canadian eClaims in OD instead). The bridge allows us to send patient and procedure informatio...

Search found 141 matches