LDT Importer

Revision as of 13:04, 16 June 2014

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.

Configuration

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

<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.

<a href="/images/LDT_import_example.txt">Demographics import file (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.

<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.

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

MER format

Header

Field names cannot be changed;

Field names must be separated by semicolon;

Data

Data needs to match the sequence of the header;

Data needs to be between quotation marks;

Each field needs to be separated by semicolon;

If information is not available, leave content inside quotation marks empty (...;"";...);

Each row after the header is one patient and one partner (if exists);

LDT/BDT format

Data

Each row in a file represents one field to be inserted;

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;

Example: 00830001 - one row in a file

008 = length

3000 = identifier for Patient_ID

1 = ID of a patient

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

@@ Line 16: / Line 16: @@
 <p>The importing of data is only possible if a specific file format is delivered.</p>
 <p>&nbsp;</p>
-<h2>Demographics import</h2>
+<h3>Demographics import</h3>
 <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">
@@ Line 27: / Line 27: @@
 </table>
 <p>&nbsp;</p>
-<h2>Referrer import</h2>
+<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">
@@ Line 38: / Line 38: @@
 </table>
 <p style="text-align: center;">&nbsp;</p>
-<h2 style="text-align: left;">Laboratory data import&nbsp;</h2>
+<h3 style="text-align: left;">Laboratory data import&nbsp;</h3>
 <p>An example of laboratory data import file in LDT format can be downloaded from the link below.&nbsp;</p>
 <table style="margin-left: auto; margin-right: auto;" border="0">
@@ Line 49: / Line 49: @@
 </table>
 <p style="text-align: center;">&nbsp;</p>
-<p>&nbsp;</p>
-<p>&nbsp;</p>
 <table style="margin-left: auto; margin-right: auto;" border="0">
 <tbody>
@@ Line 89: / Line 87: @@
 <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>