Sign in to follow this  
tommannanchery

Error: If you've special characters in your XML (like %, &, ' or accented characters), please URL Encode them.

Recommended Posts

Hi,

I was running into this weird issue, which could be trivial. Maybe I am missing something.

I have a Multi Series chart, the xml for which is as follows (Please note the link attribute):

<chart caption='Student Enrollment Stats' xAxisName='Department - Year' yAxisName='Student Count' showValues='0' formatNumberScale='0' showBorder='1'>

<categories>

<category label='Biotechnology'/>

<category label='Computer Science'/>

<category label='Literature'/>

<category label='Health Sciences'/>

<category label='Environmental Sciences'/>

<category label='Civil Engineering'/>

</categories>

<dataset seriesName='2006'>

<set value='4' link='%3FdeptID=1%26yearEnrolled=2006'/>

<set value='5' link='%3FdeptID=2%26yearEnrolled=2006'/>

<set value='3' link='%3FdeptID=3%26yearEnrolled=2006'/>

<set value='5' link='%3FdeptID=4%26yearEnrolled=2006'/>

<set value='2' link='%3FdeptID=5%26yearEnrolled=2006'/>

<set value='6' link='%3FdeptID=6%26yearEnrolled=2006'/>

</dataset>

<dataset seriesName='2007'>

<set value='4' link='%3FdeptID=1%26yearEnrolled=2007'/>

<set value='5' link='%3FdeptID=2%26yearEnrolled=2007'/>

<set value='3' link='%3FdeptID=3%26yearEnrolled=2007'/>

<set value='5' link='%3FdeptID=4%26yearEnrolled=2007'/>

<set value='2' link='%3FdeptID=5%26yearEnrolled=2007'/>

<set value='6' link='%3FdeptID=6%26yearEnrolled=2007'/>

</dataset>

<dataset seriesName='2008'>

<set value='4' link='%3FdeptID=1%26yearEnrolled=2008'/>

<set value='5' link='%3FdeptID=2%26yearEnrolled=2008'/>

<set value='3' link='%3FdeptID=3%26yearEnrolled=2008'/>

<set value='5' link='%3FdeptID=4%26yearEnrolled=2008'/>

<set value='2' link='%3FdeptID=5%26yearEnrolled=2008'/>

<set value='6' link='%3FdeptID=6%26yearEnrolled=2008'/>

</dataset>

</chart>

This chart renders fine. And the drill down mechanism works smooth.

But the following Single Series chart fails to be generated and gives me an error: ERROR: Invalid XML encountered. An XML element is malformed. Check the XML data that you've provided. If you've special characters in your XML (like %, &, ' or accented characters), please URL Encode them.

<chart caption='Student Enrollment Stats - '2008' xAxisName='Department' yAxisName='Student Count' showValues='0' formatNumberScale='0' showBorder='1'>

<set label='Biotechnology' value='4' color='FFA500' link='%3FdeptID=1%26yearEnrolled=2008'/>

<set label='Computer Science' value='5' color='FFFF00' link='%3FdeptID=2%26yearEnrolled=2008'/>

<set label='Literature' value='3' color='FFA500' link='%3FdeptID=3%26yearEnrolled=2008'/>

<set label='Health Sciences' value='5' color='FFFF00' link='%3FdeptID=4%26yearEnrolled=2008'/>

<set label='Environmental Sciences' value='2' color='FF0000' link='%3FdeptID=5%26yearEnrolled=2008'/>

<set label='Civil Engineering' value='6' color='FFFF00' link='%3FdeptID=6%26yearEnrolled=2008'/>

</chart>

The link attributes are same for both the xml data, then why does it work for one and not for the other.

Hope to get some answers from this forum.

Share this post


Link to post
Share on other sites

Ok guys .. I found the mistake. Just being a lot careless. I thought that the problem would be in the link section cuz of the error description, but it was here:

<chart caption='Student Enrollment Stats - '2008' xAxisName='Department' yAxisName='Student Count' showValues='0' formatNumberScale='0' showBorder='0'>

There is an extra ' (apostrophe) before the '2008 ' in the chart caption and that messed up the xml data.

I am glad I figured it out and hope this helps someone.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this