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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Birthdate incorrectly mapped .. to fix?
Pages: [1]

Author Topic: Birthdate incorrectly mapped .. to fix?  (Read 1198 times)

nimzie

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 1
Birthdate incorrectly mapped .. to fix?
November 12, 2008, 08:46:19 am
I did an import for a client. In this import, I inadvertently imported a member start date as birthdate. I was hoping I could just rename Birthdate to Member Start Date somewhere, but I can't.

How can I:
blank all the birthdates

move these dates to a new "member start date" field?

Is this possible?

Thanks,
Adam

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: Birthdate incorrectly mapped .. to fix?
November 12, 2008, 09:42:13 am

to blank birthdates is quite simple. from a mysql command line (or phpMyAdmin):

 UPDATE civicrm_contact SET birth_date = null WHERE SOME_CONDITIONS_YOU_SPECIFY

copying the birthdates to a member start field is more complicated and depends on some other factors like membership type etc. You'll also need to update the membership_log table

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

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Birthdate incorrectly mapped .. to fix?
November 12, 2008, 12:25:48 pm
Consider re-importing in order to updat the member start date?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Birthdate incorrectly mapped .. to fix?
November 12, 2008, 02:33:29 pm
Seconding peter d, since member start date is imported with memberships under CiviMember - a separate operation from importing contact records (which is where the Birth Date import would have happened).
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Birthdate incorrectly mapped .. to fix?

This forum was archived on 2017-11-26.