Re: Customer Notification System.

["R. Scott Evans" <nanog () rsle net>]

What, no programmers in your NOC to roll your own?

---
#!/usr/bin/perl

use DBI;

# define variables ($sendmail, $from, $database... etc)

$dbh = DBI->connect("DBI:mysql:$database:$server", $user, $pass);
$mysearch = $dbh->prepare("SELECT customer,cid,email FROM $table WHERE
$find);
$mysearch->execute;

while (($customer,$cid,$email) = $mysearch->fetchrow_array) {
        open(MAIL, "| $sendmail -t");
        print MAIL "From: $from\n";
        print MAIL "To: $email\n";
        print MAIL "Subject: $subject\n\n";
        print MAIL "$customer,\nYour circuit $cid is going down bla bla bla.";
        close(MAIL);
}
$dbh->disconnect;
---

** NOTE - this is off the top of my head, ie.. not tested.  That said,
it's more or less a simplified version of what we do. 

-Scott

On Tue, 21 Feb 2012 17:58:19 -0500, "James Wininger"
<jwininger () ifncom net> wrote:
> We are a smaller ISP in Indiana. We are growing quite rapidly (yeah for
> us). We have a need for a customer notification system. We have simply
> out grown the ability to send emails to our customers manually. We need
> to have a better way of notifying our customers of maintenance etc.
>
> We would need to send notifications out to say about 400 customers.
> Ideally the system would send an attached PDF. It would be great if this
> system were SQL based etc.
>
> Does anyone know of a system that is out there that does this? We have
> looked at a few applications (windows based) but integration with
> billing etc seems to be a caveat. I have thought of possibly using a
> mailing list type approach, but that gets us back to (almost) where we
> are today. Any pointers would be greatly appreciated. 
>
> --
> Jim Wininger
> jwininger () ifncom net