Difference between revisions of "Contact Zone:Contact Verify:Output Filter"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Contact Zone:Reference|← Contact Zone Reference]]
{{ContactZoneContactVerifyNav
 
|ContactVerifyCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Contact Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Contact Zone:Contact Verify Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[Contact Zone:Contact Verify:Component Settings|Component Settings]]
|-
|[[Contact Zone:Contact Verify:Component Settings#Show Details (On-Premise)|Show Details (On-Premise)]]
|-
|[[Contact Zone:Contact Verify:Component Settings#Show Details (Web)|Show Details (Web)]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Contact Verify Tabs
|-
|[[Contact Zone:Contact Verify:Name|Name]]
|-
|[[Contact Zone:Contact Verify:Address|Address]]
|-
|[[Contact Zone:Contact Verify:GeoCode|GeoCode]]
|-
|[[Contact Zone:Contact Verify:Phone/Email|Phone/Email]]
|-
|[[Contact Zone:Contact Verify:Pass-Through Columns|Pass-Through Columns]]
|-
|[[Contact Zone:Contact Verify:Output Filter|Output Filter]]
|-
|[[Contact Zone:Contact Verify:Processing Options|Processing Options]]
|-
|[[Contact Zone:Contact Verify:Reporting|Reporting]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Enterprise Solutions#Contact Zone|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 
 


{{CustomTOC}}
{{CustomTOC}}


The Contact Verify Component will output records to one of two tables: the valid table and the invalid table. The Output Filter tab allows you to control which records go to which table.
The Contact Verify Component will output records in up to four streams. The Output Filter tab allows you to control which records go to which stream. Names and usage can be done in any manner. Filters are evaluated from the top down.


[[File:CZ_CV_OutputFilter.jpg|link=]]
[[File:CZ_CV_OutputFilter.png|link=]]


==Result Codes==
==Result Codes==
Line 84: Line 34:
:A custom rule that would be equivalent to Pre-built rule #6 would read: “(ES01 OR ES03) AND NOT ES04.”
:A custom rule that would be equivalent to Pre-built rule #6 would read: “(ES01 OR ES03) AND NOT ES04.”
:This means that the conditions for the rules are met if either result code “ES01” or “ES03” were returned and the result code “ES04” was not returned.
:This means that the conditions for the rules are met if either result code “ES01” or “ES03” were returned and the result code “ES04” was not returned.
:Custom rules are an advanced subject. You should be comfortable with Boolean operations before using custom rules in a production environment. For more information on the available result codes, see [[#Custom Output Filters|Custom Output Filters]] below.
:For more information, see Custom Output Filters below.


;Target
:The output which is filtered is saved in a file.


==Custom Output Filters==
The Contact Verify Component will output records in up to four streams. Names and usage can be done in any manner. Filters are evaluated from the top down. A custom filter may be created based on individual need, each pin filters the records in a cascading effect, where the results code is compared against the first expression (Pin 1) and then compared against Pin 2, and so on.


===Custom Filter===
==[[Contact Zone:Custom Output Filters|Custom Output Filters]]==
Select Customer Filter from the drop down and click Ctrl + Space in Customer Filter Expression text box to open an expression dialog drop down. These rules use Boolean operators ("OR," "AND," and "NOT") and the result codes to construct filters. Records matching the filter will be directed to the valid table while the rest are directed to the invalid table.
Custom rules are an advanced subject. You should be comfortable with Boolean operations before using custom rules in a production environment.


[[File:CZ_CV_OutputFilter_CustomFilter.jpg|link=]]
For more information see [[Contact Zone:Custom Output Filters|Custom Output Filters]].
 
A custom rule that would be equivalent to Pre-built rule #2 would read: "(AS01 OR AS02)". This means that the conditions for the rules are met if either result code "AS01" or "AS02" were returned.
 
===Validate Custom Rules===
[[File:CZ_CV_OutputFilter_ValidateRules.jpg|link=]]
 
[[File:CZ_CV_OutputFilter_Validated.jpg|link=]]
 
A custom expression may be tested by clicking on the "Validate Custom Rule(s)" button. A pop-up dialog box will confirm whether or not the custom expression is acceptable.
 
===Save Custom Rule===
[[File:CZ_CV_OutputFilter_SaveRules.jpg|link=]]
 
Right-click the Custom Expression, then left-click Save Custom Rule... from the pop-up. Enter a name for the filter in the window and click OK. It will now be available as a Pre-Built Filter for subsequent components.
 
===Remove Selected Rule===
[[File:CZ_CV_OutputFilter_RemoveRules.jpg|link=]]
 
[[File:CZ_CV_OutputFilter_RemoveConfirm.jpg|link=]]
 
To remove a Pre-Built Filter, select the filter from the Pre-Built drop-down list, right-click the filter, and select Remove Selected Rule.... Click OK. After saving this component, it will no longer be available in new component configurations.
*[[Returned Result Codes:Enterprise Solutions#Contact Zone|Returned Result Codes]]




[[Category:Contact Zone]]
[[Category:Contact Zone]]

Latest revision as of 01:09, 3 January 2017

← Contact Zone

Contact Verify Navigation
Overview
Tutorial
Component Settings
Show Details (On-Premise)
Show Details (Web)
Contact Verify Tabs
Name
Address
GeoCode
Phone/Email
Pass-Through Columns
Output Filter
Processing Options
Reporting
Result Codes



The Contact Verify Component will output records in up to four streams. The Output Filter tab allows you to control which records go to which stream. Names and usage can be done in any manner. Filters are evaluated from the top down.

CZ CV OutputFilter.png

Result Codes

The output status of a record is returned via result codes returned by the underlying objects. The Component will combine them into a single, comma-delimited string and write them to the field mapped here. New field names can be created by typing the name into the Output Results Code box.


Output Filter

Select a filter to determine which records will be directed to a particular output stream. A custom filter may be created based on individual need, each pin filters the records in a cascading effect, where the results code is compared against the first expression (Pin 1) and then compared against Pin 2, and so on.

No Filter
All records are written to a single output stream.
Pre-built Filter
The Component comes with several pre-built filters for common applications:
  1. Full Address Matches - The record is valid only with a valid and deliverable mailing address.
  2. Street Address Matches - The record is valid if the street address is deliverable, even if the suite information is missing.
  3. Full Address Match and Deliverable by all carriers - The record is valid only with a valid and deliverable mailing address that is also served by alternate delivery services such as Fed Ex and UPS.
  4. Non-Questionable Names - The record is valid if the name information was complete and contains no questionable information (vulgarities or common nuisance names).
  5. Valid Email Domains - The record is valid if the domain for the email address was either confirmed to be valid or, at the very least, is not known to be invalid.
  6. Valid and Allowable Email Domains - The record is valid if the domain for the email address was either confirmed to be valid or is not known to be invalid, and is not a mobile email address (which are not deliverable per FCC regulations).
  7. Full Phone Matches - The record is valid only if the phone number was verified to the 10-digit level.
  8. Full and Partial Phone Matches - The record is valid if the phone number was verified to either the 10-digit or 7-digit level.
Custom Filter
A custom rule that would be equivalent to Pre-built rule #6 would read: “(ES01 OR ES03) AND NOT ES04.”
This means that the conditions for the rules are met if either result code “ES01” or “ES03” were returned and the result code “ES04” was not returned.
For more information, see Custom Output Filters below.
Target
The output which is filtered is saved in a file.


Custom Output Filters

Custom rules are an advanced subject. You should be comfortable with Boolean operations before using custom rules in a production environment.

For more information see Custom Output Filters.