confirmForms.ipynb 88 KB
### Requirements
- Installed git. More on how to use and install git can be found [here][git].
- A zip of the certificate. Particularly, you'll need the crt and key files.
- A labkey access configuration file. A sample for [linux][linuxConfig] or [Windows][windowsConfig]. The file paths point to locations of extracted files from certificate zip on your disk.
[git]: https://git-scm.com/
[linuxConfig]: https://git0.fmf.uni-lj.si/studen/labkeyInterface/src/master/network-config-sample.json
[windowsConfig]: https://git0.fmf.uni-lj.si/studen/labkeyInterface/src/master/network-config-sample.json
#load required libraries
import sys
import os
import SimpleITK
import numpy
import matplotlib.pyplot
import chardet
import json
#you should get nixSuite via git clone https://git0.fmf.uni-lj.si/studen/nixSuite.git
#if you don't put it to $HOME/software/src/, you should update the path
nixSuite=os.path.join(os.path.expanduser('~'),'software','src','nixSuite')
sys.path.append(os.path.join(nixSuite,'wrapper'))
import nixWrapper
nixWrapper.loadLibrary('labkeyInterface')
import labkeyInterface
import labkeyDatabaseBrowser
import labkeyFileBrowser
def connectDB(server):
net=labkeyInterface.labkeyInterface()
fconfig=os.path.join(os.path.expanduser('~'),'.labkey','{}.json'.format(server))
net.init(fconfig)
#this reports the certificate used
#This gets a deafult CSRF code; It should report user name plus a long string of random hex numbers
net.getCSRF()
return labkeyDatabaseBrowser.labkeyDB(net)loadLibrary
remoteSourcesURL https://git0.fmf.uni-lj.si/studen/nixSuite/raw/master/remoteResources/resources.json
{'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': []}}
{'url': 'https://git0.fmf.uni-lj.si/studen/labkeyInterface/archive/master.zip', 'branch': 'master', 'modules': []}
File C:\Users\studen\temp\labkeyInterface.zip: True
#confirm Forms (equialent to onDatabaseUpload of CRF)
#works only for old version of crf on onko-nix
db=connectDB('onko-nix')
#select a project
project='limfomiPET/Study'
#dataset='Segmentation'
schema='lists'
formNameFilter={'variable':'formName','value':'10','oper':'eq'}#imageTransferReport
dsFormSetup=db.selectRows(project,schema,'FormSetup',[formNameFilter])
dsInputLists=db.selectRows(project,schema,'inputLists',[])
dsDemo=db.selectRows(project,'study','demographicData',[])
idData={r['lsid']:r['ParticipantId'] for r in dsDemo['rows']}
iLists={r['Key']:r['queryName'] for r in dsInputLists['rows']}
queries=[iLists[r['queryName']] for r in dsFormSetup['rows']]
print('Queries {}'.format(queries))
query='crfEntry'
formFilter={'variable':'Form','value':'10','oper':'eq'}
statusFilter={'variable':'FormStatus','value':'2','oper':'eq'}
ds=db.selectRows(project,schema,query,[formFilter,statusFilter])
rows=ds['rows']
for row in rows:
crfEntry=row['entryId']
crfFilter={'variable':'crfRef','value':'{}'.format(crfEntry),'oper':'eq'}
for q in queries:
# get in list
du=db.selectRows(project,'lists',q,[crfFilter])
print('List {} {} {}'.format(crfEntry,q,len(du['rows'])))
# get in study
dus=db.selectRows(project,'study',q,[crfFilter])
print('Study {} {} {}'.format(crfEntry,q,len(dus['rows'])))
nStudy=len(dus['rows'])
nList=len(du['rows'])
for i in range(nStudy):
#update
targetRow=dus['rows'][i]
sourceRow=du['rows'][i]
sKeys=list(sourceRow.keys())
tKeys=list(targetRow.keys())
keys=[k for k in sKeys if k not in ['Key']]
for k in keys:
targetRow[k]=sourceRow[k]
print(db.modifyRows('update',project,'study',q,[targetRow]))
for i in range(nStudy,nList):
targetRow=du['rows'][i]
targetRow['SequenceNum']=(int(crfEntry) % 1000000000)+i/100
targetRow['ParticipantId']=idData[targetRow['participantCode']]
print('Target row {}'.format(targetRow))
print(db.modifyRows('insert',project,'study',q,[targetRow]))
#assume the same ordering, only that rows(study)<=rows(lists)
row['FormStatus']=3
print(db.modifyRows('update',project,schema,query,[row]))
#print(row)
#change the value of the field in database
#if field is not in database, it will NOT be added and no changes will occur
#db.modifyRows('update',project,schema,query,[row])
User: andrej studen CSRF: 9d9762bd7dfbb0e54d684e522df3a22f
Queries ['imageTransferReport']
List 1678913582089 imageTransferReport 1
Study 1678913582089 imageTransferReport 1
User: andrej studen CSRF: 69507afcb824ac3464a82e657e410604
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 544,\n "CreatedBy" : 1003,\n "imageDate" : "20180105",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:21",\n "SequenceNum" : 913582089.0000,\n "ParticipantId" : "6780/05",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6780/05.913582089.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678913582089",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6780/05.805281932.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: eb8f34720c5a08e9eea573765a2b9d79
List 1678913677872 imageTransferReport 1
Study 1678913677872 imageTransferReport 1
User: andrej studen CSRF: 0e11d1e18598dd3ff05b8019eefef28d
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 545,\n "CreatedBy" : 1003,\n "imageDate" : "20180720",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 913677872.0000,\n "Created" : "2023/03/20 16:10:22",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6780/05.913677872.0000",\n "ParticipantId" : "6780/05",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678913677872",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6780/05.805281932.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 59f7ecfbfc44645b87f14619b1ac4a34
List 1678913756244 imageTransferReport 1
Study 1678913756244 imageTransferReport 1
User: andrej studen CSRF: 077fc01a01ae82e28735bfa947d8c9e3
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 546,\n "CreatedBy" : 1003,\n "imageDate" : "20200326",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:24",\n "SequenceNum" : 913756244.0000,\n "ParticipantId" : "676/96",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.676/96.913756244.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678913756244",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.676/96.77842022.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: b9f159fc6c5f5b871f7747fe1904d054
List 1678913789731 imageTransferReport 1
Study 1678913789731 imageTransferReport 1
User: andrej studen CSRF: fbfea65e03ec11635725635d408a50b8
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 547,\n "CreatedBy" : 1003,\n "imageDate" : "20201006",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:25",\n "SequenceNum" : 913789731.0000,\n "ParticipantId" : "676/96",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.676/96.913789731.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678913789731",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.676/96.77842022.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: e750c8c86fd8f1c4a182fdcdc0de8c14
List 1678913833288 imageTransferReport 1
Study 1678913833288 imageTransferReport 1
User: andrej studen CSRF: 87ed94e8477c08d9b1f2885ddc51b281
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 548,\n "CreatedBy" : 1003,\n "imageDate" : "20180221",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 913833288.0000,\n "Created" : "2023/03/20 16:10:26",\n "ParticipantId" : "691/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.691/18.913833288.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678913833288",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.691/18.85720306.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 04f6eaac9559912d194fadc785f6c477
List 1678913865491 imageTransferReport 1
Study 1678913865491 imageTransferReport 1
User: andrej studen CSRF: 7dd0deefaa75824e82e79f50f310780b
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 549,\n "CreatedBy" : 1003,\n "imageDate" : "20180724",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 913865491.0000,\n "Created" : "2023/03/20 16:10:27",\n "ParticipantId" : "691/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.691/18.913865491.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678913865491",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.691/18.85720306.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 6326a527a66ff3f55ed750cbc454ce98
List 1678913893349 imageTransferReport 1
Study 1678913893349 imageTransferReport 1
User: andrej studen CSRF: a2111c57f79c4c32b6d8bc508619f1f2
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 550,\n "CreatedBy" : 1003,\n "imageDate" : "20200922",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:29",\n "SequenceNum" : 913893349.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.5503/20.913893349.0000",\n "ParticipantId" : "5503/20",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678913893349",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.5503/20.85753455.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: d530e637b88d3462f8034ca810dae3cd
List 1678913917882 imageTransferReport 1
Study 1678913917882 imageTransferReport 1
User: andrej studen CSRF: 23da9f02816ac40f0601e5bb6e593e81
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 551,\n "CreatedBy" : 1003,\n "imageDate" : "20210325",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 913917882.0000,\n "Created" : "2023/03/20 16:10:30",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.5503/20.913917882.0000",\n "ParticipantId" : "5503/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678913917882",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.5503/20.85753455.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 3393e86ab2e3985d2efb1c442f74cb7c
List 1678913955250 imageTransferReport 1
Study 1678913955250 imageTransferReport 1
User: andrej studen CSRF: d2118de843a05111784a722e6eb3ea6e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 552,\n "CreatedBy" : 1003,\n "imageDate" : "20190306",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:31",\n "SequenceNum" : 913955250.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.951/19.913955250.0000",\n "ParticipantId" : "951/19",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678913955250",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.951/19.85785081.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 43e4087a453adde53547cc8c35efdc25
List 1678913983202 imageTransferReport 1
Study 1678913983202 imageTransferReport 1
User: andrej studen CSRF: 9ee492a5f196a4c47b3b3b34f1459fde
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 553,\n "CreatedBy" : 1003,\n "imageDate" : "20190717",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:32",\n "SequenceNum" : 913983202.0000,\n "ParticipantId" : "951/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.951/19.913983202.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678913983202",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.951/19.85785081.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: b49144231b7e1176c0350fb98abfedf2
List 1678914006471 imageTransferReport 1
Study 1678914006471 imageTransferReport 1
User: andrej studen CSRF: 148673422f46f7b2520327287342e17b
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 554,\n "CreatedBy" : 1003,\n "imageDate" : "20180925",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:33",\n "SequenceNum" : 914006471.0000,\n "ParticipantId" : "195/06",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.195/06.914006471.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914006471",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.195/06.85826231.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 3feb9a288f88665ec3d97122bdb4407a
List 1678914032927 imageTransferReport 1
Study 1678914032927 imageTransferReport 1
User: andrej studen CSRF: 5b5d762d2b03662cd8b09edd6e87b189
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 555,\n "CreatedBy" : 1003,\n "imageDate" : "20190408",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914032927.0000,\n "Created" : "2023/03/20 16:10:34",\n "ParticipantId" : "195/06",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.195/06.914032927.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914032927",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.195/06.85826231.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 35144c67c94cdabb2d0f4196eebb9d6a
List 1678914060412 imageTransferReport 1
Study 1678914060412 imageTransferReport 1
User: andrej studen CSRF: 2ef7983dd78795205396c6d8090ce84e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 556,\n "CreatedBy" : 1003,\n "imageDate" : "20190715",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:36",\n "SequenceNum" : 914060412.0000,\n "ParticipantId" : "195/06",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.195/06.914060412.0000",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678914060412",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.195/06.85826231.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: e7268a5eaefc10d98ee9c95600b3eb3f
List 1678914086129 imageTransferReport 1
Study 1678914086129 imageTransferReport 1
User: andrej studen CSRF: 30cc21ce13418c8246bfeff213dc9856
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 557,\n "CreatedBy" : 1003,\n "imageDate" : "20180226",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:37",\n "SequenceNum" : 914086129.0000,\n "ParticipantId" : "1041/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1041/18.914086129.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914086129",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1041/18.85858415.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 4d837f715a5010613ee368762eb600d9
List 1678914112560 imageTransferReport 1
Study 1678914112560 imageTransferReport 1
User: andrej studen CSRF: 7622cd03e2f47ddba405bb042060fd9e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 558,\n "CreatedBy" : 1003,\n "imageDate" : "20180921",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914112560.0000,\n "Created" : "2023/03/20 16:10:38",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1041/18.914112560.0000",\n "ParticipantId" : "1041/18",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914112560",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1041/18.85858415.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 65b4c57ed9b59049dd1042ed9efa296f
List 1678914143318 imageTransferReport 1
Study 1678914143318 imageTransferReport 1
User: andrej studen CSRF: f3fc8f1ab23ab8181d11ead8a7bd5c79
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 559,\n "CreatedBy" : 1003,\n "imageDate" : "20181029",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914143318.0000,\n "Created" : "2023/03/20 16:10:39",\n "ParticipantId" : "6176/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6176/18.914143318.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914143318",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6176/18.85893927.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 8de150c0d97b57b5e16b253cda986ca9
List 1678914171174 imageTransferReport 1
Study 1678914171174 imageTransferReport 1
User: andrej studen CSRF: 8a1b3661e46e3c586e8acf990660dc3a
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 560,\n "CreatedBy" : 1003,\n "imageDate" : "20190503",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:40",\n "SequenceNum" : 914171174.0000,\n "ParticipantId" : "6176/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6176/18.914171174.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914171174",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6176/18.85893927.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: a26fdab4fd37aba5cc62d6f6b8f49b8f
List 1678914194582 imageTransferReport 1
Study 1678914194582 imageTransferReport 1
User: andrej studen CSRF: 15851308d88f8ea61baa5d456385bba3
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 561,\n "CreatedBy" : 1003,\n "imageDate" : "20200518",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:42",\n "SequenceNum" : 914194582.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2352/20.914194582.0000",\n "ParticipantId" : "2352/20",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914194582",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2352/20.85925151.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 8dd7f2970a023376b3ed75c87da3448e
List 1678914220091 imageTransferReport 1
Study 1678914220091 imageTransferReport 1
User: andrej studen CSRF: 69094ee13378d3dedd5d06256797ad6e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 562,\n "CreatedBy" : 1003,\n "imageDate" : "20201001",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914220091.0000,\n "Created" : "2023/03/20 16:10:43",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2352/20.914220091.0000",\n "ParticipantId" : "2352/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914220091",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2352/20.85925151.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 027b6e8f6803b568973ff51bfbef3aa7
List 1678914261370 imageTransferReport 1
Study 1678914261370 imageTransferReport 1
User: andrej studen CSRF: 2adfed4bba2cce8390232d3a79fdf471
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 563,\n "CreatedBy" : 1003,\n "imageDate" : "20181022",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914261370.0000,\n "Created" : "2023/03/20 16:10:44",\n "ParticipantId" : "7211/90",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.7211/90.914261370.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914261370",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.7211/90.85955178.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: b7dbd79b9a10acb2fd32a27a1826ff36
List 1678914285336 imageTransferReport 1
Study 1678914285336 imageTransferReport 1
User: andrej studen CSRF: 8adfab41d89e6f5fc37dfa57e27d835e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 564,\n "CreatedBy" : 1003,\n "imageDate" : "20190514",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914285336.0000,\n "Created" : "2023/03/20 16:10:45",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.7211/90.914285336.0000",\n "ParticipantId" : "7211/90",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914285336",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.7211/90.85955178.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: ddc312c0d17b12153c2df17051216079
List 1678914308320 imageTransferReport 1
Study 1678914308320 imageTransferReport 1
User: andrej studen CSRF: 36b231d868173bdc6dbc8130f98515aa
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 565,\n "CreatedBy" : 1003,\n "imageDate" : "20190902",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:46",\n "SequenceNum" : 914308320.0000,\n "ParticipantId" : "7211/90",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.7211/90.914308320.0000",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678914308320",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.7211/90.85955178.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: f1677f625fa315652bc5110739ebc8f0
List 1678914330974 imageTransferReport 1
Study 1678914330974 imageTransferReport 1
User: andrej studen CSRF: cfd5b50cdf153b216743d444ce4d1570
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 566,\n "CreatedBy" : 1003,\n "imageDate" : "20190517",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914330974.0000,\n "Created" : "2023/03/20 16:10:48",\n "ParticipantId" : "2074/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2074/19.914330974.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914330974",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2074/19.85994148.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 2074b67a8e75475e75179f8c81e58bb2
List 1678914355532 imageTransferReport 1
Study 1678914355532 imageTransferReport 1
User: andrej studen CSRF: 5074f7662d12fcb7c868dff68d87db6b
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 567,\n "CreatedBy" : 1003,\n "imageDate" : "20191118",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:49",\n "SequenceNum" : 914355532.0000,\n "ParticipantId" : "2074/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2074/19.914355532.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914355532",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2074/19.85994148.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: c713efcccec002f6203979979bb6eacb
List 1678914380420 imageTransferReport 1
Study 1678914380420 imageTransferReport 1
User: andrej studen CSRF: ae160288fad0e29e1653fb3f2aa79f09
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 568,\n "CreatedBy" : 1003,\n "imageDate" : "20200806",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:50",\n "SequenceNum" : 914380420.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.5321/20.914380420.0000",\n "ParticipantId" : "5321/20",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914380420",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.5321/20.315526020.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 17a23f1ebe7e7f3aa938133b70ae369f
List 1678914405818 imageTransferReport 1
Study 1678914405818 imageTransferReport 1
User: andrej studen CSRF: 7d2665160f3870e8345d1026e6ff7775
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 569,\n "CreatedBy" : 1003,\n "imageDate" : "20210302",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914405818.0000,\n "Created" : "2023/03/20 16:10:51",\n "ParticipantId" : "5321/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.5321/20.914405818.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914405818",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.5321/20.315526020.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: cb40ddc805b470d132b83f34a73844dc
List 1678914431363 imageTransferReport 1
Study 1678914431363 imageTransferReport 1
User: andrej studen CSRF: 660c3071caeb71aa5ac0ee0ef841e0c4
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 570,\n "CreatedBy" : 1003,\n "imageDate" : "20200406",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:52",\n "SequenceNum" : 914431363.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1649/20.914431363.0000",\n "ParticipantId" : "1649/20",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914431363",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1649/20.315554353.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 53e49195f0a62d8d372f75205b0da4c0
List 1678914453184 imageTransferReport 1
Study 1678914453184 imageTransferReport 1
User: andrej studen CSRF: e5f411634b0253dde3cf28b2628d1a05
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 571,\n "CreatedBy" : 1003,\n "imageDate" : "20200929",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914453184.0000,\n "Created" : "2023/03/20 16:10:54",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1649/20.914453184.0000",\n "ParticipantId" : "1649/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914453184",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1649/20.315554353.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 5e76e4e568d5245e8176101669222ac4
List 1678914481682 imageTransferReport 1
Study 1678914481682 imageTransferReport 1
User: andrej studen CSRF: 2d11b17f39e4b9c300bdc7155e11e98f
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 572,\n "CreatedBy" : 1003,\n "imageDate" : "20180601",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:55",\n "SequenceNum" : 914481682.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2749/18.914481682.0000",\n "ParticipantId" : "2749/18",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914481682",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2749/18.315577408.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 6f79ea3371dbed4a7c02bb79d156755d
List 1678914506856 imageTransferReport 1
Study 1678914506856 imageTransferReport 1
User: andrej studen CSRF: 45900878b032792f4e7a32961ef82c61
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 573,\n "CreatedBy" : 1003,\n "imageDate" : "20181214",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:56",\n "SequenceNum" : 914506856.0000,\n "ParticipantId" : "2749/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2749/18.914506856.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914506856",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2749/18.315577408.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 46c768cf1bbbe4a8f96ff4bdca94c44d
List 1678914530441 imageTransferReport 1
Study 1678914530441 imageTransferReport 1
User: andrej studen CSRF: ca4036f3e5959fee60806a544b8ea11f
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 574,\n "CreatedBy" : 1003,\n "imageDate" : "20190314",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:58",\n "SequenceNum" : 914530441.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2749/18.914530441.0000",\n "ParticipantId" : "2749/18",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678914530441",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2749/18.315577408.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: a05be90a522e12c4ccc1991143dc3a14
List 1678914627792 imageTransferReport 1
Study 1678914627792 imageTransferReport 1
User: andrej studen CSRF: 4e92bc9bfb832e680ebff9b4eb92e296
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 575,\n "CreatedBy" : 1003,\n "imageDate" : "20180118",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:10:59",\n "SequenceNum" : 914627792.0000,\n "ParticipantId" : "94/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.94/18.914627792.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914627792",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.94/18.316119610.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 019abc6afa44c86c884b3ee1b1dfd13e
List 1678914654428 imageTransferReport 1
Study 1678914654428 imageTransferReport 1
User: andrej studen CSRF: 563a4341d149882434b96571d8c2575b
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 576,\n "CreatedBy" : 1003,\n "imageDate" : "20191018",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914654428.0000,\n "Created" : "2023/03/20 16:11:00",\n "ParticipantId" : "6647/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6647/19.914654428.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914654428",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6647/19.316137488.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: fe8ddd0b21677aabda79b1282fdb22c7
List 1678914678726 imageTransferReport 1
Study 1678914678726 imageTransferReport 1
User: andrej studen CSRF: 304763f536970350a2f70ffb1f2eb852
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 577,\n "CreatedBy" : 1003,\n "imageDate" : "20200120",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914678726.0000,\n "Created" : "2023/03/20 16:11:01",\n "ParticipantId" : "6647/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6647/19.914678726.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914678726",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6647/19.316137488.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 5c59ca672dbe0003429025a109b6d201
List 1678914700222 imageTransferReport 1
Study 1678914700222 imageTransferReport 1
User: andrej studen CSRF: 87772004a8864d4fde2192d5d4349dc0
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 578,\n "CreatedBy" : 1003,\n "imageDate" : "20200323",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:02",\n "SequenceNum" : 914700222.0000,\n "ParticipantId" : "6647/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6647/19.914700222.0000",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678914700222",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6647/19.316137488.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: aef3772092ddcf10ec4d0a165a94bdde
List 1678914722172 imageTransferReport 1
Study 1678914722172 imageTransferReport 1
User: andrej studen CSRF: 698b322084e9d263f1d7c6c7dd43886a
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 579,\n "CreatedBy" : 1003,\n "imageDate" : "20200118",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:04",\n "SequenceNum" : 914722172.0000,\n "ParticipantId" : "138/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.138/20.914722172.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914722172",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.138/20.316171862.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 07138ca836c9f82f31b50c48dd6e458f
List 1678914747987 imageTransferReport 1
Study 1678914747987 imageTransferReport 1
User: andrej studen CSRF: 28a3155903cacd1e748c86ccb9fdf776
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 580,\n "CreatedBy" : 1003,\n "imageDate" : "20200602",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914747987.0000,\n "Created" : "2023/03/20 16:11:05",\n "ParticipantId" : "138/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.138/20.914747987.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914747987",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.138/20.316171862.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: bed22b5d6ee57770b80ecb339098e934
List 1678914770915 imageTransferReport 1
Study 1678914770915 imageTransferReport 1
User: andrej studen CSRF: 99afe885e485e6343694269a641ea953
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 581,\n "CreatedBy" : 1003,\n "imageDate" : "20200907",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:06",\n "SequenceNum" : 914770915.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.4847/20.914770915.0000",\n "ParticipantId" : "4847/20",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914770915",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.4847/20.316194822.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 7c0207dc3866b706fb6c5fa1c4b9ae84
List 1678914791768 imageTransferReport 1
Study 1678914791768 imageTransferReport 1
User: andrej studen CSRF: 2204afe9a6e7fa07de6fb1c606f46e5e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 582,\n "CreatedBy" : 1003,\n "imageDate" : "20210204",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:08",\n "SequenceNum" : 914791768.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.4847/20.914791768.0000",\n "ParticipantId" : "4847/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914791768",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.4847/20.316194822.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 3ac837e8dd3134db895ab5eb0cfb88be
List 1678914831439 imageTransferReport 1
Study 1678914831439 imageTransferReport 1
User: andrej studen CSRF: 2821f08d1c5aad2549325a20086bd73e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 583,\n "CreatedBy" : 1003,\n "imageDate" : "20190419",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914831439.0000,\n "Created" : "2023/03/20 16:11:09",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2029/19.914831439.0000",\n "ParticipantId" : "2029/19",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914831439",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2029/19.316577458.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 119dc28466015a5c59e161ab7fda3a21
List 1678914859377 imageTransferReport 1
Study 1678914859377 imageTransferReport 1
User: andrej studen CSRF: c1602c59578a4e751b103f0ee69499d5
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 584,\n "CreatedBy" : 1003,\n "imageDate" : "20191015",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914859377.0000,\n "Created" : "2023/03/20 16:11:10",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2029/19.914859377.0000",\n "ParticipantId" : "2029/19",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914859377",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2029/19.316577458.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: f903350f94f9be97ddca0dc323f2d555
List 1678914880449 imageTransferReport 1
Study 1678914880449 imageTransferReport 1
User: andrej studen CSRF: 79cf516da11b33084f4ec6b2962e9800
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 585,\n "CreatedBy" : 1003,\n "imageDate" : "20200406",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:11",\n "SequenceNum" : 914880449.0000,\n "ParticipantId" : "1692/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1692/20.914880449.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914880449",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1692/20.316547572.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 18db7a1b163cc99161000d7cee93db77
List 1678914902327 imageTransferReport 1
Study 1678914902327 imageTransferReport 1
User: andrej studen CSRF: 22f1c5bc5d2d8d053ccf337b158fc3e9
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 586,\n "CreatedBy" : 1003,\n "imageDate" : "20201111",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:12",\n "SequenceNum" : 914902327.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1692/20.914902327.0000",\n "ParticipantId" : "1692/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914902327",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1692/20.316547572.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 033fcabcf57a8a01d53c2dc5ff0158a8
List 1678914922947 imageTransferReport 1
Study 1678914922947 imageTransferReport 1
User: andrej studen CSRF: 00943d333a3212930fcd0ddd34936b5d
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 587,\n "CreatedBy" : 1003,\n "imageDate" : "20210318",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:13",\n "SequenceNum" : 914922947.0000,\n "ParticipantId" : "1692/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1692/20.914922947.0000",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678914922947",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1692/20.316547572.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 16ae336bb3e145ad62d1783409995e71
List 1678914945309 imageTransferReport 1
Study 1678914945309 imageTransferReport 1
User: andrej studen CSRF: 1d17306a041d57d2cfc5a232042dd697
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 588,\n "CreatedBy" : 1003,\n "imageDate" : "20190615",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914945309.0000,\n "Created" : "2023/03/20 16:11:15",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2966/19.914945309.0000",\n "ParticipantId" : "2966/19",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914945309",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2966/19.316527206.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 367a47b19fb434a2c08995a6ca126a62
List 1678914964945 imageTransferReport 1
Study 1678914964945 imageTransferReport 1
User: andrej studen CSRF: 38063440269bc47c7b45dc9f7f6d201e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 589,\n "CreatedBy" : 1003,\n "imageDate" : "20191113",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914964945.0000,\n "Created" : "2023/03/20 16:11:16",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2966/19.914964945.0000",\n "ParticipantId" : "2966/19",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678914964945",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2966/19.316527206.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: d4af33a24935672a048f78e4fe59adfe
List 1678914992427 imageTransferReport 1
Study 1678914992427 imageTransferReport 1
User: andrej studen CSRF: ba38a7b57984673db189e2d410292fb3
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 590,\n "CreatedBy" : 1003,\n "imageDate" : "20160420",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 914992427.0000,\n "Created" : "2023/03/20 16:11:17",\n "ParticipantId" : "1719/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1719/19.914992427.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678914992427",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1719/19.316505239.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 6b9113a954e549df0f0c104670099e42
List 1678915012829 imageTransferReport 1
Study 1678915012829 imageTransferReport 1
User: andrej studen CSRF: 4ca97a2ac456095355f5019a51d8d869
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 591,\n "CreatedBy" : 1003,\n "imageDate" : "20190408",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 915012829.0000,\n "Created" : "2023/03/20 16:11:18",\n "ParticipantId" : "1719/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1719/19.915012829.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678915012829",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1719/19.316505239.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 1532242093d0e0f0cfff3e51cc7f69ca
List 1678915042005 imageTransferReport 1
Study 1678915042005 imageTransferReport 1
User: andrej studen CSRF: f3d96ac8a981dfdc27c2b629d4b4385d
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 592,\n "CreatedBy" : 1003,\n "imageDate" : "20190830",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 915042005.0000,\n "Created" : "2023/03/20 16:11:20",\n "ParticipantId" : "1719/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1719/19.915042005.0000",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678915042005",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1719/19.316505239.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: c75b227b274b5954afba24fd7de03310
List 1678916454071 imageTransferReport 1
Study 1678916454071 imageTransferReport 1
User: andrej studen CSRF: 24537f11e1ba4a5f54f460bdd872afc3
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 593,\n "CreatedBy" : 1003,\n "imageDate" : "20201123",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:21",\n "SequenceNum" : 916454071.0000,\n "ParticipantId" : "6799/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6799/20.916454071.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916454071",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6799/20.316454597.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 7ff00fec345c67a2b6d24da9ab3416f3
List 1678916482395 imageTransferReport 1
Study 1678916482395 imageTransferReport 1
User: andrej studen CSRF: a47c3d039155535b77e78634f0bccdc3
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 594,\n "CreatedBy" : 1003,\n "imageDate" : "20210527",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916482395.0000,\n "Created" : "2023/03/20 16:11:23",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6799/20.916482395.0000",\n "ParticipantId" : "6799/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916482395",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6799/20.316454597.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: a7bf849ffc14d8719dec8542ffcbf415
List 1678916505503 imageTransferReport 1
Study 1678916505503 imageTransferReport 1
User: andrej studen CSRF: 35c9a9cb47641563868e22cd085319e1
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 595,\n "CreatedBy" : 1003,\n "imageDate" : "20210727",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:24",\n "SequenceNum" : 916505503.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6799/20.916505503.0000",\n "ParticipantId" : "6799/20",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678916505503",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6799/20.316454597.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 283aca53bcde635dd9d89e3a1dd6ed5d
List 1678916531804 imageTransferReport 1
Study 1678916531804 imageTransferReport 1
User: andrej studen CSRF: 4616bff9683ce84614a1abf234c8adea
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 596,\n "CreatedBy" : 1003,\n "imageDate" : "20190709",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:25",\n "SequenceNum" : 916531804.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.269/19.916531804.0000",\n "ParticipantId" : "269/19",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916531804",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.269/19.316428837.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 9de75c86fff682189cdaa469b99ad3f7
List 1678916553013 imageTransferReport 1
Study 1678916553013 imageTransferReport 1
User: andrej studen CSRF: b4f4d0b65f4651dbf0412c2fddbe21a1
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 597,\n "CreatedBy" : 1003,\n "imageDate" : "20191216",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:26",\n "SequenceNum" : 916553013.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.269/19.916553013.0000",\n "ParticipantId" : "269/19",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916553013",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.269/19.316428837.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: aa5dd5656bb3a624dcafb51087ac78e0
List 1678916574996 imageTransferReport 1
Study 1678916574996 imageTransferReport 1
User: andrej studen CSRF: e7d482106e473b6d472b2afe153006d4
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 598,\n "CreatedBy" : 1003,\n "imageDate" : "20190527",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:28",\n "SequenceNum" : 916574996.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2472/19.916574996.0000",\n "ParticipantId" : "2472/19",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916574996",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2472/19.316407799.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 05207a883c9f50f25739620c15f1c49c
List 1678916595887 imageTransferReport 1
Study 1678916595887 imageTransferReport 1
User: andrej studen CSRF: 3241e448349926beb58bb1c48ddef4fe
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 599,\n "CreatedBy" : 1003,\n "imageDate" : "20200127",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916595887.0000,\n "Created" : "2023/03/20 16:11:29",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2472/19.916595887.0000",\n "ParticipantId" : "2472/19",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916595887",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2472/19.316407799.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 81570280786f7abba0951a30a9ef7f85
List 1678916615560 imageTransferReport 1
Study 1678916615560 imageTransferReport 1
User: andrej studen CSRF: d26c3560ab6ad1ca26c211a0475b3938
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 600,\n "CreatedBy" : 1003,\n "imageDate" : "20200722",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:30",\n "SequenceNum" : 916615560.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2472/19.916615560.0000",\n "ParticipantId" : "2472/19",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678916615560",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2472/19.316407799.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: c42ebec160252d617c853c475572babd
List 1678916637199 imageTransferReport 1
Study 1678916637199 imageTransferReport 1
User: andrej studen CSRF: 6cc77a622b9b723865a7ceee4cdd86c4
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 601,\n "CreatedBy" : 1003,\n "imageDate" : "20191230",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916637199.0000,\n "Created" : "2023/03/20 16:11:31",\n "ParticipantId" : "172/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.172/20.916637199.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916637199",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.172/20.316380848.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 303e735f17385480b050c95199f039e9
List 1678916658309 imageTransferReport 1
Study 1678916658309 imageTransferReport 1
User: andrej studen CSRF: 2d116af3c8681bc9bcea2a59eca8ea9d
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 602,\n "CreatedBy" : 1003,\n "imageDate" : "20200708",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:33",\n "SequenceNum" : 916658309.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.172/20.916658309.0000",\n "ParticipantId" : "172/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916658309",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.172/20.316380848.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 04e9cb2c6cb246d05fbf0c2fa969bfbe
List 1678916684813 imageTransferReport 1
Study 1678916684813 imageTransferReport 1
User: andrej studen CSRF: 7d7afe8d7c587bee0ea89c0dc4b30db6
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 603,\n "CreatedBy" : 1003,\n "imageDate" : "20180508",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:34",\n "SequenceNum" : 916684813.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2185/18.916684813.0000",\n "ParticipantId" : "2185/18",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916684813",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2185/18.316356714.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: b541fc1ee1257cf467159a0458ce0503
List 1678916709722 imageTransferReport 1
Study 1678916709722 imageTransferReport 1
User: andrej studen CSRF: c449e294d4b7f8b307943d5c479cfb2e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 604,\n "CreatedBy" : 1003,\n "imageDate" : "20191120",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:35",\n "SequenceNum" : 916709722.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6985/19.916709722.0000",\n "ParticipantId" : "6985/19",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916709722",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6985/19.316333139.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 030930ac59be70ac21ed028180fa51e0
List 1678916736177 imageTransferReport 1
Study 1678916736177 imageTransferReport 1
User: andrej studen CSRF: 71dda24de598dab89316dc904557f93d
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 605,\n "CreatedBy" : 1003,\n "imageDate" : "20200401",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916736177.0000,\n "Created" : "2023/03/20 16:11:36",\n "ParticipantId" : "6985/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.6985/19.916736177.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916736177",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.6985/19.316333139.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 8e82d719c56eb43a4ec6673f8b43a77d
List 1678916757873 imageTransferReport 1
Study 1678916757873 imageTransferReport 1
User: andrej studen CSRF: 07118cfee492bcd9d07646478ea501a2
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 606,\n "CreatedBy" : 1003,\n "imageDate" : "20181214",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:37",\n "SequenceNum" : 916757873.0000,\n "ParticipantId" : "7790/18",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.7790/18.916757873.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916757873",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.7790/18.316313037.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 62f1bb0b64bad60c3174a51ff331d992
List 1678916782920 imageTransferReport 1
Study 1678916782920 imageTransferReport 1
User: andrej studen CSRF: 619c461075a2d15c98e682d1feb1dd84
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 607,\n "CreatedBy" : 1003,\n "imageDate" : "20180615",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:38",\n "SequenceNum" : 916782920.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2799/18.916782920.0000",\n "ParticipantId" : "2799/18",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916782920",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2799/18.316284119.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 98b6fde53cb04a172a12989ae0e35de2
List 1678916805574 imageTransferReport 1
Study 1678916805574 imageTransferReport 1
User: andrej studen CSRF: d517e48314cd348626b24354a372a906
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 608,\n "CreatedBy" : 1003,\n "imageDate" : "20200410",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916805574.0000,\n "Created" : "2023/03/20 16:11:39",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1545/20.916805574.0000",\n "ParticipantId" : "1545/20",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916805574",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1545/20.316264160.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: d051ebb8ba00f6f286d009ebec53adb3
List 1678916828446 imageTransferReport 1
Study 1678916828446 imageTransferReport 1
User: andrej studen CSRF: c98d8fe1a2c8751c8a97a9380ddb39c1
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 609,\n "CreatedBy" : 1003,\n "imageDate" : "20201006",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916828446.0000,\n "Created" : "2023/03/20 16:11:41",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1545/20.916828446.0000",\n "ParticipantId" : "1545/20",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916828446",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1545/20.316264160.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: c999804596e0aa30a7c56bee447a0a76
List 1678916848137 imageTransferReport 1
Study 1678916848137 imageTransferReport 1
User: andrej studen CSRF: a431a41a861dafbe5a9239eded89f8ca
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 610,\n "CreatedBy" : 1003,\n "imageDate" : "20210420",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:42",\n "SequenceNum" : 916848137.0000,\n "ParticipantId" : "1545/20",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.1545/20.916848137.0000",\n "imagingVisitId" : 3,\n "sourcelsid" : null,\n "crfRef" : "1678916848137",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.1545/20.316264160.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 92817fc85049e11a7b9bed6f9ca53e48
List 1678916871106 imageTransferReport 1
Study 1678916871106 imageTransferReport 1
User: andrej studen CSRF: 61871d1a510b5c97423e3fcda600181e
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 611,\n "CreatedBy" : 1003,\n "imageDate" : "20191008",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916871106.0000,\n "Created" : "2023/03/20 16:11:43",\n "ParticipantId" : "5695/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.5695/19.916871106.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916871106",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.5695/19.316238994.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 5eced20bf7ec90fb49bbc3c27f0ff4dd
List 1678916895773 imageTransferReport 1
Study 1678916895773 imageTransferReport 1
User: andrej studen CSRF: a8a7c822e64fbd55fc62654112a77e7f
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 612,\n "CreatedBy" : 1003,\n "imageDate" : "20200218",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "Created" : "2023/03/20 16:11:44",\n "SequenceNum" : 916895773.0000,\n "ParticipantId" : "5695/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.5695/19.916895773.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916895773",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.5695/19.316238994.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: d1ab84a151428590570f160d06946017
List 1678916919973 imageTransferReport 1
Study 1678916919973 imageTransferReport 1
User: andrej studen CSRF: eb0c394710b86483dcbeb05271a5eea0
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 613,\n "CreatedBy" : 1003,\n "imageDate" : "20190503",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916919973.0000,\n "Created" : "2023/03/20 16:11:46",\n "ParticipantId" : "2181/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2181/19.916919973.0000",\n "imagingVisitId" : 1,\n "sourcelsid" : null,\n "crfRef" : "1678916919973",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2181/19.316217675.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: a3886104d26efc7b287b7e786d5f323d
List 1678916943501 imageTransferReport 1
Study 1678916943501 imageTransferReport 1
User: andrej studen CSRF: 4f9c294a07b4ca0adedf36a49c284a85
b'{\n "rowsAffected" : 1,\n "queryName" : "imageTransferReport",\n "schemaName" : "study",\n "containerPath" : "/limfomiPET/Study",\n "rows" : [ {\n "date" : null,\n "dsrowid" : 614,\n "CreatedBy" : 1003,\n "imageDate" : "20191008",\n "QCState" : null,\n "submissionDate" : "2023/03/15 13:00:00",\n "SequenceNum" : 916943501.0000,\n "Created" : "2023/03/20 16:11:47",\n "ParticipantId" : "2181/19",\n "lsid" : "urn:lsid:labkey.com:Study.Data-38:5002.2181/19.916943501.0000",\n "imagingVisitId" : 2,\n "sourcelsid" : null,\n "crfRef" : "1678916943501",\n "participantCode" : "urn:lsid:labkey.com:Study.Data-38:5001.2181/19.316217675.0000"\n } ],\n "command" : "update"\n}'
User: andrej studen CSRF: 4190a7c4e913e112cde959facdfd987c
net1=labkeyInterface.labkeyInterface()
fconfig1=os.path.join(os.path.expanduser('~'),'.labkey','labkey-public.json')
net1.init(fconfig1)
net1.getCSRF()
net2=labkeyInterface.labkeyInterface()
fconfig2=os.path.join(os.path.expanduser('~'),'.labkey','labkey-klimt.json')
net2.init(fconfig2)
net2.getCSRF()
db1=labkeyDatabaseBrowser.labkeyDB(net1)
#select a project
project1='hypoAfrica/Study'
schema1='study'
query1='consentList'
db2=labkeyDatabaseBrowser.labkeyDB(net2)
#select a project
project2='hypoAfrica/Study'
schema2='study'
query2=query1
#idFilter={'variable':'ParticipantId','value':'VUB_PA3','oper':'eq'}
#aliasFilter={'variable':'aliasID','value':'3OBR','oper':'eq'}
#empty filter
qFilter=[]
#qFilter can be a list of filters used in conjugation (logical AND)
#qFilter=[aliasFilter]
ds=db1.selectRows(project1,schema1,query1,qFilter)
rows=ds['rows']
for row in rows:
#row as a dictionary
print(row)
#update row
#depending on field type adjust newValue
#change the value of the field in database
#if field is not in database, it will NOT be added and no changes will occur
print(db2.modifyRows('insert',project2,schema2,query2,[row]))
User: andrej studen CSRF: 8d5073a5a0f98622de543f64ab8319cc
User: andrej studen CSRF: 826b45d185e85d1780e89b3aac079a39
{'ParticipantId': 'JOHN003', 'followUpDuration': 1, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.JOHN003.243390879.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=1', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=JOHN003', 'crfRef': '1649243390879', 'submissionDate': '2022/04/06 14:00:00', 'SequenceNum': 243390879.0}
User: andrej studen CSRF: b0d3f22a0a97552c9877c12e0c15c803
b'{\n "rowsAffected" : 1,\n "queryName" : "consentList",\n "schemaName" : "study",\n "containerPath" : "/hypoAfrica/Study",\n "rows" : [ {\n "date" : null,\n "followUpDuration" : 1,\n "ParticipantVisit" : "JOHN003|243390879.0000",\n "dsrowid" : 1,\n "CreatedBy" : 1003,\n "Modified" : "2022-11-29 16:16:05.479",\n "DataSets" : "JOHN003",\n "QCState" : null,\n "submissionDate" : "2022-04-06 14:00:00.000",\n "ModifiedBy" : 1003,\n "Created" : "2022-11-29 16:16:05.479",\n "SequenceNum" : 243390879.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-14:5010.JOHN003.243390879.0000",\n "ParticipantId" : "JOHN003",\n "diImportHash" : null,\n "sourcelsid" : null,\n "VisitRowId" : 12,\n "crfRef" : "1649243390879"\n } ],\n "command" : "insert"\n}'
{'ParticipantId': 'NLHA001', 'followUpDuration': 3, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.NLHA001.640728995.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=3', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=NLHA001', 'crfRef': '1650640728995', 'submissionDate': '2022/04/22 14:00:00', 'SequenceNum': 640728995.0}
User: andrej studen CSRF: 671b0eb80a773813544ab14ee68273d8
b'{\n "rowsAffected" : 1,\n "queryName" : "consentList",\n "schemaName" : "study",\n "containerPath" : "/hypoAfrica/Study",\n "rows" : [ {\n "date" : null,\n "followUpDuration" : 3,\n "ParticipantVisit" : "NLHA001|640728995.0000",\n "dsrowid" : 2,\n "CreatedBy" : 1003,\n "Modified" : "2022-11-29 16:16:05.977",\n "DataSets" : "NLHA001",\n "QCState" : null,\n "submissionDate" : "2022-04-22 14:00:00.000",\n "ModifiedBy" : 1003,\n "Created" : "2022-11-29 16:16:05.977",\n "SequenceNum" : 640728995.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-14:5010.NLHA001.640728995.0000",\n "ParticipantId" : "NLHA001",\n "diImportHash" : null,\n "sourcelsid" : null,\n "VisitRowId" : 11,\n "crfRef" : "1650640728995"\n } ],\n "command" : "insert"\n}'
{'ParticipantId': 'TEST001', 'followUpDuration': 1, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.TEST001.831036294.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=1', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=TEST001', 'crfRef': '1648831036294', 'submissionDate': '2022/04/01 14:00:00', 'SequenceNum': 831036294.0}
User: andrej studen CSRF: 4197622f8e01491fbaba7c5f7ce6dfd8
b'{\n "rowsAffected" : 1,\n "queryName" : "consentList",\n "schemaName" : "study",\n "containerPath" : "/hypoAfrica/Study",\n "rows" : [ {\n "date" : null,\n "followUpDuration" : 1,\n "ParticipantVisit" : "TEST001|831036294.0000",\n "dsrowid" : 3,\n "CreatedBy" : 1003,\n "Modified" : "2022-11-29 16:16:06.428",\n "DataSets" : "TEST001",\n "QCState" : null,\n "submissionDate" : "2022-04-01 14:00:00.000",\n "ModifiedBy" : 1003,\n "Created" : "2022-11-29 16:16:06.428",\n "SequenceNum" : 831036294.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-14:5010.TEST001.831036294.0000",\n "ParticipantId" : "TEST001",\n "diImportHash" : null,\n "sourcelsid" : null,\n "VisitRowId" : 7,\n "crfRef" : "1648831036294"\n } ],\n "command" : "insert"\n}'
{'ParticipantId': 'TEST02', 'followUpDuration': 3, 'lsid': 'urn:lsid:labkey.com:Study.Data-61:5011.TEST02.953000497.0000', '_labkeyurl_followUpDuration': '/labkey/hypoAfrica/Study/list-details.view?listId=141&pk=3', '_labkeyurl_ParticipantId': '/labkey/hypoAfrica/Study/study-participant.view?participantId=TEST02', 'crfRef': '1668953000497', 'submissionDate': '2022/11/22 13:00:00', 'SequenceNum': 953000497.0}
User: andrej studen CSRF: 38717387d1d774658ac0e25920f0fef2
b'{\n "rowsAffected" : 1,\n "queryName" : "consentList",\n "schemaName" : "study",\n "containerPath" : "/hypoAfrica/Study",\n "rows" : [ {\n "date" : null,\n "followUpDuration" : 3,\n "ParticipantVisit" : "TEST02|953000497.0000",\n "dsrowid" : 4,\n "CreatedBy" : 1003,\n "Modified" : "2022-11-29 16:16:06.933",\n "DataSets" : "TEST02",\n "QCState" : null,\n "submissionDate" : "2022-11-22 13:00:00.000",\n "ModifiedBy" : 1003,\n "Created" : "2022-11-29 16:16:06.933",\n "SequenceNum" : 953000497.0000,\n "lsid" : "urn:lsid:labkey.com:Study.Data-14:5010.TEST02.953000497.0000",\n "ParticipantId" : "TEST02",\n "diImportHash" : null,\n "sourcelsid" : null,\n "VisitRowId" : 8,\n "crfRef" : "1668953000497"\n } ],\n "command" : "insert"\n}'