Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Excel Writer - template bugs?

  1. #1
    Join Date
    Feb 2011
    Posts
    840

    Default Excel Writer - template bugs?

    So, am I doing something from (like, am I not supposed to use the same name for template and target sheets), or is this a bug?

    First, I thought the problem was with upper-case named sheets, since I was going with "BASE". Then, I changed template sheet name to "model", but forgot to change target. When I did, same error:
    Code:
    : Error opening new file
    : org.pentaho.di.core.exception.KettleException: 
    : Tempate Sheet: modelo not found, aborting
    : 
    : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.prepareNextOutputFile(ExcelWriterStep.java:697)
    : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.init(ExcelWriterStep.java:871)
    : 	at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62)
    : 	at java.lang.Thread.run(Unknown Source)
    : Couldn't prepare output file ${Internal.Transformation.Filename.Directory}\Report ${year}-${month}
    : Unexpected error
    : java.lang.NullPointerException
    : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:211)
    : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:172)
    : 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    : 	at java.lang.Thread.run(Unknown Source)
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  2. #2
    Join Date
    Dec 2013
    Posts
    2

    Default

    Hi,

    Same here, I couldn't find any other place it was discussed. Hasn't anyone else got the same issue?
    I'm using 4.4.0 and writing an xslx file with template. I tried renaming the sheet in a very simple way but still...

    Code:
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error opening new file
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleException: 
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Tempate Sheet: Direct Response not found, aborting
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.prepareNextOutputFile(ExcelWriterStep.java:697)
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.init(ExcelWriterStep.java:871)
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62)
    2013/12/19 13:07:52 - Microsoft Excel Writer.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.lang.Thread.run(Unknown Source)
    Thanks

  3. #3
    Join Date
    Feb 2011
    Posts
    840

    Default

    geez, I know I worked this around somehow, but I really don't remember where/how...
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  4. #4
    Join Date
    Apr 2007
    Posts
    2,010

    Default

    Errm, does http://jira.pentaho.com/browse/PDI-2565 help? This is being fixed and/or about to be comitted shortly... May be worth trying a CI build once this issue is fixed!

  5. #5
    Join Date
    Feb 2011
    Posts
    840

    Default

    Excel Output and Excel Writer are different steps...
    BTW, I really thought Excel Output step would be discontinued, ever since Slawo's Excel Writer step came in PDI... really surprised to see it's still there.
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  6. #6
    Join Date
    Dec 2013
    Posts
    2

    Default

    Hi,

    I found the work around : the "Stream XLSX data" option has to be ticked. Otherwise it fails...

    Now I'm having a lot more problems with the formatting of my output file, that doesn't respect the template (and I think I tried all the options). But this is another story.

    Thanks anyway!

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.