Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-17493

Issue with importing to checkbox type fields where label is the same as database value (may affect other types too)

    Details

    • Type: Bug
    • Status: Reopened
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.6.10, 4.7.13
    • Fix Version/s: 4.6.11
    • Component/s: None
    • Labels:
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      Hi Dave,

      Can you size up a fix for an issue with imports into checkboxes (but may affect other field widgets also).

      If you create a new custom field and in this case add it to activity. Make the field a checkbox and give it some options.

      Make the option label + the same+ as the option value. important!

      If you then attempt to import to the field through the importer, after import you will get error for all fields "'1' is not a valid option for field custom_XX"

      I set this up on the demo site http://d46.demo.civicrm.org/ - using new field called "Nature of enquiry / feedback".

      Please see example import attached and import errors doc.

      If you can size this up asap and then I can get the fix approved to be paid.

      Let me know if you need any more info.

      Many thanks

      nb - Dave if you want to include in costs adding tests to this stuff then please give both estimates. thanks

        Attachments

        1. Import_Errors (8).csv
          0.4 kB
          Jamie Novick
        2. Workbook1.csv
          0.2 kB
          Jamie Novick

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jamienovickcompucorp_uk Jamie Novick
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated: