Skip navigation
Currently Being Moderated

How to import repeated data cells with XML?

May 6, 2013 7:01 AM



I have some little troubles with the XML import functionality.


Let's consider a billing table:


Tax percentageVATTotal price
Item description$8020%$20$100
  • 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.



    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.




    <tgroup cols="4">

    <colspec colname="1"/>

    <colspec colname="2"/>

    <colspec colname="3"/>

    <colspec colname="4"/>











    <entry>Item 1</entry>

    <entry>Price 1</entry>

    <entry>Tax 1</entry>

    <entry>Total 1</entry>



    <entry>Item 2</entry>

    <entry>Price 2</entry>

    <entry>Tax 2</entry>

    <entry>Total 2</entry>



    <entry>Item 3</entry>

    <entry>Price 3</entry>

    <entry>Tax 3</entry>

    <entry>Total 3</entry>






    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.



    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