US address verificaiton and Navision

David_Singleton · 2012-08-17

Does anyone have any experience (and can recommend) a program for verifying USPS addresses?

I basically want to go through thousands of customers in a Navision db, feed them into the verifying software, and get back correct addresses including 5-4 zip codes. Either something with OCX I can call direct in Navision, or failing that one where I can export (eg CSV) and get back a fixed file, or even something direct connecting to SQL.

Thanks.

ara3n · 2012-08-18

Hmm. I wonder where I've seen this.

http://mibuso.com/blogs/ara3n/2009/02/1 ... nitiative/

Savatage · 2012-08-18

I've also played around with the Address Validation - Street Level in ups:
https://www.ups.com/upsdeveloperkit/dow ... ?loc=en_US

we have a ups account so after filling out a few request got my id.

We soon went with Endicia Professional that does the address verification and adjustment automaticly upon shipping.
http://www.endicia.com/products/professional/

David_Singleton · 2012-08-18

David Singleton wrote:

Does anyone have any experience (and can recommend) a program for verifying USPS addresses?

I basically want to go through thousands of customers in a Navision db, feed them into the verifying software, and get back correct addresses including 5-4 zip codes. Either something with OCX I can call direct in Navision, or failing that one where I can export (eg CSV) and get back a fixed file, or even something direct connecting to SQL.

Thanks.

Thanks Rashed and Harry, but I don't see how either of these returns the corrected address?

Most importantly I need to get the full zip code.

David_Singleton · 2012-08-18

This web site:

http://www.cedar.buffalo.edu/cgi-bin/nasciic

does exactly what I need, but I need a way to do this in bulk, rather than one off.

ara3n · 2012-08-18

If you look at this report the left column is address from NAV, the right column is address verified from Yahoo. As you can see it has the zip code on right column

Savatage · 2012-08-18

says you can do a batch of 1000 at a time

http://www.melissadata.com/lookups/batc ... scheck.asp

David_Singleton · 2012-08-18

ara3n wrote:

If you look at this report the left column is address from NAV, the right column is address verified from Yahoo. As you can see it has the zip code on right column

Ah OK I see now what you are doing. I will look into that more. Thanks.

Also I was trying to avoid a "Free" web based solution if possible, I was more interested in something I can pay for and call the company with questions when it doesn't work.

David_Singleton · 2012-08-18

Savatage wrote:

says you can do a batch of 1000 at a time

http://www.melissadata.com/lookups/batc ... scheck.asp

1,000 a time wont be enough

ara3n · 2012-08-20

David Singleton wrote:

Also I was trying to avoid a "Free" web based solution if possible, I was more interested in something I can pay for and call the company with questions when it doesn't work.

I mentioned USPS who do support and you pay them for the service. I've provided the solution for the integration and you can call them if their service isn't working.

David_Singleton · 2012-08-20

ara3n wrote:

I mentioned USPS who do support and you pay them for the service. I've provided the solution for the integration and you can call them if their service isn't working.

Actually USPS was the first web site I looked at before posting here. I couldn't find what I was looking for. Also I may have misunderstood your blog. I thought you said that the USPS service can only be used at order entry time (one off) where I need to batch process thousands of addresses in one hit to clean the database first.

ara3n · 2012-08-20

They do have a batch process, but they send you a DVD so that you can test it locally. They recommend that approach instead.

David_Singleton · 2012-08-20

ara3n wrote:

They do have a batch process, but they send you a DVD so that you can test it locally. They recommend that approach instead.

ok I just saw that on your blog. :thumbsup:

Thanks that is probably what we need.

davmac1 · 2012-08-20

Years ago I used a service from Melissa to do batch address verification and deduping.
You could check with them on whether they provide the service the way you need it.

http://www.melissadata.com/address-veri ... /index.htm

David_Singleton · 2012-08-20

davmac1 wrote:

Years ago I used a service from Melissa to do batch address verification and deduping.
You could check with them on whether they provide the service the way you need it.

http://www.melissadata.com/address-veri ... /index.htm

Thanks I will check this out as well.

US address verificaiton and Navision

Comments

Categories