Repository navigation
Getting Started
Owen Selles edited this page May 15, 2015
·
19 revisions
qual2db is easy install and use. It was deliberately built using only standard Python libraries so all you need is Python 2.7. No dependencies are required.
- Python 2.7
- A Qualtrics account with API access
- A MySQL database
- The Python-MySQL ODBC connector for Python 2.7.
At the moment, the best way to use qual2db is to:
- Download and unzip the source code
- Write scripts in the same directory as the qual2db folder that "import" qual2db
###Folder structure
your workspace/
example_script.py
qual2db/
config.ini
config.py
qualInterface.py
sqlInterface.py
survey.py
###Example Script
import qual2db
s = qual2db.survey('your survey id')
s.describe()Once you have downloaded and unzipped the code you must enter your credentials into the configuration file (config.ini).
###Qualtrics Credentials
| Credential | Description |
|---|---|
| basurl | Leave this as the default: https://survey.qualtrics.com/WRAPI/ControlPanel/api.php?
|
| User | The Qualtrics username of an account with API access |
| Password | The account password |
| Version | The API version. Leave this as the default: 2.3. |
###MySQL Credentials
| Credential | Description |
|---|---|
| sqlUser | MySQL username with read/write privileges |
| sqlPassword | MySQL account password |
| sqlHost | Database server url |
| sqlDB | The database where the qual2db tables will be stored |
##Setting up MySQL tables To set up the MySQL table structure write and run a script like this:
import qual2db
qual2db.sqlInterface.configure_db()This will create all the tables needed to store Qualtrics data. It is recommended that you designate a MySQL database for the sole purpose of holding these tables.
- Group and Rank Questions
- Choice and answer re-coding
- Gap Analysis
- Heat map