More Importing Features

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 275: Line 275:
 
<td>
 
<td>
 
<p>Date of sperm collection (Date)</p>
 
<p>Date of sperm collection (Date)</p>
<span style="text-decoration: underline;">Preferred format:</span> dd.mm.yyyy hh:mm</td>
+
<em><span style="text-decoration: underline;">Preferred format:</span> dd.mm.yyyy hh:mm</em></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 293: Line 293:
 
<p>11 = Other</p>
 
<p>11 = Other</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
<p>A sperm sample can have several collection purposes. If it is the case, the purposes&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</p>
+
<p><em>A sperm sample can have several collection purposes. If it is the case, the purposes&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
<strong>E.g.:</strong> 0,3,8,11</td>
+
<em> <strong>E.g.:</strong> 0,3,8,11</em></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 327: Line 327:
 
<p>24 = Micro-TESE</p>
 
<p>24 = Micro-TESE</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
Please note that only one ID referring to sample collection method could be chosen.</td>
+
<em>Please note that only one ID referring to sample collection method could be chosen.</em></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
<td>COLLECTION_PLACE</td>
+
<td><em>COLLECTION_PLACE</em></td>
 
<td>
 
<td>
 
<p>Place of sample collection (Integer)</p>
 
<p>Place of sample collection (Integer)</p>
Line 348: Line 348:
 
<td>
 
<td>
 
<p>Analysis start time (Time)</p>
 
<p>Analysis start time (Time)</p>
<p><span style="text-decoration: underline;">Format:</span> hh:mm:ss</p>
+
<p><em><span style="text-decoration: underline;">Format:</span> hh:mm:ss</em></p>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 356: Line 356:
 
<p>Name of the staff performing the sperm sample analysis (113 characters)</p>
 
<p>Name of the staff performing the sperm sample analysis (113 characters)</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
This will be properly imported once the staff members are inserted in the system.&nbsp;</td>
+
<em>This will be properly imported once the staff members are inserted in the system.&nbsp;</em></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
<td>APPEARANCE</td>
+
<td><em>APPEARANCE</em></td>
 
<td>
 
<td>
 
<p>Sample appearance (128 characters)</p>
 
<p>Sample appearance (128 characters)</p>
Line 372: Line 372:
 
<p>8 = Debris</p>
 
<p>8 = Debris</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
<p>A sperm sample can have several appearances.</p>
+
<p><em>A sperm sample can have several appearances.</em></p>
<p>If it is the case, the appearances&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</p>
+
<p><em>If it is the case, the appearances&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
<strong>E.g.:</strong> 0,3,5,8</td>
+
<em> <strong>E.g.:</strong> 0,3,5,8</em></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 405: Line 405:
 
<tr>
 
<tr>
 
<td>TREATMENT</td>
 
<td>TREATMENT</td>
<td>&nbsp;</td>
+
<td>Sperm treatment (200 characters)</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>SCORE</td>
 
<td>SCORE</td>
<td>&nbsp;</td>
+
<td>Sperm sample score (10 characters)</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_VOLUME</td>
 
<td>NA_VOLUME</td>
<td>&nbsp;</td>
+
<td>Native sperm sample volume in [ml] (Decimal(4,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_PH</td>
 
<td>NA_PH</td>
<td>&nbsp;</td>
+
<td>Native sperm PH (Decimal(4,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_CONCENTRATION</td>
 
<td>NA_CONCENTRATION</td>
<td>&nbsp;</td>
+
<td>Native sperm concentration [Mio/ml] (Decimal(5,3))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_VITALITY</td>
 
<td>NA_VITALITY</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;Vitality [%] (Decimal(5,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_LEUCOCYTES</td>
 
<td>NA_LEUCOCYTES</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;leucocytes [Mio/ml] (Decimal(9,4))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_ROUND_CELLS</td>
 
<td>NA_ROUND_CELLS</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;round cells [Mio/ml] (Decimal(9,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_QUANTIFICATION</td>
 
<td>NA_QUANTIFICATION</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;quantification possibility (Integer)
 +
<p>0 = Not specified</p>
 +
<p>1 = Yes</p>
 +
2 = No</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_PEROXIDASE</td>
 
<td>NA_PEROXIDASE</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;peroxidase-positive cells [10^6/ml] (Decimal(5,2))&nbsp;</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_IMMUNOBEAD</td>
 
<td>NA_IMMUNOBEAD</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;immunobead test [% adherent] (Decimal(5,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_MAR</td>
 
<td>NA_MAR</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;MAR test [% adherent] (Decimal(5,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_MAR_IGG</td>
 
<td>NA_MAR_IGG</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;MAR test - IgG [%] (Decimal(5,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_MAR_IGA</td>
 
<td>NA_MAR_IGA</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;MAR test - IgA [%] (Decimal(5,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_WHO_AB</td>
 
<td>NA_WHO_AB</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;WHO AB [%] (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_WHO_C</td>
 
<td>NA_WHO_C</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;WHO C [%]&nbsp; (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_WHO_D</td>
 
<td>NA_WHO_D</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;WHO D [%] (Decimal(5,2))&nbsp;</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_NORMAL_FORMS</td>
 
<td>NA_NORMAL_FORMS</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;normal forms [%] (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_HEAD_DEF</td>
 
<td>NA_HEAD_DEF</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;head defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_NECK_MID_DEF</td>
 
<td>NA_NECK_MID_DEF</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;neck and midpiece defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_TAIL_DEF</td>
 
<td>NA_TAIL_DEF</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;tail defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_ERC</td>
 
<td>NA_ERC</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;excess residual cytoplasm ERC [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_MULT_DEF</td>
 
<td>NA_MULT_DEF</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;multiple defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NA_TZI</td>
 
<td>NA_TZI</td>
<td>&nbsp;</td>
+
<td>Native sperm&nbsp;teratozoospermia index TZI (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_VOLUME</td>
 
<td>AP_VOLUME</td>
<td>&nbsp;</td>
+
<td>After preparation sample volume in [ml] (Decimal(4,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_CONCENTRATION</td>
 
<td>AP_CONCENTRATION</td>
<td>&nbsp;</td>
+
<td>After preparation sample concentration [Mio/ml] (Decimal(5,3))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_VITALITY</td>
 
<td>AP_VITALITY</td>
<td>&nbsp;</td>
+
<td>After preparation sample Vitality [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_LEUCOCYTES</td>
 
<td>AP_LEUCOCYTES</td>
<td>&nbsp;</td>
+
<td>After preparation sample leucocytes [Mio/ml] (Decimal(9,4))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_ROUND_CELLS</td>
 
<td>AP_ROUND_CELLS</td>
<td>&nbsp;</td>
+
<td>After preparation sample round cells [Mio/ml] (Decimal(9,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_QUANTIFICATION</td>
 
<td>AP_QUANTIFICATION</td>
<td>&nbsp;</td>
+
<td>
 +
<p>After preparation, if sample quantification was possible (Integer)</p>
 +
<p>0 = Not specified</p>
 +
<p>1 = Yes</p>
 +
2 = No<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_ICSI</td>
 
<td>AP_ICSI</td>
<td>&nbsp;</td>
+
<td>
 +
<p>After preparation sample ICSI possibility (Integer)</p>
 +
<p>0 = Not specified</p>
 +
<p>1 = Yes</p>
 +
<p>2 = No</p>
 +
<p>&nbsp;</p>
 +
<em>This should only be filled if the previous quantification was NOT possible.</em><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_PEROXIDASE</td>
 
<td>AP_PEROXIDASE</td>
<td>&nbsp;</td>
+
<td>After preparation sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_IMMUNOBEAD</td>
 
<td>AP_IMMUNOBEAD</td>
<td>&nbsp;</td>
+
<td>After preparation sample immunobead test [% adherent] (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_MAR</td>
 
<td>AP_MAR</td>
<td>&nbsp;</td>
+
<td>After preparation sample MAR test [% adherent] (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_MAR_IGG</td>
 
<td>AP_MAR_IGG</td>
<td>&nbsp;</td>
+
<td>After preparation sample MAR test - IgG [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_MAR_IGA</td>
 
<td>AP_MAR_IGA</td>
<td>&nbsp;</td>
+
<td>After preparation sample MAR test - IgA [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_WHO_AB</td>
 
<td>AP_WHO_AB</td>
<td>&nbsp;</td>
+
<td>After preparation sample WHO AB [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_WHO_C</td>
 
<td>AP_WHO_C</td>
<td>&nbsp;</td>
+
<td>After preparation sample WHO C [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_WHO_D</td>
 
<td>AP_WHO_D</td>
<td>&nbsp;</td>
+
<td>After preparation sample WHO D [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_NORMAL_FORMS</td>
 
<td>AP_NORMAL_FORMS</td>
<td>&nbsp;</td>
+
<td>After preparation sample normal forms [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_HEAD_DEF</td>
 
<td>AP_HEAD_DEF</td>
<td>&nbsp;</td>
+
<td>After preparation sample head defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_NECK_MID_DEF</td>
 
<td>AP_NECK_MID_DEF</td>
<td>&nbsp;</td>
+
<td>After preparation sample neck and midpiece defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_TAIL_DEF</td>
 
<td>AP_TAIL_DEF</td>
<td>&nbsp;</td>
+
<td>After preparation sample tail defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_ERC</td>
 
<td>AP_ERC</td>
<td>&nbsp;</td>
+
<td>After preparation sample excess residual cytoplasm ERC [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_MULT_DEF</td>
 
<td>AP_MULT_DEF</td>
<td>&nbsp;</td>
+
<td>After preparation sample multiple defects [%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>AP_TZI</td>
 
<td>AP_TZI</td>
<td>&nbsp;</td>
+
<td>After preparation sample teratozoospermia index TZI (Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>PREP_DATE</td>
 
<td>PREP_DATE</td>
<td>&nbsp;</td>
+
<td>
 +
<p>Preparation date of the sample (Date)</p>
 +
<p>&nbsp;</p>
 +
<p><em><span style="text-decoration: underline;">Preferred format:</span>&nbsp;dd.mm.yyyy hh:mm</em></p>
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>PREP_BY</td>
 
<td>PREP_BY</td>
<td>&nbsp;</td>
+
<td>
 +
<p>Name of the staff performing the sperm sample analysis (113 characters)</p>
 +
<p>&nbsp;</p>
 +
<em>This will be properly imported once the staff members are inserted in the system.</em><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>PREP_METHOD</td>
 
<td>PREP_METHOD</td>
<td>&nbsp;</td>
+
<td>
 +
<p>Preparation method (Integer)</p>
 +
<p>1 = None</p>
 +
<p>2 = Density gradient</p>
 +
<p>3 = Swim-up</p>
 +
<p>4 = Wash / centrifugation</p>
 +
<p>5 = Incubation</p>
 +
<p>6 = Glass wool filtration</p>
 +
<p>7 = Migration / sedimentation</p>
 +
<p>8 = Concentration</p>
 +
<p>9 = Unknown</p>
 +
<p>10 = Other</p>
 +
<p>11 = Mechanical</p>
 +
<p>12 = Enzymatical</p>
 +
<p>13 = Density gradient plus swim-up</p>
 +
<p>14 = Pellet resuspended</p>
 +
<p>15 = MACS</p>
 +
<p>&nbsp;</p>
 +
<p><em>A maximum of 4 methods can be allowed.</em></p>
 +
<p><em>In case of more than 1 method, the methods&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
 +
<em><strong> E.g.:</strong> 1,3,5,8</em><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>DNA_FRAG</td>
 
<td>DNA_FRAG</td>
<td>&nbsp;</td>
+
<td>Sperm sample DNA fragmented [%] (Decimal(5,2))<br /></td>
 +
</tr>
 +
<tr>
 +
<td>DIAGNOSIS</td>
 +
<td>
 +
<p>Sperm sample diagnosis (128 characters)</p>
 +
<p>1 = Normozoospermia</p>
 +
<p>2 = Aspermia</p>
 +
<p>3 = Azoospermia</p>
 +
<p>4 = Azoospermia obstructive</p>
 +
<p>5 = Azoospermia not obstructive</p>
 +
<p>6 = Oligozoospermia</p>
 +
<p>7 = Asthenozoospermia</p>
 +
<p>8 = Teratozoospermia</p>
 +
<p>9= Hyperzoospermia</p>
 +
<p>10 = OAT I</p>
 +
<p>11 = OAT II</p>
 +
<p>12 = OAT III</p>
 +
<p>13 = Cryptozoospermia</p>
 +
<p>14 = Viskopathy</p>
 +
<p>15 = Necrozoospermia</p>
 +
<p>16 = Globozoospermia</p>
 +
<p>17 = Hypospermia</p>
 +
<p>18 = Haematospermia</p>
 +
<p>19 = Pyospermia</p>
 +
<p>20 = Other</p>
 +
<p>21 = Dispermia lieve</p>
 +
<p>22 = Dispermia moderata</p>
 +
<p>23 = Dispermia severa</p>
 +
<p>24 = Necrospermia</p>
 +
<p>25 = Eiaculazione Retrogada</p>
 +
<p>26 = Aneiaculazione</p>
 +
<p>27 = Anorgasmia</p>
 +
<p>28 = Polyzoospermia</p>
 +
<p>34 = Hyperspermia</p>
 +
<p>&nbsp;</p>
 +
<p><em>A sperm sample can have several diagnoses.</em></p>
 +
<p><em>If it is the case, the diagnoses ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
 +
<em><strong> E.g.:</strong> 1,3,10,18</em></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>FINDING</td>
 
<td>FINDING</td>
<td>&nbsp;</td>
+
<td>
 +
<p>Sample diagnosis finding status (Integer)</p>
 +
<p>1 = Normal</p>
 +
2 = Abnormal<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>TIME_COLL_USAGE</td>
 
<td>TIME_COLL_USAGE</td>
<td>&nbsp;</td>
+
<td>
 +
<p>Time between sperm sample collection and usage (Time)</p>
 +
<p><em><span style="text-decoration: underline;">Format:</span> hh:mm:ss</em></p>
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NO_MOT_SPERM_INSEM</td>
 
<td>NO_MOT_SPERM_INSEM</td>
<td>&nbsp;</td>
+
<td>Number of motile sperms inseminated [Mio.] (Decimal(9,2))</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>NOTE</td>
 
<td>NOTE</td>
<td>&nbsp;</td>
+
<td>Semen analysis note (500 characters)<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>VOL_INSEM</td>
 
<td>VOL_INSEM</td>
<td>&nbsp;</td>
+
<td>Volume inseminated [ml] (Decimal(9,3))<br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td>24H_MOT</td>
 
<td>24H_MOT</td>
<td>&nbsp;</td>
+
<td>Sperm sample 24h motility rate[%](Decimal(5,2))<br /></td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
Line 716: Line 800:
 
<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 10:02, 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.

 

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.

<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

Semen analyses Import

 

<tbody> </tbody>
PATIENT_ID Patient ID number (Integer)
SAMPLE_ID Sample ID number (Integer)
COLLECTION_DATE

Date of sperm collection (Date)

Preferred format: dd.mm.yyyy hh:mm
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
FOR_DONATION

If the sample is marked for donation (Boolean)

0 = No

1 = Yes
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 could be chosen.
COLLECTION_PLACE

Place of sample collection (Integer)

1 = At home

2 = At clinic
COLLECTION_DIFFICULTIES Sample collection difficulties (200 characters)
ABS_PERIOD Abstinence period [days] (Integer)
ANALYSIS_START

Analysis start time (Time)

Format: hh:mm:ss

ANALYSED_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. 
APPEARANCE

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
SMELL

Smell of the sperm sample (Integer)

1 = Typical

2 = Foul

3 = Other
VISCOSITY

Viscosity of the sperm sample (Integer)

0 = Normal

1 = Increased

2 = Lowered
LIQQUEFACTION_TIME Sperm sample liquefaction time [minutes] (Integer)
AGGLUTINATION

Sperm agglutination (Boolean)

0 = No

1 = Yes
TREATMENT Sperm treatment (200 characters)
SCORE Sperm sample score (10 characters)
NA_VOLUME Native sperm sample volume in [ml] (Decimal(4,2))
NA_PH Native sperm PH (Decimal(4,2))
NA_CONCENTRATION Native sperm concentration [Mio/ml] (Decimal(5,3))
NA_VITALITY Native sperm Vitality [%] (Decimal(5,2))
NA_LEUCOCYTES Native sperm leucocytes [Mio/ml] (Decimal(9,4))
NA_ROUND_CELLS Native sperm round cells [Mio/ml] (Decimal(9,2))
NA_QUANTIFICATION Native sperm quantification possibility (Integer)

0 = Not specified

1 = Yes

2 = No
NA_PEROXIDASE Native sperm peroxidase-positive cells [10^6/ml] (Decimal(5,2)) 
NA_IMMUNOBEAD Native sperm immunobead test [% adherent] (Decimal(5,2))
NA_MAR Native sperm MAR test [% adherent] (Decimal(5,2))
NA_MAR_IGG Native sperm MAR test - IgG [%] (Decimal(5,2))
NA_MAR_IGA Native sperm MAR test - IgA [%] (Decimal(5,2))
NA_WHO_AB Native sperm WHO AB [%] (Decimal(5,2))
NA_WHO_C Native sperm WHO C [%]  (Decimal(5,2))
NA_WHO_D Native sperm WHO D [%] (Decimal(5,2)) 
NA_NORMAL_FORMS Native sperm normal forms [%] (Decimal(5,2))
NA_HEAD_DEF Native sperm head defects [%](Decimal(5,2))
NA_NECK_MID_DEF Native sperm neck and midpiece defects [%](Decimal(5,2))
NA_TAIL_DEF Native sperm tail defects [%](Decimal(5,2))
NA_ERC Native sperm excess residual cytoplasm ERC [%](Decimal(5,2))
NA_MULT_DEF Native sperm multiple defects [%](Decimal(5,2))
NA_TZI Native sperm teratozoospermia index TZI (Decimal(5,2))
AP_VOLUME After preparation sample volume in [ml] (Decimal(4,2))
AP_CONCENTRATION After preparation sample concentration [Mio/ml] (Decimal(5,3))
AP_VITALITY After preparation sample Vitality [%](Decimal(5,2))
AP_LEUCOCYTES After preparation sample leucocytes [Mio/ml] (Decimal(9,4))
AP_ROUND_CELLS After preparation sample round cells [Mio/ml] (Decimal(9,2))
AP_QUANTIFICATION

After preparation, if sample quantification was possible (Integer)

0 = Not specified

1 = Yes

2 = No
AP_ICSI

After preparation sample ICSI possibility (Integer)

0 = Not specified

1 = Yes

2 = No

 

This should only be filled if the previous quantification was NOT possible.
AP_PEROXIDASE After preparation sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))
AP_IMMUNOBEAD After preparation sample immunobead test [% adherent] (Decimal(5,2))
AP_MAR After preparation sample MAR test [% adherent] (Decimal(5,2))
AP_MAR_IGG After preparation sample MAR test - IgG [%](Decimal(5,2))
AP_MAR_IGA After preparation sample MAR test - IgA [%](Decimal(5,2))
AP_WHO_AB After preparation sample WHO AB [%](Decimal(5,2))
AP_WHO_C After preparation sample WHO C [%](Decimal(5,2))
AP_WHO_D After preparation sample WHO D [%](Decimal(5,2))
AP_NORMAL_FORMS After preparation sample normal forms [%](Decimal(5,2))
AP_HEAD_DEF After preparation sample head defects [%](Decimal(5,2))
AP_NECK_MID_DEF After preparation sample neck and midpiece defects [%](Decimal(5,2))
AP_TAIL_DEF After preparation sample tail defects [%](Decimal(5,2))
AP_ERC After preparation sample excess residual cytoplasm ERC [%](Decimal(5,2))
AP_MULT_DEF After preparation sample multiple defects [%](Decimal(5,2))
AP_TZI After preparation sample teratozoospermia index TZI (Decimal(5,2))
PREP_DATE

Preparation date of the sample (Date)

 

Preferred format: dd.mm.yyyy hh:mm

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

Preparation method (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
DNA_FRAG Sperm sample DNA fragmented [%] (Decimal(5,2))
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
FINDING

Sample diagnosis finding status (Integer)

1 = Normal

2 = Abnormal
TIME_COLL_USAGE

Time between sperm sample collection and usage (Time)

Format: hh:mm:ss

NO_MOT_SPERM_INSEM Number of motile sperms inseminated [Mio.] (Decimal(9,2))
NOTE Semen analysis note (500 characters)
VOL_INSEM Volume inseminated [ml] (Decimal(9,3))
24H_MOT Sperm sample 24h motility rate[%](Decimal(5,2))

 

 

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>