DJJWP
Posts: 77
|
| Posted: 03/15/2007, 5:55 PM |
|
I have been able to get Fusion charts running on PHP and CCS but need ASP as well. The way I got it done in PHP thanks to the help of pattyD  on here but it did not work on ASP.
Does anyone have a documented process?
_________________
Network Operations Rule |
 |
 |
Benjamin Krajmalnik
|
| Posted: 03/15/2007, 11:40 PM |
|
There is no difference - I use it in both. Actually ended up writing class
wrappers to make my code portable.
What I do is have a "data provider" page.
The data provider has one label.
THe html page is totally stripped so it oly has the label's tag
In the before show of the label for the data provider I insert the working
code which generaltes the XML.
Remember, the HTML view of your data provider is totally blank except for
the {Label}
(which in my case I call {XMLData})
"DJJWP" <DJJWP@forum.codecharge> wrote in message
news:645f9f9167781c@news.codecharge.com...
>I have been able to get Fusion charts running on PHP and CCS but need ASP
>as
> well. The way I got it done in PHP thanks to the help of pattyD on
> here did
> not work on ASP.
>
> Does anyone have a documented process?
>
>
> _________________
> Network Operations Rule
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
DJJWP
Posts: 77
|
| Posted: 03/16/2007, 8:50 AM |
|
Do you use this as a include page? No matter what I do I end up with the chart at the top of the page and anything else gets pushed down.
_________________
Network Operations Rule |
|
|
|
Mango_Lier
Posts: 110
|
| Posted: 03/16/2007, 8:58 AM |
|
Take a look at my "Tips & Techniques" section post on how to create data island to spit out XML.
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 03/16/2007, 9:58 PM |
|
No.
The chart page would have an HTML label, which would have the flash object.
I use the dataurl method. The url which is called creates the xml for the
chart.
So, the BeforeShow event of my label has the following code:
Dim MyURL
MyURL =
"SOBreakDownData.asp?s_DataType=1&s_StartDate="&StartDate&"&s_EndDate="&EndDate
MyURL = CCToURL(MyURL)
Set graph = new FGWrapper
EventCaller.Value = graph.Object ("Pie3D", myURL, "600", "300", "#FFFFFF",
"0")
set graph=nothing
The call to gaph.obkct in this case will create the flash call for the Pie3D
char, using MyURL as the data URL, Width 600, Height 300, White background.
SOBreakdownData.asp looks at the passd parmeters and, using classes,
generates the XML for the charts.
"DJJWP" <DJJWP@forum.codecharge> wrote in message
news:645facac799549@news.codecharge.com...
> Do you use this as a include page? No matter what I do I end up with the
> chart
> at the top of the page and anything else gets pushed down.
> _________________
> Network Operations Rule
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
jerrym
Posts: 52
|
| Posted: 05/09/2007, 2:23 AM |
|
Benjamin
i was wondering if you could provide a step by step procedure on how you integrated funsion charts within CCS (ASP). i am not a programmer and am lost with your post and unable to follow it.
many thanks for your help in advance.
regards
jerry
|
|
|
|
jerrym
Posts: 52
|
| Posted: 05/09/2007, 3:43 PM |
|
Hi djjwp
your solution would be much appreciated but if you could give it to me step by step as i'm no programmer. thanks very much, i await your post and reply.
regards
jerry
|
|
|
|
DJJWP
Posts: 77
|
| Posted: 05/17/2007, 7:35 PM |
|
Give this a try:
http://www.fusioncharts.com/forum/Topic469-30-2.aspx
_________________
Network Operations Rule |
|
|
|
terencef
Posts: 7
|
| Posted: 08/22/2007, 11:53 AM |
|
Hi; I used the code listed in djjwp's post thanks... and got it to work with XML data, but the dataURL does not seems to work...
My Chart.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="GENERATOR" content="CodeCharge Studio 3.2.0.2">
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
<title>eDashboard</title>
<link rel="stylesheet" type="text/css" href="Styles/ACSezOrder/Style_doctype.css">
<!--[if IE 6]><link rel="stylesheet" type="text/css" href="Styles/ACSezOrder/Style_ie6.css"><![endif]-->
<script language="Javascript" src="FusionCharts.js"></script>
</head>
<body>
</body>
</html>
Chart.asp code
============
<!-- #INCLUDE VIRTUAL="FusionCharts.asp" -->
...
...
'Fusion Chart Code
'Variable to contain dataURL
Dim strDataURL
'Set DataURL with animation property to 1
'NOTE: It's necessary to encode the dataURL if you've added parameters to it
'strDataURL = encodeDataURL("ChartsData.asp?animate=1")
strDataURL = "ChartData.asp"
'Create the chart - Pie 3D Chart with dataURL as strDataURL
Call renderChart("Column3D.swf", strDataURL, "", "stats", 600, 400, false, false)
and my ChartData.asp
==================
<%
dim statsdim rs
dim sqldim cn
dim field1 'Hold data returned
dim field2 'Hold name
dim strXML 'strXML will be used to store the entire XML document generated
'Default.asp has passed us a property animate. We request that.
Dim animateChart
animateChart = Request.QueryString("animate")
'Set default value of 1
if animateChart="" then
animateChart = "1"
end if
'Make db conx
cn = "dns..."
set rs = server.createobject("adodb.recordset")
'Create your SQL here, this was mine
sql = "SELECT NBR_OPEN_INCIDENTS FROM DASHBOARD_VIEW"
'Start XML data
strXML = "<chart caption=' Current OMS Status' subCaption='Dashboard' pieSliceDepth='30' showBorder='0' formatNumberScale='0' numberSuffix=' Tickets' animation='0'>"
'Open db and grab records
rs.open sql, cn
do while not rs.eof
'Write the data line str
XML = strXML & "<set label='Open Incidents' value='20'/>"
'Go to next record
rs.movenext
loop
'Finally, close <chart> element
strXML = strXML & "</chart>"
'Close loop and conx
rs.closeSet
rs = nothing
'Set Proper output content-type
Response.ContentType = "text/xml"
'Just write out the XML data
'NOTE THAT THIS PAGE DOESN'T CONTAIN ANY HTML TAG, WHATSOEVER
Response.Write(strXML)
%>
the result can be seen at
http://open.acsatlanta.com/OMS/chart.asp
Would appreicate a fresh set of eyes...
Thanks
|
|
|
|
|
