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) »
  • Similiar Situation with an import
Pages: [1]

Author Topic: Similiar Situation with an import  (Read 2978 times)

dhairston

  • Guest
Similiar Situation with an import
January 28, 2008, 01:33:30 pm
We thought we imported all the data we needed from our old system.  Now we  realized that there are a couple of fields that did not come over.

I have tried to import and update but i keep getting error messages and I dont know what I am doing wrong.  I am matching my external id and the data of the field that I am missing. What am I doing wrong!  Help quick!

geilhufe

  • I post frequently
  • ***
  • Posts: 293
  • Karma: 33
    • Social Source Software
Re: Similiar Situation with an import
January 28, 2008, 07:09:53 pm
An answer would require more information. What error messages are you getting?
Drupal and CiviCRM consulting, strategy and configuration
http://www.social-source.com/

dhairston

  • Guest
Re: Similiar Situation with an import
January 29, 2008, 08:33:30 am
It says that the information is already in the system.  Ok let mw tell you exactly what I have done.  I upload the CSV file I then map the fields and then it tells me the information was not imported.  The external contact id is already in the file.

geilhufe

  • I post frequently
  • ***
  • Posts: 293
  • Karma: 33
    • Social Source Software
Re: Similiar Situation with an import
January 29, 2008, 09:01:11 am
Based on the information you have supplied, it suggests you have not choosen Update on this line of the first import screen:
For Duplicate Contacts    Skip Update Fill No Duplicate Checking

It may also be that you have not set up the contact matching to key on the external id field in the settings:
http://sandbox.civicrm.org/civicrm/admin/dupematch?reset=1
Drupal and CiviCRM consulting, strategy and configuration
http://www.social-source.com/

dhairston

  • Guest
Re: Similiar Situation with an import
January 29, 2008, 11:44:02 am
It is definitely the second one.  The link wasnt useful to me.  I dont have a login for sandbox. 

geilhufe

  • I post frequently
  • ***
  • Posts: 293
  • Karma: 33
    • Social Source Software
Re: Similiar Situation with an import
January 29, 2008, 12:12:09 pm
sorry. The sandbox is a standard civicrm demo... username: demo password: demo

Navigating via the UI:
Administer >> Configure >> Contact matching
Drupal and CiviCRM consulting, strategy and configuration
http://www.social-source.com/

regenbauma

  • Guest
Re: Similiar Situation with an import
February 05, 2008, 07:52:27 pm
im using 1.9 on ubuntu 7
im using a csv file (that is def UTF-8)
Import gets to step 4 and simply returns back to the menu.
I see this is a documented bug
can anyone give me the sql statement to insert new individuals so that I can manually import until this is repaired ?
Much appreciation ...

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: Similiar Situation with an import
February 06, 2008, 12:06:46 am

can you please replicate your situation on the sandbox server and if so, file an issue

the sql to insert an individual is a bit complicated and there is composed of multiple sql statements

thanx

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 (Moderator: Dave Greenberg) »
  • Similiar Situation with an import

This forum was archived on 2017-11-26.