Help with OWC & xml datasource

[krishnanrajah]

hi,
I am new in using office web components. I am trying to assign a xm
datasource to the chart component. I understood from articles that th
xml should follow the recordset schema. The problem i face is tha
when the chart appears it shows only one value ( the first value i
both the axis ). I have checked the xml data & the data has lot o
values. The xml data comes from a asp.net page( this is the place
connect to db2 database, convert it to xml & then transform the xml i
to recordset schema using xslt and throw it as output).Please help. I
is very urgent. Thank you for your help in advance.


krishna

 

[Uday Takbhate [MSFT]]

Krishnan,

Please refer to the following KB atricles,

How To Use XML Data with the Chart Component
http://support.microsoft.com/kb/q249805/

HOW TO: Use the Office Web Components with XML Data Generated by an XML Web
Service Created Using ASP.NET
http://support.microsoft.com/?id=315695

Regards,
Uday Takbhate
Microsoft Developer Support
--------------------

NNTP-Posting-Date: Tue, 09 Aug 2005 06:41:21 -0500
From: krishnanrajah <[email protected]>
Newsgroups: microsoft.public.office.developer.web.components
Subject: Help with OWC & xml datasource
Date: Tue, 9 Aug 2005 16:37:56 +0530
Message-ID: <[email protected]>
Organization: Posted via OfficeHelp.IN - http://www.officehelp.in
User-Agent: vBulletin USENET gateway
X-Newsreader: vBulletin USENET gateway
X-Originating-IP: 61.247.254.65
Lines: 5
X-Trace: sv3-b9sYhKGBrIYWNnqa7+TcBlkcfz3qsqxvzNNly+0mMitDYKWDIVS1Cs7HWstLqyM0mk9byfPF
HURWpO9!a04JHNTLotketRofuSRthWy0Rdvo3tIR1kpEZhVVLsvwcM6XHhlM/AAYrw9ngsX6Nw==
X-Complaints-To: (e-mail address removed)
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.32
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!border1.nntp.dca.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.office.developer.web.components:3220
X-Tomcat-NG: microsoft.public.office.developer.web.components

hi,
I am new in using office web components. I am trying to assign a xml

datasource to the chart component. I understood from articles that the
xml should follow the recordset schema. The problem i face is that
when the chart appears it shows only one value ( the first value in
both the axis ). I have checked the xml data & the data has lot of
values. The xml data comes from a asp.net page( this is the place i
connect to db2 database, convert it to xml & then transform the xml in
to recordset schema using xslt and throw it as output).Please help. It
is very urgent. Thank you for your help in advance.

krishnan

--
krishnanrajah
------------------------------------------------------------------------
krishnanrajah's Profile: http://www.officehelp.in/member.php?userid=434
View this thread: http://www.officehelp.in/showthread.php?t=733295
Visit - http://www.officehelp.in |
http://www.officehelp.in/archive/index.php |
http://www.officehelp.in/index/index.php

 

[krishnanrajah]

thanks uday ,
I found the problem.The problem was with the xml format. I just foun
one behaviour of OWC. The xml needs to follow the recordset schema
thats what the documentation states. So the rows should be of forma
<z:row attribute="value" ..... />. As per xml syntax both <z:ro
attribute="value" /> and <z:row attribute="value" > </z:row> are th
same. But OWC accepts the former case, if the xml in the later forma
it doesn't accept. I think this is a strange behaviour. If you coul
explain me why this happens it would be fine.


thanks once again

Krishna

 

[Uday Takbhate [MSFT]]

Internally, OWC uses ADO to load the XML into a record set object.

Try the same file with ADO. If ADO fails, then that’s why OWC fails. If ADO
does not fail, then there is an OWC bug.

Regards,
Uday Takbhate [MSFT]
Developer Support
--------------------

NNTP-Posting-Date: Thu, 01 Sep 2005 01:30:53 -0500
From: krishnanrajah <[email protected]>
Newsgroups: microsoft.public.office.developer.web.components
Subject: Re: Help with OWC & xml datasource
Date: Thu, 1 Sep 2005 11:40:06 +0530
Message-ID: <[email protected]>
Organization: Posted via OfficeHelp.IN - http://www.officehelp.in
User-Agent: vBulletin USENET gateway
X-Newsreader: vBulletin USENET gateway
X-Originating-IP: 219.65.99.254
References: <[email protected]>

Lines: 7
X-Trace: sv3-8tEkNxzQpU3yyvOCGMZOwP37KO93h1hU25AVhagD2aMtW84B/9K3I/YhcSgLWRfqodmZ/Q7V
aZPlQK6!Xnwmt7iyWmb/+EejpvgzvB5DSQm7bjLel+EkkjLec10kiGmJAwvtZKboynKMqp/55w==
X-Complaints-To: (e-mail address removed)
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.32
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
wsfeed1.ip.tiscali.net!news.glorb.com!border1.nntp.dca.giganews.com!nntp.gig
anews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mai
l
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.office.developer.web.components:3352
X-Tomcat-NG: microsoft.public.office.developer.web.components


thanks uday ,
I found the problem.The problem was with the xml format. I just found
one behaviour of OWC. The xml needs to follow the recordset schema,
thats what the documentation states. So the rows should be of format
<z:row attribute="value" ..... />. As per xml syntax both <z:row
attribute="value" /> and <z:row attribute="value" > </z:row> are the
same. But OWC accepts the former case, if the xml in the later format
it doesn't accept. I think this is a strange behaviour. If you could
explain me why this happens it would be fine.


thanks once again

Krishnan

http://www.officehelp.in/archive/index.php |
http://www.officehelp.in/index/index.php

 

[krishnanrajah]

hi uday,

I tried the same with ado & it works fine. I have one more doubt. I
the XML file is greater than 1 mb OWC's performance is going down w
badly. Is there a solution to the same?

please suggest.


regards
Krishna