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

Search Forums:

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

Page 1 of 54 1 2 3 4

Search Forums: Search took 0.15 seconds.

  1. Replies
    1
    Views
    43

    I feel like something is getting lost in...

    I feel like something is getting lost in translation.

    The "How do you want to handle two outputs" is a basic logic piece - you have to tell PDI if you want to split the rows between the following...
  2. Which OS? Unix: You could schedule something...

    Which OS?

    Unix: You could schedule something in your startup scripts, or in cron.
    Windows: You could schedule something in autoexec.bat (I'm not sure if Windows Task Scheduler has "On Boot")
  3. Replies
    18
    Views
    171

    I'm getting the same, but not just on the Zip,...

    I'm getting the same, but not just on the Zip, the BZ2 as well.

    When I manually uncompressed them, and rebuilt it as described (bzip2 in zip file), I was able to do a GetFileNames on the zip:file...
  4. Replies
    18
    Views
    171

    Got it.

    Got it.
  5. Your question is actually very similar to this...

    Your question is actually very similar to this thread
    It's just that your "New Record" flag is "C400"
  6. Thread: sql Join

    by gutlez
    Replies
    1
    Views
    47

    Try setting the "Error on Multiple Rows" on your...

    Try setting the "Error on Multiple Rows" on your lookups.
  7. Replies
    18
    Views
    171

    Can you attach a really simple example file (of...

    Can you attach a really simple example file (of the Zip containing BZip files)?
  8. Find the file %USERPROFILE%/.kettle/.spoonrc...

    Find the file %USERPROFILE%/.kettle/.spoonrc
    Find the line OpenLastFile=Y
    Change it to OpenLastFile=N
    Save the file, and try it again.
  9. Replies
    18
    Views
    171

    Just a thought.... What about a Get File Names...

    Just a thought....

    What about a Get File Names step: zip:file://path/to/zip wildcard .*\.bz2
    Then the file input would be bz2:zip:file://path/to/zip/!bz2/file.txt ?
  10. By definition, all variables are strings... Do...

    By definition, all variables are strings... Do as njain suggested, and then convert it to an int.
  11. Replies
    2
    Views
    62

    This page...

    This page?
  12. Replies
    4
    Views
    149

    EE indicates that you have a support contract. ...

    EE indicates that you have a support contract. You might want to ask your Pentaho contact about this.
  13. Replies
    3
    Views
    94

    You know... This really screams "Build a cube"...

    You know... This really screams "Build a cube" to me.
    I'm not 100% sure how you would do "Last 12 months" and "Last 6 months", but there are a bunch of wizards over in the Mondrian forum that could...
  14. Replies
    8
    Views
    123

    And this is why I like marabu's solutions! I...

    And this is why I like marabu's solutions!
    I don't like the Javascript step - I consider it a last-resort step...
  15. Replies
    8
    Views
    123

    This request seems to come up often, and I'd love...

    This request seems to come up often, and I'd love to learn how to code a plug in just to solve it.

    In the mean-time, the usual solution:
    Text File Input - Read in each line of your file as a...
  16. Replies
    1
    Views
    63

    I usually recommend people start by reviewing the...

    I usually recommend people start by reviewing the step documentation.
    Specifically, in your case: This page
  17. Turn off batch updates, and you'll get a better...

    Turn off batch updates, and you'll get a better response from PostgreSQL

    Right now, it's telling you to "Call getNextException to see the cause."

    It may be something as simple as a type...
  18. Also, have a look in the "Run All" in the samples...

    Also, have a look in the "Run All" in the samples directory.
  19. Replies
    4
    Views
    144

    Depending on the PL/SQL code, you can sometimes...

    Depending on the PL/SQL code, you can sometimes do it in a Table Input step, which would make sense if you are trying to return a data set.

    Execute SQL is mostly for updating data within a...
  20. You would likely have to use the MS JDBC driver,...

    You would likely have to use the MS JDBC driver, rather than jtds ( http://sourceforge.net/p/jtds/feature-requests/73/ )
  21. Thread: Lead/lag series

    by gutlez
    Replies
    3
    Views
    95

    But don't forget to set the group on the Analytic...

    But don't forget to set the group on the Analytic Query to be your product!
  22. Did you declare the parameter in Transform 2? ...

    Did you declare the parameter in Transform 2? (Hint: Open Transform 2 and press Ctrl-T and then go to the Parameters tab)
  23. Transform 1 ends with "Copy Rows to Results"...

    Transform 1 ends with "Copy Rows to Results"
    Transform 2 declares Parameter "xxVALUE" (used in the Table Input as "select ... where xx=${xxVALUE}" quoting may be required!)
    In the Job, on the step...
  24. Replies
    1
    Views
    81

    Pentaho Report Output is a step designed to RUN a...

    Pentaho Report Output is a step designed to RUN a report file, not push data into a report that already exists.
    You cannot circularly reference the Transformation and the Report.

    Have a good look...
  25. First thing I would suggest is using the MS...

    First thing I would suggest is using the MS Access input rather than Table Input over ODBC.
  26. And njain provided you one way to do that. Not...

    And njain provided you one way to do that. Not the only way, but one way.
  27. Replies
    2
    Views
    129

    Well, tell us about your situation, not just "It...

    Well, tell us about your situation, not just "It doesn't work" or "it seems a problem with..."

    There should be some sort of error message that gets displayed....

    Note: The forum will help those...
  28. Replies
    2
    Views
    105

    Try a wildcard (RegEx) of...

    Try a wildcard (RegEx) of productiondb_out_f_monthly_.*\.csv
  29. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    364

    Ok, so that shows that there are no directories...

    Ok, so that shows that there are no directories in the "SRG - MyFactory" directory.
    So what about the "BS - MyFactory" directory?

    Are you ABSOLUTELY sure that you are using the same repository...
  30. Replies
    11
    Views
    642

    You need to change the DB driver from MS SQL...

    You need to change the DB driver from MS SQL (JDBC) to MS SQL (JDBC-Native)
  31. Replies
    11
    Views
    642

    Paul, When they mention "Native" driver, they...

    Paul,

    When they mention "Native" driver, they mean the MS Driver, not the jTDS driver.
    Link works (at least today)

    It is not Open Source, so it cannot be distributed with Pentaho. It is...
  32. Put another select values step directly after...

    Put another select values step directly after your Table Input.
    On the MetaData tab, change the "Format" for the offending column to "000000000.000" (Leave the decimal as "," and the group as ".")
    ...
  33. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    364

    Based on the second half of your response, the...

    Based on the second half of your response, the questions about the JARs for the Repository's DB are now irrelevant. :D

    Note that your "CMP - MyFactory" directory cannot be found in the...
  34. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    364

    What version of PDI are you using? What DB is...

    What version of PDI are you using?
    What DB is the repository held in?
    Do you have the appropriate JAR files for connecting to the repository's DB in the appropriate lib directory?

    Also, can you...
  35. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    364

    Post the output of the first step from the other...

    Post the output of the first step from the other post:

    kitchen /listrep
  36. Assuming that your KTR is the one in the sample,...

    Assuming that your KTR is the one in the sample, what happens if you replace the generated row with:

    select 1 as num, TO_DATE(null, 'YYYY-MM-DD')


    Also...

    If you are selected a column that...
  37. The Reporting Output Step will be run once for...

    The Reporting Output Step will be run once for each row sent to it - it is not intended to supply the report with the data that the report will need.

    Could you post the transformation, and we can...
  38. If you require urgent assistance with an issue, I...

    If you require urgent assistance with an issue, I would recommend you contact Pentaho ( http://www.pentaho.com/services ) and get a support contract.
  39. Replies
    9
    Views
    250

    Try the Mail Job Entry...

    Try the Mail Job Entry
  40. Thread: automatic Job

    by gutlez
    Replies
    13
    Views
    364

    You have spaces in your names... Did you...

    You have spaces in your names... Did you remember to enclose them in quotes?

    kitchen.bat /rep:Kettle /job:PAs aelter als 2 Wochen /dir:/CMP - MyFactory/MyFactory/ /user:admin /pass:Passwort1
    vs...
  41. I don't know that there's an easy way to do that,...

    I don't know that there's an easy way to do that, short of joining on just the phone number, and then filtering out the records that don't meet your time window. You could do a calculation...
  42. Replies
    5
    Views
    262

    Usual answer on this: Start back at the...

    Usual answer on this:
    Start back at the beginning to figure out what's going on.

    Excel Input -> Text File Output. If that runs, then add the next step from your transform, and repeat.

    Note...
  43. Replies
    2
    Views
    183

    Each Job Entry has the option of allowing you to...

    Each Job Entry has the option of allowing you to execute the next step based on success or on fail.
    You can use this functionality to send mail on steps that fail to execute completely.

    You also...
  44. Replies
    4
    Views
    611

    You can configure Firefox to pass NTLM...

    You can configure Firefox to pass NTLM information to the server. (See here)
    I'm not sure how you configure the server to understand it.

    Short answer: I can get you one step closer, but not all...
  45. Replies
    10
    Views
    229

    Two ways I can think of: 1) Your calling Job...

    Two ways I can think of:

    1) Your calling Job would specify the carte server as an "Execute on remote server" for an additional job that would collect the file, and process it.
    2) Your calling Job...
  46. Replies
    10
    Views
    229

    Another option is to have a Carte server running...

    Another option is to have a Carte server running "near" the database, which will grab that text file, and process it into the DB... Thus your network roundtrip times are a lot shorter.
  47. Replies
    10
    Views
    229

    After you swap the Insert / Update with an Update...

    After you swap the Insert / Update with an Update step, you still have to select the "Don't perform lookup" box, or it will still do a lookup first. Don't ask - I don't know why it does that.
  48. Replies
    10
    Views
    229

    You might be able to squeeze a little bit more...

    You might be able to squeeze a little bit more out of it by using an Update step, and disabling the lookup. But that shouldn't improve the speed much. Do you have cache turned on on the Combination...
  49. Have a good look at:...

    Have a good look at:
    http://wiki.pentaho.com/display/EAI/Dimension+Lookup-Update
  50. Replies
    1
    Views
    115

    Something like:...

    Something like:...
Results 1 to 50 of 2673
Page 1 of 54 1 2 3 4