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

Open Office calc ods files wrongly imported (Columns limited to 10 and NPE)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 4.2.0 GA (4.0.0 GA Suite Release)
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • Environment:
      java version "1.6.0_20"
      Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
      Java HotSpot(TM) Server VM (build 16.3-b01, mixed mode)
    • Story Points:
      5
    • PDI Sub-component:
    • 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:
      Pervach
    • Browser:
      Mozilla Firefox 3.6
    • Operating System/s:
      Ubuntu 10.04

      Description

      When trying to import data from an OO ods file, via excel input step, I experience two issues:

      1) a java NPE clicking on the Get fields from header rows. Anyway, after closing the pop-up, I found the fields in the grid, so apparently there isn't any error except for the error warning

      2) more important: it seems that the step can import only the values contained in the first 10 fields. It gets the header for the 11th and on as well, but does not import any data for these columns.

        Attachments

        1. dealers.ods
          22 kB
        2. ODS_test_version2_4.ods
          7 kB
        3. Schermata-6.png
          Schermata-6.png
          32 kB
        4. tr_input_ods.ktr
          29 kB

          Activity

            People

            Assignee:
            ihar_chekan Ihar Chekan (Inactive)
            Reporter:
            ato Andrea Torre
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: