Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 2.2.8
-
Fix Version/s: 3.0
-
Component/s: Core CiviCRM
-
Labels:None
Description
To replicate:
(1) Import Contacts Step 1: choose data source SQL query, enter:
SELECT 'Testy' AS `First Name`, 'Tester' AS `Last Name`,'Test Org' AS `Organization Name`, 'testorg@civicrm.org' AS email, 'http://www.civicrm.org/' AS Website;
and leave import options as default (Ind., skip, no saved field mapping).
(2) Import Step 2: accept the correct defaults offered for First/Last Name; for Org Name, Email & Website, choose "Employee of" and select Org Name, Email & Website fields from Organization. Tick Save field mapping, save as TestWeb.
(3) Proceed with import steps 3, 4.
(4) As (1) but choose saved mapping TestWeb.
(5) At Import Step 2, all fields are correct except Website, which shows "Employee of" - "- do not import -". I.e. mapping lost for this field.
civicrm_mapping_field shows the following:
| 9 | 3 | First Name | Individual | 0 | NULL | NULL | NULL | NULL | 1 | NULL | NULL |
| 10 | 3 | Last Name | Individual | 1 | NULL | NULL | NULL | NULL | 1 | NULL | NULL |
| 11 | 3 | Organization Name | Individual | 2 | NULL | NULL | 4 | a_b | 1 | NULL | NULL |
| 12 | 3 | Individual | 3 | 1 | NULL | 4 | a_b | 1 | NULL | NULL | |
| 13 | 3 | Home URL | Individual | 4 | NULL | NULL | 4 | a_b | 1 | NULL | NULL |
Is "Home URL" the problem? For an import with only Organization fields, civicrm_mapping_field name is "Website".
CIvi 2.2.8, Drupal 6.12, PHP 5.2.10, MySQL 5.0.45