<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div dir="ltr">Hi Remya,
<div><br>
</div>
<div>Thanks for your inquiry -- </div>
<div><br>
</div>
<div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
1. If we have data stored on several instruments within LORIS, is it possible to query, filter and export specific data that we need into a CSV file (or any spreadsheet) using the LORIS interface? If not, is this a feature currently being developed?</blockquote>
<div><br>
</div>
<div>Yes, the Data Querying Tool (DQT) module is designed for precisely that purpose. </div>
<div>Try it out at <a href="http://demo.loris.ca">demo.loris.ca</a> -- you'll find this module under the "Tools" menu. </div>
<div>The Data Querying Tool allows users to design, save and share custom queries, and to download the results as a CSV file, though the LORIS front-end. Users can query and filter specific data fields or whole instruments across timepoints, including metadata,
demographic data, and imaging data. The DQT is also extensible for genomic data. </div>
<div>For example, a user can filter for only female subjects that have a T1 scan completed, and have an IQ score above a certain threshold, etc. </div>
<div><br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
2. Currently we understand the way to do mass uploads of data into a LORIS instrument is via the database directly. Is there any way to upload data into an instrument directly from a CSV instead (or any spreadsheet format file)?</blockquote>
<div><br>
</div>
<div>A module to load instrument data via the front-end is in our Roadmap for development; for the present we recommend a simple script to load instruments fields from a CSV into the corresponding database table field. </div>
<div><br>
</div>
<div>Storing files in LORIS attached to a participant-timepoint (without processing the data contents), can also be done via the Media Module. </div>
<div><br>
</div>
<div>Best,</div>
<div>Christine </div>
<div>The LORIS team </div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, Aug 30, 2019 at 5:44 PM Remya Nair <<a href="mailto:rnair@caltech.edu">rnair@caltech.edu</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hi,</div>
<div dir="ltr">
<div><br>
</div>
<div>We have a couple of questions that we were hoping the LORIS developers might be able to help with. Apologies if this has been answered previously on this forum.</div>
<div><br>
</div>
<div>1. If we have data stored on several instruments within LORIS, is it possible to query, filter and export specific data that we need into a CSV file (or any spreadsheet) using the LORIS interface? If not, is this a feature currently being developed?</div>
<div><br>
</div>
<div>2. Currently we understand the way to do mass uploads of data into a LORIS instrument is via the database directly. Is there any way to upload data into an instrument directly from a CSV instead (or any spreadsheet format file)?</div>
<div><br>
</div>
<div>Your take on the above questions would be greatly appreciated. Thank you in advance for your help.</div>
<div dir="ltr"><br>
</div>
<div dir="ltr"><br>
</div>
Best,</div>
<div dir="ltr">Remya</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail-m_-8508943080260252671gmail_signature">
<div dir="ltr">
<div style="font-size:12.8px">
<p><br>
</p>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<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" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a><br>
McGill Centre for Integrative Neuroscience | MCIN.ca</div>
<div>Montreal Neurological Institute</div>
<div>McGill University | Montreal | Canada</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>