nanog mailing list archives
Re: Customer Notification System.
From: "R. Scott Evans" <nanog () rsle net>
Date: Wed, 22 Feb 2012 10:34:32 -0500
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
Current thread:
- Re: Customer Notification System., (continued)
- Re: Customer Notification System. David (Feb 21)
- Re: Customer Notification System. Graham Beneke (Feb 21)
- Re: Customer Notification System. Brian Stengel (Feb 21)
- Re: Customer Notification System. Dan White (Feb 21)
- Re: Customer Notification System. Alex Leach (Feb 21)
- Re: Customer Notification System. Adam Rothschild (Feb 21)
- Re: Customer Notification System. Jay Ashworth (Feb 21)
- Re: Customer Notification System. Rich Kulawiec (Feb 22)
- RE: Customer Notification System. Leigh Porter (Feb 22)
- Re: Customer Notification System. James Wininger (Feb 22)
- Re: Customer Notification System. R. Scott Evans (Feb 22)
- Re: Customer Notification System. Daniel Rohan (Feb 22)
- Re: Customer Notification System. JC Dill (Feb 22)
- Re: Customer Notification System. acv (Feb 22)
- Re: Customer Notification System. James Wininger (Feb 22)
- Re: Customer Notification System. JC Dill (Feb 23)
- RE: Customer Notification System. Vinny_Abello (Feb 23)
- Re: Customer Notification System. Rich Kulawiec (Feb 23)
- Re: Customer Notification System. David (Feb 21)
- Re: Customer Notification System. Tom Pipes (Feb 21)