Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 5 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Hi, Sounds like some permissions changed on...

    Hi,

    Sounds like some permissions changed on your target instance. I would verify the userid you use still has the necessary access.

    HTH.
  2. Hi Ed, If you are using crontab - 0 0 1 */3 *...

    Hi Ed,

    If you are using crontab - 0 0 1 */3 * (run first day of every third month)

    HTH
  3. Replies
    8
    Views
    628

    Lucas, On my linux machine it is in the...

    Lucas,

    On my linux machine it is in the '.kettle' (maybe hidden) directory.

    Thanks
  4. Replies
    8
    Views
    628

    Hi Lucas, Use a variable - set up in your...

    Hi Lucas,

    Use a variable - set up in your kettle.properties file. It is then available to all transformations.

    eg source_user_password=yourpassword

    In you connection input, specify the...
  5. Replies
    4
    Views
    633

    Hi Vineeth, I agree with marabu. Kettle is a...

    Hi Vineeth,

    I agree with marabu. Kettle is a tool to process data. It doesn't hold (personal)
    data in any form within it's components - it's just a repository of meta-data that tells a process...
  6. Replies
    3
    Views
    2,081

    Hi, See -...

    Hi,

    See - https://help.pentaho.com/Documentation/8.0/Setup/Components_Reference - page down to Java Virtual Machine section.

    I would say that Java 9 has not been assessed as yet.

    Thanks,
  7. Replies
    3
    Views
    2,081

    Hi, I'm not sure Pentaho 8.0 runs under Java...

    Hi,

    I'm not sure Pentaho 8.0 runs under Java 9. The documentation says to use Java 8.
  8. Hi dbogey, It looks like you have Enterprise...

    Hi dbogey,

    It looks like you have Enterprise (and thus supported) version. I think that's why they say you need to run tomcat etc, otherwise if you ask for help, they could refuse.

    For us, I...
  9. Hi, According to...

    Hi,

    According to https://wiki.pentaho.com/display/EAI/.07+Variables

    you should be able for specify 'c$[3A]' to denote 'c:'.

    Give that a go.
  10. Replies
    8
    Views
    1,869

    Hi, I think that since you are reading all...

    Hi,

    I think that since you are reading all files from a directory, you should use the Copy rows to results scenario.

    You would three fields in your result rows - filename, cutfrom, cutto.
    ...
  11. Hi, Try escaping the ":" - c\:\\ ( you want...

    Hi,

    Try escaping the ":" - c\:\\ ( you want c:\ right?)
  12. Replies
    8
    Views
    1,869

    Yes - I always use a Get Variables step to make...

    Yes - I always use a Get Variables step to make sure they are available in the current transformation.
  13. Hi Gaëtan, You could setup a Parameter for the...

    Hi Gaëtan,

    You could setup a Parameter for the job and then you that in the connection database field of the connection.

    Example :-

    Define a Parameter in the JOB properties (ie. DBNAME)
    In...
  14. Replies
    8
    Views
    1,869

    Hi Burnie, Are you defining and using the ${}...

    Hi Burnie,

    Are you defining and using the ${} variables in the same transformation? If so, you can't do this in Pentaho. You need a separate transformation to set the variable values and then you...
  15. Replies
    21
    Views
    31,407

    Sticky: FYI - PDI CE version 8 available -...

    FYI - PDI CE version 8 available - https://sourceforge.net/projects/pentaho/files/Pentaho%208.0/
  16. Hi, Try...

    Hi,

    Try http://wiki.pentaho.com/display/EAI/Get+File+Names

    HTH
  17. Replies
    11
    Views
    1,581

    Hi Gosforth, Have you tried grabbing what you...

    Hi Gosforth,

    Have you tried grabbing what you are sending the the authorization fields and putting it in your favorite browser. I think it should tell you if it's valid or what any issue is.
    ...
  18. Hi Cris123, I think you will need to use 'Get...

    Hi Cris123,

    I think you will need to use 'Get mails (POP3/IMAP)' (Job component) to save the attachments to a specific folder and then re-attach them when you send the new emails (specifying...
  19. Hi, Is there no way to preprocess some of your...

    Hi,

    Is there no way to preprocess some of your input? If you are really processing 600M rows every time, I think you are in a losing battle.

    You need to re-examine your flow/design if you can...
  20. Replies
    4
    Views
    1,261

    Hi bobv, Do you have the -o option or...

    Hi bobv,

    Do you have the -o option or redirect '>' to capture the output?
    After the curl command, can you display the return code ($? in bash)

    Maybe you need other options for curl?

    HTH
  21. Hi, Solution found (for me at least) - I just...

    Hi,

    Solution found (for me at least) - I just moved the Execute shell script into the transformation (changed to 'execute process')

    Just in case someone else encounters the same issue.
    ...
  22. PDI 7.1.0 - Execute shell script for each input row - Fails if no rows passed

    Hi,

    Testing migrating to PDI 7.1.0. I have a process as below.

    18769

    The first transformation copies rows to results and the second 'executes for every input row' and I have 'Copy previous...
  23. Hi, Start here -...

    Hi,

    Start here - http://wiki.pentaho.com/display/BAD/Cassandra . You might have to installed the pluging - https://github.com/pentaho/pentaho-cassandra-plugin

    I have never used this but HTH.
  24. Replies
    1
    Views
    904

    Hi, This is not a PDI issue. You need to...

    Hi,

    This is not a PDI issue. You need to install pandas on the machine where you are running the script. Google is your friend on this one ;-)

    HTH
  25. Replies
    1
    Views
    635

    Hi Amarendra, Is the process you are calling...

    Hi Amarendra,

    Is the process you are calling supposed to produce output? If so, then I would suspect you would need to :-

    1) Use the id provided to 'poll' the job until it completed.
    2) Call...
  26. Hi, It sounds like you will have to use the...

    Hi,

    It sounds like you will have to use the API (not salesforce input) to load data. To me it looks like several steps :-

    1) Prepare csv
    2) Authenticate to salesforce
    3) Add file description...
  27. Replies
    6
    Views
    997

    Buddy, As I read the docs, it seems that you...

    Buddy,

    As I read the docs, it seems that you need to pass different authentication depending the which API you are trying to access. If you need to pass a JWT signature you will need to use the...
  28. Replies
    6
    Views
    997

    Hi Buddy, Have you looked at -...

    Hi Buddy,

    Have you looked at - https://connect.liveperson.com/content/getting-started-building-restful-chat ?

    Is this the set of API's you are looking at?

    I think it will have to be a case...
  29. Replies
    1
    Views
    552

    Hi Bhavya, Are you upgrading directly from 5.4...

    Hi Bhavya,

    Are you upgrading directly from 5.4 -> 7 ? If so, it is advised to upgrade through the major releases 5.4 -> 6 -> 7 because there could be subtle differences behind the scenes that...
  30. Replies
    1
    Views
    377

    Hi, I think your best bet is a custom...

    Hi,


    I think your best bet is a custom javascript. You can control outputting of rows using 'skip transformation'

    This link might be helpful -...
  31. Replies
    6
    Views
    997

    Hi Buddy, You usually have to form the request...

    Hi Buddy,

    You usually have to form the request string that contains your customer/access key. Not sure what API you are trying to access but there is normally some kind of documentation if it's a...
  32. Replies
    4
    Views
    585

    HI crisaf, Try Number Range (under Transform)...

    HI crisaf,

    Try Number Range (under Transform)

    HTH
  33. Replies
    4
    Views
    880

    Hi, Given your simple example, I have managed...

    Hi,

    Given your simple example, I have managed it using filter and multi-merge. I put data into csv but you should be able to add to your flow.

    18576

    See if that works
  34. Hi, I tried a test :- Input csv - date...

    Hi,

    I tried a test :-

    Input csv - date format 'MMMyyyy'
    Ouptut - date format 'yyyy-MM-01' (assuming you want the day to be the first of the month).

    No other transformations needed.

    HTH.
  35. Thread: If contains

    by tnewman
    Replies
    4
    Views
    1,446

    Hi scharan, How about trying 'Fuzzy match'?...

    Hi scharan,

    How about trying 'Fuzzy match'? Have a file with the key words and use that as input. Add to the list as you find new values.

    I'm not sure you can achieve what you want without...
  36. Hi, If your output text file has a header row...

    Hi,

    If your output text file has a header row comma/tab separated then you should be able to you this for the input - specify a header row exists.

    Does that help?
  37. Replies
    6
    Views
    1,458

    Hi Gosforth, You can use 'Generate row' (set #...

    Hi Gosforth,

    You can use 'Generate row' (set # of rows = 1) then in the value column, enter the literal you want.

    HTH.
  38. Hi Gutlez, Hmm - not what I was hoping for but...

    Hi Gutlez,

    Hmm - not what I was hoping for but thanks for your response.

    I will use a transform.
  39. Issue using 'Copy Files' to merge to single file

    Hi,

    I am trying to use 'Copy Files' in a Job to merge several files to one. Here;s my setup :-

    18269

    I have 'Destination is a file' and 'Replace existing files' checked on the Settings tab....
  40. Hi, Try a filter, something like :- {...

    Hi,

    Try a filter, something like :-

    { Created_dt : { $gte : ISODate("2017-05-15T00:00:00.000Z")} }

    The format of the date can vary so you might need to adjust that part.

    HTH
  41. Replies
    21
    Views
    31,407

    Sticky: Hi, You can download PDI CE 7.1 -...

    Hi,

    You can download PDI CE 7.1 - https://sourceforge.net/projects/pentaho/files/Data%20Integration/

    HTH
  42. Hi alan_s, Have you tried executing the...

    Hi alan_s,

    Have you tried executing the statement in a 'table input' component? You can preview the results of the statement, it might give you more clues.

    Regards
  43. Marabu, Must have been a Friday/end of week...

    Marabu,

    Must have been a Friday/end of week brain-hiccup. I figured it out.
  44. 'Put SFTP' not sending all files when using wildcard setting

    Hi,

    I am using 'Put files with SFTP' with a wildcard setting but it seems to be skipping one file. Setup :-

    Wildcard = hhhh_.*${file_date}.*\.pgp

    ${file_date} = 20170512093334

    The files...
  45. Hi Sanket, I think you need to convert NaN to...

    Hi Sanket,

    I think you need to convert NaN to a value. I found :-

    https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions090.htm

    HTH.
  46. Replies
    1
    Views
    1,743

    Hi Timo, That's a big ask! I can give you some...

    Hi Timo,

    That's a big ask! I can give you some more pointers.

    1) With a good API, when there is more results than the max allowed in one request, there is usually and page/record pointer that...
  47. Replies
    1
    Views
    1,261

    Hi pooja, You don't provide much detail on...

    Hi pooja,

    You don't provide much detail on your issue, but it sounds like the query you are trying to run is taking too long to get results from the API. You can try looping through dates based on...
  48. Replies
    4
    Views
    1,767

    Hi mashraf, Sounds like the query you are...

    Hi mashraf,

    Sounds like the query you are trying to run is taking too long to get results from the API. You can try looping through dates based on created_date for records in the table.

    Not...
  49. Hi jasonjo, Not sure if you are using a...

    Hi jasonjo,

    Not sure if you are using a database or file repository?

    I use a database (mySql).

    You really need an upgrade path through major versions - 4.2 -> 5 ->6 -> 7. Export the repo...
  50. Hi jendmaoul, I would say your EVENT_VALUE is...

    Hi jendmaoul,

    I would say your EVENT_VALUE is JSON-like. I would expect an example to look like :-

    {
    "af_currency": "USD",
    "af_content_id": "15555048",
    "af_quantity": 1,
    "af_price":...
Results 1 to 50 of 237
Page 1 of 5 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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