bugPSPP - Bugs: bug #30690, DATETIME without width and quotes...

 
 

bug #30690: DATETIME without width and quotes fails to import

Submitter:  None
Submitted:  Sun 08 Aug 2010 06:47:57 PM UTC
   
 
Category:  Syntax Parser Severity:  5 - Average
Status:  Fixed Assigned to:  None
Open/Closed:  Closed Release:  Before 0.8.0
Effort:  0.00
* Mandatory Fields

Add a New Comment Rich Markup
   

Jump to the original submission

Sun 25 Nov 2012 01:50:59 AM UTC, comment #8: 

Fixed with commit c3dd7acbbaca29 "DATA LIST: Accept freefield format types without widths use minimum width."

Ben Pfaff <blp>
Group administrator
Fri 13 Aug 2010 04:20:28 PM UTC, comment #7: 

Thanks.  I'm attaching a copy of that .png also just in case it disappears from the website sometime later.


Ben Pfaff <blp>
Group administrator
Fri 13 Aug 2010 05:59:01 AM UTC, comment #6: 
Andreas Lappe <crazynd>
Thu 12 Aug 2010 07:22:14 PM UTC, comment #5: 

Thank you for the command syntax.

Now I am curious about the format actually used.  Can you run the following command (in SPSS) and report what it says?


DISPLAY DICTIONARY /VARIABLES=STARTED.


Thanks again.

Ben Pfaff <blp>
Group administrator
Thu 12 Aug 2010 05:53:33 AM UTC, comment #4: 

DATA LIST FREE(TAB)
 /CASE (F8.0)
  REF (A255)
  SERIAL (A255)
  LASTPAGE (F8.0)
  QUESTNNR (A255)
  MODE (A16)
  STARTED (DATETIME)
  FINISHED (F1.0)
  A001 (F3.0)
  A002 (F3.0)
  A003 (F3.0)
  A004 (F3.0)
  A004_07 (A32767)
  A005 (F3.0)
  A005_09 (A32767)
  A101 (F3.0)
  A102 (F3.0)
  A103_01 (F1.0)
  A103_02 (F1.0)
  A103_03 (F1.0)
  A103_03a (A32767)
  A104_01 (F1.0)
  A104_02 (F1.0)
  A104_03 (F1.0)
  A104_04 (F1.0)
  A104_05 (F1.0)
  A104_05a (A32767)
  A105 (F3.0)
  A106 (F3.0)
  A107_01 (F1.0)
  A107_02 (F1.0)
  A108 (F3.0)
  A109_01 (F1.0)
  A109_02 (F1.0)
  A109_03 (F1.0)
  A109_03a (A32767)
  A110_01 (F1.0)
  A110_02 (F1.0)
  A110_03 (F1.0)
  A110_04 (F1.0)
  A110_04a (A32767)
  A111_01 (F1.0)
  A111_02 (F1.0)
  A111_03 (F1.0)
  A111_04 (F1.0)
  A111_04a (A32767)
  A112_01 (F1.0)
  A112_02 (F1.0)
  A112_03 (F1.0)
  A112_04 (F1.0)
  A112_05 (F1.0)
  A112_05a (A32767).
BEGIN DATA
1 \t \t \t 11 \t surveyname \t interview \t 24-07-2010 14:22:05 \t 1 \t 2 \t 3 \t 2 \t 3 \t \t 2 \t \t 1 \t 1 \t 2 \t 2 \t 1 \t \t \t \t \t \t \t \t 1 \t 1 \t 2 \t 1 \t 3 \t 2 \t 2 \t 1 \t \t \t \t \t \t \t \t \t \t \t \t 1 \t 2 \t 2 \t 1 \t 1 \t \t
END DATA.
VARIABLE WIDTH  REF SERIAL QUESTNNR MODE A004_07 A005_09 A103_03a A104_05a A109_03a A110_04a A111_04a A112_05a (8) STARTED (20)
.

VARIABLE LABELS
...
.

VALUE LABELS
...
.

MISSING VALUES
 A001 A002 A003 A004 A005 A101 A102 A105 A106 A108 (-9,-8)
 A103_01 A103_02 A103_03 A104_01 A104_02 A104_03 A104_04 A104_05 A107_01
 A107_02 A109_01 A109_02 A109_03 A110_01 A110_02 A110_03 A110_04 A111_01
 A111_02 A111_03 A111_04 A112_01 A112_02 A112_03 A112_04 A112_05 (-8)
.

-----8<------8<------8<------

I only pasted on line of data as a sample and omitted the labels if that's ok. Other than that, that's my whole file. The file has been generated/exported for me by www.soscisurvey.de – a free platform for scientific surveys.

HTH
Andy

Andreas Lappe <crazynd>
Thu 12 Aug 2010 04:55:04 AM UTC, comment #3: 


>I pasted the combined syntax+data-file from my survey into a new syntax window and selected run->all. This brought up:


OK.  What was in the syntax window when the error occurred?  If you could cut-and-paste the contents of that window, or at least the DATA LIST command, it will allow us to help you.

Ben Pfaff <blp>
Group administrator
Mon 09 Aug 2010 09:10:09 AM UTC, comment #2: 

I'm not sure if I can provide the appropriate aswers as I'm completely new to both SPSS and PSPP and I'm not used to write syntax either.

I pasted the combined syntax+data-file from my survey into a new syntax window and selected run->all. This brought up:

 The error is: Syntax1:12: syntax error: Input format DATETIME0.0                              
 specifies width 0, but DATETIME requires a width between 17 and 40.

When changed to DATETIME20 (John Darrington helped me with that) it still brought up the following:

 Syntax1:70: data file warning: (columns 33-32, DATETIME field) Syntax error in date field.
 Syntax1:71: data file warning: (columns 33-32, DATETIME field) Syntax error in date field.
 Syntax1:72: data file warning: (columns 36-35, DATETIME field) Syntax error in date field.
 Syntax1:73: data file warning: (columns 3-2, F field) Field contents are not numeric.
 Syntax1:73: data file warning: (columns 36-35, F field) Field contents are not numeric.
 Syntax1:73: data file warning: (columns 62-61, DATETIME field) Delimiter expected between fields in date.
 Syntax1:73: data file warning: (columns 71-70, F field) Field contents are not numeric.

The gui tells me there are 1770 messages in total, it displays 110 and I just selected the first seven of them above.

Even though these messages come up, it loads them but the fields are wrong (as in every line has a offset).

That's where I switched to SPSS-demo, imported the file, wrote a .sav and imported that into PSPP. Worked fine.

To your other questions: It is a DATA LIST FREE(TAB) and one line out of it looks like that (I replaced Tabs my ' \t ' to make the list a bit more readable in this webview):

1 \t  \t  \t 11 \t surveyname \t interview \t 24-07-2010 14:22:05 \t 1 \t 2 \t 3 \t 2 \t 3 \t  \t 2 \t  \t 1 \t 1 \t 2 \t 2 \t 1 \t  \t  \t  \t  \t  \t  \t  \t 1 \t 1 \t 2 \t 1 \t 3 \t 2 \t 2 \t 1 \t  \t  \t  \t  \t  \t  \t  \t  \t  \t  \t  \t 1 \t 2 \t 2 \t 1 \t 1 \t  \t

I hope that helps... if you need more informations, tell me.
All this was happening in PSPP 0.6.2 on Ubuntu (straight from repository).

For performance reasons I left the vm out now and build PSPP via Macports, which brought up some more problems but with the .sav file it works fine.

Andreas Lappe <crazynd>
Sun 08 Aug 2010 08:37:40 PM UTC, comment #1: 

Thank you for the report.  Can you give a little more detail?  What is the command on which the former fails and the latter works?  I guess that it is DATA LIST.  If so, then is DATA LIST being used in FIXED, FREE, or LIST mode?

Ben Pfaff <blp>
Group administrator
Sun 08 Aug 2010 06:47:57 PM UTC, original submission:  

Fails:

STARTED (DATETIME)

Works:

STARTED (DATETIME20)

My DATETIME entry is:

24-07-2010 14:22:05

if that's not quoted it fails.

SPSS imports all that without problems (tested with version 17).

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

Attached Files

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by crazynd (Posted a comment)
  • -email is unavailable- added by blp (Posted a comment)
  • -email is unavailable- added by blp (reporter)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 5 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2012-11-25 blp StatusNone Fixed
        Open/ClosedOpen Closed
    2011-05-14 blp ReleaseNone Before 0.8.0
    2010-08-13 blp Attached File- Added Screen shot 2010-08-13 at 07.57.15.png, #21212
    2010-08-08 blp Carbon-Copy- Added -email is unavailable-

    Back to the top

    Powered by Savane 3.13-d3ae.
    Corresponding source code