Problem populating the chart with data form XML file or thru XML string

[mmcled]

Hi,

I am having this issue with the free version of the chart.

I am working on a project where i need to read data from a MySQL DB and create a chart form this data.

The chart and DB are on a remote server.

I tried the following 2 aproaches and both did not work:

1) using VBscript/Javascript I read the data from the DB into a string than saved it (using the FileSystemObject) to the Data.XML, this did work locally running the scripts and having the XML file and the flash etc.. files on my local machine and accessing the DB from the remote server. When i uploaded the files to the server, and changed all the relative paths the XML file wouldn't get updated and I will always get the same data displayed ( from the Data.XML file on the server)

The 2nd aproach: 

2) I tried using cookies to create and Pass the XML data from the parsing html page to the Report page.

In this case i checked the created XML string and it looked ok, but the chart will give me invalid XML data.

The following is the code I used to read the cookie etc.. on the report page:

<script language="JavaScript">  

 <!--

 alert("In JScript");

 var strXML = get_cookie ( "XMLData" );

 strXML = strXML + "";

 alert(strXML);

 //var Temp = WrFile(strXML);

 var chart1 = new FusionCharts("Charts/FCF_Column3D.swf", "chart1Id", "400", "300", "0", "0");

 chart1.setDataXML(strXML);

 chart1.render("chartdiv1");

 //alert("Before Delete");

 var ClsCookie = delete_cookie("XMLData");

 

 function get_cookie ( cookie_name )

 {

var results = document.cookie.match ( '(^| ?' + cookie_name + '=([^;]*)(;|$)' );

 

if ( results )

return ( unescape ( results[2] ) );

else

return null;

 }

 function delete_cookie ( cookie_name )

 {

var cookie_date = new Date ( );  // current date & time

cookie_date.setTime ( cookie_date.getTime() - 1 );

document.cookie = cookie_name += "=; expires=" + cookie_date.toGMTString();

 }

 -->

</script>

 

And the following is the created string from the cookie:

I tried seperating the XML elements using VBTab, VBCRLF also " " and none would work.

Any help will be really apreciated.

Thanks

[Arindam]

Hi mmcled,

  Due to invalid XML data, could you please try ones after removing "_" character from xml?

[mmcled]

Hi,

I did try that, I created the XML string using VBscript and I tried seperating the XML tags with VBCRLF, VBCR, Just Space, and no separation, and I got the same result.

The VBCRL and the VBCR shows as "___" in the alert message.

The following is the code i am using the create the cookie:

. . .

dim FirstLine

Firstline ="<graph caption=""" & ChartCaption & """  xAxisName=""NNN"" yAxisName=""Power Month"" showNames=""1"" decimalPrecision=""2"" formatNumberScale=""0"">"

do until objRecordset.EOF

 

NNNNAME=objRecordset.Fields(3)

  mValue= objRecordSet.Fields(4) 

 

  XMLText = "<set name=" & "'" & NNNNAME & "'" & " " & "value=" & "'" & mValue & "'" & " " & "color=" & "'" &  DecToHex(Randomizing) & "'" & " " & "/>" & VBcrlf

 

  LinesInFile =LinesInFile & XMLText

  objRecordSet.MoveNext

 nRec =nRec +1

 loop

 Exp = "expires=Thursday, 30-Jun-2008 00:00:00 GMT"

 Document.cookie= "XMLData" & "=" & Firstline &  LinesInFile &  "</graph>" '& ";" & Exp

 alert document.cookie 

 

 objRecordset.Close

. . .

 

Thx

Edited June 26, 2008 by Guest

[mmcled]

Ahh,  I got it working, I was missing a "'" character in the cookie creation algorithm.