AVI Country Validation

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
dj
Participant
Posts: 78
Joined: Thu Aug 24, 2006 5:03 am
Location: india

AVI Country Validation

Post by dj »

Hi All,

The country field when passed and AVI -country when selected Output ISO and Country fields behaves differently.

Eg:

Case :1
For a USA record when passed to AVI[USA country selected]
street,city,state,zip,country - it is Validated and country qsav is "USA"

Case:2
For a USA record-but country from input is stamped incorrectly as Mexico when passed to AVI[USA country selected]
street,city,state,zip,country - it is Validated BUT country qsav is "Mexico"

Why does AVI did not recognize the country as USA even though it parses all other address fields correctly.

Case:3
For a USA record-but country from input is blank when passed to AVI[Mexico selected]
street,city,state,zip,country - it is Validated BUT country qsav is "Mexico"

Case 4: When no country is selected in AVI, and incorrect country passed is input- still it is incorrect o/p

Which takes precedence or validates better, the country selected in AVI or input country value passed?

Does country is not derived from AVI reference files for the parsed address?

Thanks in advance
boxtoby
Premium Member
Premium Member
Posts: 138
Joined: Mon Mar 13, 2006 5:11 pm
Location: UK

Post by boxtoby »

Hi dj,

I haven't used qsav for a while, but my recollections are that the results differ depending how you pass the data in to qsav.

If you send in distinct street, city, state, zip country columns you get the best results assuming the columns contain the correct data, eg. you haven't got street and city in the same column.

If you send the street and area information as two separate columns the results aren't quite as good, but not bad.

If you send the address as a single string results tend to be varied.

Results also depend on the country, some countries simply don't have enough reference data. The US should be fine.

From your post, you appear to be using the first option. In which case I would send the problem in it's simplest form to support.

Hope that helps.

Bob.
Bob Oxtoby
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

While AVI can try to determine country code based on the input, the best practice is to send it a country code.
Regards,
Robert
dj
Participant
Posts: 78
Joined: Thu Aug 24, 2006 5:03 am
Location: india

Post by dj »

Thanks for your replies.

yes , we are passing street1,street2,city,country,postalcode as separate fields to AVI.

Does AVI do not determine the country code from Reference files based on the input addresses?

When a USA record is passed except the input country is stamped as MEX, why does AVI stamps the country as MEX? Here then standardization of the other qsav fields are independant of the country column?

Thanks
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

As I said, While AVI can try to determine country code based on the input, the best practice is to send it a country code.

It's hard to address your specific example with out specifics :)

Do you have a mixture of countries? If not, you can create set the default country in the AVI stage to US (or add a column prior to AVI with a value of US). Or you can try to use the COUNTRY rule set to assign a country code.
Regards,
Robert
Post Reply