Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    786

    I discovered their SOAP Service goes down often...

    I discovered their SOAP Service goes down often on their test servers....thus the invalid session return.
    However, another issue has arisen: After a successful call,
    I cannot get the large RESPONSE...
  2. Replies
    6
    Views
    2,695

    PDI's integration with Excel is not so good. Even...

    PDI's integration with Excel is not so good. Even the Excel output transform is limited to the old XLS format and limited to 65,535 rows of data.
    You will need to create a plug-in to be able to...
  3. Just add a Javascript step and concatenate the 2...

    Just add a Javascript step and concatenate the 2 fields in question.
  4. Replies
    5
    Views
    969

    Which version of PDI ?

    Which version of PDI ?
  5. Replies
    1
    Views
    786

    SOAP 1.2 via Javascript and POST

    I am able to log into a web service using SOAP 1.2 by building the request via Javascript and using variable injection for the credentials.
    I am able to obtain what appears to be a valid session...
  6. Replies
    0
    Views
    375

    Kettle Job Log - Needs sorting

    From the admin console on port 9080 one can see the logs of recently executed jobs.

    However, they appear to be in random order, not by execution date/time.
    Is there a config option somewhere to...
  7. Replies
    1
    Views
    874

    Strange Error in PDI Job

    We have a job that runs hourly and it has many SQL Script steps that call stored procedures.

    Every once in a while (about every 3 days), the job fails with an "invalid object" which happens to be...
  8. Scheduler for reports - distribution lists

    We do not want to hard-code the email addresses of the recipients of reports as email attachments.

    How can we dynamically update the email addresses stored in the scheduler ?
  9. Never mind....issue resolved. The file is stored...

    Never mind....issue resolved. The file is stored in ZIP format but sent via email attachment as XLSX.
    Comment: the XLSX is already in zip format....they do not have to zip it to save storage space.
  10. Scheduled jobs for prpt files; email isssue; filetype issue

    Version 5.3
    When I schedule a report designer file to be created, I obtain the report but it is in ZIP file format, not XLSX as I had specified.
    In addition, I do not receive the email with...
  11. java not working in javascript transform

    var ft = new java.SimpleDateFormat ("H");
    Alert("Hour="+ft.format(DateOfFile));

    I am getting this error:
    - TypeError: [JavaPackage java.SimpleDateFormat] is not a function, it is object....
  12. Dashboard reports not refreshing when tied to a Mondrian Schema

    Anyone experience this ?
    Only after re-opening the dashboard and then refreshing the data cache (in our case, SQL Server) does the current data appear.
    We have an hourly report that must be...
  13. Report Designer - parameter in Message Field

    I have a report parameter with a default value. However, it does not render in the Report Header - it only appears by name ${Rptname}.
    Is this a bug or not supported in V 5.3 ?
  14. Thanks much EBS....that should work.

    Thanks much EBS....that should work.
  15. User Console: Login Timeout - Config option to change this ?

    We want our users to only have to login once per day.
    Is this possible thru a config file change ?
  16. Well we supposedly paid a consultant to set this...

    Well we supposedly paid a consultant to set this up and test all BI components. Great job he did.

    And well one can get ODBC to work but only with the ancient version 6.0 driver. Right now the...
  17. Report Designer - MS SQL Server Native connection failuer with JDBC

    Get this message : pentaho Error connecting to database: (using class com.microsoft.sqlserver.jdbc.SQLServerDriver) The connection string contains a badly formed name or value.

    ODBC works, but...
  18. Report Designer - data source question....

    Can the data source be a parameterized Stored Procedure ?
  19. Replies
    6
    Views
    853

    Thanks for that Johan !!

    Thanks for that Johan !!
  20. Replies
    6
    Views
    853

    Thanks, and you are right....it doesn't look like...

    Thanks, and you are right....it doesn't look like they publish any of the guides any longer....only these tutorials.
    I'm not a happy camper about that.....
  21. We are facing the same problem and intend to...

    We are facing the same problem and intend to tackle it with Report Designer's sub-report feature.
    Our other problem is customizing the Subject line of the email that notifies the end users.
  22. Replies
    2
    Views
    692

    But which transform can select multiple reports...

    But which transform can select multiple reports and send them via email ?
  23. Replies
    6
    Views
    853

    Thanks for responding. V 5.4 Shouldn't they be...

    Thanks for responding.
    V 5.4
    Shouldn't they be on the help site in the form of PDF downloads ?
  24. Replies
    6
    Views
    853

    Where are these docs ?

    Pentaho Analysis Guide, Penaho User Console Guide, Pentaho Report Designer User Guide

    I tried searching on the help.pentaho.com site to no avail.
  25. Replies
    2
    Views
    692

    Multiple Reports sent in a single email

    Is it possible with the report designer ?

    I don't think it's possible with data analysis reports which seem to each have their own scheduled task.

    Essentially I am looking to have multiple...
  26. Data Analysis Reporting/Scheduling - Email Subject line needs modification

    Currently, the scheduler generates the subject line from the report name.

    Is this definition stored as an XML file somewhere so that we could modify the subject line on-the-fly and enter a date or...
  27. Replies
    3
    Views
    765

    But we want our own Properties file for each PDI...

    But we want our own Properties file for each PDI application.
    We use a slick transformation that sets all of the variables.
  28. Replies
    3
    Views
    765

    Start-up Job feature

    We use variables for connections properties and other things.
    So technically we need to run a job upon every login.

    Is it possible to have a job run upon PDI start-up ?
  29. Gut - what about this idea: I'll create a LOG...

    Gut - what about this idea: I'll create a LOG table in SQL Server. In that manner I can then have a hop/step that displays the message records for the stored procedure that just ran.
    Yeah, that...
  30. I don't know Gut....it doesn't seem to offer very...

    I don't know Gut....it doesn't seem to offer very much.....and then there is this quirk:
    "The Call DB Procedure needs to be triggered. Use a Row generator step generating e.g. 1 empty row and link...
  31. Sorry Gut - PDI. The insert, read, update...

    Sorry Gut - PDI.

    The insert, read, update count feature only works of course if it's inline SQL.
  32. SQL Script adapter - Call Stored Procedure

    Does anyone know if an output parameter to a stored procedure called from an SQL Script adapter can be referenced with an environmental variable ?
    I'd like to get the rowcount to display it in the...
  33. Thanks Gut - I just love that qualifer "not fully...

    Thanks Gut - I just love that qualifer "not fully supported".

    However after I mapped the network share to a drive letter, upon Browse and selecting the file, it CONVERTED IT TO A UNC REFERENCE !!...
  34. CSV File Input bug ? Cannot find a file with UNC reference

    2015/08/17 11:57:16 - CSV file input:HourlyConvRpt.csv.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2015/08/17...
  35. Replies
    0
    Views
    574

    Property Input Adapter broken - V5.3

    I cloned a transform using the above. Then I changed the reference to a different properties file....
    and somehow Pentaho was still fetching the properties from the previous file !!

    The only...
  36. Replies
    9
    Views
    1,569

    http://sourceforge.net/p/jacob-project/discussion/...

    http://sourceforge.net/p/jacob-project/discussion/375946/thread/83e49c58/

    Found a cool set of Java classes that will open an XLAM or XLSM file and execute a macro.
    This could be the basis for a...
  37. Replies
    9
    Views
    1,569

    Ahhhhh....because I need to create the intricate...

    Ahhhhh....because I need to create the intricate formatted report in Excel.
    The report designer may be considered for this, but I need to show something fast.....and this was going to be an interim...
  38. Replies
    9
    Views
    1,569

    Exactly...once it is opened, it fetches data from...

    Exactly...once it is opened, it fetches data from a data warehouse.
    This would be a cool plug-in if it can be pulled-off, but I don't think there are any Java classes to do this, are there ?
  39. Replies
    9
    Views
    1,569

    Just discovered: the worksheets have got to be in...

    Just discovered: the worksheets have got to be in perfect table format.
    My sheets had missing headers for some columns, missing rows, etc.
    Also,there is no way to open an XLAM file is there ? I'd...
  40. Replies
    9
    Views
    1,569

    Excel Input Adapter - XLSX file format

    Has anyone been able to successfully read an XLSX file with version 5.3 or later ?
  41. Environmental Variables - where are they stored ?

    I crashed Spoon by creating an environmental variable to change the Java heapsize.
    It now opens and immediately closes without message or warning.
    When I open it useing SPOONDEBUG, my environmental...
  42. Need transform to access file modified date

    The Copy Files job adapter can only place the current timestamp into the file name.
    What I really want access to is the Modified Date property of the file....and to then append that to the file...
  43. Replies
    2
    Views
    577

    Thanks for that. I agree and I wonder why they...

    Thanks for that. I agree and I wonder why they didn't architect it as a GET AND PUT.

    I see that the Job adapter has an "Upload files to FTPS" feature, but no "Download files from FTPS".
    Also, I...
  44. Replies
    2
    Views
    577

    FTP Get Adapter ?

    Guys - in version 5.4 I see an SFTP Put transformation adapter, but what about the SFTP Get ?
    I need to pull files from a secure FTP location on an hourly basis.
    Do I need to create a custom...
  45. Replies
    0
    Views
    2,308

    Jira usage - a complaint

    I submitted a JIRA request as a bug report for the Sales Force adapter in PDI and it got closed out without comment.
    WTF ?
    Why is that ?
    http://jira.pentaho.com/browse/PDI-14184?filter=-2

    When...
  46. Replies
    4
    Views
    647

    Thanks for that Gut. I totally discovered a bug...

    Thanks for that Gut.
    I totally discovered a bug in 5.4 in the Sales Force Input - It does not support SOQL queries that contain joins....it gets all messed up.
    One must workaround with 2 inputs and...
  47. Replies
    2
    Views
    900

    Thanks Gut, that worked well. I see they have...

    Thanks Gut, that worked well.
    I see they have the JIRA User Guide in PDF format...hooray.
    Web-based help really sucks IMHO....you can't mark it up.
  48. Replies
    4
    Views
    647

    Thanks Gut, but no dice. I did get access to the...

    Thanks Gut, but no dice. I did get access to the Jira.
    Do they really follow-up on the issues posted there ?
  49. Replies
    2
    Views
    900

    Release 5.4 vs. 5.3

    Does anyone see a compelling reason to upgrade from 5.3 to 5.4 ?
    I only saw the captions of the changes, but I was wondering if there were some other goodies like bug fixes incorporated as well ?...
  50. Replies
    4
    Views
    647

    Access to the WIKI ?

    My forum credentials do not work for accessing the wiki which has some great technical info.
    There is no "Sign-up" link that I could see.
    How do we gain access ?
Results 1 to 50 of 50
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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