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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > > Sent: Wednesday, February 12, 2003 1:24 PM > > To: [EMAIL PROTECTED] > > 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: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > - > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > = A$HI$H __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] RE: a product or code to read email and update database
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 [EMAIL PROTECTED] Red Hat - RH Interchange Inc., Orleansstrasse 4, D-81669 Munich/Germany phone: +49 (0)89 206058-53 fax: +49 (0)89 206058-88 signature.asc Description: This is a digitally signed message part
RE: [OT] RE: a product or code to read email and update database
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:[EMAIL PROTECTED]] | 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 | <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] | > > Sent: Wednesday, February 12, 2003 1:24 PM | > > To: [EMAIL PROTECTED] | > > 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: | > [EMAIL PROTECTED] | > > For additional commands, e-mail: | > [EMAIL PROTECTED] | > > | > | > | - | > To unsubscribe, e-mail: | > [EMAIL PROTECTED] | > For additional commands, e-mail: | > [EMAIL PROTECTED] | > | | | = | A$HI$H | | __ | Do you Yahoo!? | Yahoo! Shopping - Send Flowers for Valentine's Day | http://shopping.yahoo.com | | - | To unsubscribe, e-mail: [EMAIL PROTECTED] | For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] RE: a product or code to read email and update database
I have worked on something like that before.. We had 1)Poller which periodically checked the POP server (to get mail) (it did not delete the mail from the server) 2)Checked for the email "subject" ,if it matched the one we were looking for, then opened it. 3)Did some processing (using String parsers ..gets a specific text) and sent a mail back to the sendor... But that was 4 years ago ! , I am sure as Jacob said you are better off doing something web-based since there are many points of failure in the above Cheers, Naggi -Original Message- From: Jacob Hookom [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 3:51 PM To: 'Struts Users Mailing List' Subject: RE: [OT] RE: a product or code to read email and update database 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:[EMAIL PROTECTED]] | 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 | <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] | > > Sent: Wednesday, February 12, 2003 1:24 PM | > > To: [EMAIL PROTECTED] | > > 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: | > [EMAIL PROTECTED] | > > For additional commands, e-mail: | > [EMAIL PROTECTED] | > > | > | > | - | > To unsubscribe, e-mail: | > [EMAIL PROTECTED] | > For additional commands, e-mail: | > [EMAIL PROTECTED] | > | | | = | A$HI$H | | __ | Do you Yahoo!? | Yahoo! Shopping - Send Flowers for Valentine's Day | http://shopping.yahoo.com | | - | To unsubscribe, e-mail: [EMAIL PROTECTED] | For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] RE: a product or code to read email and update database
Hi, The solution i have to build is not only email, it is actually lot more, like there is a web based interface, a AS400 interface (green screen ) also now we need a email interface, the mail will be sent to a speicific account, so all the mails coming here are only for testing purpose, also all the mails will come from outlook , so only have to worry about microsoft mails, But i read few days back a product on IBM DB@ Information Integrator, so wanted to know if there are any such products which will do the same thing.. Ashish --- "Rao, Nagraj" <[EMAIL PROTECTED]> wrote: > I have worked on something like that before.. > We had > 1)Poller which periodically checked the POP server > (to get mail) > (it did not delete the mail from the server) > 2)Checked for the email "subject" ,if it matched the > one we were looking > for, then opened it. > 3)Did some processing (using String parsers ..gets a > specific text) and sent > a mail back to the sendor... > > But that was 4 years ago ! , I am sure as Jacob said > you are better off > doing something web-based since there are many > points of failure in the > above > > Cheers, > Naggi > > > > > > > > -Original Message- > From: Jacob Hookom [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 12, 2003 3:51 PM > To: 'Struts Users Mailing List' > Subject: RE: [OT] RE: a product or code to read > email and update > database > > > 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:[EMAIL PROTECTED]] > | 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 > | <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > | > > Sent: Wednesday, February 12, 2003 1:24 PM > | > > To: [EMAIL PROTECTED] > | > > 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: > | > [EMAIL PROTECTED] > | > > For additional commands, e-mail: > | > [EMAIL PROTECTED] > | > > > | > > | > > | > - > | > To unsubscribe, e-mail: > | > [EMAIL PROTECTED] > | > For additional commands, e-mail: > | > [EMAIL PROTECTED] > | > > | > | > | = > | A$HI$H > | > | __ > | Do you Yaho