Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: file path inside xml

  1. #1
    Join Date
    Jun 2009
    Posts
    26

    Default file path inside xml

    Hi,

    am having an xml like this,

    <test>
    <shop>D:\Program Files\shopDetails.xml</shop>
    </test>


    i have file path inside xml tag, i need to take the contents of the file...

    Can i go for xml input or any other option?




    thanks,
    kaleesh

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    In 2 steps of course... first read the paths with an xml step, then open the files to read their input with another xml step (get xml data e.g.) or text file input, ...

    And another problem may be the \'s which may be interpreted as escape character.

    Regards,
    Sven

  3. #3
    Join Date
    Jun 2009
    Posts
    26

    Default

    Hi Sven,

    First i read the path with the xml input, but am not able to open the file shopDetails.xml, which component will help... In get data xml, we can only specify the path manually, right...







    thanks,
    kaleesh

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    As of v3.1 with xml get data you can have that step read the file to open from an input field... look at the examples of that step in the samples directory of your PDI installation.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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