<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EstiloCorreo19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="ES" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hello Cecile!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thank you for your kind response. You were completely correct, the problem was the visit label not being read correctly,
but we managed to solve this by adding an optional parameter: patient_name as seen below<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">(loris-mri-python) lorisadmin@maria-HP-ProBook-650-G2:/opt/loris/bin/mri$ uploadNeuroDB/imaging_non_minc_insertion.pl
-profile prod -upload_id 1 -file_path /home/lorisadmin/Downloads/DCC0000_359572_V3.zip -output_type native -scan_type t1 -date_acquired 2012-04-20 -scanner_id 1 -coordin_space native -reckless -verbose -patient_name DCC0000_359572_V3
<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">However, this proved to come with its fair share of errors, it seems the file Is read well and moved to another location
(/data/loris/data/assembly/359572/V3/mri/native/) but the console output reads as follows:<o:p></o:p></span></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">log dir is /data/loris/data/logs and log file is /data/loris/data/logs/FileLoad-12-20-gEsQPj.log.<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">PSCID is: DCC0000<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">CandID id: 359572<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">visit_label is: V3<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">PSCID is: DCC0000<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">CandID id: 359572<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">visit_label is: V3<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> -> ScannerID was set to 1<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> -> SessionID was set to 1<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> -> Acquisition date was set to 2012-04-20<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> -> Output type was set to native<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Acquisition date: 2012-04-20<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">DBD::mysql::db do failed: Unknown column 'PhaseEncodingDirection' in 'field list' at /opt/loris/bin/mri/uploadNeuroDB/NeuroDB/MRI.pm
line 793.<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`LORIS`.`parameter_file`,
CONSTRAINT `FK_parameter_file_1` FOREIGN KEY (`FileID`) REFERENCES `files` (`FileID`)) at /opt/loris/bin/mri/uploadNeuroDB/NeuroDB/MRI.pm line 818.<o:p></o:p></span></i></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">We had the idea of adding another parameter indicating there was a json file with said Phase encoding direction inside
((<i>loris-mri-python) lorisadmin@maria-HP-ProBook-650-G2:/opt/loris/bin/mri$ uploadNeuroDB/imaging_non_minc_insertion.pl -profile prod -upload_id 1 -file_path /home/lorisadmin/Downloads/DCC0000_359572_V3.zip -output_type native -scan_type t1 -date_acquired
2012-04-20 -scanner_id 1 -coordin_space native -reckless -verbose -patient_name DCC0000_359572_V3 -metadata_file /home/lorisadmin/Downloads/patient.json</i>) , but it was of no use, the console sent us the same message.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Inside the log file
<i>FileLoad-12-20-gEsQPj.log</i> here is what is written<i>:<o:p></o:p></i></span></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">==> computing md5 hash for MINC body.<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">--> md5: aab815082fbf91e7e3e26b7f6b899e2d<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">File /home/lorisadmin/Downloads/DCC0000_359572_V3.zip
<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">moved to:<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">/data/loris/data/assembly/359572/V3/mri/native/loris_359572_V3_t1_001.zip<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">ative<o:p></o:p></span></i></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">And the MRICandidateErrors has an empty set.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Any help would be much appreciated, best regards!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">María<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">De:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Cecile Madjar <cecile.madjar@mcin.ca>
<br>
<b>Enviado el:</b> martes, 22 de noviembre de 2022 17:35<br>
<b>Para:</b> Olano.María <molano@ext.cnio.es>; loris-dev <loris-dev@bic.mni.mcgill.ca><br>
<b>Asunto:</b> imaging_non_minc_insertion.pl issue with scanner_id<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="background:orange"><strong><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:white">CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the
sender and know the content is safe</span></strong> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal">Dear Maria,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Sorry for the late reply. For some reason I never received your email. Luckily, someone else from the LORIS team just flagged it and sent it to me.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">It looks like the latest issue you are encountering is that the visit label is not properly parsed by the getSubjectIDs function in your prod file. Instead of returning V3, it returns V3.zip which is most likely not a valid visit label
for your project.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The other possibility could be that DCC0000 and 359572 do not refer to the same candidate. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">In any case, I think for both situations, an entry has been added to the MRICandidateErrors table and you could see the file in the MRI violations module where the file would be logged there.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Let me know if that helps. Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cécile<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">---------- Forwarded message ---------<br>
From: <strong>Olano.María</strong> <<a href="mailto:molano@ext.cnio.es" target="_blank">molano@ext.cnio.es</a>><br>
Date: Thu, Nov 17, 2022 at 10:24 AM<br>
Subject: Re: [Loris-dev] <a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> issue with scanner_id<br>
To: <a href="mailto:loris-dev@bic.mni.mcgill.ca" target="_blank">loris-dev@bic.mni.mcgill.ca</a> <<a href="mailto:loris-dev@bic.mni.mcgill.ca" target="_blank">loris-dev@bic.mni.mcgill.ca</a>><o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">Good afternoon!</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">We managed to solve the issue with the scanner_id by linking the CandID to the scanner</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">mysql> SELECT * FROM `mri_scanner`;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">+----+--------------+---------+---------------+----------+--------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">| ID | Manufacturer | Model | Serial_number | Software | CandID |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">+----+--------------+---------+---------------+----------+--------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">| 0 | NULL | NULL | NULL | NULL | NULL |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">| 1 | SIEMENS | TrioTim | 35008 | Python | 359572 |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">| 10 | NULL | NULL | NULL | NULL | NULL |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">+----+--------------+---------+---------------+----------+--------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">And later got the upload_id error:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">(loris-mri-python) lorisadmin@maria-HP-ProBook-650-G2:/opt/loris/bin/mri$ uploadNeuroDB/<a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> -profile
prod -upload_id 1 -file_path /home/lorisadmin/Documents/DCC0000_359572_V3.zip -output_type native -scan_type t1 -date_acquired 2012-04-20 -scanner_id 1 -coordin_space native -reckless -verbose</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">log dir is /data/loris/data/logs and log file is /data/loris/data/logs/FileLoad-11-48-F5qW5R.log.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> ERROR: Invalid UploadID 1.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">Managed to side step this error by using the front end Imaging Uploader which filled out the mri_upload table with the UploadID 1</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">mysql> SELECT * FROM `mri_upload`;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">+----------+------------+---------------------+-------------------------------------------------+----------------------+-------------------+-----------+-------------------+------------------------+-----------------------+------------+-----------+--------------------------+---------------------+-----------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">| UploadID | UploadedBy | UploadDate | UploadLocation | DecompressedLocation | InsertionComplete
| Inserting | PatientName | number_of_mincInserted | number_of_mincCreated | TarchiveID | SessionID | IsCandidateInfoValidated | IsTarchiveValidated | IsPhantom |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">+----------+------------+---------------------+-------------------------------------------------+----------------------+-------------------+-----------+-------------------+------------------------+-----------------------+------------+-----------+--------------------------+---------------------+-----------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">| 1 | lorisadmin | 2022-11-17 14:40:58 | /data/incoming/lorisadmin/DCC0000_359572_V3.zip | |
0 | NULL | DCC0000_359572_V3 | NULL | NULL | NULL | 1 | NULL | 0 | N |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">+----------+------------+---------------------+-------------------------------------------------+----------------------+-------------------+-----------+-------------------+------------------------+-----------------------+------------+-----------+--------------------------+---------------------+-----------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">However! It didn’t manage to upload correctly so we tried to use the back end again with <a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> (as
this isn’t a DICOM file) and we are presented with our last error:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">(loris-mri-python) lorisadmin@maria-HP-ProBook-650-G2:/opt/loris/bin/mri$ uploadNeuroDB/<a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> -profile
prod -upload_id 1 -file_path /data/incoming/lorisadmin/DCC0000_359572_V3.zip -output_type native -scan_type t1 -date_acquired 2012-04-20 -scanner_id 1 -coordin_space native -reckless -verbose</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">log dir is /data/loris/data/logs and log file is /data/loris/data/logs/FileLoad-16-0-_g35H2.log.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">PSCID is: DCC0000</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">CandID id: 359572</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">visit_label is: V3.zip</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">PSCID is: DCC0000</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">CandID id: 359572</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">visit_label is: V3.zip</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">=> No Visit label</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> ERROR: Candidate IDs mismatch for /data/incoming/lorisadmin/DCC0000_359572_V3.zip.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">This Visit label has been populated in the MySQL visit table, so we don’t know what mismatch it is referring to.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">Any help would be much appreciated.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D">María</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b>De:</b> Olano.María<br>
<b>Enviado el:</b> miércoles, 16 de noviembre de 2022 14:11<br>
<b>Para:</b> '<a href="mailto:loris-dev@bic.mni.mcgill.ca" target="_blank">loris-dev@bic.mni.mcgill.ca</a>' <<a href="mailto:loris-dev@bic.mni.mcgill.ca" target="_blank">loris-dev@bic.mni.mcgill.ca</a>><br>
<b>Asunto:</b> <a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> issue with scanner_id<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Good afternoon,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Hope this email finds you well. We are having problems using the <a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> as
when we execute the command this what pops up in the terminal.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">(loris-mri-python) lorisadmin@maria-HP-ProBook-650-G2:/opt/loris/bin/mri$ uploadNeuroDB/<a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> -profile
prod -upload_id 1 -file_path /home/lorisadmin/Documents/DCC0000_359572_V3.zip -output_type native -scan_type t1 -date_acquired 2012-04-20 -scanner_id 0 -coordin_space native -reckless -verbose</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">This script inserts a file in the files and parameter_file tables.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Usage: perl <a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> [options]</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">-help for options</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> ERROR: missing -scanner_id argument</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">As you can see, scanner_id is included in the options accompanying the command, but when changing the ID from 0 to 10 it does recognize scanner_id, shown as followed:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">(loris-mri-python) lorisadmin@maria-HP-ProBook-650-G2:/opt/loris/bin/mri$ uploadNeuroDB/<a href="http://imaging_non_minc_insertion.pl/" target="_blank">imaging_non_minc_insertion.pl</a> -profile
prod -upload_id 1 -file_path /home/lorisadmin/Documents/DCC0000_359572_V3.zip -output_type native -scan_type t1 -date_acquired 2012-04-20 -scanner_id 10 -coordin_space native -reckless -verbose</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">log dir is /data/loris/data/logs and log file is /data/loris/data/logs/FileLoad-12-49-8uubDY.log.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> ERROR: Invalid ScannerID 10.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Both IDs are in the MYSQL table “mri_scanner” so we don’t know what the problem could be.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">mysql> SELECT * FROM `mri_scanner`;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">+----+--------------+-------+---------------+----------+--------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">| ID | Manufacturer | Model | Serial_number | Software | CandID |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">+----+--------------+-------+---------------+----------+--------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">| 0 | NULL | NULL | NULL | NULL | NULL |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">| 10 | NULL | NULL | NULL | NULL | NULL |</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">+----+--------------+-------+---------------+----------+--------+</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Any help would be much appreciated.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Best regards,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">María</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><br>
<br>
**ADVERTENCIA LEGAL**: Este correo electrónico, y en su caso los ficheros adjuntos, pueden contener información protegida para el uso exclusivo de su destinatario. Se prohíbe la distribución, reproducción o cualquier otro tipo de transmisión por parte de otra
persona que no sea el destinatario. Si usted recibe por error este correo, se ruega comunicarlo al remitente y borrar el mensaje recibido.<br>
De conformidad con lo dispuesto en el Reglamento (UE) 2016/679 relativo a la protección de los datos personales de las personas físicas, la información personal que nos pueda facilitar a través de este correo electrónico quedará registrada por la Fundación
CNIO con la finalidad de tramitar el objeto del presente correo electrónico. El tratamiento de sus datos personales se encuentra legitimado por ser necesario para gestionar el objeto del presente mensaje. Estos datos personales no serán comunicados a ningún
destinatario salvo a aquellos que usted nos autorice o así venga exigido por una ley. Ud. podrá ejercer los derechos de acceso, rectificación, supresión, limitación de tratamiento, portabilidad y oposición en la siguiente dirección: c/Melchor Fernandez Almagro
3, 28029 (Madrid). Podrá ponerse en contacto con el Delegado de Protección de Datos en: <a href="mailto:delegado_lopd@cnio.es" target="_blank">delegado_lopd@cnio.es</a>. Para el caso de que Ud. precise conocer información adicional sobre el tratamiento de
sus datos personales, puede consultar dicha información adicional en el siguiente enlace dentro de nuestra página web: <a href="https://www.cnio.es/es/privacidad/index.asp" target="_blank">https://www.cnio.es/es/privacidad/index.asp</a><br>
<br>
**LEGAL NOTICE**: This email and any attached files may contain protected information for the sole use of its intended recipient or addressee. Anyone other than the intended recipient or addressee is strictly prohibited from distributing, reproducing or transmitting
the email and its contents in any way. If you receive this email in error, please notify the sender and delete the message.<br>
Pursuant to the provisions of EU Regulation 2016/679 regarding the protection of personal data, any personal information you provide through this email will be registered by the CNIO Foundation in order to deal with content of this email. Your personal data
must be processed in order to be able to deal with the content and purpose of this message. Your personal details will not be passed on to anyone else unless you authorise us to do so or we are required to do so by law. You may exercise your rights regarding
access, rectification, suppression, limitation of processing, portability and opposition by writing to the following address: c/Melchor Fernandez Almagro 3, 28029 (Madrid). You may contact the Data Protection Delegate (Delegado de Protección de Datos) at: <a href="mailto:delegado_lopd@cnio.es" target="_blank">delegado_lopd@cnio.es</a>.
If you require further information about the processing of your personal data, go to the following link on our webpage: <a href="https://www.cnio.es/es/privacidad/index.asp" target="_blank">https://www.cnio.es/es/privacidad/index.asp</a><o:p></o:p></p>
</div>
<p class="MsoNormal">_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
<br>
<br>
**ADVERTENCIA LEGAL**: Este correo electrónico, y en su caso los ficheros adjuntos, pueden contener información protegida para el uso exclusivo de su destinatario. Se prohíbe la distribución, reproducción o cualquier otro tipo de transmisión por parte de otra
persona que no sea el destinatario. Si usted recibe por error este correo, se ruega comunicarlo al remitente y borrar el mensaje recibido.<br>
De conformidad con lo dispuesto en el Reglamento (UE) 2016/679 relativo a la protección de los datos personales de las personas físicas, la información personal que nos pueda facilitar a través de este correo electrónico quedará registrada por la Fundación
CNIO con la finalidad de tramitar el objeto del presente correo electrónico. El tratamiento de sus datos personales se encuentra legitimado por ser necesario para gestionar el objeto del presente mensaje. Estos datos personales no serán comunicados a ningún
destinatario salvo a aquellos que usted nos autorice o así venga exigido por una ley. Ud. podrá ejercer los derechos de acceso, rectificación, supresión, limitación de tratamiento, portabilidad y oposición en la siguiente dirección: c/Melchor Fernandez Almagro
3, 28029 (Madrid). Podrá ponerse en contacto con el Delegado de Protección de Datos en: delegado_lopd@cnio.es. Para el caso de que Ud. precise conocer información adicional sobre el tratamiento de sus datos personales, puede consultar dicha información adicional
en el siguiente enlace dentro de nuestra página web: https://www.cnio.es/es/privacidad/index.asp
<br>
<br>
**LEGAL NOTICE**: This email and any attached files may contain protected information for the sole use of its intended recipient or addressee. Anyone other than the intended recipient or addressee is strictly prohibited from distributing, reproducing or transmitting
the email and its contents in any way. If you receive this email in error, please notify the sender and delete the message.<br>
Pursuant to the provisions of EU Regulation 2016/679 regarding the protection of personal data, any personal information you provide through this email will be registered by the CNIO Foundation in order to deal with content of this email. Your personal data
must be processed in order to be able to deal with the content and purpose of this message. Your personal details will not be passed on to anyone else unless you authorise us to do so or we are required to do so by law. You may exercise your rights regarding
access, rectification, suppression, limitation of processing, portability and opposition by writing to the following address: c/Melchor Fernandez Almagro 3, 28029 (Madrid). You may contact the Data Protection Delegate (Delegado de Protección de Datos) at:
delegado_lopd@cnio.es. If you require further information about the processing of your personal data, go to the following link on our webpage: https://www.cnio.es/es/privacidad/index.asp
</body>
</html>