Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 6 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    4
    Views
    1,775

    Hi Krishna There are sufficient information,...

    Hi Krishna

    There are sufficient information, of you take the time to search. for example
    here : http://forums.pentaho.com/showthread.php?51754-Pentaho-Web-Services-support
    here :...
  2. Replies
    1
    Views
    5,141

    The 'replace variable' option does not apply to...

    The 'replace variable' option does not apply to table elements (table name, column name, etc).

    There has been a few discussion in the forums, including this one :...
  3. Replies
    1
    Views
    2,404

    You can't this in PDI without preparing the data....

    You can't this in PDI without preparing the data.

    Look at the PDF2TXT utility on unix based systems, or look at converting from pdf using something like alfresco.

    I can warn you from my own...
  4. Replies
    2
    Views
    1,609

    Parveen CDF/CDE comes shipped with JQuery. No...

    Parveen CDF/CDE comes shipped with JQuery. No need to add it again. Just use it.
  5. Just take note that I got different results using...

    Just take note that I got different results using the two methods :

    I accept it might be my version of mysql, but it's a warning just the same.


    SELECT ...... `TABLE_ROWS` > 0;...
  6. Replies
    1
    Views
    930

    Do this : 1. try another browser - Firefox is...

    Do this :
    1. try another browser - Firefox is tried and tested, for example.
    2. Ask Microsoft about the browser crash.
  7. Look here :...

    Look here : http://craftersloft.blogspot.com/2010/01/redirecting-to-dashboard-upon-login-in.html
  8. Replies
    4
    Views
    1,402

    The easiest might be to start using the CDF. If...

    The easiest might be to start using the CDF. If you are not, then you will have to look into changing the PUC code or writing a plugin (overkill for your requirement, maybe).

    The PUC documentation...
  9. Replies
    4
    Views
    1,402

    Look at the CDF examples. This is used to print...

    Look at the CDF examples. This is used to print the CDF documentation.
  10. Sean You should be able to specify the format...

    Sean

    You should be able to specify the format of the date against the input field in the text file read step.

    Alternatively, if you place a SELECT transformation step somewhere between your...
  11. Replies
    2
    Views
    1,837

    On the ftp properties dialogue, click the 'add...

    On the ftp properties dialogue, click the 'add filename to result' then get rows from result in a child transformation.
  12. Replies
    5
    Views
    2,152

    I'm guessing here, but extend your splitting...

    I'm guessing here, but extend your splitting solution from this:
    ${part1}$[3F]${part2}
    to this
    ${part1}?{part2}
  13. Replies
    5
    Views
    4,463

    On you db connection, try setting the initial...

    On you db connection, try setting the initial database command to 'set names utf8'
  14. Replies
    3
    Views
    3,314

    See the same report the formula for the...

    See the same report the formula for the background colour.
  15. You have to use the no data band. Why do you not...

    You have to use the no data band. Why do you not want to use it - I'd be interested to find out. That's what it is there for.
  16. Madhu I'v implemented such a system. It was...

    Madhu

    I'v implemented such a system. It was discussed and described in this post : http://forums.pentaho.com/showthread.php?84834-scheduling-and-sending-reports
  17. Replies
    1
    Views
    879

    This is your best source of information to allow...

    This is your best source of information to allow you to proceed.
    http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+Steps
  18. Replies
    5
    Views
    2,152

    Does this help ? ...

    Does this help ?
    http://www.w3schools.com/tags/ref_urlencode.asp
  19. Replies
    1
    Views
    4,038

    dulci You do not need to...

    dulci

    You do not need to /pentaho-demo/pentaho-solutions/system/smtp-email/email_config.xml to run the mail step in PDI.

    Instead, you provide the SMTP details in the step properties dialogue in...
  20. Replies
    5
    Views
    1,312

    Rajesh Look at this link -...

    Rajesh

    Look at this link - http://forums.pentaho.com/showthread.php?50008-xaction-for-generating-reports-and-save-them-as-pdf

    It's quite an old post and the attached xaction may not work in the...
  21. Replies
    6
    Views
    4,435

    What does the logs say?

    What does the logs say?
  22. Replies
    4
    Views
    4,824

    Yes uwegeercken, There are a few parts to this...

    Yes uwegeercken,

    There are a few parts to this solution:

    Trigger polling
    A scheduled (every 5 mins) kettle job looks in a queue directory for incoming files abcd.trigger. it does a lookup for...
  23. Replies
    4
    Views
    4,824

    Interesting take. We developed a report engine...

    Interesting take.

    We developed a report engine that queues up jobs depending on different triggers (for example, end of day settlement, data archive complete, etc). We configure and queue reports...
  24. Replies
    11
    Views
    2,779

    Ivan Please don't take my response as being...

    Ivan

    Please don't take my response as being rude, but it is advisable to search the forums for keywords before posting.

    There was a forum post just a few days ago to address this issue. ...
  25. I'd be very worried that you can supply a SQL...

    I'd be very worried that you can supply a SQL query on the URL. That is a very dangerous feature. Nonetheless, if access is restricted to internal users, some risk is managed.

    You should be using...
  26. Replies
    2
    Views
    1,246

    DELETE FROM users WHERE id NOT IN (SELECT MIN(id)...

    DELETE FROM users WHERE id NOT IN (SELECT MIN(id) FROM MyTable GROUP BY email);
  27. Replies
    4
    Views
    2,071

    In javascript step

    In javascript step
  28. Replies
    3
    Views
    2,889

    Try this with SQL, if the data is coming from a...

    Try this with SQL, if the data is coming from a database.
  29. You will have to supply more info about the...

    You will have to supply more info about the memory error, for example is it out of heap errors, or errors related to garbage collection, and so on.

    Each type of error required different diagnostic...
  30. You could be facing other problems like...

    You could be facing other problems like pernissions and path issues.

    Try starting the server using the startup scripts, eg.
    For extra information, try
  31. Replies
    19
    Views
    18,587

    Sticky: To add to hansva's explaination, Saiku allows you...

    To add to hansva's explaination, Saiku allows you to provide OLAP analysis of data cubes. It used to be called PAT, and is a replacement for the JPivot tool that is shipped with the CE version of the...
  32. Replies
    6
    Views
    1,903

    As far as I know, the report plugin is only...

    As far as I know, the report plugin is only available for Kettle 4.1 and upwards.

    In addition, 4.1 was not not provided with the Report plugin, and had to be manually installed, but 4.2 comes...
  33. Replies
    1
    Views
    861

    Use the Number Range step.

    Use the Number Range step.
  34. Not sure, but just something to check up on -...

    Not sure, but just something to check up on - the first parameter requires a format YYYY-MM-DD, and you are supplying yyyy-MM-dd.
  35. Replies
    3
    Views
    2,246

    I would vote against this. PDI can only do so...

    I would vote against this. PDI can only do so much, and having a zero byte zip file is the result of some other error, and should not be managed by PDI, in the same way that a corrupt zip file will...
  36. Replies
    6
    Views
    1,903

    Arunmadhaven if you follow the example in the...

    Arunmadhaven

    if you follow the example in the link, you will realise that it replaces xaction, so you therefore do not really need an xaction.

    Also, the PRPR format was changed from the OLD xml...
  37. Replies
    1
    Views
    2,206

    If you are using MySQL then use...

    If you are using MySQL then use SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS() so that you rub your query once.

    Otherwise you'll probably use both a job and transformation - Use the SQL Evaluate Rows...
  38. Replies
    4
    Views
    1,821

    Strange then where it gets the string from. ...

    Strange then where it gets the string from.

    Create another step, and text file output with 2 string fields (FundName and Date), and attach that to the error handling step of the table output...
  39. Thread: shared.xml

    by crafter
    Replies
    2
    Views
    4,888

    I can't speak about the error, but I can say that...

    I can't speak about the error, but I can say that I use a properties file for achieving connections to different databases, and setting various filepaths and other options.

    I found the following...
  40. Replies
    2
    Views
    1,180

    Perhaps you need to rethink your plugin. PDI...

    Perhaps you need to rethink your plugin.

    PDI will process each row in single thread. It does not process rows one-by-one. Therefore, if the step before your plugin returns more than one row, your...
  41. Replies
    7
    Views
    1,038

    "snow" is not equal to "snow ". However,...

    "snow" is not equal to "snow ". However, depending on where you are getting the string from, you can apply trim to the string, or use a calculation or javascript to trim the space manually.
  42. Replies
    4
    Views
    1,821

    Either your data, or your data mapping is not...

    Either your data, or your data mapping is not correct.

    It appears you have a value 'CONCOR' in the Date field, which is obviously not a correct date. Java therefore complains in trying to convert...
  43. Replies
    1
    Views
    1,245

    That, and more, here :...

    That, and more, here :
    http://diethardsteiner.blogspot.com/2011/02/pentaho-data-integration-designing.html
  44. Maris is correct. However, if you are placing the...

    Maris is correct. However, if you are placing the filename in a variable you cannot do this in a single transformation, you will have to convert this to a job <-> transformation scheme.


    myjob...
  45. Bump: I've made no progress in understanding how...

    Bump: I've made no progress in understanding how to pass parameters to the reporting step using a file. Anyone done this?
  46. Thread: Filter Row

    by crafter
    Replies
    4
    Views
    1,196

    It will When you create the select statement ,...

    It will

    When you create the select statement , this creates a transformation field number_of_entries. This field gets passed to each step until the end of the transformation.

    To verify, right...
  47. Thread: Filter Row

    by crafter
    Replies
    4
    Views
    1,196

    Are you doing : "SELECT count(*) AS...

    Are you doing :
    "SELECT count(*) AS number_of_entries ..." ?
  48. Passing generic parameter list to Reporting Step from PDI

    Hi

    I have a job that runs one of various reports based on some preprocessing. In other words, the actual report template (.prpt) name is only calculated at run time. Because of this, an individual...
  49. Replies
    5
    Views
    26,438

    ...and therein lies your problem. Your issue...

    ...and therein lies your problem.

    Your issue is with the code itself, not with PDI.

    Therefore you have more chances of a suitable response in a Java related forum.
  50. " p { margin-bottom: 0.21cm; }Unexpected...

    " p { margin-bottom: 0.21cm; }Unexpected error during transformation metadata load "

    Looks like you have problems connecting to the PDI repository.
    Is your scheduled job and manual job...
Results 1 to 50 of 260
Page 1 of 6 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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