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"

        Attachments

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

          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: