"Generic" mailing list tool

Hi all,

I'm looking for a very specific mailing tool and I hope that someone
can help me.

I work for a company with many many department spread in many many
building. The information about who is in which departement and in
which building is already stored in a database.

I need a mailing tool that will allow us to have a mailing list for
each departement in each building, using a pre-defined syntax. For
example, sending an email to b123d456@mailinglist.mycompany.com would
send an email to all members of department 456 in building 123.

However, there are so many departments that are created and deleted
each month, I would like to find a tool that will automatically parse
the address "b123d456" and retreive the recipient list from the
database. In other word, I want to define 1 generic rule that will
define all mailing lists.

Anybody knows if a tool like that already exist? Or is there an Open
Source software that I could use to build this tool from?

Thanks a lot for any help!

Re: "Generic" mailing list tool

In news:df3a8299-86ab-493c-b51d-71b880af5f0b@i3g2000hsf.googleg roups.com,
twiggy182 typed:

> ... The information about who is in which departement and in
> which building is already stored in a database.
>
> I need a mailing tool that will allow us to have a mailing list
> for each departement in each building, using a pre-defined
> syntax. For example, sending an email to
> b123d456@mailinglist.mycompany.com would send an email
> to all members of department 456 in building 123.
....
> Anybody knows if a tool like that already exist? Or is there an Open
> Source software that I could use to build this tool from?

It's called a "shell script", which you write to extract the database info
and construct the aliases file from it. It can run from cron or be invoked
from whatever tool you use to populate the database with revised info.

Re: "Generic" mailing list tool

On 1 f=E9v, 11:43, "Greg Rusel" wrote:
> Innews:df3a8299-86ab-493c-b51d-71b880af5f0b@i3g2000hsf.googl egroups.com,tw=
iggy182 typed:
>
>
>
> > ... The information about who is in which departement and in
> > which building is already stored in a database.
>
> > I need a mailing tool that will allow us to have a mailing list
> > for each departement in each building, using a pre-defined
> > syntax. For example, sending an email to
> > b123d...@mailinglist.mycompany.com would send an email
> > to all members of department 456 in building 123.
> ...
> > Anybody knows if a tool like that already exist? Or is there an Open
> > Source software that I could use to build this tool from?
>
> It's called a "shell script", which you write to extract the database info=

> and construct the aliases file from it. It can run from cron or be invoked=

> from whatever tool you use to populate the database with revised info.

Hi,

I was thinking more of a system like Sympa or Mailman. The problem
with these 2 systems is that you need to define all your lists
explicitely.

If I understand your solution correctly, you mean to create all my
lists with a script by finding all the valid department and building
matches, is that it?

Thanks,

Re: "Generic"mailing list tool

This is a MIME GnuPG-signed message. If you see this text, it means that
your E-mail or Usenet software does not support MIME signed messages.
The Internet standard for MIME PGP messages, RFC 2015, was published in 1996.
To open this message correctly you will need to install E-mail or Usenet
software that supports modern Internet standards.

--=_mimegpg-commodore.email-scan.com-533-1201904609-0001
Content-Type: text/plain; format=flowed; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

twiggy182 writes:

> On 1 fév, 11:43, "Greg Rusel" wrote:
>> Innews:df3a8299-86ab-493c-b51d-71b880af5f0b@i3g2000hsf.googl egroups.co=
m,twiggy182 typed:
>>
>>
>>
>> > ... The information about who is in which departement and in
>> > which building is already stored in a database.
>>
>> > I need a mailing tool that will allow us to have a mailing list
>> > for each departement in each building, using a pre-defined
>> > syntax. For example, sending an email to
>> > b123d...@mailinglist.mycompany.com would send an email
>> > to all members of department 456 in building 123.
>> ...
>> > Anybody knows if a tool like that already exist? Or is there an Open
>> > Source software that I could use to build this tool from?
>>
>> It's called a "shell script", which you write to extract the database =
info
>> and construct the aliases file from it. It can run from cron or be inv=
oked
>> from whatever tool you use to populate the database with revised info.
>=20
> Hi,
>=20
> I was thinking more of a system like Sympa or Mailman. The problem
> with these 2 systems is that you need to define all your lists
> explicitely.

The chances of those "systems" that you are referring to, which is free,=20
generic software, of somehow understanding the unique, specific schema of=20
your organization's internal database, and automatically knowing what to =
do=20
with it, and how it needs to be done, is slim to none.

> If I understand your solution correctly, you mean to create all my
> lists with a script by finding all the valid department and building
> matches, is that it?

Correct. This is rather a simple task that any qualified programmer shoul=
d=20
be able to get up and running in less amount of time that it took you to=20
post your question, and receive an answer.


--=_mimegpg-commodore.email-scan.com-533-1201904609-0001
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQBHo5vhx9p3GYHlUOIRAvZrAJsG+sMxwV2ZHA6UcRR7huPmeRZe6ACd ElpD
XuVuIOt7LCrSO6dt1D9K1v4=
=+UlJ
-----END PGP SIGNATURE-----

--=_mimegpg-commodore.email-scan.com-533-1201904609-0001--