RE: iSeries Address standardization and lookup software

Sounds like our new town.

Our house is referred to as "Granny Royer's old place". Pronounced ROY-AY

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: Friday, March 14, 2014 2:55 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: iSeries Address standardization and lookup software

we have similar situations with our customers...
they "have always gone by" "the corner of I-45 and prairie ridge road"
we also have strange "ship to" locations like "up the road a bit" :)

we force our customer reps to provide a address that is verified USPS,
and compute nexus on that.... we do allow a different address for
"delivery paperwork"



On 3/14/2014 2:32 PM, DeLong, Eric wrote:

That sounds odd... These "install addresses" aren't stored anywhere? How

do you know where to send the stuff to be installed? I'm sure you didn't
mean that, but you imply that you have no way of applying address
standardization to them... I'm confused.

We have a standardized address format and service programs to apply the

address correction business on all address changes (or adds). We can apply
this to any address, within any file, fairly consistently. I'm sure
something similar would work for you.

Not trying to put you off, just curious...
-Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx

[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steinmetz, Paul

Sent: Friday, March 14, 2014 1:19 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: iSeries Address standardization and lookup software

I want to thank everyone for their input.
One issue, which I don't think anyone's software will handle, is we have

many customers whose physical install address is different than their postal
mailing address. Because of this, install address will not be in the address
data base, thus cannot verify/validate nor determine the location for
mapping and/or taxing/franchise purposes.

Paul

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx

[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric

Sent: Friday, March 14, 2014 1:15 PM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries Address standardization and lookup software

I have used Per/ZIP4 for address standardization and correction. The only

issue I've noticed is that the USPS does not list all physical locations in
its database. Some street addresses are not serviced by mail delivery
(perhaps PO Box only), and it sometimes takes a while for new addresses to
come into the database. I think most of these issues are due to USPS and
not really the fault of the vendor.

Hth,
-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx

[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steinmetz, Paul

Sent: Friday, March 14, 2014 12:02 PM
To: 'Midrange Systems Technical Discussion'
Subject: iSeries Address standardization and lookup software


We currently use Group1 CODE1-Plus software, for inquiry lookups and for

address standardization.

We call Code1-Plus 'C1MATCHI' to return an address in a standardized

format, from 2 different databases, then we compare the results to see if
equal.

We are looking for replacement options, annual maintenance is high

(5-digits)

Does anyone use any address standardization and/or address inquiry

software on the iSeries.

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx
http://www.pencor.com/