You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Jarnot Voytek Contr AU HQ/SC <Vo...@MAXWELL.AF.MIL> on 2003/02/12 20:31:12 UTC
[OT] RE: a product or code to read email and update database
Please prefix off topic topics with [OT].
Are you looking to have your users receive email attachments, and then
upload them to the app server? Or are you talking about your server-side
java code polling a mail server periodically and retrieving messages?
--
Voytek Jarnot
Quidquid latine dictum sit, altum viditur.
> -----Original Message-----
> From: Ashish Kulkarni [mailto:kulkarni_ash1312@yahoo.com]
> Sent: Wednesday, February 12, 2003 1:24 PM
> To: struts-user@jakarta.apache.org
> Subject: a product or code to read email and update database
>
>
> Hi,
>
> In my project i have a requirement to read the data
> coming in from email ( outlook ) and update the
> database in real time
> Has any one worked with this kind of requirement,
> Any help about different products or code willl be
> helpful, the data coming in email may be xml or pdf,
> or plain text which is not yet decided
>
> Ashish
>
> =====
> A$HI$H
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Shopping - Send Flowers for Valentine's Day
> http://shopping.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: [OT] RE: a product or code to read email and update database
Posted by Michael Hanisch <mh...@redhat.com>.
On Wed, 2003-02-12 at 21:06, Ashish Kulkarni wrote:
> What u have to do is a automatic approval process,
>
> A user will be sending a mail to his boss for some
> approval, and then the boss will reply with a message
> , which will be approved or not aproved,
> I want to update the database depending on the reply i
> get from the mail from boss
If you don't insist on an "email-only" solution, probably the easiest
way to deal with the "automatic approval process" would be to send an
email to the "boss" which contains just two URLs of your application -
one to approve, and one which can be used to reject (whatever).
You could generate one-off tokens (JCE is your friend) to make sure that
the "boss" can approve/reject the same message only once, and that
no-one else can do so. Easy enough to implement, and very easy for the
boss, since one click is sufficient (no need to write an email).
If you want to receive/process the answer in the form of an email, you
should check the JavaMail API, which makes this sort of thing reasonably
easy.
In any case you have to check for a number of potential problems, like
- authorization (use secret tokens in the original email, which have to
be present in the reply)
- tracking which reply corresponds to which "request for approval"
- handling errors (first email bounces, reply email cannot be parsed
etc.) You will encounter more problems using the "email-only" solution
since messages might be garbled, mail clients might do interesting
things to the replies etc.
Hope this gives you some ideas...
Michael.
--
Michael Hanisch mhanisch@redhat.com
Red Hat - RH Interchange Inc., Orleansstrasse 4, D-81669 Munich/Germany
phone: +49 (0)89 206058-53 fax: +49 (0)89 206058-88
RE: [OT] RE: a product or code to read email and update database
Posted by Jacob Hookom <ho...@uwec.edu>.
You are probably better off doing something web based so stuff gets uploaded
to a server and the boss logs in to approve. It would save A LOT of
platform problems with different email clients putting junk in the mail
message and then making the message unparsable.
-Jacob
| -----Original Message-----
| From: Ashish Kulkarni [mailto:kulkarni_ash1312@yahoo.com]
| Sent: Wednesday, February 12, 2003 2:06 PM
| To: Struts Users Mailing List
| Subject: Re: [OT] RE: a product or code to read email and update database
|
| What u have to do is a automatic approval process,
|
| A user will be sending a mail to his boss for some
| approval, and then the boss will reply with a message
| , which will be approved or not aproved,
| I want to update the database depending on the reply i
| get from the mail from boss
|
| Ashish
| --- Jarnot Voytek Contr AU HQ/SC
| <Vo...@MAXWELL.AF.MIL> wrote:
| > Please prefix off topic topics with [OT].
| >
| > Are you looking to have your users receive email
| > attachments, and then
| > upload them to the app server? Or are you talking
| > about your server-side
| > java code polling a mail server periodically and
| > retrieving messages?
| >
| > --
| > Voytek Jarnot
| > Quidquid latine dictum sit, altum viditur.
| >
| >
| > > -----Original Message-----
| > > From: Ashish Kulkarni
| > [mailto:kulkarni_ash1312@yahoo.com]
| > > Sent: Wednesday, February 12, 2003 1:24 PM
| > > To: struts-user@jakarta.apache.org
| > > Subject: a product or code to read email and
| > update database
| > >
| > >
| > > Hi,
| > >
| > > In my project i have a requirement to read the
| > data
| > > coming in from email ( outlook ) and update the
| > > database in real time
| > > Has any one worked with this kind of requirement,
| > > Any help about different products or code willl be
| > > helpful, the data coming in email may be xml or
| > pdf,
| > > or plain text which is not yet decided
| > >
| > > Ashish
| > >
| > > =====
| > > A$HI$H
| > >
| > > __________________________________________________
| > > Do you Yahoo!?
| > > Yahoo! Shopping - Send Flowers for Valentine's Day
| > > http://shopping.yahoo.com
| > >
| > >
| >
| ---------------------------------------------------------------------
| > > To unsubscribe, e-mail:
| > struts-user-unsubscribe@jakarta.apache.org
| > > For additional commands, e-mail:
| > struts-user-help@jakarta.apache.org
| > >
| >
| >
| ---------------------------------------------------------------------
| > To unsubscribe, e-mail:
| > struts-user-unsubscribe@jakarta.apache.org
| > For additional commands, e-mail:
| > struts-user-help@jakarta.apache.org
| >
|
|
| =====
| A$HI$H
|
| __________________________________________________
| Do you Yahoo!?
| Yahoo! Shopping - Send Flowers for Valentine's Day
| http://shopping.yahoo.com
|
| ---------------------------------------------------------------------
| To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
| For additional commands, e-mail: struts-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org
Re: [OT] RE: a product or code to read email and update database
Posted by Ashish Kulkarni <ku...@yahoo.com>.
What u have to do is a automatic approval process,
A user will be sending a mail to his boss for some
approval, and then the boss will reply with a message
, which will be approved or not aproved,
I want to update the database depending on the reply i
get from the mail from boss
Ashish
--- Jarnot Voytek Contr AU HQ/SC
<Vo...@MAXWELL.AF.MIL> wrote:
> Please prefix off topic topics with [OT].
>
> Are you looking to have your users receive email
> attachments, and then
> upload them to the app server? Or are you talking
> about your server-side
> java code polling a mail server periodically and
> retrieving messages?
>
> --
> Voytek Jarnot
> Quidquid latine dictum sit, altum viditur.
>
>
> > -----Original Message-----
> > From: Ashish Kulkarni
> [mailto:kulkarni_ash1312@yahoo.com]
> > Sent: Wednesday, February 12, 2003 1:24 PM
> > To: struts-user@jakarta.apache.org
> > Subject: a product or code to read email and
> update database
> >
> >
> > Hi,
> >
> > In my project i have a requirement to read the
> data
> > coming in from email ( outlook ) and update the
> > database in real time
> > Has any one worked with this kind of requirement,
> > Any help about different products or code willl be
> > helpful, the data coming in email may be xml or
> pdf,
> > or plain text which is not yet decided
> >
> > Ashish
> >
> > =====
> > A$HI$H
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Shopping - Send Flowers for Valentine's Day
> > http://shopping.yahoo.com
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> struts-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> struts-user-help@jakarta.apache.org
> >
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> struts-user-help@jakarta.apache.org
>
=====
A$HI$H
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org