Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

address management software Expand / Collapse
Author
Message
Posted Monday, July 7, 2003 2:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 30, 2005 4:25 AM
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!
Post #13891
Posted Monday, July 7, 2003 5:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 30, 2005 4:25 AM
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!
Post #69359
Posted Monday, July 7, 2003 5:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 8, 2004 10:31 AM
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 :) [I'll take my usual 10% ;) ]

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

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




Post #69360
Posted Monday, July 7, 2003 6:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 30, 2005 4:25 AM
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!
Post #69361
Posted Monday, January 28, 2013 5:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 28, 2013 5:05 AM
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 .
Post #1412352
Posted Monday, January 28, 2013 6:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:50 AM
Points: 12,877, Visits: 31,792
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1412384
Posted Tuesday, January 29, 2013 4:10 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:50 AM
Points: 2,854, Visits: 3,174
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 2014, 2012, 2008 R2, 2008 and 2005. 29 May 2014: now over 29,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1412892
Posted Tuesday, January 29, 2013 4:22 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, April 13, 2014 11:32 AM
Points: 939, 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.
Post #1412899
Posted Thursday, April 11, 2013 4:56 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 308, Visits: 812
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.
Post #1441521
Posted Tuesday, March 4, 2014 3:34 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 3:55 AM
Points: 4, Visits: 8
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 Systems | Order Management Software | Contact Management System. Sign Up for FREE
Post #1547223
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse