Listware for Excel:Global Tutorial - Revision history

Admin at 23:48, 26 December 2019

2019-12-26T23:48:40Z

← Older revision		Revision as of 23:48, 26 December 2019
Line 33:		Line 33:
	Choose which cleansing operations you require and specify your country of origin, what type of script to output, and the default country.		Choose which cleansing operations you require and specify your country of origin, what type of script to output, and the default country.

	For more information on Melissa Data Credits, please see [~~http~~://www.~~melissadata~~.com/~~dqt~~/~~credit-summary.htm~~ Credit Costs].		For more information on Melissa Data Credits, please see [https://www.melissa.com/pricing/listware Credit Costs].

	[[File:LWE_Global_Tutorial_Operations.png\|link=]]		[[File:LWE_Global_Tutorial_Operations.png\|link=]]

Admin at 23:46, 31 May 2018

2018-05-31T23:46:04Z

← Older revision		Revision as of 23:46, 31 May 2018
Line 1:		Line 1:
	{{LWEGlobalNav}}		{{LWEGlobalNav}}

	{{CustomTOC}}		{{CustomTOC}}

Admin at 23:45, 31 May 2018

2018-05-31T23:45:52Z

← Older revision		Revision as of 23:45, 31 May 2018
Line 1:		Line 1:
	~~[[Listware for Excel:Reference\|← Listware for Excel Reference]]~~		{{LWEGlobalNav}}

	{~~\| 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;"\|'''Global Check and Verify Navigation'''~~
	\|-
	~~\| style="padding-right:220px;"\|~~
	\|-
	~~\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]~~
	\|-
	~~\|[[Listware for Excel:Global\|Overview]]~~
	\|-
	~~\|[[Listware for Excel:Global Tutorial\|Tutorial]]~~
	\|-
	\|
	{~~\| class="mw-collapsible mw-collapsed" style="width:100%;"~~
	~~\|- align="left"~~
	~~! style="color:black;"\|Steps~~
	\|-
	~~\|[[Listware for Excel:Global:Processing Range\|Processing Range]]~~
	\|-
	~~\|[[Listware for Excel:Global:Cleansing Operations\|Cleansing Operations]]~~
	\|-
	~~\|[[Listware for Excel:Global:Input Columns\|Input Columns]]~~
	\|-
	~~\|[[Listware for Excel:Global:Output Columns\|Output Columns]]~~
	\|-
	~~\|[[Listware for Excel:Global:Reporting\|Reporting]]~~
	\|-
	~~\|[[Listware for Excel:Global:Review Settings\|Review Settings]]~~
	\|-
	~~\|[[Listware for Excel:Global:Processing\|Processing]]~~
	\|-
	~~\|[[Listware for Excel:Global: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}}		{{CustomTOC}}

Admin at 18:38, 16 December 2016

2016-12-16T18:38:48Z

← Older revision		Revision as of 18:38, 16 December 2016
Line 50:		Line 50:
	[[File:LWE_Global_Button.png\|link=]]		[[File:LWE_Global_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 cleansing on a data set with Global Check & Verify.		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 Global Check & Verify.

Admin at 02:06, 13 January 2015

2015-01-13T02:06:55Z

← Older revision		Revision as of 02:06, 13 January 2015
Line 102:		Line 102:
	[[File:LWE_Global_Tutorial_OutputColumns.png\|link=]]		[[File:LWE_Global_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_Global_Tutorial_Reporting.png\|link=]]

			Once you choose what reports you want, click 'next' to continue to the Review Settings step.

Admin at 20:57, 19 September 2014

2014-09-19T20:57:31Z

← Older revision		Revision as of 20:57, 19 September 2014
Line 77:		Line 77:
	==Choose Cleansing Operations==		==Choose Cleansing Operations==
	Choose which cleansing operations you require and specify your country of origin, what type of script to output, and the default country.		Choose which cleansing operations you require and specify your country of origin, what type of script to output, and the default country.

			For more information on Melissa Data Credits, please see [http://www.melissadata.com/dqt/credit-summary.htm Credit Costs].

	[[File:LWE_Global_Tutorial_Operations.png\|link=]]		[[File:LWE_Global_Tutorial_Operations.png\|link=]]

Admin at 22:23, 16 September 2014

2014-09-16T22:23:42Z

← Older revision		Revision as of 22:23, 16 September 2014
Line 86:		Line 86:
	Specify the input columns you want to process.		Specify the input columns you want to process.

	For example, if your data has Address Line 1, Locality, Admin Area, and Postal Code, you should map these columns by selecting the column in the drop-down boxes next to its corresponding column..		For example, if your data has Address Line 1, Locality, Admin Area, and Postal Code, you should map these columns by selecting the column in the drop-down boxes next to its corresponding column.

	[[File:LWE_Global_Tutorial_InputColumns.png\|link=]]		[[File:LWE_Global_Tutorial_InputColumns.png\|link=]]

Admin at 21:42, 15 September 2014

2014-09-15T21:42:10Z

← Older revision		Revision as of 21:42, 15 September 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| 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;"\|'''Global Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Global Check and Verify Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
			\|-
			\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:Global\|Overview]]		\|[[Listware for Excel:Global\|Overview]]

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

2014-07-07T17:47:10Z

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;"|'''Global Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Listware for Excel:Global|Overview]]
|-
|[[Listware for Excel:Global Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:Global:Processing Range|Processing Range]]
|-
|[[Listware for Excel:Global:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:Global:Input Columns|Input Columns]]
|-
|[[Listware for Excel:Global:Output Columns|Output Columns]]
|-
|[[Listware for Excel:Global:Reporting|Reporting]]
|-
|[[Listware for Excel:Global:Review Settings|Review Settings]]
|-
|[[Listware for Excel:Global:Processing|Processing]]
|-
|[[Listware for Excel:Global: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_Global_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 cleansing on a data set with Global Check & Verify.

==Open a Spreadsheet==
Open a spreadsheet containing your data in Excel.

To process global addresses you must specify an input country column in your data OR designate a default country in the [[#Choose Cleansing Operations|Cleansing Operations]] step.

==Select Global==
Select the Listware Ribbon followed by the Global Check & Verify button.

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

The Global 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.

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

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 and specify your country of origin, what type of script to output, and the default country.

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

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 Address Line 1, Locality, Admin Area, and Postal Code, you should map these columns by selecting the column in the drop-down boxes next to its corresponding column..

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

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.

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

Once your output data has been chosen, 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.

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

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.

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

*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.

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

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

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

[[Category:Listware for Excel]]