Re: charting solution for using with CF
Hi there I'm trying to find a good charting tool to use with CF and also with a MSSQL database to produce graphs and also dashboard style reports/graphs. Wondering what tools software people have used for doing this. Look forward to seeing replies. Many thanks Toby You may also try FusionCharts. It can easily be integrated with ColdFusion. The online documentation of FusionCharts has a separate section on how to use it with ColdFusion. You can get more information at: http://www.fusioncharts.com/ To read the documentation, visit: http://www.fusioncharts.com/Docs/index.html and then drill down to Guide for Web Developers Using with ColdFusion. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: charting solution for using with CF
I got curious about whether you could output those gauge charts...and this code works, but it outputs the Developer Edition watermark on the output...even though the server is a licensed version of CF7 (the data and style were just straight from the example one in the webcharts builder) cfobject type=JAVA action=Create name=svr class=com.gp.api.jsp.MxServerComponent cfscript svr.getDefaultInstance(getPageContext().getServletContext()); myChart = svr.newImageSpec(); myChart.width = 400 ; myChart.height= 300 ; myChart.type = PNG ; myChart.style = dialChart dial=Dial240 inside=##C5 hand=##B699CCFF axis scaleMin=0/ dataLabels style=Value font=Arial-24/ legend equalCols=false/ elements drawShadow=true series index=0 paint color=##CCFF99/ /series series index=1 paint color=##FFCC99/ /series series index=2 paint color=##FF99CC/ /series /elements table cellSpacing=4 cellPadding=0/ paint palette=Pastel min=18/ /dialChart ; myChart.model = ?xml version=1.0 encoding=UTF-8?\nXML type=default\nCOLLow/COL\nCOLAverage/COL\nCOLHigh/COL\nROW col0=120.0 col1=220.0 col2=0.0Sample 0:/ROW\nROW col0=150.0 col1=300.0 col2=250.0Sample 1:/ROW\nROW col0=200.0 col1=400.0 col2=400.0Sample 2:/ROW\n/XML; svr.saveBytesTo(myChart,#GetDirectoryFromPath(GetBaseTemplatePath())#testimage.png); /cfscript img src=/testimage.png alt= border=0 ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
A warning for anyone that might want to try the code I sent earlier. I noticed after sending it that all charts produced with cfchart on that server now had the Developer Edition watermark. Restarting CF clears it up, but as soon as I run the code that connects directly to the webcharts class, it starts again. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
Jim Wright wrote: A warning for anyone that might want to try the code I sent earlier. I noticed after sending it that all charts produced with cfchart on that server now had the Developer Edition watermark. Restarting CF clears it up, but as soon as I run the code that connects directly to the webcharts class, it starts again. you'll need to buy a license from them. a million years ago i used a free version of kavacharts from ve.com to do speedos of air pollution data for thailand's EPA. not sure if they still have a free version but those things were a breeze to work with even though we had to dodge the occasional woolly mammoth back then ;-) ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: charting solution for using with CF
Jim, On 9/6/07, Rob Parkhill [EMAIL PROTECTED] wrote: So how does one leverage the webcharts design app? it is a cool tool which I had no idea existed until yesterday. I played around with it quite a bit and designed a couple of charts (actually the gauges are going to get me in good with the boss :)) I have tried using them as a JSP file etc. but keep getting an error in the display. First, I'm 99% sure the gauge charts don't work in CFMX. CFMX only supports a subset of the graphs you can actually build with Webcharts3D. The easiest way to use the charts is to just use the Style XML to create your own style definition that you use in CFMX. In CFMX's .\charting\styles directory, you'll notice a bunch of XML files. One you create a charting style you like, you can just save a copy of your style XML into this folder and give it a unique name. You'll then be able to specify that style attribute of the cfchart / tag. You could also just pass in the entire XML packet into the style attribute as well if you didn't want to reference a static file. -Dan ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
Warning -- this is going to be a bit of a thread hijacking. But it involves the XML discussed in this thread. And I have asked this question in this and other forums, with no responses. So please excuse my hoping that someone involved in this conversation might help. I have used XML stylesheets for charts and passed them through the style attribute in the cfchart tag. But I now need to create a style specification (one not supported within the other attributes of cfchart) dynamically -- else I'd have to create many, many different stylesheets (think international number formatting). The docs say that an XML string can be passed into the style attribute in place of a file path. But no matter how I produce/parse/handle the XML string, I can't get it to work. I get the equivalent of a file not found error, indicating that a path is always expected. Has anyone been able to successfully pass an XML string to this attribute? I have Googled, searched forum archives, and posted in numerous places, but have found no information. Again, I apologize for jumping into this thread. I'm just getting a little desperate for a solution. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: charting solution for using with CF
Tom, I just copied the XML out of the WebChart3D program (not necessarily what you are looking for, but perhaps good enough?) and I pasted it into the Style attribute of cfchart. After I had replaced all double quotes with single quotes and removed one of the tags that was formatting the labels with a bunch of 's I got it to work. I was only replicating a bar chart. I don't think that I will even be able to use this approach for the gauges that I want to use... maybe I'll have to create a SWF for that, but I digress. I had some 'success' in adding the XML directly to the style attribute. I hope that that helps. Rob On 9/7/07, Tom McNeer [EMAIL PROTECTED] wrote: Warning -- this is going to be a bit of a thread hijacking. But it involves the XML discussed in this thread. And I have asked this question in this and other forums, with no responses. So please excuse my hoping that someone involved in this conversation might help. I have used XML stylesheets for charts and passed them through the style attribute in the cfchart tag. But I now need to create a style specification (one not supported within the other attributes of cfchart) dynamically -- else I'd have to create many, many different stylesheets (think international number formatting). The docs say that an XML string can be passed into the style attribute in place of a file path. But no matter how I produce/parse/handle the XML string, I can't get it to work. I get the equivalent of a file not found error, indicating that a path is always expected. Has anyone been able to successfully pass an XML string to this attribute? I have Googled, searched forum archives, and posted in numerous places, but have found no information. Again, I apologize for jumping into this thread. I'm just getting a little desperate for a solution. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
Hi Rob, I hope that that helps. Well, it certainly gives me a direction -- mainly by your experience with needing to replace and escape certain values. Thanks very much. The errors I mentioned came when doing much the same thing you were trying. The difference is that I saved the XML into a variable, which was then output in the style attribute. This is necessary because of the need to build the XML dynamically. But I'll do some testing, using your suggestions. Meanwhile, if anyone has any other XML experiences that might be relevant, I'm sure we'll all appreciate it. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
CFChart can be effective, especially if you use the webcharts app to create your own styles. Look in your cf directory/charting for the webcharts.bat file, which fires off the webcharts design app. So how does one leverage the webcharts design app? it is a cool tool which I had no idea existed until yesterday. I played around with it quite a bit and designed a couple of charts (actually the gauges are going to get me in good with the boss :)) I have tried using them as a JSP file etc. but keep getting an error in the display. Any assistance would be appreciated. Thanks, Rob ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: charting solution for using with CF
On 9/6/07, Rob Parkhill [EMAIL PROTECTED] wrote: So how does one leverage the webcharts design app? it is a cool tool which I had no idea existed until yesterday. I played around with it quite a bit and designed a couple of charts (actually the gauges are going to get me in good with the boss :)) I have tried using them as a JSP file etc. but keep getting an error in the display. I haven't tried using any of the chart types that aren't directly supported by cfchart, although I don't see why you couldn't find a way to do it. The way I have used it is to access the style attributes that aren't supported by the cfchart tags to fine-tune a charts appearance...refer to this article... http://livedocs.macromedia.com/coldfusion/7/htmldocs/1431.htm ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: charting solution for using with CF
On 9/5/07, Peter Tanswell [EMAIL PROTECTED] wrote: Hi there I'm trying to find a good charting tool to use with CF and also with a MSSQL database to produce graphs and also dashboard style reports/graphs. Wondering what tools software people have used for doing this. CFChart can be effective, especially if you use the webcharts app to create your own styles. Look in your cf directory/charting for the webcharts.bat file, which fires off the webcharts design app. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: charting solution for using with CF
Wow, Thanks Jim I didn't know that was there. Makes life on Mars much easier to bare :-) Bill -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: September 5, 2007 9:00 AM To: CF-Talk Subject: Re: charting solution for using with CF On 9/5/07, Peter Tanswell [EMAIL PROTECTED] wrote: Hi there I'm trying to find a good charting tool to use with CF and also with a MSSQL database to produce graphs and also dashboard style reports/graphs. Wondering what tools software people have used for doing this. CFChart can be effective, especially if you use the webcharts app to create your own styles. Look in your cf directory/charting for the webcharts.bat file, which fires off the webcharts design app. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
