Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-15241

Invalid sample data in Zipssortedbycitystate.csv

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 6.1.0.1 GA
    • Fix Version/s: 7.1.0 GA
    • Component/s: Samples
    • Labels:
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)

      Description

      I was going through the video "Pentaho Evaluation Lesson 6 - Enriching Data" located at the following URL:
      http://www.pentaho.com/evaluation-path#data-integration

      This video uses some sample files provided by the PDI installation.

      The step that reads postal codes reads the attached csv file "Zipssortedbycitystate.csv". By doing this, I received an error (attached as "Log.txt"). One of the postal codes in the sample csv file is invalid due to quotation marks. The line is:

      BANNOCKBURN,IL,"60015"""

      You can replicate by running the attached transformation file. The sample files that the job reads are located in:
      ".\Pentaho\design-tools\data-integration\samples\transformations\files"

        PractiTest Integration




          Attachments

          1. InvalidPostalCode.png
            46 kB
            Michael Lazo
          2. Load Sales Data.ktr
            26 kB
            Michael Lazo
          3. Log.txt
            6 kB
            Michael Lazo
          4. tests_zip.ktr
            16 kB
            Alena Karneichyk
          5. Zipssortedbycitystate.csv
            385 kB
            Michael Lazo

            Activity

              People

              Assignee:
              AKarneichyk Alena Karneichyk (Inactive)
              Reporter:
              mlazo Michael Lazo
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: