Thursday 30 June 2016

OpenDental SMS Plugin - Correct communication log type for sent text messages

Issue
Previous, SMS plugin adds a communication log (commlog) record for each sent text. The commlog type is set to the first type in commlog type definition (below)


Therefore, commlog of a patient looks like below:

Solution
The latest SMS plugin version 16.1.31 has fixed this issue. In order to do so, you need to set up the commlog type list in particular order (go to Setup/Definition => CommLog type and use Up and Down button):
  1. ApptRelated
  2. Recall
  3. Financial
    ...
     The last is Misc

The plugin will use:
  • first type for Appointment confirmation texts
  • second type for Recall texts
  • third type for Payment confirmation texts (you may no use this feature see here)
  • last type is Misc for all other texts






Monday 6 June 2016

An example of how to setup Google Calendar Sync plugin

(from rhaber posts in OpenDental forum)

With great thank to Dr Richard Haber who has been testing the plugin intensively for us and provided valuable feedbacks to improve the plugin

(source: http://opendentalsoft.com/forum/viewtopic.php?f=1&t=6035)

Now I want to share with you how I am planning to use the ONLINE scheduling with simplybook.me
(or you can use any other similar service)
I have not implemented that in my office yet

- Mopensoft plugin will allow OD to sync to Google Calendar (automated and manual sync options available)
- Google Calendar will sync to simplybook.me (or any other provider) - ..... simplybook.me offer 2 ways sync with google calendar and not just integration with google calendar.
- Email is sent from simplybook.me to the provider informing the office that a booking is made.
- In OD, you get a pop up that an appointment was made online (not finished yet, Minh working on it ......)
- Front office enter the appointment in OD, 
- and Mopensoft plugin autosync, will sync OD to Google Calendar again

I have not started this online booking yet , still testing for over a week now and it looks fine, 
http://www.simplybook.me offer one month free trial to test their services.

Through http://www.simplybook.me I was able to create these options

Image

I decided to design this online booking webpage on my website, and the link will be emailed to our recall patients, and maybe to those patients that need treatments.
so when a patient click on one of these options, the booking calendar open directly without going through all the additional options that are provided by simplybook.me widget.
I just wanted to bypass all the other additional pages.

You can create any options that you are interested in, depending on your office needs

Again, I am still testing it, and it look very promising

If you test it, and you find any bug, please post it here or email it to mopensoft

----------------------------------------------------------------------------------------------------------

http://opendentalsoft.com/forum/viewtopic.php?f=1&t=6200)

I started using a different online scheduling, similar to OD web schedule, for our patients to make their own appointments, and it is a very GOOD start. 
http://opendentalsoft.com/forum/viewtopic.php?f=1&t=6035

last year , my receptionist started collecting patients emails and cell phone numbers. so we have a good database.
We presented this small UPDATE slip to “ALL” of our patients ( every patient that walked through our door)
presented to them as an update of personal information.

. UPDATE 
Last Name: ____________________ First Name_________________________
Email address: _____________________________________________________
Wireless Phone: (_____ )____________________________________________

Telling your patients about THIS ONLINE BOOKING is always the missing part.

1- We sent an email to all of our active patients telling them about the "New Online Scheduling" that is available to them now

Subject: NEW Online Scheduling - Book Online your next dental appointment! 

We are happy to inform you that you can now book your appointment online with our office 24/7. This option is available on our webpage http://www. {URL} 
Call our office (123) 456-7890 if you are having any difficulty finding the right time to schedule your appointment. 
We will do our best to accommodate your schedule.
We look forward to seeing you at your next appointment. 

2- In all of the recall template Email messages we added this message too: 
"New Online Scheduling is available now 24/7 on our webpage {URL} "
from the main Menu, go to Setup/ Appointments/ Recall
We mainly sent it to those patients who are overdue for recall, 

3- we added that also to the Text messaging and Email "CONFIRMATIONS" templates
so patients will know that online scheduling is available to them now
"New Online Scheduling is available now 24/7 on our webpage {URL} "

4- we added it to the message that is sent on the recall reminders post cards too
(if we do not have a patient email or cell phone number)

5- we added it at the bottom of our signature in any email sent to patients

6- " I " tell every patient that comes to our office that next time they can try it and give us their feed back

7- Made a special appointments options on our contact webpage mainly for NEW PATIENTS to use it
Easier for the new patients to schedule their appointment


Note: The 2 ways TEXT MESSAGING was the best thing I added to OD
We have been using it for over a year now and it really works!

Wednesday 1 June 2016

A toy model: tennis team roster


We put in a tennis team to play Victoria Tennis Pennant grade 7 this winter.

  •             There are 6 players in the team and 5 of them are keen to play as much as possible while I only want to play occasionally.
  •             There are 8 team in the section so we decide to make have 5 players playing 10 weeks and I only play 6 weeks.
  •             There are 7 weeks’ away and 7 weeks’ home.
  •             Odd weeks are for single matches and even weeks are for double matches
  •             One player doesn’t have car so I make a trade off with him, he plays as many home matches as possible and I’m happy to play more away matches.
As the round robin schedule came out, the captain needs to make the roster which is a bit tricky to make everyone happy. For example, I only play 6 matches so I do not want to play an opponent twice, or player want to play even single/double matches, home/away matches, or player do not want to play/no-play too many weeks in a row, etc.
So I decided to put it into a model and let the optimization solver work out the best roster.

The model

Input data:
  •           Number of team = 8
  •           Number of round = 14
  •           Number of players = 6
  •           Number of players for each week = 4
  •           Array of number of playing weeks for each players: array of 6 elements.
  •           Home and away schedule: and array of size 14 with equal home and away elements
  •           Single and double schedule: and array of size 14 with equal single and double elements
  •           Player 1 prefers play home
  •           Player 5 only play 6 weeks (it’s me)

Constraints:
  •           Except Titus and Minh, everyone has number of home and away match difference of no more than 1 
  •           Everyone has number of single and double match difference of no more than 1 
  •           Everyone except Minh play other team at least once
  •           No one play more than 4 weeks in a row
  •           No one off more than 2 weeks in a row
  •           Except me, each player plays all other teams at least once.

Objective:
  •           Maximum player 1 home matches

Implementation: The model is built in Minizinc (www.minizinc.org) and run on 2 solvers comes with Minizinc IDE, Gecode  and G12 FD.


Result: Both found optimal solution less than 1 second and give player one 7 matches.