[thelist] Put emails into database (ASP)

[Matt Warden]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kevin Stevens wrote:
> Ah, sorry, I have not explained myself properly. This is an on-going
> project and what I need is, when an e-mail is sent it goes out to
> everyone on the list and into the database. Sort of how I imagine the
> evolt archives work, but with a different front end.

Well, this is what I believe Joshua was asking. For example, for a
mailman-managed list like this one, archives can be produced by
parsing the mbox file of all the emails that have been sent to this
list. This is how I believe Dean Mah's tip harvester works
(http://lists.evolt.org/harvest/).

So, unless you are setting it up such that every email sent to the
list has to be sent via a web form, you are probably going to have to
parse some 'inbox' file. So, if your list is mylist at foo.com, then you
would need to parse the inbox for mylist at foo.com in some manner (your
script could access it via POP). Then you can either insert these
emails into a typical relational database or generate HTML versions of
the emails and add them to the filesystem (the latter is what it seems
mailman does).

- --
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFC4+8kAQ0d4HGyPE8RAnIlAJ9ERM4J7SFCM80S0RklBl8LEt1uGACfY+ly
hhCu2Ys5z3y2r+W1XV8dHzw=
=x9QW
-----END PGP SIGNATURE-----