View source for HL7 Exporter

<p><strong>MedITEX HL7 Exporter</strong> helps you on exporting data from your datebase. This page is intended to help you with configuration and usability of this tool.</p>
<p>&nbsp;</p>
<h2>Main window</h2>
<p>This is <strong>HL7 Exporter</strong> main window. Here you can see all patients currently in your database, view protocols and export data.</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter1.png" alt="" width="600" height="394" /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h2>Configuration</h2>
<p>Clicking on <strong>Configuration</strong> at the top of the window, the following window will open:</p>
<p>This window is separated into four tabs: <strong>Settings</strong>, <strong>HL7/Export</strong>, <strong>Databiding</strong> and <strong>MSH</strong>.</p>
<p>&nbsp;</p>
<h3>Settings</h3>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter2.png" alt="" /></td>
</tr>
<tr>
<td>
<p><strong>Centre</strong>: name of your clinic.</p>
<p><strong>Centre code</strong>: identification number given to your clinic.</p>
<p><strong>HL7 messages</strong>: choose if the exported data will be saved on this computer or sent via TCP-IP.</p>
<p><strong>SQL Statement for data collection</strong>: editor to create the <strong>Select</strong> statement which will be linked to the <strong>HL7</strong> message creator. The SQL statement <strong>must</strong> export parameter&nbsp;<strong>PKEY</strong> and can &ndash; in addition &ndash; export&nbsp;<strong>PKEY2</strong> if nescessary. You can delete the</p>
<p><strong>Automatic JL7 export</strong>: activate this option to automatically export data. After any <strong>insert</strong>, <strong>update</strong> or <strong>delete</strong> of patient information, <strong>HL7 Exporter</strong> will automatically generate the data file. Turn-off this option by clicking on the <strong>Deactivate </strong>button.</p>
<p><strong>UDF</strong>: necessary for the automatic export. Contact support for the latest "dll" file.</p>
<p><strong>Password</strong>: in order to open this configuration window, you need to enter this password. To change it, click on the <strong>Edit </strong>button (paper/pencil).<strong><br /></strong></p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h3>HL7/Export</h3>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter3.png" alt="" width="538" height="428" /></td>
</tr>
<tr>
<td>
<p><strong>HL7</strong>: 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 <strong>Segment separation with CRLF</strong> in order to have the messages idented, otherwise it will be displayed in one line.</p>
<p><strong>Export file</strong>: path where the exported will be saved.</p>
<p><strong>IP address</strong>, <strong>Port</strong>: IP address and port for sending the file via TCP-IP. <strong><br /></strong></p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h3>Databiding</h3>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter4.png" alt="" /></td>
</tr>
<tr>
<td>
<p>Each row represents a selected field from the SQL statement, including <strong>PRTINFO</strong> (click here for more information).</p>
<p><strong>Double-click</strong> a row and enter the wanted HL7 message section where the current field value should be placed. Use a <strong>dash</strong> (<strong>-</strong>) instead of dots to define the HL7 position, for example: <strong>PID-4-1</strong>.</p>
<p>Click on <strong>find possible ADT structures</strong> to get a list of structure names that fit the list of your export segments and positions.</p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h3>MSH</h3>
<p>The purpose of this tab is to make sure that the selected message types and structures result in a well formatted <strong>HL7</strong> message.</p>
<p>Click on <strong>Create HL7 message</strong> 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 <strong>HL7</strong> client.</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter7.png" alt="" /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h2>Edit</h2>
<p>In order to open the <strong>Edit - Tables - Views - Triggers - Procedures</strong> window, you need to click on the the the button <strong>Create/Edit</strong> at the <strong>Configuration</strong> window.</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img src="/images/CreateEdit.png" alt="" width="108" height="23" /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>This is the editor for the <strong>Select</strong> statement. Two tabs are displayed: <strong>Editor </strong>and <strong>GRID</strong>.</p>
<p>&nbsp;</p>
<h4>Editor</h4>
<p>On this tab, you can write <strong>Select</strong> statements.</p>
<p>Click on <strong>Execute</strong> to run and save.</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter11.png" alt="" width="695" height="563" /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>This <strong>Editor</strong> is enhanced with a sintax highlighter in order to make editing easier. In addition, it contains the following features:</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><strong>Auto-complete</strong>. Press <strong>Ctrl-Space</strong> to activate this feature.</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="http://wiki.meditex-software.com/images/HL7Exporter17.png" alt="" width="695" height="563" /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><strong>QM-Button</strong>. <strong>Right-click</strong> on the editor to open the menu.</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="http://wiki.meditex-software.com/images/HL7Exporter18.png" alt="" width="695" height="563" /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<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: #339966;"><span style="color: #000000;"> sintax to activate this feature.</span></span></p>
</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter16.png" alt="" width="695" height="563" /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h4>GRID</h4>
<p>&nbsp;</p>
<h2>Protocol</h2>
<p>&nbsp;</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td><br /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>[[Image:HL7Exporter8.png|none|500px|thumb|left|link=http://wiki.meditex-software.com/images/HL7Exporter8.png|]]</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>[[Image:HL7Exporter9.png|none|500px|thumb|left|link=http://wiki.meditex-software.com/images/HL7Exporter9.png|]]</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter10.png" alt="" width="402" height="449" /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><br /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter12.png" alt="" width="695" height="563" /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter13.png" alt="" width="695" height="563" /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter14.png" alt="" width="695" height="563" /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/HL7Exporter15.png" alt="" width="695" height="563" /></td>
<td>&nbsp;</td>
</tr>
</tbody>
</table>