[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
PSPP-BUG: [bug #61809] Import dialog: Preview shows correct data but imp
|
From: |
Friedrich Beckmann |
|
Subject: |
PSPP-BUG: [bug #61809] Import dialog: Preview shows correct data but import results in empty data view (Text Delimeter) |
|
Date: |
Wed, 6 Apr 2022 09:12:24 -0400 (EDT) |
Update of bug #61809 (project pspp):
Status: None => Confirmed
_______________________________________________________
Follow-up Comment #2:
It might be related to localization. I can reproduce the problem with german
localization. I select ";" as field delimiter manually during the import
process. Then most variables are identified as "numeric" and everything seems
o.k. in the preview. But then during import I see these warnings:
++++
/Users/fritz/Downloads/data_bug.csv:2.1-2.4: Warnung: Die Daten für die
Variable lfdn sind im Format F ungültig: Feldinhalte sind nicht numerisch.
/Users/fritz/Downloads/data_bug.csv:2.6-2.8: Warnung: Die Daten für die
Variable external_lfdn sind im Format F ungültig: Feldinhalte sind nicht
numerisch.
/Users/fritz/Downloads/data_bug.csv:2.10-2.12: Warnung: Die Daten für die
Variable tester sind im Format F ungültig: Feldinhalte sind nicht numerisch.
...
----
The log window shows the following import command:
++++
GET DATA
/TYPE=TXT
/FILE="/Users/fritz/Downloads/data_bug.csv"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/FIRSTCASE=2
/DELIMITERS=";"
/VARIABLES=
lfdn F2.0
external_lfdn F1.0
tester F1.0
dispcode F2.0
lastpage F7.0
quality F3.0
duration F5.0
v_1 F2.0
v_2 F1.0
v_3 F1.0
v_4 F1.0
v_10 F1.0
v_11 F1.0
v_12 F1.0
v_15 F1.0
v_67 F1.0
v_16 F1.0
v_68 F1.0
v_17 F1.0
v_69 F1.0
v_25 F1.0
v_26 F1.0
v_27 F1.0
v_28 F1.0
v_29 F1.0
v_30 F1.0
v_31 F1.0
v_32 F1.0
v_33 F1.0
v_34 F1.0
v_35 F1.0
v_36 F1.0
v_37 F1.0
v_38 F1.0
v_39 F1.0
v_40 F1.0
v_41 F1.0
v_42 F1.0
v_43 F1.0
v_44 F1.0
v_45 F1.0
v_46 F1.0
v_47 F1.0
v_48 F1.0
v_49 F1.0
v_50 F1.0
v_51 F1.0
v_52 F1.0
v_53 F1.0
v_54 F1.0
v_55 F1.0
v_56 F1.0
v_57 F1.0
v_58 F1.0
v_59 F1.0
v_60 F1.0
v_61 F1.0
v_62 F1.0
v_63 F1.0
v_64 F1.0
v_65 F1.0
v_66 F1.0
browser A135
referer F3.0
device_type F1.0
quota F1.0
quota_assignment F3.0
quota_rejected_id F1.0
page_history DOT40.0
hflip F1.0
vflip F1.0
output_mode F1.0
javascript F3.0
flash F3.0
session_id A32
language F1.0
cleaned F1.0
ats F10.0
datetime YMDHMS19.0
date_of_last_access YMDHMS19.0
date_of_first_mail DATETIME20.0
rts5542751 F5.0
rts5542786 F5.0
rts5542805 F5.0
rts5542806 F5.0
rts5542847 F5.0
rts5591843 F5.0.
----
When I check the the ";" as delimiter and I check " as quoting character, then
the import works. The working import command is then
++++
GET DATA
/TYPE=TXT
/FILE="/Users/fritz/Downloads/data_bug.csv"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/FIRSTCASE=2
/DELIMITERS=";"
/QUALIFIER='"'
/VARIABLES=
lfdn F2.0
external_lfdn F1.0
tester F1.0
dispcode F2.0
lastpage F7.0
quality F3.0
duration F5.0
v_1 F2.0
v_2 F1.0
v_3 F1.0
v_4 F1.0
v_10 F1.0
v_11 F1.0
v_12 F1.0
v_15 F1.0
v_67 F1.0
v_16 F1.0
v_68 F1.0
v_17 F1.0
v_69 F1.0
v_25 F1.0
v_26 F1.0
v_27 F1.0
v_28 F1.0
v_29 F1.0
v_30 F1.0
v_31 F1.0
v_32 F1.0
v_33 F1.0
v_34 F1.0
v_35 F1.0
v_36 F1.0
v_37 F1.0
v_38 F1.0
v_39 F1.0
v_40 F1.0
v_41 F1.0
v_42 F1.0
v_43 F1.0
v_44 F1.0
v_45 F1.0
v_46 F1.0
v_47 F1.0
v_48 F1.0
v_49 F1.0
v_50 F1.0
v_51 F1.0
v_52 F1.0
v_53 F1.0
v_54 F1.0
v_55 F1.0
v_56 F1.0
v_57 F1.0
v_58 F1.0
v_59 F1.0
v_60 F1.0
v_61 F1.0
v_62 F1.0
v_63 F1.0
v_64 F1.0
v_65 F1.0
v_66 F1.0
browser A135
referer F3.0
device_type F1.0
quota F1.0
quota_assignment F3.0
quota_rejected_id F1.0
page_history DOT40.0
hflip F1.0
vflip F1.0
output_mode F1.0
javascript F3.0
flash F3.0
session_id A32
language F1.0
cleaned F1.0
ats F10.0
datetime YMDHMS19.0
date_of_last_access YMDHMS19.0
date_of_first_mail DATETIME20.0
rts5542751 F5.0
rts5542786 F5.0
rts5542805 F5.0
rts5542806 F5.0
rts5542847 F5.0
rts5591843 F5.0.
----
The difference is the "QUALIFIER" setting. But the "QUALIFIER" is not used
during preview, i.e. preview looks o.k. but the import fails.
_______________________________________________________
Reply to this item at:
<https://savannah.gnu.org/bugs/?61809>
_______________________________________________
Message sent via Savannah
https://savannah.gnu.org/