CiviCRM Community Forums (archive)

Having a lot of frustration getting contacts imported.  Using 4.0.7 on Drupal, new installation and user.  I have a 2 line test import record with about 55 columns on it (many of them skipped).  I do have some custom data configured that some of the import is supposed to flow into.  The purpose of this import is to bring in our data from our old system.  The old system is a relational database, no duplicates, so I have set the option to not dedupe.  I selected the existing ID column as the Internal Identifier.

When I "Continue" from step 3 to step 4, I get the following error:

    Notice: Undefined index: custom in _civicrm_add_formatted_param() (line 352 of /home/botany/domains/civicrm.botany.org/public_html/sites/all/modules/civicrm/api/v2/utils.v2.php).
    Notice: Undefined index: contact_type in _civicrm_add_formatted_param() (line 353 of /home/botany/domains/civicrm.botany.org/public_html/sites/all/modules/civicrm/api/v2/utils.v2.php).
    Notice: Undefined index: prefix_id in _civicrm_add_formatted_param() (line 210 of /home/botany/domains/civicrm.botany.org/public_html/sites/all/modules/civicrm/api/v2/utils.v2.php).
    Notice: Undefined variable: newContact in CRM_Import_Parser_Contact->import() (line 654 of /home/botany/domains/civicrm.botany.org/public_html/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php).
    Notice: Undefined variable: newContact in CRM_Import_Parser_Contact->import() (line 685 of /home/botany/domains/civicrm.botany.org/public_html/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php).
    Notice: Undefined variable: newContact in CRM_Import_Parser_Contact->import() (line 685 of /home/botany/domains/civicrm.botany.org/public_html/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php).
    Notice: Undefined variable: newContact in CRM_Import_Parser_Contact->import() (line 695 of /home/botany/domains/civicrm.botany.org/public_html/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php).

The mapping was not created (grrrrr...)

OK, so I am thinking that my usage of the Internal Identifier is wrong, so I chose to not import that (I'll figure out how to set relations later).  This time I get similar errors to above, but my records do import.  But still no field mapping saved (GRRRR...)

What am I doing wrong?

How do I contruct this import so that I can preserve relations (for example, import old membership records, donations and other data).

Thanks.

Thanks.  I've run the import on the demo site with my 2 record import file.  The results were just like my own site.

It occurs to me I might be severely misunderstanding what's supposed to happen.  Just like my site, I get this:

http://drupal.demo.civicrm.org/civicrm/admin/mapping?action=update&id=1&reset=1

However there aren't any mappings to edit, and the notice below says "There are currently no saved import or export mappings. You create saved mappings as part of an Import or Export task. "  Which tells me that the "header" of the mapping is saved, but not the actual field mappings themselves.  Otherwise, what's the point of "Edit Mappings" other than to change the name and description(?).

Anyway, I only mapped three of the fields; SHIPLNAME, SHIPMNAME, SHIPFNAME.  I checked the box for the first line including column headings, and selected no duplicate checking.  Import file attached.

Check:

http://drupal.demo.civicrm.org/civicrm/admin/mapping?action=browse&reset=1

however on that screen, u only change the name / description. You update the mapping in import/export. You can load/create/update a mapping via the import screens. Can you file an issue for the bad message (http://issues.civicrm.org/)

i'd assign them to the "external_identifier" field

lobo