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

Bug In Excel Input wrong values ​​of an hour column

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Not a Bug
    • Affects Version/s: 9.0.0 GA
    • Fix Version/s: None
    • Component/s: Step
    • Labels:
      None
    • Environment:
      Pentaho Data Integration 9.0
    • 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.
    • Browser:
      Google Chrome 10.x
    • Operating System/s:
      Windows 10
    • Steps to Reproduce:
      Hide

      1. I added a Microsoft Excel Input

      2. I'm reading a column in the format of hours hh: mm: ss

      3. Run Transformation

      Show
      1. I added a Microsoft Excel Input 2. I'm reading a column in the format of hours hh: mm: ss 3. Run Transformation

      Description

      Using the step Excel input, when trying to read a column of hours, the keetle returns values ​​different from the correct ones, I realized that the error happens when reading times between 21 to 23 hours ... the same brings these values ​​with a difference of 6:28 minutes ...

        Attachments

        1. print.JPG
          print.JPG
          78 kB
        2. print2.JPG
          print2.JPG
          42 kB
        3. teste_horas_2.xlsx
          17 kB
        4. teste_horas_novo.ktr
          155 kB

          Activity

            People

            Assignee:
            bowens Brittany Owens
            Reporter:
            MC85 Michel Platini de Almeida César
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: