Forum Discussion

Yasuhiro1120's avatar
Yasuhiro1120
Copper Contributor
Oct 28, 2021

XML file export

Hi

I wanted to export XML file, but the below message is popped up.

Map I use is IESTM33_map, and I want to confirm that this map is not possible to export fundamentally?

If so, I will give up to use EXCEL to create XML file for TM-33 reporting.

Can anybody tell me this is a fundamental issue which nobody can solve?

 

Thanks.

 

Hiro 

developer
excel
office 365

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 29, 2021

    Yasuhiro1120 Excel can only export XML files which have one level of tags. This structure is allowed:

    <xml>
    <tagLevel1.1>Some Content</tagLevel1.1>
    <tagLevel1.2>Some Content</tagLevel1.2>
    <tagLevel1.3>Some Content</tagLevel1.3>
</xml>

    But this is too complex for Excel:

    <xml>
    <tagLevel1.1>
        <tagLevel1.1.1>Some Content</tagLevel1.1.1>
        <tagLevel1.1.2>Some Content</tagLevel1.1.2>
    </tagLevel1.1>
    <tagLevel1.2>
        <tagLevel1.2.1>Some Content</tagLevel1.2.1>
        <tagLevel1.2.2>Some Content</tagLevel1.2.2>
        <tagLevel1.2.3>Some Content</tagLevel1.2.3>
        <tagLevel1.2.4>Some Content</tagLevel1.2.4>
    </tagLevel1.2>
</xml>