Listware for Excel:SmartMover - Revision history

Admin at 23:52, 31 May 2018

2018-05-31T23:52:12Z

← Older revision		Revision as of 23:52, 31 May 2018
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}}

Admin at 23:26, 23 May 2018

2018-05-23T23:26:44Z

← Older revision		Revision as of 23:26, 23 May 2018
Line 49:		Line 49:
	[[File:LWE_SmartMover_Button.png\|link=]]		[[File:LWE_SmartMover_Button.png\|link=]]

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

Admin at 21:38, 23 September 2014

2014-09-23T21:38:58Z

← Older revision		Revision as of 21:38, 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 20:50, 19 September 2014

2014-09-19T20:50:25Z

← Older revision		Revision as of 20:50, 19 September 2014
Line 50:		Line 50:


	SmartMover ~~allows you~~ to ~~do Move Updates~~. Each step can be navigated to by clicking the 'Next' or 'Previous' buttons. The steps are as follows:		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:

	;[[Listware for Excel:SmartMover:Processing Range\|Processing Range]]		;[[Listware for Excel:SmartMover:Processing Range\|Processing Range]]

Admin at 19:42, 17 September 2014

2014-09-17T19:42:58Z

← Older revision		Revision as of 19:42, 17 September 2014
Line 71:		Line 71:

	;[[Listware for Excel:SmartMover:Processing\|Processing]]		;[[Listware for Excel:SmartMover:Processing\|Processing]]
	:Processing will display the ~~progess~~ of your data cleansing.		:Processing will display the progress of your data cleansing. Once it is complete you can generate NCOA Reports and CASS Reports from this step.

	~~;[[Listware for Excel:SmartMover:Review Results\|Review Results]]~~
	:Once ~~processing~~ is ~~completed,~~ this step ~~will display. You may take this opportunity to review, restart, or close the process~~.


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin at 19:40, 17 September 2014

2014-09-17T19:40:48Z

← Older revision		Revision as of 19:40, 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 at 23:09, 16 September 2014

2014-09-16T23:09:12Z

← Older revision		Revision as of 23:09, 16 September 2014
Line 19:		Line 19:
	\|[[Listware for Excel:SmartMover:Processing Range\|Processing Range]]		\|[[Listware for Excel:SmartMover:Processing Range\|Processing Range]]
	\|-		\|-
	\|[[Listware for Excel:SmartMover:~~Cleansing Operations~~\|~~Cleansing Operations~~]]		\|[[Listware for Excel:SmartMover:NCOA Options\|NCOA Options]]
	\|-		\|-
	\|[[Listware for Excel:SmartMover:Input Columns\|Input Columns]]		\|[[Listware for Excel:SmartMover:Input Columns\|Input Columns]]

Admin at 21:41, 16 September 2014

2014-09-16T21:41:23Z

← Older revision		Revision as of 21:41, 16 September 2014
Line 53:		Line 53:

	SmartMover allows you to do Move Updates. Each step can be navigated to by clicking the 'Next' or 'Previous' buttons. The steps are as follows:		SmartMover allows you to do Move Updates. Each step can be navigated to by clicking the 'Next' or 'Previous' buttons. The steps are as follows:

			;[[Listware for Excel:SmartMover:Processing Range\|Processing Range]]
			:Select the range of cells in your worksheet that you would like to process, then click the 'Select Data to Process' button.

	;[[Listware for Excel:SmartMover:NCOA Options\|NCOA Options]]		;[[Listware for Excel:SmartMover:NCOA Options\|NCOA Options]]

Admin at 21:39, 16 September 2014

2014-09-16T21:39:44Z

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

2014-09-16T21:36:01Z

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 mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:SmartMover:Processing Range|Processing Range]]
|-
|[[Listware for Excel:SmartMover:Cleansing Operations|Cleansing Operations]]
|-
|[[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_Button.png|link=]]

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

SmartMover allows you to do Move Updates. Each step can be navigated to by clicking the 'Next' or 'Previous' buttons. The steps are as follows:

;[[Listware for Excel:SmartMover:NCOA Options|NCOA Options]]
:Select the Change of Address service you would like to perform, then click the 'Select Data to Process' button.

;[[Listware for Excel:SmartMover:Input Columns|Input Columns]]
Specify the input fields you want to process by selecting them in the drop-down menus.

;[[Listware for Excel:SmartMover:Output Columns|Output Columns]]
Specify what data you want to output by checking the box next to the desired fields.

;[[Listware for Excel:SmartMover:Reporting|Reporting]]
Listware now gives you the option of creating an additional sheet of processing statistics for a completed process.

;[[Listware for Excel:SmartMover:Review Settings|Review Settings]]
Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file.

;[[Listware for Excel:SmartMover:Processing|Processing]]
Processing will display the progess of your data cleansing.

;[[Listware for Excel:SmartMover:Review Results|Review Results]]
Once processing is completed, this step will display. You may take this opportunity to review, restart, or close the process.

[[Category:Listware for Excel]]

← Older revision		Revision as of 21:39, 16 September 2014
Line 58:		Line 58:

	;[[Listware for Excel:SmartMover:Input Columns\|Input Columns]]		;[[Listware for Excel:SmartMover:Input Columns\|Input Columns]]
	Specify the input fields you want to process by selecting them in the drop-down menus.		:Specify the input fields you want to process by selecting them in the drop-down menus.

	;[[Listware for Excel:SmartMover:Output Columns\|Output Columns]]		;[[Listware for Excel:SmartMover:Output Columns\|Output Columns]]
	Specify what data you want to output by checking the box next to the desired fields.		:Specify what data you want to output by checking the box next to the desired fields.

	;[[Listware for Excel:SmartMover:Reporting\|Reporting]]		;[[Listware for Excel:SmartMover:Reporting\|Reporting]]
	Listware now gives you the option of creating an additional sheet of processing statistics for a completed process.		:Listware now gives you the option of creating an additional sheet of processing statistics for a completed process.

	;[[Listware for Excel:SmartMover:Review Settings\|Review Settings]]		;[[Listware for Excel:SmartMover:Review Settings\|Review Settings]]
	Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file.		:Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file.

	;[[Listware for Excel:SmartMover:Processing\|Processing]]		;[[Listware for Excel:SmartMover:Processing\|Processing]]
	Processing will display the progess of your data cleansing.		:Processing will display the progess of your data cleansing.

	;[[Listware for Excel:SmartMover:Review Results\|Review Results]]		;[[Listware for Excel:SmartMover:Review Results\|Review Results]]
	Once processing is completed, this step will display. You may take this opportunity to review, restart, or close the process.		:Once processing is completed, this step will display. You may take this opportunity to review, restart, or close the process.


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]