More Importing Features

Revision as of 17:09, 22 February 2017

This page contains additional importing features supported by MedITEX.

Please plan enough time for the preparation of the data import as it usually takes several tries to bring all data in required structure.

You need to prepare a list in Excel or CSV format where each line in the import file is one patient.

<a href="/images/Patient_Demographics.xlsx">Click here</a> to download an example of Patient demographics import file.

The following elements should be included in this file:

	Column name	Column content
1.	PATIENT_ID	Patient ID number (Integer)
2.	PARTNER_ID	Partner ID number (Integer)
3.	GEBURTSDATUM	Patient date of birth (Date)
4.	NACHNAME	Patient surname (100 characters)
5.	VORNAME	Patient first name (100 characters)
6.	GESCHLECHT	Patient gender (1 character - W/M)
7.	PLZ	Patient address: postal code (50 characters)
8.	ORT	Patient address: city (50 characters)
9.	STRASSE	Patient address: street (255 characters)
10.	TEL_PRIVAT	Patient private phone number (50 characters)

Please make sure that your current Patient IDs from your existing data are unique.

It is possible to import insurance companies by providing a spreadsheet with the information described on this section.

An example of this file can be downloaded from the link below. This document contains the insurance information about one insurer.

<a href="/images/Insurance.xls">Click here</a> to download an example of Insurance information import file.

The structure of this file is described in the table below:

	Column name	Column content
1.	IN_NAME	Insurer name (50 characters)
2.	IN_INSURER_NO	Insurer number (30 characters)
3.	IN_ADDRESS	Insurer address (255 characters)
4.	IN_EMAIL	Insurer email (50 characters)
5.	IN_PHONE	Insurer phone (50 characters)
6.	IN_FAX	Insurer fax (50 characters)
7.	IN_COUNTRY	Insurer country (numeric code related to the country) The list of countries and corresponding codes can be <a href="/images/Countries.xls">downloaded here</a>
8.	IN_CLINIC_ID_NUMBER	Insurer clinic ID number (defined by the clinic itself)
9.	IN_IS_INSURANCE	Insurer / Funder (1 = insurer, 0 = funder)
10.	IN_IS_ECLAIM_BILLING	E-claim billing (1 = yes, 0 = no)

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

@@ Line 1: / Line 1: @@
 <p>This page contains additional importing features supported by <strong>MedITEX</strong>.</p>
+<p>Please plan enough time for the preparation of the data import as it  usually takes several tries to bring all data in required structure.</p>
 <p>&nbsp;</p>
 <h2>Patient demographics import</h2>
-<p>Please plan enough time for the preparation of the data import as it usually takes several tries to bring all data in required structure.</p>
+<p>You need to prepare a list in Excel or CSV format where each line in the import file is one patient.</p>
-<p>You need to prepare a list in Excel or CSV format with the following where each line in the import file is one patient.</p>
 <table style="margin-left: auto; margin-right: auto;" border="0">
 <tbody>
@@ Line 166: / Line 166: @@
 <ul>
 <li>Not all fields are required;</li>
 <li>Required fields are:
 <ul>
 <li>IN_NAME</li>