Parker Software Ltd Homepage
Forum Home Forum Home > ThinkAutomation Business Process Automation > Samples
  New Posts New Posts RSS Feed - Auto-lead Data Format (ADF) XML Parse Sample
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Auto-lead Data Format (ADF) XML Parse Sample

 Post Reply Post Reply
Author
Message
Daniel Horton View Drop Down
Admin Group
Admin Group
Avatar
Technical Support

Joined: 01 Jun 2009
Location: Stoke-on-Trent
Points: 346
Post Options Post Options   Thanks (0) Thanks(0)   Quote Daniel Horton Quote  Post ReplyReply Direct Link To This Post Topic: Auto-lead Data Format (ADF) XML Parse Sample
    Posted: 18 Jul 2012 at 10:29am
Version 3 only sample

The following sample is to show how you are able to parse Auto-lead Data Format (ADF) XML content from an email body or an attachment within the Email2DB tool and how to configure this using a trigger.

Download Sample Account and Triggers  http://downloads.email2db.com/ADFSample.db3 

You can download the above .db3 file to your computer, then use the File -> Server Configuration Manager -> Import Accounts option inside the Email2DB Administrator. 

Select the file using the Folder button, then click Open, then click the Import button to import the accounts. Now restart the Email2DB services to view the imported account.

Once you have loaded Email2DB's Administrator you will see the following account has been added to your service:




Within this account is a single trigger called Auto-lead Data Format (ADF) Parse:



Within the account's properties you will see that we have enabled the option to 'Append Text, Rich Text & PDF Attachments To Body For Parsing'. This means that any attached XML files or ADF content will be considered by our parsing rules:



Within the trigger there are 7 fields currently being extracted. These fields are taken from the minimum amount of fields that can be found within an ADF document so that it is a valid format, but there are several other fields that could be added to this trigger if you require them: 



The sample ADF we are using here is as follows:

<?ADF VERSION "1.0"?>
<?XML VERSION “1.0”?>
<adf>
<prospect>
<requestdate>2000-03-30T15:30:20-08:00</requestdate>
<vehicle>
<year>1999</year>
<make>Chevrolet</make>
<model>Blazer</model>
</vehicle>
<customer>
<contact>
<name part="full">John Doe</name>
<phone>393-999-3922</phone>
</contact>
</customer>
<vendor>
<contact>
<name part="full">Acura of Bellevue</name>
</contact>
</vendor>
</prospect>
</adf>


Within most of the fields we are able to use the standard parsing rules of <tag> until end of tag, which you may see within the VehicleYear, VehicleMake, VehicleModel and ContactPhone fields. 

VehicleYear:





This will work whenever the date is formatted like so:

<tag>{value}</tag>

Though as we can see in the example, some of the fields that are given to us contain further XML items that will not be taken into account with the above rules and so we need to offer Email2DB further information to find these fields. An example of one of these fields would be ContactName which looks like this:

<name part="full">John Doe</name>

So within Email2DB we need to use the following to find the field's value:

Look for - 

<name part="full">

Extract Until These Characters -

</name>





With all of these field extractions in place when you run the trigger against data, the Message Processor Log should show the following when you run through test data to indicate that the fields have been extracted from the message correctly:



Once the fields are within Email2DB you are then able to take advantage of all of the actions found within our Email2DB product.

If you have any further questions in regard to the sample then please let us know via this thread or via email to support@parker-software.com.


Edited by James Horton - 18 Jul 2012 at 10:56am
Best Regards,

Daniel James Horton
Technical Manager
Parker Software
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.05
Copyright ©2001-2016 Web Wiz Ltd.

This page was generated in 0.063 seconds.