Listware for Excel:SmartMover:Processing: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Listware for Excel:Reference|← Listware for Excel Reference]]
{{LWESmartMoverNav
 
|StepsCollapse=
{| 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;"|'''SmartMover NCOA Navigation'''
|-
| style="padding-right:220px;"|
|-
|style="border-bottom:1px solid #aaaaaa;"|[[Listware for Excel:Check and Verify|← Check and Verify]]
|-
|[[Listware for Excel:SmartMover|Overview]]
|-
|[[Listware for Excel:SmartMover Tutorial|Tutorial]]
|-
|[[Listware for Excel:SmartMover:PAF|PAF]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:SmartMover:Processing Range|Processing Range]]
|-
|[[Listware for Excel:SmartMover:NCOA Options|NCOA Options]]
|-
|[[Listware for Excel:SmartMover:Input Columns|Input Columns]]
|-
|[[Listware for Excel:SmartMover:Output Columns|Output Columns]]
|-
|[[Listware for Excel:SmartMover:Reporting|Reporting]]
|-
|[[Listware for Excel:SmartMover:Review Settings|Review Settings]]
|-
|[[Listware for Excel:SmartMover:Processing|Processing]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}
Line 62: Line 19:
:The number of records where the minimum input for Change of Address was not met.
:The number of records where the minimum input for Change of Address was not met.


:This can occur if any of the following are blank:
:The minimum input requirements are:
:*FullName and Company
 
::'''''OR'''''
#[FullName] '''''OR''''' [Company] '''''OR''''' [FirstName and LastName]
:*FirstName and LastName
#[Address1 OR Address2] '''''AND''''' [City/State] '''''OR''''' [Address1 OR Address2] '''''AND''''' [Zip]
::'''''OR'''''
:*Address1 and City/State
::'''''OR'''''
:*Address1 and Zip


;Corrected
;Corrected
:The number of records whose address has been corrected.
:The number of records whose address has been corrected.


==Actions==
==Actions==

Latest revision as of 23:54, 31 May 2018

← Listware for Excel Reference

SmartMover NCOA Navigation
← US & Canada
Overview
Tutorial
PAF
Steps
Processing Range
NCOA Options
Input Columns
Output Columns
Reporting
Review Settings
Processing
Result Codes



Processing

Processing will display the progress of your data cleansing.

Verified
The number of records whose address was verified.
Unverified
The number of records whose address could not be verified.
Empty
The number of records where the minimum input for Change of Address was not met.
The minimum input requirements are:
  1. [FullName] OR [Company] OR [FirstName and LastName]
  2. [Address1 OR Address2] AND [City/State] OR [Address1 OR Address2] AND [Zip]
Corrected
The number of records whose address has been corrected.


Actions

NCOA Report
Click this button to view (and then optionally print) the NCOA Summary Report.
This report will contain your PAF information, the name of the list processed, and Change of Addres statistics.
CASS Report
Click this button to view (and then optionally print) the 3553 CASS Form.
This report will contain address correction statistics.
Restart
If you want to restart the data cleansing process (possibly to change some settings, process more records, etc.) click 'Restart'.
Close
Click 'Close' to close the Listware Add-in. Make sure to save your file before you exit Excel, or you may lose your cleansed data.


Credits Used

Once processing is complete a window will pop-up, displaying the amount of credits your data cleansing process used.

Retrieved from "http://wiki.melissadata.com/index.php?title=Listware_for_Excel:SmartMover:Processing&oldid=14707"