Hitachi Vantara Pentaho Community Forums
Results 1 to 11 of 11

Thread: Get data from XML

  1. #1

    Default Get data from XML

    Could not get the attached XML to display any rows.
    Is the format of the XML file incorrect ?
    Also attached transformation.
    Attached Files Attached Files

  2. #2

    Default

    Hi,
    first put /AirportGetAirportsResponse/AirportDetail as Loop Xpath
    Second, check 'Namespace aware' option.


    Samatar
    Samatar

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Set the Loop XPath parameter to "/AirportGetAirportsResponse/AirportDetail".
    Then check the "Namespace aware?" checkbox. For some reason it needs this. I'm unfortunately no XPath expert.
    Then grab @AirportCode etc.

    If you feel like it, post your solution over on the wiki: http://wiki.pentaho.com/display/EAI/Get+Data+From+XML

    TIA,
    Matt

  4. #4

    Default

    Hi Matt,
    In the sample file,
    URI xmlns="http://pathfinder-xml/AirportService.xsd" identifiy a namespace.
    The document contruction requires names constructed before parsing..

    Take care

    Samatar
    Samatar

  5. #5

    Default

    You would think 2 replies with the same answer would work but it didn't.
    When I select "Preview Rows" I get no rows.
    I attached the .ktr.......let me know if I missed something.

  6. #6

    Default

    Oops I did miss something the attachement
    Transformation attached.
    Attached Files Attached Files

  7. #7

    Default

    See attached sample.

    Samatar
    Last edited by shassan2; 03-31-2009 at 08:31 AM.
    Samatar

  8. #8

    Default

    Were you able to preview rows ?
    Tried your .ktr and still no rows.
    I'm using Kettle version 3.1.0-M2.

  9. #9

    Smile

    see attached
    Last edited by shassan2; 03-31-2009 at 08:31 AM.
    Samatar

  10. #10
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    3.1.0-M2 is too old. "Get Data From XML" is a brand new step and therefor under scrutiny.
    Grab a recent build over here:

    ftp://download.pentaho.org/client/da...gration/3.1.0/

  11. #11

    Default

    Well it helps to have the latest and greatest !
    Now it works.......thank you.

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.