{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "d1318b4b-4ae5-4bfa-9084-fe93eaa255f3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import importlib\n",
    "import sys\n",
    "import os\n",
    "    \n",
    "def getImporter():\n",
    "    nixSuite=os.path.join(os.path.expanduser('~'),'software','src','nixSuite')\n",
    "    sys.path.append(os.path.join(nixSuite,'wrapper'))\n",
    "    import nixWrapper\n",
    "    nixWrapper.loadLibrary('labkeyInterface')\n",
    "    import importXLSX\n",
    "    importlib.reload(importXLSX)\n",
    "    return importXLSX\n",
    "\n",
    "def modify(qv,columnName):\n",
    "    if columnName=='ROBOVI - najbližji':\n",
    "        qv=qv.replace('mm','')\n",
    "        qv=qv.replace(',','.')\n",
    "    return qv\n",
    "\n",
    "def modifyRT(qv,columnName):\n",
    "    pMap={'obsevano področje':parseRTArea,\n",
    "         'Boost':parseX,\n",
    "          'tehnika obsevanja':parseRTTechnique,\n",
    "          'tehnika boosta':parseBoostTechnique,\n",
    "          'obsevanje v globokem vdihu':parseX\n",
    "         }\n",
    "    for p in pMap:\n",
    "        if columnName==p:\n",
    "            qv=pMap[p](qv)\n",
    "    return qv  \n",
    "\n",
    "def parseMap(qv,vmap):\n",
    "    for v in vmap:\n",
    "        if qv==v:\n",
    "            return vmap[v]\n",
    "    return qv\n",
    "\n",
    "def parseRTArea(qv):\n",
    "    vmap={'3 (cela dojka + lezija)':3, \n",
    "          '3 - cela dojka + ležišče':3,\n",
    "          '3 - leva dojka in ležišče':3,\n",
    "          'X':None\n",
    "         }\n",
    "    return parseMap(qv,vmap)\n",
    "    \n",
    "def parseX(qv):\n",
    "    vmap={'X':None}\n",
    "    return parseMap(qv,vmap)\n",
    "\n",
    "\n",
    "def parseRTTechnique(qv):\n",
    "    vmap={'3D fif':4,\n",
    "          '3 - ABC':5,\n",
    "          '3 - 3D + E boost':6,\n",
    "          '3 - ABC, 3D-CRT':7,\n",
    "          '3D fif - ABC, SIB':8,\n",
    "          '3D fif - ABC':10,\n",
    "          'DIBH 3D + FREE 3D fif':11,\n",
    "          'X':None}\n",
    "          \n",
    "    return parseMap(qv,vmap)\n",
    "    \n",
    "def parseBoostTechnique(qv):\n",
    "    vmap={'X':None,\n",
    "         'elekt.':2,\n",
    "         'e boost':2}\n",
    "          \n",
    "    return parseMap(qv,vmap)\n",
    "    \n",
    "\n",
    "def getGlobalId(df,r):\n",
    "    possibleLabels=['ID','zaporedna št v raziskavi','ID študija']\n",
    "    rawId=None\n",
    "    for x in possibleLabels:\n",
    "        try:\n",
    "            rawId=str(df.at[r,x])\n",
    "        except KeyError:\n",
    "            continue\n",
    "    #drop spaces\n",
    "    rawId=rawId.replace(' ','')\n",
    "    #print(rawId)\n",
    "    return rawId\n",
    "\n",
    "def convertLookup(xlsColumnName):\n",
    "    return False\n",
    "\n",
    "\n",
    "    \n",
    " "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "1005793b-d809-415d-8df4-8e63af22535d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "loadLibrary\n",
      "remoteSourcesURL https://git0.fmf.uni-lj.si/studen/nixSuite/raw/master/remoteResources/resources.json\n",
      "{'labkeyInterface': {'url': 'https://git0.fmf.uni-lj.si/studen/labkeyInterface/archive/master.zip', 'branch': 'master', 'modules': []}, 'irAEMM': {'url': 'https://git0.fmf.uni-lj.si/studen/iraemm/archive/master.zip', 'branch': 'master', 'modules': ['iraemmBrowser']}, 'SlicerLabkeyExtension': {'url': 'https://git0.fmf.uni-lj.si/studen/SlicerLabkeyExtension/archive/SlicerExtensionIndex.zip', 'branch': 'SlicerExtensionIndex', 'modules': ['labkeyBrowser']}, 'limfomiPET': {'url': 'https://git0.fmf.uni-lj.si/studen/limfomiPET/archive/master.zip', 'branch': 'master', 'modules': ['imageBrowser', 'segmentationBrowser']}, 'parseConfig': {'url': 'https://git0.fmf.uni-lj.si/studen/parseConfig/archive/master.zip', 'branch': 'master', 'modules': []}, 'orthancInterface': {'url': 'https://git0.fmf.uni-lj.si/studen/orthancInterface/archive/master.zip', 'branch': 'master', 'modules': []}, 'dynamicSPECT': {'url': 'https://git0.fmf.uni-lj.si/studen/dynamicSPECT/archive/master.zip', 'branch': 'master', 'modules': ['imageBrowser']}}\n",
      "{'url': 'https://git0.fmf.uni-lj.si/studen/labkeyInterface/archive/master.zip', 'branch': 'master', 'modules': []}\n",
      "File  C:\\Users\\studen\\temp\\labkeyInterface.zip: True\n",
      "User: andrej studen CSRF: 9a6cdab0becd1015a30de73a099d1f50\n",
      "dateVars: []\n",
      "aliases: {'Popisna številka': 'idOIL', 'obsevano področje': 'rtArea', 'TD_Gy': 'totalDose', 'D_fr': 'dosePerFraction', 'Boost': 'boost', 'tehnika boosta': 'boostTechnique', 'TD_Boost': 'boostTotalDose', 'D_Boost_fr': 'boostDoseFractions', 'tehnika obsevanja': 'rtTechnique', 'obsevanje v globokem vdihu': 'rtDIBH', 'Opomba': 'comment'}\n",
      "Index(['ID študija', 'Ime in priimek', 'Popisna številka', 'RT',\n",
      "       'obsevano področje', 'TD_Gy ', 'D_fr', 'Boost', 'tehnika boosta',\n",
      "       'TD_Boost', 'D_Boost_fr', 'tehnika obsevanja',\n",
      "       'obsevanje v globokem vdihu', 'Opomba',\n",
      "       'RT podatki (stolpci E-M) preverjeni (da/ne)',\n",
      "       'Vrisane strukture (da/ne)', 'Plan uvožen (da/ne)',\n",
      "       'Vključene v slikovno diagnostiko', 'Unnamed: 18', 'Unnamed: 19'],\n",
      "      dtype='object')\n",
      "Index: 199\n",
      "[{'ParticipantId': '1', 'idOIL': '6028/19', 'rtArea': 1, 'totalDose': 50.0, 'dosePerFraction': 2.0, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 1, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '2', 'idOIL': '5911/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '3', 'idOIL': '6146/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '4', 'idOIL': '6286/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '5', 'idOIL': '6289/19', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '6', 'idOIL': '6334/19', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '7', 'idOIL': '6439/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '8', 'idOIL': '6064/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '9', 'idOIL': '6556/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '10', 'idOIL': '6795/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '11', 'idOIL': '473/16', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '12', 'idOIL': '6854/19', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 1, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '13', 'idOIL': '6071/19', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '14', 'idOIL': '6251/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '15', 'idOIL': '6483/19', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 5, 'rtDIBH': 1, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '16', 'idOIL': '7194/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 6, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '17', 'idOIL': '7217/19', 'rtArea': 3, 'totalDose': 46.69, 'dosePerFraction': 2.03, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 61.18, 'boostDoseFractions': 2.66, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '18', 'idOIL': '4274/97', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.84, 'boostDoseFractions': 3.056, 'rtTechnique': 5, 'rtDIBH': 1, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '20', 'idOIL': '7087/19', 'rtArea': 1, 'totalDose': 45.57, 'dosePerFraction': 2.17, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 55.86, 'boostDoseFractions': 2.66, 'rtTechnique': 1, 'rtDIBH': 1, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '21', 'idOIL': '6823/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '22', 'idOIL': '7627/19', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': None, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '23', 'idOIL': '7319/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 2, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': None, 'rtDIBH': 1, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '24', 'idOIL': '4510/93', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': None, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '25', 'idOIL': '60/20', 'rtArea': 3, 'totalDose': 50.0, 'dosePerFraction': 2.0, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': None, 'rtDIBH': 1, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '26', 'idOIL': '7365/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 9, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '28', 'idOIL': '6812/19', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 2, 'boostTotalDose': 13.0, 'boostDoseFractions': 2.6, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '33', 'idOIL': '1012/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '35', 'idOIL': '778/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '36', 'idOIL': '1132/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '37', 'idOIL': '4202/92', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '40', 'idOIL': '1212/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '42', 'idOIL': '1141/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 9, 'rtDIBH': 9, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '43', 'idOIL': '422/20', 'rtArea': 1, 'totalDose': 50.0, 'dosePerFraction': 2.0, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '44', 'idOIL': '1750/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '46', 'idOIL': '1789/20', 'rtArea': 1, 'totalDose': 45.75, 'dosePerFraction': 3.05, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 9, 'rtDIBH': 9, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '47', 'idOIL': '759/20', 'rtArea': 1, 'totalDose': 45.75, 'dosePerFraction': 2.17, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 55.86, 'boostDoseFractions': 2.66, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '48', 'idOIL': '4355/19', 'rtArea': 1, 'totalDose': 45.75, 'dosePerFraction': 2.17, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 55.86, 'boostDoseFractions': 2.66, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '49', 'idOIL': '1864/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 2, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '50', 'idOIL': '1746/20', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '51', 'idOIL': '787/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '53', 'idOIL': '1752/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '54', 'idOIL': '2099/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '55', 'idOIL': '6669/91', 'rtArea': 3, 'totalDose': 45.75, 'dosePerFraction': 2.17, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 55.86, 'boostDoseFractions': 2.66, 'rtTechnique': 7, 'rtDIBH': 1, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '56', 'idOIL': '4198/20', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '57', 'idOIL': '4000/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '59', 'idOIL': '2260/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '61', 'idOIL': '2474/18', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '62', 'idOIL': '4682/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '63', 'idOIL': '5002/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '65', 'idOIL': '4691/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': 'ABC', 'SequenceNum': 1}, {'ParticipantId': '66', 'idOIL': '4918/20', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '67', 'idOIL': '7919/14', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '68', 'idOIL': '5244/20', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': None, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '69', 'idOIL': '202/19', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.57, 'boostDoseFractions': 3.05, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '70', 'idOIL': '1278/04', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '71', 'idOIL': '5837/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '72', 'idOIL': '5959/20', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '73', 'idOIL': '5945/20', 'rtArea': 1, 'totalDose': 40.0, 'dosePerFraction': 2.66, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '74', 'idOIL': '4956/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 2, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '75', 'idOIL': '4965/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 2, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '76', 'idOIL': '6215/20', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 8, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '77', 'idOIL': '4894/16', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': 'PRONE', 'SequenceNum': 1}, {'ParticipantId': '78', 'idOIL': '6547/20', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '79', 'idOIL': '7051/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '80', 'idOIL': '3212/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'v PA poziciji', 'SequenceNum': 1}, {'ParticipantId': '81', 'idOIL': '6865/20', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '82', 'idOIL': '9224/06', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'v PA poziciji', 'SequenceNum': 1}, {'ParticipantId': '83', 'idOIL': '5874/20', 'rtArea': 1, 'totalDose': 50.0, 'dosePerFraction': 2.0, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': '+ ABC', 'SequenceNum': 1}, {'ParticipantId': '84', 'idOIL': '4527/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': '10 obsevanj v ABC', 'SequenceNum': 1}, {'ParticipantId': '85', 'idOIL': '7140/20', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 9, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '86', 'idOIL': '6595/20', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '87', 'idOIL': '7225/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '88', 'idOIL': '6765/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '89', 'idOIL': '7038/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '90', 'idOIL': '1558/89', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '91', 'idOIL': '7392/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '92', 'idOIL': '7548/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'v PA poziciji', 'SequenceNum': 1}, {'ParticipantId': '93', 'idOIL': '64/21', 'rtArea': 3, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '94', 'idOIL': '52/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': 'ABC', 'SequenceNum': 1}, {'ParticipantId': '95', 'idOIL': '6738/20', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '96', 'idOIL': '7480/20', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 2, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': '3D CRT + E-boost', 'SequenceNum': 1}, {'ParticipantId': '97', 'idOIL': '270/21', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '98', 'idOIL': '2040/92', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '99', 'idOIL': '7263/20', 'rtArea': 3, 'totalDose': 45.57, 'dosePerFraction': 2.17, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 55.86, 'boostDoseFractions': 2.66, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '100', 'idOIL': '974/21', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '101', 'idOIL': '963/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '102', 'idOIL': '933/21', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '103', 'idOIL': '1023/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '104', 'idOIL': '2044/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '105', 'idOIL': '1382/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '106', 'idOIL': '1714/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '107', 'idOIL': '1657/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 10, 'rtDIBH': 2, 'comment': 'ABC', 'SequenceNum': 1}, {'ParticipantId': '109', 'idOIL': '2224/21', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '110', 'idOIL': '3405/00', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '111', 'idOIL': '2110/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': 'v PA poziciji', 'SequenceNum': 1}, {'ParticipantId': '112', 'idOIL': '2508/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'v PA poziciji', 'SequenceNum': 1}, {'ParticipantId': '113', 'idOIL': '2425/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '114', 'idOIL': '4754/21', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'v PA poziciji', 'SequenceNum': 1}, {'ParticipantId': '115', 'idOIL': '4684/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'ABC ni šlo', 'SequenceNum': 1}, {'ParticipantId': '116', 'idOIL': '1684/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '117', 'idOIL': '4098/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': 1, 'comment': 'DIBH 6 fr. + free 9. fr', 'SequenceNum': 1}, {'ParticipantId': '118', 'idOIL': '4240/21', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '119', 'idOIL': '4382/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'Ap6', 'SequenceNum': 1}, {'ParticipantId': '120', 'idOIL': '4140/15', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '121', 'idOIL': '3023/05', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 1, 'comment': 'DIBH (ABC)', 'SequenceNum': 1}, {'ParticipantId': '122', 'idOIL': '4729/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '123', 'idOIL': '4148/21', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 2, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': '3D CRT + E boost', 'SequenceNum': 1}, {'ParticipantId': '125', 'idOIL': '4659/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '126', 'idOIL': '4794/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '127', 'idOIL': '4819/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '128', 'idOIL': '4874/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '129', 'idOIL': '4984/21', 'rtArea': 3, 'totalDose': 46.69, 'dosePerFraction': 2.03, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 61.18, 'boostDoseFractions': 2.66, 'rtTechnique': 4, 'rtDIBH': 9, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '130', 'idOIL': '2468/97', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '131', 'idOIL': '548/91', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '132', 'idOIL': '3715/97', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '133', 'idOIL': '5963/21', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '134', 'idOIL': '6051/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '135', 'idOIL': '6136/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '136', 'idOIL': '4064/98', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 15.25, 'boostDoseFractions': 3.05, 'rtTechnique': 1, 'rtDIBH': 2, 'comment': 'SIB', 'SequenceNum': 1}, {'ParticipantId': '137', 'idOIL': '4481/16', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '139', 'idOIL': '6359/21', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 1, 'comment': 'DIBH', 'SequenceNum': 1}, {'ParticipantId': '140', 'idOIL': '6332/21', 'rtArea': 3, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': None, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '141', 'idOIL': '4864/21', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '142', 'idOIL': '7485/21', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': 2, 'comment': 'prone positron', 'SequenceNum': 1}, {'ParticipantId': '143', 'idOIL': '2873/11', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '144', 'idOIL': '8062/21', 'rtArea': 2, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '145', 'idOIL': '50597/22', 'rtArea': 2, 'totalDose': 42.3, 'dosePerFraction': 2.35, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 52.2, 'boostDoseFractions': 2.9, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '146', 'idOIL': '7757/21', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 1, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '147', 'idOIL': '7978/21', 'rtArea': 2, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '148', 'idOIL': '3371/07', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '149', 'idOIL': '446/22', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '151', 'idOIL': '1053/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '152', 'idOIL': '1942/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '153', 'idOIL': '1570/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '154', 'idOIL': '998/11', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 11, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '155', 'idOIL': '4150/96', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '156', 'idOIL': '2026/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '157', 'idOIL': '2205/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '158', 'idOIL': '2001/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '159', 'idOIL': '3269/04', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '160', 'idOIL': '2506/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '161', 'idOIL': '4010/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '162', 'idOIL': '4342/22', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '163', 'idOIL': '1698/07', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '164', 'idOIL': '6027/92', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '165', 'idOIL': '2062/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 1, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '166', 'idOIL': '4074/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 16.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '167', 'idOIL': '2681/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '168', 'idOIL': '6897/15', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 10.0, 'boostDoseFractions': 2.0, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '169', 'idOIL': '5268/22', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '170', 'idOIL': '4680/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '171', 'idOIL': '6243/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.26, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '172', 'idOIL': '6929/22', 'rtArea': 2, 'totalDose': 45.75, 'dosePerFraction': 2.17, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 55.86, 'boostDoseFractions': 2.66, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '173', 'idOIL': '6020/16', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '174', 'idOIL': '6958/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '175', 'idOIL': '7253/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '176', 'idOIL': '1237/95', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '177', 'idOIL': '6488/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '178', 'idOIL': '3289/16', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '179', 'idOIL': '7767/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '180', 'idOIL': '8078/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '181', 'idOIL': '7814/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '182', 'idOIL': '8238/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '183', 'idOIL': '8420/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': 1, 'boostTotalDose': 1.0, 'boostDoseFractions': 1.0, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '184', 'idOIL': '8157/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '185', 'idOIL': '7378/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '186', 'idOIL': '3227/95', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 1, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '187', 'idOIL': '7927/22', 'rtArea': 1, 'totalDose': 42.72, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '188', 'idOIL': '367/23', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '189', 'idOIL': '858/23', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '190', 'idOIL': '7719/22', 'rtArea': 2, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 1, 'boostTechnique': 1, 'boostTotalDose': 45.75, 'boostDoseFractions': 3.05, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '191', 'idOIL': '374/23', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '192', 'idOIL': '107/23', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '193', 'idOIL': '4937/19', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '194', 'idOIL': '8424/22', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '195', 'idOIL': '2843/23', 'rtArea': 1, 'totalDose': 40.05, 'dosePerFraction': 2.67, 'boost': 0, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '196', 'idOIL': '2747/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '197', 'idOIL': '3107/08', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '198', 'idOIL': '7661/21', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '199', 'idOIL': '2059/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '200', 'idOIL': '4109/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '201', 'idOIL': '2508/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '202', 'idOIL': '5026/92', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '203', 'idOIL': '2745/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '204', 'idOIL': '4596/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '205', 'idOIL': '1235/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '206', 'idOIL': '2509/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '207', 'idOIL': '5185/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '208', 'idOIL': '5132/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '209', 'idOIL': '5427/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '210', 'idOIL': '5531/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '211', 'idOIL': '5428/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '212', 'idOIL': '5020/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '213', 'idOIL': '6714/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '214', 'idOIL': '6909/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 2, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '215', 'idOIL': '6860/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '216', 'idOIL': '6031/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '217', 'idOIL': '8022/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': 4, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}, {'ParticipantId': '218', 'idOIL': '8067/23', 'rtArea': None, 'totalDose': None, 'dosePerFraction': None, 'boost': None, 'boostTechnique': None, 'boostTotalDose': None, 'boostDoseFractions': None, 'rtTechnique': None, 'rtDIBH': None, 'comment': None, 'SequenceNum': 1}]\n",
      "Updating 5 entries\n",
      "User: andrej studen CSRF: 742fe1637468f101da711f46ebdca491\n",
      "Inserting 194 entries\n",
      "User: andrej studen CSRF: 04ff9a3c1db820922c3e62a89210fb80\n"
     ]
    }
   ],
   "source": [
    "importXLSX=getImporter()\n",
    "filename=os.path.join('z:','DCIS_import1.xlsx')\n",
    "filename1=os.path.join('z:','DCISimportRT.xlsx')\n",
    "#print(os.path.isfile(filename))\n",
    "\n",
    "#Demographics\n",
    "parServer={'server':'onko-nix',\n",
    "      'project':'DCIS/Study',\n",
    "      'schema':'study'}\n",
    "\n",
    "parXLS= {'sheet_name':0,  'skiprows':6}\n",
    "parXLS1= {'sheet_name':1,  'skiprows':0}\n",
    "parXLS2= {'sheet_name':0,  'skiprows':0}\n",
    "\n",
    "#DEMOGRAPHICS\n",
    "parD={'query':'Demographics'}\n",
    "\n",
    "##PART 1\n",
    "#importData(parServer| parD | parXLS,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "#PART 2\n",
    "#importData(parServer| parD | parXLS1,filename,getGlobalId,dryRun=False)\n",
    "\n",
    "#COMORBIDITIES\n",
    "parC={'query':'comorbidities'}\n",
    "#importData(parServer | parC | parXLS,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "#TOXICITY\n",
    "parT={'query':'toxicity'}\n",
    "\n",
    "## VISIT 1\n",
    "parTV1={'usecols':'A,O:AG', 'seqNumOffset':0}\n",
    "#importData(parServer | parT | parXLS | parTV1,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "## VISIT 2\n",
    "parTV2={'usecols':'A,AH:AZ', 'seqNumOffset':1}\n",
    "#importData(parServer | parT | parXLS | parTV2,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "## VISIT 3\n",
    "parTV3={'usecols':'A,BA:BP', 'seqNumOffset':2}\n",
    "#importData(parServer | parT | parXLS | parTV3,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "## VISIT 4\n",
    "parTV4={'usecols':'A,BQ:CF', 'seqNumOffset':3}\n",
    "#importData(parServer | parT | parXLS | parTV4,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "## VISIT 5\n",
    "parTV5={'usecols':'A,CG:CW', 'seqNumOffset':4}\n",
    "#importData(parServer | parT | parXLS | parTV5,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "# CANCER DATA\n",
    "parCA={'query':'cancerData'}\n",
    "#importData(parServer | parCA | parXLS1,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "#SURGERY\n",
    "parSG={'query':'surgery'}\n",
    "#importData(parServer | parSG | parXLS1,filename,getGlobalId,dryRun=True)\n",
    "\n",
    "#RT\n",
    "parRT={'query':'radiotherapy'}\n",
    "#importData(parServer | parRT | parXLS1,filename,getGlobalId,dryRun=True)\n",
    "importXLSX.importData(parServer | parRT | parXLS2,filename1,getId=getGlobalId,\n",
    "                      modify=modifyRT,\n",
    "                      convertLookup=convertLookup,\n",
    "                      dryRun=False,\n",
    "                      debug=False)\n",
    "\n",
    "#laboratoryTests\n",
    "parLT={'query':'laboratoryTests'}\n",
    "## VISIT 1\n",
    "parLTV1={'usecols':'A,AO,AS,AW', 'seqNumOffset':1}\n",
    "#importData(parServer | parLT | parXLS1 | parLTV1,filename,getGlobalId,dryRun=False)\n",
    "\n",
    "## VISIT 2\n",
    "parLTV2={'usecols':'A,AP,AT,AX', 'seqNumOffset':2}\n",
    "#importData(parServer | parLT | parXLS1 | parLTV2,filename,getGlobalId,dryRun=False)\n",
    "\n",
    "## VISIT 3\n",
    "parLTV3={'usecols':'A,AQ,AU,AY', 'seqNumOffset':3}\n",
    "#importData(parServer | parLT | parXLS1 | parLTV3,filename,getGlobalId,dryRun=False)\n",
    "\n",
    "\n",
    "## VISIT 4\n",
    "parLTV4={'usecols':'A,AR,AV,AZ', 'seqNumOffset':4}\n",
    "#importXLSX.importData(parServer | parLT | parXLS1 | parLTV4,filename,getGlobalId,modify,convertLookup,dryRun=True)\n",
    "\n",
    "## IMAGING1\n",
    "parIm={'query':'Imaging1','usecols':'A,C'}\n",
    "#importXLSX.importData(parServer | parIm | parXLS2 ,filename1,getGlobalId,modify,convertLookup,dryRun=False,debug=False)\n",
    "\n",
    "\n",
    "#df=pandas.read_excel(filename,skiprows=6,usecols=parsT5['usecols'])\n",
    "#print(df)\n",
    "\n",
    "#for repeated evaluations, apply columnt offset (or selection) and provide seqNumOffset\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8b5d6212-0ee7-4f3e-8b26-a9c6024823ab",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}