Conversions

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, P&P, QuickClaim and SoftInfo.

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:
http://www.web2generators.com/html-based-tools/online-html-entities-encoder-and-decoder

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) { 
 document.getElementById(uncheckboxid).checked=false;
 }
}
</script>
<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.

Agenda:

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”
ciphers=”TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384, TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA,TLS_ECDHE_RSA_WITH_RC4_128_SHA, TLS_RSA_WITH_AES_128_CBC_SHA256,TLS_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_256_CBC_SHA256, TLS_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_RC4_128_SHA” />

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:
/var/lib/tomcat6/webapps/drugref/WEB-INF/classes/org/drugref/ca/dpd/fetch/DPDImport.class

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:
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/txt/allfiles.zip

to:
http://www.hc-sc.gc.ca/dhp-mps/alt_formats/zip/prodpharma/databasdon/allfiles.zip

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:
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/dpd_bdpp_data_extract-eng.php

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:
/var/lib/tomcat6/webapps/Oscar12_1/images/prov-license#.gif
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

Creating new Users, logins and assigning Roles

The procedure to add new users requires 3 steps.  I have written some notes to ensure that there are no problems.

Menu: Admin, Provider

Use Search/Edit/Delete Provider Records to find a free provider number.

Note: for providers that will appear on the appointment screen, the order of appearance will be the order of their alphabetic provider code.  ( 1000, 111, 1200, 15 )

1) Add Provider
Need provider number, first name, last name

Role: Doctor or Receptionist.  If you want the provider to be able to view the patient records, then set the role to Doctor.

2) Menu: Admin, Security, Add a Login Record
need loginname, Password, PIN
eg. Student1 , Student01 , 0124

loginname: I usually use the lastname and an initial for the loginname.  This makes it much easier to find a login later, if you need to reset the password or delete the loginname.

Password: It must be a mix of Uppercase, lowercase and numbers.  I typically use something like LastF1234, where Last is part of their lastname, F is the first letter of their firstname and 1234 is their favorite 4 digit number.  I use the same 4 digit number for their PIN.

Make sure you match the login record to the correct Provider number.
Expiry Date: check and select a date about 2 yrs (or less) in the future.

3) Menu: Admin, Security, Assign Role to Provider
Select role depending on their job description, then click on ‘Add’.

 

More notes on roles coming soon…

 

Posted in Technical | Comments Off on Creating new Users, logins and assigning Roles