<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4611.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm working on a project called jake (<A
href="http://jake-db.org/docs/about.php">http://jake-db.org/docs/about.php</A>),
and considering using RT as an 'update tracker', shifting its use slightly to
allow approval and update of database changes (for instance, if the publisher of
a particular journal decides to change its name). I'm wondering if anyone
has used RT to do this before, and if they could point me to some examples, or
share some tips. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Essentially, we want web users to
submit update requests (e.g. "Life Magazine" will now be called "Lives
Magazine"). The web update engine will generate an XML change object, and
create a ticket in the RT system (possibly using SOAP). Then RT
'Approvers' will be able to review the change tickets and approve them if
appropriate, triggering another action from the RT system to the database front
end software, which applies the XML chunk to update the entry to "Lives
Magazine".</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If anyone has any suggestions or leads, that would
help a great deal.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks much,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>David Sarno</FONT></DIV></BODY></HTML>