[Loris-dev] Questions regarding querying LORIS

[Christine Rogers, Ms.]

Hi Remya,

Thanks for your inquiry --

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?

Yes, the Data Querying Tool (DQT) module is designed for precisely that purpose.
Try it out at demo.loris.ca<http://demo.loris.ca> -- you'll find this module under the "Tools" menu.
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.
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.

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)?

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.

Storing files in LORIS attached to a participant-timepoint (without processing the data contents), can also be done via the Media Module.

Best,
Christine
The LORIS team


On Fri, Aug 30, 2019 at 5:44 PM Remya Nair <rnair at caltech.edu<mailto:rnair at caltech.edu>> wrote:
Hi,

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.

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?

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)?

Your take on the above questions would be greatly appreciated. Thank you in advance for your help.


Best,
Remya


--


_______________________________________________
Loris-dev mailing list
Loris-dev at bic.mni.mcgill.ca<mailto:Loris-dev at bic.mni.mcgill.ca>
https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev


--

christine.rogers at mcgill.ca<mailto:christine.rogers at mcgill.ca>
McGill Centre for Integrative Neuroscience | MCIN.ca
Montreal Neurological Institute
McGill University | Montreal | Canada
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20190902/f039ccc0/attachment.html>