search

datawiser / qual2db

Python code for extracting data from the Qualtrics API and posting to a MySQL database
8 stars 8 forks source link

Using qual2db 3.0 programmatically? #23

Open kgweber-sag opened 6 years ago

kgweber-sag commented 6 years ago

Hi, all:

The GUI version on the front of qual2db is just lovely, but I'd really like to be calling its functionality from a script. The documentation on the wiki must be referring to an earlier version, as I'm not finding much that resembles the code I see.

Before I take the tool apart, can you let me know whether there are modules specifically aimed at being called without the intervention of the GUI?

datawiser commented 6 years ago

Hi @arfenarf -- have we met? Thanks for looking into BDI. Your comment is timely. @joseabraham-mena and I (Neil Carlson) were just talking yesterday morning about repository management.

The "csr-working" branch on this repository is the version described in the wiki; we call it 2.0, though there's no versioning tags in the repository. It works on Qualtrics' API 2.3 and Python 2.x and a tkinter desktop GUI. It has some limitations related to the API version--it can't retrieve data edited in the Qualtrics Data and Analysis tab, for example, or handle drill-down questions. However, the data model and our understanding of it is very stable and useful for Tableau and similar analysis.

The other branches here are in-progress captures of our work on qual2db 3.0, which uses Qualtrics API 3.x, Python 3.x, and a cherrypy web server GUI which is our active area of development. We're working toward a stable beta release, but there are still some possible bugs. Abe can comment on the best path to get a version of 3.0 running, if you want.

We'd be happy to try to learn from your efforts to deploy qual2db, to consider integration of any code you contribute, and to consider any issues you add here for development time.

kgweber-sag commented 6 years ago

Thank you so much for your input. I'll look at the older version and see whether it's easier to import and call from code, and will certainly add thoughts as I find them. My use case is a regular, incremental refresh of the Qualtrics data, as I've found the Tableau WDC to be rather flaky. Thanks again.

datawiser commented 6 years ago

Great! @oaselles is the author of the 2.0 code, and he's always run it from the command line without the GUI. He should be able to help you understand how to control it with code.