Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: JoBrad; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. You can use a template when writing the Excel...

    You can use a template when writing the Excel file, which means you could define the conditional formatting in that template, and PDI would only be writing the data.
  2. Thread: Move Files

    by JoBrad
    Replies
    3
    Views
    1,421

    Look for SFTP and FTPS steps under the "File...

    Look for SFTP and FTPS steps under the "File Transfer" section of the Job design tree.
  3. They were listed in another category. I don't...

    They were listed in another category. I don't have any details as to why, etc.

    http://www.pentaho.com/blog/2016/03/24/gartner-bi-summit-2016-recap-forecasting-future-data-everywhere
  4. Replies
    11
    Views
    1,841

    Dubbu, I recently had to handle a similar...

    Dubbu,
    I recently had to handle a similar situation, and was a little frustrated, frankly, that Spoon deals with XML far better than it does JSON. I've attached a transformation that will turn a...
  5. Replies
    11
    Views
    1,841

    There are a few apparent problems here: * It...

    There are a few apparent problems here:
    * It seems like you've literally copy/pasted the example code. But while that code fits your general use-case, it wasn't made for your transformation, so that...
  6. After a night to think through it, I will...

    After a night to think through it, I will actually re-write this so that I get all of the data I need up front, and use some sort of column to flag what data needs to go on sheet 1 versus sheet 2....
  7. That would be awesome, if it were! The bug that I...

    That would be awesome, if it were! The bug that I experienced is that, if your input has no data, the Excel Writer doesn't keep/access the Row Metadata properly, so it fails with an NPE.

    I will...
  8. Replies
    11
    Views
    1,841

    Can you paste your MJSV code?

    Can you paste your MJSV code?
  9. Replies
    11
    Views
    1,841

    The forum resizes images, so it's really hard to...

    The forum resizes images, so it's really hard to read much, but it looks like you might have a JSON reader after your MJSV? You don't need that, if you do, because your MJSV already converted it to...
  10. Thanks for the reply, Mick I tried several...

    Thanks for the reply, Mick
    I tried several options, but when I upload the image, it is being resized from 1212x274 -> 600x136. I don't know of a way to address this - ideas?

    In any case, I do...
  11. HI yyuanju, I used a Javascript step, with this...

    HI yyuanju,
    I used a Javascript step, with this code, to get the path. Maybe it will help you.



    parent_job.addParameterDefinition("itemName", parent_job.getRepositoryDirectory() + "/" +...
  12. Replies
    1
    Views
    441

    Can you provide any more detail? Where is this...

    Can you provide any more detail? Where is this value being set - in the Parameters tab of a job or transformation, or somewhere else? What are you doing with it when you encounter the error?
  13. Workaround for Excel Writer NPE when no rows exist

    Hi everyone,
    I have a question about a known bug for which I really need some form of a workaround.
    I have a transformation that gets data from two tables and writes it to a single spreadsheet....
  14. It sounds like you have a text file output step...

    It sounds like you have a text file output step on some error path which currently outputs error information to a file. So, you've already captured the error condition and the details, which is the...
  15. You could also place a try/catch block in your...

    You could also place a try/catch block in your code to catch an exception, and provide an alternate value. Something like this:



    var cte;
    cte = gera_cte (CTRC.getString(),...
  16. Replies
    0
    Views
    1,859

    Problems browsing JIRA

    This isn't about the Pentaho product, really, but about the Pentaho JIRA. If there's someone else I should contact, I couldn't find that information on JIRA, so I hope this is a good place.

    When...
  17. I created a series of transformations that parsed...

    I created a series of transformations that parsed jobs and transformations to find dependencies between them, as well as any used connections. You could do something similar to find all steps that...
  18. Replies
    1
    Views
    897

    I think you have a few issues that are keeping...

    I think you have a few issues that are keeping the steps in this transformation from running at all.

    First, I didn't see any columns defined in the Get rows from result step. You need to define...
  19. Replies
    2
    Views
    1,124

    Are you running the query in a job or...

    Are you running the query in a job or transformation? If you're using a Table Input step in a transformation, you can't include semicolons at the end of the statement. Maybe if you could provide more...
  20. Replies
    4
    Views
    2,066

    You have to also define the error handling for...

    You have to also define the error handling for the step. Right click the table output step and click Error Handling.... There you can define new fields that contain the information you want, and...
  21. Gerardo's comment on...

    Gerardo's comment on http://jira.pentaho.com/browse/PDI-14629 removed the error from my log, and created a blank file But even though I adjusted the priority values to INFO for a few of the...
  22. Replies
    4
    Views
    3,012

    I know this thread is pretty old now, but I was...

    I know this thread is pretty old now, but I was able to get this working, and wanted to share how I did it. After some trial and error configuring log4j settings, I found this folder:...
  23. Replies
    4
    Views
    3,012

    Hi Mick, I know about that step. I'm asking for...

    Hi Mick,
    I know about that step. I'm asking for the location of the Spoon *application* logs. This would be sort of like the tomcat logs, for the server (but I'm asking about the client logs,...
  24. Replies
    4
    Views
    3,012

    Pentaho Logging and Opening Files

    Hi everyone,
    I'm running PDI 5.2 and 6.0, and cannot seem to locate any log files. In versions before 5.2, the log files would be located in the %TEMP% folder, with a name starting with spoon and...
Results 1 to 24 of 24
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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