[SunRescue] perl programmer help needed

Bill Bradford rescue at sunhelp.org
Mon Apr 16 15:51:37 CDT 2001


On Mon, Apr 16, 2001 at 03:32:46PM -0500, Patrick Giagnocavo wrote:
> Hi Bill,
> To begin with,  I sure wouldn't implement it like this.
> Instead, I would stuff all the info into a database running PostgreSQL
> (www.postgresql.org) and then write a couple of scripts that queried the
> database.  This would make it easier, faster, and if a new report was needed
> you just have to write a new SQL query.
> That is, assuming that you have access or you care about the underlying raw
> data.

There's a method to my madness.  The end result has to be static HTML
(no CGIs, etc) because its going to be FTPed between 2-3 machines
(from an "inside" UNIX-based system, to an intermediary, out to a
machine sitting in the DMZ) with the end web server being an NT/IIS box.

> However to implement it given the situation you currently have...
> create a directory listing and read it in
>        (I assume you don't need to recurse directories)

Nope, everything is flat in the same directory.  I'll just re-run the
script for each customer.

> set the record separator to be "_" (will need to do some quoting) and split
> the filenames into a list or hash(s)
> read the hash(s) and write the HTML

This is basically what I'm working on, I'm just braindead right now, which
is why I asked for suggestions.

Thanks.

Bill

-- 
Bill Bradford
mrbill at mrbill.net
Austin, TX



More information about the rescue mailing list