Page 1 of 1

UK Address Standardization

Posted: Wed Apr 07, 2010 8:24 am
by kamesh_sk
HI,

I have an Address standardization Job for UK. The QS job involves an Address PREP and then an UK address and Area rule set.
The data iam having problem is this 'FLAT 5 193 SUTTON COURT ROAD CHISWICK LONDON W4 5RT'' The prep moves ''FLAT 5 193 SUTTON COURT ROAD CHISWICK' to the Address standardization and the rest of Data to Area Standardization.
Now i dont get the word CHISWICK from outside the address standardizer.
I checked the output from all the output fields including the Unhandled values but i nowhere see this word CHISWICK....so iam missing some of my address information which is really not good. can any one help me to understand why iam losing the information....Iam an starter with Quality stage , so my excuses if i have mentioned something wrong here or missed any fundamental

Posted: Wed Apr 07, 2010 2:20 pm
by ray.wurlod
CHISWICK belongs in UKAREA, not in UKADDR. Check how you have configured the UKPREP run.

Posted: Fri Apr 09, 2010 2:20 am
by kamesh_sk
ray.wurlod wrote:CHISWICK belongs in UKAREA, not in UKADDR. Check how you have configured the UKPREP run. ...
.

Gotcha , the prep pushes it to UKADDR , could not understand why , but a override at UKADDR pushes this T+ pattern to source field , rather than to output, and hence this area getting dropped.Now managed to capture all the information though....but still wondering why the prep is pushing this to ADDR

Posted: Fri Apr 09, 2010 2:28 am
by ray.wurlod
If it looks like a bug, and smells like a bug...

Posted: Fri Apr 09, 2010 7:41 am
by stuartjvnorton
This may be a dumb question because I don't have GBPREP on hand , but is Chiswick in the CLS file?
Strangely enough, I have v7.5, but not v8. Go figure... It's not in the v7.5 CLS file. Hence my question.

Posted: Fri Apr 09, 2010 6:03 pm
by ray.wurlod
It's not there in version 8 either.

(I also note that CLWYD is but CLWYDD is not, so maybe there are other issues with this particular rule set.)

Since the GBAREA.PAT does not look up any tables, there does not appear to be any mechanism other than a classification override to handle CHISWICK. Or create a copy rule set.

Posted: Fri Apr 09, 2010 6:04 pm
by ray.wurlod
Maybe you need to check that CHISWICK really exists, and isn't just a figment of Douglas Adams's imagination?
:lol:

Posted: Sat Apr 10, 2010 1:51 am
by JoshGeorge
Override classification with Legend "R" for CHISWICK.

Posted: Tue Apr 13, 2010 3:13 am
by kamesh_sk
Chiswick is definitely an Proper Location in London

Posted: Tue Apr 13, 2010 6:49 am
by chulett
ps. Ray was joking... and perhaps meant Robert Rankin rather than DA.

Posted: Tue Apr 13, 2010 5:13 pm
by stuartjvnorton
JoshGeorge wrote:Override classification with Legend "R" for CHISWICK.
I would have thought you'd classify it as S.

A, N and R are what you end up with after you've determined the context and calling it an R up front may well cause it to not parse properly. There are several points in the processing while it's still trying to work out context where finding an A, N or R would stop processing on the field. Because an A, N or R tell it that it's already been processed.

Then you get this: 123 Chiswick St London
Giving Chiswick an R up front would cause some pretty fundamental problems with this, even if it did try to parse it.