Skip to content

Automating IBM SPSS Data Collection survey export?

soujanya bargavi edited this page Jan 4, 2019 · 1 revision

I'm so sorry for the vague question here, but I'm hoping an SPSS expert will be able to help me out here. We have some surveys that are done via SPSS, from which we extract data for an internal report. Right now the process is very cumbersome and requires going to the SPSS Data Collection Interviewer Server Administration page and manually exporting data from two different projects (which takes hours at a time!). We then take that data, massage it, and upload it to another database that drives the internal report.

My question is, does anyone out there know how to automate this process? Is there a SQL Server database behind the SPSS data? Where does the .mdd file come in to play? Can my team (who is well-versed in extracting data from various sources) tap into the SQL Server database behind IBM SPSS to get our data? Or do we need some sort of Python script and plugin? IBM SPSS Training

If I'm missing information that would be helpful in answering the question, please let me know. I'm happy to provide it; I just don't know what to provide.

Clone this wiki locally