Discussion:
Trouble importing data from Qualtrics
Stefana Racorean
2018-05-31 20:21:28 UTC
Permalink
Hi,
I'm a new user of PSPP on a Windows computer, and I have trouble importing
data from Qualtrics into the program. After selecting the file, the program
doesn't display any of the options on customizing my variables. I can hit
next and then apply, but then the variables are inserted automatically, and
the the responses are not imported. Here are some print screens of what
happens.
Could you help me?
Thank you!
Stefana
Alan Mead
2018-05-31 23:00:26 UTC
Permalink
Stefana,

This sounds like a bug others have encountered. Can you tell us the
version you are using (Help > About).

Do you know the file format the Qualtrics file? I think it's a delimited
file, but that's a guess... PSPP is limited in which file formats it can
import.

-Alan
Post by Stefana Racorean
Hi,
I'm a new user of PSPP on a Windows computer, and I have trouble
importing data from Qualtrics into the program. After selecting the
file, the program doesn't display any of the options on customizing my
variables. I can hit next and then apply, but then the variables are
inserted automatically, and the the responses are not imported. Here
are some print screens of what happens. 
Could you help me?
Thank you!
Stefana
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
--
Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.

science + technology = better workers

http://www.alanmead.org

I've... seen things you people wouldn't believe...
functions on fire in a copy of Orion.
I watched C-Sharp glitter in the dark near a programmable gate.
All those moments will be lost in time, like Ruby... on... Rails... Time for Pi.

--"The Register" user Alister, applying the famous
"Blade Runner" speech to software development
Stefana Racorean
2018-06-01 12:05:15 UTC
Permalink
Hi Alan,

Thanks for getting back to me so soon. Here is the version of PSPP I
downloaded: GNU pspp 0.10.5-pre2g9a68ff
The file I was trying to import is a .csv file. The tutorials said it was
compatible.

Best,
Stefana
Post by Alan Mead
Stefana,
This sounds like a bug others have encountered. Can you tell us the
version you are using (Help > About).
Do you know the file format the Qualtrics file? I think it's a delimited
file, but that's a guess... PSPP is limited in which file formats it can
import.
-Alan
Hi,
I'm a new user of PSPP on a Windows computer, and I have trouble importing
data from Qualtrics into the program. After selecting the file, the program
doesn't display any of the options on customizing my variables. I can hit
next and then apply, but then the variables are inserted automatically, and
the the responses are not imported. Here are some print screens of what
happens.
Could you help me?
Thank you!
Stefana
_______________________________________________
--
Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.
science + technology = better workers
http://www.alanmead.org
I've... seen things you people wouldn't believe...
functions on fire in a copy of Orion.
I watched C-Sharp glitter in the dark near a programmable gate.
All those moments will be lost in time, like Ruby... on... Rails... Time for Pi.
--"The Register" user Alister, applying the famous
"Blade Runner" speech to software development
Alan Mead
2018-06-01 14:02:46 UTC
Permalink
I think you are experiencing bug 52873 .

It looks like the latest version available here:

http://pspp.awardspace.com/

is GNU pspp 1.0.1-g818227 and I installed that version. It will read my
test CSV data but now allow me to read the variable names nor modify the
types, etc. I can think of a few workarounds:

* Place the file someplace like C:\ . This worked for me, although a
network drive of G:\ did not (PSPPire crashed). There is something
about long paths that seems to trigger bug 52873 .
* Read the file into LibreOffice and save it as a spreadsheet; PSPP
reads .ODS files.
* Paste the resulting syntax and then edit it to achieve your desired
goal (e.g., rename VAR001, VAR002, etc. to the names and formats you
want).
* Install the latest version at the URL above and import the data and
then manually fix the data (e.g., rename VAR001, VAR002, etc. to the
names and formats you want).
* Uninstall PSPP and find version from 2016-07-14 and install that. It
is reported to handle this issue correctly.

If that doesn't work, is it possible to send a small sample of the CSV
file to the list or attach it to this bug:
https://savannah.gnu.org/bugs/?52873 ? Maybe there's something about
your file that is triggering this issue.

-Alan
Post by Stefana Racorean
Hi Alan,
Thanks for getting back to me so soon. Here is the version of PSPP I
downloaded: GNU pspp 0.10.5-pre2g9a68ff
The file I was trying to import is a .csv file. The tutorials said it
was compatible.
Best,
Stefana
Stefana,
This sounds like a bug others have encountered. Can you tell us
the version you are using (Help > About).
Do you know the file format the Qualtrics file? I think it's a
delimited file, but that's a guess... PSPP is limited in which
file formats it can import.
-Alan
Post by Stefana Racorean
Hi,
I'm a new user of PSPP on a Windows computer, and I have trouble
importing data from Qualtrics into the program. After selecting
the file, the program doesn't display any of the options on
customizing my variables. I can hit next and then apply, but then
the variables are inserted automatically, and the the responses
are not imported. Here are some print screens of what happens. 
Could you help me?
Thank you!
Stefana
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
<https://lists.gnu.org/mailman/listinfo/pspp-users>
--
Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.
science + technology = better workers
http://www.alanmead.org
I've... seen things you people wouldn't believe...
functions on fire in a copy of Orion.
I watched C-Sharp glitter in the dark near a programmable gate.
All those moments will be lost in time, like Ruby... on... Rails... Time for Pi.
--"The Register" user Alister, applying the famous
"Blade Runner" speech to software development
--
Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.

science + technology = better workers

http://www.alanmead.org

I've... seen things you people wouldn't believe...
functions on fire in a copy of Orion.
I watched C-Sharp glitter in the dark near a programmable gate.
All those moments will be lost in time, like Ruby... on... Rails... Time for Pi.

--"The Register" user Alister, applying the famous
"Blade Runner" speech to software development
Loading...