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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Data conversion from Ebase 1.03
Pages: [1]

Author Topic: Data conversion from Ebase 1.03  (Read 1252 times)

stillstonevisions

  • Guest
Data conversion from Ebase 1.03
April 13, 2010, 09:04:27 am
My organization is working towards translating our existing Ebase 1.03 database into CiviCRM.  So far, we have many, many volunteer programming hours invested and the job is not nearly complete.  Is there no established pathway for this conversion...perhaps with scripts and some automation, or at least with well-thought out instructions?  I've done searches of this forum for "data conversion" and with Google for "ebase civicrm" but have found nothing helpful.  I can't imagine that no other organization has had to deal with this problem.

Thank you,
Paul Chubbuck
Western Colorado Congress

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Data conversion from Ebase 1.03
April 13, 2010, 10:48:31 am
I am fairly certain there is no upgrade path in particular for this. The standard approach to this situation is to output the various data sets (contacts, contributions, events etc.) into CSV files and then import them into CiviCRM using the import feature.
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.

stillstonevisions

  • Guest
Re: Data conversion from Ebase 1.03
April 13, 2010, 10:53:23 am
Yes, that is the path we are following.  It is not easy.  There are hundreds of Ebase fields.  Many are not used.  Others are calculated, and so not relevant.  Others may have no relevance in CiviCRM.  It is a tedious, error-prone task.

Paul

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Data conversion from Ebase 1.03
April 13, 2010, 10:56:44 am
> It is a tedious, error-prone task.

I am not surprised--eBase appears to be a fairly complicated piece of software.

I personally am not aware of any other approach. What you could do is keep notes as much as possible, as to what exports and imports you do, and then post here or in a wiki page, so that others could potentially benefit from that and expand upon it as well.

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.

stillstonevisions

  • Guest
Re: Data conversion from Ebase 1.03
April 13, 2010, 11:02:52 am
Thanks, Hershel.

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: Data conversion from Ebase 1.03
April 13, 2010, 11:25:38 am
The only other approach I know off is to write code to neatly adjust the source data and then call the public CiviCRM API's to add contacts, tags, groups etc. An example can be found here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Using+CiviCRM+APIs+-+Code+Snippets#UsingCiviCRMAPIs-CodeSnippets-ExampleofconversionusingAPI%27s%28contact%2Cgroup%2Ctag%2Clocation%2Crelationship%29

Mind you, this is also a tedious job. In this particular case I spend about 4 days developing and testing the conversion script. The problem is often, as I understand from your post, the translation from one database and system into another....not the technical part!
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Data conversion from Ebase 1.03

This forum was archived on 2017-11-26.