More Importing Features

Revision as of 15:41, 24 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.

Patient demographics import

You need to prepare an import file which is a list in Excel or CSV format where each line 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.	DOB	Patient date of birth (Date)
4.	NAME	Patient name (100 characters)
5.	FIRST_NAME	Patient first name (100 characters)
6.	GENDER	Patient gender (1 character - W/M)
7.	POSTCODE	Patient address: postal code (50 characters)
8.	CITY	Patient address: city (50 characters)
9.	STREET	Patient address: street (255 characters)
10.	PHONE	Patient private phone number (50 characters)
11.	LOCATION (CLINIC)	The clinic where the patient is located (250 characters)

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

Required fields are:

PATIENT_ID
DOB
NAME
GENDER (W/M)
PARTNER ID (If couples should be linked)

Cryo storage import

It is mandatory to prepare an import file where each line is ONE straw.

<a href="/images/Cryo_Storage.xlsx">Click here</a> to download an example of Cryo storage import file.

Before importing, it is important to know that:

The cryo storage dimension must be configured in MedITEX IVF Settings;
The patient demographics must already be imported into the MedITEX Database;
Each line must contain the Patient ID, which is the identification for inserting the cryo information for the correct patient. Important is that Patient ID is unique like already mentioned above;
Type of semen material can be specified in: Native sperm, Prep. Sperm, Tissue, Tissue left, Tissue right, Tissue ambilateral, MESA, MESA left, MESA right, MESA ambilateral, Supernatant, Supernatant left, Supernatant right, Supernatant ambilateral, PESA, TESA, TESE.

The following elements/conditions should be included in the import file:

	Column name	Column content
1.	PATIENT ID	Patient ID number (Integer)
2.	ASPIRATION/COLLECTION DATE	Date of sperm collection/follicle aspiration (Timestamp)
3.	FREEZING DATE	Date of freezing (Timestamp)
4.	STORAGE DATE	Date of storage (Date)
5.	NO. OF OOCYTES	Total number of collected oocytes (Smallint)
6.	NO. OF IVF PNs	Number of PNs after IVF (Smallint)
7.	NO. OF ICSI PNs	Number of PNs after ICSI (Smallint)
8.	NO. OF IVF EMBs	Number of embryos after IVF (Smallint)
9.	NO. OF ICSI EMBs	Number of embryos after ICSI (Smallint)
10.	OVARIAN TISSUE	Ovarian tissue cryopreservation
11.	TYPE OF SEMEN MATERIAL
12.	STRAW ID	Straw ID (50 characters)
13.	CRYO TECHNIQUE	Cryo technique used
14.	STORAGE LOCATION DESCR.	Container/Tank
15.	STORAGE DIMENSION 1	e.g. Tank level
16.	STORAGE DIMENSION 2	e.g. Canister
17.	STORAGE DIMENSION 3	e.g. Goblet
18.	POSITION	Storage position
19.	COLOUR 1	First color defining the storage location and position
20.	COLOUR 2	Second color defining the storage location and position
21.	CRYOPRESERVED BY
22.	STORED BY

Insurance Import

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)

Not all fields are required;
Required fields are:
- IN_NAME
- IN_INSURER_NO
- IN_IS_ECLAIM_BILLING

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

@@ Line 136: / Line 136: @@
 <td align="center">2.</td>
 <td style="text-align: left;" align="center">ASPIRATION/COLLECTION DATE<br /></td>
-<td style="text-align: left;" align="center">Date of sperm collection/follicle aspiration (Date)</td>
+<td style="text-align: left;" align="center">Date of sperm collection/follicle aspiration (Timestamp)</td>
 </tr>
 <tr>
 <td align="center">3.</td>
 <td style="text-align: left;" align="center">FREEZING DATE<br /></td>
-<td style="text-align: left;" align="center">Date of freezing (Date)<br /></td>
+<td style="text-align: left;" align="center">Date of freezing (Timestamp)<br /></td>
 </tr>
 <tr>
@@ Line 151: / Line 151: @@
 <td align="center">5.</td>
 <td style="text-align: left;" align="center">NO. OF OOCYTES<br /></td>
-<td style="text-align: left;" align="center">Total number of collected oocytes (Integer)<br /></td>
+<td style="text-align: left;" align="center">Total number of collected oocytes (Smallint)<br /></td>
 </tr>
 <tr>
 <td align="center">6.</td>
 <td style="text-align: left;" align="center">NO. OF IVF PNs<br /></td>
-<td style="text-align: left;" align="center">Number of PNs after IVF (Integer)<br /></td>
+<td style="text-align: left;" align="center">Number of PNs after IVF (Smallint)<br /></td>
 </tr>
 <tr>
 <td align="center">7.</td>
 <td style="text-align: left;" align="center">NO. OF ICSI PNs<br /></td>
-<td style="text-align: left;" align="center">Number of PNs after ICSI (Integer)<br /></td>
+<td style="text-align: left;" align="center">Number of PNs after ICSI (Smallint)<br /></td>
 </tr>
 <tr>
 <td align="center">8.</td>
 <td style="text-align: left;" align="center">NO. OF IVF EMBs<br /></td>
-<td style="text-align: left;" align="center">Number of embryos after IVF (Integer)<br /></td>
+<td style="text-align: left;" align="center">Number of embryos after IVF (Smallint)<br /></td>
 </tr>
 <tr>
 <td align="center">9.</td>
 <td style="text-align: left;" align="center">NO. OF ICSI EMBs<br /></td>
-<td style="text-align: left;" align="center">Number of embryos after ICSI (Integer)<br /></td>
+<td style="text-align: left;" align="center">Number of embryos after ICSI (Smallint)<br /></td>
 </tr>
 <tr>
@@ Line 191: / Line 191: @@
 <td align="center">13.</td>
 <td style="text-align: left;" align="center">CRYO TECHNIQUE</td>
-<td style="text-align: left;" align="center">The cryo technique used <br /></td>
+<td style="text-align: left;" align="center">Cryo technique used</td>
 </tr>
 <tr>
 <td align="center">14. <br /></td>
 <td style="text-align: left;" align="center">STORAGE LOCATION DESCR.<br /></td>
-<td style="text-align: left;" align="center">Container/Tank</td>
+<td style="text-align: left;" align="center">Container/Tank <br /></td>
 </tr>
 <tr>
 <td align="center">15.</td>
 <td style="text-align: left;" align="center">STORAGE DIMENSION 1<br /></td>
-<td style="text-align: left;" align="center">e.g. Tank level<br /></td>
+<td style="text-align: left;" align="center">e.g. Tank level</td>
 </tr>
 <tr>
 <td align="center">16. <br /></td>
 <td style="text-align: left;" align="center">STORAGE DIMENSION 2<br /></td>
-<td style="text-align: left;" align="center">e.g. Canister<br /></td>
+<td style="text-align: left;" align="center">e.g. Canister&nbsp; <br /></td>
 </tr>
 <tr>
 <td align="center">17.</td>
 <td style="text-align: left;" align="center">STORAGE DIMENSION 3<br /></td>
-<td style="text-align: left;" align="center">e.g. Goblet<br /></td>
+<td style="text-align: left;" align="center">e.g. Goblet</td>
 </tr>
 <tr>
 <td align="center">18.</td>
 <td style="text-align: left;" align="center">POSITION</td>
-<td style="text-align: left;" align="center">&nbsp;</td>
+<td style="text-align: left;" align="center">Storage position <br /></td>
 </tr>
 <tr>
 <td align="center">19.</td>
 <td style="text-align: left;" align="center">COLOUR 1</td>
-<td style="text-align: left;" align="center">Colors defining the storage lcoation and positon <br /><br /></td>
+<td style="text-align: left;" align="center">First color defining the storage location and position<br /></td>
 </tr>
 <tr>
 <td align="center">20.</td>
 <td style="text-align: left;" align="center">COLOUR 2</td>
-<td style="text-align: left;" align="center">&nbsp;</td>
+<td style="text-align: left;" align="center">Second color defining the storage location and position <br /></td>
 </tr>
 <tr>
@@ Line 327: / Line 327: @@
 <ul>
 <li>Not all fields are required;</li>
 <li>Required fields are:
 <ul>
 <li>IN_NAME</li>

More Importing Features

From MedITEX - Wiki

Revision as of 15:41, 24 February 2017

Patient demographics import

Cryo storage import

Insurance Import