Skip to main content
CiviCRM

Return to Question

Bumped by Community user
replaced http://civicrm.stackexchange.com/ with https://civicrm.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

I'm trying to do a bulk tidy-up of Address fields in CiviCRM 4.7 by exporting the data, manipulating it in a spreadsheet and re-importing it. This involves moving some values around between postal address fields, requiring some to be blanked. The Import option for Duplicate Matching can only be 'Update'. However, if I include a null value for any field it does not overwrite (blank out) an existing value, resulting in duplication. Only non-null values are considered to be updates.

Example: trying to move "121b Baker Street" from 'Supplementary Address 1' to 'Street Address' using Import/Update results in both these fields containing "121b Baker Street".

My problem is a more general case of the question at http://civicrm.stackexchange.com/questions/17101/uploading-null-email-address?s=2|0.2152https://civicrm.stackexchange.com/questions/17101/uploading-null-email-address?s=2|0.2152 which refers only to blanking of email addresses.

Unless I'm missing something, I'd like to propose another option for Duplicate Matching (alongside the current Skip / Update / Fill / No duplicate checking) called 'Edit'. It would allow the removal of existing values by overwriting with a null string but would otherwise behave in the same way as Update.

I'm trying to do a bulk tidy-up of Address fields in CiviCRM 4.7 by exporting the data, manipulating it in a spreadsheet and re-importing it. This involves moving some values around between postal address fields, requiring some to be blanked. The Import option for Duplicate Matching can only be 'Update'. However, if I include a null value for any field it does not overwrite (blank out) an existing value, resulting in duplication. Only non-null values are considered to be updates.

Example: trying to move "121b Baker Street" from 'Supplementary Address 1' to 'Street Address' using Import/Update results in both these fields containing "121b Baker Street".

My problem is a more general case of the question at http://civicrm.stackexchange.com/questions/17101/uploading-null-email-address?s=2|0.2152 which refers only to blanking of email addresses.

Unless I'm missing something, I'd like to propose another option for Duplicate Matching (alongside the current Skip / Update / Fill / No duplicate checking) called 'Edit'. It would allow the removal of existing values by overwriting with a null string but would otherwise behave in the same way as Update.

I'm trying to do a bulk tidy-up of Address fields in CiviCRM 4.7 by exporting the data, manipulating it in a spreadsheet and re-importing it. This involves moving some values around between postal address fields, requiring some to be blanked. The Import option for Duplicate Matching can only be 'Update'. However, if I include a null value for any field it does not overwrite (blank out) an existing value, resulting in duplication. Only non-null values are considered to be updates.

Example: trying to move "121b Baker Street" from 'Supplementary Address 1' to 'Street Address' using Import/Update results in both these fields containing "121b Baker Street".

My problem is a more general case of the question at https://civicrm.stackexchange.com/questions/17101/uploading-null-email-address?s=2|0.2152 which refers only to blanking of email addresses.

Unless I'm missing something, I'd like to propose another option for Duplicate Matching (alongside the current Skip / Update / Fill / No duplicate checking) called 'Edit'. It would allow the removal of existing values by overwriting with a null string but would otherwise behave in the same way as Update.

Bumped by Community user
Source Link
David Hepper
David Hepper
  • 149
  • 7

Is there an Import option to allow overwriting fields with null (empty)?

I'm trying to do a bulk tidy-up of Address fields in CiviCRM 4.7 by exporting the data, manipulating it in a spreadsheet and re-importing it. This involves moving some values around between postal address fields, requiring some to be blanked. The Import option for Duplicate Matching can only be 'Update'. However, if I include a null value for any field it does not overwrite (blank out) an existing value, resulting in duplication. Only non-null values are considered to be updates.

Example: trying to move "121b Baker Street" from 'Supplementary Address 1' to 'Street Address' using Import/Update results in both these fields containing "121b Baker Street".

My problem is a more general case of the question at http://civicrm.stackexchange.com/questions/17101/uploading-null-email-address?s=2|0.2152 which refers only to blanking of email addresses.

Unless I'm missing something, I'd like to propose another option for Duplicate Matching (alongside the current Skip / Update / Fill / No duplicate checking) called 'Edit'. It would allow the removal of existing values by overwriting with a null string but would otherwise behave in the same way as Update.