More Importing Features
From MedITEX - Wiki
(Difference between revisions)
| Line 25: | Line 25: | ||
<tr> | <tr> | ||
<td align="center">1.</td> | <td align="center">1.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">Patient ID<br /></td> |
<td style="text-align: left;" align="center">Patient ID number (Integer)</td> | <td style="text-align: left;" align="center">Patient ID number (Integer)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">2.</td> | <td align="center">2.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">Partner ID<br /></td> |
<td style="text-align: left;" align="center">Partner ID number (Integer)</td> | <td style="text-align: left;" align="center">Partner ID number (Integer)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">3.</td> | <td align="center">3.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">DOB</td> |
<td style="text-align: left;" align="center">Patient date of birth (Date)</td> | <td style="text-align: left;" align="center">Patient date of birth (Date)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">4.</td> | <td align="center">4.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">Name</td> |
| − | <td style="text-align: left;" align="center">Patient | + | <td style="text-align: left;" align="center">Patient name (100 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">5.</td> | <td align="center">5.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">First name<br /></td> |
<td style="text-align: left;" align="center">Patient first name (100 characters)</td> | <td style="text-align: left;" align="center">Patient first name (100 characters)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">6.</td> | <td align="center">6.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">Gender</td> |
<td style="text-align: left;" align="center">Patient gender (1 character - W/M)</td> | <td style="text-align: left;" align="center">Patient gender (1 character - W/M)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">7.</td> | <td align="center">7.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">Postcode</td> |
<td style="text-align: left;" align="center">Patient address: postal code (50 characters)<br /></td> | <td style="text-align: left;" align="center">Patient address: postal code (50 characters)<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">8.</td> | <td align="center">8.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">City</td> |
<td style="text-align: left;" align="center">Patient address: city (50 characters)<br /></td> | <td style="text-align: left;" align="center">Patient address: city (50 characters)<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">9.</td> | <td align="center">9.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">Street<br /></td> |
<td style="text-align: left;" align="center">Patient address: street (255 characters)</td> | <td style="text-align: left;" align="center">Patient address: street (255 characters)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">10.</td> | <td align="center">10.</td> | ||
| − | <td style="text-align: left;" align="center"> | + | <td style="text-align: left;" align="center">Phone</td> |
<td style="text-align: left;" align="center">Patient private phone number (50 characters)<br /></td> | <td style="text-align: left;" align="center">Patient private phone number (50 characters)<br /></td> | ||
</tr> | </tr> | ||
| Line 185: | Line 185: | ||
<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> | ||
Revision as of 17:33, 23 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.
| <img src="/images/plus48.png" alt="" width="48" height="48" /> |
<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) |
Please make sure that your current Patient IDs from your existing data are unique.
Cryo storage import
It is mandatory to prepare an import file where each line is ONE straw.
| <img src="/images/plus48.png" alt="" width="48" height="48" /> |
<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.
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.
| <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:
| 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) |
| <img src="/images/hint129.png" alt="" width="129" height="129" /> |
|
|
<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a> |
<a href="#top">Back to top</a> |