Difference between revisions of "Listware for Excel:Similar Solutions"

From Melissa Data Wiki
Jump to navigation Jump to search
Line 10: Line 10:
==Personator options not available in Listware (and how Listware is set)==
==Personator options not available in Listware (and how Listware is set)==
* Name options (set to default):  
* Name options (set to default):  
**NameHint
**NameHint (set to 'Varying')
**GenderPopulation
**GenderPopulation (set to 'Mixed')
**GenderAggression
**GenderAggression (set to 'Neutral')
**MiddleNameLogic
**MiddleNameLogic (set to 'ParseLogic')
**SalutationFormat
**SalutationFormat (set to 'Formal')
**CorrectFirstName
**CorrectFirstName (set to 'On')
**StandardizeCompany
**StandardizeCompany (set to 'On')


* Address options:  
* Address options:  
Line 24: Line 24:


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


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

Revision as of 18:27, 2 July 2014

Similar solutions


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.
  • Currently VR10, VS01, VS31 and VS41 are not returned. They were added to Personator after Listware was coded to handle 'Verifications'.
  • 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


Back to Listware Main Page