Email Parser Rules Window

Here you will Create the Rules necessary for each of your Parsers to Automate the Merging of Email Registrations into your Database:

The left hand side grid shows the Data Items that are to be filled and merged from the Email and the right hand side defines the rules of how to find and copy the data from the Email and merge it into the data item.

For each piece of data you want to merge you need to add a Data Item and set it's rule for how to find and copy it from the Email.

When adding multiple records you may find the Copy Button will save time. It copies the current record which you can then modifiy potentially saving a lot of time for items that are similar in setup.

There a 4 pre-defined settings for easily parsing Addresses. These settings are found in the Data Rules Field. If you choose one of these settings you are automatically using multiple data fields (Address 1, Address 2, City, State, Zip, etc) and therefore do not need to add those fields yourself. The Data Rules Field explains these options and the layouts they support.

If a Registration Service updates or changes the format of their Registration Notification Emails a new import file will be created and once it is downloaded, you will be able to use the Replace Rules button to update a Parser to the lastest rules.

If you need help setting up your rules, we can help if you send us an example of the email and tell us which data item(s) you want to merge.

Icon Meanings

Replace all the Rules (when updated)
Copy Current Record
Add a New Record
Edit the Current Record
Delete the Current Record
Save Changes when you are Adding or Editing
Cancel Changes when you are Adding or Editing
Open the Help File
Close the Window

Parser Rules
You must be in Edit or Insert mode in order to change/add data.

How to Pick the Data Item
Click on the button inside the Data Field to bring up the Merge Fields Window. The Merge Fields Window is where you will pick the Data Item from the available Database fields.

How to tell the parser where to find the data
Click on the Positioning drop down arrow to select the type of positioning to use from the choices below:

Line and Col - Start position will be a specific line & column in the email.
Match # - Start position is where the Match field is found plus the length of Match field.
Match # - Begin of Line - Same as Match #; however, the start position will be the beginning of the line.
Match # - End of Line - Same as Match #; however, the start position will be the end of the line.
Match # - Line/Col Offset - Same as Match #; however, the start position will be offset by Line Offset and Col Offset.

For above Match #'s, Match # field determines which occurance of the Match Field to use.

How to tell the parser the amount of data to copy
Click on the Data Rules drop down arrow to select the type of data rules to use from the choices below:

# of Characters - Amount copied is specified by # of Characters field
Until Found - Copy from Start position to position where Until Found field is found
Until End of Line - Copy from Start position to the end of that line.
Until Begin of Line - Copy from Start position to the beginning of that line.
Full Address (Type 1) - This is for addresses of the following layout:
        Address 1
        Address 2
        City, State
        Zip
        Country
Full Address (Type 2) - This is for addresses of the following layout:
        Address 1
        Address 2
        City, State Zip
        Country
City, State Zip Country - This is for addresses of the following layout:
        City, State Zip Country
City, State Zip - This is for addresses of the following layout:
        City, State Zip

How to tell the parser the direction to copy
Click on the Copy Direction drop down arrow to select the direction from the choices below:

Forward - Copy from Start position Forward.
Back - Copy from Start position Backwards.

Example