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

From Melissa Data Wiki
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
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]]
|-
|
{| 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}}
Line 48: Line 5:
[[File:LWE_SmartMover_Button.png|link=]]
[[File:LWE_SmartMover_Button.png|link=]]


After you install Listware and set your Customer License String, you are ready to use Listware. Follow along with the steps below to perform a sample move update on a data set with SmartMover NCOA.
After you install Listware and set your License Key, you are ready to use Listware. Follow along with the steps below to perform a sample move update on a data set with SmartMover NCOA.




Line 58: Line 15:
Select the Listware Ribbon followed by the SmartMover NCOA button.
Select the Listware Ribbon followed by the SmartMover NCOA button.


[[File:LWE_SmartMover_Tutorial_Select.png|link=]]
<!--[[File:LWE_SmartMover_Tutorial_Select.png|link=]]-->
[[File:LWE_US_Tutorial_Select.png|link=]]


The SmartMover NCOA panel will open.
The SmartMover NCOA panel will open.
Line 69: Line 27:


Once your data has been selected, click 'next' to move on to the NCOA Options step.
Once your data has been selected, click 'next' to move on to the NCOA Options step.
==PAF==
You must have a PAF on file with Melissa Data to use SmartMover NCOA.
[[File:LWE_SmartMover_PAFAlert.png|link=]]
If you see the "No PAFs on file (click for more information)" warning, you do not have a PAF on file. Please click the "click for more information" link and follow the prompts to set up your PAF. For more information, see [[Listware for Excel:SmartMover:PAF|PAF]].




==Choose NCOA Options==
==Choose NCOA Options==
Choose which NCOA options you require.
Choose which NCOA options you require.
For more information on Melissa Data Credits, please see [https://www.melissa.com/pricing/listware Credit Costs].


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

Latest revision as of 23:48, 26 December 2019

← 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 Button.png

After you install Listware and set your License Key, you are ready to use Listware. Follow along with the steps below to perform a sample move update on a data set with SmartMover NCOA.


Open a Spreadsheet

Open a spreadsheet containing your data in Excel.


Select SmartMover

Select the Listware Ribbon followed by the SmartMover NCOA button.

LWE US Tutorial Select.png

The SmartMover NCOA panel will open.


Select Data

Choose what data you want to use by click-dragging a box around it and clicking the 'Select Data to Process' button.

LWE SmartMover Tutorial SelectData.png

Once your data has been selected, click 'next' to move on to the NCOA Options step.


PAF

You must have a PAF on file with Melissa Data to use SmartMover NCOA.

LWE SmartMover PAFAlert.png

If you see the "No PAFs on file (click for more information)" warning, you do not have a PAF on file. Please click the "click for more information" link and follow the prompts to set up your PAF. For more information, see PAF.


Choose NCOA Options

Choose which NCOA options you require.

For more information on Melissa Data Credits, please see Credit Costs.


LWE SmartMover Tutorial NCOA.png

Click 'next' to continue on to the Input Columns step.


Input Columns

Specify the input columns you want to process.

For example, if your data has Full Name, Address 1, City, State, and ZIP4, you should map these columns by selecting the column in the drop-down boxes next to its corresponding column.

LWE SmartMover Tutorial InputColumns.png

Once your input columns have been mapped, click 'next' to continue on to the Output Columns step.


Output Columns

Specify what data you want to output.

You can quickly select all or none of the fields using the right-click menu.

LWE SmartMover Tutorial OutputColumns.png

Once your output data has been chosen, click 'next' to continue to the Review Settings step.


Reporting

You can choose what reports you want to be generated here.

LWE SmartMover Tutorial Reporting.png


Finalize Settings

Review and finalize your settings.

If there are any warnings, they will be listed here. These will need to be resolved before you can process the data.

LWE SmartMover Tutorial Finalize.png

Click 'Process!' to begin processing your file. A progress bar will be displayed.

Note: It is strongly recommended that you refrain from editing your spreadsheet while Listware is processing.


Processing Complete

Once processing is complete you can generate 'NCOA Reports', 'CASS Reports', 'Restart', or 'Close' the process.

LWE SmartMover Tutorial ProcessingComplete.png

  • Restart will run the process again.
  • Close will close the side bar.


Save

When you are satisfied with your data, use the Excel menu to save your spreadsheet.