Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Something broken on Excel input

  1. #1
    Join Date
    Feb 2011
    Posts
    840

    Default Something broken on Excel input

    By suggestion of Slawo I'm opening this new thread. Seems I've got a problem with the Excel Input step. I'm gonna duplicate what I've said in the other thread:

    Quote Originally Posted by joao.ciocca View Post
    Also... seems like Excel Input won't read formula values correctly. When it tries to read the cel B4 (which contains formula =B5-B6), I'm getting this error:
    Code:
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Error processing row from Excel file [F:\CAPITAL\DLO\2011\2015-06\DLO 2015-06.xls] : org.pentaho.di.trans.steps.excelinput.KettleCellValueException: Cannot convert field "VR_CONTA" from cell on sheet 1, row 3, column 2: 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected conversion error while converting value [v String] to a Number
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : v String : couldn't convert String to number 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unparseable number: "VALOR"
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected conversion error while converting value [v String] to a Number
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : v String : couldn't convert String to number 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unparseable number: "VALOR"
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.KettleCellValueException: Cannot convert field "VR_CONTA" from cell on sheet 1, row 3, column 2: 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected conversion error while converting value [v String] to a Number
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : v String : couldn't convert String to number 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unparseable number: "VALOR"
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected conversion error while converting value [v String] to a Number
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : v String : couldn't convert String to number 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unparseable number: "VALOR"
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.fillRow(ExcelInput.java:231)
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:644)
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:450)
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/03/17 15:25:31 - Compatibilização PR/PRE.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.lang.Thread.run(Unknown Source)
    Which is just weird, since I told Excel input to start at row 3 - and "VALOR" is in row 2, not row 3 (or am I understanding wrong? from what I get, Kettle's row 0 = Excel's row 1 and so on...)

    I'm attaching the transformation with the problem.

    Also, after I try to run the transformation for the first time, I am able to use the Preview button on the Input step that's giving that error, and it shows an error on the log, but shows up the preview correctly, with the same data that's on the spreadsheet - starting from row 3, and not row 2...
    Code:
    2011/03/17 15:25:32 - 2041_Atualiza_Outras - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Erros detectados!
    2011/03/17 15:25:32 - 2041_Atualiza_Outras - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Erros detectados!
    "Erros detectados!" = "Detected errors!" in portuguese...
    I've attached both the XLS template used and the transformation that reads it.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.