Melissa Data Wiki - User contributions [en]

Listware for Excel:Similar Solutions

2014-10-22T12:48:44Z

Tim: /* Only In Listware */

[[Listware for Excel|← Listware for Excel]]
{{CustomTOC}}

==Similar Solutions==
;[[API|Data Quality Suite]]
:Individual Address, Name, Phone, Email Object programmers libraries or Suite.

;[[Web Services|Personator and Global Web Services]]
:Contact data verification callable web service from various protocols.

;[[MAILERS+4|MAILERS+4 Software]]
:Desktop CASS, PAVE, Deduping.

;[[SSIS:Data Quality Components|ETL SSIS Components]]
:Contact data verification for Enterprise customers.

;[[Express Entry]]
:Real-time data entry with auto-complete and verification of US addresses.

==Personator Options Not Available in Listware==
The following options are Personator options not available in Listware for Excel, along with how Listware for Excel is set.

;Name options (set to default):
:*NameHint (set to 'Varying')
:*GenderPopulation (set to 'Mixed')
:*GenderAggression (set to 'Neutral')
:*MiddleNameLogic (set to 'ParseLogic')
:*SalutationFormat (set to 'Formal')
:*CorrectFirstName (set to 'On')
:*StandardizeCompany (set to 'On')

;Address options:
:*UsePreferredCity (set to 'On')
:*AdvancedAddressCorrection (set to 'On')
:*Address option Diacritics are set to it's default value ('Auto').

;Email options (set to default):
:*CorrectSyntax (set to 'On')
:*UpdateDomain (set to 'On')
:*DatabaseLookup (set to 'On')
:*StandardizeCasing (set to 'On')

;Verify option:
:*CentricHint (set to default: Auto)

;Append option:
:*Append is set to 'Blank'.

==Not Available in Listware==
*NS02, NS05, NS06, NS07 and NS08 codes are suppressed.
*No detailed phone properties are available in Listware.
*No detailed e-mail properites are available in Listware.
*The user cannot GeoCode using only an Address Key (ie, he must provide a full address).
*No .cfg override
*Input/Output properties: The underlying services (see individual product pages) offer more options

==Only In Listware==
*Result Codes - default behavior (Settings > Add-in Options) is to suppress 'Good' Result Codes
*Parsed Result Code fields
:*SSIS lets you set a filter by code
:*Web service returns one output Result Code property which must programmatically parse
*Summary report of credits consumed, number of records successfully verified for each operation
*Flexible on demand credit payment system

[[Category:Listware for Excel]]

Listware for Excel:Download & Updates

2014-09-25T20:13:51Z

Tim:

*To Get Started, and learn about setting up an account, see [http://www.melissadata.com/webhelp/listware/excel/index.htm Listware for Excel Web Help]

*Updates to the most recent version can be found here...

[ftp://ftp.melissadata.com/Updates/ListwareForExcelSetup.msi ftp.melissadata.com/Updates/ListwareForExcelSetup.msi]

...remember, you can always update directly from Listware > Settings > Check for Updates

[[Listware for Excel| Back to Listware for Excel Main Page]]

Listware for Excel:Download & Updates

2014-09-25T20:13:38Z

Tim:

Listware for Excel

2014-09-25T20:12:38Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
A complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, Global Check & Verify, SmartMover NCOA and Express Entry
* '''New Release:''' Smartmover (NCOA) Change of Address, Express Entry: Validated Suites. See [[Listware for Excel:Build History|Build History]].
* MatchUp® record deduping currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released Sept 23, 2014
<br>Build 1.0.0.2429
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:PRICE CHANGE FOR MOVE UPDATE|'''Price Change''']]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel

2014-09-25T20:11:59Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
A complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, Global Check & Verify, SmartMover NCOA and Express Entry
* '''New Release:''' Smartmover (NCOA) Change of Address, Express Entry: Validated Suites. See [[Listware for Excel:Build History|Build History]].
* MatchUp® record deduping currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released Sept 23, 2014
<br>Build 1.0.0.2429
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:PRICE CHANGE FOR MOVE UPDATE|'''Price Change''']]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates to the Latest Version]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel:Issues

2014-09-25T20:09:45Z

Tim:

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==Check for Updates Link==
The latest version introduced a hidden update link <br>
'''Get the latest version of Listware for Excel''' [ftp://ftp.melissadata.com/updates/ListwareForExcelSetup.msi here].

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. <br>
As of build 2428 we are no longer officially supporting installations on win XP, as Microsoft is no longer supporting the OS. <br>

See [http://www.microsoft.com/en-us/windows/enterprise/end-of-support.aspx End of Support XP] for details

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:Issues

2014-09-25T18:55:38Z

Tim: /* XP Installation */

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. <br>
As of build 2428 we are no longer officailly supporting installations on win XP, as microsoft is no longer supporting the OS. <br>

See [http://www.microsoft.com/en-us/windows/enterprise/end-of-support.aspx End of Support XP] for details

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:Build History

2014-09-25T18:48:21Z

Tim:

[[Listware for Excel|Back to Listware for Excel Main Page]]

'''Get the latest version of Listware for Excel''' [ftp://ftp.melissadata.com/updates/ListwareForExcelSetup.msi here].

{{CustomTOC}}

==Build 1.0.1.2429==
''Released Sept 23, 2014''
* Fixed an issue with not being able to click the update link.
* Added SmartMover module.
* Updated ExpressEntry to use new web service features - Suite validation.
* Added 'Suppress 0 Counts' to all reporting options.
* Cosmetic changes to processing screens and result code descriptions.
* Removed latitude/longitude from analyzer panel (US & Global Check & Verify).
* Background color of problem fields shaded in red (US & Global Check & Verify).
* Updated list of transmission result codes and explanations.
* Added missing VR10, VS01, VS31 and VS41 result codes (US Check & Verify).
* Added German localization to GlobalVerify.

==Build 1.0.1.2405==
''Released July 16, 2014''
* Fixed display anomaly on Setting screen where user's ID and credit balance wouldn't appear.

==Build 1.0.1.2395==
''Released July 03, 2014''
* Added Spanish localization.
* Added 'Support' ribbon menu.
* Changed installer to set permissions on "ProgramData/Melissa Data/Listware for Excel" to 'Everyone'.
* Result Code changes: Global GS05 suppressed if 'Suppress Good Results' is checked.
* Result Code changes: Global AC15, AC16 and AC17 added to report.
* Result Code changes: NS02 now suppressed (handled by current error codes).
* Improved navigation for starting and closing components

==Build 1.0.1.2345==
''Released March 21, 2014''
* First public release of ExpressEntry.
* Express Entry charges 1 credits per successful Zip+4 address completed and entered.
* US/Global Verify: Added reporting (optional and configurable) sheet
* US/Global Verify: Added automatic loading of old settings from previously run reports.
* US Verify: Added many new Additional Address, Census and Parsed Address Output fields.

==Build 1.0.0.2314==
''Released February 06, 2014''
* Added a 'don't show me again' button to summary screen.
* US & Global Verify: 'Check' operation is now always on and Read-only.
* US & Global Verify: Removed GeoLocation operation, not connected to Lat/Long output control.
* Email append is now functional
* Global Verify: Added Output Address options.
* Global Verify: Added individual output address fields.

==Build 1.0.0.2288==
''Released November 21, 2013''
*Updated EULA.
*Combined Output Latitude & Longitude into a single prompt.
*Misc. bug fixes

==Build 1.0.0.2262==
''Released November 2013''

*Made the 'Processing Complete' dialog get it's own icon in the Windows Tray to make it easier to find after long runs.
*Misc. bug fixes

;Processing

:*Added 50k row per session processing limit.
:*User is now prompted to save changes before processing.

;GUI

:*Simplified Introduction screen.
:*Improved communication error reporting.
:*Added a few messages to better direct user about Proxy settings.
:*Added 'Refresh' button to US & Global setup screens to let user update credit totals.
:*Minor rephrasing of GeoCode option on some prompts to avoid confusion.
:*Feedback link now passes back version number and customer Id as URL parameters.
:*Added a 'Proxy Setup' button to Introduction panel so proxy users could set those settings and get their ID approved.

;US

:*'Append Name' relabeled to 'Append Name/Company' in many locations to eliminate user confusion.

;Settings

:*Added a port button to proxy settings (previously users could specify the port with a colon in the URL).

;Processing

:*Changed number of simultaneous threads to 2.

;Installer

:*Added file signing step to avoid 'Unknown publisher' issues.

==Build 1.0.0.2246==
''Released September 2013''

*Now using live URL.

==Build 1.0.0.2214==
''Released July 2013''

*Initial Release

[[Listware for Excel|Back to Listware for Excel Main Page]]
[[Category:Build History]]
[[Category:Listware for Excel]]

Listware for Excel:Build History

2014-09-25T18:47:14Z

Tim:

[[Listware for Excel|Back to Listware for Excel Main Page]]

'''Get the latest version of Listware for Excel''' [ftp://ftp.melissadata.com/updates/ListwareForExcelSetup-1.0.1.2429.msi here].

{{CustomTOC}}

==Build 1.0.1.2429==
''Released Sept 23, 2014''
* Fixed an issue with not being able to click the update link.
* Added SmartMover module.
* Updated ExpressEntry to use new web service features - Suite validation.
* Added 'Suppress 0 Counts' to all reporting options.
* Cosmetic changes to processing screens and result code descriptions.
* Removed latitude/longitude from analyzer panel (US & Global Check & Verify).
* Background color of problem fields shaded in red (US & Global Check & Verify).
* Updated list of transmission result codes and explanations.
* Added missing VR10, VS01, VS31 and VS41 result codes (US Check & Verify).
* Added German localization to GlobalVerify.

==Build 1.0.1.2405==
''Released July 16, 2014''
* Fixed display anomaly on Setting screen where user's ID and credit balance wouldn't appear.

==Build 1.0.1.2395==
''Released July 03, 2014''
* Added Spanish localization.
* Added 'Support' ribbon menu.
* Changed installer to set permissions on "ProgramData/Melissa Data/Listware for Excel" to 'Everyone'.
* Result Code changes: Global GS05 suppressed if 'Suppress Good Results' is checked.
* Result Code changes: Global AC15, AC16 and AC17 added to report.
* Result Code changes: NS02 now suppressed (handled by current error codes).
* Improved navigation for starting and closing components

==Build 1.0.1.2345==
''Released March 21, 2014''
* First public release of ExpressEntry.
* Express Entry charges 1 credits per successful Zip+4 address completed and entered.
* US/Global Verify: Added reporting (optional and configurable) sheet
* US/Global Verify: Added automatic loading of old settings from previously run reports.
* US Verify: Added many new Additional Address, Census and Parsed Address Output fields.

==Build 1.0.0.2314==
''Released February 06, 2014''
* Added a 'don't show me again' button to summary screen.
* US & Global Verify: 'Check' operation is now always on and Read-only.
* US & Global Verify: Removed GeoLocation operation, not connected to Lat/Long output control.
* Email append is now functional
* Global Verify: Added Output Address options.
* Global Verify: Added individual output address fields.

==Build 1.0.0.2288==
''Released November 21, 2013''
*Updated EULA.
*Combined Output Latitude & Longitude into a single prompt.
*Misc. bug fixes

==Build 1.0.0.2262==
''Released November 2013''

*Made the 'Processing Complete' dialog get it's own icon in the Windows Tray to make it easier to find after long runs.
*Misc. bug fixes

;Processing

:*Added 50k row per session processing limit.
:*User is now prompted to save changes before processing.

;GUI

:*Simplified Introduction screen.
:*Improved communication error reporting.
:*Added a few messages to better direct user about Proxy settings.
:*Added 'Refresh' button to US & Global setup screens to let user update credit totals.
:*Minor rephrasing of GeoCode option on some prompts to avoid confusion.
:*Feedback link now passes back version number and customer Id as URL parameters.
:*Added a 'Proxy Setup' button to Introduction panel so proxy users could set those settings and get their ID approved.

;US

:*'Append Name' relabeled to 'Append Name/Company' in many locations to eliminate user confusion.

;Settings

:*Added a port button to proxy settings (previously users could specify the port with a colon in the URL).

;Processing

:*Changed number of simultaneous threads to 2.

;Installer

:*Added file signing step to avoid 'Unknown publisher' issues.

==Build 1.0.0.2246==
''Released September 2013''

*Now using live URL.

==Build 1.0.0.2214==
''Released July 2013''

*Initial Release

[[Listware for Excel|Back to Listware for Excel Main Page]]
[[Category:Build History]]
[[Category:Listware for Excel]]

Listware for Excel:Build History

2014-09-25T18:46:01Z

Tim:

[[Listware for Excel|Back to Listware for Excel Main Page]]

Get the latest version of Listware for Excel, [ftp://ftp.melissadata.com/updates/ListwareForExcelSetup-1.0.1.2429.msi download this update here].

{{CustomTOC}}

==Build 1.0.1.2429==
''Released Sept 23, 2014''
* Fixed an issue with not being able to click the update link.
* Added SmartMover module.
* Updated ExpressEntry to use new web service features - Suite validation.
* Added 'Suppress 0 Counts' to all reporting options.
* Cosmetic changes to processing screens and result code descriptions.
* Removed latitude/longitude from analyzer panel (US & Global Check & Verify).
* Background color of problem fields shaded in red (US & Global Check & Verify).
* Updated list of transmission result codes and explanations.
* Added missing VR10, VS01, VS31 and VS41 result codes (US Check & Verify).
* Added German localization to GlobalVerify.

==Build 1.0.1.2405==
''Released July 16, 2014''
* Fixed display anomaly on Setting screen where user's ID and credit balance wouldn't appear.

==Build 1.0.1.2395==
''Released July 03, 2014''
* Added Spanish localization.
* Added 'Support' ribbon menu.
* Changed installer to set permissions on "ProgramData/Melissa Data/Listware for Excel" to 'Everyone'.
* Result Code changes: Global GS05 suppressed if 'Suppress Good Results' is checked.
* Result Code changes: Global AC15, AC16 and AC17 added to report.
* Result Code changes: NS02 now suppressed (handled by current error codes).
* Improved navigation for starting and closing components

==Build 1.0.1.2345==
''Released March 21, 2014''
* First public release of ExpressEntry.
* Express Entry charges 1 credits per successful Zip+4 address completed and entered.
* US/Global Verify: Added reporting (optional and configurable) sheet
* US/Global Verify: Added automatic loading of old settings from previously run reports.
* US Verify: Added many new Additional Address, Census and Parsed Address Output fields.

==Build 1.0.0.2314==
''Released February 06, 2014''
* Added a 'don't show me again' button to summary screen.
* US & Global Verify: 'Check' operation is now always on and Read-only.
* US & Global Verify: Removed GeoLocation operation, not connected to Lat/Long output control.
* Email append is now functional
* Global Verify: Added Output Address options.
* Global Verify: Added individual output address fields.

==Build 1.0.0.2288==
''Released November 21, 2013''
*Updated EULA.
*Combined Output Latitude & Longitude into a single prompt.
*Misc. bug fixes

==Build 1.0.0.2262==
''Released November 2013''

*Made the 'Processing Complete' dialog get it's own icon in the Windows Tray to make it easier to find after long runs.
*Misc. bug fixes

;Processing

:*Added 50k row per session processing limit.
:*User is now prompted to save changes before processing.

;GUI

:*Simplified Introduction screen.
:*Improved communication error reporting.
:*Added a few messages to better direct user about Proxy settings.
:*Added 'Refresh' button to US & Global setup screens to let user update credit totals.
:*Minor rephrasing of GeoCode option on some prompts to avoid confusion.
:*Feedback link now passes back version number and customer Id as URL parameters.
:*Added a 'Proxy Setup' button to Introduction panel so proxy users could set those settings and get their ID approved.

;US

:*'Append Name' relabeled to 'Append Name/Company' in many locations to eliminate user confusion.

;Settings

:*Added a port button to proxy settings (previously users could specify the port with a colon in the URL).

;Processing

:*Changed number of simultaneous threads to 2.

;Installer

:*Added file signing step to avoid 'Unknown publisher' issues.

==Build 1.0.0.2246==
''Released September 2013''

*Now using live URL.

==Build 1.0.0.2214==
''Released July 2013''

*Initial Release

[[Listware for Excel|Back to Listware for Excel Main Page]]
[[Category:Build History]]
[[Category:Listware for Excel]]

Issues:StyleList

2014-09-25T18:42:14Z

Tim:

{{CustomTOC}}
[[StyleList|Back to StyleList Main Page]]

==Installation / Running Issues==
===Operating System Compatability===
My version of StyleList will not run on Windows Server 20xx?
This version of StyleList was created with a compiler before this operating system was released and may have an OS compatability issue. Go to the Compatibility section (right click on the StyleList icon > Properties > Compatibility tab).... and select ‘Run this program in compatibility mode for …’ and choose an earlier operating system like Windows 2000 or Windows 98.

===Operating System Data Access Prevention===
My version of StyleList will not run on Windows Server 20xx?
Newer operating systems sometimes prevent older applications from running in what is called Data Execution Prevention. Try changing the DEP settings via
Start > Control Panel > System > Advanced > Performance > Data Execution Prevention...
And select ‘Turn on DEP for all programs except…’ then ‘Add’ your StyleList executable.

===Unknown Application or Program Files Not Found===
My StyleList is not recognized when I try to run…
1. select Control Panel > Appearance and Personalization > Folder Options
2. View > uncheck Hide extensions from known folder types

===UAC issues===

1.First Try – Right Click MatchUp shortcut and select Run As Admin. Alternately,…

To configure an application to always run elevated
A. Right-click an application that is not likely to have been assigned an administrative token, such as a word processing application.
B. Click Properties, and then select the Compatibility tab.
C. Under Privilege Level, select Run this program as an administrator, and then click OK.

2.Change your UAC settings…

A. Click Start, and then click Control Panel.
B. In Control Panel, click User Accounts.
C. In the User Accounts window, click User Accounts.
D. In the User Accounts tasks window, click Turn User Account Control on or off. or Change User Account Control settings
E. Lower the security (notify) setting

===Installation Location===
You can also try installing outside the c:\program files folder – like directly on the c drive, or even better another drive like d:\SL\

==Processing Issues==
===Phone data type===
*Input phone patterns with slashes do not process correctly. The Output phone is left unchanged.

===Company data type===
*4 letter last names are returned UPPER cased, like they’re acronyms. These are words not in either Company lookup table, which may be present in a company ( i.e. A law firm ‘Brown, Best & Byle LLC’ returns ‘Brown, Best & BYLE, LLC’.

===CSZ data type===
*Cities which are also a State get abbreviated when processing City State Zip data.

<pre>Ex. Washington, GA > Wa, Ga
Washington, Georgia > Washington, Georgia</pre>

===Name data type===
*Punctuation does not get added to a middle initial ‘O’ ( ‘O’ gets a special treatment in processing in its attempt to recognize ‘Irish’ formatted last names ).

<pre>Ex. John N Smith > John N. Smith
John O Smith > John O Smith</pre>

===Add Punctuation===
*Does not work if you choose ‘No casing’ ( the casing option overrides the add punctuation option ).

<pre>Ex. DR SMITH > DR SMITH
Dr. Smith > Dr. Smith </pre>

===CSZ data type===
*The “New York” in “Anytown, New York 11111” does not get abbreviated for a target size 22, but “Anytown, Georgia 11111” does.

===Expand: Address data type===
*A street address entry with an ampersand causes one of the few words which have a 'start / end' flag in the lookup table to get processed incorrectly. Start / End means that it is a word which has a different expansion for its location. St at the start of an address field is more likely to be 'Saint', at the end 'Street'.

<pre>Ex. 21st. & St. Louis St. > 21st Street Louis Street
2 St. Louis St. > 2 St Louis Street</pre>

===Analyze===
*If you are sitting on the last record, and you select either of the ‘Next’ edit buttons, the program will crash.

===Tools===
*If you select ‘Any Field’ on the ‘Locate Again’ tool, the program will crash.

[[Category:Issues]]
[[Category:StyleList]]

Issues:StyleList

2014-09-25T18:40:58Z

Tim: /* Name data type */

{{CustomTOC}}
[[StyleList|Back to StyleList Main Page]]

==Installation / Running Issues==
===Operating System Compatability===
My version of StyleList will not run on Windows Server 20xx?
This version of StyleList was created with a compiler before this operating system was released and may have an OS compatability issue. Go to the Compatibility section (right click on the StyleList icon > Properties > Compatibility tab).... and select ‘Run this program in compatibility mode for …’ and choose an earlier operating system like Windows 2000 or Windows 98.

===Operating System Data Access Prevention===
My version of StyleList will not run on Windows Server 20xx?
Newer operating systems sometimes prevent older applications from running in what is called Data Execution Prevention. Try changing the DEP settings via
Start > Control Panel > System > Advanced > Performance > Data Execution Prevention...
And select ‘Turn on DEP for all programs except…’ then ‘Add’ your StyleList executable.

===Unknown Application or Program Files Not Found===
My StyleList is not recognized when I try to run…
1. select Control Panel > Appearance and Personalization > Folder Options
2. View > uncheck Hide extensions from known folder types

===UAC issues===

1.First Try – Right Click MatchUp shortcut and select Run As Admin. Alternately,…

To configure an application to always run elevated
A. Right-click an application that is not likely to have been assigned an administrative token, such as a word processing application.
B. Click Properties, and then select the Compatibility tab.
C. Under Privilege Level, select Run this program as an administrator, and then click OK.

2.Change your UAC settings…

A. Click Start, and then click Control Panel.
B. In Control Panel, click User Accounts.
C. In the User Accounts window, click User Accounts.
D. In the User Accounts tasks window, click Turn User Account Control on or off. or Change User Account Control settings
E. Lower the security (notify) setting

===Installation Location===
You can also try installing outside the c:\program files folder – like directly on the c drive, or even better another drive like d:\SL\

==Processing Issues==
===Phone data type===
*Input phone patterns with slashes do not process correctly. The Output phone is left unchanged.

===Company data type===
*4 letter last names are returned UPPER cased, like they’re acronyms. These are words not in either Company lookup table, which may be present in a company ( i.e. A law firm ‘Brown, Best & Byle LLC’ returns ‘Brown, Best & BYLE, LLC’.

===CSZ data type===
*Cities which are also a State get abbreviated when processing City State Zip data.

<pre>Ex. Washington, GA > Wa, Ga
Washington, Georgia > Washington, Georgia</pre>

===Name data type===
*Punctuation does not get added to a middle initial ‘O’ ( ‘O’ gets a special treatment in processing in its attempt to recognize ‘Irish’ formatted last names ).

<pre>Ex. John N Smith > John N. Smith
John O Smith > John O Smith</pre>

===Add Punctuation===
*Does not work if you choose ‘No casing’ ( the casing option overrides the add punctuation option ).

<pre>Ex. DR SMITHà DR SMITH
Dr. Smithà Dr. Smith </pre>

===CSZ data type===
*The “New York” in “Anytown, New York 11111” does not get abbreviated for a target size 22, but “Anytown, Georgia 11111” does.

===Expand: Address data type===
*A street address entry with an ampersand causes one of the few words which have a 'start / end' flag in the lookup table to get processed incorrectly. Start / End means that it is a word which has a different expansion for its location. St at the start of an address field is more likely to be 'Saint', at the end 'Street'.

<pre>Ex. 21st. & St. Louis St. à 21st Street Louis Street
2 St. Louis St. à 2 St Louis Street</pre>

===Analyze===
*If you are sitting on the last record, and you select either of the ‘Next’ edit buttons, the program will crash.

===Tools===
*If you select ‘Any Field’ on the ‘Locate Again’ tool, the program will crash.

[[Category:Issues]]
[[Category:StyleList]]

Issues:StyleList

2014-09-25T18:40:34Z

Tim: /* CSZ data type */

{{CustomTOC}}
[[StyleList|Back to StyleList Main Page]]

==Installation / Running Issues==
===Operating System Compatability===
My version of StyleList will not run on Windows Server 20xx?
This version of StyleList was created with a compiler before this operating system was released and may have an OS compatability issue. Go to the Compatibility section (right click on the StyleList icon > Properties > Compatibility tab).... and select ‘Run this program in compatibility mode for …’ and choose an earlier operating system like Windows 2000 or Windows 98.

===Operating System Data Access Prevention===
My version of StyleList will not run on Windows Server 20xx?
Newer operating systems sometimes prevent older applications from running in what is called Data Execution Prevention. Try changing the DEP settings via
Start > Control Panel > System > Advanced > Performance > Data Execution Prevention...
And select ‘Turn on DEP for all programs except…’ then ‘Add’ your StyleList executable.

===Unknown Application or Program Files Not Found===
My StyleList is not recognized when I try to run…
1. select Control Panel > Appearance and Personalization > Folder Options
2. View > uncheck Hide extensions from known folder types

===UAC issues===

1.First Try – Right Click MatchUp shortcut and select Run As Admin. Alternately,…

To configure an application to always run elevated
A. Right-click an application that is not likely to have been assigned an administrative token, such as a word processing application.
B. Click Properties, and then select the Compatibility tab.
C. Under Privilege Level, select Run this program as an administrator, and then click OK.

2.Change your UAC settings…

A. Click Start, and then click Control Panel.
B. In Control Panel, click User Accounts.
C. In the User Accounts window, click User Accounts.
D. In the User Accounts tasks window, click Turn User Account Control on or off. or Change User Account Control settings
E. Lower the security (notify) setting

===Installation Location===
You can also try installing outside the c:\program files folder – like directly on the c drive, or even better another drive like d:\SL\

==Processing Issues==
===Phone data type===
*Input phone patterns with slashes do not process correctly. The Output phone is left unchanged.

===Company data type===
*4 letter last names are returned UPPER cased, like they’re acronyms. These are words not in either Company lookup table, which may be present in a company ( i.e. A law firm ‘Brown, Best & Byle LLC’ returns ‘Brown, Best & BYLE, LLC’.

===CSZ data type===
*Cities which are also a State get abbreviated when processing City State Zip data.

<pre>Ex. Washington, GA > Wa, Ga
Washington, Georgia > Washington, Georgia</pre>

===Name data type===
*Punctuation does not get added to a middle initial ‘O’ ( ‘O’ gets a special treatment in processing in its attempt to recognize ‘Irish’ formatted last names ).

<pre>Ex. John N Smith à John N. Smith
John O Smith à John O Smith</pre>

===Add Punctuation===
*Does not work if you choose ‘No casing’ ( the casing option overrides the add punctuation option ).

<pre>Ex. DR SMITHà DR SMITH
Dr. Smithà Dr. Smith </pre>

===CSZ data type===
*The “New York” in “Anytown, New York 11111” does not get abbreviated for a target size 22, but “Anytown, Georgia 11111” does.

===Expand: Address data type===
*A street address entry with an ampersand causes one of the few words which have a 'start / end' flag in the lookup table to get processed incorrectly. Start / End means that it is a word which has a different expansion for its location. St at the start of an address field is more likely to be 'Saint', at the end 'Street'.

<pre>Ex. 21st. & St. Louis St. à 21st Street Louis Street
2 St. Louis St. à 2 St Louis Street</pre>

===Analyze===
*If you are sitting on the last record, and you select either of the ‘Next’ edit buttons, the program will crash.

===Tools===
*If you select ‘Any Field’ on the ‘Locate Again’ tool, the program will crash.

[[Category:Issues]]
[[Category:StyleList]]

Issues:StyleList

2014-09-25T18:39:57Z

Tim: /* CSZ data type */

{{CustomTOC}}
[[StyleList|Back to StyleList Main Page]]

==Installation / Running Issues==
===Operating System Compatability===
My version of StyleList will not run on Windows Server 20xx?
This version of StyleList was created with a compiler before this operating system was released and may have an OS compatability issue. Go to the Compatibility section (right click on the StyleList icon > Properties > Compatibility tab).... and select ‘Run this program in compatibility mode for …’ and choose an earlier operating system like Windows 2000 or Windows 98.

===Operating System Data Access Prevention===
My version of StyleList will not run on Windows Server 20xx?
Newer operating systems sometimes prevent older applications from running in what is called Data Execution Prevention. Try changing the DEP settings via
Start > Control Panel > System > Advanced > Performance > Data Execution Prevention...
And select ‘Turn on DEP for all programs except…’ then ‘Add’ your StyleList executable.

===Unknown Application or Program Files Not Found===
My StyleList is not recognized when I try to run…
1. select Control Panel > Appearance and Personalization > Folder Options
2. View > uncheck Hide extensions from known folder types

===UAC issues===

1.First Try – Right Click MatchUp shortcut and select Run As Admin. Alternately,…

To configure an application to always run elevated
A. Right-click an application that is not likely to have been assigned an administrative token, such as a word processing application.
B. Click Properties, and then select the Compatibility tab.
C. Under Privilege Level, select Run this program as an administrator, and then click OK.

2.Change your UAC settings…

A. Click Start, and then click Control Panel.
B. In Control Panel, click User Accounts.
C. In the User Accounts window, click User Accounts.
D. In the User Accounts tasks window, click Turn User Account Control on or off. or Change User Account Control settings
E. Lower the security (notify) setting

===Installation Location===
You can also try installing outside the c:\program files folder – like directly on the c drive, or even better another drive like d:\SL\

==Processing Issues==
===Phone data type===
*Input phone patterns with slashes do not process correctly. The Output phone is left unchanged.

===Company data type===
*4 letter last names are returned UPPER cased, like they’re acronyms. These are words not in either Company lookup table, which may be present in a company ( i.e. A law firm ‘Brown, Best & Byle LLC’ returns ‘Brown, Best & BYLE, LLC’.

===CSZ data type===
*Cities which are also a State get abbreviated when processing City State Zip data.

<pre>Ex. Washington, GA à Wa, Ga
Washington, Georgia à Washington, Georgia</pre>

===Name data type===
*Punctuation does not get added to a middle initial ‘O’ ( ‘O’ gets a special treatment in processing in its attempt to recognize ‘Irish’ formatted last names ).

<pre>Ex. John N Smith à John N. Smith
John O Smith à John O Smith</pre>

===Add Punctuation===
*Does not work if you choose ‘No casing’ ( the casing option overrides the add punctuation option ).

<pre>Ex. DR SMITHà DR SMITH
Dr. Smithà Dr. Smith </pre>

===CSZ data type===
*The “New York” in “Anytown, New York 11111” does not get abbreviated for a target size 22, but “Anytown, Georgia 11111” does.

===Expand: Address data type===
*A street address entry with an ampersand causes one of the few words which have a 'start / end' flag in the lookup table to get processed incorrectly. Start / End means that it is a word which has a different expansion for its location. St at the start of an address field is more likely to be 'Saint', at the end 'Street'.

<pre>Ex. 21st. & St. Louis St. à 21st Street Louis Street
2 St. Louis St. à 2 St Louis Street</pre>

===Analyze===
*If you are sitting on the last record, and you select either of the ‘Next’ edit buttons, the program will crash.

===Tools===
*If you select ‘Any Field’ on the ‘Locate Again’ tool, the program will crash.

[[Category:Issues]]
[[Category:StyleList]]

Listware for Excel:Build History

2014-09-25T18:31:27Z

Tim:

[[Listware for Excel|Back to Listware for Excel Main Page]]

{{CustomTOC}}

==Updating Issue==
The newest version of Listware for Excel fixed an issue with not being able to click the update link. To update to the newest version of Listware for Excel, [ftp://ftp.melissadata.com/updates/ListwareForExcelSetup-1.0.1.2429.msi download this update here].

==Build 1.0.1.2429==
''Released Sept 23, 2014''
* Added SmartMover module.
* Updated ExpressEntry to use new web service features - Suite validation.
* Added 'Suppress 0 Counts' to all reporting options.
* Cosmetic changes to processing screens and result code descriptions.
* Removed latitude/longitude from analyzer panel (US & Global Check & Verify).
* Background color of problem fields shaded in red (US & Global Check & Verify).
* Updated list of transmission result codes and explanations.
* Added missing VR10, VS01, VS31 and VS41 result codes (US Check & Verify).
* Added German localization to GlobalVerify.

==Build 1.0.1.2405==
''Released July 16, 2014''
* Fixed display anomaly on Setting screen where user's ID and credit balance wouldn't appear.

==Build 1.0.1.2395==
''Released July 03, 2014''
* Added Spanish localization.
* Added 'Support' ribbon menu.
* Changed installer to set permissions on "ProgramData/Melissa Data/Listware for Excel" to 'Everyone'.
* Result Code changes: Global GS05 suppressed if 'Suppress Good Results' is checked.
* Result Code changes: Global AC15, AC16 and AC17 added to report.
* Result Code changes: NS02 now suppressed (handled by current error codes).
* Improved navigation for starting and closing components

==Build 1.0.1.2345==
''Released March 21, 2014''
* First public release of ExpressEntry.
* Express Entry charges 1 credits per successful Zip+4 address completed and entered.
* US/Global Verify: Added reporting (optional and configurable) sheet
* US/Global Verify: Added automatic loading of old settings from previously run reports.
* US Verify: Added many new Additional Address, Census and Parsed Address Output fields.

==Build 1.0.0.2314==
''Released February 06, 2014''
* Added a 'don't show me again' button to summary screen.
* US & Global Verify: 'Check' operation is now always on and Read-only.
* US & Global Verify: Removed GeoLocation operation, not connected to Lat/Long output control.
* Email append is now functional
* Global Verify: Added Output Address options.
* Global Verify: Added individual output address fields.

==Build 1.0.0.2288==
''Released November 21, 2013''
*Updated EULA.
*Combined Output Latitude & Longitude into a single prompt.
*Misc. bug fixes

==Build 1.0.0.2262==
''Released November 2013''

*Made the 'Processing Complete' dialog get it's own icon in the Windows Tray to make it easier to find after long runs.
*Misc. bug fixes

;Processing

:*Added 50k row per session processing limit.
:*User is now prompted to save changes before processing.

;GUI

:*Simplified Introduction screen.
:*Improved communication error reporting.
:*Added a few messages to better direct user about Proxy settings.
:*Added 'Refresh' button to US & Global setup screens to let user update credit totals.
:*Minor rephrasing of GeoCode option on some prompts to avoid confusion.
:*Feedback link now passes back version number and customer Id as URL parameters.
:*Added a 'Proxy Setup' button to Introduction panel so proxy users could set those settings and get their ID approved.

;US

:*'Append Name' relabeled to 'Append Name/Company' in many locations to eliminate user confusion.

;Settings

:*Added a port button to proxy settings (previously users could specify the port with a colon in the URL).

;Processing

:*Changed number of simultaneous threads to 2.

;Installer

:*Added file signing step to avoid 'Unknown publisher' issues.

==Build 1.0.0.2246==
''Released September 2013''

*Now using live URL.

==Build 1.0.0.2214==
''Released July 2013''

*Initial Release

[[Listware for Excel|Back to Listware for Excel Main Page]]
[[Category:Build History]]
[[Category:Listware for Excel]]

Listware for Excel:Build History

2014-09-25T18:29:18Z

Tim:

Listware for Excel:Similar Solutions

2014-09-24T13:34:15Z

Tim: /* Not available in Listware */

Updated 07/03/2014

==Similar solutions==
*[[API|Data Quality Suite]] Individual Address, Name, Phone, Email Object programmers libraries or Suite
*[[Web Services|Personator and Global Web Services]] contact data verification callable web service from various protocols
*[[MAILERS+4|MAILERS+4 Software]] desktop CASS, PAVE, Deduping
*[[SSIS:Data Quality Components|ETL SSIS Components]] contact data verification for Enterprise customers
*[[Express Entry]] Real-time data entry with auto-complete and verification of US addresses

==Personator options not available in Listware (and how Listware is set)==
* Name options (set to default):
**NameHint (set to 'Varying')
**GenderPopulation (set to 'Mixed')
**GenderAggression (set to 'Neutral')
**MiddleNameLogic (set to 'ParseLogic')
**SalutationFormat (set to 'Formal')
**CorrectFirstName (set to 'On')
**StandardizeCompany (set to 'On')

* Address options:
**UsePreferredCity (set to 'On')
**AdvancedAddressCorrection (set to 'On')
** Address option Diacritics are set to it's default value ('Auto').

* Email options (set to default):
**CorrectSyntax (set to 'On')
**UpdateDomain (set to 'On')
**DatabaseLookup (set to 'On')
**StandardizeCasing (set to 'On')

* Verify option CentricHint (set to default: Auto)
* Append option Append is set to 'Blank'.

==Not available in Listware==
* NS02, NS05, NS06, NS07 and NS08 codes are suppressed.
* No detailed phone properties are available in Listware.
* No detailed e-mail properites are available in Listware.
* The user cannot GeoCode using only an Address Key (ie, he must provide a full address).
* no .cfg override
* Input/Output properties: The underlying services (see individual product pages) offer more options

==Only In Listware==
*Parsed Result Code fields
** SSIS lets you set a filter by code
** Web service returns one output Result Code property which must programmatically parse
*Summary report of credits consumed, number of records successfully verified for each operation
*Flexible on demand credit payment system

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Similar Solutions

2014-09-24T13:31:33Z

Tim: /* Not available in Listware */

Updated 07/03/2014

==Similar solutions==
*[[API|Data Quality Suite]] Individual Address, Name, Phone, Email Object programmers libraries or Suite
*[[Web Services|Personator and Global Web Services]] contact data verification callable web service from various protocols
*[[MAILERS+4|MAILERS+4 Software]] desktop CASS, PAVE, Deduping
*[[SSIS:Data Quality Components|ETL SSIS Components]] contact data verification for Enterprise customers
*[[Express Entry]] Real-time data entry with auto-complete and verification of US addresses

==Personator options not available in Listware (and how Listware is set)==
* Name options (set to default):
**NameHint (set to 'Varying')
**GenderPopulation (set to 'Mixed')
**GenderAggression (set to 'Neutral')
**MiddleNameLogic (set to 'ParseLogic')
**SalutationFormat (set to 'Formal')
**CorrectFirstName (set to 'On')
**StandardizeCompany (set to 'On')

* Address options:
**UsePreferredCity (set to 'On')
**AdvancedAddressCorrection (set to 'On')
** Address option Diacritics are set to it's default value ('Auto').

* Email options (set to default):
**CorrectSyntax (set to 'On')
**UpdateDomain (set to 'On')
**DatabaseLookup (set to 'On')
**StandardizeCasing (set to 'On')

* Verify option CentricHint (set to default: Auto)
* Append option Append is set to 'Blank'.

==Not available in Listware==
* NS02, NS05, NS06, NS07 and NS08 codes are suppressed.
* No detailed phone properties are available in Listware.
* No detailed e-mail properites are available in Listware.
* The user cannot GeoCode using only an Address Key (ie, he must provide a full address).
* no .cfg override

==Only In Listware==
*Parsed Result Code fields
** SSIS lets you set a filter by code
** Web service returns one output Result Code property which must programmatically parse
*Summary report of credits consumed, number of records successfully verified for each operation
*Flexible on demand credit payment system

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Capabilities

2014-09-23T20:20:01Z

Tim:

<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>

<span style="color:#0000FF">'''Domestic US and Canada''' </span><br>
* '''Check''' - Standardize and correct
** Names
** Addresses
** Phone Numbers
** Email Addresses
** Append Geo-coordinates
* '''SmartMover NCOA''' - check to see if a Name or associated Company has moved to a new address

<span style="color:#0000FF">'''Domestic US only''' </span><br>
* '''Personator Verify''' - correlate the above data types, ie. do they actually belong together

* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

* '''Personator Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

* '''Express Entry'''
** Real time data entry for any field type
** Real time auto-complete and validation for US addresses

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* US Check & Verify State Distribution Summary (US only)
* SmartMover NCOA State & Province Distribution Summary (US & CAN)
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''For International Data (non US or Canada)'''</span> <br>
'''Global Check''' - Standardize and correct
* Addresses
* Append Geo-coordinates

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''In Development'''</span> <br>
'''MatchUp'''
* Record Matching (Are there any duplicate records?)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Capabilities

2014-09-23T20:17:58Z

Tim:

<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>

<span style="color:#0000FF">'''Domestic US and Canada''' </span><br>
* '''Check''' - Standardize and correct
** Names
** Addresses
** Phone Numbers
** Email Addresses
** Append Geo-coordinates
* '''SmartMover NCOA''' - check to see if a Name or associated Company has moved to a new address

<span style="color:#0000FF">'''Domestic US only''' </span><br>
* '''Personator Verify''' - correlate the above data types, ie. do they actually belong together

* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

* '''Personator Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

* '''Express Entry'''
** Real time data entry for any field type
** Real time auto-complete and validation for US addresses

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* US Check & Verify State Distribution Summary (US only)
* SmartMover NCOA State & Province Distribution Summary (US & CAN)
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''For International Data (non US or Canada)'''</span> <br>
'''Global Check''' - Standardize and correct
* Addresses
* Append Geo-coordinates

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* Result Code Summary, Table of total counts for each possible output action

'''In Development''' <br>
'''MatchUp'''
* Record Matching (Are there any duplicate records?)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Capabilities

2014-09-23T19:50:02Z

Tim:

<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>

<span style="color:#0000FF">'''Domestic US and Canada''' </span><br>
* '''Check''' - Standardize and correct
** Names
** Addresses
** Phone Numbers
** Email Addresses
** Append Geo-coordinates
* '''SmartMover NCOA''' - check to see if a Name or associated Company has moved to a new address

<span style="color:#0000FF">'''Domestic US only''' </span><br>
* '''Personator Verify''' - correlate the above data types, ie. do they actually belong together

* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

* '''Personator Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

* '''Express Entry'''
** Real time data entry for any field type
** Real time auto-complete and validation for US addresses

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* State Distribution Summary (US only)
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''For International Data (non US or Canada)'''</span> <br>
'''Global Check''' - Standardize and correct
* Addresses
* Append Geo-coordinates

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* Result Code Summary, Table of total counts for each possible output action

'''In Development''' <br>
'''MatchUp'''
* Record Matching (Are there any duplicate records?)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Capabilities

2014-09-23T19:49:27Z

Tim:

<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>

<span style="color:#0000FF">'''Domestic US and Canada''' </span><br>
* '''Check''' - Standardize and correct
** Names
** Addresses
** Phone Numbers
** Email Addresses
** Append Geo-coordinates
* '''SmartMover NCOA''' - check to see if a Name or associated Company has moved to a new address

<span style="color:#0000FF">'''Domestic US only''' </span><br>
* '''Verify''' - correlate the above data types, ie. do they actually belong together

* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

* '''Express Entry'''
** Real time data entry for any field type
** Real time auto-complete and validation for US addresses

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* State Distribution Summary (US only)
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''For International Data (non US or Canada)'''</span> <br>
'''Global Check''' - Standardize and correct
* Addresses
* Append Geo-coordinates

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* Result Code Summary, Table of total counts for each possible output action

'''In Development''' <br>
'''MatchUp'''
* Record Matching (Are there any duplicate records?)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Capabilities

2014-09-23T19:47:03Z

Tim:

<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>

<span style="color:#0000FF">'''Domestic US and Canada''' </span><br>
* '''Check''' - Standardize and correct
** Names
** Addresses
** Phone Numbers
** Email Addresses
** Append Geo-coordinates

<span style="color:#0000FF">'''Domestic US only''' </span><br>
* '''Verify''' - correlate the above data types, ie. do they actually belong together

* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

* '''Express Entry'''
** Real time data entry for any field type
** Real time auto-complete and validation for US addresses

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* State Distribution Summary (US only)
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''For International Data (non US or Canada)'''</span> <br>
'''Global Check''' - Standardize and correct
* Addresses
* Append Geo-coordinates

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* Result Code Summary, Table of total counts for each possible output action

'''In Development''' <br>
'''MatchUp'''
* Record Matching (Are there any duplicate records?)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Capabilities

2014-09-23T19:46:45Z

Tim:

<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>

<span style="color:#0000FF">'''Domestic US and Canada''' </span><br>
* '''Check''' - Standardize and correct
** Names
** Addresses
** Phone Numbers
** Email Addresses
** Append Geo-coordinates

<span style="color:#0000FF">'''Domestic US only''' </span><br>
* '''Verify''' - correlate the above data types, ie. do they actually belong together

* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

* '''Express Entry''
** Real time data entry for any field type
** Real time auto-complete and validation for US addresses

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* State Distribution Summary (US only)
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''For International Data (non US or Canada)'''</span> <br>
'''Global Check''' - Standardize and correct
* Addresses
* Append Geo-coordinates

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* Result Code Summary, Table of total counts for each possible output action

'''In Development''' <br>
'''MatchUp'''
* Record Matching (Are there any duplicate records?)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Capabilities

2014-09-23T19:45:07Z

Tim:

<h3>See individual product pages' documentation or Result codes for a complete description of capabilities</h3>

<span style="color:#0000FF">'''Domestic US and Canada''' </span><br>
* '''Check''' - Standardize and correct
** Names
** Addresses
** Phone Numbers
** Email Addresses
** Append Geo-coordinates

<span style="color:#0000FF">'''Domestic US only''' </span><br>
* '''Verify''' - correlate the above data types, ie. do they actually belong together

* '''Move''' - check to see if a Name or associated Company has moved to a new address

* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

<span style="color:#0000FF">'''Express Entry'''</span> <br>
* Real time data entry for any field type
* Real time auto-complete and validation for US addresses

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* State Distribution Summary (US only)
* Result Code Summary, Table of total counts for each possible output action

<span style="color:#0000FF">'''For International Data (non US or Canada)'''</span> <br>
'''Global Check''' - Standardize and correct
* Addresses
* Append Geo-coordinates

'''Reporting'''
* Result Codes, the quality and errors associated with each record; appended to each record
* General Processing Summary, the details of processed job
* Processing Results Summary, summary table and charts of each action performed
* Result Code Summary, Table of total counts for each possible output action

'''In Development''' <br>
'''MatchUp'''
* Record Matching (Are there any duplicate records?)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel

2014-09-23T19:32:46Z

Tim:

Listware for Excel

2014-09-23T19:26:37Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
A complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, Global Check & Verify, SmartMover NCOA and Express Entry
* '''New Release:''' Smartmover (NCOA) Change of Address, Express Entry: Validated Suites .
* See [[Listware for Excel:Build History|Build History]] for all changes.
* MatchUp® record deduping currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released Sept 23, 2014
<br>Build 1.0.0.2429
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:PRICE CHANGE FOR MOVE UPDATE|'''Price Change''']]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel

2014-09-23T19:25:49Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
A complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, Global Check & Verify, SmartMover NCOA and Express Entry
* '''New Release:''' Smartmover (NCOA) Change of Address, Express Entry: Validated Suites . See [[Listware for Excel:Build History|Build History]] for all changes.
* MatchUp® record deduping currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released Sept 23, 2014
<br>Build 1.0.0.2429
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:PRICE CHANGE FOR MOVE UPDATE|'''Price Change''']]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel

2014-09-23T19:24:40Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
A complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, Global Check & Verify, SmartMover NCOA and Express Entry
* '''New Release:''' Smartmover (NCOA) Change of Address, Express Entry: Validated Suites . See [[Listware for Excel:Build History|Build History]] for all changes.
* MatchUp® record deduping and SmartMover Change of Address currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released Sept 23, 2014
<br>Build 1.0.0.2429
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:PRICE CHANGE FOR MOVE UPDATE|'''Price Change''']]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel:Build History

2014-09-23T19:22:35Z

Tim:

[[Listware for Excel|Back to Listware for Excel Main Page]]

{{CustomTOC}}

==Build 1.0.1.2429==
''Released Sept 23, 2014''
* Added SmartMover module.
* Updated ExpressEntry to use new web service features - Suite validation.
* Added 'Suppress 0 Counts' to all reporting options.
* Cosmetic changes to processing screens and result code descriptions.
* Removed latitude/longitude from analyzer panel (US & Global Check & Verify).
* Background color of problem fields shaded in red (US & Global Check & Verify).
* Updated list of transmission result codes and explanations.
* Added missing VR10, VS01, VS31 and VS41 result codes (US Check & Verify).
* Added German localization to GlobalVerify.

==Build 1.0.1.2405==
''Released July 16, 2014''
* Fixed display anomaly on Setting screen where user's ID and credit balance wouldn't appear.

==Build 1.0.1.2395==
''Released July 03, 2014''
* Added Spanish localization.
* Added 'Support' ribbon menu.
* Changed installer to set permissions on "ProgramData/Melissa Data/Listware for Excel" to 'Everyone'.
* Result Code changes: Global GS05 suppressed if 'Suppress Good Results' is checked.
* Result Code changes: Global AC15, AC16 and AC17 added to report.
* Result Code changes: NS02 now suppressed (handled by current error codes).
* Improved navigation for starting and closing components

==Build 1.0.1.2345==
''Released March 21, 2014''
* First public release of ExpressEntry.
* Express Entry charges 1 credits per successful Zip+4 address completed and entered.
* US/Global Verify: Added reporting (optional and configurable) sheet
* US/Global Verify: Added automatic loading of old settings from previously run reports.
* US Verify: Added many new Additional Address, Census and Parsed Address Output fields.

==Build 1.0.0.2314==
''Released February 06, 2014''
* Added a 'don't show me again' button to summary screen.
* US & Global Verify: 'Check' operation is now always on and Read-only.
* US & Global Verify: Removed GeoLocation operation, not connected to Lat/Long output control.
* Email append is now functional
* Global Verify: Added Output Address options.
* Global Verify: Added individual output address fields.

==Build 1.0.0.2288==
''Released November 21, 2013''
*Updated EULA.
*Combined Output Latitude & Longitude into a single prompt.
*Misc. bug fixes

==Build 1.0.0.2262==
''Released November 2013''

*Made the 'Processing Complete' dialog get it's own icon in the Windows Tray to make it easier to find after long runs.
*Misc. bug fixes

;Processing

:*Added 50k row per session processing limit.
:*User is now prompted to save changes before processing.

;GUI

:*Simplified Introduction screen.
:*Improved communication error reporting.
:*Added a few messages to better direct user about Proxy settings.
:*Added 'Refresh' button to US & Global setup screens to let user update credit totals.
:*Minor rephrasing of GeoCode option on some prompts to avoid confusion.
:*Feedback link now passes back version number and customer Id as URL parameters.
:*Added a 'Proxy Setup' button to Introduction panel so proxy users could set those settings and get their ID approved.

;US

:*'Append Name' relabeled to 'Append Name/Company' in many locations to eliminate user confusion.

;Settings

:*Added a port button to proxy settings (previously users could specify the port with a colon in the URL).

;Processing

:*Changed number of simultaneous threads to 2.

;Installer

:*Added file signing step to avoid 'Unknown publisher' issues.

==Build 1.0.0.2246==
''Released September 2013''

*Now using live URL.

==Build 1.0.0.2214==
''Released July 2013''

*Initial Release

[[Listware for Excel|Back to Listware for Excel Main Page]]
[[Category:Build History]]
[[Category:Listware for Excel]]

Listware for Excel:Build History

2014-09-23T19:21:50Z

Tim:

[[Listware for Excel|Back to Listware for Excel Main Page]]

{{CustomTOC}}

==Build 1.0.1.2429==
''Released Sept 23, 2014''
* Added SmartMover module.
* Updated ExpressEntry to use new web service features - Suite validation.
* Added 'Suppress 0 Counts' to all reporting options.
* Cosmetic changes to processing screens and result code descriptions.
* Removed latitude/longitude from analyzer panel (US & Global Check & Verify).
* Background color of problem fields shaded in red (US & Global Check & Verify).
* Updated list of transmission result codes and explanations.
* Added missing VR10, VS01, VS31 and VS41 result codes (US Check & Verify).
* Added German localization to GlobalVerify.

==Build 1.0.1.2405==
''Released July 16, 2014''
* Fixed display anomaly on Setting screen where user's ID and credit balance wouldn't appear.

==Build 1.0.1.2395==
''Released July 03, 2014''
* Added Spanish localization.
* Added 'Support' ribbon menu.
* Changed installer to set permissions on "ProgramData/Melissa Data/Listware for Excel" to 'Everyone'.
* Result Code changes: Global GS05 suppressed if 'Suppress Good Results' is checked.
* Result Code changes: Global AC15, AC16 and AC17 added to report.
* Result Code changes: NS02 now suppressed (handled by current error codes).
* Improved navigation for starting and closing components

==Build 1.0.1.2345==
''Released March 21, 2014''
* First public release of ExpressEntry.
* Express Entry charges 1 credits per successful Zip+4 address completed and entered.
* US/Global Verify: Added reporting (optional and configurable) sheet
* US/Global Verify: Added automatic loading of old settings from previously run reports.
* US Verify: Added many new Additional Address, Census and Parsed Address Output fields.

==Build 1.0.0.2314==
''Released February 06, 2014''
* Added a 'don't show me again' button to summary screen.
* US & Global Verify: 'Check' operation is now always on and Read-only.
* US & Global Verify: Removed GeoLocation operation, not connected to Lat/Long output control.
* Email append is now functional
* Global Verify: Added Output Address options.
* Global Verify: Added individual output address fields.

==Build 1.0.0.2288==
''Released November 21, 2013''
*Updated EULA.
*Combined Output Latitude & Longitude into a single prompt.
*Misc. bug fixes

==Build 1.0.0.2262==
''Released November 2013''

*Made the 'Processing Complete' dialog get it's own icon in the Windows Tray to make it easier to find after long runs.
*Misc. bug fixes

;Processing

:*Added 50k row per session processing limit.
:*User is now prompted to save changes before processing.

;GUI

:*Simplified Introduction screen.
:*Improved communication error reporting.
:*Added a few messages to better direct user about Proxy settings.
:*Added 'Refresh' button to US & Global setup screens to let user update credit totals.
:*Minor rephrasing of GeoCode option on some prompts to avoid confusion.
:*Feedback link now passes back version number and customer Id as URL parameters.
:*Added a 'Proxy Setup' button to Introduction panel so proxy users could set those settings and get their ID approved.

;US

:*'Append Name' relabeled to 'Append Name/Company' in many locations to eliminate user confusion.

;Settings

:*Added a port button to proxy settings (previously users could specify the port with a colon in the URL).

;Processing

:*Changed number of simultaneous threads to 2.

;Installer

:*Added file signing step to avoid 'Unknown publisher' issues.

==Build 1.0.0.2246==
''Released September 2013''

*Now using live URL.

==Build 1.0.0.2214==
''Released July 2013''

*Initial Release

[[Category:Build History]]
[[Category:Listware for Excel]]

Listware for Excel:Build History

2014-09-23T19:20:29Z

Tim:

{{CustomTOC}}

==Build 1.0.1.2429==
''Released Sept 23, 2014''
* Added SmartMover module.
* Updated ExpressEntry to use new web service features - Suite validation.
* Added 'Suppress 0 Counts' to all reporting options.
* Cosmetic changes to processing screens and result code descriptions.
* Removed latitude/longitude from analyzer panel (US & Global Check & Verify).
* Background color of problem fields shaded in red (US & Global Check & Verify).
* Updated list of transmission result codes and explanations.
* Added missing VR10, VS01, VS31 and VS41 result codes (US Check & Verify).
* Added German localization to GlobalVerify.

==Build 1.0.1.2405==
''Released July 16, 2014''
* Fixed display anomaly on Setting screen where user's ID and credit balance wouldn't appear.

==Build 1.0.1.2395==
''Released July 03, 2014''
* Added Spanish localization.
* Added 'Support' ribbon menu.
* Changed installer to set permissions on "ProgramData/Melissa Data/Listware for Excel" to 'Everyone'.
* Result Code changes: Global GS05 suppressed if 'Suppress Good Results' is checked.
* Result Code changes: Global AC15, AC16 and AC17 added to report.
* Result Code changes: NS02 now suppressed (handled by current error codes).
* Improved navigation for starting and closing components

==Build 1.0.1.2345==
''Released March 21, 2014''
* First public release of ExpressEntry.
* Express Entry charges 1 credits per successful Zip+4 address completed and entered.
* US/Global Verify: Added reporting (optional and configurable) sheet
* US/Global Verify: Added automatic loading of old settings from previously run reports.
* US Verify: Added many new Additional Address, Census and Parsed Address Output fields.

==Build 1.0.0.2314==
''Released February 06, 2014''
* Added a 'don't show me again' button to summary screen.
* US & Global Verify: 'Check' operation is now always on and Read-only.
* US & Global Verify: Removed GeoLocation operation, not connected to Lat/Long output control.
* Email append is now functional
* Global Verify: Added Output Address options.
* Global Verify: Added individual output address fields.

==Build 1.0.0.2288==
''Released November 21, 2013''
*Updated EULA.
*Combined Output Latitude & Longitude into a single prompt.
*Misc. bug fixes

==Build 1.0.0.2262==
''Released November 2013''

*Made the 'Processing Complete' dialog get it's own icon in the Windows Tray to make it easier to find after long runs.
*Misc. bug fixes

;Processing

:*Added 50k row per session processing limit.
:*User is now prompted to save changes before processing.

;GUI

:*Simplified Introduction screen.
:*Improved communication error reporting.
:*Added a few messages to better direct user about Proxy settings.
:*Added 'Refresh' button to US & Global setup screens to let user update credit totals.
:*Minor rephrasing of GeoCode option on some prompts to avoid confusion.
:*Feedback link now passes back version number and customer Id as URL parameters.
:*Added a 'Proxy Setup' button to Introduction panel so proxy users could set those settings and get their ID approved.

;US

:*'Append Name' relabeled to 'Append Name/Company' in many locations to eliminate user confusion.

;Settings

:*Added a port button to proxy settings (previously users could specify the port with a colon in the URL).

;Processing

:*Changed number of simultaneous threads to 2.

;Installer

:*Added file signing step to avoid 'Unknown publisher' issues.

==Build 1.0.0.2246==
''Released September 2013''

*Now using live URL.

==Build 1.0.0.2214==
''Released July 2013''

*Initial Release

[[Category:Build History]]
[[Category:Listware for Excel]]

Listware for Excel

2014-09-23T19:08:24Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
A complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, and Global Check & Verify
* '''New Release:''' Smartmover (NCOA) Change of Address, Express Entry: Validated Suites . See [[Listware for Excel:Build History|Build History]] for all changes.
* MatchUp® record deduping and SmartMover Change of Address currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released Sept 23, 2014
<br>Build 1.0.0.2429
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:PRICE CHANGE FOR MOVE UPDATE|'''Price Change''']]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel:Issues

2014-09-22T20:28:25Z

Tim:

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. As of build 2428 we are no longer officailly supporting installations on win XP, as microsoft is no longer supporting the OS. <br>

See [http://www.microsoft.com/en-us/windows/enterprise/end-of-support.aspx End of Support XP] for details

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:Issues

2014-09-22T20:04:07Z

Tim: /* XP Installation */

==Result Code: AE07 not reported==
If the minimal requirements for address input are not met, AE07 should be returned. <br>
the underlying web service is not returning this, which may cause some records to be returned
with No result codes

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. As of build 2428 we are no longer officailly supporting installations on win XP, as microsoft is no longer supporting the OS. <br>

See [http://www.microsoft.com/en-us/windows/enterprise/end-of-support.aspx End of Support XP] for details

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:Issues

2014-09-22T20:03:46Z

Tim:

==Result Code: AE07 not reported==
If the minimal requirements for address input are not met, AE07 should be returned. <br>
the underlying web service is not returning this, which may cause some records to be returned
with No result codes

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. As of build 2428 we are no longer officailly supporting installations on win XP, as microsoft is no longer supporting the OS. <br>

See [http://www.microsoft.com/en-us/windows/enterprise/end-of-support.aspx EndofSupportXP] for details

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:Issues

2014-09-22T20:01:43Z

Tim: /* XP Installation */

==Result Code: AE07 not reported==
If the minimal requirements for address input are not met, AE07 should be returned. <br>
the underlying web service is not returning this, which may cause some records to be returned
with No result codes

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. As of build 2428 we are no longer officailly supporting installations on win XP, as microsoft is no longer supporting the OS. <br>

See [http://www.microsoft.com/en-us/windows/enterprise/end-of-support.aspx] for details

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:FAQ

2014-09-22T19:53:18Z

Tim:

[[Listware for Excel|Back to Listware Main Page]]

__FORCETOC__
==Listware for Excel Requirements==
===Does computer operating system matter? Does Listware work for both Mac and PC?===
:Currently the component is available only for PC. We no longer support win XP or earlier.

===What version of Excel do I need to use Listware?===
:We support versions of Excel from 2007 – 2013 on Windows.

===The installer says that I need to install .NET 4.0?===
:The .NET Framework 4.0 is needed to run Listware for Excel. If it's not installed, you will need to install it.

===Can I use Listware on several different computers?===
:Yes, Listware can be installed on multiple PCs. Each instance of Listware will consume credits from your account.

===Can I install Listware for all users of a machine?===
:No, Microsoft does not recommend plug-ins be available across users. A single installation holds unique configuration settings, therefore does not lend itself for user1 to access to edit user2's configuration. Since the componetn is free and a single account can be shared by users at the same company, simply download multiple components for each user.

===I downloaded and installed Listware. Still haven't received license info to use.===
:If you downloaded the program from www.melissadata.com, an automated email is sent out. Please check your spam email folder and make sure www.melissadata.com is not blocked. If you still cannot find it, you can email sales@melissadata.com for help from a sales representative.
If you downloaded the program from a third party website like www.download.com, navigate here: http://www.melissadata.com/dqt/listware-excel-credits.htm to activate an account.

===Can you use Listware in MS Access?===
:No, this component was written specifically for Excel. Fortunately, both being Microsoft products, you can easily export to Excel from Access, process your data, then import into MS Access if needed.

===Why is my Anti-virus Software preventing Listware installation?===
:Many third party Anti-virus suites use different methods and procedures to recognize and allow or to prevent third party software from running. While we are currently whitelisted by leading Antivirus providers, there may be small market share providers which we are currently working with. Please contact tech support if your provider will not run Listware. [[Support|Support Page]].

==Using Listware for Excel / Basics==

===How does Listware work?===
:The Listware component uses our secure underlying web services to process your data. This means that when you select 'process' for a range of cells, blocks of 100 records are sent via SOAP web request to our servers, where the data is processed according to the options you have selected. The results are returned and appended to the existing sheet.

===Do I need internet access to use Listware?===
:Yes, to process data or retrieve your account information through Listware you will need an internet connection. However, to analyze a finished process, you do not, as cell styles and comments have been written to your sheet. (Remember to save changes to your sheet when you are done processing!)

===Will this work with existing data or only data purchased through Melissa Data?===
:This will work with your existing data.

===Does this work for Canadian addresses?===
:Yes, Listware US Check and Verify will also verify Canadian addresses. For all other countries, use Listware Global Check & Verify.
:Currently, Move and Append operations are for US only

===Will the original data be replaced?===
:Listware does not replace columns it appends new columns to the processed sheet. The old data will remain in the original column cells.

===Is this input structure mandatory? What if our addresses fields are different?===
:The input structure does not have to be any particular order. After selecting the range of cells that you want to process, you can specify which columns contain the fields of interest ie: name, address, city , state, zip, etc

===Can I input a LastLine (ie CSZ as an input instead of parsed City, State and Zip?===
:No, this was a design and development decision.

===What are the row limitations?===
:You can only process 50,000 rows in a single processing run. The sheet itself may contain more rows, but to process the entire range you would have to run a second process (selecting the remaining rows and re-starting).

===How extensive is your database to update non-business, or residential mail list?===
:Melissa Data sources the most comprehensive sources of consumer data available. It is hard to say a precise number, but a typical non-junk list can usually expect around 80%-90% of their names and addresses to validate. We are also continually refining our data and adding additional sources so we expect our coverage to grow with time.

===Is the data transfer during verification encrypted?===
:Listware uses HTTPS - a secure version of the HTTP Protocol using SSL 128 Bit encryption. No personal information is ever kept or stored on the Melissa Data web servers.

===Can I automate the Listware process? Save configurations?===
No, Listware is only used in interactively with an opened Excel sheet. Melissa Data provides a number of developer solutions that are designed for automation and integration with existing systems.

With the addition of reporting, Listware now offers limited re-useable configuration. When you open a previously processed sheet with a saved report (it must be the sheet to the immediate right of the data sheet), Listware will read the input / output settings from that report and use them. These settings willbe read and loaded once, when the table is first opened,

===Do I have any control over how data is processed?===
Yes, select the Settings item on the menu ribbon to see the available configurations

===Where are the Screens where I checked 'Don't Show me Anymore'?===
If you have chosen to hide screens like Processing Summary or Tutorials, and would like them back, contact Tech Support, as this requires us to manually change a program file

===How long does it take to process 10,000 rows?===
:Your Available memory, network speed and the quality of the source data are all important factors in processing performance. Also simply checking Names will process much faster than a process which verifies Names against Addresses, identifies moves and appends phones./ Checking 10000 records may take less than 5 minutes.

===Is all or most of this functionality present in the Mailers+4 software already?===
:Individually, many of the cleansing operations exist in some form in Mailers+4, such as address verification and NCOA. What makes Listware unique is that it will verify different data types against each other in verifying that the entire record is a valid contact. Using a valid full contact record also enables additional data to be appended to the record.

===I am a current MatchUp user; when will the matchup de-dupe function be in this product?===
:The MatchUp plug-in to de-dupe customer lists for Listware is currently in development. At this time there is no release date.

===Is Listware a Consumer or Business solution?===
:Listware is a full contact solution for both Business and Residential use. Our data sources come from a wide variety and range of business and consumer sources.

==Credit System==
===How much are credits?===
:At this time one credit is equal to .002 cents, and different cleansing services use defined amounts of credits. <br>
:You can find out more here: http://www.melissadata.com/dqt/listware-excel-credits.htm

===Is there a monthly fee for this service or do you pay as you go on credits needed?===
:As with our other products, you can elect to license Listware with a yearly subscription for different levels of expected usage.

===Do I pay for the append attempt if you do not find a value – ie: if Melissa Data does not have a name and I requested name append?===
:No, your request for append credits will only be consumed when we return added data (see above)

===What happens if you reprocess the same data set again (perhaps by accident)? Are you charged again?===
:Using our easy to use credit system, if you accidently select 'RESTART' from the output summary page (the one with the colored output grid) or 'RESTART' from the Review page - you will have to navigate thru the setup screens again, so it is not an easy mistake to make, but you will get billed. <br>
:If you choose 'RESCAN' from the review page, you will not get billed (credits consumed). However, the rescanning life of a record is about a day.

===What if my Credit Balance is not correct?===
:In the event that your credit balance has not been consumed or credited, please contact support (link to the left) or your sales representative.

===Can you have an account consume credits in real time?===
:Once you have selected the data to process and the cleansing operations, Listware will display an estimated (required) amount of credits to process. You can then use the links to purchase that amount although if doing indeterminate append actions it is recommended to pad with more credits. Listware does not bill your credit card in real time for the exact number of credits consumed. There are options to set up and use a common Automated Recurring Billing option. This allows you to specify a tier of credits to purchase and replenish credits when consumed.

===I have 10K records what is the approx. cost?===
:The cost to process a list greatly varies on the number of credits for the cleansing operations you choose, operations like Check are 1 credit per record, and others like Move/Append are simply based on we can actually append or move for you. We only debit credits for data that is appended.

===Different pricing for non-profits?===
:Please contact a Melissa Data sales representative at sales@melissadata.com or call them at 1800-Melissa Option 3.

==Listware for Excel In-Depth==
===I downloaded the trial version and it appended data based on the contact's personal info, not business info.===
:Listware for Excel is a consumer/residential centric software, not business centric software.

===What are the enterprise solutions for larger companies?===
:This link is a portal to other address solutions in our product queue briefly mentioned in the webinar. http://www.melissadata.com/address-verification/index.htm

:Some of the possible solutions for the Enterprise are solutions like Personator – the underlying web service used by Listware - or the individual Data Quality APIs.
:Melissa Data also has products for ETL (SSIS and Contact Zone) which are more advanced and have robust capabilities in data transformation and cleansing.

===How do I use the help to get questions answered?===
:The help icons are a link to the online documentation. Links for feedback and request for support can be found under the Listware Settings section as well as other carefully placed locations throughout the component. You can also Melissa Data at 1800-Melissa option 4 at any time and speak to a support representative.

===If a contact has moved, are they verified?===
:Yes, if we move or append a new address, it has first been verified.

===Can I write the output results to a new sheet?===
:Not in the current version, although this behvior may be available in future versions.

===How do I know what Listware has returned for each record?===
:Use the Result codes, coloring and attached comments to analyze the returned status.

===Is there a score associated with a match, or just the color coding and comments?===
:The color coding, and comments are visual cues to help easily analyze the results. The results describing a match (verified as being the same contact) between two or more contact components, is the result of Melissa Data algorithms and data sources. A confidence level or score is not an output property returned to the customer.

===If rooftop geocode value is not available, what priority of values is returned (street level? census tract? etc)===
:If we cannot verify a geocode to the rooftop level, we will attempt to return an interpolated rooftop, street level (zip+4), neighborhood (zip+2) or community (zip5) level in that order.

===How are divorced contacts resolved?===
:Listware for Excel will create an Individual Move using the first and last name to supply a new address.

===What kind of email verification steps do you perform (e.g. spam, syntax correction, etc.)===
:Email verification will verify and correct or update valid domains. It will flag invalid, unverified and spam domains. It will also identify mobile, spamtrap and disposable emails.

===What percentage of matches do you normally find of phone numbers to addresses?===
:The percentage of matches for phone numbers to address depends highly on the quality of the input data. Every list is different and we do not have a “normal” percentage number. Melissa Data will return high match rates when matching landlines to addresses, but not so well when matching cell phone to addresses.

===Is the software validating that the business (melissa data) exists at the particular address, or is it just validating that the business address is a viable (mailable) address?===
;Answer:
:The Check Action Result Codes (AS, AE) will tell you the address is a valid mail-able address. The Verify Action Result Codes (VR) will tell you if two pieces of data are verified as belonging to the same record.

===If a contact at a business moves and I have their business address will it update their move?===
;Answer:
:If an entire business moves and we are provided the original business name and address, we will move the business to their new address. We will not be able to move someone who changes jobs and moves to a new business while the businesses themselves do not move.

===Can we append data based on just one piece of information?===
:In some cases, yes.

===So the reds are the bad addresses there is no flag in a separate column to show which are bad?===
:Also appended to the output columns are the Result Codes for each cleansing action. They tell you the verification level of all the cleansing operations performed and any data changes we have applied to the output. They are documented in all our products, and here http://www.melissadata.com/webhelp/listware/excel/index.htm#Basics/Check_and_Verify/US/Review_Results.htm you have the option of having them combined into one field and whether to display ‘only error codes’ (suppress good results and change codes) or all codes. You can then do an Excel sort on this field(s) of query for certain codes.

===So how do you get around that? Most, if not all, of our contacts are professionals, as we provide B2B services?===
;Answer:
:MelissaData is exploring possibilities for providing business additional centric information. However, that is not an option at this time.

===Where would it indicate that a house is vacant?===
;Answer:
:As with all properties returned with a record, you can find find the vacant house indicator – AS16 (for US only) – in the output result code field.

==Compliance / Certification / Conformity==

===Can the appended corrections go to our Mailpiece as CASS certified?===
;Answer:
:Not all verified address information is assumed as CASS certified. The extensive underlying data sources contain over 6 million non USPS but valid addresses. USPS vs Non-USPS addresses can be identified by using the Result codes (AS01 vs AS03).

===Can Listware return a DSF2 designation for an address? That determines if the address is a residence or a business address.===
;Answer:
:Listware does not return a Delivery indicator or (Business / Residential Indicator) at this time.

===Do you have a GLN option?===
;Answer:
:Currently we do not provide a unique Global Location Number.

===What is DPV level address verification?===
;Answer:
:Delivery Point Validation as defined by the USPS confirms the existence of an address to the suite or delivery number level and therefore ensures USPS delivery. This is a part of CASS Certification conducted by Melissa Data with the USPS.

===Does Listware implement DNC (do not call) filtering along with identifying and filtering cell phone numbers that I want removed from my list?===
Also, can your services identify residential or land-line numbers if I already have a cell phone number?
;Answer:
:Listware does not return DNC flags on supplied phone numbers. Listware does perform real time phone checking as far as cell / landline info, and detects if the phone number is 7-digit verified (likely in service) or 10-digit verified (most likely in service). Listware also attempts to match phone numbers to the name and address in the Verification process, and can append missing Phones if not provided in some cases with Append.

:Yes, for identified numbers, there is a flag for Phone Type returned by Listware in the Result Codes section: PS07 Cellular Line, PS08 - Land Line, PS09 - VOIP Line, PS10 - Residential Number, PS11 - Business Number, PS12 - SOHO Number.

===Once you run your list through Listware will we be able to print out postal documents NCOA etc?===
;Answer:
:Currently, there are no reporting features provided. Since Listware uses Melissa Data’s own data to process moves it is not an NCOA process.

===From whom do you license your company information appends? Will you be offering Firmographic information (e.g .SIC, URL, Employees) in the future?===
;Answer:
:We license our data from a large number of different sources. We cannot list them all but they are the industry leading data providers ranging from telephone to credit to marketing data, etc. Yes, we do plan to offer some Demographic and Firmographic information in the future although the exact fields have not been determined.

===Can you export the geocoding into a KML file?===
;Answer:
:Listware for Excel does not provide a mechanism to directly save your geocoding results to KML at this time, however it is being considered for a future release.

:You may want to try this site which uses Google Maps: http://batchgeo.com/
:You simply copy and paste your range of latitude and longitude coordinates into the page.

===Are there issues with HIPPA compliance sending PI (personally identifiable) information on the internet?===
;Answer:
:Listware is not HIPPA compliant, because the customer is not sending us medical information related to the contact, there is no breach of the Act. Name and address by itself does not constitute information that falls under HIPAA guidelines.

===HIPPA Compliance requires that NON-medical information only is transferred.===
;Answer:
:Correct, Listware does NOT require you to send the entire contact record to be processed. Only the relative data fields – Name, Address, Zip, etc required to perform the requested cleansing operations are encrypted and transmitted to us.

[[Category:FAQ]]
[[Category:Software]]
[[Category:Listware for Excel]]

MatchUp Software:Excel/Access Troubleshooting Guide

2014-09-22T14:48:49Z

Tim: /* Trouble Processing xlsx or accdb formats */

Troubleshooting Tips When Processing an Access or Excel Table

Access and Excel are difficult formats to process because they are in a proprietary Microsoft format. Because of this, we are forced to use Microsoft's prescribed methods to access data. MatchUp uses one of two technologies for doing this: ADO and DAO.
This document is intended to provide steps in working around the default behavior and providing MatchUp with formats it can handle.

[[MatchUp Software|Back to MatchUp Main Page]]

==Add an Autonumber field to your table.==
One of the biggest problems with DAO/ADO is that these technologies were written with the assumption that people always access their data in a linear fashion, from start to end. While MatchUp does do this while building keys, it must access the data in a random sequence when it is performing the merge/purge operation. Another way to explain this is to say that DAO/ADO do not use record numbers. So when MatchUp tells DAO/ADO to move to record 58, DAO/ADO uses an awkward (and apparently buggy) algorithm to accomplish this. Adding an autonumber field essentially provides a record number field for your table, saving DAO/ADO from sweating out the computations.

CREATE AN AUTONUMBER IN EXCEL

1. Create a new column

[[File:auto1.png]]

2. Navigate to bottom row and highlight last cell

3. CTRL + SHIFT + Arrow (to highlight all active cells in that column)

4. Type in the formula.... .

[[File:auto2.png|auto2.png]]

...(note '-1' so first cell can have a header created)

Each cell should now have the results of the formula

5. Highlight column and select COPY

6. Select PASTE > PASTE VALUES

The cells will now contain the row number instead of the formula

7. Select and edit the first cell and create a column name.

Do not name the Column ‘ID’ as this is a used column name and has previously caused crashes for some of our users.

[[File:auto3.png|auto3.png]]

CREATING AN AUTONUMBER IN ACCESS

1. Open the table in Access, and select Design View

[[File:auto4.png|auto4.png]]

2. Create a new column (Do not name it ‘ID’), type AutoNumber

[[File:auto5.png|auto5.png]]

3. Set its properties to increment unique values

[[File:auto6.png|auto6.png]]

4. Select Data sheet view….

[[File:auto7.png|auto7.png]]

5. Review the new column…

[[File:auto8.png|auto8.png]]

==Try the other technology.==
There is no way to easily get the data access version, so we can’t even say “your data access engine is outdated, get version xxxx”. Also, different versions of Excel perform better with different versions of the data access engine, while the same version of Access might be the complete opposite.
In Tools | User Settings | General: Interface, you can select either DAO or ADO. Often, changing this will do the trick. Note that ADO is usually slower than DAO.

[[File:adoDao.png|adoDao.png]]

==Edit Output Field Mapping==
By the time you configure the Output Field Mapping Tab, MatchUp is creating the structure for the Output Table based on what you have in this screen. However, at this point it does not know the Output table type (you haven’t created it yet). Since MatchUp can create output tables of many different types, each with restrictions of what constitutes a valid structure, you must create an Output Field Mapping structure which conforms with a ‘common valid structure ruleset’ which any Output type can use.

[[File:ofm1.png|ofm1.png]]

FIELD SIZES
If you're working with a table with rather large fields (ie, over 200 characters), you may want to try reducing the sizes to a more manageable size and see what happens.

Excel most always reports field sizes as 255 characters, attempting to modify the column width in excel will not work.
Be sure that you won't truncate any of your data before doing this.

FIELD COLUMN NAMES
Since some database systems have restrictions on column names, MatchUp follows suit and will not create these Output Table types if the column names are seen by MatchUp as multi-word or have a length of over 10 characters.

Excel allows duplicate field names. MatchUp tries to do what it can with these, but sometimes comes up short. It's best just to fix the problem in the native DBMS before working with the file in MatchUp. And better database practice!

A good rule of thumb – if you look at only the first 10 characters of the column names, and there are more than one instance, or embedded spaces, the program may crash.

FIELD TYPES

If the table has a few 'oddball' fields, you may want to make a copy of the table and try removing the fields. Such fields would be non-character and non-numeric fields, and not critical to the deduping process or the desired output table.

If all fields are required in Output, you can try changing the output column type. For example, different versions of Excel and Access contain options for numeric data, logic fields and dates. If you find one of these to be problematic, try changing the output type to ‘fixed character’.

For a hands off, advanced approach, you can edit your .ini file…

'''Warning: This is an advanced topic. Proceed only if you know what you are doing!'''

When MatchUp needs to create a table, it normally uses data from the chart below to determine what DBMS (ie, 'native') data type should be used for a given MatchUp field type:

[[File:field1.png|field1.png]]

However, like many things, one size does not fit all. For Excel, Access and SQL Server users, there exists a mechanism to override these native field types.

Regardless of the database engine, you will need to open your dt.ini file (it will be in the folder where MatchUp is installed) in Notepad. At the end of the file (after a blank line or two), add the section listed.

Access or Excel through DAO:

[[File:field2.png|field2.png]]

Above, the black entry indicates the MatchUp field type you want to change, blue indicates the Access/Excel type you want to use, and green indicates your choices for that particular field type (in the dt.ini file, do not type in the green text!).

The available native data types are the very same ones that you would use in a CREATE TABLE statement; consult your Excel or Access documentation for exactly what each data type represents.

Access or Excel through ADO:
Even though we are accessing the same table types as DAO, the native data types are sometimes different (direct your complaints to Microsoft for this).

[[File:field3.png|field3.png]]

Above, the black entry indicates the MatchUp field type you want to change, blue indicates the Access/Excel type you want to use, and green indicates your choices for that particular field type (in the dt.ini file, do not type in the green text!).

The available native data types are the very same ones that you would use in a CREATE TABLE statement; consult your Excel or Access documentation for exactly what each data type represents.

Above, the black entry indicates the MatchUp field type you want to change, blue indicates the SQL Server type you want to use, and green indicates your choices for that particular field type (in the dt.ini file, do not type in the green text!).

The available native data types are the very same ones that you would use in a CREATE TABLE statement; consult your SQL Server documentation for exactly what each data type represents.

Notes:
*These settings are global, and are not setup file specific.
*If you omit any entry or specify an invalid one, the default will be used.

This setup structure will process, where the previous would crash for many files…

[[File:ofm2.png]]

==CASS Considerations==
Unlike some other database types, MatchUp CASS process does not allow you to append columns to the Excel or Access table you are processing. You must select an existing column. So before processing, you must create the columns in the respective program, using the recommended troubleshooting guidelines above.

Especially with CASS (but also Merge Purge), make sure that you are allowing zero-length (aka, 'Allow NULLs') fields.

[[File:cassCons.png]]

==Choose an alternate format==
If all else fails, converting the files to dBASE (or .csv) will work
Our dBASE driver was written in-house and is the most stable and fastest database type available for output tables.

If your Output table must be returned in its native format, it is usually quicker to process in dbase and import the output table to the native program.

Although .csv is not as fast as dBASE, and does not allow you to use some of the advanced options (to write results back to the source table), it is a much more stable option than Excel or Access.

==Fixing Excel Zip Codes==
What's up with Excel's handling of Zip Codes?

Wouldn't we like to know... Excel is very quirky when working with Zip Codes. Sometimes it will get convert them all to numbers. Although that's fine in the midwest, up in the northeast one or more digit of the zip code can be lost.
MatchUp does a good job of converting ‘excel-ed’ zip codes to their five digit format but problems can arise if there is a mix of zip5 and zip9 codes. Since excel will report that the field is numeric, the zip9 codes containing a dash will get wiped out, and MatchUp will see these records as not containing a zip code.

One way to handle this (sometimes this won't work!):

# Insert a blank column next to the Zip field
# On the first row of data, type =TEXT(C1,0), where C1 is the cell containing the zip code.
# Copy the function for the rest of the column (the C1 should correctly adjust to C2, C3, etc as you go down). Your northeast Zip Codes should now read correctly.
# Click at the very top of the column to highlight the entire row.
# Right-click and select Copy.
# Right-click and select Paste Special. Select Values.
# You can delete the original column of badly formatted Zip Codes.

==Trouble Processing xlsx or accdb formats==
MatchUp can not process xlsx nor accdb files when 64-bit msOffice is installed. The workaround is to install 32-bit msOffice or to process the files as a csv format.

[[MatchUp Software|Back to MatchUp Main Page]]

MatchUp Software:Excel/Access Troubleshooting Guide

2014-09-22T14:48:30Z

Tim:

Listware for Excel:Issues

2014-09-12T12:54:54Z

Tim:

==Result Code: AE07 not reported==
If the minimal requirements for address input are not met, AE07 should be returned. <br>
the underlying web service is not returning this, which may cause some records to be returned
with No result codes

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. We are currently researching the issue.

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:Issues

2014-09-12T12:54:41Z

Tim:

==Result Code: AE07 not reported==
If the minimal requirements for address input are not met, AE07 should be returned. <br>
the underlying web service is not returning this, which may cause some records to be returned
with No result codes

==Installation Issues==
[[Listware for Excel:FAQ#Why is my Anti-virus Software preventing Listware installation?|Important Notice about Anti-Virus Software]]

==XP Installation==
There may be an issue with XP outdated service packs, updates, .NET compatibility or .msi issues preventing installation on some XP configurations. We are currently researching the issue.

[[Listware for Excel|Back to Listware for Excel Main Page]]

Listware for Excel:Issues

2014-08-20T19:54:23Z

Tim:

Listware for Excel:Pricing

2014-08-20T19:52:40Z

Tim:

The Price for a Listware for Excel US Check & Verify Move Update has changed. <br>
A new address will now consume 10 credits. <br>
(Effective 8/13/2014)

[[Listware for Excel|Back to Listware Main Page]]

Listware for Excel:Pricing

2014-08-20T19:51:33Z

Tim: Created page with "The Price for a Listware for Excel US Check & Verify Move Update has changed. <br> A new address will now consume 10 credits. <br> (Effective 8/13/2014)"

The Price for a Listware for Excel US Check & Verify Move Update has changed. <br>
A new address will now consume 10 credits. <br>
(Effective 8/13/2014)

Listware for Excel

2014-08-20T19:45:09Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
Complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, and Global Check & Verify
* '''NEW RELEASE''' Spanish localization, Easier support access added. See Build History for list of changes.
* MatchUp® record deduping and SmartMover 'Change of Address' currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released July 16, 2014
<br>Build 1.0.0.2405
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:PRICE CHANGE FOR MOVE UPDATE|PRICE CHANGE]]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel

2014-08-20T19:44:24Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
Complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, and Global Check & Verify
* '''NEW RELEASE''' Spanish localization, Easier support access added. See Build History for list of changes.
* MatchUp® record deduping and SmartMover 'Change of Address' currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released July 16, 2014
<br>Build 1.0.0.2405
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:'''PRICE CHANGE FOR MOVE UPDATE'''|PRICE CHANGE]]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

Listware for Excel

2014-08-20T19:38:54Z

Tim:

__NOTOC__
{| border="0" valign="top" style="border-spacing:0px; max-width:1000px;"
|colspan="2"|
{{ProductHeader
|Color=prodfuchsia
|Image=[[File:MediumTile_SFT_ListwareExcel.png|link=]]
|Body=
Complete data cleansing service built as an Add-in for Microsoft's Excel®.
* Listware includes US Check & Verify, and Global Check & Verify
* '''NEW RELEASE''' Spanish localization, Easier support access added. See Build History for list of changes.
* MatchUp® record deduping and SmartMover 'Change of Address' currently in development.
}}
|-
|valign="top" colspan="2"|
{{ProductSecond
|Color=orange
|Image=[[File:MediumTile_Current.png|link=]]
|BodyCol1=
<h3>Current Build</h3>
Released July 16, 2014
<br>Build 1.0.0.2405
*[[Listware for Excel:Build History|Build History]]
|BodyCol2=
<h3>Notices</h3>
*[[Listware for Excel:'''PRICE CHANGE FOR MOVE UPDATE''']]
*[[Listware for Excel:Issues|Known Issues]]
}}
|-
|valign="top" width="50%" style="padding-right:8px;"|
{{ProductLeft
|Color=green
|Image=[[File:MediumTile_Essentials.png|link=]]
|Body=
<h3>Basics</h3>
*[[Listware Basics:What can Listware Do?|What can Listware Do?]]
*[[How do I get Started or Where are the Updates]]
*[[Listware for Excel:Best Practices|Best Practices]]
*[[Listware Similar Solutions / Different Options|Similar Solutions / Different Options]]
<h3>FAQ</h3>
*[[Listware for Excel:FAQ|Listware for Excel]]
}}
|valign="top" width="50%" style="padding-left:8px;"|
{{ProductLeft
|Color=red
|Image=[[File:MediumTile_Reference.png|link=]]
|Body=
<h3>Documentation</h3>
*[[Listware for Excel:Reference|Online Reference]]
*[http://www.melissadata.com/webhelp/listware/excel/index.htm WebHelp]
<h3>[[Result Codes]]</h3>
*[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
}}
|}

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

MatchUp Software:SQL Troubleshooting Guide

2014-08-13T13:13:10Z

Tim:

[[MatchUp Software|Back to MatchUp Main Page]]

'''1. Can you connect to another table or database?''' You can try the Northwind SQL demo.
If you can connect to another table, it may be permission issues.

'''2. If permission issues do not seem to be the problem…'''

'''3. Connection issues''' often show themselves if you can’t see a dropdown list of servers, databases and or tables. Are you typing any of them in? If you do not get any dropdown choices, MatchUp / Personator probably can not connect to the database \ table.

Open up your SQL Server Configuration Manager (via Start menu >... SQL Server Config Tools...).
Check the settings for the Client and Server Configurations. Make sure the client protocols match the server's protocol (protocol names and order) and port number.

[[File:client_protocols.png]]

If they are the same…

'''4. Try creating an Alias'''
We have seen this problem resolved by creating an ALIAS to the server in the Configuration Manager. MatchUp is sometimes able to connect to the alias when it can not connect to the direct instance of the server. NOTE: Try an ALIAS with a single name, letters only.

Open up your SQL Server Configuration Manager (via Start menu >... SQL Server Config Tools...).

Again, check the settings under the Client Configuration for the Alias you have created. Make sure they match the server's protocol (protocol names and order) and port number. Also try creating another Alias - where one has the naming convention SERVER and the other has the convention SERVER\MSSQLSERVER. reboot. Basically, setting this up can be trial and error, as one may work on certain configured machines while the other works on different configurations.

NOTE 64-bit users: Currently, only a 32 bit SQL Native Client will be recognized...

[[File:alias-64bit.png]]

'''5.''' If the connection is not the problem, '''it may actually be a problem reading the structure…'''

Check the datatypes of some of the fields in your SQL tables. MatchUp does have trouble reading and writing certain field types (some users have changed decimal to integer).

Finally, if you are processing a view (as opposed to table) why not create a view that is simpler in structure? - less fields means less processing time, and less areas for potential errors.

There may be problems with the view because while MatchUp can process some views, ones created by a join of tables can not. A view created from various tables can be ambiguous as to what records or fields would be updated - as in a view which may have a many to one relationship or Data in a view may have been tabulated or derived from multiple tables.
Even without creating an output table, MatchUp still has to know which individual record it is reading because it uses each record to build the analyzer and reports.

When you go to add the SQL table do you automatically get an error, or a message saying the client is not installed, or do you actually see prompts for Trusted Connection / Server / database/ table?

'''6. Do a search for NtwDbLib.dll'''. MatchUp needs this dll to speak with SQL. Microsoft stopped shipping this dll with SQl 2000. You can hunt and get it easily on the internet, or we can get one to the customer. Even if the file is present, make sure that Windows can locate it. That is, it is in your Windows folder, the System folder, the System32 folder, or any folder listed in your Path= statement.

On a whim I tried connecting to a different table than the one I needed, and it worked. There are some tables I can access, and some I can’t. '''Are there any limitations as far as the number of columns in a table?''' The particular table I want to use (view actually) has 247 columns.

MatchUp does not have any limitations to the number of columns, although writing them out can cause problems when opening up in a program which cannot read that many.

There may be problems with the view because while MatchUp can process some views, ones created by a join of tables cannot. A view created from various tables can be ambiguous as to what records or fields would be updated - as in a view which may have a many to one relationship or Data in a view may have been tabulated or derived from multiple tables.

Also, '''check the data types of some of the fields in your SQL tables'''. MatchUp does have trouble reading and writing certain field types (like decimal). See the help file section Reference | Overriding MatchUp’s Default Field Types for tips how to overcome this.

Finally, if you are processing a view (as opposed to table) why not create a view that is simpler in structure? - less fields means less processing time, and less areas for potential errors.

[[MatchUp Software|Back to MatchUp Main Page]]

MatchUp Software:SQL Troubleshooting Guide

2014-08-13T13:12:28Z

Tim:

MatchUp / SQL Connection Troubleshooting

[[MatchUp Software|Back to MatchUp Main Page]]

'''1. Can you connect to another table or database?''' You can try the Northwind SQL demo.
If you can connect to another table, it may be permission issues.

'''2. If permission issues do not seem to be the problem…'''

'''3. Connection issues''' often show themselves if you can’t see a dropdown list of servers, databases and or tables. Are you typing any of them in? If you do not get any dropdown choices, MatchUp / Personator probably can not connect to the database \ table.

Open up your SQL Server Configuration Manager (via Start menu >... SQL Server Config Tools...).
Check the settings for the Client and Server Configurations. Make sure the client protocols match the server's protocol (protocol names and order) and port number.

[[File:client_protocols.png]]

If they are the same…

'''4. Try creating an Alias'''
We have seen this problem resolved by creating an ALIAS to the server in the Configuration Manager. MatchUp is sometimes able to connect to the alias when it can not connect to the direct instance of the server. NOTE: Try an ALIAS with a single name, letters only.

Open up your SQL Server Configuration Manager (via Start menu >... SQL Server Config Tools...).

Again, check the settings under the Client Configuration for the Alias you have created. Make sure they match the server's protocol (protocol names and order) and port number. Also try creating another Alias - where one has the naming convention SERVER and the other has the convention SERVER\MSSQLSERVER. reboot. Basically, setting this up can be trial and error, as one may work on certain configured machines while the other works on different configurations.

NOTE 64-bit users: Currently, only a 32 bit SQL Native Client will be recognized...

[[File:alias-64bit.png]]

'''5.''' If the connection is not the problem, '''it may actually be a problem reading the structure…'''

Check the datatypes of some of the fields in your SQL tables. MatchUp does have trouble reading and writing certain field types (some users have changed decimal to integer).

Finally, if you are processing a view (as opposed to table) why not create a view that is simpler in structure? - less fields means less processing time, and less areas for potential errors.

There may be problems with the view because while MatchUp can process some views, ones created by a join of tables can not. A view created from various tables can be ambiguous as to what records or fields would be updated - as in a view which may have a many to one relationship or Data in a view may have been tabulated or derived from multiple tables.
Even without creating an output table, MatchUp still has to know which individual record it is reading because it uses each record to build the analyzer and reports.

When you go to add the SQL table do you automatically get an error, or a message saying the client is not installed, or do you actually see prompts for Trusted Connection / Server / database/ table?

'''6. Do a search for NtwDbLib.dll'''. MatchUp needs this dll to speak with SQL. Microsoft stopped shipping this dll with SQl 2000. You can hunt and get it easily on the internet, or we can get one to the customer. Even if the file is present, make sure that Windows can locate it. That is, it is in your Windows folder, the System folder, the System32 folder, or any folder listed in your Path= statement.

On a whim I tried connecting to a different table than the one I needed, and it worked. There are some tables I can access, and some I can’t. '''Are there any limitations as far as the number of columns in a table?''' The particular table I want to use (view actually) has 247 columns.

MatchUp does not have any limitations to the number of columns, although writing them out can cause problems when opening up in a program which cannot read that many.

There may be problems with the view because while MatchUp can process some views, ones created by a join of tables cannot. A view created from various tables can be ambiguous as to what records or fields would be updated - as in a view which may have a many to one relationship or Data in a view may have been tabulated or derived from multiple tables.

Also, '''check the data types of some of the fields in your SQL tables'''. MatchUp does have trouble reading and writing certain field types (like decimal). See the help file section Reference | Overriding MatchUp’s Default Field Types for tips how to overcome this.

Finally, if you are processing a view (as opposed to table) why not create a view that is simpler in structure? - less fields means less processing time, and less areas for potential errors.

[[MatchUp Software|Back to MatchUp Main Page]]