AR System Email Attachments and AR system Email Attachment Join are the two you want to look at. Personally, to save space, I'd just reference the GUID on the AR System Email Attachments form rather than copying it over. If you still need to copy it for some reason, you should be able to push it over.
ORA-600 <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 03/25/2007 01:29 AM Please respond to [email protected] To [email protected] cc Subject Re: AR System Email Messages Doug, Thanks! This works. My problem is now that incoming email messages which have attachments. I can see the attachments in the AR System Email Messages form, but evidently they are actually on a different form, because they aren't in the 'table' when I create my escalation. I would like to grab any attachments that are included and put them to my attachment pool in another form. How can I do this? Thanks again! Michael Tanner, Doug wrote: > > There are a few ways to do, but there is a hidden field that has the > mailbox ID (GUID). Doug > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF > AFRL/SNOD > Sent: Wednesday, March 21, 2007 2:47 PM > To: [email protected] > Subject: AR System Email Messages > Importance: High > > > > I have a need to set up an escalation, etc that runs against AR System > Email Messages. > > When it finds new messages in this form (as placed there by the remedy > email engine), I would like to run a set fields to push the data to a > new form. My problem is that I want to look at Mailbox Name to secure > messages that come in from a specific remedy mailbox setup. I get an > error that I can't since the mailbox name field is display only. Ah ha! > So I'll instead use the to field, and grab only messages that were sent > to the inbox in question. Now I get "Failure during SQL operation to > the database" - evidently there is a further issue. "The data types > text and varchar are incompatible in the equal to operator. (SQL Server > 402)" > > My question is, once I have the email in remedy, procedurally, what is a > good way to find it and process it? Someone has to have done this - > please help me. > > > > Thanks! > > --- > Michael Cupp, Jr., Contractor, RCF > Oracle Database Administrator > AFRL EBS Helpdesk Team Lead > AFRL/SNOD Enterprise Operations Center > Wright-Patterson AFB, Ohio > DSN 785-3827 > > __20060125_______________________This posting was submitted with HTML in > it___ > > DISCLAIMER Important! This message is intended for the above named > person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the > intended recipient of this e-mail and have received it in error, please > immediately notify the sender by return email and then delete it from your > mailbox. This message may be protected by the attorney-client privilege > and/or work product doctrine. Accessing, copying, disseminating or > re-using any of the information contained in this e-mail by anyone other > than the intended recipient is strictly prohibited. Finally, you should > check this email and any attachments for the presence of viruses, as the > sender accepts no liability for any damage caused by any virus transmitted > by this email. Thank you. > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/AR-System-Email-Messages-tf3442763.html#a9657487 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
