Listware for Excel:SmartMover: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 1: Line 1:
[[Listware for Excel:Reference|← Listware for Excel Reference]]
{{LWESmartMoverNav}}
 
{| 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 mw-collapsed" 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}}

Latest revision as of 23:52, 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



SmartMover can be accessed by clicking the 'SmartMover NCOA' button in the 'Check, Verify & Move' section.


SmartMover uses National Change of Address (NCOA) data to update addresses with associated move information in the US and Canada. Each step can be navigated to by clicking the 'Next' or 'Previous' buttons. The steps are as follows:

Processing Range
Select the range of cells in your worksheet that you would like to process, then click the 'Select Data to Process' button.
NCOA Options
Select the Change of Address service you would like to perform, then click the 'Select Data to Process' button.
Input Columns
Specify the input fields you want to process by selecting them in the drop-down menus.
Output Columns
Specify what data you want to output by checking the box next to the desired fields.
Reporting
Listware now gives you the option of creating an additional sheet of processing statistics for a completed process.
Review Settings
Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file.
Processing
Processing will display the progress of your data cleansing. Once it is complete you can generate NCOA Reports and CASS Reports from this step.