Re: Spread***::Read 0.20

Thanks to David Cantrell, who ran into the same problems on OpenBSD, and kindly
offered my access to the failing box, I think I have nailed it down.

0.23 has entered CPAN as

file: $CPAN/authors/id/H/HM/HMBRAND/Spread***-Read-0.23.tar.gz
size: 64710 bytes
md5: 8d9c6b8f7ca38ef6966724ccc3090b45

No action is required on your part
Request entered by: HMBRAND (H.Merijn Brand)
Request entered on: Thu, 21 Jun 2007 10:51:24 GMT
Request completed: Thu, 21 Jun 2007 10:52:58 GMT

0.23 Thu 21 Jun 2007

- Use IO::Scalar instead of File::Temp when installed
Thanks to David Cantrell for making a OpenBSD test box available!
- use binmode () when opening files
- Also use 3-arg open in test files
- die if test files cannot be opene'ed

0.22 Mon 18 Jun 2007

- 0.21 should already support Text::CSV_PP 1.05
Tested Text::CSV_PP 1.05 on bleadperl.
- Better detection of (not) installed modules
- Module requires perl 5.6.x

0.21 Mon 18 Jun 2007

- Text::CSV_XS uses keep_meta_info instead of get_flags
- Removed always_quote from xlscat's CSV output

0.20 Thu 31 May 2007

- perlcritic OK
- CSV parsing now uses getline (), and auto-detects eol
Assumes first line does not contain embedded eol. This implies that
parsing CSV with embedded eol sequences is now safe.
- As I now also maintain Text::CSV_XS, I changed the references
- Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997)

On Wed, 20 Jun 2007 18:00:57 +0200, <liuhang@xxxxxxxxx> wrote:

On May 31, 8:38 am, "H.Merijn Brand" <h.m.br...@xxxxxxxxx> wrote:
0.20 Fri 30 May 2007

- perlcritic OK
- CSV parsing now uses getline (), and auto-detects eol
Assumes first line does not contain embedded eol. This implies that
parsing CSV with embedded eol sequences is now safe.
- As I now also maintain Text::CSV_XS, I changed the references
- Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997)

Hi, Merijn,

I was trying to install Spread***::Read 0.22 but met some failed
testing. The following is the report from the whole installation
procedure, what should I do?

I'm on Solaris 9/Sparc, I believe I've installed all the
prerequisites.

TIA.
Alan

#########################################
# perl Makefile.PL
Do you want to install 'xlscat' (Convert Spread*** to plain text or
CSV) ? [n] y
Do you want to install 'ss2tk' (Show a Spread*** in Perl/Tk) ? [n]
y
Writing Makefile for Spread***::Read
# make
cp Read.pm blib/lib/Spread***/Read.pm
cp examples/ss2tk blib/script/ss2tk
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/
ss2tk
cp examples/xlscat blib/script/xlscat
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/
xlscat
Manifying blib/man3/Spread***::Read.3
# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00_pod.......skipped
all skipped: Test::Pod 1.00 required for testing POD
t/01_pod.......skipped
all skipped: Test::Pod::Covarage required for testing POD
Coverage
t/
10_basics....ok
t/
11_call......ok
t/
20_csv.......ok
t/
21_csv.......ok
t/30_xls.......NOK
53
# Failed test '*** count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
t/30_xls.......NOK
55
# Failed test '*** list count'
# in t/30_xls.t at line 41.
# got: '0'
# expected: '2'
t/30_xls.......NOK
58
# Failed test 'Unformatted cell A1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A1'
t/30_xls.......NOK
59
# Failed test 'Formatted cell A1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A1'
t/30_xls.......NOK
60
# Failed test 'Unformatted cell A2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A2'
t/30_xls.......NOK
61
# Failed test 'Formatted cell A2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A2'
t/30_xls.......NOK
62
# Failed test 'Unformatted cell A3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A3'
t/30_xls.......NOK
63
# Failed test 'Formatted cell A3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A3'
t/30_xls.......NOK
64
# Failed test 'Unformatted cell A4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A4'
t/30_xls.......NOK
65
# Failed test 'Formatted cell A4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A4'
t/30_xls.......NOK
66
# Failed test 'Unformatted cell B1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B1'
t/30_xls.......NOK
67
# Failed test 'Formatted cell B1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B1'
t/30_xls.......NOK
68
# Failed test 'Unformatted cell B2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B2'
t/30_xls.......NOK
69
# Failed test 'Formatted cell B2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B2'
t/30_xls.......NOK
70
# Failed test 'Unformatted cell B4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B4'
t/30_xls.......NOK
71
# Failed test 'Formatted cell B4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B4'
t/30_xls.......NOK
72
# Failed test 'Unformatted cell C3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C3'
t/30_xls.......NOK
73
# Failed test 'Formatted cell C3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C3'
t/30_xls.......NOK
74
# Failed test 'Unformatted cell C4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C4'
t/30_xls.......NOK
75
# Failed test 'Formatted cell C4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C4'
t/30_xls.......NOK
76
# Failed test 'Unformatted cell D1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D1'
t/30_xls.......NOK
77
# Failed test 'Formatted cell D1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D1'
t/30_xls.......NOK
78
# Failed test 'Unformatted cell D3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D3'
t/30_xls.......NOK
79
# Failed test 'Formatted cell D3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D3'

# Failed test 'Row'ed rows'
# in t/30_xls.t at line 59.
# got: '0'
# expected: '4'
Can't use an undefined value as an ARRAY reference at t/30_xls.t line
60.
# Looks like you planned 217 tests but only ran 91.
# Looks like you failed 25 tests of 91 run.
# Looks like your test died just after 91.
t/
30_xls.......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 53, 55, 58-79, 91-217
Failed 151/217 tests, 30.41% okay
t/
31_clr.......ok
t/
32_fmt.......ok
t/
33_misc......ok
t/
40_sxc.......ok
t/
45_ods.......ok
t/46_clr.......skipped
all skipped: Spread***::ReadSXC version 0.20 doesn't support
field attributes
t/
50_sc........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/30_xls.t 255 65280 217 277 127.65% 53 55 58-79 91-217
3 tests skipped.
Failed 1/14 test scripts, 92.86% okay. 151/1471 subtests failed,
89.73% okay.
make: *** [test_dynamic] Error 29
# perl -Mblib t/30_xls.t
1..217
ok 1 - Nonexistent file
ok 2 - Empty file
ok 3 - Read/Parse xls file
ok 4 - Base values
ok 5 - Return type
ok 6 - Spread*** type
ok 7 - *** count
ok 8 - *** list
ok 9 - *** list count
ok 10 - Parser version
ok 11 - Defined fields
ok 12 - Unformatted cell A1
ok 13 - Formatted cell A1
ok 14 - Unformatted cell A2
ok 15 - Formatted cell A2
ok 16 - Unformatted cell A3
ok 17 - Formatted cell A3
ok 18 - Unformatted cell A4
ok 19 - Formatted cell A4
ok 20 - Unformatted cell B1
ok 21 - Formatted cell B1
ok 22 - Unformatted cell B2
ok 23 - Formatted cell B2
ok 24 - Unformatted cell B4
ok 25 - Formatted cell B4
ok 26 - Unformatted cell C3
ok 27 - Formatted cell C3
ok 28 - Unformatted cell C4
ok 29 - Formatted cell C4
ok 30 - Unformatted cell D1
ok 31 - Formatted cell D1
ok 32 - Unformatted cell D3
ok 33 - Formatted cell D3
ok 34 - Undefined fields
ok 35 - Unformatted cell B3
ok 36 - Formatted cell B3
ok 37 - Unformatted cell C1
ok 38 - Formatted cell C1
ok 39 - Unformatted cell C2
ok 40 - Formatted cell C2
ok 41 - Unformatted cell D2
ok 42 - Formatted cell D2
ok 43 - Unformatted cell D4
ok 44 - Formatted cell D4
ok 45 - Row'ed rows
ok 46 - Row'ed columns
ok 47 - Row'ed value D1
ok 48 - Row'ed value C4
ok 49 - Parse xls data
ok 50 - Base values
ok 51 - Return type
ok 52 - Spread*** type
not ok 53 - *** count
# Failed test '*** count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
ok 54 - *** list
not ok 55 - *** list count
# Failed test '*** list count'
# in t/30_xls.t at line 41.
# got: '0'
# expected: '2'
ok 56 - Parser version
ok 57 - Defined fields
not ok 58 - Unformatted cell A1
# Failed test 'Unformatted cell A1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A1'
not ok 59 - Formatted cell A1
# Failed test 'Formatted cell A1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A1'
not ok 60 - Unformatted cell A2
# Failed test 'Unformatted cell A2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A2'
not ok 61 - Formatted cell A2
# Failed test 'Formatted cell A2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A2'
not ok 62 - Unformatted cell A3
# Failed test 'Unformatted cell A3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A3'
not ok 63 - Formatted cell A3
# Failed test 'Formatted cell A3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A3'
not ok 64 - Unformatted cell A4
# Failed test 'Unformatted cell A4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A4'
not ok 65 - Formatted cell A4
# Failed test 'Formatted cell A4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A4'
not ok 66 - Unformatted cell B1
# Failed test 'Unformatted cell B1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B1'
not ok 67 - Formatted cell B1
# Failed test 'Formatted cell B1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B1'
not ok 68 - Unformatted cell B2
# Failed test 'Unformatted cell B2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B2'
not ok 69 - Formatted cell B2
# Failed test 'Formatted cell B2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B2'
not ok 70 - Unformatted cell B4
# Failed test 'Unformatted cell B4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B4'
not ok 71 - Formatted cell B4
# Failed test 'Formatted cell B4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B4'
not ok 72 - Unformatted cell C3
# Failed test 'Unformatted cell C3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C3'
not ok 73 - Formatted cell C3
# Failed test 'Formatted cell C3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C3'
not ok 74 - Unformatted cell C4
# Failed test 'Unformatted cell C4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C4'
not ok 75 - Formatted cell C4
# Failed test 'Formatted cell C4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C4'
not ok 76 - Unformatted cell D1
# Failed test 'Unformatted cell D1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D1'
not ok 77 - Formatted cell D1
# Failed test 'Formatted cell D1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D1'
not ok 78 - Unformatted cell D3
# Failed test 'Unformatted cell D3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D3'
not ok 79 - Formatted cell D3
# Failed test 'Formatted cell D3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D3'
ok 80 - Undefined fields
ok 81 - Unformatted cell B3
ok 82 - Formatted cell B3
ok 83 - Unformatted cell C1
ok 84 - Formatted cell C1
ok 85 - Unformatted cell C2
ok 86 - Formatted cell C2
ok 87 - Unformatted cell D2
ok 88 - Formatted cell D2
ok 89 - Unformatted cell D4
ok 90 - Formatted cell D4
not ok 91 - Row'ed rows
# Failed test 'Row'ed rows'
# in t/30_xls.t at line 59.
# got: '0'
# expected: '4'
Can't use an undefined value as an ARRAY reference at t/30_xls.t line
60.
# Looks like you planned 217 tests but only ran 91.
# Looks like you failed 25 tests of 91 run.
# Looks like your test died just after 91.


.

Quantcast