Skip navigation
IRISccg
Currently Being Moderated

How to import repeated data cells with XML?

May 6, 2013 7:01 AM

Hello!

 

I have some little troubles with the XML import functionality.

 

Let's consider a billing table:

 

ItemPrice
Tax percentageVATTotal price
Item description$8020%$20$100
Total$80
$20$100
 
Replies
  • Currently Being Moderated
    May 6, 2013 7:07 AM   in reply to IRISccg

    What trouble are you having? Your post doesn't identify what the issue is.

     

    If you want to see what your XML source should be structured like, create a table, add the appropriate data, and export it as XML. Open it in a text editor. Make your output from however the data is generated be like it.

     

    Take care, Mike

     
    |
    Mark as:
  • Currently Being Moderated
    May 6, 2013 7:30 AM   in reply to IRISccg

    Yes, the forum software I love to hate...

     

    Hmm, haven't seen a repeat unless the XML data is malformed. And it appears in the screen shot that a table is inserted into a table? (Well, both repeats appear to be tables in tables).

     

    In a new document, I would begin with creating the data as per your first screen shot (if that is how you want the data), export to XML and compare it to a single node in your imported XML. Cause it looks like unclosed or repeated data.

     

    Mike

     
    |
    Mark as:
  • Currently Being Moderated
    May 6, 2013 8:44 AM   in reply to IRISccg

    I quickly modified an existing XML I am working on. Try this.

     

    <Prices>

    <table>

    <tgroup cols="4">

    <colspec colname="1"/>

    <colspec colname="2"/>

    <colspec colname="3"/>

    <colspec colname="4"/>

    <thead>

    <row>

    <entry>Item</entry>

    <entry>Price</entry>

    <entry>Tax</entry>

    <entry>Total</entry>

    </row>

    </thead>

    <tbody>

    <row>

    <entry>Item 1</entry>

    <entry>Price 1</entry>

    <entry>Tax 1</entry>

    <entry>Total 1</entry>

    </row>

    <row>

    <entry>Item 2</entry>

    <entry>Price 2</entry>

    <entry>Tax 2</entry>

    <entry>Total 2</entry>

    </row>

    <row>

    <entry>Item 3</entry>

    <entry>Price 3</entry>

    <entry>Tax 3</entry>

    <entry>Total 3</entry>

    </row>

    </tbody>

    </tgroup>

    </table>

    </Prices>

     
    |
    Mark as:
  • Currently Being Moderated
    May 6, 2013 11:58 AM   in reply to IRISccg

    I'm not thinking there is a bug, but rather a communication error between what you write and what I think it means. If you needed a different structure, it would have been good to know exactly how you wish for the import to lay out as.

     

    In the end, glad you worked it out.

     

    Mike

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points