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) »
  • Trouble with matching fields on contact import
Pages: [1]

Author Topic: Trouble with matching fields on contact import  (Read 486 times)

corvi

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 3.4
  • CMS version: Drupal 6
  • MySQL version: .
  • PHP version: .
Trouble with matching fields on contact import
November 18, 2013, 08:22:19 am
Hello all,
I've been working on a Civi upgrade project, using a dev site rather than the live one for testing purposes. The main database was exported/imported using mysqldump, but now I just need to add the newer data that's been added in the last week. Tried to use the Civi export/import features, but am having issues getting the fields to match. Whether I select export Primary fields, or custom ones, it's the same issue.. when I go to import, the available fields don't match, including the Internal Contact ID (which I thought was standard across the board), Contact Type, etc.

What am I missing here? 

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: Trouble with matching fields on contact import
November 18, 2013, 09:37:11 am
I am guessing you have the Import in Step 1 set to 'skip' and hence the Internal Contact ID is not provided to you.

I just checked on the Drupal Demo version and it is there if you set to 'update' and is not there if you set to 'skip'.

If that isn't the issue, I have no idea. sorry
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

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: Trouble with matching fields on contact import
November 19, 2013, 04:15:44 am
It looks like you did not check the "First row contains column headers" box in step one.  That is why the column headers are appearing as the first record.  As a result, Civi does not know how to match your fields. 
 

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: Trouble with matching fields on contact import
November 19, 2013, 10:12:57 am
The answer may be both - but #2 does not cause you to not find the Internal ID - that is #1 i suspect
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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Trouble with matching fields on contact import

This forum was archived on 2017-11-26.