March 07, 2007, 06:13 PM
TexasStingrayEmail Listener with Attachment
Has anyone configured the an iAD Email Listener with the Attachment
com.ibi.agents.XDMailAttachAgent
I am looking for Step by Step help as I have not been able to get this working iWay 5.5SP5
I have and email comming in that has an attachment and that attachment is the data I need to process. I have the email listener working but am having some trouble with the AttachAgent
Thanks
Scott
March 18, 2007, 11:01 AM
FrankDutchSo when you receive the mail, the proces should save the attachment and then that attechment will be processed against the database?
Never knew that would be a possibility.
I will search in the descriptions how that can be done, I need this too and was thinking on some vba scripting against the mailserver.
Frank
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
March 18, 2007, 04:51 PM
TexasStingrayFrank,
I got it working. Using iWay Adapter Manager new name iWay Service Manager.
Here is what I am doing; using WebFOCUS Dashboard the user, in this case a product buyer, after logging in may be presented with an alert that tells them that a one or more of the products they are responable for buying is low. Then using WebFOCUS and an Excel Template the user is presented with a Report in Excel and then they can enter the Qty (number of items they want) to order for each product, then when ready they click the place order button on the excel worksheet, then using VBA the file is saved as a CSV file and emailed as an attachment to an email address iAM is pooling for email. Then iAM / Service Manager then extracts the attachment and process it using JDBC and Supplier WebServices to place an Order. An email message is then sent to the buyer, and because the Product_Orders table has been updated the alert in the dashboard disappears until product levels get low again.
VERY VERY Cool.
Scott
Scott
November 27, 2012, 06:21 PM
ShirleyHi Scott,
I'm looking to achieve similar process here. I have an attachment via email. I'm trying to get the email listener working. Do you know where can I find documentation on how to setup email listener? Much appreciated on your help!
Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16