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) »
  • Portable Import/Export Mappings
Pages: [1]

Author Topic: Portable Import/Export Mappings  (Read 1552 times)

DerekL

  • I post frequently
  • ***
  • Posts: 132
  • Karma: 1
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.54
  • PHP version: 5.2.17
Portable Import/Export Mappings
October 19, 2011, 07:46:10 pm
Hi All,

I would like to know if anyone knows of a way to "copy and paste" import/export mappings from one civicrm site to another?

I have two dev sites on which I've been working on different components and the time to consolidate them, and possibly to go a staging server is near. I'd like to know if there is a way to save a few hours in redoing all the field mapping.

Thanks!

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: Portable Import/Export Mappings
October 20, 2011, 01:14:55 am
no idea why you have done the dev on two separate sites but it may be worth trying an export import of the required rows from the civicrm_mapping and civicrm_mapping_fields and provided you get all the necessary bits aligning and change the ID numbers to match you might get away with it
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

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: Portable Import/Export Mappings
October 20, 2011, 06:13:39 am

there are two scripts:

bin/migrate/export.php
bin/migrate/import.php

export converts your DB data into xml format and import takes this xml file and add it to your existing DB

These scripts do a lot of other objects at the same time (custom/profile group,fields etc). You can try using that and see if it works for you. Would be great if you can:

1. Write documentation for these scripts on the wiki
2. Extend them to make them more configurable

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

DerekL

  • I post frequently
  • ***
  • Posts: 132
  • Karma: 1
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.54
  • PHP version: 5.2.17
Re: Portable Import/Export Mappings
October 22, 2011, 11:53:22 am
Thank for the tip!

I will DEFINITELY be looking into this, I'd be honored to give something back to civi.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Portable Import/Export Mappings

This forum was archived on 2017-11-26.