CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Question about mass updating postal addresses for NCOA
Pages: [1]

Author Topic: Question about mass updating postal addresses for NCOA  (Read 1650 times)

jbourne

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CMS version: Joomla
  • MySQL version: 5.x
  • PHP version: 5.x
Question about mass updating postal addresses for NCOA
January 30, 2011, 07:24:12 pm
I've tried googling the forums and the 'net in general for some kind of discussion on this and I can't find any lengthy discussions.  I have not installed CiviCRM yet but I plan to.  I have in the neighborhood of 60,000 records and I want to be able to do regular national change of address comparisons on the data.

That is going to require me to do mass updates on existing data in the database.  How does civiCRM handle this kind of bulk change of address on existing records?

Is this a common feature request that is actually supported natively somehow?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Question about mass updating postal addresses for NCOA
January 31, 2011, 06:21:52 am

This has not come up in a long time :) I dont think there is support for this in the current code base. There is integration with the USPS web service system that also does something similar

However, there is a script called bin/UpdateAddress.php which is a command line script that call and external webservice to geocode all addresses in the system. Modifying this script to call the NCOA web service (or use a csv file) and update the address should not be too hard for someone with php/mysql/civicrm skills

if you do so, please share your changes so others can benefit

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: Question about mass updating postal addresses for NCOA
June 27, 2012, 12:57:06 pm
I've written up some thoughts here: http://wiki.civicrm.org/confluence/display/CRM/Change+of+Address+Updates

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: Question about mass updating postal addresses for NCOA
July 03, 2012, 07:36:50 am
And in further trying to understand how email and snail addresses are updated along with their communication preferences, I did some testing and derived these Address Update Rules http://wiki.civicrm.org/confluence/display/CRM/Address+Update+Rules (which I hope are correct!).
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Question about mass updating postal addresses for NCOA

This forum was archived on 2017-11-26.