Difference between revisions of "Listware for Excel:SmartMover:Processing"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(4 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 50: Line 7:
[[File:LWE_SmartMover_Processing.png|link=]]
[[File:LWE_SmartMover_Processing.png|link=]]


==Processing==
Processing will display the progress of your data cleansing.
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:
#[FullName] '''''OR''''' [Company] '''''OR''''' [FirstName and LastName]
#[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
;NCOA Report
:Click this button to view (and then optionally print) the NCOA Summary Report.
:Click this button to view (and then optionally print) the NCOA Summary Report.

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



LWE SmartMover Processing.png

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

LWE CreditsUsed.png

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