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

cbimport csv should handle fields in quotes

    XMLWordPrintable

Details

    Description

      Problem

      A number of tools will enclose fields in quotes in csv files.
      cbimport fails on these files with the following error:

      CSV import failed: line 1, column 1: bare " in non-quoted-field

      Steps to reproduce

      cbimport csv -c localhost -u test -p password -b test -d file://Downloads/invoices.csv -g %id%  -v

      Expectation

      cbimport to be able to import data where the fields in the CVS are enclosed in quotes.

      Attachments

        1. invoices.csv
          0.3 kB
          Patrick Varley

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-36755 cbimport csv fails with UTF-BOM files

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MB-27587 White paper uses the wrong command

          • Major - Major loss of function.
          • Open
          For Gerrit Dashboard: MB-27597
          # Subject Branch Project Status CR V
          100709,2 MB-27597 Handle CSV fields inside quotes master backup Status: MERGED +2 +1

          Activity

            People

              pvarley Patrick Varley (Inactive)
              pvarley Patrick Varley (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty