Data Querying Tool

HOME > SETUP > DATA QUERY TOOL

The Data Query Tool is an open-source extension of LORIS which enables users to query and download datasets. Front-end users can design and store queries to extract any data available in LORIS, including imaging data.

Installing the Data Query Tool

Please see the Data Query Tool Readme (in beta) for installation instructions. Detailed instructions for some systems are available in the DQT repository wiki

Loading the Data Query Tool

Custom php scripts are provided in the LORIS codebase for loading data into the Data Query Tool.
Before attempting to load data into the Data Query Tool, the Data Dictionary must be generated.

In your LORIS tools/ directory, run the CouchDB_Import_* scripts to import each type of data :

• Base candidate data : CouchDB_Import_Demographics.php : Run first to import base candidate data

• Instrument data : CouchDB_Import_Instruments.php - omit if Behavioural data not used

• Imaging (MRI) data : CouchDB_Import_MRI.php - omit if Imaging data not used

• Radiological review module data : CouchDB_Import_RadiologicalReview.php - omit unless module in use

cd /var/www/$projectname/tools php CouchDB_Import_Demographics.php php CouchDB_Import_Instruments.php php CouchDB_Import_MRI.php php CouchDB_Import_RadiologicalReview.php

The MRI import script may require some editing or configuration to find the exact path for all imaging data.  Selected mincs may should be populated for the appropriate session under the field "Selected_$SCANTYPE" e.g. Selected_t1.  Files should then be available for download under the "View Data" tab either by clicking the link after running the query, or clicking on "Download all as zip" button.

CouchDB_Import_*.php scripts are provided in the tools/ directory to push Demographic, Instrument, MRI and Radiological Review data from LORIS into the DQT. Note that CouchDB_Import_Demographics.php must be run first. 

Upon initial import of data, it may take between a few minutes and a few hours to build the initial indexes, depending on the size of your dataset

### Troubleshooting

* If queries do not run immediately after setting up the DQT, note that it may take between a few minutes and a few hours to build the initial indexes, depending on the size of your dataset
* [Futon](http://docs.couchdb.org/en/stable/intro/tour.html#welcome-to-futon), the built-in administrative interface for CouchDB, is highly useful for debugging

### User Help
A User Guide is available within the DQT's Help section, by clicking on Question Mark icon in top menu bar.