Listware for Excel:SmartMover:Processing - Revision history

Admin at 23:54, 31 May 2018

2018-05-31T23:54:43Z

@@ Line 1: / Line 1: @@
-[[Listware for Excel:Reference|&larr; 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;"
+}}
 {{CustomTOC}}

Admin at 19:19, 24 September 2014

2014-09-24T19:19:44Z

← Older revision		Revision as of 19:19, 24 September 2014
Line 62:		Line 62:
	: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 the following~~ are ~~blank~~:		:The minimum input requirements are:

	#[FullName] '''''OR''''' [Company] '''''OR''''' [FirstName and LastName]		#[FullName] '''''OR''''' [Company] '''''OR''''' [FirstName and LastName]
	#[Address1] '''''AND''''' [City/State] '''''OR''''' [Address1] '''''AND''''' [Zip]		#[Address1 OR Address2] '''''AND''''' [City/State] '''''OR''''' [Address1 OR Address2] '''''AND''''' [Zip]

	;Corrected		;Corrected

Admin at 17:55, 24 September 2014

2014-09-24T17:55:51Z

← Older revision		Revision as of 17:55, 24 September 2014
Line 62:		Line 62:
	: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:		:This can occur if the following are blank:
	:*FullName ~~and~~ Company
	::'''''OR'''''		#[FullName] '''''OR''''' [Company] '''''OR''''' [FirstName and LastName]
	:*FirstName and LastName		#[Address1] '''''AND''''' [City/State] '''''OR''''' [Address1] '''''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==

Admin: /* Processing */

2014-09-24T17:36:18Z

Processing

← Older revision		Revision as of 17:36, 24 September 2014
Line 63:		Line 63:

	:This can occur if any of the following are blank:		:This can occur if any of the following are blank:
	:*FullName		:*FullName and Company
	:*~~First/Last~~		::'''''OR'''''
	:*Company		:*FirstName and LastName
	:*Address1 and ~~Address2~~		::'''''OR'''''
	:*~~City/State/~~Zip		:*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==

Admin at 22:08, 23 September 2014

2014-09-23T22:08:25Z

@@ Line 50: / Line 50: @@
 [[File:LWE_SmartMover_Processing.png|link=]]
 Processing will display the progress of your data cleansing.
 ;NCOA Report
 :Click this button to view (and then optionally print) the NCOA Summary Report.

Admin at 21:39, 23 September 2014

2014-09-23T21:39:54Z

← Older revision		Revision as of 21:39, 23 September 2014
Line 11:		Line 11:
	\|-		\|-
	\|[[Listware for Excel:SmartMover Tutorial\|Tutorial]]		\|[[Listware for Excel:SmartMover Tutorial\|Tutorial]]
			\|-
			\|[[Listware for Excel:SmartMover:PAF\|PAF]]
	\|-		\|-
	\|		\|

Admin at 19:37, 17 September 2014

2014-09-17T19:37:43Z

← Older revision		Revision as of 19:37, 17 September 2014
Line 30:		Line 30:
	\|-		\|-
	\|[[Listware for Excel:SmartMover:Processing\|Processing]]		\|[[Listware for Excel:SmartMover:Processing\|Processing]]
	\|-
	~~\|[[Listware for Excel:SmartMover:Review Results\|Review Results]]~~
	\|}		\|}
	\|-		\|-

Admin: Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

2014-09-17T19:36:14Z

Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

New page

[[Listware for Excel:Reference|← Listware for Excel Reference]]

{| 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]]
|-
|
{| 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]]
|-
|[[Listware for Excel:SmartMover:Review Results|Review Results]]
|}
|-
|
{| 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}}

[[File:LWE_SmartMover_Processing.png|link=]]

Processing will display the progress of your data cleansing.

;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==
[[File:LWE_CreditsUsed.png|link=]]

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

[[Category:Listware for Excel]]