Stephen C. Nill wrote:
> [Posted to LSTSRV-L and LSTOWN-L.]
>
> Colleagues,
>
> I have a need to easily obtain all subscribers for all lists, without
> duplicated addresses (such as where a given subscriber is subscribed to two
> or more lists). The end result needs to be a single listing of email
> addresses and, optionally, corresponding names, without duplicates,
> representing all subscribers of all lists.
>
> Problem: With 150+ lists, it is inconvenient and time-consuming to issue
> the typical REVIEW command for each list, and then merge and purge to
> delete duplicates.
>
> Having read all the manuals and scanned the archives, and having posted
> this question some weeks ago, I am fairly well convinced that there is no
> ready means to accomplish this task. For example, for security reasons, as
> I recall, LISTSERV does not have a command to do what I want.
>
> I do plan to implement DBMS and utilize MS SQL 2000 Server as the
> datastore. Indeed, I have set up a test list that accomplishes
> this. However, given the demands on my time, it will likely be several
> weeks or months before I can migrate all existing lists to SQL 2000. At
> that point I will have a number of options for pulling data out of the
> database -- problem solved. Until then, though, I find myself spending
> considerable time getting the simple end-result I need: a single listing
> of subscriber email addresses for all lists, without duplicates.
>
> Anything I'm not considering? Is there some simple thing I'm missing?
I guess if I needed to do that I'd just write a shell script that did a
LIST command to get all the listnames, then have it do "review all" for
all of them, then have it clean it up and dedupe it.
Regards,
Al Iverson
--
Al Iverson -- http://www.radparker.com -- Minneapolis, Minnesota, USA
Support Minnesota Jazz -- Disclaimer: All of my opinions are mine alone.
|