IBM Mainframe Forum

Hi All,

Through the File-Aid option, then utilities then XMLGEN
I was able to convert my data file in to XML format data set.

Then i FTP the data set to my destkop.

Could any one let me how can i transfer the contents in the XML file to excel.
This option will help me in maping the copy book fields to the values int he data set.

Thanks and regards,
Naveen N

To add to the above issue:

if i open the FTP'ed XML file i am gettting the error message:

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------

Invalid at the top level of the document. Error processing resource 'file:///X:Documenten/NAVEEN.XML'. Line 27, Posi...

</FILE>

Thanks and regards,
Naveen N

Hello,

What do you see if you open the file in notepad?

Hi,

I am able to see my data in the below XML format:

<?xml version="1.0"?>
<FILE DSN="DATA-SET Name[/b]">
<ABC-FILE-ROOT RECORD="00001">
<NUMBER>123456</NUMBER>
<ABC-NUMBER>272</ABC-NUMBER>
<ID>01</ID>
<BO-NUM>111111</BO-NUM>
</ABC-FILE-ROOT>
<ABC-FILE-ROOT RECORD="00002">
<NUMBER>234567</NUMBER>
<ABC-NUMBER>83162097</ABC-NUMBER>
<ID>01</ID>
<BO-NUM>512344</BO-NUM>
</ABC-FILE-ROOT>
<ABC-FILE-ROOT RECORD="00003">
<NUMBER>233444444</NUMBER>
<ABC-NUMBER>37383543</ABC-NUMBER>
<ID>01</ID>
<BO-NUM>111111</BO-NUM>
</FILE>

Thanks and regards,
Naveen N

Hello,

It appears that the fileaid and the ftp have run successfully (the mainframe processes).

I believe you need to speak with your local desktop support people as to how you can process the file on the pc.