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 (Moderator: Dave Greenberg) »
  • Can I copy custom fields from another installation
Pages: [1]

Author Topic: Can I copy custom fields from another installation  (Read 2057 times)

mcsmom

  • I post frequently
  • ***
  • Posts: 266
  • Karma: 23
    • Official Joomla! Book
  • CiviCRM version: 4 and 3.4
  • CMS version: Joomla!
Can I copy custom fields from another installation
August 17, 2007, 08:31:36 am
I have one installation with a bunch of custom fields set up the way I want.
I have a fresh install that I want to use the same fields for.
If I go into mysql can I export from the old and import into the new? Is there anything tricky that would be involved?

Also, I guess I have the same question for profiles.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can I copy custom fields from another installation
August 17, 2007, 12:15:20 pm
Yes it is possible.
1. Take data dump of following tables : civicrm_custom_group, civicrm_custom_field, civicrm_uf_group and civicrm_uf_field from your old installation.
2. Make sure all above tables are empty in new installation (just to avoid duplicate id error etc.).
3. Import data dump in new installation.

I hope both your CiviCRM installations are running on same CiviCRM version.

HTH

Kurund
Found this reply helpful? Support CiviCRM

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Can I copy custom fields from another installation
August 17, 2007, 02:38:11 pm
Elin - Assuming you DO NOT want to copy over custom field VALUES - but only the custom group and custom field configurations...the answer below is correct HOWEVER...

If any of your custom fields are SELECT, RADIO, or CHECKBOX (i.e. multiple choice) - then you ALSO need to copy over all records from civicrm_custom_option WHERE entity_table = ' civicrm_custom_field'.

Regards,
dave
Protect your investment in CiviCRM by  becoming a Member!

mcsmom

  • I post frequently
  • ***
  • Posts: 266
  • Karma: 23
    • Official Joomla! Book
  • CiviCRM version: 4 and 3.4
  • CMS version: Joomla!
Re: Can I copy custom fields from another installation
August 21, 2007, 07:41:21 pm
Thank you! That saves me a lot of time recreating fields. :)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Can I copy custom fields from another installation

This forum was archived on 2017-11-26.