Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


address management software


address management software

Author
Message
achowe
achowe
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 1
Does anyone know of any address management software that is compliant with sql server 2000, i.e. for record duplication and address cleansing etc...

Thanks!


If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
achowe
achowe
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 1
Any suggestions appreciated!

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
planet115
planet115
SSC-Enthusiastic
SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)

Group: General Forum Members
Points: 181 Visits: 1
Can't recommend a product, but David Poole wrote an article on this topic recently, which you might find useful.

http://www.sqlservercentral.com/columnists/dpoole/dealingwithaddresses.asp

Maybe you could commission him for a nice bespoke number Smile [I'll take my usual 10% Wink ]

On the topic of skydiving, what's this all about?

http://news.bbc.co.uk/1/hi/england/lincolnshire/3050344.stm



achowe
achowe
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 1
Thanks for the inof mate.

An unfortuneate incident at a drop zone in lincolnshire..it appears someone sabotaged a parachute with obvious intentions...The sport is a closely knit community so this kind of thing saddens the day really....lets hope whoever is responsible is caught....Blue Skies!


If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
datatools12
datatools12
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 2
Yes, I recommend you to go for Data Cleansing Software and De duping software. The Data Cleansing Software will remove the erroneous data from the SQL server, and the deduping will remove the duplicate data from the Database. Both the two are Address Management Software.
For know more about click deduping software and data cleansing software .
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14955 Visits: 38949
depending on how many addresses you need to validate,(and you want to do it yourself) this link below could be an option;
i'ved used this to clean up and validate a non profits contact list of a few thousand names:


it's a CLR that you'd have to add to a 2005+ instance, which in turn has linked servers to your 2000 database;
so the data can stay on 2000, but the cleanup requires CLR, so that's 2005 at a minimum:

http://yaddressudf.codeplex.com/

as i remember it, once you hit 2000 addresses, it starts stops processing and asks you to buy into theri service, but even then it wasn't expensive(well, more expensive than free, but still)

i've got a bookmark somewhere where there is a free service from some education institution, but i never bothered making a CLR to hit that service; if you still need a free solution, i'll try to find that web service for you .

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 3816
Address clensing and deduplication is a complicated process, particularly if you want to achieve the standard required for discounts on postage.

If you want a result that looks cheap and nasty, then find something that is cheap or free.

If you want the professional result needed to qualify for discounts then you need to buy professional address management software.

Each country has its own requirements for address formatting. In the UK, the Royal Mail site has links to some of the people able to deal with UK addresses. The mail authorities in other countries may have similar links.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Stupeo
Stupeo
SSC Eights!
SSC Eights! (937 reputation)SSC Eights! (937 reputation)SSC Eights! (937 reputation)SSC Eights! (937 reputation)SSC Eights! (937 reputation)SSC Eights! (937 reputation)SSC Eights! (937 reputation)SSC Eights! (937 reputation)

Group: General Forum Members
Points: 937 Visits: 778
datatools12 (1/28/2013)
Yes, I recommend you to go for Data Cleansing Software and De duping software. The Data Cleansing Software will remove the erroneous data from the SQL server, and the deduping will remove the duplicate data from the Database. Both the two are Address Management Software.
For know more about click deduping software and data cleansing software .


Hold thread resurrection batman!!

Spam.
MMartin1
MMartin1
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1088 Visits: 2014
The US post office has a NCOA (national change of address) service. They in the process maintain a standardized version of US addresses. There are companies that buy/rent this data for address standarization/cleansing. You can send yours off to one of these services and use their alogorithms to clean up your addresses. It is usually a quick turnaround time. I dont have a company in mind but you can certainly google ncoa address cleansing or the like.

----------------------------------------------------
How to post forum questions to get the best help
vardhanhrishi
vardhanhrishi
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 16
Lowell (1/28/2013)
depending on how many addresses you need to validate,(and you want to do it yourself) this link below could be an option;
i'ved used this to clean up and validate a non profits contact list of a few thousand names:


it's a CLR that you'd have to add to a 2005+ instance, which in turn has linked servers to your 2000 database;
so the data can stay on 2000, but the cleanup requires CLR, so that's 2005 at a minimum:

http://yaddressudf.codeplex.com/

as i remember it, once you hit 2000 addresses, it starts stops processing and asks you to buy into theri service, but even then it wasn't expensive(well, more expensive than free, but still)

i've got a bookmark somewhere where there is a free service from some education institution, but i never bothered making a CLR to hit that service; if you still need a free solution, i'll try to find that web service for you .


I like your reply and its fact that it depends on requirement. I think it should be in user usage. Anyway good sharing.

Orderhive is a Multi Channel Cloud based Inventory Management Software Sign Up for FREE
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search