Skip to content
Owen Selles edited this page Apr 30, 2015 · 135 revisions

[insert logo here]

Table of Contents

Background

##What is qual2db? qual2db is an object-based python package that transforms Qualtrics survey data into a 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 replace the useful relational database structure formerly provided by the Inquisite survey system.

##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 tidy 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 sqlInferface object and the qualInterface object communicate with a MySQL database and the Qualtrics API respectively. The survey object uses both these objects to transfer and process data between systems.

The folder structure below:

qual2db/
         __init__.py
         config.ini
         config.py
         qualInterface.py
         sqlInterface.py
         survey.py

Installation & Configuration

qual2db is very easy to install. It was deliberately designed to only use built-in Python modules so no additional packages need to be installed.

Requirements

  • Python 2.7
  • A Qualtrics account with API access
  • A MySQL database
  • The python-MySQL ODBC connector

Installation

At this point the best way to use qual2db is to download the code, unzip it somewhere in your workspace and then write scripts that import it as qual2db.

Configuration

Once you have downloaded

Clone this wiki locally