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) »
  • Techniques for Reorganizing Custom Fields
Pages: [1]

Author Topic: Techniques for Reorganizing Custom Fields  (Read 1151 times)

Denver Dave

  • Ask me questions
  • ****
  • Posts: 471
  • Karma: 9
Techniques for Reorganizing Custom Fields
December 28, 2007, 12:04:44 pm
It is hard to know the best configuration of custom fields until we have tried them out for a while.  I don't believe that the format of custom fields can be changed, so I'm periodically creating new custom fields, exporting the database, setup the values for the new custom field (or sometimes manually changing in CiviCRM) and uploading the data.

We seem to be able to export all records, but have to import back in batches of 600.  Is export / re-import the best approach (other than getting fields right to start with), or are there other techniques that others are using.  As our database grows about 2,000 reorganizing custom fields becomes harder.

Suggestions?
« Last Edit: December 28, 2007, 10:14:29 pm by Denver Dave »

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: Techniques for Reorganizing Custom Fields
December 28, 2007, 06:48:38 pm

This will be significantly easier in 2.x when all custom values for a specific field are stored in a column in a newly created table. as such u'll need to do an alter statement only.

in v1.9, you could accomplish the same with a couple of sql queries to copy the value to the right "data" field for the new type, assuming type conversion is possible between the two

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

Denver Dave

  • Ask me questions
  • ****
  • Posts: 471
  • Karma: 9
Re: Techniques for Reorganizing Custom Fields
December 28, 2007, 10:15:20 pm
Thanks - I wondered about the SQL approach.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Techniques for Reorganizing Custom Fields

This forum was archived on 2017-11-26.