Installl CPAN packages without ftp.

2005-08-04 Thread Nicolae.Popovici
Title: Installl CPAN packages without ftp.






Hi guys,


 Following problem: I would like to install SFTP package from CPAN on my computer but it has a lot of dependencies that I need and I DO NOT have ftp access. Any other way without downloading each one of them? Downloading each one of them and then search through dependencies and then repeat the steps it will take to much time and it is error prone.

Thanks,

Nicu



 



___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Installl CPAN packages without ftp.

2005-08-04 Thread $Bill Luebkert
[EMAIL PROTECTED] wrote:

 Hi guys,
 
Following problem: I would like to install SFTP package from CPAN on
 my computer but it has a lot of dependencies that I need and I DO NOT
 have ftp access. Any other way without downloading each one of them?
 Downloading each one of them and then search through dependencies and
 then repeat the steps it will take to much time and it is error prone.

Your browser should also handle FTP links.
You should be able to D/L using HTTP links as well.

EG:

http://cpan.uwinnipeg.ca/htdocs/faqs/cpan-search.html  Search for 'net sftp'

D/L:
http://cpan.uwinnipeg.ca/cpan/authors/id/D/DB/DBROBINS/Net-SFTP-0.09.tar.gz

-- 
  ,-/-  __  _  _ $Bill LuebkertMailto:[EMAIL PROTECTED]
 (_/   /  )// //   DBE CollectiblesMailto:[EMAIL PROTECTED]
  / ) /--  o // //  Castle of Medieval Myth  Magic http://www.todbe.com/
-/-' /___/__/_/_http://dbecoll.tripod.com/ (My Perl/Lakers stuff)
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Installl CPAN packages without ftp.

2005-08-04 Thread Octavian Rasnita
Title: Installl CPAN packages without ftp.



Hi,

You could install cpan modules using the cpan 
shell.

Before doing this, delete all the urllist and then 
make sure you will add only CPAN sites which are not using FTP but 
http.
There are much fewer http CPAN sites than FTP 
sites, but there are some...

Teddy


  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Perl-Win32-Users@listserv.ActiveState.com 
  
  Sent: Thursday, August 04, 2005 10:46 
  AM
  Subject: Installl CPAN packages without 
  ftp.
  
  Hi guys, 
   Following problem: I would like to 
  install SFTP package from CPAN on my computer but it has a lot of dependencies 
  that I need and I DO NOT have ftp access. Any other way without downloading 
  each one of them? Downloading each one of them and then search through 
  dependencies and then repeat the steps it will take to much time and it is 
  error prone.
  Thanks, Nicu 
   
  
  

  ___Perl-Win32-Users 
  mailing listPerl-Win32-Users@listserv.ActiveState.comTo unsubscribe: 
  http://listserv.ActiveState.com/mailman/mysubs
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Installl CPAN packages without ftp.

2005-08-04 Thread Sisyphus

- Original Message - 
From: [EMAIL PROTECTED]
To: Perl-Win32-Users@listserv.ActiveState.com
Sent: Thursday, August 04, 2005 5:46 PM
Subject: Installl CPAN packages without ftp.


Hi guys,

   Following problem: I would like to install SFTP package from CPAN on
my computer but it has a lot of dependencies that I need and I DO NOT
have ftp access. Any other way without downloading each one of them?
Downloading each one of them and then search through dependencies and
then repeat the steps it will take to much time and it is error prone.

Thanks,
Nicu

For a simpler solution, using ppm, see:

http://www.soulcage.net/ppds/

You probably need only 'ppm install Net-SSH-W32Perl', followed by 'ppm
install Net-SFTP'.

Cheers,
Rob











 ___
 Perl-Win32-Users mailing list
 Perl-Win32-Users@listserv.ActiveState.com
 To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


RE: Installl CPAN packages without ftp.

2005-08-04 Thread Nicolae.Popovici


-Original Message-
From: $Bill Luebkert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 04, 2005 10:59 AM
To: Popovici Nicolae (HTX)
Cc: Perl-Win32-Users@listserv.ActiveState.com
Subject: Re: Installl CPAN packages without ftp.


[EMAIL PROTECTED] wrote:

 Hi guys,
 
Following problem: I would like to install SFTP package from CPAN 
 on my computer but it has a lot of dependencies that I need and I DO 
 NOT have ftp access. Any other way without downloading each one of 
 them? Downloading each one of them and then search through 
 dependencies and then repeat the steps it will take to much time and 
 it is error prone.

Your browser should also handle FTP links.
You should be able to D/L using HTTP links as well.

EG:

http://cpan.uwinnipeg.ca/htdocs/faqs/cpan-search.html  Search for 'net
sftp'

D/L:
http://cpan.uwinnipeg.ca/cpan/authors/id/D/DB/DBROBINS/Net-SFTP-0.09.tar
.gz


Tried that. Unfourtunately the package does not find the
Class-ErrorHandler package on the uwinnipeg server. This is the error
message that I get:
ppm install Net-SFTP
Error: Package 'Class-ErrorHandler' not found on server. Please 'search'
for it
first.
ppm
I did find the package on CPAN and I install it on my machine. However 
ppmsearch Class-ErrorHandler 
on my local repository does not find it. Any ideeas of what may be
wrong?

Nicu

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


RE: Installl CPAN packages without ftp.

2005-08-04 Thread Nicolae.Popovici


-Original Message-
From: Sisyphus [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 04, 2005 11:17 AM
To: Popovici Nicolae (HTX); Perl-Win32-Users@listserv.ActiveState.com
Subject: Re: Installl CPAN packages without ftp.



- Original Message - 
From: [EMAIL PROTECTED]
To: Perl-Win32-Users@listserv.ActiveState.com
Sent: Thursday, August 04, 2005 5:46 PM
Subject: Installl CPAN packages without ftp.


Hi guys,

   Following problem: I would like to install SFTP package from CPAN on
my computer but it has a lot of dependencies that I need and I DO NOT
have ftp access. Any other way without downloading each one of them?
Downloading each one of them and then search through dependencies and
then repeat the steps it will take to much time and it is error prone.

Thanks,
Nicu

For a simpler solution, using ppm, see:

http://www.soulcage.net/ppds/

You probably need only 'ppm install Net-SSH-W32Perl', followed by 'ppm
install Net-SFTP'.

Cheers,
Rob

Tried that but only the last part and it says that the package does not
exist on this server. I guess just installing the first one would not
make any diference.

Nicu










 ___
 Perl-Win32-Users mailing list 
 Perl-Win32-Users@listserv.ActiveState.com
 To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Installl CPAN packages without ftp.

2005-08-04 Thread Sisyphus

- Original Message - 
From: [EMAIL PROTECTED]

 
 You probably need only 'ppm install Net-SSH-W32Perl', followed by 'ppm
 install Net-SFTP'.
 
 Cheers,
 Rob
 
 Tried that but only the last part and it says that the package does not
 exist on this server. I guess just installing the first one would not
 make any diference.

This worked ok for me:

D:\ppm install http://www.soulcage.net/ppds.58/Net-SFTP.ppd
Installing package 'http://www.soulcage.net/ppds.58/Net-SFTP.ppd'...
Bytes transferred: 15487
Installing D:\perl58_M\5.8.7\html\lib\Net\SFTP.html
Installing D:\perl58_M\5.8.7\html\lib\Net\SFTP\Attributes.html
Installing D:\perl58_M\5.8.7\html\lib\Net\SFTP\Buffer.html
Installing D:\perl58_M\5.8.7\html\lib\Net\SFTP\Constants.html
Installing D:\perl58_M\5.8.7\html\lib\Net\SFTP\Util.html
Installing D:\perl58_M\site\5.8.7\lib\Net\SFTP.pm
Installing D:\perl58_M\site\5.8.7\lib\Net\SFTP\Attributes.pm
Installing D:\perl58_M\site\5.8.7\lib\Net\SFTP\Buffer.pm
Installing D:\perl58_M\site\5.8.7\lib\Net\SFTP\Constants.pm
Installing D:\perl58_M\site\5.8.7\lib\Net\SFTP\Util.pm
Writing D:\perl58_M\site\5.8.7\lib\auto\Net\SFTP\.packlist

Cheers,
Rob
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Installl CPAN packages without ftp.

2005-08-04 Thread $Bill Luebkert
[EMAIL PROTECTED] wrote:

 Tried that. Unfourtunately the package does not find the
 Class-ErrorHandler package on the uwinnipeg server. This is the error
 message that I get:
 ppm install Net-SFTP
 Error: Package 'Class-ErrorHandler' not found on server. Please 'search'
 for it
 first.
 ppm
 I did find the package on CPAN and I install it on my machine. However 
 ppmsearch Class-ErrorHandler 
 on my local repository does not find it. Any ideeas of what may be
 wrong?

Don't know.  Why didn't you say PPM was OK ?  I would always use PPM over
CPAN if available.

Try doing a PPM search and install from AS site for your Class-ErrorHandler
module.  Then go back and try Net-SFTP again (uninstall of necessary).

Here's an older version if you can't get .09 running:
http://www.soulcage.net/ppds/PPDS.58/

-- 
  ,-/-  __  _  _ $Bill LuebkertMailto:[EMAIL PROTECTED]
 (_/   /  )// //   DBE CollectiblesMailto:[EMAIL PROTECTED]
  / ) /--  o // //  Castle of Medieval Myth  Magic http://www.todbe.com/
-/-' /___/__/_/_http://dbecoll.tripod.com/ (My Perl/Lakers stuff)
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Win32::ChangeNotify

2005-08-04 Thread Michael Meltzer

With this module I monitor  changes in a directory:

mailprot(Monitoring gestartet);   

$WatchSubTree = 1;  
$Events = 'FILE_NAME';  


Win32::ChangeNotify::FindFirst($monitor, $MonDir, $WatchSubTree,
   FILE_NOTIFY_CHANGE_FILE_NAME
 );

while ($monitor-FindNext()) {
   $monitor-Wait( INFINITE );
#sleep(300);
   $Inhalt = ;   
   if (! opendir (BKDIR, $MonDir)) {   
 mailprot(can't opendir $MonDir:\n   $!\n);

   }
   while (defined ($fname = readdir(BKDIR))) {
  next if $fname =~ /^\.$/;   
  next if $fname =~ /^\.\.$/;

  next if $fname =~ /@ReadMe\.htm/i;
  next if $fname =~ /^Bitte Version und Sprache/i;
  $Inhalt = ${Inhalt}\n$fname;  
   }   
   close BKDIR;

   mailprot(Aenderungen im Briefkasten:\n$Inhalt);
}

END{ mailprot(Monitoring gestoppt); } 
exit 0;



I compiled the program whith perl2exe to an exe file.

If I start the  program from comand line all works fine but if it runs 
as service I get no
message if something changes in the monitored directory but i get the 
start message

(see first line in script)

The service was created as described in Dave Roth's  Book
'Win32 Perl Scripting', Page  274  in the following way:

instsrv.exe monitor  C:\WIN_NT\system32/srvany.exe

Modifying the registry was not as described in the book. I had to create 
the Parameters key.

Should the key not be there already ?
That's what I now have in the registry:
'Monitor' has the keys Enum, Parameters, Security
Parameters has the String Values ApplicationREG_SZ  Path to my 
exe file

  AppParameters REG_SZ
  (Default)   
REG_SZ  (Value not set)

If I start or stop the service I get the start or stop message by mail
but if I create or delete a file in the monitored directory I get no 
message.

Why ?

Details: Win2000 (upgrade from NT) SP4
ActiveState perl 5.6.1.623
Win32::ChangeNotify 1.02

Michael

--
Michael Meltzer  AED-SICAD AGLilienthal-Str. 7  D-85579 Neubiberg
   Tel.:+49 89 45026 108Fax: +49 89 45026 113
[EMAIL PROTECTED]
http://www.aed-sicad.de/

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: HTML::GoogleMaps or Other Way to show multiple addresses on a

2005-08-04 Thread $Bill Luebkert
Suresh Govindachar wrote:

 One answer to the question I asked earlier: 
 
I would like to show multiple addresses on a map -- from
a user PC (rather than from a web-server).  I am

Why not a webserver on your local PC ?  You can easily install
Apache on your PC from Apache.org.

hoping to have a perl script read in a list of addresses
and generate a html page.  All the input addresses would
be within about 20 miles of each other; and each address
in the list would have a html link associated with it.
Viewing the html page generated by the perl script in a
browser should show a map with markers for each address
in the list.  Clicking on the marker should open a new
browser for the html link associated with that address.

Can the preceding be done?  Any suggestions?
   
 is WebServer::GoogleMaps.  
 
 To install on Windows, just end up with the file
 pathperl/site/libWebService/GoogleMaps.pm 
 Then change line 57 in GoogleMaps.pm from 
 $self-{gm_version} ||= .1;
 to 
 $self-{gm_version} ||= .3;
 (Preceding modification is from a post to CPAN::Forum 
 by Michael Burns on Sat Jun 18 20:38:18 2005.)
 Then run the two main examples and look at the resulting 
 images mymap.png and goodeats.png.

I would consider using HTML::GoogleMaps instead and bring up the
Google map interactive so you can pan and zoom direct from the
Google site.  You can get a free key for your machine (I got one
for 127.0.0.1 and used that on my PC).

-- 
  ,-/-  __  _  _ $Bill LuebkertMailto:[EMAIL PROTECTED]
 (_/   /  )// //   DBE CollectiblesMailto:[EMAIL PROTECTED]
  / ) /--  o // //  Castle of Medieval Myth  Magic http://www.todbe.com/
-/-' /___/__/_/_http://dbecoll.tripod.com/ (My Perl/Lakers stuff)
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


RE: Installl CPAN packages without ftp.

2005-08-04 Thread Nicolae.Popovici


-Original Message-
From: $Bill Luebkert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 04, 2005 1:51 PM
To: Popovici Nicolae (HTX)
Cc: Perl-Win32-Users@listserv.ActiveState.com
Subject: Re: Installl CPAN packages without ftp.


[EMAIL PROTECTED] wrote:

 Tried that. Unfourtunately the package does not find the 
 Class-ErrorHandler package on the uwinnipeg server. This is the error 
 message that I get:
 ppm install Net-SFTP
 Error: Package 'Class-ErrorHandler' not found on server. Please 
 'search' for it first.
 ppm
 I did find the package on CPAN and I install it on my machine. However
 ppmsearch Class-ErrorHandler
 on my local repository does not find it. Any ideeas of what may be 
 wrong?

Don't know.  Why didn't you say PPM was OK ?  I would always use PPM
over CPAN if available.

Try doing a PPM search and install from AS site for your
Class-ErrorHandler module.  Then go back and try Net-SFTP again
(uninstall of necessary).

Here's an older version if you can't get .09 running:
http://www.soulcage.net/ppds/PPDS.58/


It looks like it runs on my machine now. Thanks Bill, thanks Rob. It was
a combination of the packages from ActiveState and uwinnipeg packages.

Now, I said that it looks like it is running on my machine because when
I packed it with pp and run the result on another machine it complains
with the following error message:


Can't locate Net/SSH/Perl/Util/SSH2MP.pm in @INC (@INC contains:
CODE(0xcc384c) CODE(0xdbac7c) .) at
 C:/Perl/site/lib/Net/SSH/Perl/Util.pm line 56.
BEGIN failed--compilation aborted at C:/Perl/site/lib/Net/SFTP/Buffer.pm
line 9.
Compilation failed in require at C:/Perl/site/lib/Net/SFTP/Attributes.pm
line 7.
BEGIN failed--compilation aborted at
C:/Perl/site/lib/Net/SFTP/Attributes.pm line 7.
Compilation failed in require at C:/Perl/site/lib/Net/SFTP.pm line 8.
BEGIN failed--compilation aborted at C:/Perl/site/lib/Net/SFTP.pm line
8.
Compilation failed in require at script/secFTP.pl line 9.
BEGIN failed--compilation aborted at script/secFTP.pl line 9.


Here is my small sftp test program.
==

use strict;
use warnings;

use Net::SFTP;

sub SendFileOverFTP {


 #  my($file,$local)= @_; 

my %args = (
user = someuser,
password = xxx,
debug = true,
); 

my %defaultArgs = (
FTPServer = MyFtpSite,
FTPRemoteDir = someDir);

my $sftp = Net::SFTP-new($defaultArgs{FTPServer},%args); 

  my $openFtpDir =  $sftp-do_open($defaultArgs{FTPRemoteDir});
if ( !defined($openFtpDir) ) {
 print failed to open the ftp directory\n;
}

my $local = someFile.txt; 
my $remote = someFile.txt;

my $ergebnis = $sftp-put($local,$remote); 

if ( !defined($ergebnis) )
{
print error\n;
}

#$sftp-quit; 
undef $sftp;
}

SendFileOverFTP;
===

Any ideeas?

Cheers,
Nicu


___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


RE: Installl CPAN packages without ftp.

2005-08-04 Thread Randy Kobes

On Thu, 4 Aug 2005, [EMAIL PROTECTED] wrote:
[ ... ]

Tried that. Unfourtunately the package does not find the
Class-ErrorHandler package on the uwinnipeg server. This is the error
message that I get:
ppm install Net-SFTP
Error: Package 'Class-ErrorHandler' not found on server. Please 'search'
for it first.
ppm
I did find the package on CPAN and I install it on my machine. However
ppmsearch Class-ErrorHandler
on my local repository does not find it. Any ideeas of what may be
wrong?


I didn't have Class-ErrorHandler in our repository (I've 
since added it, though) because it's in ActiveState's 
repository:

   http://ppm.activestate.com/BuildStatus/5.8-C.html
Do you have ActiveState's repository in your list of
active repositories within ppm?

--
best regards,
randy
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Win32:OLE Excel

2005-08-04 Thread Hsu, David
Hi,
Does someone know of another method of naming the Excel sheets?
Currently I am using:
...
$Worksheet = $Workbook-Worksheets()-Add();
$Worksheet-{Name} = test $i;
...

The sheet names are still Sheet1, Sheet2, etc...

Thanks,
David

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


RE: Win32:OLE Excel

2005-08-04 Thread Ken Barker
Try

$ws1 = $workbook-add_worksheet('worksheetname');



Ken Barker
IT Lead
Americall Group, Inc
314-213-7927
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Hsu, David
Sent: Thursday, August 04, 2005 10:23 AM
To: Perl-Win32-Users@listserv.ActiveState.com
Subject: Win32:OLE Excel


Hi,
Does someone know of another method of naming the Excel sheets?
Currently I am using:
...
$Worksheet = $Workbook-Worksheets()-Add();
$Worksheet-{Name} = test $i;
...

The sheet names are still Sheet1, Sheet2, etc...

Thanks,
David

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

__
This e-mail has been scanned by MCI Managed Email Content Service, using 
Skeptic(tm) technology powered by MessageLabs. For more information on MCI's 
Managed Email Content Service, visit http://www.mci.com.
__

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Installl CPAN packages without ftp.

2005-08-04 Thread $Bill Luebkert
[EMAIL PROTECTED] wrote:

 Here is my small sftp test program.
 ==
 
 use strict;
 use warnings;
 
 use Net::SFTP;
 
 sub SendFileOverFTP {
 
   
  #my($file,$local)= @_; 
   
   my %args = (
   user = someuser,
   password = xxx,
   debug = true,
   ); 
   
   my %defaultArgs = (
   FTPServer = MyFtpSite,
   FTPRemoteDir = someDir);
   
   my $sftp = Net::SFTP-new($defaultArgs{FTPServer},%args); 
   
   my $openFtpDir =$sftp-do_open($defaultArgs{FTPRemoteDir});
   if ( !defined($openFtpDir) ) {
print failed to open the ftp directory\n;
   }
   
   my $local = someFile.txt; 
   my $remote = someFile.txt;
   
   my $ergebnis = $sftp-put($local,$remote); 
   
   if ( !defined($ergebnis) )
   {
   print error\n;
   }
 
   #$sftp-quit; 
   undef $sftp;
 }
 
 SendFileOverFTP;
 ===
 
 Any ideeas?

This works for me (you should check on Net/SSH/Perl/Util/SSH2MP.pm being 
installed) :

use strict;
use warnings;
use Net::SFTP;

my $server = 'MyFtpSite.com';
my $remdir = 'public_html';
my $remfile = 'some.txt';
my $locfile = 'txt/some.txt';

SendFileOverFTP ($server, $remdir, $remdir/$remfile, $locfile);
exit;

#- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

sub SendFileOverFTP {
my ($server, $remfile, $locfile) = @_;

my $user = 'someuser';
my $password = 'xxx';

my $sftp = Net::SFTP-new($server, user = $user, password = $password,
  port = 22, debug = 1) or die new SFTP: $! ($^E);
$sftp-put($locfile, $remfile) and die put $locfile, $remfile: $! ($^E);

}

__END__

-- 
  ,-/-  __  _  _ $Bill LuebkertMailto:[EMAIL PROTECTED]
 (_/   /  )// //   DBE CollectiblesMailto:[EMAIL PROTECTED]
  / ) /--  o // //  Castle of Medieval Myth  Magic http://www.todbe.com/
-/-' /___/__/_/_http://dbecoll.tripod.com/ (My Perl/Lakers stuff)
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Win32:OLE Excel

2005-08-04 Thread $Bill Luebkert
Hsu, David wrote:
 Hi,
 Does someone know of another method of naming the Excel sheets?
 Currently I am using:
 ...
 $Worksheet = $Workbook-Worksheets()-Add();
 $Worksheet-{Name} = test $i;
 ...
 
 The sheet names are still Sheet1, Sheet2, etc...

my $workbook = $Excel-Workbooks-Add();
my $worksheet = $workbook-Worksheets(1);
$worksheet-{Name} = First Sheet;

-- 
  ,-/-  __  _  _ $Bill LuebkertMailto:[EMAIL PROTECTED]
 (_/   /  )// //   DBE CollectiblesMailto:[EMAIL PROTECTED]
  / ) /--  o // //  Castle of Medieval Myth  Magic http://www.todbe.com/
-/-' /___/__/_/_http://dbecoll.tripod.com/ (My Perl/Lakers stuff)
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


RE: Win32:OLE Excel

2005-08-04 Thread Hsu, David
Ken,
I am using Win32::OLE.  Add_worksheet uses the Spreadsheet:WriteExcel
module.

Thanks,
David

-Original Message-
From: Ken Barker [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 04, 2005 12:07 PM
To: Hsu, David; Perl-Win32-Users@listserv.ActiveState.com
Subject: RE: Win32:OLE Excel

Try

$ws1 = $workbook-add_worksheet('worksheetname');



Ken Barker
IT Lead
Americall Group, Inc
314-213-7927
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Hsu, David
Sent: Thursday, August 04, 2005 10:23 AM
To: Perl-Win32-Users@listserv.ActiveState.com
Subject: Win32:OLE Excel


Hi,
Does someone know of another method of naming the Excel sheets?
Currently I am using:
...
$Worksheet = $Workbook-Worksheets()-Add();
$Worksheet-{Name} = test $i;
...

The sheet names are still Sheet1, Sheet2, etc...

Thanks,
David

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

__
This e-mail has been scanned by MCI Managed Email Content Service, using
Skeptic(tm) technology powered by MessageLabs. For more information on
MCI's Managed Email Content Service, visit http://www.mci.com.
__

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


RE: Win32:OLE Excel

2005-08-04 Thread dkazatsky

David,

I have a script with almost the exact same code and it works correctly.  Try removing the parens from your add statement and see if that makes a difference.

Original Code:
$Worksheet = $Workbook-Worksheets()-Add();
$Worksheet-{Name} = test $i;

Becomes: 
$Worksheet = $Workbook-Worksheets-Add;
$Worksheet-{Name} = test $i;

HTH.

Dave Kazatsky
Senior Middleware Engineer
W. (908) 575-6947
C. (973) 865-8106
Hsu, David [EMAIL PROTECTED]










Hsu, David [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/04/2005 01:17 PM




	
	To:	Ken Barker [EMAIL PROTECTED], Perl-Win32-Users@listserv.ActiveState.com
	cc:	
	Subject:	RE: Win32:OLE Excel




Ken,
I am using Win32::OLE.  Add_worksheet uses the Spreadsheet:WriteExcel
module.

Thanks,
David

-Original Message-
From: Ken Barker [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, August 04, 2005 12:07 PM
To: Hsu, David; Perl-Win32-Users@listserv.ActiveState.com
Subject: RE: Win32:OLE Excel

Try

$ws1 = $workbook-add_worksheet('worksheetname');



Ken Barker
IT Lead
Americall Group, Inc
314-213-7927
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
Hsu, David
Sent: Thursday, August 04, 2005 10:23 AM
To: Perl-Win32-Users@listserv.ActiveState.com
Subject: Win32:OLE Excel


Hi,
Does someone know of another method of naming the Excel sheets?
Currently I am using:
...
$Worksheet = $Workbook-Worksheets()-Add();
$Worksheet-{Name} = test $i;
...

The sheet names are still Sheet1, Sheet2, etc...

Thanks,
David

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

__
This e-mail has been scanned by MCI Managed Email Content Service, using
Skeptic(tm) technology powered by MessageLabs. For more information on
MCI's Managed Email Content Service, visit http://www.mci.com.
__

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs




The information contained in this message may be CONFIDENTIAL and is for the intended addressee only.  Any unauthorized use, dissemination of the information, or copying of this message is prohibited.  If you are not the intended addressee, please notify the sender immediately and delete this message.


___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


upgrading www::mechanize

2005-08-04 Thread Irmawaty Nugroh Nugroho
Hi monks, My current www::mechanize is version 0.72 because I installed it 
using ppm. I am wanting to upgrade it so I can use some function such as 
select, URI to do more stuff... How can I do this properly? 

I tried to use upgrade on ppm prompt, but it has taken minutes and still 
processing and has not shown me the available upgrades.

Please kindly advise me 



___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: HTML::GoogleMaps or Other Way to show multiple addresses on a

2005-08-04 Thread Suresh Govindachar
 $Bill Luebkert Sent on 04 Aug 2005 07:36:35 -0700:

  Suresh Govindachar wrote:
 
 One answer to the question I asked earlier: 
 
I would like to show multiple addresses on a map -- from
a user PC (rather than from a web-server).  I am
 
 Why not a webserver on your local PC ?  You can easily install
 Apache on your PC from Apache.org.

Thanks for the suggestion and mentioning (below) your experience
using GoogleMaps with it.  

I suspect that one can also write a perl script that acts as a
simple HTTP server and works with GoogleMaps -- but I don't know
where to start for coding and for seeing examples of such scripts.  
I would like to explore this before getting into Apache.  
Any suggestions?  

hoping to have a perl script read in a list of addresses
and generate a html page.  All the input addresses would
be within about 20 miles of each other; and each address
in the list would have a html link associated with it.
Viewing the html page generated by the perl script in a
browser should show a map with markers for each address
in the list.  Clicking on the marker should open a new
browser for the html link associated with that address.

Can the preceding be done?  Any suggestions?
   
 is WebServer::GoogleMaps.  
 
 To install on Windows, just end up with the file
 pathperl/site/libWebService/GoogleMaps.pm 
 Then change line 57 in GoogleMaps.pm from 
 $self-{gm_version} ||= .1;
 to 
 $self-{gm_version} ||= .3;
 (Preceding modification is from a post to CPAN::Forum 
 by Michael Burns on Sat Jun 18 20:38:18 2005.)
 Then run the two main examples and look at the resulting 
 images mymap.png and goodeats.png.
 
 I would consider using HTML::GoogleMaps instead and bring up the
 Google map interactive so you can pan and zoom direct from the
 Google site.  You can get a free key for your machine (I got one
 for 127.0.0.1 and used that on my PC).
 
Thanks,

--Suresh

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


amazon web services

2005-08-04 Thread bruce
hey...

hsa anybody ever used the amazon web services api regarding the
browsenodes???

ive checked cpan/looked at google/etc...

thanks

bruce

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: Installl CPAN packages without ftp.

2005-08-04 Thread Sisyphus

- Original Message - 
From: [EMAIL PROTECTED]


 Now, I said that it looks like it is running on my machine because when
 I packed it with pp and run the result on another machine it complains
 with the following error message:
 
 
 Can't locate Net/SSH/Perl/Util/SSH2MP.pm in @INC (@INC contains:
 CODE(0xcc384c) CODE(0xdbac7c) .) at
  C:/Perl/site/lib/Net/SSH/Perl/Util.pm line 56.

But I take it that both the script and the PAR executable run ok on your
machine ?

If so, then it looks like PAR is not packing the SSH2MP module. I'm not
really up to speed with PAR but I think there might be a pp command line
switch that enables you to specify additional modules to be packed in. Check
the PAR docs, or the PAR mailing list (see http://lists.perl.org/index.cgi )
if you don't get the answer here.

Cheers,
Rob

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: upgrading www::mechanize

2005-08-04 Thread Sisyphus

- Original Message - 
From: Irmawaty Nugroh Nugroho [EMAIL PROTECTED]
To: perl-win32-users@listserv.ActiveState.com
Sent: Friday, August 05, 2005 4:02 AM
Subject: upgrading www::mechanize


 Hi monks, My current www::mechanize is version 0.72 because I installed it
using ppm. I am wanting to upgrade it so I can use some function such as
select, URI to do more stuff... How can I do this properly?

 I tried to use upgrade on ppm prompt, but it has taken minutes and still
processing and has not shown me the available upgrades.

 Please kindly advise me


It's pure perl, so you could install from CPAN source (
http://search.cpan.org ) using nmake.

You can get nmake15.exe from either :
ftp://ftp.microsoft.com/Softlib/MSLFILES/nmake15.exe or :
http://download.microsoft.com/download/vc15/Patch/1.52/W95/EN-US/Nmake15.exe

Just run the downloaded executable to install nmake to the location of your
choice and make sure that location is in your system's path.

Then unpack the CPAN source tarball, cd to the folder that contains the
unpacked files and run 'perl Makefile.PL' and 'nmake test'. If you're happy
with the 'nmake test' results, run 'nmake install'. Looks like ActiveState
don't have a ppm of the latest WWW::Mechanize because one of the tests
failed or hanged. If the same happens for you, the choice is either to fix
the problem, or just install it anyway and hope that the problem  is not
going to affect the things that you want to do. (Sometimes test failures
arise from bugs in the test scripts, rather than bugs in the module being
tested.)

Cheers,
Rob

___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: HTML::GoogleMaps or Other Way to show multiple addresses on a

2005-08-04 Thread $Bill Luebkert
Suresh Govindachar wrote:

 Thanks for the suggestion and mentioning (below) your experience
 using GoogleMaps with it.  
 
 I suspect that one can also write a perl script that acts as a
 simple HTTP server and works with GoogleMaps -- but I don't know
 where to start for coding and for seeing examples of such scripts.  
 I would like to explore this before getting into Apache.  
 Any suggestions?  

Why not just do it with Javascript ?  If you have a webserver, you can
just code it in Javascript (that's all HTML::GoogleMaps does is change
your code to Javascript).  Here's a page that will start you off near
my house (I shifted it off a bit) and let you move wherever you want :

!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN 
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd;

HTML xmlns=http://www.w3.org/1999/xhtml;
  xmlns:v=urn:schemas-microsoft-com:vml

HEAD
script src=http://maps.google.com/maps?file=apiv=1key=KEY-GOES-HERE 
type=text/javascript/script
/HEAD

BODY

div id=map style=width: 900px; height: 600px/div
script type=text/javascript
//![CDATA[
//if (GBrowserIsCompatible()) {

  var map = new GMap(document.getElementById(map));
  map.centerAndZoom(new GPoint(-118.709012, 34.282444), 0);
  map.setMapType(G_HYBRID_TYPE);
  map.addControl(new GSmallMapControl());
  map.addControl(new GMapTypeControl());
  var marker_1 = new GMarker(new GPoint(-118.709812, 34.284244));
  map.addOverlay(marker_1);
  var point = new GPoint (-118.709812, 34.284244);
  var marker1 = new GMarker (point);
  // Show this marker's index in the info window when it is clicked
  //var html = My House - ;
  //GEvent.addListener (marker1, click, function (overlay, pos) {
  //  marker1.openInfoWindowHtml(html + pos.x + ,  + pos.y);
  //});
  map.addOverlay (marker1);

//}
//]]
/script

/BODY

/HTML

You have to get a key from Google http://www.google.com/apis/maps/signup.html
I just used 127.0.0.1 for my IP address.

The addListener part isn't working yet - just started playing with it (and
Javascript).

-- 
  ,-/-  __  _  _ $Bill LuebkertMailto:[EMAIL PROTECTED]
 (_/   /  )// //   DBE CollectiblesMailto:[EMAIL PROTECTED]
  / ) /--  o // //  Castle of Medieval Myth  Magic http://www.todbe.com/
-/-' /___/__/_/_http://dbecoll.tripod.com/ (My Perl/Lakers stuff)
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


Re: upgrading www::mechanize

2005-08-04 Thread Randy Kobes

On Fri, 5 Aug 2005, Sisyphus wrote:


It's pure perl, so you could install from CPAN source (
http://search.cpan.org ) using nmake.

You can get nmake15.exe from either :
ftp://ftp.microsoft.com/Softlib/MSLFILES/nmake15.exe or :
http://download.microsoft.com/download/vc15/Patch/1.52/W95/EN-US/Nmake15.exe

Just run the downloaded executable to install nmake to the 
location of your choice and make sure that location is in 
your system's path.


Then unpack the CPAN source tarball, cd to the folder that 
contains the unpacked files and run 'perl Makefile.PL' and 
'nmake test'. If you're happy with the 'nmake test' 
results, run 'nmake install'. Looks like ActiveState don't 
have a ppm of the latest WWW::Mechanize because one of the 
tests failed or hanged. If the same happens for you, the 
choice is either to fix the problem, or just install it 
anyway and hope that the problem is not going to affect 
the things that you want to do. (Sometimes test failures 
arise from bugs in the test scripts, rather than bugs in 
the module being tested.)


On my system, the tests that failed had to do with 
connecting to a live server; the failures may have been

due to changes in the content from the server that
the tests expect. All of the non-live tests passed.

Rob's advice about getting 'nmake' and subsequently 
installing pure Perl modules yourself is good, so that one 
doesn't run into delays like this. If desired, though, I put 
up a current WWW-Mechanize package in our repository at 
http://theoryx5.uwinnipeg.ca/ppms/.


--
best regards,
randy
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs