HL7 Exporter

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 128: Line 128:
 
<tr>
 
<tr>
 
<td>
 
<td>
<p><strong>Navigation</strong>. You can navigate between procedures, tables and triggers within the editor. <strong>Double-click</strong> a <span style="text-decoration: underline; color: #339966;">green underlined</span><span style="color: #333333;"> sintax to activate this feature.</span></p>
+
<p><strong>Navigation</strong>. You can navigate between procedures, tables and triggers within the editor. <strong>Double-click</strong> a <span style="text-decoration: underline; color: #339966;">green underlined</span><span style="color: #333333;"> </span>sintax to activate this feature.<span style="color: #333333;"></span></p>
 
</td>
 
</td>
 
</tr>
 
</tr>

Revision as of 12:28, 16 May 2013

MedITEX HL7 Exporter helps you on exporting data from your datebase. This page is intended to help you with configuration and usability of this tool.

 

Contents

Main window

This is HL7 Exporter main window. Here you can see all patients currently in your database, view protocols and export data.

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter1.png" alt="" width="600" height="394" />

 

Configuration

Clicking on Configuration at the top of the window, the following window will open:

This window is separated into four tabs: Settings, HL7/Export, Databiding and MSH.

 

Settings

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter2.png" alt="" />

Centre: name of your clinic.

Centre code: identification number given to your clinic.

HL7 messages: choose if the exported data will be saved on this computer or sent via TCP-IP.

SQL Statement for data collection: editor to create the Select statement which will be linked to the HL7 message creator. The SQL statement must export parameter PKEY and can – in addition – export PKEY2 if nescessary. You can delete the

Automatic JL7 export: activate this option to automatically export data. After any insert, update or delete of patient information, HL7 Exporter will automatically generate the data file. Turn-off this option by clicking on the Deactivate button.

UDF: necessary for the automatic export. Contact support for the latest "dll" file.

Password: in order to open this configuration window, you need to enter this password. To change it, click on the Edit button (paper/pencil).

 

HL7/Export

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter3.png" alt="" width="538" height="428" />

HL7: settings for the HL7. For more information, visit <a href="http://www.hl7.org/documentcenter/public/wg/conf/Msgadt.pdf">this link</a>. Check the option Segment separation with CRLF in order to have the messages idented, otherwise it will be displayed in one line.

Export file: path where the exported will be saved.

IP address, Port: IP address and port for sending the file via TCP-IP.

 

Databiding

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter4.png" alt="" />

Each row represents a selected field from the SQL statement, including PRTINFO (click here for more information).

Double-click a row and enter the wanted HL7 message section where the current field value should be placed. Use a dash (-) instead of dots to define the HL7 position, for example: PID-4-1.

Click on find possible ADT structures to get a list of structure names that fit the list of your export segments and positions.

 

MSH

The purpose of this tab is to make sure that the selected message types and structures result in a well formatted HL7 message.

Click on Create HL7 message to create a randomized message (insert/update/delete) with a randomly selected patient from your database. In order to test this message, copy it to your HL7 client.

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter7.png" alt="" />

 

Edit

In order to open the Edit - Tables - Views - Triggers - Procedures window, you need to click on the the the button Create/Edit at the Configuration window.

<tbody> </tbody>
<img src="/images/CreateEdit.png" alt="" width="108" height="23" />

 

This is the editor for the Select statement. Two tabs are displayed: Editor and GRID.

 

Editor

On this tab, you can write Select statements.

Click on Execute to run and save.

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter11.png" alt="" width="695" height="563" />

 

This Editor is enhanced with a sintax highlighter in order to make editing easier. In addition, it contains the following features:

<tbody> </tbody>
Auto-complete. Press Ctrl-Space to activate this feature.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter17.png" alt="" width="695" height="563" />

 

<tbody> </tbody>
QM-Button. Right-click on the editor to open the menu.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter18.png" alt="" width="695" height="563" />

 

<tbody> </tbody>

Navigation. You can navigate between procedures, tables and triggers within the editor. Double-click a green underlined sintax to activate this feature.

<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter16.png" alt="" width="695" height="563" />

 

GRID

 

Protocol

 

<tbody> </tbody>

 
HL7Exporter8.png
 
HL7Exporter9.png
 
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter10.png" alt="" width="402" height="449" />  

 
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter12.png" alt="" width="695" height="563" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter13.png" alt="" width="695" height="563" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter14.png" alt="" width="695" height="563" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter15.png" alt="" width="695" height="563" />