View source for More Importing Features

<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>&nbsp;</p>
<h2>Patient demographics import</h2>
<p>You need to prepare an import file which is a list in Excel or CSV format where each line is ONE patient.</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/Patient_Demographics.xls">Click here</a>&nbsp;to download an example of Patient demographics import file.</p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</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>&nbsp;</strong></td>
<td align="center"><strong>&nbsp;Column name</strong></td>
<td align="center"><strong>&nbsp;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 (Integer)</td>
</tr>
<tr>
<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 number (Integer)</td>
</tr>
<tr>
<td align="center">3.</td>
<td style="text-align: left;" align="center">DOB</td>
<td style="text-align: left;" align="center">Patient date of birth (Date)</td>
</tr>
<tr>
<td align="center">4.</td>
<td style="text-align: left;" align="center">NAME</td>
<td style="text-align: left;" align="center">Patient name (100 characters)</td>
</tr>
<tr>
<td align="center">5.</td>
<td style="text-align: left;" align="center">FIRST_NAME<br /></td>
<td style="text-align: left;" align="center">Patient first name (100 characters)</td>
</tr>
<tr>
<td align="center">6.</td>
<td style="text-align: left;" align="center">GENDER</td>
<td style="text-align: left;" align="center">Patient gender (1 character - W/M)</td>
</tr>
<tr>
<td align="center">7.</td>
<td style="text-align: left;" align="center">POSTCODE</td>
<td style="text-align: left;" align="center">Patient address: postal code (50 characters)<br /></td>
</tr>
<tr>
<td align="center">8.</td>
<td style="text-align: left;" align="center">CITY</td>
<td style="text-align: left;" align="center">Patient address: city (50 characters)<br /></td>
</tr>
<tr>
<td align="center">9.</td>
<td style="text-align: left;" align="center">STREET<br /></td>
<td style="text-align: left;" align="center">Patient address: street (255 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">Patient private phone number (50 characters)<br /></td>
</tr>
<tr>
<td align="center">11.</td>
<td style="text-align: left;" align="center">LOCATION (CLINIC)</td>
<td style="text-align: left;" align="center">The clinic where the patient is located (250 characters)</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>Please make sure that your current <strong>Patient IDs from your existing data are <span style="text-decoration: underline;">unique</span>.</strong></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>Required fields are:</p>
<ul>
<li>PATIENT ID</li>
<li>DOB</li>
<li>NAME</li>
<li>GENDER (W/M)</li>
<li>PARTNER ID (If couples should be linked)</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<h2>Cryo storage import</h2>
<p>It is mandatory to prepare an import file where each line is ONE straw.</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_Storage.xls">Click here</a>&nbsp;to download an example of Cryo storage import file.</p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>Before importing, it is important to know that:</p>
<ul>
<li>The cryo storage dimension must be configured in MedITEX IVF Settings;</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>Type of semen material can be specified in: <strong>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.</strong></li>
</ul>
<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>&nbsp;</strong></td>
<td align="center"><strong>&nbsp;Column name</strong></td>
<td align="center"><strong>&nbsp;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 (Integer)</td>
</tr>
<tr>
<td align="center">2.</td>
<td style="text-align: left;" align="center">COLLECTION_DATE<br /></td>
<td style="text-align: left;" align="center">Date of sperm collection/follicle aspiration (Date)</td>
</tr>
<tr>
<td align="center">3.</td>
<td style="text-align: left;" align="center">FREEZING_DATE<br /></td>
<td style="text-align: left;" align="center">Date of freezing (Date)<br /></td>
</tr>
<tr>
<td align="center">4.</td>
<td style="text-align: left;" align="center">STORAGE_DATE<br /></td>
<td style="text-align: left;" align="center">Date of storage (Date)<br /></td>
</tr>
<tr>
<td align="center">5.</td>
<td style="text-align: left;" align="center">NO_OOCYTES<br /></td>
<td style="text-align: left;" align="center">Total number of collected oocytes (Integer)<br /></td>
</tr>
<tr>
<td align="center">6.</td>
<td style="text-align: left;" align="center">IVF_PNs<br /></td>
<td style="text-align: left;" align="center">Number of PNs after IVF (Integer)<br /></td>
</tr>
<tr>
<td align="center">7.</td>
<td style="text-align: left;" align="center">ICSI_PNs<br /></td>
<td style="text-align: left;" align="center">Number of PNs after ICSI (Integer)<br /></td>
</tr>
<tr>
<td align="center">8.</td>
<td style="text-align: left;" align="center">IVF_EMBs<br /></td>
<td style="text-align: left;" align="center">Number of embryos after IVF (Integer)<br /></td>
</tr>
<tr>
<td align="center">9.</td>
<td style="text-align: left;" align="center">ICSI_EMBs<br /></td>
<td style="text-align: left;" align="center">Number of embryos after ICSI (Integer)<br /></td>
</tr>
<tr>
<td align="center">10.</td>
<td style="text-align: left;" align="center">OVARIAN_TISSUE<br /></td>
<td style="text-align: left;" align="center">Ovarian tissue cryopreservation (OOC/EMB/PN) (0=No, 1=Yes)<br /></td>
</tr>
<tr>
<td align="center">11.</td>
<td style="text-align: left;" align="center">SEMEN_MATERIAL</td>
<td style="text-align: left;" align="center">Type of semen material specification (100 characters)&nbsp; <br /></td>
</tr>
<tr>
<td align="center">12.</td>
<td style="text-align: left;" align="center">STRAW_ID</td>
<td style="text-align: left;" align="center">Straw ID (50 characters)<br /></td>
</tr>
<tr>
<td align="center">13.</td>
<td style="text-align: left;" align="center">CRYO_TECHNIQUE</td>
<td style="text-align: left;" align="center">Cryo technique used (50 characters)<br /></td>
</tr>
<tr>
<td align="center">14. <br /></td>
<td style="text-align: left;" align="center">STORAGE_LOCATION<br /></td>
<td style="text-align: left;" align="center">Storage location description e.g. Container/Tank (128 characters)<br /></td>
</tr>
<tr>
<td align="center">15.</td>
<td style="text-align: left;" align="center">STORAGE_DIM1<br /></td>
<td style="text-align: left;" align="center">Storage dimension e.g. Tank level (128 characters)</td>
</tr>
<tr>
<td align="center">16. <br /></td>
<td style="text-align: left;" align="center">STORAGE_DIM2<br /></td>
<td style="text-align: left;" align="center">Storage dimension e.g. Canister level (128 characters)</td>
</tr>
<tr>
<td align="center">17.</td>
<td style="text-align: left;" align="center">STORAGE_DIM3<br /></td>
<td style="text-align: left;" align="center">Storage dimension e.g. Goblet level (128 characters)</td>
</tr>
<tr>
<td align="center">18.</td>
<td style="text-align: left;" align="center">POSITION</td>
<td style="text-align: left;" align="center">Straw position (10 characters)<br /></td>
</tr>
<tr>
<td align="center">19.</td>
<td style="text-align: left;" align="center">COLOUR1</td>
<td style="text-align: left;" align="center">First color defining the straw (10 characters)<br /></td>
</tr>
<tr>
<td align="center">20.</td>
<td style="text-align: left;" align="center">COLOUR2</td>
<td style="text-align: left;" align="center">Second color defining the straw (10 characters)<br /></td>
</tr>
<tr>
<td align="center">21.</td>
<td style="text-align: left;" align="center">CRYOPRESERVED_BY</td>
<td style="text-align: left;" align="center">Staff responsible of the cryopreservation (100 characters)<br /></td>
</tr>
<tr>
<td align="center">22.</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>
</tr>
</tbody>
</table>
<ul>
</ul>
<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>Required fields are:</p>
<ul>
<li>PATIENT ID</li>
<li>COLLECTION DATE</li>
<li>FREEZING DATE</li>
<li>OVARIAN TISSUE</li>
<li>TYPE OF SEMEN MATERIAL</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>Semen analyses Import</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">
<tbody>
<tr>
<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
<td>
<p><a href="/images/Semen_Analysis_Import.xlsx">Click here</a>&nbsp;to download an example of Semen analysus import file.</p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>Before importing, it is important to know that:</p>
<ul>
<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 semen analysis information for the correct patient. It is important to know that Patient ID must be unique;</li>
<li>The staff must be inserted in the system in order to properly assign them in the appropriate fields of the semen analysis.</li>
</ul>
<p>The following elements/conditions could be included in the import file:</p>
<table border="0">
<tbody>
<tr>
<td>PATIENT_ID</td>
<td>Patient ID number (Integer)</td>
</tr>
<tr>
<td>SAMPLE_ID</td>
<td>Sample ID number (Integer)</td>
</tr>
<tr>
<td>COLLECTION_DATE</td>
<td>
<p>Date of sperm collection (Date)</p>
<em><span style="text-decoration: underline;">Preferred format:</span> dd.mm.yyyy hh:mm</em></td>
</tr>
<tr>
<td>PURPOSE</td>
<td>
<p>Purpose of sample collection (128 characters)</p>
<p>0 = Semen analysis, diagnostics</p>
<p>1 = IVF</p>
<p>2 = ICSI</p>
<p>3 = Insemination</p>
<p>4 = Cryopreservation</p>
<p>5 = Control</p>
<p>6 = IMSI</p>
<p>7 = IVM</p>
<p>8 = Fertility preservation</p>
<p>9 = PICSI</p>
<p>11 = Other</p>
<p>&nbsp;</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>
<em> <strong>E.g.:</strong> 0,3,8,11</em></td>
</tr>
<tr>
<td>FOR_DONATION</td>
<td>
<p>If the sample is marked for donation (Boolean)</p>
<p>0 = No</p>
1 = Yes</td>
</tr>
<tr>
<td>COLLECTION_METHOD</td>
<td>
<p>Method of sample collection (Integer)</p>
<p>0 = Not specified</p>
<p>1 = antegrade ejaculation</p>
<p>2 = retrograde ejaculation</p>
<p>3 = Cryo sperm</p>
<p>4 = MESA</p>
<p>5 = frozen/thawed MESA</p>
<p>6 = PESA</p>
<p>7 = frozen/thawed PESA</p>
<p>8 = TESE</p>
<p>9 = frozen/thawed TESE</p>
<p>10 = Electrostimulation</p>
<p>11 = Spermatocele</p>
<p>12 = Donor</p>
<p>13 = TESA</p>
<p>14 = frozen/thawed TESA</p>
<p>15 = ESA</p>
<p>16 = frozen/thawed ESA</p>
<p>23 = Micro-TESA</p>
<p>24 = Micro-TESE</p>
<p>&nbsp;</p>
<em>Please note that only one ID referring to sample collection method could be chosen.</em></td>
</tr>
<tr>
<td>COLLECTION_PLACE</td>
<td>
<p>Place of sample collection (Integer)</p>
<p>1 = At home</p>
2 = At clinic</td>
</tr>
<tr>
<td>COLLECTION_DIFFICULTIES</td>
<td>Sample collection difficulties (200 characters)</td>
</tr>
<tr>
<td>ABS_PERIOD</td>
<td>Abstinence period [days] (Integer)</td>
</tr>
<tr>
<td>ANALYSIS_START</td>
<td>
<p>Analysis start time (Time)</p>
<p><em><span style="text-decoration: underline;">Format:</span> hh:mm:ss</em></p>
</td>
</tr>
<tr>
<td>ANALYSED_BY</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.&nbsp;</em></td>
</tr>
<tr>
<td>APPEARANCE</td>
<td>
<p>Sperm sample appearance (128 characters)</p>
<p>0 = Not specified</p>
<p>1 = Normal</p>
<p>2 = Transparent</p>
<p>3 = Flocculent</p>
<p>4 = Yellowish</p>
<p>5 = Hemospermia</p>
<p>6 = Colloidal particles</p>
<p>7 = Colloidal plaque</p>
<p>8 = Debris</p>
<p>&nbsp;</p>
<p><em>A sperm sample can have several appearances.</em></p>
<p><em>If it is the case, the appearances&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
<em> <strong>E.g.:</strong> 0,3,5,8</em></td>
</tr>
<tr>
<td>SMELL</td>
<td>
<p>Sperm sample smell (Integer)</p>
<p>1 = Typical</p>
<p>2 = Foul</p>
3 = Other</td>
</tr>
<tr>
<td>VISCOSITY</td>
<td>
<p>Sperm sample viscosity (Integer)</p>
<p>0 = Normal</p>
<p>1 = Increased</p>
2 = Lowered</td>
</tr>
<tr>
<td>LIQQUEFACTION_TIME</td>
<td>Sperm sample liquefaction time [minutes] (Integer)</td>
</tr>
<tr>
<td>AGGLUTINATION</td>
<td>
<p>Sperm agglutination (Boolean)</p>
<p>0 = No</p>
1 = Yes</td>
</tr>
<tr>
<td>TREATMENT</td>
<td>Sperm treatment (200 characters)</td>
</tr>
<tr>
<td>SCORE</td>
<td>Sperm sample score (10 characters)</td>
</tr>
<tr>
<td>NA_VOLUME</td>
<td>Native sperm sample volume in [ml] (Decimal(4,2))</td>
</tr>
<tr>
<td>NA_PH</td>
<td>Native sperm sample PH (Decimal(4,2))</td>
</tr>
<tr>
<td>NA_CONCENTRATION</td>
<td>Native sperm sample&nbsp;concentration [Mio/ml] (Decimal(5,3))</td>
</tr>
<tr>
<td>NA_VITALITY</td>
<td>Native sperm sample&nbsp;vitality [%] (Decimal(5,2))</td>
</tr>
<tr>
<td>NA_LEUCOCYTES</td>
<td>Native sperm sample&nbsp;leucocytes [Mio/ml] (Decimal(9,4))</td>
</tr>
<tr>
<td>NA_ROUND_CELLS</td>
<td>Native sperm sample&nbsp;round cells [Mio/ml] (Decimal(9,2))</td>
</tr>
<tr>
<td>NA_QUANTIFICATION</td>
<td>
<p>If native sperm sample&nbsp;quantification is possible (Integer)</p>
<p>1 = Yes</p>
2 = No</td>
</tr>
<tr>
<td>NA_PEROXIDASE</td>
<td>Native sperm sample&nbsp;peroxidase-positive cells [10^6/ml] (Decimal(5,2))&nbsp;</td>
</tr>
<tr>
<td>NA_IMMUNOBEAD</td>
<td>Native sperm sample&nbsp;immunobead test [% adherent] (Decimal(5,2))</td>
</tr>
<tr>
<td>NA_MAR</td>
<td>Native sperm sample&nbsp;MAR test [% adherent] (Decimal(5,2))</td>
</tr>
<tr>
<td>NA_MAR_IGG</td>
<td>Native sperm sample&nbsp;MAR test - IgG [%] (Decimal(5,2))</td>
</tr>
<tr>
<td>NA_MAR_IGA</td>
<td>Native sperm sample&nbsp;MAR test - IgA [%] (Decimal(5,2))</td>
</tr>
<tr>
<td>NA_WHO_AB</td>
<td>Native sperm sample&nbsp;WHO AB [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_WHO_C</td>
<td>Native sperm sample&nbsp;WHO C [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_WHO_D</td>
<td>Native sperm sample&nbsp;WHO D [%] (Decimal(5,2))&nbsp;</td>
</tr>
<tr>
<td>NA_NORMAL_FORMS</td>
<td>Native sperm sample&nbsp;normal forms [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_HEAD_DEF</td>
<td>Native sperm sample&nbsp;head defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_NECK_MID_DEF</td>
<td>Native sperm sample&nbsp;&nbsp;neck and midpiece defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_TAIL_DEF</td>
<td>Native sperm sample&nbsp;&nbsp;tail defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_ERC</td>
<td>Native sperm sample&nbsp;excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_MULT_DEF</td>
<td>Native sperm sample&nbsp;multiple defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>NA_TZI</td>
<td>Native sperm sample&nbsp;teratozoospermia index TZI (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_VOLUME</td>
<td>After preparation, sperm sample volume in [ml] (Decimal(4,2))<br /></td>
</tr>
<tr>
<td>AP_CONCENTRATION</td>
<td>After preparation, sperm sample&nbsp;concentration [Mio/ml] (Decimal(5,3))<br /></td>
</tr>
<tr>
<td>AP_VITALITY</td>
<td>After preparation, sperm sample vitality [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_LEUCOCYTES</td>
<td>After preparation, sperm sample&nbsp;leucocytes [Mio/ml] (Decimal(9,4))<br /></td>
</tr>
<tr>
<td>AP_ROUND_CELLS</td>
<td>After preparation, sperm sample&nbsp;round cells [Mio/ml] (Decimal(9,2))<br /></td>
</tr>
<tr>
<td>AP_QUANTIFICATION</td>
<td>
<p>After preparation, if sperm sample&nbsp;quantification is possible (Integer)</p>
<p>0 = Not specified</p>
<p>1 = Yes</p>
2 = No<br /></td>
</tr>
<tr>
<td>AP_ICSI</td>
<td>
<p>After preparation, if ICSI is possible (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 <strong>NOT </strong>possible.</em><br /></td>
</tr>
<tr>
<td>AP_PEROXIDASE</td>
<td>After preparation, sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_IMMUNOBEAD</td>
<td>After preparation, sperm sample&nbsp;immunobead test [% adherent] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_MAR</td>
<td>After preparation, sperm sample&nbsp;MAR test [% adherent] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_MAR_IGG</td>
<td>After preparation, sperm sample&nbsp;MAR test - IgG [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_MAR_IGA</td>
<td>After preparation, sperm sample&nbsp;MAR test - IgA [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_WHO_AB</td>
<td>After preparation, sperm sample&nbsp;WHO AB [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_WHO_C</td>
<td>After preparation, sperm sample&nbsp;WHO C [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_WHO_D</td>
<td>After preparation, sperm sample&nbsp;WHO D [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_NORMAL_FORMS</td>
<td>After preparation, sperm sample&nbsp;normal forms [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_HEAD_DEF</td>
<td>After preparation, sperm sample&nbsp;head defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_NECK_MID_DEF</td>
<td>After preparation, sperm sample&nbsp;neck and midpiece defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_TAIL_DEF</td>
<td>After preparation, sperm sample&nbsp;tail defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_ERC</td>
<td>After preparation, sperm sample&nbsp;excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_MULT_DEF</td>
<td>After preparation, sperm sample&nbsp;multiple defects [%] (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>AP_TZI</td>
<td>After preparation, sperm sample&nbsp;teratozoospermia index TZI (Decimal(5,2))<br /></td>
</tr>
<tr>
<td>PREP_DATE</td>
<td>
<p>Preparation date of the sperm sample&nbsp;(Date)</p>
<p><em><span style="text-decoration: underline;">Preferred format:</span>&nbsp;dd.mm.yyyy hh:mm</em></p>
</td>
</tr>
<tr>
<td>PREP_BY</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>
<td>PREP_METHOD</td>
<td>
<p>Preparation method of the sperm sample&nbsp;(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>
<td>DNA_FRAG</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>
<td>FINDING</td>
<td>
<p>Sperm sample diagnosis finding status (Integer)</p>
<p>1 = Normal</p>
2 = Abnormal<br /></td>
</tr>
<tr>
<td>TIME_COLL_USAGE</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>
<td>NO_MOT_SPERM_INSEM</td>
<td>Number of motile sperms inseminated [Mio.] (Decimal(9,2))</td>
</tr>
<tr>
<td>NOTE</td>
<td>Semen analysis note (500 characters)<br /></td>
</tr>
<tr>
<td>VOL_INSEM</td>
<td>Volume inseminated [ml] (Decimal(9,3))<br /></td>
</tr>
<tr>
<td>24H_MOT</td>
<td>Sperm sample 24h motility rate[%](Decimal(5,2))<br /></td>
</tr>
</tbody>
</table>
<p>&nbsp;</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>Mandatory fields are:</p>
<ul>
<li>PATIENT ID</li>
<li>SAMPLE_ID</li>
<li>COLLECTION_DATE</li>
</ul>
</td>
</tr>
</tbody>
</table>
<h2>Insurance Import</h2>
<p>It is possible to import insurance companies by providing a spreadsheet with the information described on this section.</p>
<p>An example of this file can be downloaded from the link below. This document contains the insurance information about one insurer.</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/Insurance.xls">Click here</a>&nbsp;to download an example of&nbsp;Insurance information import file.</p>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>The structure of this file is described in the table below:&nbsp;</p>
<table style="margin-left: auto; margin-right: auto;" border="0">
<tbody>
<tr>
<td align="center"><strong>&nbsp;</strong></td>
<td align="center"><strong>&nbsp;Column name</strong></td>
<td align="center"><strong>&nbsp;Column content</strong></td>
</tr>
<tr>
<td align="center">1.</td>
<td style="text-align: left;" align="center">IN_NAME</td>
<td style="text-align: left;" align="center">Insurer name (50 characters)</td>
</tr>
<tr>
<td align="center">2.</td>
<td style="text-align: left;" align="center">IN_INSURER_NO</td>
<td style="text-align: left;" align="center">Insurer number (30 characters)</td>
</tr>
<tr>
<td align="center">3.</td>
<td style="text-align: left;" align="center">IN_ADDRESS</td>
<td style="text-align: left;" align="center">Insurer address (255 characters)</td>
</tr>
<tr>
<td align="center">4.</td>
<td style="text-align: left;" align="center">IN_EMAIL</td>
<td style="text-align: left;" align="center">Insurer email (50 characters)</td>
</tr>
<tr>
<td align="center">5.</td>
<td style="text-align: left;" align="center">IN_PHONE</td>
<td style="text-align: left;" align="center">Insurer phone (50 characters)</td>
</tr>
<tr>
<td align="center">6.</td>
<td style="text-align: left;" align="center">IN_FAX</td>
<td style="text-align: left;" align="center">Insurer fax (50 characters)</td>
</tr>
<tr>
<td align="center">7.</td>
<td style="text-align: left;" align="center">IN_COUNTRY</td>
<td style="text-align: left;" align="center">
<p><span>Insurer country (numeric code related to the country)</span></p>
<p>The list of countries and corresponding codes&nbsp;can be <a href="/images/Countries.xls">downloaded here</a></p>
</td>
</tr>
<tr>
<td align="center">8.</td>
<td style="text-align: left;" align="center">IN_CLINIC_ID_NUMBER</td>
<td style="text-align: left;" align="center">Insurer clinic ID number (defined by the clinic itself)</td>
</tr>
<tr>
<td align="center">9.</td>
<td style="text-align: left;" align="center">IN_IS_INSURANCE</td>
<td style="text-align: left;" align="center">Insurer / Funder (1 = insurer, 0 = funder)</td>
</tr>
<tr>
<td align="center">10.</td>
<td style="text-align: left;" align="center">IN_IS_ECLAIM_BILLING</td>
<td style="text-align: left;" align="center">E-claim billing (1 = yes, 0 = no)&nbsp;</td>
</tr>
</tbody>
</table>
<p style="text-align: center;">&nbsp;</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>Required fields are:                                                                                  
<ul>
<li>IN_NAME</li>
<li>IN_INSURER_NO</li>
</ul>
</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p style="text-align: left;">&nbsp;</p>
<table style="float: right;" border="0">
<tbody>
<tr>
<td>
<p style="text-align: left;"><a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a></p>
</td>
<td><a href="#top">Back to top</a><br /></td>
</tr>
</tbody>
</table>