develooper Front page | perl.perl5.porters | Postings from December 2017

Re: CPAN-river-1000: failures as of perl-5.27.6

Thread Previous
From:
H.Merijn Brand
Date:
December 20, 2017 09:33
Subject:
Re: CPAN-river-1000: failures as of perl-5.27.6
Message ID:
20171220103239.6704c826@pc09.procura.nl
On Mon, 18 Dec 2017 20:51:36 -0800, John SJ Anderson
<john@genehack.org> wrote:

> At least with the version of Excel I had here, I was able to rename
> it to a .csv extension, then do File -> Import, select “delimited
> data”, and then a custom ‘|’ delimiter. 

We have a wonderful tool called perl :)

$ head -2 cpan-river-1000-failures-as-of-perl-5.27.6.psv
AnyEvent-HTTP|MLEHMANN|AnyEvent-HTTP-2.23|2.23|FAIL|MLEHMANN|AnyEvent-HTTP-2.23|2.23|FAIL|MLEHMANN|AnyEvent-HTTP-2.23|2.23|FAIL
DBIx-Class-Schema-Loader|ILMARI|DBIx-Class-Schema-Loader-0.07047|0.07047|FAIL|ILMARI|DBIx-Class-Schema-Loader-0.07047|0.07047|FAIL|ILMARI|DBIx-Class-Schema-Loader-0.07047|0.07047|FAIL
$ xlscat --in-sep='|' -c cpan-river-1000-failures-as-of-perl-5.27.6.psv >cpan-river-1000-failures-as-of-perl-5.27.6.csv
    13 x     13
$ head -2 cpan-river-1000-failures-as-of-perl-5.27.6.csv
AnyEvent-HTTP,MLEHMANN,AnyEvent-HTTP-2.23,2.23,FAIL,MLEHMANN,AnyEvent-HTTP-2.23,2.23,FAIL,MLEHMANN,AnyEvent-HTTP-2.23,2.23,FAIL
DBIx-Class-Schema-Loader,ILMARI,DBIx-Class-Schema-Loader-0.07047,0.07047,FAIL,ILMARI,DBIx-Class-Schema-Loader-0.07047,0.07047,FAIL,ILMARI,DBIx-Class-Schema-Loader-0.07047,0.07047,FAIL

xlscat comes with Spreadsheet::Read and uses Text::CSV_XS for things like this
See https://github.com/Tux/Spreadsheet-Read/tree/master/examples

You get csv2xls and csv2xlsx with Text::CSV_XS. See
https://github.com/Tux/Text-CSV_XS/tree/master/examples

> Just starting from CSV would be better. 8^)

Agree

> chrs,
> john.
> 
> 
> > On 18Dec2017, at 18:48, Karen Etheridge <perl@froods.org> wrote:
> > 
> > This is useful data - thank you! - but the file format is awful: as
> > not many spreadsheet editors understand the .psv extension, they
> > want to open it as a raw text file, which necessitates me using a
> > perl oneliner to convert the file to .csv before reading :)
> > 
> > On Mon, Dec 18, 2017 at 6:04 PM, James E Keenan <jkeenan@pobox.com>
> > wrote: Attached you will find some data measuring the impact of the
> > last three monthly Perl 5 development releases on the
> > so-called 'CPAN river'.  Specifically, you will find data on
> > those distributions among the 'top 1000' of the CPAN river
> > which received a grade of 'FAIL' when I tried to install
> > them with 'cpanm' against the most recent dev release,
> > perl-5.27.6.
> > 
> > Excluded from consideration for this list are distributions
> > graded 'NA' -- typically, distributions for which necessary
> > external dependencies are not installed or which are
> > inappropriate for the operating system (Linux) on which
> > 'cpanm' was being run.  Also excluded from consideration are
> > distributions graded 'UNKNOWN'.
> > 
> > Anyone who wishes to follow up on this data or help me
> > further develop analyses like this should contact me.
> > 
> > I will try to update this data once perl-5.27.7 is released.
> > 
> > Thank you very much.
> > Jim Keenan

-- 
H.Merijn Brand  http://tux.nl   Perl Monger  http://amsterdam.pm.org/
using perl5.00307 .. 5.27   porting perl5 on HP-UX, AIX, and openSUSE
http://mirrors.develooper.com/hpux/        http://www.test-smoke.org/
http://qa.perl.org   http://www.goldmark.org/jeff/stupid-disclaimers/

Thread Previous


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About