Re: PSPP-BUG: reading csv data set

[Harry Thijssen]

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 <address@hidden>
To: address@hidden
Subject: PSPP-BUG: reading csv data set
Message-ID: <address@hiddeng-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