The mailing list for listmasters using Sympa

[Jérôme Zittoun <address@concealed>]

Hello,

If changes don't occur very frequently, another way is possible by sending
owners commands to Sympa.

When an user removes himself in your DB/software, you can send "DELETE 
listname
user@host" with list-owner as FROM.

More details on http://www.sympa.org/wiki/manual/sympa-commands#owner_commands

The biggest issue (in my opinion) with Sympa is that email is always part of 
the
primary key, so when one wants to change it, he change primary keys (and 
there's
no cascading) :-S

Jérôme
--
Jérôme Zittoun
Erigne Informatique / DZ2
http://www.erigne.com
________________________________

        De : Olivier Salaün - CRU [mailto:address@concealed] 
        Envoyé : vendredi 27 avril 2007 17:10
        À : Tim Koop
        Cc : address@concealed; Chris Andrews
        Objet : [sympa-users] Re: Re: Re: How to unsubscribe people from a 
list
from the command line
        
        
        Generaly speaking, directly editing the database is not a good idea
because the database format might change and your code would either not work
anymore or introduce corrupted data into Sympa's backend. That's the reason 
why
we developed a SOAP server in Sympa, to allow external programs to request 
Sympa
services in a secured way.
        
        In your situation though, removing subscriber_table entries sounds 
less
risked than adding new entries because you don't need to know about the exact
format of the DB entries.
        
        Tim Koop wrote: 

                Thanks Chris and Olivier.
                
                If the command line is not an option, I don't mind poking into
Sympa's database myself.  Can somebody confirm that a simple delete of a 
record
in subscriber_table would do the trick, even while Sympa is in the middle of a
mailing?
                

        
<http://www.sympa.org/wiki/manual/soap#sympa_soap_server>
Tim Koop wrote:

                        > Is there some way to unsubscribe an email address 
from
a mailing list

                        > from the command-line?  I've looked in the
documentation, but I can't

                        > find anything anywhere.

                        > 

                        > We sometimes have people in our own database who
change their email

                        > addresses, so we need to automatically reflect that
change in Sympa

                        > too.  I can't find a command-line command to change
someone's email

                        > address.  The other way to do it would be to
unsubscribe the old

                        > address and add the new one.

                        > 

                        > Is this possible at all?  What are we to do?