Listware for Excel:US Tutorial: Difference between revisions
No edit summary |
No edit summary |
||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{LWEUSNav}} | |||
{ | |||
{ | |||
{{CustomTOC}} | {{CustomTOC}} | ||
Line 50: | Line 5: | ||
[[File:LWE_US_Button.png|link=]] | [[File:LWE_US_Button.png|link=]] | ||
After you install Listware and set your | 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 cleansing on a data set with US Check & Verify. | Follow along with the steps below to perform a sample cleansing on a data set with US Check & Verify. | ||
Line 77: | Line 32: | ||
Choose which cleansing operations you require. | Choose which cleansing operations you require. | ||
For more information on Melissa Data Credits, please see [ | For more information on Melissa Data Credits, please see [https://www.melissa.com/pricing/listware Credit Costs]. | ||
[[File:LWE_US_Tutorial_Operations.png|link=]] | [[File:LWE_US_Tutorial_Operations.png|link=]] | ||
Line 103: | Line 58: | ||
[[File:LWE_US_Tutorial_OutputColumns.png|link=]] | [[File:LWE_US_Tutorial_OutputColumns.png|link=]] | ||
Once your output data has been chosen, click 'next' to continue to the Review Settings step. | Once your output data has been chosen, click 'next' to continue to the Reporting step. | ||
==Reporting== | |||
Specify if you want a report created and the contents of that report. | |||
When processing is completed, you have the option of having a new sheet created and inserted immediately following the processed sheet. This reporting sheet will contain statistics and settings summarizing the processing run. | |||
[[File:LWE_US_Tutorial_Reporting.png|link=]] | |||
Once you choose what reports you want, click 'next' to continue to the Review Settings step. | |||
Latest revision as of 23:49, 26 December 2019
← Listware for Excel Reference
US Check and Verify Navigation | |||||||||
---|---|---|---|---|---|---|---|---|---|
← US & Canada | |||||||||
Overview | |||||||||
Tutorial | |||||||||
| |||||||||
Result Codes |
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 cleansing on a data set with US Check & Verify.
Open a Spreadsheet
Open a spreadsheet containing your data in Excel.
Select US
Select the Listware Ribbon followed by the US Check & Verify button.
The US Check & Verify 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.
Once your data has been selected, click 'next' to move on to the Cleansing Operations step.
Choose Cleansing Operations
Choose which cleansing operations you require.
For more information on Melissa Data Credits, please see Credit Costs.
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.
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 cannot receive output for column that have no matching input unless you are using the Append action.
For example, if you have no input phone field do not select phone as an output when Append is not checked under the Cleansing Operations: This will cause a warning and US Check & Verify will not perform any actions until you change this to follow the requirements. But if you choose Append as a Cleansing Operation, you can create a phone output without a phone input because a valid name and address input is likely to append that contacts phone number.
Once your output data has been chosen, click 'next' to continue to the Reporting step.
Reporting
Specify if you want a report created and the contents of that report.
When processing is completed, you have the option of having a new sheet created and inserted immediately following the processed sheet. This reporting sheet will contain statistics and settings summarizing the processing run.
Once you choose what reports you want, click 'next' to continue to the Review Settings step.
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.
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 'Review' errors, 'Restart', or 'Close' the process.
- Review will allow you to fine-tune your data. See step 9 for more information.
- Restart will run the process again.
- Close will close the side bar.
Review
If you choose to 'Review' any Errors you will be directed to a Navigation side bar that allows you to modify any data that has returned errors.
When reviewing you can edit the input data of the current record being reviewed.
For example: With a record where the Organization and Address were in the wrong input columns, you can paste them into the correct field and hit re-scan. The record will then be reprocessed according to the cleansing operation. If the result returns a better result code you can then select save to write those properties to the actual sheet (You will not be charged a credit for re-scanning a previously processed record)
Save
When you are satisfied with your data, use the Excel menu to save your spreadsheet.