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) »
  • Importing Database from Raiser's Edge with Multiple Tables
Pages: [1]

Author Topic: Importing Database from Raiser's Edge with Multiple Tables  (Read 3647 times)

jazzman

  • Guest
Importing Database from Raiser's Edge with Multiple Tables
May 20, 2010, 02:40:16 pm
Could anyone point me in the direction of instructions on how to import clients with multiple tables.  These original tables are coming out of Raiser's Edge.

Many thanks,
Andy

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Importing Database from Raiser's Edge with Multiple Tables
May 21, 2010, 01:56:01 am
Are these tables that you need to import structured in such a way that you can use the standard import function? If not, you would first need to do some manipulation with either SQL or a script?
The instructions of using the standard import can be found here : http://en.flossmanuals.net/CiviCRM/ContactsAddingAndImporting
Erik
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Importing Database from Raiser's Edge with Multiple Tables
May 21, 2010, 03:10:26 am
I think Erik's suggestion is the best--try first to export your data in a "flat" format like CSV and then you can use the existing CiviCRM import features.

If you can't export it flat, then let us know more details about the structure of the data.

HTH
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Importing Database from Raiser's Edge with Multiple Tables
May 21, 2010, 03:45:45 am
If the import is more complicated that "simply" the contacts (eg needs to create groups, tags, contact sub types, relationships and so on), we found it easier to write a php script that uses the api and call the various functions.

bonus point, you can run it from the shell, don't timeout/load issues and you don't end up clicking 10 zillion time on the import wizard.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Importing Database from Raiser's Edge with Multiple Tables
May 21, 2010, 03:52:23 am
Personally I agree with Xavier, I find it a lot easier to use the API's in a script....but I can also imagine it is a little to much (PHP and stuff) for some people. If you are familiar with developing, go for the script option. In my experience, migration data is never consistent and always needs mapping or other manipulation.
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

hassab

  • Guest
Re: Importing Database from Raiser's Edge with Multiple Tables
May 21, 2010, 07:54:53 am
Hi all,

I work with Jazzman - we are trying to import some data that may be more complicated than the current setup in CiviCRM - for example, gifts being split out into multiple appeals/campaigns, etc.  Our question was actually twofold:

1.  Are we able to create new tables in CiviCRM to house custom data?
2.  If so, would we then be able to import into those tables?

Thanks,
Hassab

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: Importing Database from Raiser's Edge with Multiple Tables
May 21, 2010, 08:02:50 am

yes, check:

http://en.flossmanuals.net/CiviCRM/CiviConfigExtendingCoreData

you can import into single record custom groups. Would be good for u and jazzman to read the book:

http://en.flossmanuals.net/CiviCRM

and get an idea of the structure of civicrm before embarking on the import process

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing Database from Raiser's Edge with Multiple Tables

This forum was archived on 2017-11-26.