SteveC

Hi, I am using v3.2.1 of Fusion Charts with classic Windows ASP and Javascript code. I've looked up the similar topics that address how to remove the plotGradientColor = ' ' and found the entry that states we can't use the SetChartParams() function with that setting. I've been struggling to figure out an easy way to set this setting without success. I've tried using the GetXML() function to get the entire XML for the chart and then substitute the plotGradientColor setting and use the setDataXML() function to try and apply the change but haven't been successful with that approach yet either. Is there any plans to add support for this setting to the SetChartParams() function? That would make it so easy to apply. I'm seeing behavior for the basic Bar2D charts where the plot gradients appear to be off as the EBIT_Good.jpg chart shows. However, when we use a different chart, we see the graph that appears in the EBIT_Bad.jpg where the bottom portion of the plots are black and gradually turning blue. When I enable the plotGradientColor but leave no color set, it defaults to the white bottom. Do the single-series charts not automatically do plot gradients? Do all the charts have the same default plotGradientColor? Sorry if this rambles a bit, but I'm just trying to figure out which charts 'default' plot gradients deviate from the documented '#ffffff' color and appears to go from black to blue and which one's don't. Thanks for any and all suggestions. Steve

Can anyone point out to me what is wrong with the XML listed below for rendering an MSCombi2D chart? When I try to export the chart using the Server-side Image Saver DLL on our server, no chart is rendered but it displays 'Invalid XML format'. I've eyeballed the XML as well as put it into the Visual Studio 2005 XML file format and I haven't been able to see what is wrong with the XML. I'm using the following command where 'theXML' contains the XML listed below. Dim ssh As ServerSideImageHandler = New ServerSideImageHandler("MSCombi2D.swf, 720, 400, theXML, "", sExportFilename.ToString()) ssh.BeginCapture() Thanks again for your help. Steve Here's the XML being generated: <chart caption='Productivity %' adjustDiv='0' plotGradientColor='' animation='0' canvasBorderThickness='1' showBorder='0' outCnvBaseFont='Arial' outCnvBaseFontSize='12' outCnvbaseFontColor='000000' bgColor='ffffff' bgAlpha='100' YAxisName='% Productivity' yAxisMinValue='0' yAxisMaxValue='2' numDivLines='4' showLegend='1' legendBgColor='ffffff' legendBgAlpha='100' legendIconScale='1' legendInteractive='1' decimals='0' borderSize='0' labelDisplay='Rotate' slantLabels='1' exportEnabled='1' exportAction='save' exportAtClient='0' use3DLighting='0'> <Categories> <Category Label='2010' /> <Category Label='YTD-AVG' /> <Category Label='Jan-11' /> <Category Label='Feb-11' /> <Category Label='Mar-11' /> <Category Label='Apr-11' /> <Category Label='May-11' /> <Category Label='Jun-11' /> <Category Label='Jul-11' /> <Category Label='Aug-11' /> <Category Label='Sep-11' /> <Category Label='Oct-11' /> <Category Label='Nov-11' /> <Category Label='Dec-11' /> </Categories> <dataset seriesName='Actual' showValues='1' color='0a3c91' includeInLegend='1' renderAs='Column' parentYAxis='P' valuePosition='auto'> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> </dataset> <dataset seriesName='Plan' showValues='0' color='ff0000' includeInLegend='1' renderAs='Line' parentYAxis='P' valuePosition='auto'> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> <set value='' /> </dataset> <styles> <definition> <style name='MyTitleFont' type='font' font='Arial' size='12' align='center' color='000000' /> <style name='MyXAxisFont' type='font' font='Arial' size='12' /> <style name='MyYAxisFont' type='font' font='Arial' size='10' color='000000' bold='1' /> </definition> <application> <apply toObject='CAPTION' styles='MyTitleFont' /> <apply toObject='SUBCAPTION' styles='MyTitleFont' /> <apply toObject='XAxisName' styles='MyXAxisFont' /> <apply toObject='PAxisName' styles='MyYAxisFont' /> </application> </styles> </chart>

Thank you everyone for your help. The updated FusionChartsImageSaver did indeed include the fix for the encoding problem. I am now exporting the 700+ charts with the proper encoding and getting the correct '>', '<', '%' characters as expected. Happy charting everyone! Steve

Hi Sanjukta, I have tried the encoding of "%26" but no translation occurs. It just prints out the literal text '%26' and not the '&' character. Thanks, I'll try sending email to support requesting the updated Saver Assembly. Regards, Steve

Hi Sanjukta, Just a quick question. When you ran the XML from my previous post, did you use the FusionChartsImageSaver .NET wrapper or did you use the usual FusionCharts DLLs? The reason I ask is because I am getting the chart to display correctly as well when I go through the FusionCharts DLL. It's only when I try to create the chart via the FusionChartsImageSaver .NET wrapper that it comes back with the 'Invalid xml format' error. Thanks for the clarification. Steve

Hi Pete, I'm not sure if you've obtained a complete answer to this post or not. I was able to get FusionChart's assistance with their ServerSaveImage .NET DLL wrappers. Their .NET files allowed me to write a .NET console application that runs twice a day and exports over 700+ charts each time without user intervention once the Scheduled Task has been created to run the console application. This is working very well for us. I had to create the console application to construct the Chart XML settings dynamically for each of our charts but it is only taking about 30 minutes to "generate" 700+ charts on our server which are then consumed by another application that includes the chart .png files into a Powerpoint slide document and then saved to either a Powerpoint presentation or a PDF document. If you search the FusionChart's websites for "ServerSaveImage" there is a link identifying how to obtain a copy of their .NET DLL wrappers. Hope this helps. Steve

I've tried modifying the XML of the Chart to use the isHTML='1' setting within the Styles for CAPTION and DATALABELS still to no avail. I'm still getting the 'Invalid XML Format'. I compared the resulting XML for the chart against the examples within the documentation and it looks alike to me. I've attached the XML for the Chart for your expert insight :^). Any suggestions would be much appreciated. Thanks, Steve FusionChartSample.txt

Do you have any update on this issue yet? Was the attached XML correct? Thanks, Steve

We're using v3.2.1 and these files: FusionCharts.js 10/6/2010 11:14am FusionChartsExportComponent.js 9/15/2010 9:02am highcharts.js 10/6/2010 8:59am FCExporter.swf 9/15/2010 2:08am ShockwaveFlashObjects.dll 6/3/2011 12:44pm AxShockwaveFlashObjects.dll 6/3/2011 12:44pm FusionChartsImageSaver.dll 6/3/2011 1:15pm FusionChartsImageSaver.xml 6/3/2011 1:15pm Fusion Charts version: Info: Chart loaded and initialized. Initial Width: 1162 Initial Height: 741 Scale Mode: noScale Debug Mode: Yes Application Message Language: EN Version: 3.2.1 Chart Type: Stacked 2D Column Line Chart

I'm using the .NET server-side save image utility so I'm not sure which approach it is using. I'm guessing is the DataXML(). So I'm constructing the XML as a string into 'theXML' variable and then issuing the following function call: ServerSideImageHandler(sChart.ToString(), 720, 400, theXML, "", sExportFilename.ToString()) I've tried encoding the characters and wrapping the XML values in single-quotes and double-quotes but to no affect. If you could take the attached XML and point out to me what is wrong in this instance, I'd appreciate it. The 4th dataset should have a dataset name of '> 90'. XMLFile1.xml

I have managed to get the chart to export now whereas before it wasn't. Now the problem I'm working on is to properly encode the special XML characters '<', '>', '%', single-quote, double-quote, and the '&' symbol when they are part of the axis labels or other parts of text attributes. These are resulting in the 'Invalid XML Format' error. I've tried substituting the '%25' for the '%' but it is just treating that as a string literal and not translating it into '%' when rendered. I've also tried the '%' string but that didn't seem to work either. Thanks, Steve

Forgot to mention for the last XML that the chart being used is the StackedColumn2DLine.swf. I realized that the XML below includes the <lineset> tag which isn't part of that chart's XML. So I'm switching that over to the <dataset> tags.

Hi Radis, Thanks for the response. I discovered that the problem is the '%' in the chart name. I've escaped that out and that part is working properly, but now I'm encountering what seems to be a similar problem with another 'special char' in the XML below which I haven't been able to locate the offending char. Is there some rule as to when to use the double-quotes around attributes versus single-quotes? Does it matter if one is used over the other as long as they are all consistent? <chart caption="Aged WIP" adjustDiv="0" plotGradientColor="" animation="0" canvasBorderThickness="1" showBorder="0" outCnvBaseFont="Arial" outCnvBaseFontSize="12" outCnvbaseFontColor="000000" bgColor="ffffff" bgAlpha="100" YAxisName="$ in Millions" yAxisMinValue="0" yAxisMaxValue="1" numDivLines="6" showLegend="1" legendBgColor="ffffff" legendBgAlpha="100" legendIconScale="1" legendInteractive="1" decimals="2" borderSize="0" labelDisplay="Rotate" slantLabels="1" exportEnabled="1" exportAction="save" exportAtClient="0" use3DLighting="0"><categories><category label="2010" /><category label="YTD" /><category label="Jan-11" /><category label="Feb-11" /><category label="Mar-11" /><category label="Apr-11" /><category label="May-11" /><category label="Jun-11" /><category label="Jul-11" /><category label="Aug-11" /><category label="Sep-11" /><category label="Oct-11" /><category label="Nov-11" /><category label="Dec-11" /></categories><dataset><dataset seriesName="0-30 Days" showValues="0" color="0a3c91" includeInLegend="1" renderAs="Column" parentYAxis="P" valuePosition="auto"><set value="5.276526" /> <set value="" /> <set value="0.282" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> </dataset><dataset seriesName="31-60 Days" showValues="0" color="7f7f7f" includeInLegend="1" renderAs="Column" parentYAxis="P" valuePosition="auto"><set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> </dataset><dataset seriesName="61-90 Days" showValues="0" color="ffff00" includeInLegend="1" renderAs="Column" parentYAxis="P" valuePosition="auto"><set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> </dataset><dataset seriesName=">90 Days" showValues="0" color="008800" includeInLegend="1" renderAs="Column" parentYAxis="P" valuePosition="auto"><set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> </dataset></dataset><lineset seriesName="Plan" showValues="0" color="ff0000" includeInLegend="1" parentYAxis="P" valuePosition="auto"><set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> <set value="" /> </lineset><styles><definition><style name="MyTitleFont" type="font" font="Arial" size="12" align="center" color="000000" /><style name="MyXAxisFont" type="font" font="Arial" size="12" /><style name="MyYAxisFont" type="font" font="Arial" size="10" color="000000" bold="1" /></definition><application><apply toObject="CAPTION" styles="MyTitleFont" /><apply toObject="SUBCAPTION" styles="MyTitleFont" /><apply toObject="XAxisName" styles="MyXAxisFont" /><apply toObject="PAxisName" styles="MyYAxisFont" /></application></styles></chart>

And just in case an image of what I'm seeing helps, I've attached a copy of the problem.

I forgot to mention that this is running on a Windows Server 2008 R2 server with FlashPlayer 11 Beta 2 for 64-bit.

Have you tried creating a Virtual directory within IIS for where the exportHandler is located and using that path in the exportHandler setting? You might also want to make sure the correct permissions are granted on the directory for the ExportHandler to IIS's built-in users. That's my 2-cents' worth :^) Steve

Thanks for the confirmation. We updated our server with the 64-bit Beta Flash Player and we're now rendering the charts successfully. Steve

This may be a silly question, but I have to ask. When you say the assembly is not 64-bit compatable, does that mean I can't deploy it to a 64-bit operating system (Windows 2008 R2) even though my .NET application was built for the X86 platform and deployed such that it runs in Windows XP compatibility mode? Thanks. Steve

Hi all, I'm having trouble getting a StackedColumn2DLine.swf chart to render a dataset as 'Area'. The chart keeps rendering the dataset as a column even though the renderAs explicitly states 'Area'. I'm hoping someone can point out to me what I'm doing wrong. Thanks very much. Here is the XML for the Chart. <chart caption='TESTING' subcaption='STACK CHART' showBorder='0' outCnvBaseFont='Arial' outCnvBaseFontSize='12' outCnvbaseFontColor='cc10ff' bgColor='4eff1c,4b00ef' bgAlpha='50,50' bgRatio='60,40' bgAngle='90' PYAxisName='# Inventory Turns' yAxisMinValue='0' yAxisMaxValue='100' numDivLines='4' SYAxisName='# COPQ' SYAxisMinValue='0' SYAxisMaxValue='80000' baseFontColor='288000' baseFont='Arial' baseFontsize='12' showLegend='1' legendBgAlpha='10' legendIconScale='1' legendInteractive='0' decimals='2' borderSize='0' PAxisName='# Inventory Turns' showValues='0' labelDisplay='Rotate' slantLabels='1' animation='0' canvasBorderThickness='1' use3DLighting='0' plotGradientColor='' > <categories > <category label='2008' /> <category label='2009' /> <category label='YTD-AVG' /> <category label='Jan-10' /> <category label='Feb-10' /> <category label='Mar-10' /> <category label='Apr-10' /> <category label='May-10' /> <category label='Jun-10' /> </categories> <dataset seriesName='COPQ' showValues='0' alpha='0 ' color='ff6304' includeInLegend='1' renderAs='Column' parentYAxis='P' valuePosition='auto' > <set value='27800' /> <set value='31800' /> <set value='10850' /> <set value='12230' /> <set value='27750' /> <set value='40880' /> <set value='40800' /> <set value='24800' /> <set value='35000' /> </dataset> <dataset seriesName='Net Inventory' showValues='0' alpha='0 ' color='d1d700' includeInLegend='1' renderAs='Column' parentYAxis='P' valuePosition='auto' > <set value='40800' /> <set value='24800' /> <set value='35000' /> <set value='10800' /> <set value='11800' /> <set value='10850' /> <set value='12230' /> <set value='17750' /> <set value='40880' /> </dataset> <dataset seriesName='EBIT' showValues='0' alpha='0 ' color='ff0856' includeInLegend='1' renderAs='Area' parentYAxis='P' valuePosition='auto' > <set value='27800' /> <set value='31800' /> <set value='10850' /> <set value='12230' /> <set value='27750' /> <set value='40880' /> <set value='40800' /> <set value='24800' /> <set value='35000' /> </dataset> <styles> <definition> <style name='MyTitleFont' type='font' font='Arial' size='12' align='center' color='#cc10ff' /> <style name='MyXAxisFont' type='font' font='Arial' size='12' color='#0b00ab' bold='1' /> <style name='MyYAxisFont' type='font' font='Arial' size='12' color='f76d00' bold='1' /> <style name='MyZAxisFont' type='font' font='Arial' size='12' color='#00e5eb' bold='1' /> </definition> <application> <apply toObject='CAPTION' styles='MyTitleFont' /> <apply toObject='SUBCAPTION' styles='MyTitleFont' /> <apply toObject='XAxisName' styles='MyXAxisFont' /> <apply toObject='YAxisName' styles='MyYAxisFont' /> <apply toObject='SYAxisName' styles='# COPQ' /> </application> </styles> </chart>

Thank you for clearing that up. I suspected as much but thought I should ask for confirmation. Is there somewhere in the documentation which lists which charts support which rendering formats? Thanks, Steve

Hi All, I'm encountering an error with the FusionChartsExportComponent.js script when my ASP code is attempting to call myExportComponent.Render. The error mesage I'm getting is: Line 9 Error: object required I only seem to get this error when my chart is configured to render with the FC.setCurrentRenderer('javascript') and not when I render it using Flash. When I choose to step into the debugger in Visual Studio 2005, the debugger breaks on the bolded text below in the FusionChartsExportComponent.js: getNew:function(a){var b=document.createElement(a),arg;for(var i=1;c<arguments.length;i++){arg=arguments.split('=');b.setAttribute(arg[0],arg[1])}return b},sync:function(a,{for(var c in a){b[c]=a[c]}} and examining the value of 'b' from the document.createElement(a) it shows as 'undefined'. the value for 'a' is the list of component attribute values that were set just prior to making the .Render call. Here is how I have my .asp code is setup for the component: My chart definition is as follows: <chart exportEnabled='1' exportAction='save' exportAtClient='0' exportHandler='FusionCharts/ASP_Net/FCExporter.aspx' .../> and further into the .asp file: <div id="fcexpDiv" align="center" style="display:none;">FusionCharts Export Handler Component</div> In a Script block I have the following: var myExportComponent = new FusionChartsExportObject("fcExporter1", "FusionCharts/FCExporter.swf"); myExportComponent.sourceCharts = ['Chart23', 'Chart24']; myExportComponent.exportAttributes.exportFormat = 'PNG'; myExportComponent.debugMode = true; myExportComponent.componentAttributes.fullMode='1'; myExportComponent.componentAttributes.saveMode='both'; myExportComponent.componentAttributes.showAllowedTypes = '1'; myExportComponent.componentAttributes.width = '350'; myExportComponent.componentAttributes.height = '140'; myExportComponent.componentAttributes.showMessage = '1'; myExportComponent.componentAttributes.message = 'Click on button above to begin export of charts. Then save from here.'; myExportComponent.Render("fcexpDiv"); I'm guessing I missed a step in setting the chart up for export when rendering it in Javascript instead of Flash. If someone can point me in the right direction, I would appreciate the assistance. Thanks, Steve

Hi, I'm trying to use the FusionCharts.setCurrentRenderer('javascript') to render my charts as Javascript instead of Flash but I must be doing something wrong as it still renders using Flash. If someone can point me in the right direction, it would be much appreciated. Thank you very much, Steve Here is the XML I'm using: (FusionCharts v3.2) <script type="text/javascript"><!-- FusionCharts.setCurrentRenderer('javascript'); // --></script> <div id='Chart23Div' > Chart. </div> <script type="text/javascript"> //Instantiate the Chart var chart_Chart23 = new FusionCharts("FusionCharts/MSCombi2D.swf", "Chart23", "720", "400", "0", "1","","noScale","EN"); //Provide entire XML data using dataXML method chart_Chart23.setDataXML("<chart caption='EBIT and EBIT % to Plan' adjustDiv='0' numDivLines='2' exportFileName='Left_Side_Settings_1_-1_2011_6' plotGradientColor='' animation='0' canvasBorderThickness='1' showBorder='0' outCnvBaseFont='Arial' outCnvBaseFontSize='12' outCnvbaseFontColor='ff0000' bgColor='ffffff' bgAlpha='100' YAxisName='Amount ($M)' yAxisMinValue='0' yAxisMaxValue='3' showLegend='0' decimals='2' borderSize='0' labelDisplay='Rotate' slantLabels='1' exportEnabled='1' exportAction='save' exportAtClient='0' exportHandler='FusionCharts/ASP_Net/FCExporter.aspx' use3DLighting='0' ><categories ><category label='2009' /><category label='2010' /><category label='YTD' /><category label='Jan-11' /><category label='Feb-11' /><category label='Mar-11' /><category label='Apr-11' /><category label='May-11' /><category label='Jun-11' /><category label='Jul-11' /><category label='Aug-11' /><category label='Sep-11' /><category label='Oct-11' /><category label='Nov-11' /><category label='Dec-11' /></categories><dataset seriesName='EBIT' showValues='1' color='0a3c91' includeInLegend='1' renderAs='Column' parentYAxis='P' valuePosition='auto' ><set value='0.480229' /><set value='0.916563' /><set value='1.812716' /><set value='1.774' /><set value='1.503382' /><set value='2.854' /><set value='0.896' /><set value='1.322914' /><set value='2.526' /><set value='' /><set value='' /><set value='' /><set value='' /><set value='' /><set value='' /></dataset><dataset seriesName='EBIT Plan' showValues='0' color='ff0000' includeInLegend='1' renderAs='Line' parentYAxis='P' valuePosition='auto' ><set value='' /><set value='' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /><set value='1.129' /></dataset><styles><definition><style name='MyTitleFont' type='font' font='Arial' size='12' align='center' color='ff0000' /><style name='MyXAxisFont' type='font' font='Arial' size='12' /><style name='MyYAxisFont' type='font' font='Arial' size='12' color='ff0000' bold='1' /></definition><application><apply toObject='CAPTION' styles='MyTitleFont' /><apply toObject='SUBCAPTION' styles='MyTitleFont' /><apply toObject='XAxisName' styles='MyXAxisFont' /><apply toObject='PAxisName' styles='MyYAxisFont' /></application></styles></chart>"); // Provide Transparent SWF chart_Chart23.setTransparent(false); //Finally, render the chart. chart_Chart23.render("Chart23Div"); </script>

Thanks for the code sample. I tried using what you specified but received the error 'Object does not support that property or method'. I believe we must be using an older version of FusionCharts for the scripting. When I view the MSLine.swf with ?debugMode=1, it lists the version as v3.2.1. However, when I look at the FusionCharts.js file, it is dated as 08/18/2010 10:45AM and the header portion of the file lists this informaton: /** * FusionCharts: Flash Player detection and Chart embedding. * Version: 1.2.3 (15th September, 2008) - Added fix for % and & characters. Additional fixes to properly handle double quotes and single quotes in setDataXML() function. * Version: 1.2.2 (10th July, 2008) - Added fix for % scaled dimensions, fixes in setDataXML() and setDataURL() functions * Version: 1.2.1 (21st December, 2007) - Added setting up transparent/opaque mode: setTransparent() function * Version: 1.2 (1st November, 2007) - Added FORM fixes for IE * Version: 1.1 (29th June, 2007) - Added Player detection, New conditional fixes for IE * * Morphed from SWFObject (http://blog.deconcept.com/swfobject/) under MIT License: * http://www.opensource.org/licenses/mit-license.php * */ Doing a search for 'setCurrentRenderer' in the fusioncharts.js file results in no matches found. I will try downloading the latest version and see if that makes a difference. (I'm confident it will.) In the meantime, can you confirm that the FusionCharts.js file I listed really is from FusionCharts v1.2.3 ?? Thank you very much, Steve

Ok. I've finally figured out how to do what I need to with the plotGradientColor removal. I'm using the GetXML( ) function to retrieve the XML of the chart after all properties and attributes have been set. Then I substitute the plotGradientColor's value with an empty string and then instead of calling renderChart( ) I use the renderChartFromExtXML( ) function with the XML string. This results in the plotGradientColor being cleared as we need it to be.

Here's some more details that I've noticed in case it helps. The plots keep their solid colors (as we want) (i.e. no gradients) for Single Series charts (except for Area) but the Multi-Series Combi charts result in the plot gradients appearing which I don't want to happen. We are mostly using the Multi-series charts so this is an issue for us. Thanks for any help you can provide. Steve