what parameters to specify to open XML in internet explorer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
snt_ds
Premium Member
Premium Member
Posts: 280
Joined: Wed Oct 18, 2006 11:53 am
Location: Pune, India

what parameters to specify to open XML in internet explorer

Post by snt_ds »

Hi All,

I need help on this.
I have a XML file as target. The file is created. it is opened by editplus.But i need to open this in internet explorer. But it is not opening.

It is giving error like

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.


--------------------------------------------------------------------------------

Only one top level element is allowed in an XML document. Error processing resource




So, Please help me on this.


Thanks
Vijay
turash
Premium Member
Premium Member
Posts: 51
Joined: Fri Apr 06, 2007 10:09 am
Location: Edison, NJ

Re: what parameters to specify to open XML in internet explo

Post by turash »

Error message indicates XML structure of the file is not valid.
Check your XML file structure.

snt_ds wrote:Hi All,

I need help on this.
I have a XML file as target. The file is created. it is opened by editplus.But i need to open this in internet explorer. But it is not opening.

It is giving error like

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.


--------------------------------------------------------------------------------

Only one top level element is allowed in an XML document. Error processing resource




So, Please help me on this.


Thanks
Vijay
VCInDSX
Premium Member
Premium Member
Posts: 223
Joined: Fri Apr 13, 2007 10:02 am
Location: US

Post by VCInDSX »

How does your XML structure look like?
Do you have something that resembles the following?

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<Employees>
<Employee>
 <ID>1</ID>
 <Name>Name 1</Name>
</Employee>
<Employee>
 <ID>2</ID>
 <Name>Name21</Name>
</Employee>
</Employees>
<Employees>
<Employee>
 <ID>3</ID>
 <Name>Name 3</Name>
</Employee>
</Employees>
-V
Govindarajan
Participant
Posts: 24
Joined: Mon Jul 12, 2004 10:16 am

XML

Post by Govindarajan »

add the following syntax in begin and end of your XML.

begin

<ALL>
(this should be the first line)
</ALL>
(this should be the last line)
snt_ds
Premium Member
Premium Member
Posts: 280
Joined: Wed Oct 18, 2006 11:53 am
Location: Pune, India

Post by snt_ds »

Yes. It resembles like that only.

But I am unable to open in internet explorer. Please find the structure below.

<?xml version="1.0" encoding="UTF-8"?>
<!--
- Generated by Ascential Software Corporation, DataStage - XMLOutput stage -
- Wed Oct 24 05:16:22 2007
-->
<Performance>
<monthAsOf>
2007-02-28 00:00:00
</monthAsOf>
<fund>
<fundID>
955
</fundID>
<shareClass>
<classLetter>
V2
</classLetter>
<fundTypeCode>
VCT
</fundTypeCode>
<shareName>
Pioneer America Income VCT Portfolio-Class II
</shareName>
<inceptionDate>
2003-05-01 00:00:00
</inceptionDate>
<nasdaqSymbol>

</nasdaqSymbol>
<nav>
<ytd>
1.35
</ytd>
<oneMonth>
1.49
</oneMonth>
<threeMonth>




Thanks
vijay





VCInDSX wrote:How does your XML structure look like?
Do you have something that resembles the following?

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<Employees>
<Employee>
 <ID>1</ID>
 <Name>Name 1</Name>
</Employee>
<Employee>
 <ID>2</ID>
 <Name>Name21</Name>
</Employee>
</Employees>
<Employees>
<Employee>
 <ID>3</ID>
 <Name>Name 3</Name>
</Employee>
</Employees>
Post Reply