Search found 137 matches

by Mifa
Fri Dec 13, 2019 12:54 pm
Forum: Advanced Topics
Topic: Custom reports: looking for an alternative to RDL
Replies: 0
Views: 2169

Custom reports: looking for an alternative to RDL

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
by Mifa
Fri Dec 28, 2018 2:45 pm
Forum: Developers
Topic: Changing payment sort order
Replies: 2
Views: 679

Re: Changing payment sort order

Thanks Allen, this is what I was looing for.
by Mifa
Fri Dec 21, 2018 10:16 pm
Forum: Developers
Topic: Changing payment sort order
Replies: 2
Views: 679

Changing payment sort order

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...
by Mifa
Fri Jul 27, 2018 11:13 pm
Forum: Advanced Topics
Topic: Importing basic insurance information into OD
Replies: 1
Views: 3089

Importing basic insurance information into OD

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...
by Mifa
Mon Feb 26, 2018 1:03 pm
Forum: Advanced Topics
Topic: Primary key duplicate
Replies: 3
Views: 1953

Re: Primary key duplicate

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... :D
by Mifa
Mon Feb 26, 2018 11:01 am
Forum: Advanced Topics
Topic: Primary key duplicate
Replies: 3
Views: 1953

Primary key duplicate

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...
by Mifa
Mon Sep 18, 2017 7:22 am
Forum: Advanced Topics
Topic: Alternative to Crashplan - PC to PC backup over the Internet
Replies: 3
Views: 3970

Alternative to Crashplan - PC to PC backup over the Internet

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...
by Mifa
Tue Oct 04, 2016 5:07 pm
Forum: Advanced Topics
Topic: Recall Interval
Replies: 4
Views: 4056

Re: Recall Interval

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! :D
by Mifa
Mon Aug 29, 2016 8:09 am
Forum: Main Forum
Topic: Set Appointment complete vs set procedure complete
Replies: 9
Views: 13361

Re: Set Appointment complete vs set procedure complete

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...
by Mifa
Sat Jul 23, 2016 6:17 pm
Forum: Main Forum
Topic: Problem with XDR after server upgrade to Windows 10
Replies: 3
Views: 5039

Re: Problem with XDR after server upgrade to Windows 10

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...
by Mifa
Sat Jul 23, 2016 5:02 pm
Forum: Main Forum
Topic: Problem with XDR after server upgrade to Windows 10
Replies: 3
Views: 5039

Problem with XDR after server upgrade to Windows 10

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...
by Mifa
Wed Jun 01, 2016 8:13 pm
Forum: Main Forum
Topic: EasyMarkit
Replies: 0
Views: 2852

EasyMarkit

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...
by Mifa
Fri May 13, 2016 6:37 am
Forum: Main Forum
Topic: Set Appointment complete vs set procedure complete
Replies: 9
Views: 13361

Re: Set Appointment complete vs set procedure complete

Thanks Jason!

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

Mifa
by Mifa
Thu May 12, 2016 5:35 am
Forum: Main Forum
Topic: Set Appointment complete vs set procedure complete
Replies: 9
Views: 13361

Re: Set Appointment complete vs set procedure complete

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...
by Mifa
Wed May 11, 2016 6:45 am
Forum: Main Forum
Topic: Set Appointment complete vs set procedure complete
Replies: 9
Views: 13361

Re: Set Appointment complete vs set procedure complete

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 ...
by Mifa
Tue May 10, 2016 2:25 pm
Forum: Main Forum
Topic: Set Appointment complete vs set procedure complete
Replies: 9
Views: 13361

Set Appointment complete vs set procedure complete

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...
by Mifa
Tue Apr 05, 2016 7:53 am
Forum: Main Forum
Topic: Inventory control
Replies: 3
Views: 2657

Inventory control

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.
by Mifa
Wed Jan 27, 2016 4:43 pm
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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...
by Mifa
Fri Jan 22, 2016 11:07 am
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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...
by Mifa
Wed Jan 20, 2016 11:27 pm
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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
by Mifa
Wed Jan 20, 2016 10:27 pm
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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...
by Mifa
Wed Jan 20, 2016 1:45 am
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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...
by Mifa
Thu Jan 14, 2016 8:05 am
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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...
by Mifa
Wed Jan 13, 2016 11:48 am
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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...
by Mifa
Thu Dec 10, 2015 11:09 pm
Forum: Advanced Topics
Topic: Kiosk tablets and wired network
Replies: 4
Views: 3873

Re: Kiosk tablets and wired network

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 ...
by Mifa
Thu Dec 10, 2015 11:25 am
Forum: Advanced Topics
Topic: Kiosk tablets and wired network
Replies: 4
Views: 3873

Kiosk tablets and wired network

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...
by Mifa
Tue Dec 08, 2015 1:45 pm
Forum: Advanced Topics
Topic: Patients list refresh while typing
Replies: 3
Views: 2480

Re: Patients list refresh while typing

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.
by Mifa
Tue Dec 08, 2015 12:06 pm
Forum: Advanced Topics
Topic: Patients list refresh while typing
Replies: 3
Views: 2480

Patients list refresh while typing

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...
by Mifa
Tue Dec 08, 2015 11:47 am
Forum: Advanced Topics
Topic: Translation for tooth surface in group notes
Replies: 6
Views: 3836

Re: Translation for tooth surface in group notes

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...
by Mifa
Thu Dec 03, 2015 8:47 pm
Forum: Advanced Topics
Topic: Translation for tooth surface in group notes
Replies: 6
Views: 3836

Re: Translation for tooth surface in group notes

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...
by Mifa
Thu Dec 03, 2015 2:15 pm
Forum: Advanced Topics
Topic: Translation for tooth surface in group notes
Replies: 6
Views: 3836

Re: Translation for tooth surface in group notes

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...
by Mifa
Fri Nov 27, 2015 9:19 pm
Forum: Advanced Topics
Topic: Translation for tooth surface in group notes
Replies: 6
Views: 3836

Translation for tooth surface in group notes

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.
by Mifa
Mon Nov 09, 2015 10:57 am
Forum: Advanced Topics
Topic: Is your root password blank?
Replies: 22
Views: 8994

Re: Is your root password blank?

Do you mean that mysql's root password will not be saved in plain text anymore in freedentalconfig?
by Mifa
Fri Oct 16, 2015 12:12 pm
Forum: Advanced Topics
Topic: Weird hang with OD and Visual Studio on one computer
Replies: 3
Views: 2962

Re: Weird hang with OD and Visual Studio on one computer

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...
by Mifa
Wed Oct 14, 2015 1:24 pm
Forum: Advanced Topics
Topic: Weird hang with OD and Visual Studio on one computer
Replies: 3
Views: 2962

Re: Weird hang with OD and Visual Studio on one computer

Just one more detail, OD is working in Windows Safe Mode with networking.
by Mifa
Wed Oct 14, 2015 12:28 pm
Forum: Advanced Topics
Topic: Weird hang with OD and Visual Studio on one computer
Replies: 3
Views: 2962

Weird hang with OD and Visual Studio on one computer

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...
by Mifa
Tue Aug 11, 2015 3:34 pm
Forum: Main Forum
Topic: text reminders
Replies: 15
Views: 8655

Re: text reminders

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?
by Mifa
Tue Jun 16, 2015 2:10 pm
Forum: Advanced Topics
Topic: Recall Interval
Replies: 4
Views: 4056

Re: Recall Interval

Thanks Jason!
by Mifa
Tue Jun 16, 2015 11:28 am
Forum: Advanced Topics
Topic: Recall Interval
Replies: 4
Views: 4056

Recall Interval

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.
by Mifa
Wed Jun 10, 2015 8:34 am
Forum: Main Forum
Topic: Deleting an out of date code
Replies: 7
Views: 2608

Re: Deleting an out of date code

Sorry to reopen an old thread. Is there a way to prevent users from using "obsolete" codes?
by Mifa
Tue Apr 07, 2015 9:37 pm
Forum: Main Forum
Topic: Changing a default pay period lenght of 15 days
Replies: 4
Views: 1472

Re: Changing a default pay period lenght of 15 days

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
by Mifa
Sun Mar 29, 2015 3:47 pm
Forum: Main Forum
Topic: SMS reminders in Canada
Replies: 13
Views: 3260

Re: SMS reminders in Canada

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...
by Mifa
Fri Mar 20, 2015 6:27 am
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

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...
by Mifa
Thu Mar 19, 2015 1:08 pm
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

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)...
by Mifa
Thu Mar 19, 2015 12:40 pm
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

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
by Mifa
Thu Mar 19, 2015 7:00 am
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

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.
by Mifa
Thu Mar 19, 2015 6:20 am
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

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...
by Mifa
Thu Mar 19, 2015 5:46 am
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

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...
by Mifa
Wed Mar 18, 2015 12:59 pm
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

Jason, we've added 3 extra tables to the DB to handle SMS messages. Do you think that may be the cause?
by Mifa
Wed Mar 18, 2015 12:56 pm
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Re: Database copies

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...
by Mifa
Wed Mar 18, 2015 9:57 am
Forum: Advanced Topics
Topic: Database copies
Replies: 15
Views: 7411

Database copies

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?
by Mifa
Wed Mar 04, 2015 1:20 pm
Forum: Developers
Topic: SMS plug-in questions
Replies: 14
Views: 5363

Re: SMS plug-in questions

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(...
by Mifa
Wed Mar 04, 2015 1:03 pm
Forum: Main Forum
Topic: SMS reminders in Canada
Replies: 13
Views: 3260

Re: SMS reminders in Canada

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...
by Mifa
Mon Feb 16, 2015 9:21 am
Forum: Developers
Topic: SMS plug-in questions
Replies: 14
Views: 5363

Re: SMS plug-in questions

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...
by Mifa
Mon Feb 16, 2015 8:17 am
Forum: Developers
Topic: SMS plug-in questions
Replies: 14
Views: 5363

Re: SMS plug-in questions

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?
by Mifa
Sun Feb 15, 2015 11:31 am
Forum: Developers
Topic: SMS plug-in questions
Replies: 14
Views: 5363

SMS plug-in questions

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...
by Mifa
Tue Feb 10, 2015 11:49 pm
Forum: Main Forum
Topic: SMS reminders in Canada
Replies: 13
Views: 3260

Re: SMS reminders in Canada

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...
by Mifa
Sun Feb 08, 2015 6:22 pm
Forum: Main Forum
Topic: SMS reminders in Canada
Replies: 13
Views: 3260

Re: SMS reminders in Canada

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...
by Mifa
Wed Feb 04, 2015 8:56 am
Forum: Main Forum
Topic: SMS reminders in Canada
Replies: 13
Views: 3260

Re: SMS reminders in Canada

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).
by Mifa
Tue Jan 27, 2015 9:18 pm
Forum: Main Forum
Topic: SMS reminders in Canada
Replies: 13
Views: 3260

SMS reminders in Canada

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
by Mifa
Mon Nov 10, 2014 2:52 pm
Forum: Main Forum
Topic: Bug Report/buggy behavior - pay periods ended
Replies: 9
Views: 8132

Re: Bug Report/buggy behavior - pay periods ended

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...
by Mifa
Tue Jun 24, 2014 8:27 pm
Forum: Advanced Topics
Topic: Quebec (ACDQ) fee schedule
Replies: 8
Views: 8518

Re: Quebec (ACDQ) fee schedule

Thank you very much Jason! Much appreciated!
by Mifa
Mon Jan 27, 2014 4:09 pm
Forum: Advanced Topics
Topic: Quebec (ACDQ) fee schedule
Replies: 8
Views: 8518

Re: Quebec (ACDQ) fee schedule

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.
by Mifa
Sat Jan 11, 2014 10:14 pm
Forum: Advanced Topics
Topic: Quebec (ACDQ) fee schedule
Replies: 8
Views: 8518

Re: Quebec (ACDQ) fee schedule

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...
by Mifa
Tue Jan 07, 2014 4:33 pm
Forum: Advanced Topics
Topic: Quebec (ACDQ) fee schedule
Replies: 8
Views: 8518

Quebec (ACDQ) fee schedule

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.
by Mifa
Tue Jan 07, 2014 4:22 pm
Forum: Main Forum
Topic: Canadian Production and Payment without lab fee
Replies: 2
Views: 861

Re: Canadian Production and Payment without lab fee

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?
by Mifa
Mon Nov 11, 2013 11:57 am
Forum: Main Forum
Topic: Query #746 variation
Replies: 1
Views: 748

Re: Query #746 variation

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...
by Mifa
Tue Jun 11, 2013 12:03 pm
Forum: Advanced Topics
Topic: New patients reporting - DateFirstVisit
Replies: 0
Views: 1811

New patients reporting - DateFirstVisit

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...
by Mifa
Sat May 18, 2013 2:59 pm
Forum: Main Forum
Topic: Disabling the "Choose Database" window on startup
Replies: 4
Views: 1236

Re: Disabling the "Choose Database" window on startup

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...
by Mifa
Mon Sep 24, 2012 7:12 am
Forum: Advanced Topics
Topic: MySQL database password protection
Replies: 8
Views: 7058

Re: MySQL database password protection

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...
by Mifa
Thu Sep 20, 2012 6:03 pm
Forum: Advanced Topics
Topic: MySQL database password protection
Replies: 8
Views: 7058

MySQL database password protection

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...
by Mifa
Wed Mar 21, 2012 8:42 am
Forum: Advanced Topics
Topic: updating billingtype and feesched
Replies: 2
Views: 2297

Re: updating billingtype and feesched

Thanks Jordan. and yes, I've checked our default values for these two fields in the patient table and will update these fields accordingly.
by Mifa
Tue Mar 20, 2012 2:15 pm
Forum: Advanced Topics
Topic: updating billingtype and feesched
Replies: 2
Views: 2297

updating billingtype and feesched

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 ...
by Mifa
Fri Jan 27, 2012 9:27 am
Forum: Advanced Topics
Topic: ODBC connection over VPN
Replies: 1
Views: 2277

ODBC connection over VPN

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...
by Mifa
Wed Aug 24, 2011 3:06 am
Forum: Main Forum
Topic: Canadian Claims
Replies: 16
Views: 2351

Re: Canadian Claims

Yes I meant convert. Thanks for your reply.
by Mifa
Tue Aug 23, 2011 5:15 pm
Forum: Main Forum
Topic: Canadian Claims
Replies: 16
Views: 2351

Re: Canadian Claims

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 ...
by Mifa
Thu Mar 31, 2011 5:14 am
Forum: Main Forum
Topic: Canadian Claims
Replies: 16
Views: 2351

Re: Canadian Claims

That's very good news! I hope it will go well with ITrans. Good luck!
by Mifa
Fri Feb 04, 2011 12:49 pm
Forum: Advanced Topics
Topic: International tooth numbering in queries
Replies: 6
Views: 2020

Re: International tooth numbering in queries

That was it. Leaving the column header to toothnum fixed it. That works for me. Thanks!
by Mifa
Fri Feb 04, 2011 7:11 am
Forum: Advanced Topics
Topic: International tooth numbering in queries
Replies: 6
Views: 2020

Re: International tooth numbering in queries

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

Thanks.
by Mifa
Thu Feb 03, 2011 1:58 pm
Forum: Advanced Topics
Topic: International tooth numbering in queries
Replies: 6
Views: 2020

International tooth numbering in queries

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
by Mifa
Fri Nov 26, 2010 10:48 am
Forum: Main Forum
Topic: Hard disk space is full
Replies: 8
Views: 1648

Re: Hard disk space is full

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...
by Mifa
Wed Oct 27, 2010 4:19 pm
Forum: Main Forum
Topic: Preventing edition of reg. fee in the procedure edit window
Replies: 1
Views: 570

Preventing edition of reg. fee in the procedure edit window

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...
by Mifa
Mon Oct 04, 2010 3:50 pm
Forum: Main Forum
Topic: Twain support for webcams and cameras
Replies: 31
Views: 51056

Re: Twain support for webcams and cameras

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...
by Mifa
Wed Sep 29, 2010 6:56 pm
Forum: Main Forum
Topic: New Beta is out!
Replies: 7
Views: 1487

Re: New Beta is out!

Is there any way we could help you?
by Mifa
Wed Sep 29, 2010 7:28 am
Forum: Main Forum
Topic: New Beta is out!
Replies: 7
Views: 1487

Re: New Beta is out!

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.
by Mifa
Fri Aug 27, 2010 2:55 am
Forum: Advanced Topics
Topic: Importing patients info into an existing OD database
Replies: 4
Views: 2596

Importing patients info into an existing OD database

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 ...
by Mifa
Tue Aug 03, 2010 8:21 pm
Forum: Main Forum
Topic: Letter Merge Unhandled Exception
Replies: 4
Views: 950

Re: Letter Merge Unhandled Exception

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...
by Mifa
Mon Jun 14, 2010 8:53 am
Forum: Main Forum
Topic: What 3rd Party Software Do you Use?
Replies: 8
Views: 2505

Re: What 3rd Party Software Do you Use?

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...
by Mifa
Thu Apr 01, 2010 1:31 pm
Forum: Main Forum
Topic: set appointment complete
Replies: 2
Views: 824

Re: set appointment complete

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...
by Mifa
Thu Apr 01, 2010 11:48 am
Forum: Main Forum
Topic: set appointment complete
Replies: 2
Views: 824

set appointment complete

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...
by Mifa
Sat Aug 29, 2009 9:03 am
Forum: Main Forum
Topic: XP Pro and Internet Explorer
Replies: 18
Views: 9722

Re: XP Pro and Internet Explorer

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.
by Mifa
Tue Jul 07, 2009 9:27 pm
Forum: Main Forum
Topic: New patient questionnaire
Replies: 5
Views: 1166

Re: New patient questionnaire

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).
by Mifa
Sun Jul 05, 2009 7:50 am
Forum: Main Forum
Topic: New patient questionnaire
Replies: 5
Views: 1166

New patient questionnaire

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.
by Mifa
Tue May 26, 2009 3:30 am
Forum: Main Forum
Topic: Print Label (appointment)
Replies: 2
Views: 827

Re: Print Label (appointment)

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!
by Mifa
Mon May 25, 2009 12:10 pm
Forum: Main Forum
Topic: Print Label (appointment)
Replies: 2
Views: 827

Print Label (appointment)

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...
by Mifa
Sat Mar 14, 2009 4:19 am
Forum: Main Forum
Topic: Payment Plan Report
Replies: 4
Views: 1163

Re: Payment Plan Report

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 ...
by Mifa
Thu Mar 05, 2009 2:18 pm
Forum: Main Forum
Topic: Payment Plan Report
Replies: 4
Views: 1163

Re: Payment Plan Report

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...
by Mifa
Wed Jan 28, 2009 2:59 am
Forum: Main Forum
Topic: Canadian eclaim
Replies: 3
Views: 1268

Re: Canadian eclaim

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...
by Mifa
Sun Jan 25, 2009 5:47 pm
Forum: Main Forum
Topic: Open Dental Cluster (dual servers)!
Replies: 22
Views: 19627

Re: Open Dental Cluster (dual servers)!

Pardon my ignorance: what is the benefit of this setup vs. a cluster of RAID configured network drives hosting OD's MySQL database? Thanks.
by Mifa
Wed Jan 21, 2009 8:07 pm
Forum: Advanced Topics
Topic: Updating employee schedule
Replies: 2
Views: 1323

Re: Updating employee schedule

OK. I was going the other way around (hiding first). I understand now. Thanks.
by Mifa
Wed Jan 21, 2009 3:25 pm
Forum: Advanced Topics
Topic: Updating employee schedule
Replies: 2
Views: 1323

Updating employee schedule

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...
by Mifa
Wed Dec 03, 2008 6:36 am
Forum: Main Forum
Topic: Overdue payment plan and account balance
Replies: 8
Views: 1980

Re: Overdue payment plan and account balance

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?
by Mifa
Thu Nov 27, 2008 5:38 pm
Forum: Main Forum
Topic: Overdue payment plan and account balance
Replies: 8
Views: 1980

Re: Overdue payment plan and account balance

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...
by Mifa
Tue Nov 25, 2008 8:29 pm
Forum: Main Forum
Topic: Overdue payment plan and account balance
Replies: 8
Views: 1980

Re: Overdue payment plan and account balance

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.
by Mifa
Tue Nov 25, 2008 5:57 am
Forum: Main Forum
Topic: Overdue payment plan and account balance
Replies: 8
Views: 1980

Overdue payment plan and account balance

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'...
by Mifa
Tue Nov 25, 2008 5:29 am
Forum: Advanced Topics
Topic: Bug with time card calculations
Replies: 3
Views: 1632

Bug with time card calculations

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...
by Mifa
Sat Nov 15, 2008 9:16 pm
Forum: Advanced Topics
Topic: Clock in/out events
Replies: 3
Views: 1794

Re: Clock in/out events

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...
by Mifa
Sat Nov 15, 2008 5:22 pm
Forum: Advanced Topics
Topic: Clock in/out events
Replies: 3
Views: 1794

Re: Clock in/out events

I know! That's why I was hoping someone had already built one... I'll give it a shot anyway. Thanks.
by Mifa
Sat Nov 15, 2008 2:54 pm
Forum: Advanced Topics
Topic: Clock in/out events
Replies: 3
Views: 1794

Clock in/out events

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 ...
by Mifa
Sat Nov 08, 2008 8:07 pm
Forum: Main Forum
Topic: Feature Request and Canadian eclaims... a catch 22?
Replies: 0
Views: 963

Feature Request and Canadian eclaims... a catch 22?

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 ...
by Mifa
Fri Aug 29, 2008 7:49 am
Forum: Advanced Topics
Topic: Bad Math on the New Payment Plan Window
Replies: 3
Views: 2442

Re: Bad Math on the New Payment Plan Window

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...
by Mifa
Sun Aug 10, 2008 12:05 am
Forum: Advanced Topics
Topic: Exporting data with special characters (accented letters)
Replies: 0
Views: 1196

Exporting data with special characters (accented letters)

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...
by Mifa
Fri Aug 08, 2008 10:43 am
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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?
by Mifa
Thu Aug 07, 2008 11:35 pm
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Re: Request for improvement - Translation

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...
by Mifa
Thu Aug 07, 2008 7:59 pm
Forum: Advanced Topics
Topic: Request for improvement - Translation
Replies: 39
Views: 16393

Request for improvement - Translation

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...
by Mifa
Tue Aug 05, 2008 10:19 pm
Forum: Developers
Topic: Production Goals
Replies: 3
Views: 1511

Re: Production Goals

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...
by Mifa
Wed Jun 18, 2008 4:44 pm
Forum: Developers
Topic: DataDictionary of database model
Replies: 2
Views: 1384

Re: DataDictionary of database model

Not sure this is what your looking for, but try this link http://www.open-dent.com/OpenDentalDocumentation56.xml.
by Mifa
Tue May 13, 2008 11:12 pm
Forum: Advanced Topics
Topic: First time with RDLDesigner
Replies: 2
Views: 1582

Re: First time with RDLDesigner

Thanks Mowgli! I'll try this as soon as I get a chance.
by Mifa
Tue May 13, 2008 11:11 pm
Forum: Main Forum
Topic: weighing the big decision
Replies: 18
Views: 102647

Re: weighing the big decision

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 ...
by Mifa
Tue May 13, 2008 10:34 pm
Forum: Main Forum
Topic: weighing the big decision
Replies: 18
Views: 102647

Re: weighing the big decision

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...
by Mifa
Fri May 02, 2008 7:00 pm
Forum: Main Forum
Topic: question on example query
Replies: 5
Views: 1634

Re: question on example query

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...
by Mifa
Fri May 02, 2008 2:42 pm
Forum: Advanced Topics
Topic: First time with RDLDesigner
Replies: 2
Views: 1582

First time with RDLDesigner

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...
by Mifa
Thu Mar 20, 2008 10:30 am
Forum: Main Forum
Topic: Procedure Time - Time Pattern
Replies: 5
Views: 1740

Re: Procedure Time - Time Pattern

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...
by Mifa
Sun Feb 24, 2008 2:09 pm
Forum: Main Forum
Topic: easynotespro vs. auto note: which way is best?
Replies: 1
Views: 1230

easynotespro vs. auto note: which way is best?

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...
by Mifa
Thu Feb 21, 2008 10:40 am
Forum: Developers
Topic: Statements/Account
Replies: 42
Views: 33802

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!
by Mifa
Tue Feb 12, 2008 3:35 pm
Forum: Advanced Topics
Topic: Daily procedure report and int'l tooth numbers
Replies: 1
Views: 1118

Daily procedure report and int'l tooth numbers

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 ...
by Mifa
Sat Feb 02, 2008 1:56 pm
Forum: Main Forum
Topic: Canadian E-claims
Replies: 38
Views: 8385

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.
by Mifa
Fri Feb 01, 2008 7:24 am
Forum: Main Forum
Topic: Open dental software : france?
Replies: 4
Views: 1064

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...
by Mifa
Tue Jan 08, 2008 9:18 pm
Forum: Developers
Topic: 5.4.19 - clicking on an appointment in the agenda crashes OD
Replies: 13
Views: 7364

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 :lol:

Thanks a lot!
by Mifa
Mon Jan 07, 2008 8:30 pm
Forum: Developers
Topic: 5.4.19 - clicking on an appointment in the agenda crashes OD
Replies: 13
Views: 7364

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...
by Mifa
Sun Jan 06, 2008 12:08 pm
Forum: Main Forum
Topic: Canadian E-claims
Replies: 38
Views: 8385

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.
by Mifa
Sun Jan 06, 2008 11:58 am
Forum: Developers
Topic: 5.4.19 - clicking on an appointment in the agenda crashes OD
Replies: 13
Views: 7364

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

Thanks for replying!
by Mifa
Sun Jan 06, 2008 10:15 am
Forum: Developers
Topic: 5.4.19 - clicking on an appointment in the agenda crashes OD
Replies: 13
Views: 7364

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...
by Mifa
Thu Dec 27, 2007 4:52 pm
Forum: Main Forum
Topic: Canadian E-claims
Replies: 38
Views: 8385

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.
by Mifa
Thu Dec 27, 2007 4:46 pm
Forum: Developers
Topic: 5.4.19 - clicking on an appointment in the agenda crashes OD
Replies: 13
Views: 7364

5.4.19 - clicking on an appointment in the agenda crashes OD

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...
by Mifa
Sat Dec 22, 2007 2:35 pm
Forum: Main Forum
Topic: Canadian E-claims
Replies: 38
Views: 8385

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.
by Mifa
Fri Dec 21, 2007 10:59 pm
Forum: Main Forum
Topic: Canadian E-claims
Replies: 38
Views: 8385

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