address management software

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » address management software

address management software

Rate Topic

Display Mode

Topic Options

Author

Message

achowe

Posted Monday, July 07, 2003 2:05 AM

SSC-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

achowe

Posted Monday, July 07, 2003 5:23 AM

SSC-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

planet115

Posted Monday, July 07, 2003 5:57 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 08, 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

achowe

Posted Monday, July 07, 2003 6:35 AM

SSC-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

datatools12

Posted Monday, January 28, 2013 5:07 AM

Forum 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

Lowell

Posted Monday, January 28, 2013 6:08 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 5:28 PM
Points: 11,627, Visits: 27,692

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

EdVassie

Posted Tuesday, January 29, 2013 4:10 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:57 AM
Points: 2,621, Visits: 2,758

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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

Stupeo

Posted Tuesday, January 29, 2013 4:22 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 07, 2013 3:07 AM
Points: 890, Visits: 774

datatools12 (1/28/2013)

Hold thread resurrection batman!!

Spam.

Post #1412899

mmartin1

Posted Thursday, April 11, 2013 4:56 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:43 PM
Points: 192, Visits: 640

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

« Prev Topic | Next Topic »

Permissions