Hello. Still sometime I'm desperately searching for some community of developers which is dealing with the parsing of incoming email and storing its structure in the database.
Quoting Mail2db developers:
Different from traditional mail archive, the Mail2db engine can convert email into real database records stored within a RDMB architecture database.
Here is the list of some language specific implementation of IMAP labrary which is used as a main tool in the development of such interfaces
- PHP: http://php.net/manual/en/book.imap.php
- PYTHON: http://docs.python.org/library/imaplib.html
- PERL: http://search.cpan.org/~kjohnson/NetxAP-0.02/Net/IMAP.pm
- C++: http://www.example-code.com/vcpp/imap.asp
But even having these libraries the main problem still persists! That is to parse the email correctly into database.
Because, generally for parsing an email into database you need to do much more than it is done by the default classes. In a sense need to validate the email structure, to distinguish correctly the destinations, attachments, inline parts and to process the body of some parts with respect to the correct encoding.
In internet you may find some commercial (so automatically no applicable to opensource) and homemade solutions of the problem:
Any ideas, links, discussions or books about the topic are very welcome!
Here you may find some homemade database structure which works fine for the most cases, but is still very limited.