Skip to content

AuditFormsExport

Audit Forms Export

purpose of this module

To provide exporting feature for the Query templates to corresponding query done by CDS or Automatic Query alert. the templates will provide by clients in various formates like Editable Pdf, docx, text. our responsibility is to fill those templates with data and provide a chance to export into there location.

Static PDF

We are getting templates in pdf's with editable format.

Tool: Adobe Acrobat Professional (Licensed but free version avaliable for 30-45 days)

Disadvantates:

  1. We can't make richtext like bold for some data dynamically.
  2. We are unable to increase the text area size dynamically base on the data.

Document

  1. We are getting templates in Word document format.

Dynamic pdf

we are only responsible to desing these pdf's using the following tool

Tool: Adobe livecycle designer (Licensed but free version avaliable for 60 days)

Advantages:

  1. We can insert data into any format.
  2. Dymanically text area size will be increased

Disadvantages

It doesn't automatically open in chrome pdf plugin, we need to disable that using chrome://plugins/

Open Office

We are the responsible to create document in the form of Open Office (ODT).

TABLES

Medcentinela

  • ExportedEncphDocuments

MedmineMaster

  • SepsisRanges
  • ComplianceAuditExportParameters

STORED PROCEDURES

  • GetEncphDataToExport

JSP / JS

  • IcdIssueTracking/AuditDocInfo.jsp

JAVA

  • biz.codeextract.documentsummary.servlet.DocEncephalopathy
  • biz.codeextract.documentsummary.servlet.PdfEncephalopathy
  • biz.kpai.complianceaudit.pdf.AcuteRespiratoryFailure
  • biz.kpai.complianceaudit.pdf.ComplianceAuditPdfCreator
  • biz.kpai.complianceaudit.pdf.ElectrolyteAbnormality
  • biz.kpai.complianceaudit.pdf.OldTemplateExport
  • biz.kpai.diagnosiscriteria.dao.DiagnosisCriteriaDao
  • biz.codeextract.documentsummary.service.PatientVisitDetailsService
  • biz.codeextract.documentsummary.service.PatientVisitDetailsDao

Phase I: Designing templates

PDF

If it is new template then follow these steps:

Step1:

To find the Field Names

Step1.1:

To find Pdf fields name use the following query

Eg: select distinct pdfParameters from MedmineMaster.dbo.ComplianceAuditExportParameters

Step 1.2:

Open pdf with Adobe Acrobat Professional in edit text fields format

Step 1.3:

  • If you find any pdfParameter is suitable for corresponding text filed then rename that text filed with pdfparameter name.
  • If it is new text filed then follow below steps
  • Insert all generalparameters,pdfparameters and docparameters into MedmineMaster.dbo.ComplianceAuditExportParameters

Eg:insert into ComplianceAuditExportParameters(documentId,generalParameters,pdfParameters,docParameters,DocPdfName,username)values (1,'standard1','Text1','$standard1','ACUTE-HEART-FAILURE','vinaym')

Document

If it is new template then follow these steps:

Step 1:

Word document must be in docx format only. If it is not in that format then open the document and click on file >save as> Word document(docx).

Step 2:

Make sure all alignments are proper format or not

Step 3:

For docx i was used velocity framework (mergefileds concept) so that i was followed some steps to give filed names

Step 3.1:

Place cursor for which filed you want to give name and press Ctrl+F9 it will give curling braces {}.

Step 3.2:

Place cursor in between the curling braces and right click > Edit field > Field pop up will be opend.

Step 3.3:

In Field Names select MergeField (after pop up open just click m in 2 times), automatically right side Field properties will be opend.

Step 3.4:

In that Field properties section Field Name field give filed name(docParameters in ExportDocumentParameters table) what you wnat with prefix $.

Eg: $standard1

Step 3.5:

Press OK, in document it will show like this «$standard1» (This filed is called merge field).

Step 4:

Repeat 3 step for all fields to give filed names.

Step 5:

To insert barcode we need place sample image and bookmark that image

Step 5.1:

In Word document click on insert menu and select picture (Image location)

Step 5.2:

Select that image and click on insert menu choose Bookmark, give name as logo and click on add.

Open Office

If it is new template then follow these steps:

Step 1:

Open document with Open Office click on file >save as> Open Office(odt)..

Step 2:

Make sure all alignments are proper format or not

Step 3:

For odt also used velocity framework (mergefileds concept) so that i was followed some steps to give filed names

Step 3.1:

Plase cursor for which filed you want to give name and press Ctrl+F2 it will open a Fields dialog box.

Step 3.2:

Select Functions Input filed click > Insert It will open Input Field dialog box.

Step 3.4:

In second text area give filed name(docParameters in ExportDocumentParameters table) what you want with prefix $.

Eg: $faxno

Step 3.5:

Press OK, next close in document it will show like this $faxno (This filed is called merge field).

Step 4:

Repeat 3 step for all fields to give filed names.

Step 5:

To insert barcode we need to place sample image and bookmark that image.

Step 5.1:

In odt document click on insert menu and select picture > From file (Image location)

Step 5.2:

Select that image and right click on image > Picture > Options> Name: logo > OK.

PDF

Document & Open Office