use Perl

• any chance... (Score:2, Insightful)

  by jdavidboyd (3251)

  Any chance of seeing this perl code?
  I could learn a great amount from it, I'm sure...
  • Re:any chance... (Score:3, Insightful)

    by gnat (29)

    Sure! I suppose I should have done more hackery to automatically determine the credentials() arguments from the URL, but I couldn't be buggered :-)

    #!/usr/bin/perl -w
    
    use LWP;
    use HTML::TableContentParser;
    use Getopt::Std;
    use strict;
    
    # username and password for ORA intranet
    my ($USERNAME, $PASSWORD) = ('CHANGE', 'ME');
    
    # where to store files.  change this!
    my $DIR = ($^O eq "darwin") ? '/Users/gnat/Ora/Paperwork/edcal'
                           
• Recipe? (Score:2, Insightful)

  by dlc (50)

  This would make a nice Cookbook recipe...

  --
  (darren)
  • Re:Recipe? (Score:2)

    by gnat (29)

    D'oh, good point. I can't believe I didn't think of that. Thanks, applied. :-)

    --Nat
    • Re:Recipe? (Score:1)

      by prakash (2793)

      There's another module HTML::TableExtract to parse HTML tables. I have used this, and it is pretty nice. I haven't looked at HTML::TableContentParser, so can't really compare, yet.

      Also, look at WWW::Mechanize, which is really awesome for scraping web content. There is WWW::Mechanize::Shell, for writing quick scripts to this kinda stuff.

      Just some more info for you to chew on while you write that cookbook entry.

      /prakash
      • Re:Recipe? (Score:2)

        by gnat (29)

        I spent a long time looking for data with column headings for HTML::TableExtract to work on. I finally found some census data [census.gov], but after half an hour of trying, I couldn't make H::TE grok the nested table headings. I finally gave up and just documented HTML::TableContentParser. Sorry!

        --Nat
• Excel to XML (Score:3, Insightful)

  by darobin (1316) on 2003.04.29 10:41 (#19573) Homepage Journal

  If the Excel is usable, then you might want to try XML::SAXDriver::Excel at some point (or for a similar problem involving surviving in an office with M$ users).

  --
  

  -- Robin Berjon [berjon.com]

  Reply to This