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