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

Search Forums:

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

Page 1 of 79 1 2 3 4

Search Forums: Search took 0.23 seconds.

  1. Replies
    2
    Views
    61

    I really wish they would package a 32-bit...

    I really wish they would package a 32-bit script...

    edit your spoon.bat
    Change the line that tells it to use "-Xmx2048m" to "-Xmx1024m" and it should start.
  2. Replies
    3
    Views
    87

    Did you go through all the steps to get your...

    Did you go through all the steps to get your certificate recognized by PDI?

    the "--insecure" in your curl call basically tells the program to trust the certificate even though it can't validate...
  3. Run all your comparison fields through a "trim"...

    Run all your comparison fields through a "trim" first.

    Remember that "Gastronomia e Bares" is different from "Gastronomia e Bares " and with the "Insert" function, that would add a new row.
  4. Replies
    14
    Views
    232

    No actually you don't. If you go to the Edit...

    No actually you don't.
    If you go to the Edit menu, and select "Set Environment Variables" it will be set, and available for use in the transformation that you are working on.
    Similarly,...
  5. A SQLLite .db file is a full DB. It can contain...

    A SQLLite .db file is a full DB. It can contain one or more tables. When you create a table, or add data to a table in a SQLLite DB, it will write to the .DB file.
  6. If you put your CREATE TABLE foo {columnname...

    If you put your
    CREATE TABLE foo {columnname text, othercolumn integer}
    into the "SQL" step in a job, then the table will exist for you to put the data into during your transform.

    Is that...
  7. SQL Script is not an input step, so it doesn't...

    SQL Script is not an input step, so it doesn't fully fire as soon as it could.
    You can fix this by generating rows (only generate one) and connecting it to the "Execute SQL Script"
    However, since...
  8. Based on your question, I'm going to assume that...

    Based on your question, I'm going to assume that you are a programmer.
    STOP.

    Go learn how Pentaho works, since it works significantly differently than most programming languages.
    A good place to...
  9. Which way do you mean "I can't find driver"?...

    Which way do you mean "I can't find driver"?
    More in the "I cannot locate a place to download the driver from the internet" or "I have downloaded the driver, but PDI is saying that it can't use it"
  10. In the transform side, there's execute row level...

    In the transform side, there's execute row level SQL
    In the job side, there's Execute SQL Statement

    Lots of options...
  11. Replies
    3
    Views
    124

    When in doubt, listen to marabu :)

    When in doubt, listen to marabu :)
  12. Replies
    28
    Views
    606

    Make sure that any images you post are readable....

    Make sure that any images you post are readable.
    For something like an error message, you are better to copy the text and paste it.

    My bet, looking at the image, is that you had rows that arrived...
  13. Replies
    3
    Views
    124

    Why not create a Variable (or two)? ${TODAY} =...

    Why not create a Variable (or two)?

    ${TODAY} = "2016/07/19/"
    Move files: From: file:///c:/Data/${TODAY} TO: file:///D:/Data/${TODAY}
    ${YESTERDAY} = "2016/07/18/"
    Move files: From:...
  14. Replies
    4
    Views
    122

    Well, you're not actually telling us anything, so...

    Well, you're not actually telling us anything, so no one can tell you the right way.

    Important info:
    Where is the data coming from?
    What exactly does the data look like?
    What should the output...
  15. Replies
    4
    Views
    122

    So... What's your question?

    So... What's your question?
  16. Replies
    28
    Views
    606

    Abort is a special step. When it receives a row,...

    Abort is a special step. When it receives a row, it will abort the overall transformation.
    Steps will process rows as soon as they can, once they receive them.
  17. Replies
    28
    Views
    606

    Please, don't do this. It invites SQL Injection....

    Please, don't do this.
    It invites SQL Injection.

    If you can, use the Get Variables Step.
  18. Replies
    2
    Views
    75

    Depends on the DB setup, but 'All Product...

    Depends on the DB setup, but 'All Product Category' <> 'All product category'
  19. You can execute SQL statements (like Create...

    You can execute SQL statements (like Create table) from within PDI, pointed at your SQLLite DB file...
  20. If you go into the DB Configuration screen,...

    If you go into the DB Configuration screen, select the type sqllite

    Give it a name for the DB Connection
    Enter the path to your .db file in the "Database name" field.
    Click "Explore DB"
    ...
  21. Replies
    3
    Views
    177

    Use the calculator to get "Month of Date" Use...

    Use the calculator to get "Month of Date"
    Use filter rows to only allow "Month of Date" = 5 and "Month of Date" = 6 to pass.
  22. Replies
    3
    Views
    177

    Are you sure this is a reporting question, or is...

    Are you sure this is a reporting question, or is this a PDI / Spoon question?
  23. Replies
    8
    Views
    267

    Additional comments: 1) MAKE SURE YOUR SAMPLES...

    Additional comments:
    1) MAKE SURE YOUR SAMPLES CAN BE RUN. Replace the Table Input with a datagrid with what the table input would have given you. This will allow other people on the forum to help...
  24. Replies
    8
    Views
    267

    Once again, since you two are in the same place,...

    Once again, since you two are in the same place, why don't you talk to each other in person, and collaborate with each other, rather than on the forum?
  25. I don't usually do this... I've been using the...

    I don't usually do this...

    I've been using the Read Values from Step for a long time, to validate values on different tabs match with each other, writing out to the same Excel File. It really...
  26. Since Interactive Reporting is an EE feature, and...

    Since Interactive Reporting is an EE feature, and EE comes with a support contract, wouldn't it make more sense to ask your support contract?
  27. Replies
    3
    Views
    201

    So you have a string of "yyyy/MM/dd HH:mm:ss.SSS"...

    So you have a string of "yyyy/MM/dd HH:mm:ss.SSS" and you want to convert to a string of "dd.MM.yyyy"?

    I understood it as date/time of format to date of format.
    You can use two Select Values back...
  28. Replies
    3
    Views
    201

    Simply: Don't. Modified Javascript is one of...

    Simply: Don't.
    Modified Javascript is one of the least performant steps in PDI.

    Use Select Values, keep the column as a date column, and just change the format. No need to go to String and back...
  29. Replies
    10
    Views
    459

    This isn't a "give me the codes" type site. ...

    This isn't a "give me the codes" type site.

    You were given a solution to how to generate a key value for data of the form:


    Column
    Value


    Name
  30. Use the embedded SQLLite JAR file to create a...

    Use the embedded SQLLite JAR file to create a SQLLite .db file and load the data using table output. It's REALLY easy, and gets you exactly to your goal.
  31. Ahh but (if I recall correctly) PDI included it...

    Ahh but (if I recall correctly) PDI included it in your install, so you do... You just have to specify the DB correctly.

    I just put in a value in Connection Name, and the path in DB Name, and then...
  32. Don't try to unzip things twice. If you already...

    Don't try to unzip things twice.
    If you already have .txt files, then unzipping isn't needed.
  33. Replies
    7
    Views
    243

    Most of the users on the forum use Pan or Kitchen...

    Most of the users on the forum use Pan or Kitchen to run their KTR and KJB
    You sound like you want to write your own version of carte or DIServer.
  34. Exactly as I said before. Use CSV Input...

    Exactly as I said before.

    Use CSV Input or Text File Input to get the data into PDI.
    Then use the Table Output (connected to your SQLLite DB) to put the data into SQLLite from PDI.
  35. Replies
    7
    Views
    243

    I don't understand your questions. There is no...

    I don't understand your questions.

    There is no .class file generated from a KTR.
    You need to have a working install of PDI in order to run a PDI Transform.
    This is similar to early...
  36. Replies
    7
    Views
    243

    There is no java code in a KTR.

    There is no java code in a KTR.
  37. CSV Input and Text File Input both support VFS...

    CSV Input and Text File Input both support VFS
    You can then connect that to a Table Output pointing at your SQL Lite DB.

    VFS URLS like

    zip:http://somehost/downloads/somefile.zip!the.csv

    ...
  38. Thread: Java Filter

    by gutlez
    Replies
    17
    Views
    415

    Please make sure that you have Lazy conversion...

    Please make sure that you have Lazy conversion turned off in the CSV Input.
  39. Replies
    10
    Views
    459

    Yes, you can. Rather -- you must.

    Yes, you can. Rather -- you must.
  40. Thread: Java Filter

    by gutlez
    Replies
    17
    Views
    415

    Try defining the RcvDate column as a date in the...

    Try defining the RcvDate column as a date in the CSV input step, and it will get redirected out the CSV error handling step.
  41. Thread: Java Filter

    by gutlez
    Replies
    17
    Views
    415

    That would mean that you haven't verified that...

    That would mean that you haven't verified that your date column actually adheres to the date format specified (yyyy-MM-dd HH:mm:ss) which makes sense because the string '1A' is not a date.
  42. Thread: Java Filter

    by gutlez
    Replies
    17
    Views
    415

    And what was that error?

    And what was that error?
  43. Replies
    2
    Views
    195

    You'll need to check if the file exists before...

    You'll need to check if the file exists before the transformation begins.

    All steps in a transformation initialize at the same time, and anything that they can do, they will.
    So as soon as the...
  44. Thread: Java Filter

    by gutlez
    Replies
    17
    Views
    415

    This is exactly the behaviour that is expected...

    This is exactly the behaviour that is expected when you have a string in a column that you are declaring to be an Integer.
    You need to handle the error with the error handling.


    You do need to...
  45. Thread: Java Filter

    by gutlez
    Replies
    17
    Views
    415

    Where's the error message?

    Where's the error message?
  46. You shouldn't need to map the boolean on your...

    You shouldn't need to map the boolean on your table select into true and false.
    Look at the column types coming out of your Table Input (right click and select show output fields) - does it...
  47. http://forums.pentaho.com/showthread.php?159783-Se...

    http://forums.pentaho.com/showthread.php?159783-Setting-Minimal-Width-on-Text-File-Output-when-field-list-unknown

    Another thing to be aware of is that your DB may be sending 'Hi . . . .' (replace...
  48. Do you mean like a DB lookup step? So that you...

    Do you mean like a DB lookup step?
    So that you can look up your set of keys in the DB, and return a row identifier... Rows that have no row identifier are not in the DB, ones that do are in the in...
  49. Do you have the "Supports Boolean" checkbox...

    Do you have the "Supports Boolean" checkbox checked on your Postgres connection?
  50. Replies
    3
    Views
    243

    Assumption: Said ERP software has a client that...

    Assumption: Said ERP software has a client that runs on Windows
    Assumption: You have access to the "Text File" printer that is available in Windows (as a stock add-in)

    Worst case solution: Print...
Results 1 to 50 of 3945
Page 1 of 79 1 2 3 4