Oscar User Group meeting – Sat. Nov 11th 2017

There will be an Oscar User Group meeting on Saturday November 11th at the Hotel Intercontinental. The meeting will run from 9:00 AM to 5:00 PM.

The Oscar meeting is being held at the same time as the annual FMF conference, but is NOT part of that conference.   FMF Conference Web Page

The event is being sponsored by the Queen Elizabeth Medical Group, which is the largest  Oscar clinic in Quebec.

We thought that if physicians were attending the FMF conference, they might want to cross the street and visit.

There is no charge and everyone who is interested in Oscar is welcome. We are providing snacks and lunch. You do NOT have to register with the FMF to attend but you DO have to RSVP.

Note: We need to know how many lunches to prepare, so please let us know beforehand.


Tentative Agenda (to be confirmed)

David Chan, the creator of Oscar will give the keynote presentation.

OscarQC vs Oscar Open Source

SelfBooking for Oscar



To confirm, please call me (514) 891-3275 or email earlwer@gmail.com

More news to follow…


Posted in News | Comments Off on Oscar User Group meeting – Sat. Nov 11th 2017


We do conversions.

We can convert data from virtually any format, into Oscar.

The basic conversion includes demographics and appointments.  The cost is $2000 for any format and any volume of data.

If you are using another EMR and want to convert your data, just call me or send an email (earlw at oscar-quebec.com).

I have converted data from the following EMRs: ABELMed, CareFile, DoctorDirect, HealthScreen, Hero, IntraHealth, Jonoke, MD4000, Medcom, Osler, P&P, QuickClaim,  SoftInfo and XWave.

I have also converted data from Excel, Access, 4thDimension, Foxpro, mySQL, PDF and SQL Server.

Don’t let your data lock you into your EMR.  We can extract the data and migrate it into Oscar.

Posted in About, News | Tagged | Comments Off on Conversions

Oscar 15 is here

Good news: Oscar 15 is out of beta and is being installed.

Bad news: Some of the underlying components (Tomcat, Java) have been updated and the upgrade may not be compatible with your current Ubuntu version.  This makes the upgrade more complicated.

I will probably start to upgrade clients in the Fall of 2016.


Posted in News | Comments Off on Oscar 15 is here

eForm programming notes

Converting PDF images to PNG

Open PDF with Inkscape:
– File, Export Bitmap (high resolution is good)
Open Bitmap file with IrfanView:
– crop borders: select area, Edit, Crop Selection (Ctrl-Y)
– adjust resolution to 1500 x 2000: Image, Resize/Resample, Width 1500, Height 2000 max, DPI 600
– reduce color depth to 16 colours: Image, Decrease Color depth, 16 Colors
– save as .PNG

Auto refresh eForm changes

Adding the following line to your eForm will force it to automatically refresh every 5 seconds, which is great when changing code in one window and viewing the results in another.

<meta http-equiv="refresh" content="5" >

Accent conversion

The RTL needs correct HTML codes for the accents.
This web site makes it easy to convert the text:

Yes/No choices with XBox

<input name="HPTWaY" id="HPTWaY" type="text" class="Xbox" style="position:absolute; left:382px; top:580px; width:12px; height:12px; font-family:sans-serif; font-style:normal; font-weight:bold; font-size:14px; text-align:center; border:1px solid #000000; background-color:transparent;" onkeypress="javascript:return displayKeyCode(event,this.id);" onClick="document.FormName.HPTWaN.value='';">
<input name="HPTWaN" id="HPTWaN" type="text" class="Xbox" style="position:absolute; left:435px; top:580px; width:12px; height:12px; font-family:sans-serif; font-style:normal; font-weight:bold; font-size:14px; text-align:center; border:1px solid #000000; background-color:transparent;" onkeypress="javascript:return displayKeyCode(event,this.id);" onClick="document.FormName.HPTWaY.value='';">

Yes/No choices with checkboxes

<script language="javascript">
function ChkBoxYN(checkboxid,uncheckboxid) { 
 if(document.getElementById(checkboxid).checked==true) { 
<input name="physy" id="physy" type="checkbox" class="largerCheckbox" style="position:absolute; left:140px; top:211px;" onclick="ChkBoxYN('physy','physn');">
<input name="physn" id="physn" type="checkbox" class="largerCheckbox" style="position:absolute; left:187px; top:211px;" onclick="ChkBoxYN('physn','physy');">

Multipage creation

Split multi-page PDF into PNGs
– Open with Acrobat.
– Delete other pages. Document, Delete Pages (Shift+Ctrl+D)
– Save as <filename>-Px.PNG
– Close, Don’t save changes
– Repeat for each page.

Edit images to 1500 pixels wide
– Open with Irfanview
– Image Information show info
– Select area (to crop extra borders)
– Edit, Crop selection (Ctrl+Y)
– Image, Resize/Resample, Set new size, Width = 1500, Height = 1960, Preserve aspect ratio (proportional) OFF
– Image, Decrease Color Depth, 2 Colors (black/white) (1 BPP)
– Repeat for each page.

Copy final cropped, monochrome documents into eForm Generator folder

eForm Generator
– Enter: Image Name; Click: Load Image
– should show Page 1
– Create fields on form

– Repeat for each page

As you go, click on ‘Load HTML code in new window’ and cut/paste for safe-keeping


Posted in Technical | Tagged | Comments Off on eForm programming notes

Montreal Oscar User Group – Wine & Cheese Dec 10th

Please note different time and location!

Due to the upcoming Holiday season and the difficulty of meeting during office hours, we are going to try a new time and location for the next meeting.

Date: Thursday, Dec 10th
Time: 17:00
Location: Queen Elizabeth Health Centre
Address: 2100 Marlowe, Montréal, QC H4A 3L5

The meeting will be in the conference room, accessible beside the restaurant entrance or through the Walk-In clinic. Signs will be posted.


New Online Booking for Oscar. Written by Dr. Tan Pham

new RAMQ requirements and funding. Oscar vs OscarQC.

MyOscar. The latest version is now called Kindredphr.org

Know2Act.org: The new eForm repository,

Oscar15 demo: Almost done…

Note: If you have any other topics that you want to cover, let me know.

Please RSVP. earlw@oscar-quebec.com
We will be providing refreshments.

Posted in News | Comments Off on Montreal Oscar User Group – Wine & Cheese Dec 10th

OCUS (Oscar Canada Users’ Society) Meeting at FMF 2015

OCUS will be having their Annual AGM in conjunction with the FMF in Toronto, on Friday Nov 13,2015.

In addition with the AGM, there will be some interesting demos, talks and workshops.

If you are going to the FMF, you should find a few minutes to visit the meeting:

Friday, November 13, 2015 –  10:00 to 17:30

The Intercontinental Hotel – Caledon/Oakville Room


The meeting is open to all attendees of the FMF.


Posted in News | Comments Off on OCUS (Oscar Canada Users’ Society) Meeting at FMF 2015

Oscar .deb updating

The advantage of using .deb installs is that it simplifies installation and updates.
Dr. Peter Hutton-Czapski has done an excellent job releasing new .debs on a regular basis.

Unfortunately, there can be some unexpected problems..

On an update from deb 169 to 494, I had an unexpected error when the deb could not be found.

The problem was that the dpkg version on the server was not compatible with the dpkg version used to create the .deb
ie. The server was running Ubuntu 10.04, which included an old version of dpkg ( ).

The only solution was to upgrade the server from Ubuntu 10.04 to 12.04.

Once that was done, the dpkg -i for the new deb ran properly.

The final issue was that the deb update script did not update the oscar_mcmaster database with all the schema changes.

To fix that, I ran a comparison between the existing oscar_mcmaster database and the upgraded oscar_12_1 database.

Once all the schema changes were done, Oscar ran perfectly.

Posted in Technical | Comments Off on Oscar .deb updating

Firefix update breaks Oscar access

A recent Firefox update (v 38) will block access if certain security settings are not in place.
If you try to login to Oscar and get:
Error code: ssl_error_weak_server_ephemeral_dh_key
then you need to update /etc/tomcat6/server.xml

You should add the ‘ciphers’ section.

<Connector port=”8443″ maxHttpHeaderSize=”8192″
maxThreads=”150″ minSpareThreads=”25″ maxSpareThreads=”75″
enableLookups=”false” disableUploadTimeout=”true”
acceptCount=”100″ scheme=”https” secure=”true” SSLEnabled=”true”
clientAuth=”false” keystoreFile=”/pathto.keystore” sslProtocol=”TLS”

After saving the change, just restart tomcat6.
sudo service tomcat6 restart

Posted in Technical | Comments Off on Firefix update breaks Oscar access

Ontario User Group Meeting – June 19th 2015

This is the Annual Ontario User Group meeting.

Useful sessions for everyone.

More info here

Posted in News | Comments Off on Ontario User Group Meeting – June 19th 2015

Updating DrugRef problem – solved

A client asked me to add a few new medications to their Oscar drugref database.
Sounded easy enough. There is an Admin function for that: Update DrugRef.

I checked on a more recent installation and the new medications were listed. (Neupro).

They were originally setup with v10 and are now running v12.1 build tag: Oscar12_1-3.1general169

I ran the Admin, Update Drugref, assuming that the program would download the latest Health Canada database and update the Oscar drugref database.

Unfortunately, the result was complete deletion of all data in the drugref database and zero meds.

The solution: I updated the DPDImport.class that contains the URL of the DrugRef database.

It can be found in:

I just replaced the file with a more recent version and re-ran the DrugRef update.

It seems that the location of the file has changed from:


I don’t know when the Health Canada database was moved, but if you have the same problem and your version of Oscar is from about July/August 2013, you may have the same problem.

You can confirm the problem by examining the DPDImport.class file.

The URL can be located within the file and checked. If it is pointing to the old location, then you have the same potential problem. An Admin user can do the update and erase all the medications.

More information on the Health Canada database at:

Posted in News, Technical | Comments Off on Updating DrugRef problem – solved

Automatic signing of Prescriptions

The automatic signing of Prescriptions is allowed in Quebec.  I have installed the change at a clinic and we have gotten a minor amount of push-pack from some pharmacists.

The solution was an ink stamp with the clinic name.  Unfortunately, this does not work if faxing the Rx, but is fine if the patient is taking it with them.

The modification also adds the following small print to the Rx:

Certification du prescripteur / Prescriber's certification</br>
Je certife que:  cette ordonnance est une ordonnance originale; le pharmacien pr&eacute;cit&eacute; est le seul destinaire; l'original ne sera pas r&eacute;utilis&eacute;.</br>
I certify that: this prescription is an original; the listed pharmacist is the only destination; the original will not be reused.

1) Make sure license# is entered in Provider.CPSID# field

2) Need to change the following program (make a backup first):
cd /var/lib/tomcat6/webapps/Oscar12_1/oscarRx
sudo cp Preview2.jsp Preview2-20130427.jsp
sudo nano /var/lib/tomcat6/webapps/Oscar12_1/oscarRx/Preview2.jsp

3) Create .gif file with signature.
Copy into the following folder:
sudo chown tomcat6:tomcat6 prov-*
Note: license# is the provider license number.

As soon as the Rx is saved, the signature is filled in.  The usual signature box can be used to override the signature.

Posted in Technical | Tagged | Comments Off on Automatic signing of Prescriptions