More Importing Features
From MedITEX - Wiki
(23 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
+ | <p> </p> | ||
<p>This page contains additional importing features supported by <strong>MedITEX</strong>.</p> | <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>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> | ||
Line 26: | Line 27: | ||
<td align="center">1.</td> | <td align="center">1.</td> | ||
<td style="text-align: left;" align="center">PATIENT_ID<br /></td> | <td style="text-align: left;" align="center">PATIENT_ID<br /></td> | ||
− | <td style="text-align: left;" align="center">Patient ID | + | <td style="text-align: left;" align="center">Patient ID (64 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">2.</td> | <td align="center">2.</td> | ||
<td style="text-align: left;" align="center">PARTNER_ID<br /></td> | <td style="text-align: left;" align="center">PARTNER_ID<br /></td> | ||
− | <td style="text-align: left;" align="center">Partner ID | + | <td style="text-align: left;" align="center">Partner ID (64 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 116: | Line 117: | ||
<ul> | <ul> | ||
<li>The cryo storage dimension must be configured in MedITEX IVF Settings;</li> | <li>The cryo storage dimension must be configured in MedITEX IVF Settings;</li> | ||
+ | <li>Each line is one straw. If you have multiple straws for the same patient, these lines must be duplicated in the file.</li> | ||
<li>The patient demographics must already be imported into the MedITEX Database;</li> | <li>The patient demographics must already be imported into the MedITEX Database;</li> | ||
<li>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;</li> | <li>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;</li> | ||
Line 131: | Line 133: | ||
<td align="center">1.</td> | <td align="center">1.</td> | ||
<td style="text-align: left;" align="center">PATIENT ID<br /></td> | <td style="text-align: left;" align="center">PATIENT ID<br /></td> | ||
− | <td style="text-align: left;" align="center">Patient ID number ( | + | <td style="text-align: left;" align="center">Patient ID number (64 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 151: | Line 153: | ||
<td align="center">5.</td> | <td align="center">5.</td> | ||
<td style="text-align: left;" align="center">NO_OOCYTES<br /></td> | <td style="text-align: left;" align="center">NO_OOCYTES<br /></td> | ||
− | <td style="text-align: left;" align="center">Total number of | + | <td style="text-align: left;" align="center">Total number of oocytes (Integer)<br /></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 237: | Line 239: | ||
<td style="text-align: left;" align="center">STORED_BY</td> | <td style="text-align: left;" align="center">STORED_BY</td> | ||
<td style="text-align: left;" align="center">Staff responsible of the storage (100 characters)<br /></td> | <td style="text-align: left;" align="center">Staff responsible of the storage (100 characters)<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">23.</td> | ||
+ | <td style="text-align: left;" align="center">CONTRACT_NO</td> | ||
+ | <td style="text-align: left;" align="center">Cryo contract number. Used to link the sample with a contract. See below. (100 characters)</td> | ||
</tr> | </tr> | ||
</tbody> | </tbody> | ||
Line 249: | Line 256: | ||
<p>Required fields are:</p> | <p>Required fields are:</p> | ||
<ul> | <ul> | ||
− | <li> | + | <li>PATIENT_ID</li> |
− | <li> | + | <li>COLLECTION_DATE</li> |
− | <li> | + | <li>FREEZING_DATE</li> |
− | <li> | + | <li>OVARIAN_TISSUE</li> |
− | <li> | + | <li>TYPE_OF_SEMEN_MATERIAL</li> |
</ul> | </ul> | ||
</td> | </td> | ||
Line 259: | Line 266: | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
− | <p>Semen analyses | + | <h3>Cryo contracts</h3> |
+ | <p>In the case a <a href="/index.php?title=How_to_create_a_new_cryo_contract%3F">cryo contract</a> needs to be imported for the samples, an additional file is required.</p> | ||
+ | <p>This file will contain the different contracts that are available for each patient. Samples are then linked with each contract, using field 23 from the sample specification above.</p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td><img src="/images/plus48.png" alt="" width="48" height="48" /></td> | ||
+ | <td> | ||
+ | <p><a href="/images/Cryo_Contracts.xls">Click here</a> to download an example of Cryo contract import file.</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <p>The following elements/conditions should be included in the import file:</p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td align="center"><strong> </strong></td> | ||
+ | <td align="center"><strong> Column name</strong></td> | ||
+ | <td align="center"><strong> Column content</strong></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">1.</td> | ||
+ | <td style="text-align: left;" align="center">PATIENT ID<br /></td> | ||
+ | <td style="text-align: left;" align="center">Patient ID number (64 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">2.</td> | ||
+ | <td style="text-align: left;" align="center">CONTRACT_NO<br /></td> | ||
+ | <td style="text-align: left;" align="center">Number of the cryo contract (100 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">3.</td> | ||
+ | <td style="text-align: left;" align="center">CONTRACT_START<br /></td> | ||
+ | <td style="text-align: left;" align="center">Date when contract starts (Date)<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">4.</td> | ||
+ | <td style="text-align: left;" align="center">CONTRACT_EXPIRY<br /></td> | ||
+ | <td style="text-align: left;" align="center">Date when contract expires (Date)<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">5.</td> | ||
+ | <td style="text-align: left;" align="center">CONTRACT_NAME<br /></td> | ||
+ | <td style="text-align: left;" align="center">Name of the contract (100 characters)<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">6.</td> | ||
+ | <td style="text-align: left;" align="center">CONTRACT_ACTIVE<br /></td> | ||
+ | <td style="text-align: left;" align="center">If contract is still active or if it is terminated. 1 = Active, 0 = Terminated (Integer)<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">7.</td> | ||
+ | <td style="text-align: left;" align="center">CONTRACT_NEXT_INVOICE<br /></td> | ||
+ | <td style="text-align: left;" align="center">Date of next invoice (Date)<br /></td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td><img src="/images/hint129.png" alt="" width="129" height="129" /></td> | ||
+ | <td> | ||
+ | <p>Before this import can take place, Cryo contracts need to be configured in the system settings: <a href="/index.php?title=MedITEX_IVF_Settings#Cryo_contracts_and_accounting">click here</a> for more information.</p> | ||
+ | <p>Required fields are:</p> | ||
+ | <ul> | ||
+ | <li>PATIENT_ID</li> | ||
+ | <li>CONTRACT_NO</li> | ||
+ | <li>CONTRACT_START</li> | ||
+ | <li>CONTRACT_NAME</li> | ||
+ | </ul> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <h2>Semen analyses import</h2> | ||
<p>An import file should be prepared as a list where each line will represent ONE complete semen analysis.</p> | <p>An import file should be prepared as a list where each line will represent ONE complete semen analysis.</p> | ||
<table style="margin-left: auto; margin-right: auto;" border="0"> | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
Line 282: | Line 367: | ||
<tbody> | <tbody> | ||
<tr> | <tr> | ||
+ | <td>1.</td> | ||
<td>PATIENT_ID</td> | <td>PATIENT_ID</td> | ||
<td>Patient ID number (Integer)</td> | <td>Patient ID number (Integer)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>2.</td> | ||
<td>SAMPLE_ID</td> | <td>SAMPLE_ID</td> | ||
− | <td>Sample ID number ( | + | <td>Sample ID number (64 caracters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>3.</td> | ||
<td>COLLECTION_DATE</td> | <td>COLLECTION_DATE</td> | ||
<td> | <td> | ||
Line 296: | Line 384: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>4.</td> | ||
<td>PURPOSE</td> | <td>PURPOSE</td> | ||
<td> | <td> | ||
Line 315: | Line 404: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>5.</td> | ||
<td>FOR_DONATION</td> | <td>FOR_DONATION</td> | ||
<td> | <td> | ||
Line 322: | Line 412: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>6.</td> | ||
<td>COLLECTION_METHOD</td> | <td>COLLECTION_METHOD</td> | ||
<td> | <td> | ||
Line 345: | Line 436: | ||
<p>24 = Micro-TESE</p> | <p>24 = Micro-TESE</p> | ||
<p> </p> | <p> </p> | ||
− | <em>Please note that only one ID referring to sample collection method | + | <em>Please note that only one ID referring to sample collection method should be chosen.</em></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>7.</td> | ||
<td>COLLECTION_PLACE</td> | <td>COLLECTION_PLACE</td> | ||
<td> | <td> | ||
Line 355: | Line 447: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>8.</td> | ||
<td>COLLECTION_DIFFICULTIES</td> | <td>COLLECTION_DIFFICULTIES</td> | ||
<td>Sample collection difficulties (200 characters)</td> | <td>Sample collection difficulties (200 characters)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>9.</td> | ||
<td>ABS_PERIOD</td> | <td>ABS_PERIOD</td> | ||
<td>Abstinence period [days] (Integer)</td> | <td>Abstinence period [days] (Integer)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>10.</td> | ||
<td>ANALYSIS_START</td> | <td>ANALYSIS_START</td> | ||
<td> | <td> | ||
Line 370: | Line 465: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>11.</td> | ||
<td>ANALYSED_BY</td> | <td>ANALYSED_BY</td> | ||
<td> | <td> | ||
− | <p> | + | <p>Username of the staff performing the sperm sample analysis (113 characters)</p> |
<p> </p> | <p> </p> | ||
− | <em> | + | <em>These usernames must be inserted in the system from MedITEX Administration.<br /></em></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>12.</td> | ||
<td>APPEARANCE</td> | <td>APPEARANCE</td> | ||
<td> | <td> | ||
Line 395: | Line 492: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>13.</td> | ||
<td>SMELL</td> | <td>SMELL</td> | ||
<td> | <td> | ||
Line 403: | Line 501: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>14.</td> | ||
<td>VISCOSITY</td> | <td>VISCOSITY</td> | ||
<td> | <td> | ||
Line 411: | Line 510: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>15.</td> | ||
<td>LIQQUEFACTION_TIME</td> | <td>LIQQUEFACTION_TIME</td> | ||
<td>Sperm sample liquefaction time [minutes] (Integer)</td> | <td>Sperm sample liquefaction time [minutes] (Integer)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>16.</td> | ||
<td>AGGLUTINATION</td> | <td>AGGLUTINATION</td> | ||
<td> | <td> | ||
Line 422: | Line 523: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>17.</td> | ||
<td>TREATMENT</td> | <td>TREATMENT</td> | ||
<td>Sperm treatment (200 characters)</td> | <td>Sperm treatment (200 characters)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>18.</td> | ||
<td>SCORE</td> | <td>SCORE</td> | ||
<td>Sperm sample score (10 characters)</td> | <td>Sperm sample score (10 characters)</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>19.</td> | ||
<td>NA_VOLUME</td> | <td>NA_VOLUME</td> | ||
<td>Native sperm sample volume in [ml] (Decimal(4,2))</td> | <td>Native sperm sample volume in [ml] (Decimal(4,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>20.</td> | ||
<td>NA_PH</td> | <td>NA_PH</td> | ||
<td>Native sperm sample PH (Decimal(4,2))</td> | <td>Native sperm sample PH (Decimal(4,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>21.</td> | ||
<td>NA_CONCENTRATION</td> | <td>NA_CONCENTRATION</td> | ||
<td>Native sperm sample concentration [Mio/ml] (Decimal(5,3))</td> | <td>Native sperm sample concentration [Mio/ml] (Decimal(5,3))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>22.</td> | ||
<td>NA_VITALITY</td> | <td>NA_VITALITY</td> | ||
<td>Native sperm sample vitality [%] (Decimal(5,2))</td> | <td>Native sperm sample vitality [%] (Decimal(5,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>23.</td> | ||
<td>NA_LEUCOCYTES</td> | <td>NA_LEUCOCYTES</td> | ||
<td>Native sperm sample leucocytes [Mio/ml] (Decimal(9,4))</td> | <td>Native sperm sample leucocytes [Mio/ml] (Decimal(9,4))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>24.</td> | ||
<td>NA_ROUND_CELLS</td> | <td>NA_ROUND_CELLS</td> | ||
<td>Native sperm sample round cells [Mio/ml] (Decimal(9,2))</td> | <td>Native sperm sample round cells [Mio/ml] (Decimal(9,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>25.</td> | ||
<td>NA_QUANTIFICATION</td> | <td>NA_QUANTIFICATION</td> | ||
<td> | <td> | ||
Line 461: | Line 571: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>26.</td> | ||
<td>NA_PEROXIDASE</td> | <td>NA_PEROXIDASE</td> | ||
<td>Native sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2)) </td> | <td>Native sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2)) </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>27.</td> | ||
<td>NA_IMMUNOBEAD</td> | <td>NA_IMMUNOBEAD</td> | ||
<td>Native sperm sample immunobead test [% adherent] (Decimal(5,2))</td> | <td>Native sperm sample immunobead test [% adherent] (Decimal(5,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>28.</td> | ||
<td>NA_MAR</td> | <td>NA_MAR</td> | ||
<td>Native sperm sample MAR test [% adherent] (Decimal(5,2))</td> | <td>Native sperm sample MAR test [% adherent] (Decimal(5,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>29.</td> | ||
<td>NA_MAR_IGG</td> | <td>NA_MAR_IGG</td> | ||
<td>Native sperm sample MAR test - IgG [%] (Decimal(5,2))</td> | <td>Native sperm sample MAR test - IgG [%] (Decimal(5,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>30.</td> | ||
<td>NA_MAR_IGA</td> | <td>NA_MAR_IGA</td> | ||
<td>Native sperm sample MAR test - IgA [%] (Decimal(5,2))</td> | <td>Native sperm sample MAR test - IgA [%] (Decimal(5,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>31.</td> | ||
<td>NA_WHO_AB</td> | <td>NA_WHO_AB</td> | ||
<td>Native sperm sample WHO AB [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample WHO AB [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>32.</td> | ||
<td>NA_WHO_C</td> | <td>NA_WHO_C</td> | ||
<td>Native sperm sample WHO C [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample WHO C [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>33.</td> | ||
<td>NA_WHO_D</td> | <td>NA_WHO_D</td> | ||
<td>Native sperm sample WHO D [%] (Decimal(5,2)) </td> | <td>Native sperm sample WHO D [%] (Decimal(5,2)) </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>34.</td> | ||
<td>NA_NORMAL_FORMS</td> | <td>NA_NORMAL_FORMS</td> | ||
<td>Native sperm sample normal forms [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample normal forms [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>35.</td> | ||
<td>NA_HEAD_DEF</td> | <td>NA_HEAD_DEF</td> | ||
<td>Native sperm sample head defects [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample head defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>36.</td> | ||
<td>NA_NECK_MID_DEF</td> | <td>NA_NECK_MID_DEF</td> | ||
<td>Native sperm sample neck and midpiece defects [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample neck and midpiece defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>37.</td> | ||
<td>NA_TAIL_DEF</td> | <td>NA_TAIL_DEF</td> | ||
<td>Native sperm sample tail defects [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample tail defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>38.</td> | ||
<td>NA_ERC</td> | <td>NA_ERC</td> | ||
<td>Native sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>39.</td> | ||
<td>NA_MULT_DEF</td> | <td>NA_MULT_DEF</td> | ||
<td>Native sperm sample multiple defects [%] (Decimal(5,2))<br /></td> | <td>Native sperm sample multiple defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>40.</td> | ||
<td>NA_TZI</td> | <td>NA_TZI</td> | ||
<td>Native sperm sample teratozoospermia index TZI (Decimal(5,2))<br /></td> | <td>Native sperm sample teratozoospermia index TZI (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>41.</td> | ||
<td>AP_VOLUME</td> | <td>AP_VOLUME</td> | ||
<td>After preparation, sperm sample volume in [ml] (Decimal(4,2))<br /></td> | <td>After preparation, sperm sample volume in [ml] (Decimal(4,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>42.</td> | ||
<td>AP_CONCENTRATION</td> | <td>AP_CONCENTRATION</td> | ||
<td>After preparation, sperm sample concentration [Mio/ml] (Decimal(5,3))<br /></td> | <td>After preparation, sperm sample concentration [Mio/ml] (Decimal(5,3))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td> | ||
+ | <p>43.</p> | ||
+ | </td> | ||
<td>AP_VITALITY</td> | <td>AP_VITALITY</td> | ||
<td>After preparation, sperm sample vitality [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample vitality [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>44.</td> | ||
<td>AP_LEUCOCYTES</td> | <td>AP_LEUCOCYTES</td> | ||
<td>After preparation, sperm sample leucocytes [Mio/ml] (Decimal(9,4))<br /></td> | <td>After preparation, sperm sample leucocytes [Mio/ml] (Decimal(9,4))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>45.</td> | ||
<td>AP_ROUND_CELLS</td> | <td>AP_ROUND_CELLS</td> | ||
<td>After preparation, sperm sample round cells [Mio/ml] (Decimal(9,2))<br /></td> | <td>After preparation, sperm sample round cells [Mio/ml] (Decimal(9,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>46.</td> | ||
<td>AP_QUANTIFICATION</td> | <td>AP_QUANTIFICATION</td> | ||
<td> | <td> | ||
Line 549: | Line 682: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>47.</td> | ||
<td>AP_ICSI</td> | <td>AP_ICSI</td> | ||
<td> | <td> | ||
Line 559: | Line 693: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>48.</td> | ||
<td>AP_PEROXIDASE</td> | <td>AP_PEROXIDASE</td> | ||
<td>After preparation, sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>49</td> | ||
<td>AP_IMMUNOBEAD</td> | <td>AP_IMMUNOBEAD</td> | ||
<td>After preparation, sperm sample immunobead test [% adherent] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample immunobead test [% adherent] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>50.</td> | ||
<td>AP_MAR</td> | <td>AP_MAR</td> | ||
<td>After preparation, sperm sample MAR test [% adherent] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample MAR test [% adherent] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>51.</td> | ||
<td>AP_MAR_IGG</td> | <td>AP_MAR_IGG</td> | ||
<td>After preparation, sperm sample MAR test - IgG [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample MAR test - IgG [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>52.</td> | ||
<td>AP_MAR_IGA</td> | <td>AP_MAR_IGA</td> | ||
<td>After preparation, sperm sample MAR test - IgA [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample MAR test - IgA [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>53.</td> | ||
<td>AP_WHO_AB</td> | <td>AP_WHO_AB</td> | ||
<td>After preparation, sperm sample WHO AB [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample WHO AB [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>54.</td> | ||
<td>AP_WHO_C</td> | <td>AP_WHO_C</td> | ||
<td>After preparation, sperm sample WHO C [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample WHO C [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>55.</td> | ||
<td>AP_WHO_D</td> | <td>AP_WHO_D</td> | ||
<td>After preparation, sperm sample WHO D [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample WHO D [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>56.</td> | ||
<td>AP_NORMAL_FORMS</td> | <td>AP_NORMAL_FORMS</td> | ||
<td>After preparation, sperm sample normal forms [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample normal forms [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>57.</td> | ||
<td>AP_HEAD_DEF</td> | <td>AP_HEAD_DEF</td> | ||
<td>After preparation, sperm sample head defects [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample head defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>58.</td> | ||
<td>AP_NECK_MID_DEF</td> | <td>AP_NECK_MID_DEF</td> | ||
<td>After preparation, sperm sample neck and midpiece defects [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample neck and midpiece defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td> | ||
+ | <p>59.</p> | ||
+ | </td> | ||
<td>AP_TAIL_DEF</td> | <td>AP_TAIL_DEF</td> | ||
<td>After preparation, sperm sample tail defects [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample tail defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>60.</td> | ||
<td>AP_ERC</td> | <td>AP_ERC</td> | ||
<td>After preparation, sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>61.</td> | ||
<td>AP_MULT_DEF</td> | <td>AP_MULT_DEF</td> | ||
<td>After preparation, sperm sample multiple defects [%] (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample multiple defects [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>62.</td> | ||
<td>AP_TZI</td> | <td>AP_TZI</td> | ||
<td>After preparation, sperm sample teratozoospermia index TZI (Decimal(5,2))<br /></td> | <td>After preparation, sperm sample teratozoospermia index TZI (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>63.</td> | ||
<td>PREP_DATE</td> | <td>PREP_DATE</td> | ||
<td> | <td> | ||
Line 626: | Line 778: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>64.</td> | ||
<td>PREP_BY</td> | <td>PREP_BY</td> | ||
<td> | <td> | ||
Line 633: | Line 786: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>65.</td> | ||
<td>PREP_METHOD</td> | <td>PREP_METHOD</td> | ||
<td> | <td> | ||
Line 657: | Line 811: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>66.</td> | ||
<td>DNA_FRAG</td> | <td>DNA_FRAG</td> | ||
<td>Sperm sample DNA fragmented [%] (Decimal(5,2))<br /></td> | <td>Sperm sample DNA fragmented [%] (Decimal(5,2))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>67.</td> | ||
<td>DIAGNOSIS</td> | <td>DIAGNOSIS</td> | ||
<td> | <td> | ||
Line 699: | Line 855: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>68.</td> | ||
<td>FINDING</td> | <td>FINDING</td> | ||
<td> | <td> | ||
Line 706: | Line 863: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>69.</td> | ||
<td>TIME_COLL_USAGE</td> | <td>TIME_COLL_USAGE</td> | ||
<td> | <td> | ||
Line 713: | Line 871: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td> | ||
+ | <p>70.</p> | ||
+ | </td> | ||
<td>NO_MOT_SPERM_INSEM</td> | <td>NO_MOT_SPERM_INSEM</td> | ||
<td>Number of motile sperms inseminated [Mio.] (Decimal(9,2))</td> | <td>Number of motile sperms inseminated [Mio.] (Decimal(9,2))</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>71.</td> | ||
<td>NOTE</td> | <td>NOTE</td> | ||
<td>Semen analysis note (500 characters)<br /></td> | <td>Semen analysis note (500 characters)<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>72.</td> | ||
<td>VOL_INSEM</td> | <td>VOL_INSEM</td> | ||
<td>Volume inseminated [ml] (Decimal(9,3))<br /></td> | <td>Volume inseminated [ml] (Decimal(9,3))<br /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
+ | <td>73.</td> | ||
<td>24H_MOT</td> | <td>24H_MOT</td> | ||
<td>Sperm sample 24h motility rate[%](Decimal(5,2))<br /></td> | <td>Sperm sample 24h motility rate[%](Decimal(5,2))<br /></td> | ||
Line 831: | Line 995: | ||
<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> | ||
Line 843: | Line 1,007: | ||
</table> | </table> | ||
<p style="text-align: left;"> </p> | <p style="text-align: left;"> </p> | ||
+ | <h2>Referrers Import</h2> | ||
+ | <p>An import file which is a list in Excel or CSV format where each line is ONE referrer should be preparred for this purpose.</p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td><img src="/images/plus48.png" alt="" width="48" height="48" /></td> | ||
+ | <td> | ||
+ | <p><a href="/images/ReferrersImport.xlsx">Click here</a> to download an example of Referrers import file.</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <p>The structure of this file is described in the table below: </p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td align="center"><strong> </strong></td> | ||
+ | <td align="center"><strong> Column name</strong></td> | ||
+ | <td align="center"><strong> Column content</strong></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">1.</td> | ||
+ | <td style="text-align: left;" align="center">SURNAME</td> | ||
+ | <td style="text-align: left;" align="center">Referrer surname (50 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">2.</td> | ||
+ | <td style="text-align: left;" align="center">FIRSTNAME</td> | ||
+ | <td style="text-align: left;" align="center">Referrer first name (50 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">3.</td> | ||
+ | <td style="text-align: left;" align="center">TITLE</td> | ||
+ | <td style="text-align: left;" align="center">Referrer title (20 characters)<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">4.</td> | ||
+ | <td style="text-align: left;" align="center">DOB<br /></td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Referrer date of birth (Date)</p> | ||
+ | <p><em>Preferred format: dd.mm.yyyy</em></p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">5.</td> | ||
+ | <td style="text-align: left;" align="center">SPECIALISATION<br /></td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Referrer specialisation (265 characters)</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">6.</td> | ||
+ | <td style="text-align: left;" align="center">SALUTATION_AS</td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Referrer salutation as (Integer)</p> | ||
+ | <p>1: GP</p> | ||
+ | <p>2: JP</p> | ||
+ | <p>3: Male doctor</p> | ||
+ | <p>4: Female doctor</p> | ||
+ | <p>5: MCC</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">7.</td> | ||
+ | <td style="text-align: left;" align="center">STREET</td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Referrer address: street and no. (100 characters)</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">8.</td> | ||
+ | <td style="text-align: left;" align="center">POSTCODE</td> | ||
+ | <td style="text-align: left;" align="center">Referrer address: postcode (8 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">9.</td> | ||
+ | <td style="text-align: left;" align="center">CITY</td> | ||
+ | <td style="text-align: left;" align="center">Referrer address: city (50 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">10.</td> | ||
+ | <td style="text-align: left;" align="center">PHONE</td> | ||
+ | <td style="text-align: left;" align="center">Referrer phone number (40 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">11.</td> | ||
+ | <td style="text-align: left;" align="center">FAX</td> | ||
+ | <td style="text-align: left;" align="center">Referrer fax (40 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">12.</td> | ||
+ | <td style="text-align: left;" align="center">EMAIL</td> | ||
+ | <td style="text-align: left;" align="center">Referrer email (100 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">13.</td> | ||
+ | <td style="text-align: left;" align="center">REFERRER_CODE</td> | ||
+ | <td style="text-align: left;" align="center">Referrer code (30 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">14.</td> | ||
+ | <td style="text-align: left;" align="center">NOTE</td> | ||
+ | <td style="text-align: left;" align="center">Referrer note (500 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">15.</td> | ||
+ | <td style="text-align: left;" align="center">ADDRESS_SALUTATION</td> | ||
+ | <td style="text-align: left;" align="center">Referrer salutations of address (200 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">16.</td> | ||
+ | <td style="text-align: left;" align="center">LETTER_SALUTATION</td> | ||
+ | <td style="text-align: left;" align="center">Referrer salutations for letter (200 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">17.</td> | ||
+ | <td style="text-align: left;" align="center">REFERRER_CLINIC_NAME</td> | ||
+ | <td style="text-align: left;" align="center">Referrer clinic name (100 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">18.</td> | ||
+ | <td style="text-align: left;" align="center">REFERRER_CLINIC_CODE</td> | ||
+ | <td style="text-align: left;" align="center">Referrer clinic code (25 characters)</td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td><img src="/images/hint129.png" alt="" width="129" height="129" /></td> | ||
+ | <td> | ||
+ | <ul> | ||
+ | <li>Not all fields are required;</li> | ||
+ | <li>Mandatory fields are: | ||
+ | <ul> | ||
+ | <li>SURNAME</li> | ||
+ | <li>FIRSTNAME</li> | ||
+ | <li>REFERRER_CODE</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | </ul> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p style="text-align: left;"> </p> | ||
+ | <h2>Historical Notes Import</h2> | ||
+ | <p>An import file which is a list in Excel or CSV format where each line is ONE historical note should be preparred for this purpose.</p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td><img src="/images/plus48.png" alt="" width="48" height="48" /></td> | ||
+ | <td> | ||
+ | <p><a href="/images/History_Notes.xls">Click here</a> to download an example of Referrers import file.</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <p>The following elements should be included in this file:</p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td align="center"><strong> </strong></td> | ||
+ | <td align="center"><strong> Column name</strong></td> | ||
+ | <td align="center"><strong> Column content</strong></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">1.</td> | ||
+ | <td style="text-align: left;" align="center">PATIENT_ID<br /></td> | ||
+ | <td style="text-align: left;" align="center">Patient ID (64 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">2.</td> | ||
+ | <td style="text-align: left;" align="center">START<br /></td> | ||
+ | <td style="text-align: left;" align="center">Start date (Date)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">3.</td> | ||
+ | <td style="text-align: left;" align="center">END<br /></td> | ||
+ | <td style="text-align: left;" align="center">End date (Date)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">4.</td> | ||
+ | <td style="text-align: left;" align="center">BY<br /></td> | ||
+ | <td style="text-align: left;" align="center">Username of the staff member that should be linked (31 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">5.</td> | ||
+ | <td style="text-align: left;" align="center">STATUS<br /></td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Status (Integer)</p> | ||
+ | <p>0 or emtpy = No status</p> | ||
+ | <p>1 = Normal</p> | ||
+ | <p>2 = Abnormal</p> | ||
+ | <br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">6.</td> | ||
+ | <td style="text-align: left;" align="center">ALERT<br /></td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Alert (Integer)</p> | ||
+ | <p>An entry set as Alert will pop-up when the patient is opened.</p> | ||
+ | <p>0 or emtpy = Not an alert</p> | ||
+ | <p>1 = Alert</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">7.</td> | ||
+ | <td style="text-align: left;" align="center">CONFIDENTIAL<br /></td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Confidential (Integer)</p> | ||
+ | <p>An entry set as Confidential can only be visible/editable by staff that have access to seeing confidential entries. This setting is set by administrators per user.</p> | ||
+ | <p>0 or emtpy = Not confidential</p> | ||
+ | <p>1 = Confidential</p> | ||
+ | <p><em>Confidential entries can ONLY be set for AREA = 9.</em></p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">8.</td> | ||
+ | <td style="text-align: left;" align="center">AREA<br /></td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Area where the historical note is visible (Integer)</p> | ||
+ | <p>9 = Medical history section</p> | ||
+ | <p>10 = Demographics section</p> | ||
+ | <p>11 = Examinations section</p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">9.</td> | ||
+ | <td style="text-align: left;" align="center">NAME<br /></td> | ||
+ | <td style="text-align: left;" align="center">Name of the entry related with the AREA above (50 characters)</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">10.</td> | ||
+ | <td style="text-align: left;" align="center">NOTE<br /></td> | ||
+ | <td style="text-align: left;" align="center">Text that should be displayed in this note. (unlimited)<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">11.</td> | ||
+ | <td style="text-align: left;" align="center">APPROVAL<br /></td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Approval status (Integer)</p> | ||
+ | <p>Emtpy = no status</p> | ||
+ | <p>0 = Attention</p> | ||
+ | 1 = Approved<br /></td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">12.</td> | ||
+ | <td style="text-align: left;" align="center">ATTENTION</td> | ||
+ | <td style="text-align: left;" align="center"> | ||
+ | <p>Username of the staff member that should be linked as attention (31 characters)</p> | ||
+ | <p><em>Can be emtpy, but should only be filled when APPROVAL = 0.</em></p> | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td align="center">13.</td> | ||
+ | <td style="text-align: left;" align="center">COMMENT</td> | ||
+ | <td style="text-align: left;" align="center">Text that can be inserted as part of the approval (255 characters)</td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
+ | <tbody> | ||
+ | <tr> | ||
+ | <td><img src="/images/hint129.png" alt="" width="129" height="129" /></td> | ||
+ | <td> | ||
+ | <ul> | ||
+ | <li>Not all fields are required;</li> | ||
+ | <li>Mandatory fields are: | ||
+ | <ul> | ||
+ | <li>PATIENT_ID</li> | ||
+ | <li>START</li> | ||
+ | <li>AREA</li> | ||
+ | <li>NAME</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | </ul> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </tbody> | ||
+ | </table> | ||
+ | <p> </p> | ||
+ | <p> </p> | ||
<table style="float: right;" border="0"> | <table style="float: right;" border="0"> | ||
<tbody> | <tbody> |
Latest revision as of 09:54, 22 August 2023
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.
Contents |
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.xls">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 (64 characters) |
2. | PARTNER_ID |
Partner ID (64 characters) |
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.
<img src="/images/hint129.png" alt="" width="129" height="129" /> |
Required fields are:
|
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.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;
- Each line is one straw. If you have multiple straws for the same patient, these lines must be duplicated in the file.
- 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 (64 characters) |
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 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) |
23. | CONTRACT_NO | Cryo contract number. Used to link the sample with a contract. See below. (100 characters) |
<img src="/images/hint129.png" alt="" width="129" height="129" /> |
Required fields are:
|
Cryo contracts
In the case a <a href="/index.php?title=How_to_create_a_new_cryo_contract%3F">cryo contract</a> needs to be imported for the samples, an additional file is required.
This file will contain the different contracts that are available for each patient. Samples are then linked with each contract, using field 23 from the sample specification above.
<img src="/images/plus48.png" alt="" width="48" height="48" /> |
<a href="/images/Cryo_Contracts.xls">Click here</a> to download an example of Cryo contract import file. |
The following elements/conditions should be included in the import file:
Column name | Column content | |
1. | PATIENT ID |
Patient ID number (64 characters) |
2. | CONTRACT_NO |
Number of the cryo contract (100 characters) |
3. | CONTRACT_START |
Date when contract starts (Date) |
4. | CONTRACT_EXPIRY |
Date when contract expires (Date) |
5. | CONTRACT_NAME |
Name of the contract (100 characters) |
6. | CONTRACT_ACTIVE |
If contract is still active or if it is terminated. 1 = Active, 0 = Terminated (Integer) |
7. | CONTRACT_NEXT_INVOICE |
Date of next invoice (Date) |
<img src="/images/hint129.png" alt="" width="129" height="129" /> |
Before this import can take place, Cryo contracts need to be configured in the system settings: <a href="/index.php?title=MedITEX_IVF_Settings#Cryo_contracts_and_accounting">click here</a> for more information. Required fields are:
|
Semen analyses import
An import file should be prepared as a list where each line will represent ONE complete semen analysis.
<img src="/images/plus48.png" alt="" width="48" height="48" /> |
<a href="/images/Semen_Analysis_Import.xlsx">Click here</a> to download an example of Semen analysus import file. |
Before importing, it is important to know that:
- 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 semen analysis information for the correct patient. It is important to know that Patient ID must be unique;
- The staff must be inserted in the system in order to properly assign them in the appropriate fields of the semen analysis.
The following elements/conditions could be included in the import file:
1. | PATIENT_ID | Patient ID number (Integer) |
2. | SAMPLE_ID | Sample ID number (64 caracters) |
3. | COLLECTION_DATE |
Date of sperm collection (Date) Preferred format: dd.mm.yyyy hh:mm |
4. | PURPOSE |
Purpose of sample collection (128 characters) 0 = Semen analysis, diagnostics 1 = IVF 2 = ICSI 3 = Insemination 4 = Cryopreservation 5 = Control 6 = IMSI 7 = IVM 8 = Fertility preservation 9 = PICSI 11 = Other
A sperm sample can have several collection purposes. If it is the case, the purposes’ ID’s should be separated by a “,”. E.g.: 0,3,8,11 |
5. | FOR_DONATION |
If the sample is marked for donation (Boolean) 0 = No 1 = Yes |
6. | COLLECTION_METHOD |
Method of sample collection (Integer) 0 = Not specified 1 = antegrade ejaculation 2 = retrograde ejaculation 3 = Cryo sperm 4 = MESA 5 = frozen/thawed MESA 6 = PESA 7 = frozen/thawed PESA 8 = TESE 9 = frozen/thawed TESE 10 = Electrostimulation 11 = Spermatocele 12 = Donor 13 = TESA 14 = frozen/thawed TESA 15 = ESA 16 = frozen/thawed ESA 23 = Micro-TESA 24 = Micro-TESE Please note that only one ID referring to sample collection method should be chosen. |
7. | COLLECTION_PLACE |
Place of sample collection (Integer) 1 = At home 2 = At clinic |
8. | COLLECTION_DIFFICULTIES | Sample collection difficulties (200 characters) |
9. | ABS_PERIOD | Abstinence period [days] (Integer) |
10. | ANALYSIS_START |
Analysis start time (Time) Format: hh:mm:ss |
11. | ANALYSED_BY |
Username of the staff performing the sperm sample analysis (113 characters) These usernames must be inserted in the system from MedITEX Administration. |
12. | APPEARANCE |
Sperm sample appearance (128 characters) 0 = Not specified 1 = Normal 2 = Transparent 3 = Flocculent 4 = Yellowish 5 = Hemospermia 6 = Colloidal particles 7 = Colloidal plaque 8 = Debris
A sperm sample can have several appearances. If it is the case, the appearances’ ID’s should be separated by a “,”. E.g.: 0,3,5,8 |
13. | SMELL |
Sperm sample smell (Integer) 1 = Typical 2 = Foul 3 = Other |
14. | VISCOSITY |
Sperm sample viscosity (Integer) 0 = Normal 1 = Increased 2 = Lowered |
15. | LIQQUEFACTION_TIME | Sperm sample liquefaction time [minutes] (Integer) |
16. | AGGLUTINATION |
Sperm agglutination (Boolean) 0 = No 1 = Yes |
17. | TREATMENT | Sperm treatment (200 characters) |
18. | SCORE | Sperm sample score (10 characters) |
19. | NA_VOLUME | Native sperm sample volume in [ml] (Decimal(4,2)) |
20. | NA_PH | Native sperm sample PH (Decimal(4,2)) |
21. | NA_CONCENTRATION | Native sperm sample concentration [Mio/ml] (Decimal(5,3)) |
22. | NA_VITALITY | Native sperm sample vitality [%] (Decimal(5,2)) |
23. | NA_LEUCOCYTES | Native sperm sample leucocytes [Mio/ml] (Decimal(9,4)) |
24. | NA_ROUND_CELLS | Native sperm sample round cells [Mio/ml] (Decimal(9,2)) |
25. | NA_QUANTIFICATION |
If native sperm sample quantification is possible (Integer) 1 = Yes 2 = No |
26. | NA_PEROXIDASE | Native sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2)) |
27. | NA_IMMUNOBEAD | Native sperm sample immunobead test [% adherent] (Decimal(5,2)) |
28. | NA_MAR | Native sperm sample MAR test [% adherent] (Decimal(5,2)) |
29. | NA_MAR_IGG | Native sperm sample MAR test - IgG [%] (Decimal(5,2)) |
30. | NA_MAR_IGA | Native sperm sample MAR test - IgA [%] (Decimal(5,2)) |
31. | NA_WHO_AB | Native sperm sample WHO AB [%] (Decimal(5,2)) |
32. | NA_WHO_C | Native sperm sample WHO C [%] (Decimal(5,2)) |
33. | NA_WHO_D | Native sperm sample WHO D [%] (Decimal(5,2)) |
34. | NA_NORMAL_FORMS | Native sperm sample normal forms [%] (Decimal(5,2)) |
35. | NA_HEAD_DEF | Native sperm sample head defects [%] (Decimal(5,2)) |
36. | NA_NECK_MID_DEF | Native sperm sample neck and midpiece defects [%] (Decimal(5,2)) |
37. | NA_TAIL_DEF | Native sperm sample tail defects [%] (Decimal(5,2)) |
38. | NA_ERC | Native sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2)) |
39. | NA_MULT_DEF | Native sperm sample multiple defects [%] (Decimal(5,2)) |
40. | NA_TZI | Native sperm sample teratozoospermia index TZI (Decimal(5,2)) |
41. | AP_VOLUME | After preparation, sperm sample volume in [ml] (Decimal(4,2)) |
42. | AP_CONCENTRATION | After preparation, sperm sample concentration [Mio/ml] (Decimal(5,3)) |
43. |
AP_VITALITY | After preparation, sperm sample vitality [%] (Decimal(5,2)) |
44. | AP_LEUCOCYTES | After preparation, sperm sample leucocytes [Mio/ml] (Decimal(9,4)) |
45. | AP_ROUND_CELLS | After preparation, sperm sample round cells [Mio/ml] (Decimal(9,2)) |
46. | AP_QUANTIFICATION |
After preparation, if sperm sample quantification is possible (Integer) 0 = Not specified 1 = Yes 2 = No |
47. | AP_ICSI |
After preparation, if ICSI is possible (Integer) 0 = Not specified 1 = Yes 2 = No This should only be filled if the previous quantification was NOT possible. |
48. | AP_PEROXIDASE | After preparation, sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2)) |
49 | AP_IMMUNOBEAD | After preparation, sperm sample immunobead test [% adherent] (Decimal(5,2)) |
50. | AP_MAR | After preparation, sperm sample MAR test [% adherent] (Decimal(5,2)) |
51. | AP_MAR_IGG | After preparation, sperm sample MAR test - IgG [%] (Decimal(5,2)) |
52. | AP_MAR_IGA | After preparation, sperm sample MAR test - IgA [%] (Decimal(5,2)) |
53. | AP_WHO_AB | After preparation, sperm sample WHO AB [%] (Decimal(5,2)) |
54. | AP_WHO_C | After preparation, sperm sample WHO C [%] (Decimal(5,2)) |
55. | AP_WHO_D | After preparation, sperm sample WHO D [%] (Decimal(5,2)) |
56. | AP_NORMAL_FORMS | After preparation, sperm sample normal forms [%] (Decimal(5,2)) |
57. | AP_HEAD_DEF | After preparation, sperm sample head defects [%] (Decimal(5,2)) |
58. | AP_NECK_MID_DEF | After preparation, sperm sample neck and midpiece defects [%] (Decimal(5,2)) |
59. |
AP_TAIL_DEF | After preparation, sperm sample tail defects [%] (Decimal(5,2)) |
60. | AP_ERC | After preparation, sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2)) |
61. | AP_MULT_DEF | After preparation, sperm sample multiple defects [%] (Decimal(5,2)) |
62. | AP_TZI | After preparation, sperm sample teratozoospermia index TZI (Decimal(5,2)) |
63. | PREP_DATE |
Preparation date of the sperm sample (Date) Preferred format: dd.mm.yyyy hh:mm |
64. | PREP_BY |
Name of the staff performing the sperm sample analysis (113 characters) This will be properly imported once the staff members are inserted in the system. |
65. | PREP_METHOD |
Preparation method of the sperm sample (Integer) 1 = None 2 = Density gradient 3 = Swim-up 4 = Wash / centrifugation 5 = Incubation 6 = Glass wool filtration 7 = Migration / sedimentation 8 = Concentration 9 = Unknown 10 = Other 11 = Mechanical 12 = Enzymatical 13 = Density gradient plus swim-up 14 = Pellet resuspended 15 = MACS
A maximum of 4 methods can be allowed. In case of more than 1 method, the methods’ ID’s should be separated by a “,”. E.g.: 1,3,5,8 |
66. | DNA_FRAG | Sperm sample DNA fragmented [%] (Decimal(5,2)) |
67. | DIAGNOSIS |
Sperm sample diagnosis (128 characters) 1 = Normozoospermia 2 = Aspermia 3 = Azoospermia 4 = Azoospermia obstructive 5 = Azoospermia not obstructive 6 = Oligozoospermia 7 = Asthenozoospermia 8 = Teratozoospermia 9= Hyperzoospermia 10 = OAT I 11 = OAT II 12 = OAT III 13 = Cryptozoospermia 14 = Viskopathy 15 = Necrozoospermia 16 = Globozoospermia 17 = Hypospermia 18 = Haematospermia 19 = Pyospermia 20 = Other 21 = Dispermia lieve 22 = Dispermia moderata 23 = Dispermia severa 24 = Necrospermia 25 = Eiaculazione Retrogada 26 = Aneiaculazione 27 = Anorgasmia 28 = Polyzoospermia 34 = Hyperspermia
A sperm sample can have several diagnoses. If it is the case, the diagnoses ID’s should be separated by a “,”. E.g.: 1,3,10,18 |
68. | FINDING |
Sperm sample diagnosis finding status (Integer) 1 = Normal 2 = Abnormal |
69. | TIME_COLL_USAGE |
Time between sperm sample collection and usage (Time) Format: hh:mm:ss |
70. |
NO_MOT_SPERM_INSEM | Number of motile sperms inseminated [Mio.] (Decimal(9,2)) |
71. | NOTE | Semen analysis note (500 characters) |
72. | VOL_INSEM | Volume inseminated [ml] (Decimal(9,3)) |
73. | 24H_MOT | Sperm sample 24h motility rate[%](Decimal(5,2)) |
<img src="/images/hint129.png" alt="" width="129" height="129" /> |
Mandatory fields are:
|
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" /> |
|
Referrers Import
An import file which is a list in Excel or CSV format where each line is ONE referrer should be preparred for this purpose.
<img src="/images/plus48.png" alt="" width="48" height="48" /> |
<a href="/images/ReferrersImport.xlsx">Click here</a> to download an example of Referrers import file. |
The structure of this file is described in the table below:
Column name | Column content | |
1. | SURNAME | Referrer surname (50 characters) |
2. | FIRSTNAME | Referrer first name (50 characters) |
3. | TITLE | Referrer title (20 characters) |
4. | DOB |
Referrer date of birth (Date) Preferred format: dd.mm.yyyy |
5. | SPECIALISATION |
Referrer specialisation (265 characters) |
6. | SALUTATION_AS |
Referrer salutation as (Integer) 1: GP 2: JP 3: Male doctor 4: Female doctor 5: MCC |
7. | STREET |
Referrer address: street and no. (100 characters) |
8. | POSTCODE | Referrer address: postcode (8 characters) |
9. | CITY | Referrer address: city (50 characters) |
10. | PHONE | Referrer phone number (40 characters) |
11. | FAX | Referrer fax (40 characters) |
12. | Referrer email (100 characters) | |
13. | REFERRER_CODE | Referrer code (30 characters) |
14. | NOTE | Referrer note (500 characters) |
15. | ADDRESS_SALUTATION | Referrer salutations of address (200 characters) |
16. | LETTER_SALUTATION | Referrer salutations for letter (200 characters) |
17. | REFERRER_CLINIC_NAME | Referrer clinic name (100 characters) |
18. | REFERRER_CLINIC_CODE | Referrer clinic code (25 characters) |
<img src="/images/hint129.png" alt="" width="129" height="129" /> |
|
Historical Notes Import
An import file which is a list in Excel or CSV format where each line is ONE historical note should be preparred for this purpose.
<img src="/images/plus48.png" alt="" width="48" height="48" /> |
<a href="/images/History_Notes.xls">Click here</a> to download an example of Referrers import file. |
The following elements should be included in this file:
Column name | Column content | |
1. | PATIENT_ID |
Patient ID (64 characters) |
2. | START |
Start date (Date) |
3. | END |
End date (Date) |
4. | BY |
Username of the staff member that should be linked (31 characters) |
5. | STATUS |
Status (Integer) 0 or emtpy = No status 1 = Normal 2 = Abnormal |
6. | ALERT |
Alert (Integer) An entry set as Alert will pop-up when the patient is opened. 0 or emtpy = Not an alert 1 = Alert |
7. | CONFIDENTIAL |
Confidential (Integer) An entry set as Confidential can only be visible/editable by staff that have access to seeing confidential entries. This setting is set by administrators per user. 0 or emtpy = Not confidential 1 = Confidential Confidential entries can ONLY be set for AREA = 9. |
8. | AREA |
Area where the historical note is visible (Integer) 9 = Medical history section 10 = Demographics section 11 = Examinations section |
9. | NAME |
Name of the entry related with the AREA above (50 characters) |
10. | NOTE |
Text that should be displayed in this note. (unlimited) |
11. | APPROVAL |
Approval status (Integer) Emtpy = no status 0 = Attention 1 = Approved |
12. | ATTENTION |
Username of the staff member that should be linked as attention (31 characters) Can be emtpy, but should only be filled when APPROVAL = 0. |
13. | COMMENT | Text that can be inserted as part of the approval (255 characters) |
<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> |