HL7 Importer

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
 
(24 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<p>&nbsp;</p>
 
 
<h2>Scheme</h2>
 
<h2>Scheme</h2>
 
<table border="0">
 
<table border="0">
Line 22: Line 21:
 
<p>PMI_HL7 active</p>
 
<p>PMI_HL7 active</p>
 
</td>
 
</td>
−
<td>Indicates whether your IVF tool is preconfigured for the import of additional patients data and therefore provides a special interface.</td>
+
<td style="text-align: justify;">Indicates whether your IVF tool is preconfigured for the import of additional patients data and therefore provides a special interface.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Protocol Level</td>
 
<td>Protocol Level</td>
 
<td>
 
<td>
−
<p>Default setting is 'Errors, Hints and Debug Information'.</p>
+
<p style="text-align: justify;">Default setting is 'Errors, Hints and Debug Information'.</p>
 
After the testing phase please switch to <strong>'Only Errors</strong>' in order to reduce traffic and data storage.</td>
 
After the testing phase please switch to <strong>'Only Errors</strong>' in order to reduce traffic and data storage.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>IP-Address</td>
 
<td>IP-Address</td>
−
<td>The IP address of the server where Importer is running. <br /> Default is 'localhost' (or 127.0.0.1)</td>
+
<td style="text-align: justify;">The IP address of the server where Importer is running. <br /> Default is 'localhost' (or 127.0.0.1).</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Number of Instances</td>
 
<td>Number of Instances</td>
−
<td>Defines the number of asynchronous communication queues (threads). Default is 1.</td>
+
<td style="text-align: justify;">
 +
<p>Defines the number of asynchronous communication queues (threads).</p>
 +
<p>Default is 1.</p>
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Number of Interfaces</td>
 
<td>Number of Interfaces</td>
 
<td>
 
<td>
−
<p>Defines the number of protocols that can be interpreted.</p>
+
<p style="text-align: justify;">Defines the number of protocols that can be interpreted.</p>
−
Default is 1 (HL7)</td>
+
Default is 1 (HL7).</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Listen queue (max)</td>
 
<td>Listen queue (max)</td>
−
<td>The maximum of entries in the listener buffer (FIFO buffer).</td>
+
<td style="text-align: justify;">The maximum of entries in the listener buffer (FIFO buffer).</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Terminate wait time</td>
 
<td>Terminate wait time</td>
−
<td>Defines the maximum delay in milliseconds to receive messages from the queue. Default is 10000 msec.</td>
+
<td style="text-align: justify;">
 +
<p>Defines the maximum delay in milliseconds to receive messages from the queue.</p>
 +
<p>Default is 10000 msec.</p>
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Thread delay</td>
 
<td>Thread delay</td>
−
<td>Defines the delay in milliseconds to give work time for other treads. Default is 100 msec.</td>
+
<td style="text-align: justify;">
 +
<p>Defines the delay in milliseconds to give work time for other treads.</p>
 +
<p>Default is 100 msec.</p>
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Reply ACK delay</td>
 
<td>Reply ACK delay</td>
 
<td>
 
<td>
−
<p>Defines the delay in milliseconds to finish a processed message.</p>
+
<p style="text-align: justify;">Defines the delay in milliseconds to finish a processed message.</p>
 
Default is 250 msec.</td>
 
Default is 250 msec.</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 85: Line 92:
 
<td rowspan="3">Instances</td>
 
<td rowspan="3">Instances</td>
 
<td>Instance Nr.</td>
 
<td>Instance Nr.</td>
−
<td>Automatic counter</td>
+
<td style="text-align: justify;">Automatic counter</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Active</td>
 
<td>Active</td>
−
<td>Yes or No</td>
+
<td style="text-align: justify;">Yes or No</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Port</td>
 
<td>Port</td>
−
<td>The client - server communications port</td>
+
<td style="text-align: justify;">The client - server communications port</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td rowspan="5">Interfaces</td>
 
<td rowspan="5">Interfaces</td>
 
<td>Interface Nr.</td>
 
<td>Interface Nr.</td>
−
<td>Automatic counter</td>
+
<td style="text-align: justify;">Automatic counter</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Active</td>
 
<td>Active</td>
−
<td>Yes or No</td>
+
<td style="text-align: justify;">Yes or No</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Protocol</td>
 
<td>Protocol</td>
−
<td>Active protocol (In this version only HL7. In future versions also XML and SOAP)</td>
+
<td style="text-align: justify;">Active protocol (In this version only HL7. In future versions also XML and SOAP)</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Version</td>
 
<td>Version</td>
−
<td>Active version</td>
+
<td style="text-align: justify;">Active version</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Libary</td>
 
<td>Libary</td>
−
<td>The name of the DLL which coummunicates with the database (Database-IN module)</td>
+
<td style="text-align: justify;">The name of the DLL which coummunicates with the database (Database-IN module)</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 143: Line 149:
 
<td>Save Level</td>
 
<td>Save Level</td>
 
<td>
 
<td>
−
<p>Each processed message can be saved with more or less information.&nbsp; &nbsp;Default is &ldquo;Errors, Hints and Debug Information&rdquo;.</p>
+
<p style="text-align: justify;">Each processed message can be saved with more or less information.&nbsp; &nbsp;Default is 'Errors, Hints and Debug Information'.</p>
−
<p>After the testing phase switch to &ldquo;<strong>Only Errors</strong>&rdquo;.</p>
+
<p style="text-align: justify;">After the testing phase switch to <strong>'Only Errors'</strong>.</p>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Save info for statistics</td>
 
<td>Save info for statistics</td>
−
<td>An additional feature to gain statistical information of the processed messages.</td>
+
<td style="text-align: justify;">An additional feature to gain statistical information of the processed messages.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Automatically load protocol file</td>
 
<td>Automatically load protocol file</td>
−
<td>An additional feature to display then message processing in the user interface of MexHL7Importer. The output will be according to the selection in section &ldquo;Save Level&rdquo;.</td>
+
<td style="text-align: justify;">An additional feature to display then message processing in the user interface of MexHL7Importer. The output will be according to the selection in section 'Save Level'.</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 176: Line 181:
 
<tr>
 
<tr>
 
<td>Minimum Length of Patient Identifier</td>
 
<td>Minimum Length of Patient Identifier</td>
−
<td>High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the length of the patient&rsquo;s identifier is less than defined, an insert or update will be refused.</td>
+
<td style="text-align: justify;">High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the length of the patient&rsquo;s identifier is less than defined, an insert or update will be refused.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
−
<td>Age Range (min / max)</td>
+
<td>
−
<td>High level check whether the current age in within the defined range.</td>
+
<p>Age Range (min/max)</p>
 +
</td>
 +
<td style="text-align: justify;">High level check whether the current age in within the defined range.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Minimum Set of Fields</td>
 
<td>Minimum Set of Fields</td>
−
<td>High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the incoming data has no values in the defined fields, an insert or update will be refused.</td>
+
<td style="text-align: justify;">High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the incoming data has no values in the defined fields, an insert or update will be refused.</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 207: Line 213:
 
<tr>
 
<tr>
 
<td>Use first available Patient ID</td>
 
<td>Use first available Patient ID</td>
−
<td>A HL7 message can provide more than one possible Patient ID because the same message can trigger several target systems wherein a Patient ought to be matched via it&rsquo;s ID.</td>
+
<td style="text-align: justify;">A HL7 message can provide more than one possible Patient ID because the same message can trigger several target systems wherein a Patient ought to be matched via it&rsquo;s ID.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Use Patient ID associated with IdentifierTypeCode</td>
 
<td>Use Patient ID associated with IdentifierTypeCode</td>
−
<td>If provided more than one Patient ID, each of them should be followed by a so called &ldquo;Identifier Code&rdquo;-&nbsp; which is nothing else than a second match code to decide which of the given Patient IDs is the right one for your system.</td>
+
<td style="text-align: justify;">If provided more than one Patient ID, each of them should be followed by a so called 'Identifier Code'-&nbsp; which is nothing else than a second match code to decide which of the given Patient IDs is the right one for your system.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Save Parameters as &ldquo;Something else&rdquo; if they can not be matched</td>
 
<td>Save Parameters as &ldquo;Something else&rdquo; if they can not be matched</td>
 
<td>
 
<td>
−
<p>Laboratory parameters are divided into several parameter groups:</p>
+
<p style="text-align: justify;">Laboratory parameters are divided into several parameter groups:</p>
−
<p>Hormone, Serology, Clinical chemistry, Genetics, Microbiology or &ldquo;<strong>Something else</strong>&rdquo;. A laboratory parameter consists of a so called <strong>short form</strong>, a <strong>long from</strong>, a <strong>unit</strong> and a <strong>value</strong>. The short form must be transmitted within the HL7 message and defined in the target system &hellip; this is the way parameters are matched. If this matching fails the parameter can be imported as &ldquo;Something else&rdquo; - what in each case demands a following manual correction.</p>
+
<p style="text-align: justify;">Hormone, Serology, Clinical chemistry, Genetics, Microbiology or <strong>'Something else</strong>'. A laboratory parameter consists of a so called <strong>short form</strong>, a <strong>long from</strong>, a <strong>unit</strong> and a <strong>value</strong>. The short form must be transmitted within the HL7 message and defined in the target system &hellip; this is the way parameters are matched. If this matching fails the parameter can be imported as &ldquo;Something else&rdquo; - what in each case demands a following manual correction.</p>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Import Notes from NTE Structure</td>
 
<td>Import Notes from NTE Structure</td>
−
<td>Additional information from the examining laboratory &ndash; as a non-formatted text - can be imported in memo fields of the target system.</td>
+
<td style="text-align: justify;">Additional information from the examining laboratory &ndash; as a non-formatted text - can be imported in memo fields of the target system.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Abnormal Flags</td>
 
<td>Abnormal Flags</td>
−
<td>Defines whether a given parameter value is inside a normal range or outside. These flags can be used to change flags in the target system.</td>
+
<td style="text-align: justify;">Defines whether a given parameter value is inside a normal range or outside. These flags can be used to change flags in the target system.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Date Format</td>
 
<td>Date Format</td>
 
<td>
 
<td>
−
<p>Describes the textual form of date and time information</p>
+
<p style="text-align: justify;">Describes the textual form of date and time information:</p>
−
<p>YYYY (year) MM (month) DD (day) HH (hour) NN (minute) SS (second)</p>
+
<p style="text-align: justify;">YYYY (year) MM (month) DD (day) HH (hour) NN (minute) SS (second).</p>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 257: Line 262:
 
<tr>
 
<tr>
 
<td>Alias</td>
 
<td>Alias</td>
−
<td>The database alias. Default is ART.</td>
+
<td style="text-align: justify;">The database alias. Default is ART.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Server</td>
 
<td>Server</td>
−
<td>
+
<td style="text-align: justify;">
 
<p>The server address on which the Firebird server runs.</p>
 
<p>The server address on which the Firebird server runs.</p>
 
<p>Default is 'localhost'&nbsp; (or 127.0.0.1).</p>
 
<p>Default is 'localhost'&nbsp; (or 127.0.0.1).</p>
Line 269: Line 274:
 
<td>Charset</td>
 
<td>Charset</td>
 
<td>
 
<td>
−
<p>The character set according to your language.</p>
+
<p style="text-align: justify;">The character set according to your language.</p>
−
<p>Ask your support for additional help.</p>
+
<p style="text-align: justify;">Ask your support for additional help.</p>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 276: Line 281:
 
<td>Client Library</td>
 
<td>Client Library</td>
 
<td>
 
<td>
−
<p>The name of the Firebird client library.</p>
+
<p style="text-align: justify;">The name of the Firebird client library.</p>
−
<p>Default is fbClient.dll (older versions use gds32.dll).</p>
+
<p style="text-align: justify;">Default is fbClient.dll (older versions use gds32.dll).</p>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Backup Start</td>
 
<td>Backup Start</td>
−
<td>If a backup task is defined type in the start time. This leads to a smarter and faster check whether database changings can be processed.</td>
+
<td style="text-align: justify;">If a backup task is defined type in the start time. This leads to a smarter and faster check whether database changings can be processed.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Backup End</td>
 
<td>Backup End</td>
−
<td>See description for point above.</td>
+
<td style="text-align: justify;">See description for point above.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Force restart</td>
 
<td>Force restart</td>
−
<td>During the processing of HL7 messages the memory usage of the HL7-Server increases continuously &hellip; not much, but it does. Therefore the time when backup is running can be used for a save restart of the HL7-Server.</td>
+
<td style="text-align: justify;">During the processing of HL7 messages the memory usage of the HL7-Server increases continuously &hellip; not much, but it does. Therefore the time when backup is running can be used for a save restart of the HL7-Server.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>DB Access</td>
 
<td>DB Access</td>
 
<td>
 
<td>
−
<p>Strongly recommended:</p>
+
<p style="text-align: justify;">Strongly recommended:</p>
−
<p>No access to database if backup is running should be checked!</p>
+
<p style="text-align: justify;">No access to database if backup is running should be checked!</p>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 321: Line 325:
 
<tr>
 
<tr>
 
<td>Install service</td>
 
<td>Install service</td>
−
<td>Requires <strong>MexHL7Service.exe</strong> and provides a so called background service, with full functionality, no interface, no login necessary. If successfully installed you can see a new entry in your service panel: <strong>MexHL7 Service.</strong></td>
+
<td style="text-align: justify;">Requires <strong>MexHL7Service.exe</strong> and provides a so called background service, with full functionality, no interface, no login necessary. If successfully installed you can see a new entry in your service panel: <strong>MexHL7 Service.</strong></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Uninstall service</td>
 
<td>Uninstall service</td>
−
<td>Uninstalls the MexHL7 Service.</td>
+
<td style="text-align: justify;">Uninstalls the MexHL7 Service.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Start service</td>
 
<td>Start service</td>
−
<td>Starts the MexHL7 Service.</td>
+
<td style="text-align: justify;">Starts the MexHL7 Service.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Stop service</td>
 
<td>Stop service</td>
−
<td>Stops the MexHL7 Service.</td>
+
<td style="text-align: justify;">Stops the MexHL7 Service.</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Automatically Interface in notification area</td>
 
<td>Automatically Interface in notification area</td>
 
<td>
 
<td>
−
<p>Provides an icon in the taskbar that indicates that the service is running and provides a GUI for configuration and statistics. This won&rsquo;t work with the new Microsoft UAC technology &hellip; older operating systems like Windows XP support this feature.</p>
+
<p style="text-align: justify;">Provides an icon in the taskbar that indicates that the service is running and provides a GUI for configuration and statistics. This won&rsquo;t work with the new Microsoft UAC technology &hellip; older operating systems like Windows XP support this feature.</p>
−
<p><strong><em>Try it and if you don&rsquo;t see the MexHL7 Icon please uncheck this feature.</em></strong></p>
+
<p style="text-align: justify;"><strong><em>Try it and if you don&rsquo;t see the MexHL7 Icon please uncheck this feature.</em></strong></p>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 355: Line 358:
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<h3>Support</h3>
 
<h3>Support</h3>
−
<p>You can send protocol, statistic and log files to your support.<strong> Fill this formular in order to provide a smart email generator. </strong></p>
+
<p style="text-align: justify;">You can send protocol, statistic and log files to your support.<strong> Fill this formular in order to provide a smart email generator. </strong></p>
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 364: Line 367:
 
<tr>
 
<tr>
 
<td>Your Name</td>
 
<td>Your Name</td>
−
<td>Type in any name you want to describe your clinic</td>
+
<td style="text-align: justify;">Type in any name you want to describe your clinic</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Your Email</td>
 
<td>Your Email</td>
−
<td>Your email addree</td>
+
<td style="text-align: justify;">Your email address</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>Email Body</td>
 
<td>Email Body</td>
−
<td>Any email body</td>
+
<td style="text-align: justify;">Any email body</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 382: Line 385:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 391: Line 393:
 
</table>
 
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 +
<p>&nbsp;</p>
 +
<h2>Application</h2>
 +
<p style="text-align: justify;">Description of the MedITEX HL7 Importer Application GUI.</p>
 +
<p style="text-align: justify;">To run the MexHL7Importer &ndash; after the configuration has been done &ndash; it is only necessary to click the '<strong>Start Server</strong>' button. The screenshot bellow shows activity and data protocolling. Content depends on what has been defined in the configuration section.</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td style="text-align: center;"><img src="/images/0GUI.png" alt="" width="765" height="990" /></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<p style="text-align: justify;">Each pair of data (HL7 message &amp; transformation into importable data) is &ndash; if configured &ndash; saved in a protocol file which has been named with a tamestamp. In this file you have the possibility to check when and which HL7 message data caused which import or change of MedITEX IVF data.</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td style="text-align: center;"><img src="/images/01GUI.png" alt="" width="765" height="993" /></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<p style="text-align: justify;">Statistical data &ndash; if configured &ndash; is automatically saved and compiled in order to provide a brief overview and a detailed table (as you can see below). For example:</p>
 +
<p style="text-align: justify;">Since the server was started, a total of 1373 HL7 messages were received, out of which a total of 37 errors occurred and finally 6 modifications of MedITEX IVF data have eventually been made.</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td style="text-align: center;"><img src="/images/02GUI.png" alt="" width="765" height="530" /></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td><strong>Item</strong></td>
 +
<td><strong>Description</strong></td>
 +
</tr>
 +
<tr>
 +
<td>DLL Errors</td>
 +
<td style="text-align: justify;">Occur if any low level communication fails (tcpIP,&nbsp; ports , sockets, &hellip;).</td>
 +
</tr>
 +
<tr>
 +
<td>Data Errors</td>
 +
<td style="text-align: justify;">Occur if the consistency check of incoming data discovers missing information (a data field with no value) or invalid information (letters where only numbers were expected or violations of minimum or maximum definitions).</td>
 +
</tr>
 +
<tr>
 +
<td>Updates</td>
 +
<td style="text-align: justify;">Updates are only triggered if the associated patient already exists in the MedITEX IVF patient table.</td>
 +
</tr>
 +
<tr>
 +
<td>Edits</td>
 +
<td style="text-align: justify;">Edits are triggered if the associated patient exists in the MedITEX IVF buffer table.</td>
 +
</tr>
 +
<tr>
 +
<td>Inserts</td>
 +
<td style="text-align: justify;">Inserts into the so called buffer table are processed if the associated patient could not be found in both tables (patient table and buffer table).</td>
 +
</tr>
 +
<tr>
 +
<td>Modifies</td>
 +
<td style="text-align: justify;">Whether triggered 'Updates' or 'Edits' are finally processed is decided dependent of the data field values. If no modifications of data are found no change of the database is performed.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td style="text-align: center;"><img src="/images/03GUI.png" alt="" width="765" height="990" /></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<h2>Message Types</h2>
 +
<p>The messages below are examples supported by <strong>MedITEX</strong>.</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0">
 +
<tbody>
 +
<tr>
 +
<td><img src="/images/hint48.png" alt="" width="48" height="48" /></td>
 +
<td>Please note that event typs such as, R01 and A08, are ignored. MedITEX will decide what to do with the message.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<h3>Lab Values Import</h3>
 +
<table style="margin-left: auto; margin-right: auto;" border="0" width="100" height="383">
 +
<tbody>
 +
<tr>
 +
<td>
 +
<h4>ORU-R01-2.5</h4>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<p>MSH|^~\&amp;|LABOR1|14|LAB|MedITEX|20150109122547||ORU^R01|16216545|P|2.5||||||8859/1</p>
 +
<p>PID||3333|096733119^^^GLIMS||Miller^Susan||19801122000000|F|||Randomroad 10^^Anytown^NY^12345</p>
 +
<p>ORC|NW||10-00740090S^14||CM||^^^20150109112946|||||LOFT1^Loft^John^^^^Dr^^^^GLIMS|||20150109000000</p>
 +
<p>OBR|1||10-00740090S^14||||20150109071000|||||||20150109112946||IVF-Clinic^^^^^^^^MedITEX||||User1||20150109000000|||M|||</p>
 +
<p>OBX|1|SN|lh^LH^GLIMS||8.7|U/l||N|||F||||||</p>
 +
<p>NTE|1|L|2.4 - 12.6&nbsp; Follicularphase\.br\14.0 - 95.6 Ovulationspeak\.br\1.0 - 11.4&nbsp; Lutealphase\.br\7.7 - 58.5&nbsp; Postmenopause</p>
 +
<p>OBX|3|SN|prog^Progesteron^GLIMS||1.7|nmol/l||N|||F||||||</p>
 +
<p>NTE|1|L|0.6 - 4.7&nbsp; Follicularphase\.br\2.4 - 9.4&nbsp; Ovulationspeak\.br\5.3 - 86.0 Lutealphase\.br\0.3 - 2.5&nbsp; Postmenopause</p>
 +
<p>OBX|5|SN|estra^Oestradiol (E2)^GLIMS||166.8|pmol/l||N|||F||||||</p>
 +
<p>NTE|1|L|46 - 607&nbsp;&nbsp;&nbsp; Follicularphase\.br\315 - 1828&nbsp; Ovulationspeak\.br\161 - 774&nbsp;&nbsp; Lutealphase\.br\&lt;18.4 - 201 Postmenopause</p>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>[[Image:10HL7.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/10HL7.png|ORU-R01 fields definitions]]</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0">
 +
<tbody>
 +
<tr>
 +
<td><a href="/images/Standard_ORU-R01-25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a></td>
 +
<td><a href="/images/Standard_ORU-R01-25.hl7">Download the file here</a>. Right-click <strong>Save link as</strong> to download.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<p>&nbsp;</p>
 +
<h3>Patient Import</h3>
 +
<table style="margin-left: auto; margin-right: auto;" border="0" width="567" height="189">
 +
<tbody>
 +
<tr>
 +
<td>
 +
<h4>ADT-A08-2.5</h4>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<p style="text-align: left;">MSH|^~\&amp;|Regional MPI|MPI|Master MPI|Alpha Hospital|20060501140010||ADT^A08|3948375|P^T|2.5|</p>
 +
<p style="text-align: left;">EVN|A08|20060501140008|||000338475^Author^Arthur^^^^^^Regional MPI&amp;2.16.840.1.113883.19.201&amp;ISO^L|20060501140008</p>
 +
<p style="text-align: left;">PID|||000197245^^^National Register&amp;2.00.123.1.123456.55.5&amp;ISO^PN~4532^^^Careful Care Clinic&amp;2.16.840.1.113883.19.2.400566&amp;ISO^PI~3242346^^^Central Clinic&amp;2.16.840.1.113883.19.2.450998&amp;ISO^PI||Miller^Susan^^^^^L||19750103|F|||Randomroad 23a&amp;Randomroad&amp;23a^^Anytown^^1200^^H||001 998877^TEL^PH~001 112233^FAX^FX|001 554433^TEL^PH</p>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td style="margin-left: auto; margin-right: auto;">[[Image:11HL7.png|none|519px|thumb|left|link=http://wiki.meditex-software.com/images/11HL7.png|ADT-A08 fields definitions]]</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0">
 +
<tbody>
 +
<tr>
 +
<td><a href="/images/Standard_ADT_A08_25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a></td>
 +
<td><a href="/images/Standard_ADT_A08_25.hl7">Download the file here</a>. Right-click <strong>Save link as</strong> to download.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<table style="float: right;" border="0">
 
<table style="float: right;" border="0">
 
<tbody>
 
<tbody>
 
<tr>
 
<tr>
−
<td style="text-align: right;"><a href="/index.php?title=Main_Page">Back to MedITEX products </a></td>
+
<td style="text-align: right;"><a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a></td>
 
<td style="text-align: right;"><a href="#top">Back to top</a></td>
 
<td style="text-align: right;"><a href="#top">Back to top</a></td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>

Latest revision as of 11:51, 12 November 2015

Contents

Scheme

<tbody> </tbody>
MedITEX HL7 Importer - Scheme

 

Configuration

General Settings

<tbody> </tbody>
General On/Off-Switch Activates or deactivates the HL7-Server

MedITEX IVF:

PMI_HL7 active

 Indicates whether your IVF tool is preconfigured for the import of additional patients data and therefore provides a special interface.
Protocol Level

Default setting is 'Errors, Hints and Debug Information'.

After the testing phase please switch to 'Only Errors' in order to reduce traffic and data storage.
IP-Address The IP address of the server where Importer is running.
Default is 'localhost' (or 127.0.0.1).
Number of Instances

Defines the number of asynchronous communication queues (threads).

Default is 1.
Number of Interfaces

Defines the number of protocols that can be interpreted.

Default is 1 (HL7).
Listen queue (max) The maximum of entries in the listener buffer (FIFO buffer).
Terminate wait time

Defines the maximum delay in milliseconds to receive messages from the queue.

Default is 10000 msec.
Thread delay

Defines the delay in milliseconds to give work time for other treads.

Default is 100 msec.
Reply ACK delay

Defines the delay in milliseconds to finish a processed message.

Default is 250 msec.
<tbody> </tbody>
<img src="/images/1HL7.png" alt="" width="598" height="404" />

 

 

COM Definitions

<tbody> </tbody>
Tab Item Description
Instances Instance Nr. Automatic counter
Active Yes or No
Port The client - server communications port
Interfaces Interface Nr. Automatic counter
Active Yes or No
Protocol Active protocol (In this version only HL7. In future versions also XML and SOAP)
Version Active version
Libary The name of the DLL which coummunicates with the database (Database-IN module)
<tbody> </tbody>
<img src="/images/2HL7.png" alt="" width="598" height="404" />
<img src="/images/3HL7.png" alt="" width="598" height="401" />

 

 

Additional Settings

Additional settings to save log files, make statistics and check the consistency of incoming data.

Saving

<tbody> </tbody>
Item Description
Save Level

Each processed message can be saved with more or less information.   Default is 'Errors, Hints and Debug Information'.

After the testing phase switch to 'Only Errors'.
Save info for statistics An additional feature to gain statistical information of the processed messages.
Automatically load protocol file An additional feature to display then message processing in the user interface of MexHL7Importer. The output will be according to the selection in section 'Save Level'.
<tbody> </tbody>
<img src="/images/4HL7.png" alt="" width="598" height="401" />

 

 

Patient Conditions

<tbody> </tbody>
Items Description
Minimum Length of Patient Identifier High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the length of the patient’s identifier is less than defined, an insert or update will be refused.

Age Range (min/max)

 High level check whether the current age in within the defined range.
Minimum Set of Fields High level check whether the message details are valid to be inserted or updated in the MedITEX IVF database. If the incoming data has no values in the defined fields, an insert or update will be refused.
<tbody> </tbody>
<img src="/images/5HL7.png" alt="" width="598" height="401" />

 

 

LAB Data Conditions

<tbody> </tbody>
Items Description
Use first available Patient ID A HL7 message can provide more than one possible Patient ID because the same message can trigger several target systems wherein a Patient ought to be matched via it’s ID.
Use Patient ID associated with IdentifierTypeCode If provided more than one Patient ID, each of them should be followed by a so called 'Identifier Code'-  which is nothing else than a second match code to decide which of the given Patient IDs is the right one for your system.
Save Parameters as “Something else” if they can not be matched

Laboratory parameters are divided into several parameter groups:

Hormone, Serology, Clinical chemistry, Genetics, Microbiology or 'Something else'. A laboratory parameter consists of a so called short form, a long from, a unit and a value. The short form must be transmitted within the HL7 message and defined in the target system … this is the way parameters are matched. If this matching fails the parameter can be imported as “Something else” - what in each case demands a following manual correction.
Import Notes from NTE Structure Additional information from the examining laboratory – as a non-formatted text - can be imported in memo fields of the target system.
Abnormal Flags Defines whether a given parameter value is inside a normal range or outside. These flags can be used to change flags in the target system.
Date Format

Describes the textual form of date and time information:

YYYY (year) MM (month) DD (day) HH (hour) NN (minute) SS (second).
<tbody> </tbody>
<img src="/images/6HL7.png" alt="" width="598" height="401" />

 

 

DB Access

Connection parameters to access the MedITEX IVF database:

<tbody> </tbody>
Item Description
Alias The database alias. Default is ART.
Server

The server address on which the Firebird server runs.

Default is 'localhost'  (or 127.0.0.1).
Charset

The character set according to your language.

Ask your support for additional help.
Client Library

The name of the Firebird client library.

Default is fbClient.dll (older versions use gds32.dll).
Backup Start If a backup task is defined type in the start time. This leads to a smarter and faster check whether database changings can be processed.
Backup End See description for point above.
Force restart During the processing of HL7 messages the memory usage of the HL7-Server increases continuously … not much, but it does. Therefore the time when backup is running can be used for a save restart of the HL7-Server.
DB Access

Strongly recommended:

No access to database if backup is running should be checked!
<tbody> </tbody>
<img src="/images/7HL7.png" alt="" width="598" height="404" />

 

 

Service

(requires MexHL7Service.exe)

<tbody> </tbody>
Item Description
Install service Requires MexHL7Service.exe and provides a so called background service, with full functionality, no interface, no login necessary. If successfully installed you can see a new entry in your service panel: MexHL7 Service.
Uninstall service Uninstalls the MexHL7 Service.
Start service Starts the MexHL7 Service.
Stop service Stops the MexHL7 Service.
Automatically Interface in notification area

Provides an icon in the taskbar that indicates that the service is running and provides a GUI for configuration and statistics. This won’t work with the new Microsoft UAC technology … older operating systems like Windows XP support this feature.

Try it and if you don’t see the MexHL7 Icon please uncheck this feature.
<tbody> </tbody>
<img src="/images/8HL7.png" alt="" />

 

 

Support

You can send protocol, statistic and log files to your support. Fill this formular in order to provide a smart email generator.

<tbody> </tbody>
Item Description
Your Name Type in any name you want to describe your clinic
Your Email Your email address
Email Body Any email body
Receiver

Default: <a href="mailto:support@critex.de">support@critex.de</a>
<tbody> </tbody>
<img src="/images/9HL7.png" alt="" width="598" height="404" />

 

 

Application

Description of the MedITEX HL7 Importer Application GUI.

To run the MexHL7Importer – after the configuration has been done – it is only necessary to click the 'Start Server' button. The screenshot bellow shows activity and data protocolling. Content depends on what has been defined in the configuration section.

<tbody> </tbody>
<img src="/images/0GUI.png" alt="" width="765" height="990" />

 

Each pair of data (HL7 message & transformation into importable data) is – if configured – saved in a protocol file which has been named with a tamestamp. In this file you have the possibility to check when and which HL7 message data caused which import or change of MedITEX IVF data.

<tbody> </tbody>
<img src="/images/01GUI.png" alt="" width="765" height="993" />

 

Statistical data – if configured – is automatically saved and compiled in order to provide a brief overview and a detailed table (as you can see below). For example:

Since the server was started, a total of 1373 HL7 messages were received, out of which a total of 37 errors occurred and finally 6 modifications of MedITEX IVF data have eventually been made.

<tbody> </tbody>
<img src="/images/02GUI.png" alt="" width="765" height="530" />

 

<tbody> </tbody>
Item Description
DLL Errors Occur if any low level communication fails (tcpIP,  ports , sockets, …).
Data Errors Occur if the consistency check of incoming data discovers missing information (a data field with no value) or invalid information (letters where only numbers were expected or violations of minimum or maximum definitions).
Updates Updates are only triggered if the associated patient already exists in the MedITEX IVF patient table.
Edits Edits are triggered if the associated patient exists in the MedITEX IVF buffer table.
Inserts Inserts into the so called buffer table are processed if the associated patient could not be found in both tables (patient table and buffer table).
Modifies Whether triggered 'Updates' or 'Edits' are finally processed is decided dependent of the data field values. If no modifications of data are found no change of the database is performed.

 

<tbody> </tbody>
<img src="/images/03GUI.png" alt="" width="765" height="990" />

 

Message Types

The messages below are examples supported by MedITEX.

<tbody> </tbody>
<img src="/images/hint48.png" alt="" width="48" height="48" /> Please note that event typs such as, R01 and A08, are ignored. MedITEX will decide what to do with the message.

 

Lab Values Import

<tbody> </tbody>

ORU-R01-2.5

MSH|^~\&|LABOR1|14|LAB|MedITEX|20150109122547||ORU^R01|16216545|P|2.5||||||8859/1

PID||3333|096733119^^^GLIMS||Miller^Susan||19801122000000|F|||Randomroad 10^^Anytown^NY^12345

ORC|NW||10-00740090S^14||CM||^^^20150109112946|||||LOFT1^Loft^John^^^^Dr^^^^GLIMS|||20150109000000

OBR|1||10-00740090S^14||||20150109071000|||||||20150109112946||IVF-Clinic^^^^^^^^MedITEX||||User1||20150109000000|||M|||

OBX|1|SN|lh^LH^GLIMS||8.7|U/l||N|||F||||||

NTE|1|L|2.4 - 12.6  Follicularphase\.br\14.0 - 95.6 Ovulationspeak\.br\1.0 - 11.4  Lutealphase\.br\7.7 - 58.5  Postmenopause

OBX|3|SN|prog^Progesteron^GLIMS||1.7|nmol/l||N|||F||||||

NTE|1|L|0.6 - 4.7  Follicularphase\.br\2.4 - 9.4  Ovulationspeak\.br\5.3 - 86.0 Lutealphase\.br\0.3 - 2.5  Postmenopause

OBX|5|SN|estra^Oestradiol (E2)^GLIMS||166.8|pmol/l||N|||F||||||

NTE|1|L|46 - 607    Follicularphase\.br\315 - 1828  Ovulationspeak\.br\161 - 774   Lutealphase\.br\<18.4 - 201 Postmenopause
ORU-R01 fields definitions

 

<tbody> </tbody>
<a href="/images/Standard_ORU-R01-25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a> <a href="/images/Standard_ORU-R01-25.hl7">Download the file here</a>. Right-click Save link as to download.

 

 

Patient Import

<tbody> </tbody>

ADT-A08-2.5

MSH|^~\&|Regional MPI|MPI|Master MPI|Alpha Hospital|20060501140010||ADT^A08|3948375|P^T|2.5|

EVN|A08|20060501140008|||000338475^Author^Arthur^^^^^^Regional MPI&2.16.840.1.113883.19.201&ISO^L|20060501140008

PID|||000197245^^^National Register&2.00.123.1.123456.55.5&ISO^PN~4532^^^Careful Care Clinic&2.16.840.1.113883.19.2.400566&ISO^PI~3242346^^^Central Clinic&2.16.840.1.113883.19.2.450998&ISO^PI||Miller^Susan^^^^^L||19750103|F|||Randomroad 23a&Randomroad&23a^^Anytown^^1200^^H||001 998877^TEL^PH~001 112233^FAX^FX|001 554433^TEL^PH
ADT-A08 fields definitions

 

<tbody> </tbody>
<a href="/images/Standard_ADT_A08_25.hl7"><img src="/images/plus48.png" alt="" width="48" height="48" /></a> <a href="/images/Standard_ADT_A08_25.hl7">Download the file here</a>. Right-click Save link as to download.

 

<tbody> </tbody>
<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a> <a href="#top">Back to top</a>