US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Page 1 of 71 1 2 3 4

Search Forums: Search took 0.27 seconds.

  1. You seem to be giving us just a bread-crumb of...

    You seem to be giving us just a bread-crumb of the overall issue.

    You really truly cannot call substring on null.

    So what are you feeding into the function?
    If Numero_CTe.getString() returns...
  2. Replies
    1
    Views
    66

    The way you have this set up, you will be sending...

    The way you have this set up, you will be sending two different calls to the REST interface on the second REST Client step.
    I'm thinking that you want one call, but with two headers...

    You...
  3. Replies
    2
    Views
    84

    Two notes: 1) In Java (up to Java 7), the Sun...

    Two notes:
    1) In Java (up to Java 7), the Sun JDBC ODBC bridge was not recommended for production use
    2) In Jave 8, the Sun JDBC ODBC bridge was removed.

    Create a true connection to your DB...
  4. Replies
    6
    Views
    118

    I get dinged on that... AGAIN. I forget that...

    I get dinged on that... AGAIN. I forget that some of the steps only allow local files.
  5. Replies
    3
    Views
    74

    For a lot of the steps, the EE source and the CE...

    For a lot of the steps, the EE source and the CE source are the same: https://github.com/pentaho/pentaho-kettle
  6. If the JSON contents are all the same, you could...

    If the JSON contents are all the same, you could even do a Data Grid (with all the URLs) connected to the JSON Input.
  7. Step 1: Please READ the error messages you post. ...

    Step 1: Please READ the error messages you post. They often tell you exactly what is wrong.

    Step 2: Don't tell us one thing and then contradict yourself: $data.exclusions.title vs $..title
    ...
  8. http://lmgtfy.com/?q=LOOKUPCUBE+site%3Apentaho.com...

    http://lmgtfy.com/?q=LOOKUPCUBE+site%3Apentaho.com

    Results in:
    http://forums.pentaho.com/showthread.php?73008-LOOKUPCUBE-in-MDX&p=422183#post422183
  9. You did read up about variables before you...

    You did read up about variables before you started using them, right?

    Including the part where it says that you cannot set them and use them in the same transformation, right?
  10. Replies
    2
    Views
    153

    NOTE: If you are using Batch Update, even error...

    NOTE: If you are using Batch Update, even error handling won't work the way you want it to.
    You have to turn Batch Mode off in the Table Output for it to work particularly well.
  11. That's not what the source code says... At the...

    That's not what the source code says...

    At the end of the day, Decimal numbers are only an approximation - If you ask for 3.00001, you may get 3.0000100008 or you may get 3.000007 both of which...
  12. Replies
    6
    Views
    101

    This tells us that you only have 326027 rows in...

    This tells us that you only have 326027 rows in your table, not the 6.6M that you think you do.
  13. which we won't be able to tell you without the...

    which we won't be able to tell you without the log.

    I've been using PDI for about 6 years, and haven't run into this before. joao.ciocca had some odd things happen, but he was never really able...
  14. Insert/Update doesn't care if the rows are...

    Insert/Update doesn't care if the rows are unchanged, only if the key exists. (Key exists => Update; Key doesn't exist => Insert )
    If the row is unchanged, it will still send the update to the DB.
  15. Replies
    6
    Views
    118

    http://wiki.pentaho.com/display/EAI/.09+Transforma...

    http://wiki.pentaho.com/display/EAI/.09+Transformation+Steps#.09TransformationSteps-ApacheVirtualFileSystem%28VFS%29Support
  16. Replies
    6
    Views
    118

    Have you tried the...

    Have you tried the zip:file:/path/to/file.zip!file.csv VFS construct?
  17. Watch out for timezones. ...

    Watch out for timezones.

    http://www.timeanddate.com/time/change/brazil/brasilia?year=2015

    2015-10-18 00:00:00 didn't exist in Brasilia. Clocks went 2015-10-17 23:59:59 then 2015-10-18 01:00:00
  18. Yes, in fact you've pretty much named all the...

    Yes, in fact you've pretty much named all the steps that you need.

    Text File Input
    Switch/Case (Route rows based on content of one of the cells)
    Microsoft Excel Output (One per case)
  19. Replies
    3
    Views
    140

    The usual approach is to add a dummy row to you...

    The usual approach is to add a dummy row to you parameter query using a union statement in the parameter SQL.
    You can then check if the parameter matches you dummy row in your data (report) query...
  20. Your URL needs to be in the form:...

    Your URL needs to be in the form:
    testing/url=jdbc:oracle:thin:@chaucer.city.se:1521:chaucerdb

    Make sure that ocijdbc10.jar file is in %PENTAHO_INSTALLATION%/lib
  21. Open your Text File Input and turn off Lazy...

    Open your Text File Input and turn off Lazy Conversion.
  22. Perhaps something like this thread:...

    Perhaps something like this thread:
    http://forums.pentaho.com/showthread.php?199861-How-to-configure-multiple-database-connections-using-config-files
  23. Replies
    3
    Views
    104

    https://msdn.microsoft.com/en-us/library/ms189837....

    https://msdn.microsoft.com/en-us/library/ms189837.aspx



    So...
    With your SP, you are doing your inserts, and getting a message back saying "Done. X rows inserted", which contains no result...
  24. Replies
    4
    Views
    165

    Nope. The request was about reading text...

    Nope.

    The request was about reading text files, and skipping lines.
    Mick_data is correct - Text File Input.

    However, What the user seems to be asking about is skipping the rows before hitting...
  25. Replies
    12
    Views
    455

    What is puzzling and annoying? I made a mistake...

    What is puzzling and annoying?
    I made a mistake in my first response - putting jar files in /lib is the right place.
  26. Replies
    4
    Views
    257

    Installation of BIServer CE Pre-Configured...

    Installation of BIServer CE Pre-Configured Install:

    1) Download (and check checksum) BIserver Zip file
    2) Unzip file in a base directory
    3) Ensure JAVA is installed
    4) Ensure $JAVA_HOME is set...
  27. Did you follow the link in my prior post? It...

    Did you follow the link in my prior post?
    It tells you which step to use, and how to configure it.
  28. You mean like a Number Range...

    You mean like a Number Range?
  29. Replies
    12
    Views
    455

    Try putting any jar file that you want to use in...

    Try putting any jar file that you want to use in the %PENTAHO_INSTALL_DIR%/lib directory.
  30. Replies
    3
    Views
    215

    I'd do as Mathias.CH suggests, but I would use...

    I'd do as Mathias.CH suggests, but I would use Job and Transformation parameters...
  31. Depends on what you mean. In Jobs, there is a...

    Depends on what you mean.

    In Jobs, there is a Simple Evaluation step, which does If Then Else on chunks of work.
    In Transformations (data level work), there is the Filter Rows step, which does If...
  32. That way will be slower / less efficient... ...

    That way will be slower / less efficient...


    Depending on the PDI version, you can select "Concatenate strings with" as the option (rather than "Concatenate strings with ,") and in the value...
  33. My Approach: 1) Leave file as Microsoft XLSX 2)...

    My Approach:
    1) Leave file as Microsoft XLSX
    2) Using Microsoft Excel input with the Apache POI (Not the POI Streaming!) configuration, accept the columns as described. Set "Number" to have the...
  34. Perhaps you could leverage the "If Null..." step...

    Perhaps you could leverage the "If Null..." step to populate empty values that your DB would like.
  35. Personally, I just did my design work on a...

    Personally, I just did my design work on a Windows box, and then used Gentoo headless for the scheduled heavy lifting.
    Since I'm not trying to do anything graphical, it just worked.

    I've done the...
  36. Replies
    4
    Views
    187

    You're right, it is a strange answer. But your...

    You're right, it is a strange answer.

    But your question is also somewhat strange.
    You're stating up front that you're a beginner to the overall platform, and then asking for advice on a highly...
  37. And then there's also the option of using JNDI...

    And then there's also the option of using JNDI configurations...
    Which meets both pieces, but I don't think simple-jndi supports the "Encrypted" values.
  38. Replies
    4
    Views
    187

    I'm sure it is, as someone wrote a security...

    I'm sure it is, as someone wrote a security provider to connect to CAS.
    I'm not sure if anyone here has done it themselves, which would be why you're getting no response.

    If someone here has...
  39. Or even put the: PROD_DB_PASSWORD=Encrypted...

    Or even put the:
    PROD_DB_PASSWORD=Encrypted 2be98afc86aa7f2e4cb79bd75dd80aace

    into the kettle.properties file, and then you don't need to use "Set Variables"
    In the password field, you simply...
  40. Could you be trying to use an update statement in...

    Could you be trying to use an update statement in the same stream after an insert statement?
    If so, your insert might not have committed yet, and therefore in the update statement, the key does not...
  41. You could do two streams and use the append...

    You could do two streams and use the append streams near the end, just before the output:

    Questions:
    Q1 | Q2 | Q3
    What is the long question? | This Question is 128 characters long | Please write...
  42. Each of those functions have their own steps. ...

    Each of those functions have their own steps.


    Setting Variables is one step.
    Filtering Rows is a different step.


    There's DB Lookup step for that.
  43. I've seen this posted here before with a...

    I've seen this posted here before with a solution... But I can't remember the solution.
  44. That's a new one for me... Do you really need a...

    That's a new one for me...
    Do you really need a field name that long? 128 characters is almost a tweet... as a field name?
  45. You could use a Delete step, but that would run...

    You could use a Delete step, but that would run in parallel with the Table Output.
    You could use the Truncate Table option on the Table Output step, but that won't limit it to just the date ranges...
  46. Because Jobs and Transforms perform different...

    Because Jobs and Transforms perform different roles.

    You should be able to use the Job step, however, it requires that a "real" file exist, not something like http://cloudserver/path/filename.csv...
  47. Are you trying to use the JOB MySQL bulk Load...

    Are you trying to use the JOB MySQL bulk Load step, or the Transform MySQL Bulk load step?
    They behave slightly differently.

    NOTE: I'm not a MySQL user.
  48. I think you may be mis-understanding the Local...

    I think you may be mis-understanding the Local option. I haven't looked at the source-code, but in MySQL "Local" means that the data is on the client machine relative to MySQL (this means the PDI...
  49. Is this on Windows? MySQL Bulkloader doesn't...

    Is this on Windows?
    MySQL Bulkloader doesn't work fully on Windows due to OS limitations around named pipes.
  50. Replies
    12
    Views
    455

    The two paths that you posted are not in your...

    The two paths that you posted are not in your LIBPATH, so they won't be found.

    Try copying the JAR into %PENTAHO_DIRECTORY%\lib or %PENTAHO_DIRECTORY%\libswt\win64
Results 1 to 50 of 3526
Page 1 of 71 1 2 3 4