[30479] in Perl-Users-Digest
Perl-Users Digest, Issue: 1722 Volume: 11
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Wed Jul 16 14:09:57 2008
Date: Wed, 16 Jul 2008 11:09:19 -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 Wed, 16 Jul 2008 Volume: 11 Number: 1722
Today's topics:
Re: comma quoted lists question <cartercc@gmail.com>
Re: comma quoted lists question xhoster@gmail.com
Re: comma quoted lists question <fawaka@gmail.com>
Re: comma quoted lists question <jimsgibson@gmail.com>
Re: FAQ 1.12 What's the difference between "perl" and " <tzz@lifelogs.com>
Re: FAQ 1.12 What's the difference between "perl" and " <cor@gmail.com>
Re: FAQ 1.12 What's the difference between "perl" and " <tzz@lifelogs.com>
Re: FAQ 1.12 What's the difference between "perl" and " <cwilbur@chromatico.net>
Re: Fastest way to remove common substrings from a list <fawaka@gmail.com>
Re: Net::SMTP and Postfix mai considered spam by google <joe@inwap.com>
new CPAN modules on Wed Jul 16 2008 (Randal Schwartz)
Re: reliability problem with Finance::QuoteHist::Yahoo <Peter@PSDT.com>
Re: reliability problem with Finance::QuoteHist::Yahoo <r.ted.byers@gmail.com>
Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: Wed, 16 Jul 2008 05:40:39 -0700 (PDT)
From: cartercc <cartercc@gmail.com>
Subject: Re: comma quoted lists question
Message-Id: <740f6022-bfa1-44a4-890d-dcba7a9b45b0@25g2000hsx.googlegroups.com>
On Jul 15, 4:45 pm, Jim Gibson <jimsgib...@gmail.com> wrote:
> The best solution was already provided: don't ask your users to save
> their spreadsheets as CSV, tab-delimited, or any other type of file.
> Ask them to send you their Excel documents and extract the data using
> the Spreadsheet::ParseExcel module. To me, this is a "no-brainer".
Okay, I got both WriteExcel and ParseExcel, and will play with them
next week. Just offhand, do you know whether ParseExcel will work with
Office 2007? Will WriteExcel work with Office 2007? If you know they
will not, it will save me some time.
Thanks, CC.
------------------------------
Date: 16 Jul 2008 15:34:28 GMT
From: xhoster@gmail.com
Subject: Re: comma quoted lists question
Message-Id: <20080716113429.619$hI@newsreader.com>
cartercc <cartercc@gmail.com> wrote:
> On Jul 15, 4:45 pm, Jim Gibson <jimsgib...@gmail.com> wrote:
> > The best solution was already provided: don't ask your users to save
> > their spreadsheets as CSV, tab-delimited, or any other type of file.
> > Ask them to send you their Excel documents and extract the data using
> > the Spreadsheet::ParseExcel module. To me, this is a "no-brainer".
>
> Okay, I got both WriteExcel and ParseExcel, and will play with them
> next week. Just offhand, do you know whether ParseExcel will work with
> Office 2007? Will WriteExcel work with Office 2007? If you know they
> will not, it will save me some time.
I don't know, and don't have access to Office 2007 to test it on. If you
find out, please report back as I'm curious to know, too. Thanks,
Xho
--
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.
------------------------------
Date: Wed, 16 Jul 2008 18:09:27 +0200
From: Leon Timmermans <fawaka@gmail.com>
Subject: Re: comma quoted lists question
Message-Id: <24ed4$487e1d37$89e0e08f$2685@news1.tudelft.nl>
On Wed, 16 Jul 2008 05:40:39 -0700, cartercc wrote:
> Okay, I got both WriteExcel and ParseExcel, and will play with them next
> week. Just offhand, do you know whether ParseExcel will work with Office
> 2007? Will WriteExcel work with Office 2007? If you know they will not,
> it will save me some time.
>
> Thanks, CC.
They will use the old XLS format, which should work just fine with Excel
2007. There is a Spreadsheet-WriteExcelXML class to write XLSX files, but
there doesn't seem to be a class that reads them yet. It should work just
fine, as long as your users don't try to convert your XML files to XLSX.
Leon Timmermans
------------------------------
Date: Wed, 16 Jul 2008 09:11:50 -0700
From: Jim Gibson <jimsgibson@gmail.com>
Subject: Re: comma quoted lists question
Message-Id: <160720080911500084%jimsgibson@gmail.com>
In article <20080716113429.619$hI@newsreader.com>, <xhoster@gmail.com>
wrote:
> cartercc <cartercc@gmail.com> wrote:
> > On Jul 15, 4:45 pm, Jim Gibson <jimsgib...@gmail.com> wrote:
> > > The best solution was already provided: don't ask your users to save
> > > their spreadsheets as CSV, tab-delimited, or any other type of file.
> > > Ask them to send you their Excel documents and extract the data using
> > > the Spreadsheet::ParseExcel module. To me, this is a "no-brainer".
> >
> > Okay, I got both WriteExcel and ParseExcel, and will play with them
> > next week. Just offhand, do you know whether ParseExcel will work with
> > Office 2007? Will WriteExcel work with Office 2007? If you know they
> > will not, it will save me some time.
>
> I don't know, and don't have access to Office 2007 to test it on. If you
> find out, please report back as I'm curious to know, too. Thanks,
Apparently not:
From <http://www.cpanforum.com/posts/6027>
"Posted on Thu Sep 6 17:56:48 2007 by jmcnamara in response to 6026
(See the whole thread of 2)
Re: Spreadsheet-ParseExcel is unable to parse excel 2007 file
Spreadsheet::ParseExcel only handles the Excel binary files format
called Biff that is used in Excel versions prior to 2007. Excel 2007
has a new file format that is comprised of zipped XML files. This is
not handled by Spreadsheet::WriteExcel.
If you unzip the 2007 xls file (change the extension to .zip if
necessary) you can probably parse the information out of the embedded
XML files using one of the Perl XML parsers."
--
Jim Gibson
------------------------------
Date: Wed, 16 Jul 2008 08:01:55 -0500
From: Ted Zlatanov <tzz@lifelogs.com>
Subject: Re: FAQ 1.12 What's the difference between "perl" and "Perl"?
Message-Id: <86hcaqugn0.fsf@lifelogs.com>
On Tue, 15 Jul 2008 16:37:10 -0700 "Gordon Corbin Etly" <ly@gmail.com> wrote:
GCE> Let me ask you something: if you are "arguing" with people who ignore
GCE> facts, who only provide excuses with little to no substance, which do
GCE> not disprove your central argument, and at the same time, refuse to see
GCE> reason, refuse to even acknowledge that there is some validity, what
GCE> would you do?
Well, in your case I tried to explain twice and then gave up.
GCE> Would you just feel it's right for people to push a belief, that
GCE> can easily be disproved, on others, or would you prefer to allow
GCE> people to freedom to express their own preferences?
Those two are not in conflict so it's not an A or B choice. I believe
in freedom of speech, so both of them are OK by me.
Ted
------------------------------
Date: Wed, 16 Jul 2008 09:17:40 -0700
From: "Gordon Corbin Etly" <cor@gmail.com>
Subject: Re: FAQ 1.12 What's the difference between "perl" and "Perl"?
Message-Id: <6e6l95F5ljn0U1@mid.individual.net>
Ted Zlatanov wrote:
> On Tue, 15 Jul 2008 16:37:10 -0700 "Gordon Corbin Etly" wrote:
> > Let me ask you something: if you are "arguing" with people who
> > ignore
> > facts, who only provide excuses with little to no substance, which
> > do
> > not disprove your central argument, and at the same time, refuse to
> > see reason, refuse to even acknowledge that there is some validity,
> > what would you do?
> Well, in your case I tried to explain twice and then gave up.
You at least tried to form a coherent argument, but you failed to prove
why it shouldn't be acceptable to write "PERL" just like you can
compress other meanings and expansions. I do commend you on your
attempts, however.
> > Would you just feel it's right for people to push a belief, that
> > can easily be disproved, on others, or would you prefer to allow
> > people to freedom to express their own preferences?
> Those two are not in conflict so it's not an A or B choice. I believe
> in freedom of speech, so both of them are OK by me.
Then why suppose this notion that people typing "PERL" is some how
inferior. It is little more than a stereotype, and there are several
people that push this and essentially tell the person they are replying
that "this is how to write it, conform or else". It's this which I
believe is just wrong. I have no problems _what_ _so_ _ever_ with
correcting people who are doing something wrong. However, typing "PERL"
is not a mistake in and of itself; it's a perfectly valid compression
and telling random people it is wrong is misleading at best, deceptive
at worst.
--
Gordon C. Etly
Email: perl -e "print q{}.reverse(q{moc.liamg@ylte.nodrog})"
------------------------------
Date: Wed, 16 Jul 2008 12:10:00 -0500
From: Ted Zlatanov <tzz@lifelogs.com>
Subject: Re: FAQ 1.12 What's the difference between "perl" and "Perl"?
Message-Id: <86od4xu55j.fsf@lifelogs.com>
On Wed, 16 Jul 2008 09:17:40 -0700 "Gordon Corbin Etly" <cor@gmail.com> wrote:
GCE> You at least tried to form a coherent argument, but you failed to prove
GCE> why it shouldn't be acceptable to write "PERL" just like you can
GCE> compress other meanings and expansions.
Right, nor do I care to prove it. It's irrelevant, as I've explained.
Please look up "shibboleth."
Ted
------------------------------
Date: Wed, 16 Jul 2008 13:51:59 -0400
From: Charlton Wilbur <cwilbur@chromatico.net>
Subject: Re: FAQ 1.12 What's the difference between "perl" and "Perl"?
Message-Id: <867iblemyo.fsf@mithril.chromatico.net>
>>>>> "GCE" == Gordon Corbin Etly <cor@gmail.com> writes:
GCE> Then why suppose this notion that people typing "PERL" is some
GCE> how inferior. It is little more than a stereotype, and there
GCE> are several people that push this and essentially tell the
GCE> person they are replying that "this is how to write it, conform
GCE> or else". It's this which I believe is just wrong. I have no
GCE> problems _what_ _so_ _ever_ with correcting people who are
GCE> doing something wrong. However, typing "PERL" is not a mistake
GCE> in and of itself; it's a perfectly valid compression and
GCE> telling random people it is wrong is misleading at best,
GCE> deceptive at worst.
I'm not telling you it's *wrong*, for the record.
I'm telling you that using it makes you look like someone who's
inexperienced with Perl, like someone who's never read the FAQ, or who's
too stubborn to conform to common usage.
These are the three reasons that people commonly use PERL.
Inexperience, ignorance, intransigence.
You may be a brilliant programmer, the best software developer ever, but
if you use PERL on a resume, in a cover letter, or in an online forum,
the safe bet is that you're one of the three. It's not worth wasting
time to figure out that you're just a free thinker.
Charlton
--
Charlton Wilbur
cwilbur@chromatico.net
------------------------------
Date: Wed, 16 Jul 2008 04:04:54 +0200
From: Leon Timmermans <fawaka@gmail.com>
Subject: Re: Fastest way to remove common substrings from a list of strings
Message-Id: <dbbb7$487d5746$89e0e08f$11280@news1.tudelft.nl>
On Tue, 15 Jul 2008 15:45:42 -0700, szr wrote:
>
> Or he just change that regex from /$s/ to /^$s/ to also achor it at the
> beginning. I think the substr might be ever so slightly faster though.
Yeah, I expected it to be faster, but haven't really tried. I suppose it
won't really matter anyway in this case though.
Leon Timmermans
------------------------------
Date: Wed, 16 Jul 2008 00:23:00 -0700
From: Joe Smith <joe@inwap.com>
Subject: Re: Net::SMTP and Postfix mai considered spam by googlemail
Message-Id: <EdidnQgufPJLPODVnZ2dnUVZ_uGdnZ2d@comcast.com>
John wrote:
> Hi
>
> I am looking at Net:SMTP and keyed in the following code as a test:
>...
> $smtp->datasend("From: john\@example.com\n");
> $smtp->datasend("To: one.two\@googlemail.com\n");
> $smtp->datasend("Subject: This is a test\n");
> $smtp->datasend("\n\n");
A message like that is fine for sending through your friendly neighborhood
SMTP relay host, but not good enough to pass through a spam filter.
Date header missing or incorrectly formatted.
Message-ID header missing.
Received header(s) missing or inconsistent.
Origination IP known to be an end user (cable modem, DSL, dial-up, etc).
Instead of going straight to the recipient's MX server, it is usually
better to go to your ISP's mail relay host. The relay will often
add missing headers and will provide a legitimate hostname+IP_address
for the TCP connection to the MX server.
-Joe
------------------------------
Date: Wed, 16 Jul 2008 04:42:21 GMT
From: merlyn@stonehenge.com (Randal Schwartz)
Subject: new CPAN modules on Wed Jul 16 2008
Message-Id: <K4312L.1tyy@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.
ASCII-validate
http://search.cpan.org/~rjsri/ASCII-validate/
----
Apache2-reCaptcha-0.3
http://search.cpan.org/~analog/Apache2-reCaptcha-0.3/
reCaptcha based auth system using cookies.
----
BSD-arc4random-1.22
http://search.cpan.org/~sjsz/BSD-arc4random-1.22/
Perl interface to the arc4 random number generator
----
Business-OnlinePayment-Iridium-0.03
http://search.cpan.org/~wreis/Business-OnlinePayment-Iridium-0.03/
Iridium backend for Business::OnlinePayment
----
CGI-Session-4.35
http://search.cpan.org/~markstos/CGI-Session-4.35/
persistent session data in CGI applications
----
CatalystX-Imports-0.03
http://search.cpan.org/~flora/CatalystX-Imports-0.03/
Shortcut functions for Catalyst controllers
----
Compress-Raw-Bzip2-2.012
http://search.cpan.org/~pmqs/Compress-Raw-Bzip2-2.012/
Low-Level Interface to bzip2 compression library
----
Compress-Raw-Zlib-2.012
http://search.cpan.org/~pmqs/Compress-Raw-Zlib-2.012/
Low-Level Interface to zlib compression library
----
Compress-Zlib-2.012
http://search.cpan.org/~pmqs/Compress-Zlib-2.012/
Interface to zlib compression library
----
Data-ParseBinary-0.01
http://search.cpan.org/~semuelf/Data-ParseBinary-0.01/
Yet Another parser for binary structures
----
DateTime-Format-CLDR-1.00
http://search.cpan.org/~maros/DateTime-Format-CLDR-1.00/
Parse and format CLDR time patterns
----
Devel-NYTProf-2.00
http://search.cpan.org/~timb/Devel-NYTProf-2.00/
Powerful feature-rich perl source code profiler
----
Devel-NYTProf-2.01
http://search.cpan.org/~timb/Devel-NYTProf-2.01/
Powerful feature-rich perl source code profiler
----
Devel-Refcount-0.01
http://search.cpan.org/~pevans/Devel-Refcount-0.01/
obtain the REFCNT value of a referent
----
Finance-Bank-IE-0.13
http://search.cpan.org/~waider/Finance-Bank-IE-0.13/
----
Graphics-Primitive-0.02
http://search.cpan.org/~gphat/Graphics-Primitive-0.02/
Device and library agnostic graphics objects
----
Gtk2-GladeXML-OO-0.422
http://search.cpan.org/~strzelec/Gtk2-GladeXML-OO-0.422/
Drop-in replacement for Gtk2::GladeXML with object oriented interface to Glade.
----
IO-AIO-3.06
http://search.cpan.org/~mlehmann/IO-AIO-3.06/
Asynchronous Input/Output
----
IO-Compress-Base-2.012
http://search.cpan.org/~pmqs/IO-Compress-Base-2.012/
Base Class for IO::Compress modules
----
IO-Compress-Bzip2-2.012
http://search.cpan.org/~pmqs/IO-Compress-Bzip2-2.012/
Write bzip2 files/buffers
----
IO-Compress-Lzf-2.012
http://search.cpan.org/~pmqs/IO-Compress-Lzf-2.012/
Write lzf files/buffers
----
IO-Compress-Lzop-2.012
http://search.cpan.org/~pmqs/IO-Compress-Lzop-2.012/
Write lzop files/buffers
----
IO-Compress-Zlib-2.012
http://search.cpan.org/~pmqs/IO-Compress-Zlib-2.012/
----
JSON-XS-2.22
http://search.cpan.org/~mlehmann/JSON-XS-2.22/
JSON serialising/deserialising, done correctly and fast
----
LEOCHARRE-Dir-1.02
http://search.cpan.org/~leocharre/LEOCHARRE-Dir-1.02/
subs for dirs
----
Layout-Manager-0.05
http://search.cpan.org/~gphat/Layout-Manager-0.05/
2D Layout Management
----
Module-Install-GetProgramLocations-0.3002
http://search.cpan.org/~dcoppit/Module-Install-GetProgramLocations-0.3002/
A Module::Install extension that allows the user to interactively specify the location of programs needed by the module to be installed
----
MooseX-KeyedMutex-0.00001
http://search.cpan.org/~dmaki/MooseX-KeyedMutex-0.00001/
Role To Add KeyedMutex
----
Mvalve-0.00009
http://search.cpan.org/~dmaki/Mvalve-0.00009/
Generic Q4M Powered Message Pipe
----
OpenResty-0.3.15
http://search.cpan.org/~agent/OpenResty-0.3.15/
General-purpose web service platform for web applications
----
PerlIO-Util-0.54
http://search.cpan.org/~gfuji/PerlIO-Util-0.54/
A selection of general PerlIO utilities
----
Syntax-Highlight-Engine-Simple-0.05
http://search.cpan.org/~jamadam/Syntax-Highlight-Engine-Simple-0.05/
Simple Syntax Highlight Engine
----
Sys-Info-0.61
http://search.cpan.org/~burak/Sys-Info-0.61/
Fetch information from the host system
----
Sys-Info-0.62
http://search.cpan.org/~burak/Sys-Info-0.62/
Fetch information from the host system
----
Test-Aggregate-0.24
http://search.cpan.org/~ovid/Test-Aggregate-0.24/
Aggregate *.t tests to make them run faster.
----
Tie-EncryptedHash-1.23
http://search.cpan.org/~vipul/Tie-EncryptedHash-1.23/
Hashes (and objects based on hashes) with encrypting fields.
----
Tie-EncryptedHash-1.24
http://search.cpan.org/~vipul/Tie-EncryptedHash-1.24/
Hashes (and objects based on hashes) with encrypting fields.
----
WWW-Search-2.503
http://search.cpan.org/~mthurn/WWW-Search-2.503/
Virtual base class for WWW searches
----
XML-Entities-0.03-02
http://search.cpan.org/~sixtease/XML-Entities-0.03-02/
Decode strings with XML entities
----
Yahoo-Marketing-4.20
http://search.cpan.org/~shenj/Yahoo-Marketing-4.20/
an interface for Yahoo! Search Marketing's Web Services.
----
iTunes-Sid-0.42
http://search.cpan.org/~billh/iTunes-Sid-0.42/
Apple iTunes SC Info common user database file interface
----
parrot-0.6.4
http://search.cpan.org/~bschmal/parrot-0.6.4/
----
threads-shared-1.25
http://search.cpan.org/~jdhedden/threads-shared-1.25/
Perl extension for sharing data structures between threads
----
umlmgr-0.10
http://search.cpan.org/~nanardon/umlmgr-0.10/
A user mode linux manager
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/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion
------------------------------
Date: Wed, 16 Jul 2008 09:38:41 GMT
From: Peter Scott <Peter@PSDT.com>
Subject: Re: reliability problem with Finance::QuoteHist::Yahoo
Message-Id: <pan.2008.07.16.09.38.41.381184@PSDT.com>
On Fri, 11 Jul 2008 21:53:53 -0700, Ted wrote:
> I have been able to get this package to work sometimes. However,
> invariably it fails on me part way through my script, after
> downloading data for from one to four ticker symbols. The error is:
>
> Can't use an undefined value as an ARRAY reference at C:/Perl/site/lib/
> Finance/QuoteHist/Generic.pm line 863.
Line 863 of the current version of that module does not attempt an array
dereference. Consider upgrading.
> I have no information about how an undefined value is being passed
deep
> into the code of a package I didn't write. I took a quick look into
> Generic.pm and yahoo.pm, but found no enlightenment so far (there's a
> lot of code there).
>
> Sometimes it arises when quotes() is executed, and at other times, it
> occurs when dividends() is executed.
I have been using Finance::QuoteHiat::Yahoo nearly daily for several years
without once having a problem. There again, I do not call splits() or
dividends(). I also do not use 'today' as a date and I always use a
starting date that I know data exists for. Construct a minimal program
requiring no user inputs that fails every time and post it here. If the
problem were changes to the Yahoo format it is extremely unlikely that the
behavior would be nondeterministic. I think it more likely that the
behavior is consistent for a particular ticker symbol.
--
Peter Scott
http://www.perlmedic.com/
http://www.perldebugged.com/
------------------------------
Date: Wed, 16 Jul 2008 04:45:44 -0700 (PDT)
From: Ted Byers <r.ted.byers@gmail.com>
Subject: Re: reliability problem with Finance::QuoteHist::Yahoo
Message-Id: <009608c6-278d-4960-bbfd-e04909970c4f@x41g2000hsb.googlegroups.com>
Hi Peter,
On Jul 16, 5:38=A0am, Peter Scott <Pe...@PSDT.com> wrote:
> On Fri, 11 Jul 2008 21:53:53 -0700, Ted wrote:
> > I have been able to get this package to work sometimes. =A0However,
> > invariably it fails on me part way through my script, after
> > downloading data for from one to four ticker symbols. =A0The error is:
>
> > Can't use an undefined value as an ARRAY reference at C:/Perl/site/lib/
> > Finance/QuoteHist/Generic.pm line 863.
>
> Line 863 of the current version of that module does not attempt an array
> dereference. =A0Consider upgrading.
>
>
I am using version 1.11. I know that is about a year old, but I
haven't found a more recent release. Is there one?
Thanks
Ted
------------------------------
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 1722
***************************************
