Tom, Ari... thanks. Tom, the site has a rudimentary CMS but most of the email addresses come from sources other than the website.... class registrations, ecommerce, on-site signups etc. The daunting task is consolidating all of these and eliminating duplicates. Ari, I'll look into RE further... after your comment, I've re-thought about reinventing the wheel all over again (as a former boss always put it). I'd like to have richer info, but mostly we just have name & email address for the majority of existing records. Thanks to all, have a great New Year. Patrick
mcn-l-request at mcn.edu wrote: Send mcn-l mailing list submissions to mcn-l at mcn.edu To subscribe or unsubscribe via the World Wide Web, visit http://toronto.mediatrope.com/mailman/listinfo/mcn-l or, via email, send a message with subject or body 'help' to mcn-l-request at mcn.edu You can reach the person managing the list at mcn-l-owner at mcn.edu When replying, please edit your Subject line so it is more specific than "Re: Contents of mcn-l digest..." Today's Topics: 1. collecting, consolidating and managing email addresses from patrons (Patrick) 2. Re: collecting, consolidating and managing email addresses from patrons (Tom) 3. Re: collecting, consolidating and managing email addresses from patrons (Ari Davidow) ---------------------------------------------------------------------- Message: 1 Date: Fri, 29 Dec 2006 08:57:43 -0800 (PST) From: Patrick Subject: [MCN-L] collecting, consolidating and managing email addresses from patrons To: mcn-l at mcn.edu Message-ID: <79040.36081.qm at web36203.mail.mud.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Hi folks, I've been tasked with putting together a plan for collecting, consolidating and managing email addresses from our patrons. We've implemented the more obvious collection points- web site, newsletter subscriptions, membership applications, e-commerce, etc.- but the challenge now is sorting through all these various email sources located in different places, matching them to existing email addresses, eliminating duplicates, cleaning the data, etc. We use parts of Raisers Edge to manage membership data but it sounds like overkill for this. I need to consolidate the various email address repositories, verify the data, eliminate any duplicates already in our membership database, and provide a means for editing/updating. Does anyone have any wisdom to share on this? Thanks in advance, and happy new year to all. Patrick Clancy Director of Information Technology The New York Botanical Garden __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------ Message: 2 Date: Fri, 29 Dec 2006 09:31:19 -0800 From: Tom Subject: Re: [MCN-L] collecting, consolidating and managing email addresses from patrons To: Museum Computer Network Listserv Message-ID: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Hi Patrick, Is your site based on a CMS or is it put together via various scripts tied into HTML pages? On Dec 29, 2006, at 8:57 AM, Patrick wrote: > Hi folks, > > I've been tasked with putting together a plan for collecting, > consolidating and managing email addresses from our patrons. We've > implemented the more obvious collection points- web site, > newsletter subscriptions, membership applications, e-commerce, > etc.- but the challenge now is sorting through all these various > email sources located in different places, matching them to > existing email addresses, eliminating duplicates, cleaning the > data, etc. > > We use parts of Raisers Edge to manage membership data but it > sounds like overkill for this. I need to consolidate the various > email address repositories, verify the data, eliminate any > duplicates already in our membership database, and provide a means > for editing/updating. Does anyone have any wisdom to share on this? > > Thanks in advance, and happy new year to all. > > Patrick Clancy > Director of Information Technology > The New York Botanical Garden > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > You are currently subscribed to mcn-l, the listserv of the Museum > Computer Network (http://www.mcn.edu) > > To post to this list, send messages to: mcn-l at mcn.edu > > To unsubscribe or change mcn-l delivery options visit: > http://toronto.mediatrope.com/mailman/listinfo/mcn-l > ------------------------------ Message: 3 Date: Fri, 29 Dec 2006 13:04:50 -0500 From: "Ari Davidow" Subject: Re: [MCN-L] collecting, consolidating and managing email addresses from patrons To: "Museum Computer Network Listserv" Message-ID: <747cfaf50612291004w20269b0bqd4bfa344e6093f2b at mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed It is very rare that you just want email addresses devoid of other context. I would suggest that using Raisers Edge is an excellent idea--maintaining the email addresses in context with any other information about the subscribers. The overhead of having subscribers about whom you know nothing (or little) beyond email address, or who have little or no connection to your development efforts is minor compared to having one place where email addresses and subscriptions are kept up to date, and where synergies with other organizational data can occur. Exporting a periodic email address report from Raisers Edge would not be nearly as much a bother as trying to integrate data the other way. I am speaking from intent, not from experience, however, so other folks may be able to present better experiential data, for or against. Our organization is in the process of moving to a single system after experiencing the joys of maintaining mailing lists in one system, volunteers in a second, development in a third, etc. ari On 12/29/06, Patrick wrote: > > Hi folks, > > I've been tasked with putting together a plan for collecting, > consolidating and managing email addresses from our patrons. We've > implemented the more obvious collection points- web site, newsletter > subscriptions, membership applications, e-commerce, etc.- but the challenge > now is sorting through all these various email sources located in different > places, matching them to existing email addresses, eliminating duplicates, > cleaning the data, etc. > > We use parts of Raisers Edge to manage membership data but it sounds > like overkill for this. I need to consolidate the various email address > repositories, verify the data, eliminate any duplicates already in our > membership database, and provide a means for editing/updating. Does anyone > have any wisdom to share on this? > > Thanks in advance, and happy new year to all. > > Patrick Clancy > Director of Information Technology > The New York Botanical Garden > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > You are currently subscribed to mcn-l, the listserv of the Museum Computer > Network (http://www.mcn.edu) > > To post to this list, send messages to: mcn-l at mcn.edu > > To unsubscribe or change mcn-l delivery options visit: > http://toronto.mediatrope.com/mailman/listinfo/mcn-l > ------------------------------ _______________________________________________ mcn-l mailing list mcn-l at mcn.edu http://toronto.mediatrope.com/mailman/listinfo/mcn-l End of mcn-l Digest, Vol 14, Issue 2 ************************************ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com