Repository navigation
Getting Started
Owen Selles edited this page May 5, 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
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 sole purpose of holding these tables.