HL7 Exporter

From MedITEX - Wiki

Revision as of 14:35, 6 June 2014 by AlNi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.



Main window

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



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.



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: settings for the HL7. For more information, visit this link. 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 file will be saved.

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



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.



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.



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


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



On this tab, you can write Select statements.

Click on Execute to run and save.


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

Auto-complete. Press Ctrl-Space to activate this feature.


QM-Button. Right-click on the editor to open the menu.


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



The GRID tab is where the resulted Select statement will be displayed. It has many diffent viewing options:

Horizontal grid.


Vertical grid.


In the Vertical grid you can further customise the screen:

Banded Record view.
Multi Record view


You can change between patients through the navigation bar.


In order to open the Protocol editor window, you need to click on the Protocol option on the top menu .

This window is devided in two tabs: Latest protocol and List of all protocols.



The text displayed in green is the PRTINFO described in the Databinding section.



On  the Program version info you can see the current version number, send an email to MedITEX Support and open our webpage.

Back to Import and Export tools Back to top