Skip to content
Owen Selles edited this page Jun 3, 2015 · 135 revisions

[insert logo here]

Table of Contents

  1. Background
  2. Supported Features
  3. Installation & Configuration

Background

##What is qual2db? qual2db is an python package that transforms Qualtrics survey data into multiple tables (Surveys, Blocks, Questions, Choices, Answers, Respondents, Responses) and uploads it into a MySQL relational database.

qual2db was created by the Center for Social Research (CSR) at Calvin College to make use of the relational database structure.

##Why is qual2db useful? There are many advantages to using a RDB for storing and managing survey data. A few of the biggest are:

A master archive

Have a lot of survey data? qual2db lets you stop worrying about spreadsheets, SPSS files, and folder paths, because all your survey data can be stored in one place in a standard format.

Sharing data is easy

Need to share data across your research team? Using qual2db's master RDB means that everyone's reporting and analysis tools can point to one raw master dataset simultaneously.

Powerful queries

qual2db's RDB structure allows you to create powerful stacked queries for analysis and visualization. It is also easy to perform cross-survey analysis, since all your survey data is in the same place and the same format.

How does qual2db work?

qual2db is composed of three python objects (or classes). The qualInterface and the sqlInterface communicate with the Qualtrics API and a MySQL database respectively. The survey object uses both these objects to transfer and process data between systems.

###Folder structure

qual2db/
         __init__.py
         config.ini
         config.py
         qualInterface.py
         sqlInterface.py
         survey.py
File Description
config.ini configuration file
config.py configuration file reader
qualInterface.py contains the qualInterface class and all the functions related to processing Qualtrics data
sqlInterface.py contains the sqlInterface class and all the functions related to MySQL
survey contains the survey object

###Database structure When a Qualtrics survey is brought into the MySQL database it is stored in 5 related tables.

table structure

Table Description
surveys information about the survey
blocks survey question blocks
questions questions and embedded data fields with detailed information
choices question choices
answers answers options for matrix and side-by-side questions
respondents survey respondents with information
responses every question response for every respondent

Clone this wiki locally