Subject: The mailing list for listmasters using Sympa
List archive
- From: Fil <address@concealed>
- To: Sympa-Users <address@concealed>
- Subject: cleaning old bouncers
- Date: Thu, 27 Mar 2003 17:53:18 +0100
Hello,
I've just realized that, if I want to celan up my subscribers' list from old
bounces, I just have to check the bounce_subscriber field and lit all users
that have quite many bounces registered with specific boucning codes.
for example :
mysql> select bounce_subscriber from subscriber_table LIMIT 0,100;
+--------------------------------+
| bounce_subscriber |
+--------------------------------+
| 1014137675 1014137675 1 5.0.0 |
| 1028312546 1048200137 18 5.0.0 |
| 1020102361 1048188420 24 |
| NULL |
| 1004445499 1048178458 36 5.1.1 |
| 1016025113 1016025113 1 4.0.0 |
| 1004447676 1037830421 55 |
| 1037135291 1048175076 11 5.0.0 |
| NULL |
.../...
What would you suppress?
This one is fine (1 hit, a long time ago):
| 1016025113 1016025113 1 4.0.0 |
This one is ugly (36 bounces coded 5.1.1):
| 1004445499 1048178458 36 5.1.1 |
I think I'm going to write a statistics and cleaning script. Any help will
be appreciated.
-- Fil
-
cleaning old bouncers,
Fil, 03/27/2003
-
Re: [sympa-users] cleaning old bouncers,
Fil, 03/27/2003
-
Re: [sympa-users] cleaning old bouncers,
Fil, 03/28/2003
-
Re: [sympa-users] cleaning old bouncers,
Olivier Salaun - CRU, 03/31/2003
- Re: [sympa-users] cleaning old bouncers, Fil, 03/31/2003
-
Re: [sympa-users] cleaning old bouncers,
Olivier Salaun - CRU, 03/31/2003
-
Re: [sympa-users] cleaning old bouncers,
Fil, 03/28/2003
-
Re: [sympa-users] cleaning old bouncers,
Fil, 03/27/2003
Archive powered by MHonArc 2.6.19+.