Other data cleansing and enrichment software     Training     Support     Data for enrichment...


Tech4T provide both software and bureau services to improve your address data.

If you are looking for your data to be address improved and verified against the Postal Address Files (PAF) on a service basis, please see our address enhancement bureau services

Note. If you are moving your data to new databases, CRM, mail order or ERP systems, we can work with you to correctly enhance, transform, standardise and migrate your address information (and other data) - whether UK, European, USA or worldwide - both business to business and business to consumer. We have skills in migrating to SAP, Seibel and many other systems.

Warning. The address improvement process - especially where non-English addresses are involved - is far more complex than a single pass through batch address enhancement software.

If you need quality output - especially for data migration work - then this will involve additional (and often time-consuming) preparation and formatting stages. In addition, it is often necessary to re-run the address validation process on subsets of the data using different parameters to gradually improve results. Other considerations include:

  • How to handle output format where some records get improved to a different level from others

  • Whether the 'local' naming should be kept - Praha vs Prague. Also if marketing want a fixed field structure that works for the UK, how do you then correctly print 'local' addresses where format varies by country

  • If your system can print accented characters and if not, how should these be replaced

  • The database field layout and maximum address field lengths your system can handle - i.e. if your system can only accept: two address lines plus city, county and Postcode, then how should output that only fits into five address lines plus city etc. be restructured

  • How fields should be 'cased', records source coded and the treatment needed to remove repeated address components (from non improved records), etc.

  • The QC process needed to ensure no crucial delivery instructions are removed

This level of work is NOT undertaken as part of on-line address enhancement. Be warned.

Software for batch, interactive and website address improvement is listed below.


< GLOBAL ADDRESS

The Global Address software captures, cleanses and enhances worldwide address data, making contact with your customers and prospects a more accurate and measurable experience.

If you work with UK, Irish, USA, European or worldwide address data, then this address enhancement solution contains a comprehensive multi-national dataset (with country and continent subsets) together with software for address correction at time of data capture or in a single multi-country batch process.  More details

Matchcode 5 Interactive

< MATCHCODE ADDRESSING

Matchcode software - perfect for fast UK and Irish batch processing - will check through your database using powerful and sophisticated searching tools, adding Postcodes and inserting missing address elements. By comparing your records with 27 million addresses in the Royal Mail’s Postcode Address File (PAF), Matchcode ensures that the information is as up-to-date and accurate as possible. Even abbreviations, mis-spellings and incomplete addresses can be identified by Matchcode thanks to its unique "fuzzy matching" processes. More details

Sortcode

< SORTCODE FOR MAILSORT

Sortcode is the perfect software for achieving the maximum savings from the Mailsort and Walksort schemes. Not only does it help you achieve the discounts offered by the Royal Mail’s Mailsort programmes but it can also help you realise additional savings in the computer automation and personnel costs, giving you both time and money to deploy elsewhere. More details

Software utilities for data transformation and enrichment...

 

Data conversion, database/data audit

DBMS/Copy

Ultra-fast database sorting and transformation

CoSort

Database comparison

DBMS/Compare

Data character cleansing (for DoubleTake)

Dirty Harry

Mixed field splitting - company/people names

Right Fielder Pro

Name splitting, gender derivation

Personator Pro

Casing, salutation creation, field abbreviation

StyleList Pro

Data restructuring and manipulation

SPSS Base

Need to read files into SAS?

DBMS/Engines

Deduplication and data merge

Merge/purge Solutions


© Tech4T (Technologies4Targeting Ltd.) 2002/2004 All Rights Reserved.  www.tech4t.co.uk