LDT Importer

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
 
(67 intermediate revisions by 6 users not shown)
Line 1: Line 1:
−
<p><strong>MedITEX LDT Importer</strong> will import data from another billing or lab program to the database being used for <strong>MedITEX</strong>, allowing basic information such as, patient and partner data, lab results and referrer information to be imported from different text-formatted files.</p>
+
<p><strong>MedITEX LDT Importer</strong> will import data from another billing or lab program to the database being used for <strong>MedITEX</strong>, allowing basic information such as, patient and partner data, referrer information and lab results to be imported from different text-formatted files.</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<h2>Configuration</h2>
 
<h2>Configuration</h2>
Line 11: Line 11:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
 
 
<h2>File formats</h2>
 
<h2>File formats</h2>
 
<p>The importing of data is only possible if a specific file format is delivered.</p>
 
<p>The importing of data is only possible if a specific file format is delivered.</p>
−
<p>This file consists of a header, for the name of the fields being imported.</p>
 
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
−
<h2>Demographics import</h2>
+
<h3>Demographics import</h3>
−
<p>An example of demographics import file can be downloaded from the link below. This document contains two patients with their respective partners.</p>
+
<p>An example of demographics import file in MER format can be downloaded from the link below. This document contains data about two patients and their respective partners.</p>
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<tbody>
 
<tbody>
 
<tr>
 
<tr>
 
<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
 
<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
−
<td><a href="/images/LDT_import_example.txt">Import file (right-click "Save link as").</a></td>
+
<td>
 +
<p><a href="/images/LDT_import_example.txt">Demographics import file (right-click "Save link as").</a></p>
 +
</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
−
<h2>Referrer</h2>
+
<table style="margin-left: auto; margin-right: auto;" border="0">
−
<p>An example of referrer import file can be downloaded from the link below.&nbsp;</p>
+
<tbody>
 +
<tr>
 +
<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
 +
<td><a href="/images/List_of_main_fields_in_MedITEX_Patient_Demographics.xlsx">List of main fields in MedITEX Patient Demographics (right-click "Save link as").</a></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<h3>Referrer import</h3>
 +
<p>An example of referrer import file in MER format can be downloaded from the link below.&nbsp;This document contains data about two referrers.</p>
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<tbody>
 
<tbody>
 
<tr>
 
<tr>
 
<td style="text-align: center;"><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
 
<td style="text-align: center;"><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
−
<td><a href="/images/GP_list-final.txt">Import file (right-click "Save link as").</a></td>
+
<td><a href="/images/LDT_Referrer_Import.txt">Referrer import file (right-click "Save link as").</a></td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
 
<p style="text-align: center;">&nbsp;</p>
 
<p style="text-align: center;">&nbsp;</p>
−
<p style="text-align: left;">&nbsp;</p>
+
<h3 style="text-align: left;">Laboratory data import</h3>
−
<p>&nbsp;</p>
+
<p>An example of laboratory data import file in LDT format can be downloaded from the link below.&nbsp;</p>
−
<p>&nbsp;</p>
+
−
<p>&nbsp;</p>
+
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<tbody>
 
<tbody>
 
<tr>
 
<tr>
−
<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
+
<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
 +
<td><a href="/images/LDT_LabData_Import.txt">Laboratory data import file (right-click "Save link as")</a></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p style="text-align: center;">&nbsp;</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0">
 +
<tbody>
 +
<tr>
 +
<td rowspan="2"><img src="/images/hint129.png" alt="" width="129" height="129" /><br /></td>
 
<td>
 
<td>
−
<h4>MER format</h4>
+
<h4>MER&nbsp;<span style="font-size: 1em;">format</span></h4>
 
</td>
 
</td>
 
<td>
 
<td>
Line 55: Line 70:
 
<blockquote><ol>
 
<blockquote><ol>
 
<li>Field names cannot be changed;</li>
 
<li>Field names cannot be changed;</li>
−
<li>Field names must be separeted by semicolon;</li>
+
<li>Field names must be separated by semicolon;</li>
 
</ol></blockquote>
 
</ol></blockquote>
 
<ul>
 
<ul>
−
<li><strong>Patients</strong></li>
+
<li><strong>Data</strong></li>
 
</ul>
 
</ul>
 
<blockquote><ol>
 
<blockquote><ol>
Line 67: Line 82:
 
<li>Each row after the header is one patient and one partner (if exists);</li>
 
<li>Each row after the header is one patient and one partner (if exists);</li>
 
</ol></blockquote>
 
</ol></blockquote>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<h4>LDT/BDT format</h4>
 +
</td>
 +
<td>
 +
<ul>
 +
<li><strong>Data</strong> </li>
 +
</ul>
 +
<ul>
 +
</ul>
 +
<blockquote><ol>
 +
<li>Each row in a file represents one field to be inserted;</li>
 +
<li>First three digits in a row represent the length of a field, next four digits represent the identifier of a field and all other characters are the information itself;</li>
 +
<li>Example: 00830001 - one row in a file                     
 +
<ul>
 +
<li>008 = length</li>
 +
<li>3000 = identifier for Patient_ID</li>
 +
<li>1 = ID of a patient</li>
 +
</ul>
 +
</li>
 +
</ol>
 +
<p><a href="/images/BDT-Datensatzbeschreibung_3-0.pdf" target="_blank"><em>Please click here for more information.</em></a></p>
 +
</blockquote>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 74: Line 114:
 
<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"> </a>
 +
<p><a href="/index.php?title=Import_and_Export_tools"><span>&nbsp;</span></a><a style="font-size: small;" href="/index.php?title=Administrators_Support">Back to Administrators Support</a></p>
 +
</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 14:32, 7 August 2018

MedITEX LDT Importer will import data from another billing or lab program to the database being used for MedITEX, allowing basic information such as, patient and partner data, referrer information and lab results to be imported from different text-formatted files.

 

Contents

Configuration

The following manual describes the main configuration possible with MedITEX LDT Importer.

<tbody> </tbody>
<a href="/images/LDT_Importer.pdf"><img src="/images/plus48.png" alt="" width="48" height="48" /></a> <a href="/images/LDT_Importer.pdf">Click here</a> to read the manual.

File formats

The importing of data is only possible if a specific file format is delivered.

 

Demographics import

An example of demographics import file in MER format can be downloaded from the link below. This document contains data about two patients and their respective partners.

<tbody> </tbody>
<img src="/images/plus48.png" alt="" width="48" height="48" />

<a href="/images/LDT_import_example.txt">Demographics import file (right-click "Save link as").</a>

 

<tbody> </tbody>
<img src="/images/plus48.png" alt="" width="48" height="48" /> <a href="/images/List_of_main_fields_in_MedITEX_Patient_Demographics.xlsx">List of main fields in MedITEX Patient Demographics (right-click "Save link as").</a>

Referrer import

An example of referrer import file in MER format can be downloaded from the link below. This document contains data about two referrers.

<tbody> </tbody>
<img src="/images/plus48.png" alt="" width="48" height="48" /> <a href="/images/LDT_Referrer_Import.txt">Referrer import file (right-click "Save link as").</a>

 

Laboratory data import

An example of laboratory data import file in LDT format can be downloaded from the link below. 

<tbody> </tbody>
<img src="/images/plus48.png" alt="" width="48" height="48" /> <a href="/images/LDT_LabData_Import.txt">Laboratory data import file (right-click "Save link as")</a>

 

<tbody> </tbody>
<img src="/images/hint129.png" alt="" width="129" height="129" />

MER format
  • Header
  1. Field names cannot be changed;
  2. Field names must be separated by semicolon;
  • Data
  1. Data needs to match the sequence of the header;
  2. Data needs to be between quotation marks;
  3. Each field needs to be separated by semicolon;
  4. If information is not available, leave content inside quotation marks empty (...;"";...);
  5. Each row after the header is one patient and one partner (if exists);

LDT/BDT format
  • Data
  1. Each row in a file represents one field to be inserted;
  2. First three digits in a row represent the length of a field, next four digits represent the identifier of a field and all other characters are the information itself;
  3. Example: 00830001 - one row in a file
    • 008 = length
    • 3000 = identifier for Patient_ID
    • 1 = ID of a patient

<a href="/images/BDT-Datensatzbeschreibung_3-0.pdf" target="_blank">Please click here for more information.</a>
<tbody> </tbody>
<a href="/index.php?title=Import_and_Export_tools"> </a>

<a href="/index.php?title=Import_and_Export_tools"> </a><a style="font-size: small;" href="/index.php?title=Administrators_Support">Back to Administrators Support</a>

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