[29362] in Perl-Users-Digest
Perl-Users Digest, Issue: 606 Volume: 11
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Sun Jul 1 03:10:08 2007
Date: Sun, 1 Jul 2007 00:09:03 -0700 (PDT)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)
Perl-Users Digest Sun, 1 Jul 2007 Volume: 11 Number: 606
Today's topics:
Re: best Excel module <notvalid@cox.net.invalid>
Re: date parts in one step <stoupa@practisoft.cz>
Re: FAQ 3.10 Is there an IDE or Windows Perl Editor? <invalid@invalid.nyet>
Re: install of perl 5.8.8 <paduille.4061.mumia.w+nospam@earthlink.net>
new CPAN modules on Sun Jul 1 2007 (Randal Schwartz)
Re: The $a have any special meanning ? <stoupa@practisoft.cz>
Re: The $a have any special meanning ? <kkeller-usenet@wombat.san-francisco.ca.us>
Re: The $a have any special meanning ? <tadmc@seesig.invalid>
unlurking <invalid@invalid.nyet>
Re: unlurking <mritty@gmail.com>
Re: unlurking <invalid@invalid.nyet>
Re: unlurking <sbryce@scottbryce.com>
Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: Sat, 30 Jun 2007 21:17:05 -0400
From: John Mason Jr <notvalid@cox.net.invalid>
Subject: Re: best Excel module
Message-Id: <138e04h8lp32gee@news.supernews.com>
cartercc@gmail.com wrote:
> A couple of years ago, I converted our database output from wide
> formfeed paper printed on obselete line printers and delivered
> manually to printing them as PDF files delievered electronically. I am
> now converting our database output into CSV or XML files that can be
> opened with Excel, which is the user desiderata. Some of these files
> have hundreds of records, and PDF files can't be sorted or filtered,
> although they are a lot better than the old line printed variety.
>
> However, I am getting user complaints that the Excel files are ugly,
> without all the nice formatting that Excel supports. I have just
> looked at CPAN and discovered 149 modules for use with Excel, and see
> several that might do what I need, such as Spreadsheet::WriteExcel,
> Querylet::Output::Excel::OLE, Querylet::Output::Excel::XLS,
> Spreadsheet::SimpleExcel, etc.
>
> Are there maybe two or three that I can test that focus on cosmetics?
> I need something that can create colored backgrounds with bolded text,
> etc.
>
> Thanks, CC.
>
Win32::OLE will allow you to control Excel directly, and often you can
determine much of the syntax for you task, such as formatting, by
looking at the code from a macro.
John
------------------------------
Date: Sun, 1 Jul 2007 03:58:12 +0200
From: "Petr Vileta" <stoupa@practisoft.cz>
Subject: Re: date parts in one step
Message-Id: <f6738p$ams$2@ns.felk.cvut.cz>
Brad Baxter wrote:
> Just for the record, there actually are a few things wrong with the
> code you posted.
>
> my ($start, $stop); # fixed
> $start = localtime;
>
should be
$start = time;
You are right, in real world never read localtime in thousands cycle, but
this code is in Perl script on server (CGI) where hundreds or thousanths of
visitors can run it simultaneously. When I'm writing code for web server I
must think about memory and / or CPU consumption. For example if I need to
make something with content of 10 kB file then I can read entire file into
memory array and do something with all elements. Or I can read file line by
line into the same variable and do something immediately. 10 kB is not a big
file, but if this file is readed by 1000 visitors in the same time then
there may be a problem ;-)
--
Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)
------------------------------
Date: Sat, 30 Jun 2007 22:09:25 -0400
From: "Wade Ward" <invalid@invalid.nyet>
Subject: Re: FAQ 3.10 Is there an IDE or Windows Perl Editor?
Message-Id: <2ZednQnkReeMkBrbnZ2dnUVZ_ruknZ2d@comcast.com>
"PerlFAQ Server" <brian@stonehenge.com> wrote in message
news:63bjl4-40o.ln1@blue.stonehenge.com...
> This is an excerpt from the latest version perlfaq3.pod, which
> comes with the standard Perl distribution. These postings aim to
> reduce the number of repeated questions as well as allow the community
> to review and update the answers. The latest version of the complete
> perlfaq is at http://faq.perl.org .
>
> --------------------------------------------------------------------
>
> 3.10: Is there an IDE or Windows Perl Editor?
>
> Perl programs are just plain text, so any editor will do.
>
> If you're on Unix, you already have an IDE--Unix itself. The UNIX
> philosophy is the philosophy of several small tools that each do one
> thing and do it well. It's like a carpenter's toolbox.
>
> If you want an IDE, check the following (in alphabetical order, not
> order of preference):
>
> Eclipse
> http://e-p-i-c.sf.net/
>
> The Eclipse Perl Integration Project integrates Perl
> editing/debugging with Eclipse.
>
> Enginsite
> http://www.enginsite.com/
>
> Perl Editor by EngInSite is a complete integrated development
> environment (IDE) for creating, testing, and debugging Perl
> scripts;
> the tool runs on Windows 9x/NT/2000/XP or later.
>
> Komodo
> http://www.ActiveState.com/Products/Komodo/
>
> ActiveState's cross-platform (as of October 2004, that's Windows,
> Linux, and Solaris), multi-language IDE has Perl support, including
> a regular expression debugger and remote debugging.
This was time down the hole for me. Since it is a commercially-viable
product, I don't think my case generalizes. They do offer a demo version,
that doesn't bellow like Nurse Ratchett or prattle like Jesse Jackson. I
couldn't make it produce for me in the month that you have to evaluate. I
do have a komodo startegy though: if I see one, hightail it the heck away.
--
WW
------------------------------
Date: Sun, 01 Jul 2007 02:58:25 GMT
From: "Mumia W." <paduille.4061.mumia.w+nospam@earthlink.net>
Subject: Re: install of perl 5.8.8
Message-Id: <lLEhi.2525$zA4.590@newsread3.news.pas.earthlink.net>
On 06/30/2007 04:25 PM, rogv24@yahoo.com wrote:
>
> I have never installed Perl. I downloaded 5.8.8 into solaris 10
> server.
> Is there an eaaasy instruction for installation. There is
> already v.5.8.4 installed.
>
> thanks
>
The instructions are not necessarily eaaasy, but they are in the source.
You probably want to read README, README.solaris, INSTALL and the output
from "./Configure --help"
------------------------------
Date: Sun, 1 Jul 2007 04:42:14 GMT
From: merlyn@stonehenge.com (Randal Schwartz)
Subject: new CPAN modules on Sun Jul 1 2007
Message-Id: <JKHH2E.52G@zorch.sf-bay.org>
The following modules have recently been added to or updated in the
Comprehensive Perl Archive Network (CPAN). You can install them using the
instructions in the 'perlmodinstall' page included with your Perl
distribution.
Apache2-ASP-1.14
http://search.cpan.org/~johnd/Apache2-ASP-1.14/
Perl extension for ASP on mod_perl2.
----
Audio-SndFile-0.05
http://search.cpan.org/~jdiepen/Audio-SndFile-0.05/
Portable reading and writing of sound files
----
Bundle-AI-0.02
http://search.cpan.org/~ski/Bundle-AI-0.02/
Perl extension to install AI modules and dependencies
----
Bundle-XML-Devel-0.01
http://search.cpan.org/~ski/Bundle-XML-Devel-0.01/
installs all XML modules and depenedencies
----
CPAN-Test-Dummy-Perl5-Make-ConfReq-1.00
http://search.cpan.org/~andk/CPAN-Test-Dummy-Perl5-Make-ConfReq-1.00/
CPAN Test Dummy
----
Catalyst-Plugin-Log-Colorful-0.02
http://search.cpan.org/~tomyhero/Catalyst-Plugin-Log-Colorful-0.02/
Catalyst Plugin for Colorful Log
----
Compress-Raw-Bzip2-2.005
http://search.cpan.org/~pmqs/Compress-Raw-Bzip2-2.005/
Low-Level Interface to bzip2 compression library
----
Compress-Raw-Zlib-2.005
http://search.cpan.org/~pmqs/Compress-Raw-Zlib-2.005/
Low-Level Interface to zlib compression library
----
Compress-Zlib-2.005
http://search.cpan.org/~pmqs/Compress-Zlib-2.005/
Interface to zlib compression library
----
D-oh-Year-0.05
http://search.cpan.org/~mschwern/D-oh-Year-0.05/
----
ExtUtils-MakeMaker-6.34
http://search.cpan.org/~mschwern/ExtUtils-MakeMaker-6.34/
Create a module Makefile
----
Finance-Currency-Convert-WebserviceX-0.06000
http://search.cpan.org/~claco/Finance-Currency-Convert-WebserviceX-0.06000/
Lightweight currency conversion using WebserviceX.NET
----
Games-Jumble-0.08
http://search.cpan.org/~dsparling/Games-Jumble-0.08/
Create and solve Jumble word puzzles.
----
Games-Jumble-0.09
http://search.cpan.org/~dsparling/Games-Jumble-0.09/
Create and solve Jumble word puzzles.
----
Gtk2-Ex-DBI-2.1
http://search.cpan.org/~dkasak/Gtk2-Ex-DBI-2.1/
Bind a Gtk2::GladeXML - generated window to a DBI data source
----
Gtk2-Ex-Datasheet-DBI-2.1
http://search.cpan.org/~dkasak/Gtk2-Ex-Datasheet-DBI-2.1/
----
Handel-1.00002
http://search.cpan.org/~claco/Handel-1.00002/
A cart/order/checkout framework with AxKit/TT/Catalyst support
----
IO-Compress-Base-2.005
http://search.cpan.org/~pmqs/IO-Compress-Base-2.005/
Base Class for IO::Compress modules
----
IO-Compress-Bzip2-2.005
http://search.cpan.org/~pmqs/IO-Compress-Bzip2-2.005/
Write bzip2 files/buffers
----
IO-Compress-Lzf-2.005
http://search.cpan.org/~pmqs/IO-Compress-Lzf-2.005/
Write lzf files/buffers
----
IO-Compress-Lzop-2.005
http://search.cpan.org/~pmqs/IO-Compress-Lzop-2.005/
Write lzop files/buffers
----
IO-Compress-Zlib-2.005
http://search.cpan.org/~pmqs/IO-Compress-Zlib-2.005/
----
Lingua-Flags-0.02
http://search.cpan.org/~ambs/Lingua-Flags-0.02/
Provide small flag icons
----
Lingua-PT-PLNbase-0.18
http://search.cpan.org/~ambs/Lingua-PT-PLNbase-0.18/
Perl extension for NLP of the Portuguese
----
Mail-Verp-0.06
http://search.cpan.org/~gyepi/Mail-Verp-0.06/
encodes and decodes Variable Envelope Return Paths (VERP) addresses.
----
Math-BigInt-1.87
http://search.cpan.org/~tels/Math-BigInt-1.87/
Arbitrary size integer/float math package
----
Math-BigInt-FastCalc-0.15
http://search.cpan.org/~tels/Math-BigInt-FastCalc-0.15/
Math::BigInt::Calc with some XS for more speed
----
Math-BigRat-0.20
http://search.cpan.org/~tels/Math-BigRat-0.20/
Arbitrary big rational numbers
----
Module-CPANTS-Analyse-0.72
http://search.cpan.org/~domm/Module-CPANTS-Analyse-0.72/
Generate Kwalitee ratings for a distribution
----
Net-FireEagle-1.01
http://search.cpan.org/~ascope/Net-FireEagle-1.01/
Object methods for working with the FireEagle location service.
----
Net-MRIM-0.6
http://search.cpan.org/~aau/Net-MRIM-0.6/
Perl implementation of mail.ru agent protocol
----
OpenGL-Image-0.00_2
http://search.cpan.org/~bfree/OpenGL-Image-0.00_2/
copyright 2007 Graphcomp - ALL RIGHTS RESERVED Author: Bob "grafman" Free - grafman@graphcomp.com
----
OpenOffice-OODoc-2.035
http://search.cpan.org/~jmgdoc/OpenOffice-OODoc-2.035/
The Perl Open OpenDocument Connector
----
PAR-Dist-FromCPAN-0.08
http://search.cpan.org/~smueller/PAR-Dist-FromCPAN-0.08/
Create PAR distributions from CPAN
----
PDF-ReportWriter-1.4
http://search.cpan.org/~dkasak/PDF-ReportWriter-1.4/
----
POE-Component-Daemon-0.1004
http://search.cpan.org/~gwyn/POE-Component-Daemon-0.1004/
Handles all the housework for a daemon.
----
POE-Component-Daemon-0.1005
http://search.cpan.org/~gwyn/POE-Component-Daemon-0.1005/
Handles all the housework for a daemon.
----
Path-Lite-0.03
http://search.cpan.org/~rkrimen/Path-Lite-0.03/
A lightweight but featureful class for UNIX-style path manipulation.
----
Path-Resource-0.03
http://search.cpan.org/~rkrimen/Path-Resource-0.03/
URI/Path::Class combination.
----
Test-WWW-Mechanize-Catalyst-0.38
http://search.cpan.org/~lbrocard/Test-WWW-Mechanize-Catalyst-0.38/
Test::WWW::Mechanize for Catalyst
----
Text-Metaphone-2.00
http://search.cpan.org/~mschwern/Text-Metaphone-2.00/
A modern soundex. Phonetic encoding of words.
----
WWW-Search-Ask-1.004
http://search.cpan.org/~mthurn/WWW-Search-Ask-1.004/
class for searching www.search.com
----
WebService-TagTheNet-0.01
http://search.cpan.org/~blom/WebService-TagTheNet-0.01/
Retrieve tags using the tagthe.net REST API
----
Weed-0.0071
http://search.cpan.org/~hooo/Weed-0.0071/
Don't use it. It's in development. For test purposes only!
----
bignum-0.22
http://search.cpan.org/~tels/bignum-0.22/
Transparent BigNumber support for Perl
If you're an author of one of these modules, please submit a detailed
announcement to comp.lang.perl.announce, and we'll pass it along.
This message was generated by a Perl program described in my Linux
Magazine column, which can be found on-line (along with more than
200 other freely available past column articles) at
http://www.stonehenge.com/merlyn/LinuxMag/col82.html
print "Just another Perl hacker," # the original
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
------------------------------
Date: Sun, 1 Jul 2007 03:42:22 +0200
From: "Petr Vileta" <stoupa@practisoft.cz>
Subject: Re: The $a have any special meanning ?
Message-Id: <f6738o$ams$1@ns.felk.cvut.cz>
Thomas Wasell wrote:
> Yes, $a and $b are special. See
>
> perldoc -f sort
>
> and
>
> perldoc perlvar
>
> for more information.
Are you sure? I found examples in perldoc -f sort but these are examples.
Nowhere is mentioned about $a as special variable. In perlvar are mentioned
variables where second (third) character is not alphabetic, for example $`,
$/ etc. and only few alphabetic variables as @ARGV, @INC etc.
--
Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)
------------------------------
Date: Sat, 30 Jun 2007 20:21:31 -0700
From: Keith Keller <kkeller-usenet@wombat.san-francisco.ca.us>
Subject: Re: The $a have any special meanning ?
Message-Id: <s6jjl4xrka.ln2@goaway.wombat.san-francisco.ca.us>
On 2007-07-01, Petr Vileta <stoupa@practisoft.cz> wrote:
> Thomas Wasell wrote:
>> Yes, $a and $b are special. See
>>
>> perldoc -f sort
>>
>> and
>>
>> perldoc perlvar
>>
>> for more information.
> Are you sure? I found examples in perldoc -f sort but these are examples.
> Nowhere is mentioned about $a as special variable. In perlvar are mentioned
> variables where second (third) character is not alphabetic, for example $`,
> $/ etc. and only few alphabetic variables as @ARGV, @INC etc.
My perldoc -f sort calls them package global variables, and my
perldoc perlvar clearly documents $a and $b as special package
variables.
--keith
--
kkeller-usenet@wombat.san-francisco.ca.us
(try just my userid to email me)
AOLSFAQ=http://www.therockgarden.ca/aolsfaq.txt
see X- headers for PGP signature information
------------------------------
Date: Sat, 30 Jun 2007 23:24:24 -0500
From: Tad McClellan <tadmc@seesig.invalid>
Subject: Re: The $a have any special meanning ?
Message-Id: <slrnf8eb3o.j7l.tadmc@tadmc30.sbcglobal.net>
Petr Vileta <stoupa@practisoft.cz> wrote:
> Thomas Wasell wrote:
>> Yes, $a and $b are special. See
>>
>> perldoc -f sort
>>
>> and
>>
>> perldoc perlvar
>>
>> for more information.
> Are you sure? I found examples in perldoc -f sort but these are examples.
> Nowhere is mentioned about $a as special variable. In perlvar are mentioned
> variables where second (third) character is not alphabetic, for example $`,
> $/ etc. and only few alphabetic variables as @ARGV, @INC etc.
From perlvar.pod:
=item $a
=item $b
Special package variables when using sort(), see L<perlfunc/sort>.
Because of this specialness $a and $b don't need to be declared
(using use vars, or our()) even when using the C<strict 'vars'> pragma.
Don't lexicalize them with C<my $a> or C<my $b> if you want to be
able to use them in the sort() comparison block or function.
--
Tad McClellan
email: perl -le "print scalar reverse qq/moc.noitatibaher\100cmdat/"
------------------------------
Date: Sat, 30 Jun 2007 19:32:31 -0400
From: "Wade Ward" <invalid@invalid.nyet>
Subject: unlurking
Message-Id: <48mdnXMMAp_UdRvbnZ2dnUVZ_qCmnZ2d@comcast.com>
With past credit for lurking, I believe to have exceeded the suggested 2 wk
minimum before posting.
Can someone give me a script or a reference (it's likely that either Barnes
and Noble or the library has popular titles) on how to use perl to herd
messages in a usenet thread into a file? I asked this question a couple
months back, but it turned out that all as far as I got was to get "Hello
World" in perl on my windows machine. It was a bumpy ride, so I don't think
of it as a failure.
Thanks in advance.
--
Wade Ward
------------------------------
Date: Sun, 01 Jul 2007 02:23:39 -0000
From: Paul Lalli <mritty@gmail.com>
Subject: Re: unlurking
Message-Id: <1183256619.607912.101960@n60g2000hse.googlegroups.com>
On Jun 30, 7:32 pm, "Wade Ward" <inva...@invalid.nyet> wrote:
> Subject: unlurking
Please put the subject of your post in the Subject of your post. Your
post is not about you unlurking. It's about using Perl to read
Usenet.
> Can someone give me a script or a reference (it's likely that either
> Barnes and Noble or the library has popular titles) on how to use perl
> to herd messages in a usenet thread into a file?
Here's a short but complete script that contacts my local news host
and retrieves the past day's new posts from comp.lang.perl.misc.
Perhaps you can use it as a starting point. It uses the Net::NNTP
module from CPAN.
#!/usr/bin/env perl
use strict;
use warnings;
use Net::NNTP;
my $nntp = Net::NNTP->new('news.example.com', { Debug => 1} );
$nntp->group('comp.lang.perl.misc')
or die "failed to set group c.l.p.m.\n";
my $msg_ids_ref = $nntp->newnews(time() - 24*60*60);
die "Failed to retrieve message ids\n" unless @{$msg_ids_ref};
open my $ofh, '>', 'articles.txt'
or die "Cannot open articles.txt: $!";
for my $msg_id (@{$msg_ids_ref}) {
$nntp->article($msg_id, $ofh)
or die "Failed to retrieve article $msg_id\n";
}
close $ofh;
__END__
Hope that helps,
Paul Lalli
------------------------------
Date: Sat, 30 Jun 2007 22:34:38 -0400
From: "Wade Ward" <invalid@invalid.nyet>
Subject: Re: unlurking
Message-Id: <HoGdnQL_nMhljxrbnZ2dnUVZ_g-dnZ2d@comcast.com>
"Paul Lalli" <mritty@gmail.com> wrote in message
news:1183256619.607912.101960@n60g2000hse.googlegroups.com...
> On Jun 30, 7:32 pm, "Wade Ward" <inva...@invalid.nyet> wrote:
>
>> Subject: unlurking
>
> Please put the subject of your post in the Subject of your post. Your
> post is not about you unlurking. It's about using Perl to read
> Usenet.
>
>> Can someone give me a script or a reference (it's likely that either
>> Barnes and Noble or the library has popular titles) on how to use perl
>> to herd messages in a usenet thread into a file?
>
> Here's a short but complete script that contacts my local news host
> and retrieves the past day's new posts from comp.lang.perl.misc.
> Perhaps you can use it as a starting point. It uses the Net::NNTP
> module from CPAN.
>
> #!/usr/bin/env perl
> use strict;
> use warnings;
> use Net::NNTP;
>
> my $nntp = Net::NNTP->new('news.example.com', { Debug => 1} );
>
> $nntp->group('comp.lang.perl.misc')
> or die "failed to set group c.l.p.m.\n";
> my $msg_ids_ref = $nntp->newnews(time() - 24*60*60);
> die "Failed to retrieve message ids\n" unless @{$msg_ids_ref};
>
> open my $ofh, '>', 'articles.txt'
> or die "Cannot open articles.txt: $!";
> for my $msg_id (@{$msg_ids_ref}) {
> $nntp->article($msg_id, $ofh)
> or die "Failed to retrieve article $msg_id\n";
> }
> close $ofh;
> __END__
>
>
> Hope that helps,
A cursory view would lead me to believe that that's darn close. Now I have
to embarrass myself by bringing up my failures in understanding,
categorically. Best to sleep on it.
--
WW
------------------------------
Date: Sat, 30 Jun 2007 22:03:58 -0600
From: Scott Bryce <sbryce@scottbryce.com>
Subject: Re: unlurking
Message-Id: <sKudnR-Nm_42uhrbnZ2dnUVZ_v-tnZ2d@comcast.com>
<code snipped>
Wade Ward wrote:
> A cursory view would lead me to believe that that's darn close. Now I have
> to embarrass myself by bringing up my failures in understanding,
> categorically. Best to sleep on it.
Even better to read the docs for Net::NNTP. In the morning, perhaps?
http://search.cpan.org/~gbarr/libnet-1.21/Net/NNTP.pm
> --
> WW
Your sig separator is incorrect. It should be hyphen hyphen space return.
------------------------------
Date: 6 Apr 2001 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin)
Subject: Digest Administrivia (Last modified: 6 Apr 01)
Message-Id: <null>
Administrivia:
#The Perl-Users Digest is a retransmission of the USENET newsgroup
#comp.lang.perl.misc. For subscription or unsubscription requests, send
#the single line:
#
# subscribe perl-users
#or:
# unsubscribe perl-users
#
#to almanac@ruby.oce.orst.edu.
NOTE: due to the current flood of worm email banging on ruby, the smtp
server on ruby has been shut off until further notice.
To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.
#To request back copies (available for a week or so), send your request
#to almanac@ruby.oce.orst.edu with the command "send perl-users x.y",
#where x is the volume number and y is the issue number.
#For other requests pertaining to the digest, send mail to
#perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
#sending perl questions to the -request address, I don't have time to
#answer them even if I did know the answer.
------------------------------
End of Perl-Users Digest V11 Issue 606
**************************************
