Anonymous_User Absent Member.
Absent Member.
2525 views

Parsing email content from Inbox using Exchange


Hello All -

My first time on these forums for Aegis and fairly a novice user. I am
thinking out loud here and trying to determine whether this can be
achieved. My goal is to be able to parse Exchange inbox for emails
including parsing the email body for specific chunk of text and insert
it into specific columns in Excel. Basically parse the email subject and
body for certain text and export it into Excel. Can this be achieved
using Aegis? Can anyone give me some ideas on how to parse the content
of an email using Aegis? Any advise would be greatly appreciated.
thanks.


--
aniazi
------------------------------------------------------------------------
aniazi's Profile: https://forums.netiq.com/member.php?userid=7981
View this thread: https://forums.netiq.com/showthread.php?t=51579

0 Likes
1 Reply
Anonymous_User Absent Member.
Absent Member.

Re: Parsing email content from Inbox using Exchange


Hi Aniazi,

Yes this is very do-able. You can configure the Mail adapter to monitor
an Exchange mailbox, any emails arriving into the inbox will generate an
event in Aegis. The event will include different fields of the email
including the subject, body, sender etc. You can then use the regular
expression activity to extract the detail you want from the message
body.

Adding the data into the Excel File can be done using the 'Execute SQL
Commands and Scripts' activity - you need to define a connection string
to do it. There is also an activity on Community which is simpler to
configure, but you'll still need to build the SQL INSERT command
yourself but the link here gives examples on how to download and use it
: http://tinyurl.com/pbezkd5

Martin


--
martincotter
------------------------------------------------------------------------
martincotter's Profile: https://forums.netiq.com/member.php?userid=3942
View this thread: https://forums.netiq.com/showthread.php?t=51579

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.