Realtime line chart not getting data

[bhoffman17]

I have created a reatime line chart but the chart just sits there not plotting any data points. I have tested the InternetCap.aspx page and it provides this data which looks correct.

&label=5/19/2010 4:12:14 PM&value=7.553656E-05|2.6951024

 Here is my dataprovider page InternetCap.aspx:

protected void Page_Load(object sender, EventArgs e)
{
string strSQL = "SELECT TOP 1 InterfaceTraffic.DateTime, Nodes.Caption, InterfaceTraffic.In_Averagebps " +
"FROM InterfaceTraffic join Nodes ON InterfaceTraffic.NodeID=Nodes.NodeID " +
"WHERE Nodes.Caption like 'cdiacc%' " +
"ORDER BY InterfaceTraffic.DateTime DESC";
SqlConnection objConnect = new SqlConnection(connString);
objConnect.Open();
SqlCommand objCommand = new SqlCommand(strSQL, objConnect);
SqlDataAdapter objAdapter = new SqlDataAdapter(objCommand); DataSet objDataSet = new DataSet();
objAdapter.Fill(objDataSet);
string strSQL2 = "SELECT TOP 1 InterfaceTraffic.DateTime, Nodes.Caption, InterfaceTraffic.In_Averagebps " +
"FROM InterfaceTraffic join Nodes ON InterfaceTraffic.NodeID=Nodes.NodeID " +
"WHERE Nodes.Caption like 'chiacc%' " +
"ORDER BY InterfaceTraffic.DateTime DESC";
SqlConnection objConnect2 = new SqlConnection(connString);
objConnect2.Open();
SqlCommand objCommand2 = new SqlCommand(strSQL2, objConnect2);
SqlDataAdapter objAdapter2 = new SqlDataAdapter(objCommand2); DataSet objDataSet2 = new DataSet();
objAdapter2.Fill(objDataSet2);
string newtest = objDataSet.Tables[0].Rows[0][2].ToString();
double cdiaccbps = double.Parse(newtest);
double cdiaccMBps = cdiaccbps / 12500000;
string newtest2 = objDataSet2.Tables[0].Rows[0][2].ToString();
double chiaccbps = double.Parse(newtest2);
double chiaccMBps = chiaccbps / 12500000;
//TestCode Response.Write(DateTime.Now + " " + objDataSet.Tables[0].Rows[0][1] + " " + cdiaccMBps + " MBps<br>");
//TestCode Response.Write(objDataSet2.Tables[0].Rows[0][0] + " " + objDataSet2.Tables[0].Rows[0][1] + " " + chiaccMBps + " MBps<br>");
Response.Write("&label=" + DateTime.Now + "&value=" + cdiaccMBps + "|" + chiaccMBps);
 objConnect.Close();
objConnect.Dispose();
objConnect2.Close();
objConnect2.Dispose();
}

Here is my xml file:

<chart caption='Internet Capacity Usage' subCaption='Mbps' dataStreamURL='InternetCap.aspx' refreshInterval='5' setAdaptiveYMin='1' xAxisName='Time' showRealTimeValue='1' realTimeValuePadding='50' labelDisplay='Rotate' slantLabels='1'>
<categories>
</categories>
<dataset seriesName='cDiacc' showValues='0'>
</dataset>
<dataset seriesName='cHiacc' showValues='0'>
</dataset>
<styles>
<definition>
<style type='font' name='captionFont' size='14' />
</definition>
<application>
<apply toObject='Caption' styles='captionFont' />
<apply toObject='Realtimevalue' styles='captionFont' />
</application>
</styles>
</chart>

and here is my defult.aspx code just for chart:

<div id="Chart5"> 
</div>
<script type="text/javascript">
var internetCap = new FusionCharts("../FusionWidgets/RealTimeLineDY.swf", "internetCap", "450", "300", "0", "0");
internetCap.setDataURL("../InternetCapacity/InternetData.xml");
internetCap.render("Chart5");
</script>

 

I have the .js files linked to so i know its not that. Please help this chart looks amazingly useful.

Ben

[Guest Basundhara Ghosal]

Hi Ben,

Could you please try the following:-

1) Please enable the debug-mode of the chart by setting it to '1'.

Ref.- var internetCap = new FusionCharts("../FusionWidgets/RealTimeLineDY.swf", "internetCap", "450", "300", "1", "0");

2) Please render the chart on the browser page and wait for around one minute.

3) Please send us screen-shot of the message received on the debug-window after one minute as an attachment.

Awaiting your reply.

[bhoffman17]

WOW i didnt even know there was a debug option! That was amazing. The file path was wrong because the dataStream URL has to be relative to the page pulling the file, not where the XML file is located.

Thanks so much!

Ben

[bhoffman17]

This is another problem i run in to. When i upload the files and try to look at the site i get fusioncharts is not defined. How do i fix this?

Thanks

[bhoffman17]

ok i fixed that error but now it just loads and doesnt show the charts. It just keep loading.

What could be the issue?

THanks,

Ben

[bhoffman17]

OK i think i narrowed down the problem: here is the value that is getting passed to the chart:

&chartWidth=250&chartHeight=35&debugMode=0&dataURL=InfrastructureCapacity%2fSuperDome3.aspx

shouldn't that dataURL be InfrastructureCapacity/SuperDome3.aspx?

My code is:

string dataURL = Server.UrEncode("InfrastructureCapacity/SuperDome2.aspx");
//Create the chart with dataURL as strDataURL
return FusionCharts.RenderChartHTML("FusionWidgets/SparkLine.swf", dataURL, "", "SuperDome2Capacity", "250", "35", false);

So whats the problem?

THanks

Ben

[Guest Basundhara Ghosal]

Hi,

Could you please send us the screen-shot of the error that you are getting as attachment?

Please note that you need to enable your debug-mode before you take the screen-shot of the error.

Awaiting your reply. :hehe:

[bhoffman17]

Actually i think everything is working now. Just had to re upload. Sorry for the panic.

 

 

 

God Bless!

 

 

 

Ben

[Guest Basundhara Ghosal]

Hi Ben,

Glad that your issue is resolved and its working fine now.

Keep smiling and keep FusionCharting.