RE: Customer Notification System.

2012-02-23 Thread Vinny_Abello
Paraphrasing someone else I would encourage my competitors to send notifications to their customers in PDF format. :) -Vinny -Original Message- From: JC Dill [mailto:jcdill.li...@gmail.com] Sent: Thursday, February 23, 2012 1:44 PM To: NANOG list Subject: Re: Customer

Re: Customer Notification System.

2012-02-23 Thread JC Dill
On 22/02/12 6:46 PM, James Wininger wrote: Well we would not be sending the notification in an attachment, but there are times when it would be nice to send a list of circuit ids (exported from billing system as PDF) or some other exported doc to the notification. Nice for WHO? There is abso

Re: Customer Notification System.

2012-02-23 Thread Rich Kulawiec
On Wed, Feb 22, 2012 at 08:34:49AM -0800, JC Dill wrote: > 99.999% of the time there is absolutely no benefit in the > attachment. But by pushing customers to open attachments to get the > content we are encouraging them to be complacent about opening all > attachments, and that's a great way to e

Re: Customer Notification System.

2012-02-22 Thread James Wininger
Well we would not be sending the notification in an attachment, but there are times when it would be nice to send a list of circuit ids (exported from billing system as PDF) or some other exported doc to the notification. -- Jim Wininger Indiana Fiber Network Desk - 317-777-7114 Cell - 317-432

Re: Customer Notification System.

2012-02-22 Thread James Wininger
Well there isn't anything wrong with the mail list approach, but it is more complicated than sending email to a list of customers. We have several types of services (transport, ss7, managed Noc svc etc). Having the db backend would give us flexibility for future notifications based on type of s

Re: Customer Notification System.

2012-02-22 Thread acv
On Wed, Feb 22, 2012 at 08:34:49AM -0800, JC Dill wrote: > > 99.999% of the time there is absolutely no benefit in the attachment. > But by pushing customers to open attachments to get the content we are > encouraging them to be complacent about opening all attachments, and > that's a great wa

Re: Customer Notification System.

2012-02-22 Thread JC Dill
On 21/02/12 2:58 PM, James Wininger wrote: We would need to send notifications out to say about 400 customers. Ideally the system would send an attached PDF. Why are you sending an attachment? I hate it when businesses think that they will somehow improve my reading experience by bloating up

Re: Customer Notification System.

2012-02-22 Thread Daniel Rohan
On Feb 22, 2012 6:35 PM, "R. Scott Evans" 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 2

Re: Customer Notification System.

2012-02-22 Thread R. Scott Evans
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->exe

RE: Customer Notification System.

2012-02-22 Thread Leigh Porter
> -Original Message- > From: Rich Kulawiec [mailto:r...@gsp.org] > Sent: 22 February 2012 11:04 > To: nanog@nanog.org > Subject: Re: Customer Notification System. > > On Tue, Feb 21, 2012 at 05:58:19PM -0500, James Wininger wrote: > > We would need to send not

Re: Customer Notification System.

2012-02-22 Thread Rich Kulawiec
On Tue, Feb 21, 2012 at 05:58:19PM -0500, James Wininger wrote: > 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. (a) Use ASCII. Using PDF for this is insane. (b) You're de

Re: Customer Notification System.

2012-02-21 Thread Jay Ashworth
- Original Message - > From: "James Wininger" > 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

Re: Customer Notification System.

2012-02-21 Thread Adam Rothschild
On Tue, Feb 21, 2012 at 5:58 PM, James Wininger 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

Re: Customer Notification System.

2012-02-21 Thread Graham Beneke
On 22/02/2012 01:00, David wrote: PHPList? We've been using PHPlist for a while but have also been searching for something that can do a 'network noticeboard' type of thing. Haven't really come up with anything useful yet. -- Graham Beneke

Re: Customer Notification System.

2012-02-21 Thread Alex Leach
Billing software that caters to smaller web hosts and ISPs like WHMCS can send out mass mailings, and you can drill down which customers should receive the email based on the services they have with you. On Tue, Feb 21, 2012 at 4:58 PM, James Wininger wrote: > We are a smaller ISP in Indiana. W

Re: Customer Notification System.

2012-02-21 Thread Tom Pipes
Not sure if you have a customer database/spreadsheet and what OS platform you use, but this product has served us well in the past: http://www.massmailsoftware.com/bulkmail/ Tom Pipes tom.pi...@t6mail.com On Tue, Feb 21, 2012 at 4:58 PM, James Wininger wrote: > We are a smaller ISP in Indiana.

Re: Customer Notification System.

2012-02-21 Thread Dan White
We use Mailchimp to relay emails to our customers. They have the ability to maintain lists of customer addresses, and I believe they have an API for maintaining the list. On 02/21/12 17:58 -0500, James Wininger wrote: We are a smaller ISP in Indiana. We are growing quite rapidly (yeah for us). W

Re: Customer Notification System.

2012-02-21 Thread Brian Stengel
http://www.varolii.com/ On Tue, Feb 21, 2012 at 5:58 PM, James Wininger 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 ne

Re: Customer Notification System.

2012-02-21 Thread David
PHPList? On 02/21/2012 02:58 PM, James Wininger 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