Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-41328

cbimport: support automatically collapsing of duplicate csv columns into a JSON array

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • backlog
    • Cheshire-Cat
    • tools
    • None
    • 1

    Description

      Ran into an issue importing Jira CSV into Couchbase. There are some fields in Jira that can take an arbitrary list of values (component, labels, versions, etc) and if you export a CSV from a list of issues it ends up taking these fields and creating duplicate column names. This then causes an issue when importing from CSV -> CB because JSON can only have unique keys for field names.

      A nice enhancement to cbimport would be the option (by default?) to automatically collapse duplicate column names into a JSON array.

      Short sample csv attached. You'll see 4 columns with "Affects Version/s" but only one value with that key gets imported into CB. The desire would be to have an "Affects Version/s" key whose value is an array of up to 4 columns (the non-empties).

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            pvarley Patrick Varley (Inactive)
            perry Perry Krug
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty