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) »
  • Import experience
Pages: [1]

Author Topic: Import experience  (Read 1653 times)

bmodesign

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
Import experience
May 04, 2009, 02:59:08 pm
Just wanted to share my experience with importing. I'm using current releases of Drupal and CiviCRM.

I have a pretty big database that I'm migrating to CiviCRM. The match fields functionality is a life saver. I first setup all of my custom fields, and profiles for my contacts, then inserted a test sample of 20-30 people, and went from there to importing about 400 at a time. Everything imported great, unless I tried to go over 400. If there was ever an error, I could easily download the troubled rows of info, fix it, then re-upload it with another mapping I made for my error documents. It's great!

Since it was a membership database it's a 3 step process. I first uploaded contact info, then uploaded membership info, and then uploaded Drupal Users that matched the contact records through email (you only have to do the Drupal part if you want them to be users on your website). I setup up profiles in CiviCRM that shows user data in your Drupal Account page.

One hiccup. My shared hosting provider just shut me down for a while. I'm signed up on a business class hosting, mid range, unlimited everything, that's not so unlimited...  They say that during my imports I raised the processing of their servers beyond the 'shared hosting limit'. So, I'm researching another way of importing... I'm a newbie, so I was using just csv files like normal. How do I use the MySQL table way of importing? would that be less load on their system?

Any replies or suggestions are appreciated. Take care,
Bmodesign.

robinhood

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 6
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.56
  • PHP version: 5.3.5
Re: Import experience
May 04, 2009, 05:03:53 pm
Personally I would take this problem back to the hosting provider.  My goodness, importing 400 records should not exceed the processing limit on the account.  If you are paying for business class, unlimited everything, service, you obviously aren't getting it.  Tell them what you need to do and see if you can work something out, like times of day when they will let you exceed these limits for example.  Or, ask for a week when the limit does not apply so you can get the import done.  You can always threaten to take your business elsewhere. 
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import experience

This forum was archived on 2017-11-26.