Difference between revisions of "BEmail Content Retrieval"

Revision as of 15:12, 12 September 2012

Content retrieval is the set of rules used to interrogate the data in an email and strip out what is required from that content. You can have as many rules as you like and trial and error usually dictate how effective your rules are.

Each rule is in the format

StartCharacters#EndCharacters#DestinationField#Location~

Take an example email

You have received a new voicemail from 0867952818 - 

From Caller ID 0867952818
To voicemail box 1401 - Video 1401 GXV3140 Received 12/09/2012 13:52:02 Duration 00:00:23
File     vmail_0867952818_1401_20120912125202

we want to extract the duration data.

The rule would look like:

Duration #vbCrLf#strCDA_X_field_0_0#Body~

The text we want to start at is [Duration ]

We want to end at the return character at the end of the line. So we use vbCrLf (Visual Basic Carriage Return Line Feed). This could be a space caracter or anything. Just our example uses a return.

strCDA_X_field_0_0 is whatever field in your campaign database you want the data to go into.

Body shows this data is in the body of the email. You could alternately use Subject.

The result of this rule will extract 00:00:23 and put it in the field strCDA_X_field_0_0