[Trac] Create ticket via email?

[Jim Cheetham]

On Thu, 2005-02-03 at 15:11 -0600, Richard Thomas wrote:
> The biggest problem I have had parsing incoming email ( I have a php 
> based parser that handles pretty much every format ) is the multiple 
> formats people use.
> 
> It gets even harder when your talking attachments.

Once I get the basic functionality working, I can look at other ways of
managing the original email. One easy option would be to archive
everything into a mailman list, and then ticket the
most-likely-to-be-human-text portions, plus a link to the mailman
archive.

Each organisation will probably vary :-) so all this functionality lies
outside a basic email-to-ticket wrapper.

At the moment, it looks like I should just take the
svn-post-commit-hook, and add functionality so that we can "open,
create, add" a ticket - something like 

{{{
            cur.execute("CREATE ticket SET changetime=%s", self.now)
	# How do I get the int(tkt) value back?
            cur.execute("INSERT INTO ticket_change (ticket, time,
author, field, oldvalue, newvalue) VALUES (%s, %s, %s, %s, %s, %s)",
                        int(tkt), self.now, self.author, 'comment', '',
self.msg)
}}}


-jim