Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: XML - input error

  1. #1
    Join Date
    Aug 2007
    Posts
    3

    Default XML - input error

    Hi,

    I'm new to kettle, came to know about this wonderful...Data Integration software...very recently....

    my problem..is ...whenevr i start a new Trrsformation..and in the grid view...select add new step...

    for importing XML file....while previewing i'm getting the message...

    please specify the path to the repeating elements in the XML document...

    do i have to specify...w3c xml standard paths in the xml document...

    this....is may be very basic problem..but i need to solve this problem..immediately...in order to

    get the XML data into mysql tables...


    Thanks in advance...

    jag
    Last edited by ewebket; 08-15-2007 at 07:34 AM.

  2. #2
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    Check a sample called XML Input, it has an example of what should be there.

    Good luck
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3
    Join Date
    Aug 2007
    Posts
    3

    Default I did check...

    i did check with the sample files...given...it is just a plain xml ..

    if u doing xml trasformations..please let me know the steps/procedures u follow...



    Quote Originally Posted by pmalves View Post
    Check a sample called XML Input, it has an example of what should be there.

    Good luck

  4. #4
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    Thats the kind of input you can do, only from a repeating element down (unfortunately). You have a xslt job entry at job level, but still bear in mind that xml support is a bit limited - at least, you need to use different approaches, like parsing the xml one time for each destination table you want to store the data in
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  5. #5
    Join Date
    Aug 2007
    Posts
    3

    Default Solved

    Thanks...for your reply...

    i solved the problem....

    once i setup the the transformation...with a local host mysql Database connection

    added the variables.with Hops in this fashion

    import XMl----xml output---insert/update

    imported an xml file...defined repeating fields in content tab....

    and...got all the fields...

    again..just added...xml output...with a hop input..as xmlinput...fetched the fields...

    added the insert/update...configured...which created a new table in the connected databse...with all fields and data..values...

    this is what i was looking for...
    thanks..and cheers.....for kettle....Data Inte/ETL

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.