Using an Address formatting and validation service before entry into RE

Chris Zello
Chris Zello
Sixth Anniversary Kudos 2 Name Dropper Participant
in Blackbaud Raiser's Edge NXT®: General Discussions

Has anyone used an Address service that will accept a CSV file, in order to verify that the address is accurate and formatted before entry into RE?

While I have AddressFinder and AddressAccelerator those tools only work when the address is in the system. I'm trying to find if it is possible to do this BEFORE import, in order to speed up processing.

Suggestions? Thanks.

Tagged:

Comments

  • Christine Robertson
    Christine Robertson
    Kudos 5 Name Dropper Participant First Anniversary

    @Chris Zello When I was still working at Zeidman Development, the developers added the option to set addresses to USPS formatting (part of the paid options in Importacular). It abbreviates according to USPS standards, but it doesn't add the 4-digit extension or verify that the address is still accurate. I'm not sure that will do what you're looking for but it's the only option of the type that I'm aware of.

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Chris Zello
    Import O Matic also have a Omatic Data Service that does the similar work, but you should reach out to them for details.

    if you want to use Power Automate flow to automate your own, though it is consier med/high code, there are USPS Address API, Google Map address validate api, etc that can be used too.

Categories