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) »
  • can I move data from one field to another?
Pages: [1]

Author Topic: can I move data from one field to another?  (Read 1483 times)

twowheeler

  • I post occasionally
  • **
  • Posts: 115
  • Karma: 11
    • Harrisburg Christian Performing Arts Center
  • CiviCRM version: 4.3.4
  • CMS version: Drupal 7.22
  • MySQL version: 5.1
  • PHP version: 5.3
can I move data from one field to another?
May 25, 2007, 06:41:07 pm
I have imported a lot of data from our old application in MS Access, and mostly it has gone very well.  I made a mistake though with one field.  I uploaded the prefix data into the wrong field, like Mr or Ms etc.  I want to move it over to the prefix field.  How do I do that?  I thought about exporting it to a file and then importing it back in, but am afraid that might be error-prone.  Any suggestion welcome.

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: can I move data from one field to another?
May 26, 2007, 02:58:29 am

if you are comfortable with sql, you might want to just write an update statement to update the civicrm_individual table with the right prefix_id based on the column in which it currently is, and then reset that column to null

If you dont know sql too well, might be easier to follow your export/import suggestion

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

twowheeler

  • I post occasionally
  • **
  • Posts: 115
  • Karma: 11
    • Harrisburg Christian Performing Arts Center
  • CiviCRM version: 4.3.4
  • CMS version: Drupal 7.22
  • MySQL version: 5.1
  • PHP version: 5.3
Re: can I move data from one field to another?
May 26, 2007, 03:29:42 am
Ok, thanks.  The export-import thing worked.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • can I move data from one field to another?

This forum was archived on 2017-11-26.