Any one usnig Docxpresso? Yet another template Engine

juggernautsei wrote on Sunday, September 27, 2015:

Over the past week have been trying to meet the requirements of a client document requests. The biggest is that the doc needed to be viewable in the browser and be filled like the template engine that Rod built.

After much digging, found Docxpresso that is able to do the complete job using the odt file and outputing a PDF.

Working on getting a working model going then will present it for sharing.

Comments…

juggernautsei wrote on Wednesday, October 07, 2015:

Got the docxpresso working. Placed a link in the patient demographics and created a view of all template files.

The place holders are almost the same {{PatientName}} instead of {PatientName}. Now we can upload an odt file and get a PDF out so they can sign it on the tablets and upload it to the patient records.
Kept all the same placeholders that Rod developed also.

teryhill wrote on Wednesday, October 07, 2015:

What am I doing wrong. Getting this error:

Are you sure CBRS_and_CM_TXPlan_and_Review_v1.odt is the required file. If so,
ERROR: query failed: SELECT field_value FROM lbf_data WHERE form_id =

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1

C:\wampclient\www\ui-demo\interface\forms\custom_odt\template_fill.php at 157:sqlStatement

Terry

juggernautsei wrote on Thursday, October 08, 2015:

You did not do anything wrong. I fixed the bug but in order to test the system. There was a blank field that was causing the SQL error.

Please use Donald Duck as the patient and encounter on 8/20. It has all the information in it to properly fill the documents.

Thanks for taking a look.

arnabnaha wrote on Thursday, October 08, 2015:

Wonderful…Loved the demo…would love to have it into openemr. Great work indeed…

tmccormi wrote on Thursday, October 08, 2015:

I guess I’m dense. I don’t see anyhing in the demo … Did I miss some previous discussion on how you create the template doc, and use it, I don’t see any examples of anything in the Donald Duck pt record. I’m interested but confused

arnabnaha wrote on Friday, October 09, 2015:

Hi Tony,

  1. Demo link: - https://omp.openmedpractice.com/ui-demo/interface/login/login_frame.php?site=default

  2. Login with the provided username and password on the login screen

  3. select the patient “DONALD DUCK”

  4. Click on “Templates” on the patient summary screen

5 It will ask for an encounter selection. Select the encounter from the encounter selection dropdown in the header

  1. You will find that the template list is populated with name of documents along with radio buttons.

  2. Need to select one of then and a “Download” link will appear. Click on that, it will prepare a pdf file with prepopulated data.

Thanks and regards,

Arnab

arnabnaha wrote on Friday, October 09, 2015:

Hello Sherwin,

My question regarding this wonderful feature is - can I create a single page patient summary with this?

The things that need to be there in the document is -

  1. Name of Patient
  2. ID
  3. DOB
  4. Phone
  5. Date of Visit
  6. Chief complaint/Reason for visit
  7. Small HPI
  8. Vitals
  9. significant examination findings
  10. Any investigation ordered - just the names of the investigation will do
  11. diagnosis
  12. medications given - just names (as patient will get a separate prescription)
  13. Next date of visit

Thanks,
Arnab

juggernautsei wrote on Saturday, October 10, 2015:

Actually it can.
It is built around the premise that Rod started.

Look at the attached file. It shows all the place holders and you can place
them any where in the document you want data to show.
These are all of the place holders that have been created so far.

If the information is in there, it can be placed in the document.

The biggest draw to this is that it cranks out a PDF that can be
electronically signed with a tablet or the like.

I will be working a releasing the code and instruction soon.

arnabnaha wrote on Sunday, October 11, 2015:

Thanks Sherwin,

I will take a look at the file…currently travelling and .odt is not opening on my phone.

It would be great if u release the code and instruction and we can test it out.

Thanks

arnabnaha wrote on Sunday, October 11, 2015:

Hi sherwin,

Saw the placeholders that are going to be added to the feature. Its my kind request to consider adding the vitals, medicine dosage, medicine duration and next appointment date if possible.

For the diagnosis part, it can be pulled from the problem placeholder which you are planning to add.

For HPI and or other form specific info, will it be possible to fetch data from lbf forms. If yes, it will be the greatest addition ever and cause preparation of single page beautiful patient summary which can be handed over ti patients very very easy.

Will be looking forward to test these features.

Thanks for everything

tmccormi wrote on Monday, October 12, 2015:

Perfect, I missed the “templates” link, Thanks!

tmccormi wrote on Monday, October 12, 2015:

Sherwin,
This is great. Do you have a branch post yet. I could use this feature right now.

teryhill wrote on Monday, October 12, 2015:

Geeze you are awfully needy lately.

Terry

arnabnaha wrote on Wednesday, December 02, 2015:

Any update on this Sherwin???

juggernautsei wrote on Tuesday, December 15, 2015:

It is late night and needing something to keep me awake. I will crank this into a github post by the end of the week.

juggernautsei wrote on Tuesday, December 15, 2015:

Here is the patch

arnabnaha wrote on Tuesday, December 15, 2015:

Hi Sherwin,
Thank you so much for the patch. I tested it on my test environment but after selecting the encounter and document from the list (From Template section of the patient summary screen) it says - Call front desk to have patient checked in.no encounter found for patient.

Please help with this.

Thanks and regards,
Arnab

juggernautsei wrote on Saturday, December 19, 2015:

The way the code is written you have to be in an encounter. The forms are named according to the encounter. So, select an encounter first then you can select a form.

The mod is working per design.

arnabnaha wrote on Saturday, December 19, 2015:

  1. Selected a patient after logging into the EMR.
  2. selected an encounter from the drop down list on the top
  3. came back to patient summary screen and clicked “Templates”
  4. It shows thae encounter number which is selected and the document with a radio button
  5. Selected the radio button and clicked fetch
  6. shows this - Call front desk to have patient checked in.no encounter found for patient.