Re: Customer Notification System.

[Daniel Rohan <drohan () gmail com>]

On Feb 22, 2012 6:35 PM, "R. Scott Evans" <nanog () rsle net> wrote:

> ** 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.

whoa. best humble brag I've seen in a few weeks, Scott. And that's saying a
lot considering this is NANOG.
 On Feb 22, 2012 6:35 PM, "R. Scott Evans" <nanog () rsle net> wrote:

> 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