Discussion:
PSPP-BUG: reading csv data set
Harry Thijssen
2018-01-03 19:43:35 UTC
Permalink
Hi Gene

You indeed found a bug in the GUI of PSPP. I can reproduce it.

The correct syntax for your import is:
GET DATA
/TYPE=TXT
/FILE="C:\Users\xxxxx\Downloads\testing.csv"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/FIRSTCASE=2
/DELIMITERS=","
/VARIABLES=
id F1.0
var1 F2.0
var2 F2.0.

The bug must be there for a longer time as it was already in the 2017-07-30
version. However it is solved in the 2017-11-16 version. This version is a
bit experimental but has some benefits too. At least the issue with quotes
when editing syntax is solved too.

Have fun


<https://lists.gnu.org/mailman/listinfo/bug-gnu-pspp> Date: Tue, 2 Jan 2018
19:30:39 -0500
Subject: PSPP-BUG: reading csv data set
Content-Type: text/plain; charset="utf-8"
Hi,
It seems highly possible there is some kind of bug with a version of pspp.
I think I have windows 10, on a 64 bit laptop, and I downloaded pspp a
couple of days ago from here
https://sourceforge.net/projects/pspp4windows/
I am pretty sure there is something wrong with the pspp version I got.
I made a simple csv file here, called "testing.csv"
https://sites.google.com/site/gsocialchange/datasets
I followed these steps on the pspp gui, and got a data set, but see the
problems below
file
import data
click on "testing.csv"
buttons on lower right are "reset", "next", "cancel"
click on next
upper left shows
"Select the lines to import"
"Select file to import"
lower right shows "reset", "next", "back", "finish" and "cancel"
click on next
upper left shows
"Select the first line"
"Select file to import"
click on next
upper left shows
"choose separators"
"Select file to import"
now lower right only shows "reset", "next", "back" and "cancel"
upper left shows
"adjust variable formats"
"Select file to import"
lower right had "finish"
click finish
variable names disappeared
there is an extra first and last line
At each step where the upper left showed that I was -supposed- to be able
to do something, there was no opportunity to do so, nothing appeared which
would allow me to select, choose, adjust, or anything.
This seems to be a really simple csv data set, and it didn't work, so I
can only conclude this version of pspp isn't working, for the windows set
up I have.
Just fyi, I had the problem first with a data set at the same location,
called pd_data_cia.csv. I -could- import the ods version of that data set.
Thanks
Gene Shackman
Albany NY
someone
2018-01-03 23:32:18 UTC
Permalink
Thanks for your response. I am kind of confused. You wrote
"it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version"


I am not exactly sure what version I am downloading. On this page
https://sourceforge.net/projects/pspp4windows/
the download button seems to show 2017-09-09 and similarly this page
https://sourceforge.net/projects/pspp4windows/files/
looks like the date says 2017-09-09


Is there a way I can get the 2017-11-16 version?


Thanks


Gene




-----Original Message-----
From: Harry Thijssen <***@gmail.com>
To: bug-gnu-pspp <bug-gnu-***@gnu.org>; pspp-users <pspp-***@gnu.org>; someone <***@aol.com>
Sent: Wed, Jan 3, 2018 2:43 pm
Subject: Re: PSPP-BUG: reading csv data set




Hi Gene


You indeed found a bug in the GUI of PSPP. I can reproduce it.



The correct syntax for your import is:

GET DATA
/TYPE=TXT
/FILE="C:\Users\xxxxx\Downloads\testing.csv"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/FIRSTCASE=2
/DELIMITERS=","
/VARIABLES=
id F1.0
var1 F2.0
var2 F2.0.



The bug must be there for a longer time as it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version. This version is a bit experimental but has some benefits too. At least the issue with quotes when editing syntax is solved too.


Have fun





Date: Tue, 2 Jan 2018 19:30:39 -0500
From: someone <***@aol.com>
To: bug-gnu-***@gnu.org
Subject: PSPP-BUG: reading csv data set
Message-ID: <160b96d59f1-c0c-***@webjasstg-vab16.srv.aolmail.net>
Content-Type: text/plain; charset="utf-8"

Hi,




It seems highly possible there is some kind of bug with a version of pspp.



I think I have windows 10, on a 64 bit laptop, and I downloaded pspp a couple of days ago from here
https://sourceforge.net/projects/pspp4windows/




I am pretty sure there is something wrong with the pspp version I got.
I made a simple csv file here, called "testing.csv"



https://sites.google.com/site/gsocialchange/datasets




I followed these steps on the pspp gui, and got a data set, but see the problems below



file
import data
click on "testing.csv"
buttons on lower right are "reset", "next", "cancel"
click on next
upper left shows
"Select the lines to import"
"Select file to import"
lower right shows "reset", "next", "back", "finish" and "cancel"
click on next
upper left shows
"Select the first line"
"Select file to import"
click on next
upper left shows
"choose separators"
"Select file to import"
now lower right only shows "reset", "next", "back" and "cancel"
upper left shows
"adjust variable formats"
"Select file to import"
lower right had "finish"
click finish


data set is read in, but:
variable names disappeared
there is an extra first and last line




At each step where the upper left showed that I was -supposed- to be able to do something, there was no opportunity to do so, nothing appeared which would allow me to select, choose, adjust, or anything.


This seems to be a really simple csv data set, and it didn't work, so I can only conclude this version of pspp isn't working, for the windows set up I have.


Just fyi, I had the problem first with a data set at the same location, called pd_data_cia.csv. I -could- import the ods version of that data set.


Thanks


Gene Shackman
Albany NY
Harry Thijssen
2018-01-04 08:38:34 UTC
Permalink
Hi

It is the version on
https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/

Although marked as "ForTestingOnly" it is a fully functional version.

Have fun
Post by someone
"it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version"
I am not exactly sure what version I am downloading. On this page
https://sourceforge.net/projects/pspp4windows/
the download button seems to show 2017-09-09 and similarly this page
https://sourceforge.net/projects/pspp4windows/files/
looks like the date says 2017-09-09
Is there a way I can get the 2017-11-16 version?
Thanks
Gene
-----Original Message-----
Sent: Wed, Jan 3, 2018 2:43 pm
Subject: Re: PSPP-BUG: reading csv data set
Hi Gene
You indeed found a bug in the GUI of PSPP. I can reproduce it.
GET DATA
/TYPE=TXT
/FILE="C:\Users\xxxxx\Downloads\testing.csv"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/FIRSTCASE=2
/DELIMITERS=","
/VARIABLES=
id F1.0
var1 F2.0
var2 F2.0.
The bug must be there for a longer time as it was already in the
2017-07-30 version. However it is solved in the 2017-11-16 version. This
version is a bit experimental but has some benefits too. At least the issue
with quotes when editing syntax is solved too.
Have fun
Date: Tue, 2 Jan 2018 19:30:39 -0500
Subject: PSPP-BUG: reading csv data set
Content-Type: text/plain; charset="utf-8"
Hi,
It seems highly possible there is some kind of bug with a version of pspp.
I think I have windows 10, on a 64 bit laptop, and I downloaded pspp a
couple of days ago from here
https://sourceforge.net/projects/pspp4windows/
I am pretty sure there is something wrong with the pspp version I got.
I made a simple csv file here, called "testing.csv"
https://sites.google.com/site/gsocialchange/datasets
I followed these steps on the pspp gui, and got a data set, but see the problems below
file
import data
click on "testing.csv"
buttons on lower right are "reset", "next", "cancel"
click on next
upper left shows
"Select the lines to import"
"Select file to import"
lower right shows "reset", "next", "back", "finish" and "cancel"
click on next
upper left shows
"Select the first line"
"Select file to import"
click on next
upper left shows
"choose separators"
"Select file to import"
now lower right only shows "reset", "next", "back" and "cancel"
upper left shows
"adjust variable formats"
"Select file to import"
lower right had "finish"
click finish
variable names disappeared
there is an extra first and last line
At each step where the upper left showed that I was -supposed- to be able
to do something, there was no opportunity to do so, nothing appeared which
would allow me to select, choose, adjust, or anything.
This seems to be a really simple csv data set, and it didn't work, so I
can only conclude this version of pspp isn't working, for the windows set
up I have.
Just fyi, I had the problem first with a data set at the same location,
called pd_data_cia.csv. I -could- import the ods version of that data set.
Thanks
Gene Shackman
Albany NY
someone
2018-01-04 12:31:28 UTC
Permalink
Thanks! I will test it out.


Gene




-----Original Message-----
From: Harry Thijssen <***@gmail.com>
To: someone <***@aol.com>
Cc: bug-gnu-pspp <bug-gnu-***@gnu.org>; pspp-users <pspp-***@gnu.org>
Sent: Thu, Jan 4, 2018 3:38 am
Subject: Re: PSPP-BUG: reading csv data set



Hi


It is the version on https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/


Although marked as "ForTestingOnly" it is a fully functional version.


Have fun






2018-01-04 0:32 GMT+01:00 someone <***@aol.com>:

Thanks for your response. I am kind of confused. You wrote
"it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version"


I am not exactly sure what version I am downloading. On this page
https://sourceforge.net/projects/pspp4windows/
the download button seems to show 2017-09-09 and similarly this page
https://sourceforge.net/projects/pspp4windows/files/
looks like the date says 2017-09-09


Is there a way I can get the 2017-11-16 version?


Thanks


Gene





-----Original Message-----
From: Harry Thijssen <***@gmail.com>
To: bug-gnu-pspp <bug-gnu-***@gnu.org>; pspp-users <pspp-***@gnu.org>; someone <***@aol.com>
Sent: Wed, Jan 3, 2018 2:43 pm
Subject: Re: PSPP-BUG: reading csv data set




Hi Gene


You indeed found a bug in the GUI of PSPP. I can reproduce it.



The correct syntax for your import is:

GET DATA
/TYPE=TXT
/FILE="C:\Users\xxxxx\Downloads\testing.csv"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/FIRSTCASE=2
/DELIMITERS=","
/VARIABLES=
id F1.0
var1 F2.0
var2 F2.0.



The bug must be there for a longer time as it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version. This version is a bit experimental but has some benefits too. At least the issue with quotes when editing syntax is solved too.


Have fun





Date: Tue, 2 Jan 2018 19:30:39 -0500
From: someone <***@aol.com>
To: bug-gnu-***@gnu.org
Subject: PSPP-BUG: reading csv data set
Message-ID: <160b96d59f1-c0c-***@webjasstg-vab16.srv.aolmail.net>
Content-Type: text/plain; charset="utf-8"

Hi,




It seems highly possible there is some kind of bug with a version of pspp.



I think I have windows 10, on a 64 bit laptop, and I downloaded pspp a couple of days ago from here
https://sourceforge.net/projects/pspp4windows/




I am pretty sure there is something wrong with the pspp version I got.
I made a simple csv file here, called "testing.csv"



https://sites.google.com/site/gsocialchange/datasets




I followed these steps on the pspp gui, and got a data set, but see the problems below



file
import data
click on "testing.csv"
buttons on lower right are "reset", "next", "cancel"
click on next
upper left shows
"Select the lines to import"
"Select file to import"
lower right shows "reset", "next", "back", "finish" and "cancel"
click on next
upper left shows
"Select the first line"
"Select file to import"
click on next
upper left shows
"choose separators"
"Select file to import"
now lower right only shows "reset", "next", "back" and "cancel"
upper left shows
"adjust variable formats"
"Select file to import"
lower right had "finish"
click finish


data set is read in, but:
variable names disappeared
there is an extra first and last line




At each step where the upper left showed that I was -supposed- to be able to do something, there was no opportunity to do so, nothing appeared which would allow me to select, choose, adjust, or anything.


This seems to be a really simple csv data set, and it didn't work, so I can only conclude this version of pspp isn't working, for the windows set up I have.


Just fyi, I had the problem first with a data set at the same location, called pd_data_cia.csv. I -could- import the ods version of that data set.


Thanks


Gene Shackman
Albany NY
someone
2018-01-05 00:39:50 UTC
Permalink
Hi,


Just wanted you to know I tested this version out. It successfully read my testing file AND my more complex file pd_data_cia.csv here
https://sites.google.com/site/gsocialchange/datasets


I will work on testing various functions next, like mean, and so on.


Thanks


Gene




-----Original Message-----
From: Harry Thijssen <***@gmail.com>
To: someone <***@aol.com>
Cc: bug-gnu-pspp <bug-gnu-***@gnu.org>; pspp-users <pspp-***@gnu.org>
Sent: Thu, Jan 4, 2018 3:38 am
Subject: Re: PSPP-BUG: reading csv data set



Hi


It is the version on https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/


Although marked as "ForTestingOnly" it is a fully functional version.


Have fun






2018-01-04 0:32 GMT+01:00 someone <***@aol.com>:

Thanks for your response. I am kind of confused. You wrote
"it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version"


I am not exactly sure what version I am downloading. On this page
https://sourceforge.net/projects/pspp4windows/
the download button seems to show 2017-09-09 and similarly this page
https://sourceforge.net/projects/pspp4windows/files/
looks like the date says 2017-09-09


Is there a way I can get the 2017-11-16 version?


Thanks


Gene





-----Original Message-----
From: Harry Thijssen <***@gmail.com>
To: bug-gnu-pspp <bug-gnu-***@gnu.org>; pspp-users <pspp-***@gnu.org>; someone <***@aol.com>
Sent: Wed, Jan 3, 2018 2:43 pm
Subject: Re: PSPP-BUG: reading csv data set




Hi Gene


You indeed found a bug in the GUI of PSPP. I can reproduce it.



The correct syntax for your import is:

GET DATA
/TYPE=TXT
/FILE="C:\Users\xxxxx\Downloads\testing.csv"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/FIRSTCASE=2
/DELIMITERS=","
/VARIABLES=
id F1.0
var1 F2.0
var2 F2.0.



The bug must be there for a longer time as it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version. This version is a bit experimental but has some benefits too. At least the issue with quotes when editing syntax is solved too.


Have fun





Date: Tue, 2 Jan 2018 19:30:39 -0500
From: someone <***@aol.com>
To: bug-gnu-***@gnu.org
Subject: PSPP-BUG: reading csv data set
Message-ID: <160b96d59f1-c0c-***@webjasstg-vab16.srv.aolmail.net>
Content-Type: text/plain; charset="utf-8"

Hi,




It seems highly possible there is some kind of bug with a version of pspp.



I think I have windows 10, on a 64 bit laptop, and I downloaded pspp a couple of days ago from here
https://sourceforge.net/projects/pspp4windows/




I am pretty sure there is something wrong with the pspp version I got.
I made a simple csv file here, called "testing.csv"



https://sites.google.com/site/gsocialchange/datasets




I followed these steps on the pspp gui, and got a data set, but see the problems below



file
import data
click on "testing.csv"
buttons on lower right are "reset", "next", "cancel"
click on next
upper left shows
"Select the lines to import"
"Select file to import"
lower right shows "reset", "next", "back", "finish" and "cancel"
click on next
upper left shows
"Select the first line"
"Select file to import"
click on next
upper left shows
"choose separators"
"Select file to import"
now lower right only shows "reset", "next", "back" and "cancel"
upper left shows
"adjust variable formats"
"Select file to import"
lower right had "finish"
click finish


data set is read in, but:
variable names disappeared
there is an extra first and last line




At each step where the upper left showed that I was -supposed- to be able to do something, there was no opportunity to do so, nothing appeared which would allow me to select, choose, adjust, or anything.


This seems to be a really simple csv data set, and it didn't work, so I can only conclude this version of pspp isn't working, for the windows set up I have.


Just fyi, I had the problem first with a data set at the same location, called pd_data_cia.csv. I -could- import the ods version of that data set.


Thanks


Gene Shackman
Albany NY
Harry Thijssen
2018-01-05 14:32:54 UTC
Permalink
Hi Gene

The differences with previous versions are mainly in the GUI. Especially in
the datasheet. I don't expect diferences in the functions. However testing
is always good.

{HT}
Post by someone
Hi,
Just wanted you to know I tested this version out. It successfully read my
testing file AND my more complex file pd_data_cia.csv here
https://sites.google.com/site/gsocialchange/datasets
I will work on testing various functions next, like mean, and so on.
Thanks
Gene
Fre Feys
2018-01-05 17:42:34 UTC
Permalink
mvg,

Frederik Feys
Kapucinessenstraat 12
2000 Antwerpen
Post by Harry Thijssen
Hi Gene
The differences with previous versions are mainly in the GUI. Especially in the datasheet. I don't expect diferences in the functions. However testing is always good.
{HT}
Hi,
Just wanted you to know I tested this version out. It successfully read my testing file AND my more complex file pd_data_cia.csv here
https://sites.google.com/site/gsocialchange/datasets <https://sites.google.com/site/gsocialchange/datasets>
I will work on testing various functions next, like mean, and so on.
Thanks
Gene
<> <>_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
someone
2018-01-06 02:57:37 UTC
Permalink
Is this a bug? I'm not sure.


As you know, I downloaded pspp from here
https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/

downloading this file
pspp-20171116-daily-64bits-ForTestingOnly-setup.exe



I'm on windows 10, 64 bit on a laptop.


I am trying to use this data file qol_justdata.ods from here
https://sites.google.com/site/gsocialchange/datasets



I DID successfully read in qol_justdata.csv, which I made by loading qol_justdata.ods, and then saving as csv. So they are exactly the same data, just one is ods, one is csb.


Here is the process


open pspp
file
import data
go to my directory
click on QOL_JUSTDATA.ODS
click on "next" in lower right
click on "use first row as variable names"
(this file has only one sheet)
click on next in lower right
in Adjust Variable Format, none of my variables show up, just table with name, type, width, etc across the top, but nothing in the cells. Data preview cells are also empty.


Am I doing something wrong, or is this a bug?


Thanks


Gene Shackman
Albany NY
Harry Thijssen
2018-01-06 18:26:51 UTC
Permalink
Hi Gene

This is a bug.

I have no workaround yet.

Have fun
Post by someone
Is this a bug? I'm not sure.
As you know, I downloaded pspp from here
https://sourceforge.net/projects/pspp4windows/files/
2017-11-16-ForTestingOnly/
downloading this file
pspp-20171116-daily-64bits-ForTestingOnly-setup.exe
I'm on windows 10, 64 bit on a laptop.
I am trying to use this data file qol_justdata.ods from here
https://sites.google.com/site/gsocialchange/datasets
I DID successfully read in qol_justdata.csv, which I made by loading qol_justdata.ods,
and then saving as csv. So they are exactly the same data, just one is ods,
one is csb.
Here is the process
open pspp
file
import data
go to my directory
click on QOL_JUSTDATA.ODS
click on "next" in lower right
click on "use first row as variable names"
(this file has only one sheet)
click on next in lower right
in Adjust Variable Format, none of my variables show up, just table with
name, type, width, etc across the top, but nothing in the cells. Data
preview cells are also empty.
Am I doing something wrong, or is this a bug?
Thanks
Gene Shackman
Albany NY
someone
2018-01-06 14:30:33 UTC
Permalink
Is this a bug? Or am I doing this wrong.


As you know, I downloaded pspp from here
https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/

downloading this file
pspp-20171116-daily-64bits-ForTestingOnly-setup.exe



I'm on windows 10, 64 bit on a laptop.


I read in this data file qol_justdata.csv from here
https://sites.google.com/site/gsocialchange/datasets



I saved this as a .sav file


Here is the process


open pspp
file
open
go to my directory



no files show up. The .sav file is not listed.




In windows explorer, I went to that directory, double clicked on qol_justdata.sav and it opened in pspp.




Am I doing something wrong, or is this a bug?


Thanks


Gene Shackman
Albany NY
Friedrich Beckmann
2018-01-06 14:54:50 UTC
Permalink
Hi Gene,

thanks for your report. Could you check if the file appears when you change
the file filter to „all files“ in the file open dialog in pspp?

That would be the following bug:

https://savannah.gnu.org/bugs/?52323

Regards

Friedrich
Post by someone
Is this a bug? Or am I doing this wrong.
As you know, I downloaded pspp from here
https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/ <https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/>
downloading this file
pspp-20171116-daily-64bits-ForTestingOnly-setup.exe
I'm on windows 10, 64 bit on a laptop.
I read in this data file qol_justdata.csv from here
https://sites.google.com/site/gsocialchange/datasets <https://sites.google.com/site/gsocialchange/datasets>
I saved this as a .sav file
Here is the process
open pspp
file
open
go to my directory
no files show up. The .sav file is not listed.
In windows explorer, I went to that directory, double clicked on qol_justdata.sav and it opened in pspp.
Am I doing something wrong, or is this a bug?
Thanks
Gene Shackman
someone
2018-01-06 18:13:03 UTC
Permalink
Yes after changing to all files it does appear, and I could load it. That worked. Thanks. The default was syntax and data file, I guess I assumed it was a data file. I read the bug you pointed to. Sorry to say I didn't understand some of the language. Should I do something to pspp?

Thanks


Gene



-----Original Message-----
From: Friedrich Beckmann <***@gmx.de>
To: someone <***@aol.com>
Cc: pspp4windows <***@gmail.com>; pspp-users <pspp-***@gnu.org>; bug-gnu-pspp <bug-gnu-***@gnu.org>
Sent: Sat, Jan 6, 2018 9:54 am
Subject: Re: reading sav data set


Hi Gene,


thanks for your report. Could you check if the file appears when you change
the file filter to „all files“ in the file open dialog in pspp?


That would be the following bug:


https://savannah.gnu.org/bugs/?52323


Regards


Friedrich



Am 06.01.2018 um 15:30 schrieb someone <***@aol.com>:






Is this a bug? Or am I doing this wrong.


As you know, I downloaded pspp from here
https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/

downloading this file
pspp-20171116-daily-64bits-ForTestingOnly-setup.exe



I'm on windows 10, 64 bit on a laptop.


I read in this data file qol_justdata.csv from here
https://sites.google.com/site/gsocialchange/datasets



I saved this as a .sav file


Here is the process


open pspp
file
open
go to my directory



no files show up. The .sav file is not listed.




In windows explorer, I went to that directory, double clicked on qol_justdata.sav and it opened in pspp.




Am I doing something wrong, or is this a bug?


Thanks


Gene Shackman
someone
2018-01-08 22:09:10 UTC
Permalink
Folks may be interested to know, I'm testing this latest version



https://sourceforge.net/projects/pspp4windows/files/2017-11-16-ForTestingOnly/

this file
pspp-20171116-daily-64bits-ForTestingOnly-setup.exe




Using this data set qol_justdata.csv, here
https://sites.google.com/site/gsocialchange/datasets







So far just basic stuff like frequencies, means and correlations. But so far, the results from PSPP match exactly the results from Libre Office. That's good! Here are the comparisons (not including freqs), qol_comparing.ods, here

https://sites.google.com/site/gsocialchange/datasets








Gene Shackman
Albany NY

Loading...