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


  • 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