Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Anybody could help me please, at least providing...

    Anybody could help me please, at least providing some help to start digging…

    Thanks in advance
  2. starting spoon, several instances of the program are created

    Hi


    I'm buildinga new DI server based on Ubuntu 18.04 and Pentaho DI 8.2, and i noticed thatwhen a user starts Spoon (
    ./spoon.sh &), 5 instances of this program arecreated and running (see...
  3. Hi At first thank you for your answer. However I...

    Hi
    At first thank you for your answer. However I still miss something as the "Destination folder" is set direcly in the transformation which means that:
    in case of transformation fails as the...
  4. moving file in folder if transformation succeed

    hi,

    At beginning of my project i expected that this part of PDI would be the easyier one, but i need to admit i miss a concept.
    I my interface has to treat several type of input files, each one...
  5. Hi, just a short explanation: as my (little)...

    Hi,
    just a short explanation: as my (little) company shared with others an ERP (SAP R/3), as we have not resources enough to build interfaces, some endusers at the endo of the day have to run a...
  6. random number format - how to manipulate it?

    hi,
    i have got several endusers that can upload to my PDI server flat files. those file will be parsed by kettle in order to be introducedvin the database.
    as those people can configure their...
  7. Replies
    2
    Views
    1,545

    Keep pan in memory

    Hi

    I want to treat text files at the moment they are written in a given folder. In oder to achive that, a (linux) script reacts at the event "new file created" and launch PAN.
    This works...
  8. Replies
    2
    Views
    737

    Convert text value into a key + Text

    Hi

    I would like to clean my database as so far my input file has text values.
    Lets imagine i have a flat file with those values:

    date temperature weather
    1/1/12;18;windy
    2/1/12;15;rain...
  9. you are right, the DB number format was too...

    you are right, the DB number format was too small.

    What a lost of time looking for this issue.....

    Thanks
  10. "split fields" for numbers and group using SPACE " "

    Hi

    I have a flat file that i parse. it contains columns separated by "|" and for 3 columns I have such format for numbers:
    | 1 062,000-| 2 289,67-| 1 274,400-|

    --> 1000th separatod :...
  11. Replies
    1
    Views
    1,149

    I reply to my own (stupid) question : instead of...

    I reply to my own (stupid) question : instead of using OUTPUT Table use the Insert / Update
  12. Thread: Error with

    by rischfre
    Replies
    5
    Views
    5,917

    Yes, using the JTDS driver it s working perfecly.

    Yes, using the JTDS driver it s working perfecly.
  13. Replies
    1
    Views
    1,149

    Best way in order to update or insert

    Hi

    I have to refresh a MS SQL Server table, until now the solution I used was to delete all records and reinsert them. But now i m facing issues with this method.

    That means I have to :
    ...
  14. Thread: Error with

    by rischfre
    Replies
    5
    Views
    5,917

    Hi I get it work, using JTDS...

    Hi

    I get it work, using JTDS (http://sourceforge.net/projects/jtds/files/latest/download?source=files)
    But with Microsoft Driver it does not...
  15. Thread: Error with

    by rischfre
    Replies
    5
    Views
    5,917

    Thanks for the answer. But does that mean I...

    Thanks for the answer.

    But does that mean I have to download the JDBC driver from Microsoft and just copy it in my folder?

    That's strange that PDI comes with the JDBC driver and the PRD not......
  16. Thread: Error with

    by rischfre
    Replies
    5
    Views
    5,917

    Error with

    Hi

    I just downloaded the Pentaho Report Designer and tried to build my first report. In order to make the connection with my Database (MS SQL) I used same parameters as in "Pentaho Data...
  17. Replies
    4
    Views
    2,495

    Hi I tried the Ato's solution and its working....

    Hi

    I tried the Ato's solution and its working. A bit anoying to be obliged to define manualy each field in the "split step", but it s working great

    Codek: I like your proposal but does exist a...
  18. Replies
    4
    Views
    2,495

    Exclude first lines of a CSV file

    Hi

    I m working with some "almost CSV" files as input. the only diference btw those files and the "strict CSV" is that first lines (6) contains comentar, dates and so on (no structured at all)....
Results 1 to 18 of 18
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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