More Importing Features

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 344: Line 344:
 
<ul>
 
<ul>
 
<li>Not all fields are required;</li>
 
<li>Not all fields are required;</li>
<li>Required fields are:                                                                  
+
<li>Required fields are:                                                                    
 
<ul>
 
<ul>
 
<li>IN_NAME</li>
 
<li>IN_NAME</li>
 
<li>IN_INSURER_NO</li>
 
<li>IN_INSURER_NO</li>
<li>IN_IS_ECLAIM_BILLING</li>
 
 
</ul>
 
</ul>
 
</li>
 
</li>

Revision as of 09:03, 20 October 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.

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

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

 

The following elements should be included in this file:

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

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

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.

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

<a href="/images/Cryo_Storage.xls">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:

<tbody> </tbody>
   Column name  Column content
1. PATIENT ID
Patient ID number (Integer)
2. COLLECTION_DATE
Date of sperm collection/follicle aspiration (Date)
3. FREEZING_DATE
Date of freezing (Date)
4. STORAGE_DATE
Date of storage (Date)
5. NO_OOCYTES
Total number of collected oocytes (Integer)
6. IVF_PNs
Number of PNs after IVF (Integer)
7. ICSI_PNs
Number of PNs after ICSI (Integer)
8. IVF_EMBs
Number of embryos after IVF (Integer)
9. ICSI_EMBs
Number of embryos after ICSI (Integer)
10. OVARIAN_TISSUE
Ovarian tissue cryopreservation (OOC/EMB/PN) (0=No, 1=Yes)
11. SEMEN_MATERIAL Type of semen material specification (100 characters) 
12. STRAW_ID Straw ID (50 characters)
13. CRYO_TECHNIQUE Cryo technique used (50 characters)
14.
STORAGE_LOCATION
Storage location description e.g. Container/Tank (128 characters)
15. STORAGE_DIM1
Storage dimension e.g. Tank level (128 characters)
16.
STORAGE_DIM2
Storage dimension e.g. Canister level (128 characters)
17. STORAGE_DIM3
Storage dimension e.g. Goblet level (128 characters)
18. POSITION Straw position (10 characters)
19. COLOUR1 First color defining the straw (10 characters)
20. COLOUR2 Second color defining the straw (10 characters)
21. CRYOPRESERVED_BY Staff responsible of the cryopreservation (100 characters)
22. STORED_BY Staff responsible of the storage (100 characters)
<tbody> </tbody>
<img src="/images/hint129.png" alt="" width="129" height="129" />

Required fields are:

  • PATIENT ID
  • COLLECTION DATE
  • FREEZING DATE
  • OVARIAN TISSUE
  • TYPE OF SEMEN MATERIAL

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.

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

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

<tbody> </tbody>
   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) 

 

<tbody> </tbody>
<img src="/images/hint129.png" alt="" width="129" height="129" />
  • Not all fields are required;
  • Required fields are:
    • IN_NAME
    • IN_INSURER_NO

 

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