December 9, 2014 at 7:12 am
Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients addresses, we are switching systems and need to cleanse the data on our servers, I am wanting to know if this would violate the terms of use policy, we aren't creating shipping labels, or shipping with another company(FEDEX,UPS) we just want to check that it is a valid address before importing into the new system, if it isn't than make our Contracts or Accounting department fix it.
December 9, 2014 at 7:34 am
I am wanting to know if this would violate the terms of use policy, ...
Please provide some more context. You're concerned about violating the terms of use policy for what product or edition?
SQL Server Developer Edition?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 9, 2014 at 7:48 am
cbrammer1219 (12/9/2014)
Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients addresses, we are switching systems and need to cleanse the data on our servers, I am wanting to know if this would violate the terms of use policy, we aren't creating shipping labels, or shipping with another company(FEDEX,UPS) we just want to check that it is a valid address before importing into the new system, if it isn't than make our Contracts or Accounting department fix it.
You would have to check with the USPS terms of use policy.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 9, 2014 at 7:54 am
cbrammer1219 (12/9/2014)
Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients addresses, we are switching systems and need to cleanse the data on our servers, I am wanting to know if this would violate the terms of use policy, we aren't creating shipping labels, or shipping with another company(FEDEX,UPS) we just want to check that it is a valid address before importing into the new system, if it isn't than make our Contracts or Accounting department fix it.
I still can't see the straight forward question :hehe:
December 9, 2014 at 7:55 am
Emil Bialobrzeski (12/9/2014)
cbrammer1219 (12/9/2014)
Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients addresses, we are switching systems and need to cleanse the data on our servers, I am wanting to know if this would violate the terms of use policy, we aren't creating shipping labels, or shipping with another company(FEDEX,UPS) we just want to check that it is a valid address before importing into the new system, if it isn't than make our Contracts or Accounting department fix it.I still can't see the straight forward question :hehe:
It is somewhat buried but reading the original question is it quite obvious.
I am wanting to know if this would violate the terms of use policy
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 9, 2014 at 8:00 am
Yes it is straight forward...Using the web tools is it a violation of use if I just use the tools for validating addresses, for such smart individuals, you like to make things more complicated.
December 9, 2014 at 8:02 am
Emil Bialobrzeski (12/9/2014)
cbrammer1219 (12/9/2014)
Ok I have a fairly straight forward question, wondering if anyone knows the answer. I have been tasked to use USPS Address tools to validate our clients addresses, we are switching systems and need to cleanse the data on our servers, I am wanting to know if this would violate the terms of use policy, we aren't creating shipping labels, or shipping with another company(FEDEX,UPS) we just want to check that it is a valid address before importing into the new system, if it isn't than make our Contracts or Accounting department fix it.I still can't see the straight forward question :hehe:
We don't work for FEDEX or UPS. I assumed this was a perhaps a question about leveraging an instance of SQL Server Developer Edition for the purpose of one time data scrubbing, but it's not stated that way.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 9, 2014 at 8:07 am
That is what I am wanting to do, but it states for use on websites, I don't want to use for a website.
December 9, 2014 at 8:08 am
cbrammer1219 (12/9/2014)
Yes it is straight forward...Using the web tools is it a violation of use if I just use the tools for validating addresses, for such smart individuals, you like to make things more complicated.
Agreed. Not sure why it is hard to have just actually read your question. While perhaps worded perfectly it is pretty obvious when reads the words what you are asking.
However, as stated we are not experts at the terms of use for the USPS webservices agreement. You will have to read the terms of use as posted by the USPS in order to find your answer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 9, 2014 at 8:12 am
There are limits on how many addresses you can send how quickly to the USPS webservice validation tool, so no they do not want you using it for doing bulk validation jobs of your entire database(well depending on how big your database is).
Of course they may have changed that since I last used it.
December 9, 2014 at 8:31 am
Without reading their terms and conditions I would say give it a go, if they have some sort of security in place that only mean you won't be able to validate all of your addresses, on the other hand if they don't, they are ok with people abusing "them"
December 9, 2014 at 8:41 am
Thank You for your response, very constructive and straight to the point. Our database isn't very large at all, maybe 70,000 plus rows give or take. And this is something that SSIS is capable of doing? Right. Any good articles that you know of that discusses accomplishing this, I have began searching for data scrubbing, and found a couple but not sure I am headed in the right direction.
December 9, 2014 at 9:20 am
There are many commercial providers of address data. This would be better than attempting to make a web service call for each record in an ETL process.
http://zipinfo.com/products/natzip4/natzip4.htm
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 9, 2014 at 9:28 am
Eric M Russell (12/9/2014)
There are many commercial providers of address data. This would be better than attempting to make a web service call for each record in an ETL process.
The USPS one is free 😛
December 9, 2014 at 9:32 am
Yes...I thought that too. I am looking into using it, just trying to find the best way to start...researching the process. Thanks for the help.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply