Installl CPAN packages without ftp.
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.
[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.
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.
- 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.
-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.
-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.
- 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.
[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
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
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.
-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.
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
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
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.
[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
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
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
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
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
$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
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.
- 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
- 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
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
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