aman0711

Hi Experts, I just got the V3.1 version and Want my charts to have save as image and save as pdf functionality. In your last version, I used to have your FusionChartsSave.jsp then two tags in the Chart tag(imageSaveURL and imageSave), which always did the trick. I tried using the same on my code this time and once the the data capturing part got to 100%, a white blank page was returned.. am I missing something? I saw some posts regarding this functionality in 3.1 which I already have. Can you please describe in detail how to use it in my application. I didnt get this peace of code below: FusionCharts Export Handler Component I never saw this line before either. var myExportComponent = new FusionChartsExportObject("fcExporter1", "../../FusionCharts/FCExporter.swf"); I am using the createChart method to render the chart. I would highly appreciate if you can tell me the instructions to implement these feature from grass root level. BELOW is the code we are using to generate our charts currently: <% Connection conn = null; Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@","user","pass"); %> <%-- Fusion Chart XML creation using dataXML method --%> <% String strXml=""; String strQuery1="", strQuery2="", strQuery3="", strQuery4="", cat="", dataset1="", dataset2="", dataset3="", dataset4=""; strXml=""; try{ Statement st1, st2, st3, st4; ResultSet rs1, rs2, rs3, rs4; strQuery1= "Select * from VSLAND.APM_WEB_12MONTH_APPGRP_V WHERE APP_GROUP='EBILL' ORDER BY DECODE(UPPER(MONTH), 'JAN', 7, 'FEB', 8, 'MAR', 9, 'APR', 10, 'MAY', 11, 'JUN', 12, 'JUL', 1, 'AUG', 2, 'SEP', 3, 'OCT', 4, 'NOV', 5, 'DEC', 6)"; strQuery2= "Select * from VSLAND.APM_WEB_12MONTH_APPGRP_V WHERE APP_GROUP='EDD' ORDER BY DECODE(UPPER(MONTH), 'JAN', 7, 'FEB', 8, 'MAR', 9, 'APR', 10, 'MAY', 11, 'JUN', 12, 'JUL', 1, 'AUG', 2, 'SEP', 3, 'OCT', 4, 'NOV', 5, 'DEC', 6)"; strQuery3= "Select * from VSLAND.APM_WEB_12MONTH_APPGRP_V WHERE APP_GROUP='KANAC' ORDER BY DECODE(UPPER(MONTH), 'JAN', 7, 'FEB', 8, 'MAR', 9, 'APR', 10, 'MAY', 11, 'JUN', 12, 'JUL', 1, 'AUG', 2, 'SEP', 3, 'OCT', 4, 'NOV', 5, 'DEC', 6)"; strQuery4= "Select * from VSLAND.APM_WEB_12MONTH_APPGRP_V WHERE APP_GROUP='QuickPay' ORDER BY DECODE(UPPER(MONTH), 'JAN', 7, 'FEB', 8, 'MAR', 9, 'APR', 10, 'MAY', 11, 'JUN', 12, 'JUL', 1, 'AUG', 2, 'SEP', 3, 'OCT', 4, 'NOV', 5, 'DEC', 6)"; st1=conn.createStatement(); rs1=st1.executeQuery(strQuery1); while(rs1.next()){ cat += ""; dataset1 +=""; } rs1.close(); st1.close(); st2=conn.createStatement(); rs2=st2.executeQuery(strQuery2); while(rs2.next()){ // cat += "" ; dataset2 +=""; } rs2.close(); st2.close(); st3=conn.createStatement(); rs3=st3.executeQuery(strQuery3); while(rs3.next()){ // cat += "" ; dataset3 +=""; } rs3.close(); st3.close(); st4=conn.createStatement(); rs4=st4.executeQuery(strQuery4); while(rs4.next()){ // cat += "" ; dataset4 +=""; } rs4.close(); st4.close(); }catch (Exception e){} strXml += " "+cat+""; strXml += " "+dataset1+" "; strXml += " "+dataset2+" "; strXml += " "+dataset3+" "; strXml += " "+dataset4+" "; strXml += ""; out.print(strXml); String chartCode=createChart("../FusionCharts/MSLine.swf", "", strXml, "SLA", 745, 300, false, false); %> <% conn.close(); %> <%=chartCode%> Please tell me the reason why currently I am only using a white screen after the data capture process is done.

Hi Experts, I want to use a solid color for the bars in Column 2D chart instead of the default color palettes (color fading towards the bottom). is it possible to do so? another question, Can I get rid of vertical and horizontal division lines in the background of chart?

Hi Experts, Can someone please help me out with getting the save as image and pdg thing to work in my application. After the data capture mode, I am only seeing a blank FCExporter.jsp. Check everypath and settings multiple times.

Thanks Srividya and thanks Rajroop problem fixed

Hi Srividya, Will these new jars fix my problem? :crying:

Thanks Rajroop :satisfied:

Hi Srividya, I emailed you the required files.

Hi folks, I was wondering if there is any way we could show a threshold value (something like value to achieve) in Column 2D chart. I know one way to do it is with Trendlines. I am displaying monthly data with x-axis depicting the months. Different months have different goals(value to achieve) and a single trendline wont help in this case. Is there any chart that could help me out?

Thanks Rajroop

Srividya, I am facing the exact same issue Ravi is facing

Hi Experts, We recently upgraded to version 3.1. and after some hard attempts, we finally made the saving capability to be working for our charts. But All the options, Save as pdf, Save as JPEG, Save as PNG, only work with Firefox, When I try to save the same in IE, after the data capturing step, all I can see is a Blank FCExporter.jsp. Your help is highly appreciated.

Hi Srividya, I only get a blank console when I try to save a chart. Though for the two pages which are under webapp root, I get the following console output on saving the image: Using EntityManagerFactory 'entityManagerFactory' for OpenEntityManagerInViewFilter Returning cached instance of singleton bean 'entityManagerFactory' Opening JPA EntityManager in OpenEntityManagerInViewFilter Jul 17, 2009 10:13:44 AM com.fusioncharts.exporter.generators.ImageGenerator getChartImage INFO: Creating the Chart image Jul 17, 2009 10:13:45 AM com.fusioncharts.exporter.generators.ImageGenerator getChartImage INFO: Image created successfully

Hey Rajroop, I really appreciate your help bro. Please do let me know if you find something else to try.. I really need a fix @ Srividya, Address is coming up as localhost:8080/analytics/FCExporter.jsp I havent touched the structure of webapp you sent me.

Hi Rajroop, So now I am on Flash 10 .. and still the same result on IE: after data capturing, I see a blank FCExporter.jsp on FF: after data capturing, I see FCExporter.jsp with all its code

Hi Rajroop I dont think upgrading would make any difference. Because I can see charts on my website, just that save functionality isnt working @ Srividya, i made a new folder in the root called saved. and in the properties file, i changed /images to /saved

Hi Srividya, I did check the folder. Nothing is being saved.. moreover after this change... even the FF save stopped working(I did change the option in the XML)

@ Sudipto, I guess I have all the plugins. Srividya has helped me a lot in past few days, and only with her help I got where I am right now but today, after trying to save it on the server, even the regular save on fireFox stopped working

Hi Srividya, Now it doesnt een work on FireFox... i have no clue.. what is going on After Data Capture, I am getting FCexporter.jsp (the complete code of FCexporter.jsp in the browser body)

Thanks for the help folks... I will try it real quick and get back to you with results. would saving image on the server make any difference? Because Firefox is already working fine. My IE versions are IE6, and IE7

Hi Srividya, I cant attach any other file now, because its complaining about the attachment size exceeded. Can I have your email address so that I can forward you the webapp folder. You can email me at [email protected] and I can reply back to that :-) if thats not an issue.

I already uploaded the webapp in one of my post, Strange I cant see my own post now.

Hey Srividya, Sorry for bugging you so much... its so frustrating, I am so close yet so far Did the change you mentioned, and still the same blank output. Below is my resources file: I tried it with localhost and "." #This constant defines the name of the export handler jsp file - DO NOT MODIFY THIS!!! EXPORTHANDLER=FCExporter_ #Path where the export handler files are located #Please note that the resource path should be relative to #FCExporter.jsp file's directory #By default the path is "Resources/" RESOURCEPATH=./analytics/static/Fusion/FusionCharts/Resources/ #Please specify the path to a folder with write permissions relative to web application root #The exported image/PDF files would be saved here. SAVEPATH=./images/ #This constant HTTP_URI stores the HTTP reference to #the folder where exported charts will be saved. #Please enter the HTTP representation of that folder #in this constant e.g., http://www.yourdomain.com/images/ HTTP_URI=http://www.yourdomain.com/images/ #OVERWRITEFILE sets whether the export handler would overwrite an existing file #the newly created exported file. If it is set to false the export handler would #not overwrite. In this case if INTELLIGENTFILENAMING is set to true the handler #would add a suffix to the new file name. The suffix is a randomly generated UUID. #Additionally, you can add a timestamp or random number as additional prefix. OVERWRITEFILE=false INTELLIGENTFILENAMING=true FILESUFFIXFORMAT=TIMESTAMP

So I changed the RESOURCEPATH of my properties file to: RESOURCEPATH=/analytics/static/Fusion/FusionCharts/Resources/ but still the same result

I hope this properties file will fix the Issue Srividya and Yes I ahvent edited anything in the properties file. Could you please edit it for me? I am quite a novice with it. properties.txt

Forgot to attach snapshot