One of my clients has roughly 75,000 records in their customer database. Oddly
enough, until now there has not been that great of a need for a lookup
function. Now they would like a lookup function that may go beyond the usual
elements of regular lookups.
First, there is a lot of mis-spelling or
,
State, Account #, etc
- Original Message -
From: Mark Johnson [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, January 19, 2005 8:58 AM
Subject: [U2] Customer Name Lookup
One of my clients has roughly 75,000 records in their customer database.
Oddly
enough
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Wednesday, January 19, 2005 8:59 AM
To: u2-users@listserver.u2ug.org
Subject:[U2] Customer Name Lookup
One of my clients has roughly 75,000 records in their customer database.
Oddly
enough, until now there has
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Wednesday, January 19, 2005 9:36 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Customer Name Lookup
First by eliminating all spaces, special characters, and UPCASEing
a lot
First, there is a lot of mis-spelling or alternate spelling of
similar names.
For example, K-mart is spelled K-Mart, K Mart and KMART. This is not a
situation of simple word lookups. There needs to be some
intuition as well.
Sometimes there's THE INDUSTRIAL DISTRIBUTION COMPANY (example)
Been there, done that. Here are a few potential suggestions:
1. Keep a library of throwaway words, and omit them from any cross
reference. Perhaps Industrial should not be one of them.
2. Use soundex on each non-throwaway word, and index them.
3. Index each non-throwaway word, as entered.
4.
Mark, One way is to create a file that uses the incorrect spelling of the
name as the record id and have the first line of the record contain the
correct spelling of the company name. When the user enters the company
name check against a file/table to see if this is the correct spelling. If
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Customer Name Lookup
Sounds to me like a need to have strict standards for naming convetions
implemented within the user community, as well as programatically
verified
at data entry point, or search point, and the bad data
consolidated/purged.
All
Sent: Wednesday, January 19, 2005 11:02 AM
Subject: RE: [U2] Customer Name Lookup
I know there are companies out there that offer data scrubbing
service...
You give them your customer master, they scrub it and give it back.
---
u2-users mailing list
u2-users@listserver.u2ug.org
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.302 / Virus Database: 265.7.1 - Release Date: 19/01/05
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.302 / Virus Database: 265.7.1 - Release Date: 19/01/05
---
u2-users mailing
Mark, you may want to look for a subroutine that uses the principles that were
used by mailing houses to correct such problems, the USPS had some guide lines
for doing this. It has been done for years and in the past it was all batched
processed.
D Raven
cell (949)2282224
e Fax (815)4259364
of hand as time goes on. Plus their user base is from another land so
that enters in some mis-spellings.
Thanks.
- Original Message -
From: Norman Morgan [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, January 19, 2005 10:31 AM
Subject: RE: [U2] Customer Name Lookup
consistently a day late and a dollar
short.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Wednesday, January 19, 2005 7:18 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Customer Name
Consider getting a zip code file so you can prompt for zip code before
city/state and then having the user choose from the available town names
and defaulting to state. Bound to prevent a bunch of misspellings.
Mark Johnson wrote:
INDUSTRIAL and DISTRIBUTION were examples. I can't remember but
Mark Johnson wrote:
I may use the purge method to scrub the data and assign
some consistency. That's fine as a manual job for me, but
on-going I think it's going to get out of hand as time
goes on. Plus their user base is from another land so
that enters in some mis-spellings.
Kevin King
15 matches
Mail list logo