tag:blogger.com,1999:blog-124201859545181164.post2881201027014304295..comments2023-09-05T03:31:26.458-07:00Comments on My Techy Thoughts: Fusion Charts for SharePoint ListSridhar Babu Kolapallihttp://www.blogger.com/profile/12879032012674034075noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-124201859545181164.post-61042629936727290242012-06-08T05:51:03.684-07:002012-06-08T05:51:03.684-07:00Hi Sridhar,
thanks a lot for sharing this article...Hi Sridhar,<br /><br />thanks a lot for sharing this article. <br />I have finally managed to get the fusion charts working on-line:)<br /><br />If I could have one more question - data for fusion chart is calculated only from the actual view(if I have item limit set at 100items then only these 100 items are shown on the chart. If I change the item limit, the statistics will also change accordingly).<br />Is it possible to change sCmdParameters so that all list content will be a subject of the chart visualisation, no matter what is the default view?<br />Thanks in advance.Witoldnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-26419640459641308292012-05-28T11:49:21.364-07:002012-05-28T11:49:21.364-07:00Hi Sridhar,
Nice Article, appriciate a lot !
I w...Hi Sridhar,<br /><br />Nice Article, appriciate a lot !<br /><br />I was successfully able to generate graphs in IE 7, 8. But the same code is not working in Mozilla. Does this code (object embedding) has any compatiblity issue with Mozilla, as the values are being generated properly, only Graph is not getting displayed.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-57532793079738511762012-02-12T03:37:41.484-08:002012-02-12T03:37:41.484-08:00Hi Sri, who are the other vendors/competitors for ...Hi Sri, who are the other vendors/competitors for Charts for Fusion? For group by options any workaround other than third party tools?Ahmedhttps://www.blogger.com/profile/09559015613316979261noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-27767622118553047072011-11-17T13:45:59.684-08:002011-11-17T13:45:59.684-08:00I have been trying to use the Gantt Chart from Fus...I have been trying to use the Gantt Chart from FusionCharts, but no luck. I tested and tried you Pie chart and was able to get it to work. :-) <br />My question, Do you have a sample code for the Gantt Chart? I can not get it to work...<br />Thank youJbluehttps://www.blogger.com/profile/07000137574534773747noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-65808699035249647022011-04-18T05:47:35.254-07:002011-04-18T05:47:35.254-07:00I can only seem to get one FusionChart to load on ...I can only seem to get one FusionChart to load on the page with IE8 but with firefox they all load fine. <br /><br />Each of the FusionCharts is within a CEWP which is set to Content Link the HTML. <br /><br />Has anyone encountered this and know a fix?<br /><br />SPNewbieAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-27867148468613370142011-04-16T07:11:32.749-07:002011-04-16T07:11:32.749-07:00Hey Sridhar,
This article has been a fantastic he...Hey Sridhar,<br /><br />This article has been a fantastic help but I had wondered how you would make it apply to the other types of FusionCharts such as Column3D. I can only seem to get the Pie2D and Pie3D versions working.SP Newbienoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-88687770419839669472011-02-16T04:57:38.189-08:002011-02-16T04:57:38.189-08:00before the questions
let me say thanks for all yo...before the questions <br />let me say thanks for all your support!<br />with your suggetions i have built a sophisticated dashboard.<br />Unfortunately now I'm trying to see it from an IPAD and it doesn't work becouse it does not understand the ActiveX<br />In particular it doesn't unterstand the string <br /><br />"var objXMLHttp= new ActiveXObject("Microsoft.XMLHTTP"); "<br /><br />do you know lecterature about <br />how to build the xmlobject,or another way to pass dinamic parameters ?<br /><br /><br />best regards <br /><br />VittorioAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-89189542724472854712010-02-03T07:42:04.602-08:002010-02-03T07:42:04.602-08:00After lots of staring and testing, I finally got t...After lots of staring and testing, I finally got this to work! Thank you thank you so much!<br /><br />The main problem I had to work through was realizing that my List's Query <i>Name</i>, "ProjStatus", for this column was different from the <i>DisplayName</i> which was "Status"(I found this by looking at the source code for the list). So I had to rename it in the RPC "Query=ProjStatus&" as well as above the switch where it says "getNamedItem(ows_ProjStatus)". Just make sure you don't change any of the "Status" which are reserved words.<br /><br />also<br /><br />"In Progress" and "Completed" are switched on the parameters list. <br /><br />set name='Completed' value='" + iInProgress + "' <br /><br />set name='In Progress' value='" + iCompleted + "' <br /><br />Hope this helps some of yall.<br /><br />LibbyLibbynoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-37332544163887426632009-11-05T08:42:50.135-08:002009-11-05T08:42:50.135-08:00Hi Vittorio,
May be you are refering to t...Hi Vittorio,<br /> <br /> May be you are refering to the incorrect name from the xml structure.<br /><br />I will recommend first check xml response before parsing the xml for required fields.<br /><br />You can check the response by using an alert statement as:<br /><br />// Request the RPC Call<br />sXML = fnXmlHttp(sSiteUrl + sCmdParameters,"");<br /><br />alert("xml output" + sXML);<br /><br />This alert is just immediately after the xmlhttp response. Now you can check in the xml whether the correct names are referd while parsing the xml.<br /><br />Parsing logic in javascript is already available in the post, please follow that.Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-20821194044900793832009-11-05T03:31:58.456-08:002009-11-05T03:31:58.456-08:00Hi
Sridhar
i'm tryng to visualize a custom ...Hi <br />Sridhar <br /><br />i'm tryng to visualize a custom list with two fields "Dato" and "Valore" <br />I used the code in the blog but when is getting the field values from the xml structure it does not work may be i have to use a spesific name for the field <br /><br />i changed the code with this <br />-----------------------------------<br /><br />//var Dato = objData.childNodes(i).attributes.getNamedItem("Dato").value;' <br />//var Valore = objData.childNodes(i).attributes.getNamedItem"("Valore").value; '<br />"switch(Dato)<br />//{<br />case "roma":'<br />//iRoma = Valore; break;'<br />---------------------------------<br />is it correct ?<br /><br />can you help me ?<br /><br />tanks <br /><br />VittorioAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-91081518343144444112009-10-22T04:41:25.808-07:002009-10-22T04:41:25.808-07:00it comes out of the box from sharepoint.
What eve...it comes out of the box from sharepoint.<br /><br />What ever the site you are access you can just append /_vti_bin/owssvr.dll.<br /><br />Please follow the steps mentioned in the post to extract the data and to show the graphs using fusion charts.Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-69256413254146130382009-10-22T03:35:57.982-07:002009-10-22T03:35:57.982-07:00where can i find owssvr.dll?where can i find owssvr.dll?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-62796132771336392582009-10-22T03:27:55.606-07:002009-10-22T03:27:55.606-07:00i 'm sorry but i'm a beginner
can you sho...i 'm sorry but i'm a beginner <br />can you show me an example ?<br />i have to take data from a list that i have made previusly <br />and <br />what about the line <br />var = "http://localhost/sites/MOSSDemos/_vti_bin/owssvr.dll?"<br /><br />vittorioAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-34936059341326016672009-10-22T03:23:23.588-07:002009-10-22T03:23:23.588-07:00It works for both WSS 3.0 and MOSS. I implemented ...It works for both WSS 3.0 and MOSS. I implemented the same solution on both WSS and MOSS.Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-69063476120920326132009-10-22T01:00:29.514-07:002009-10-22T01:00:29.514-07:00hi ,
i don't have MOSS
How can i use it on wss...hi ,<br />i don't have MOSS<br />How can i use it on wss<br /><br />tanks <br />VittorioAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-21984116645227778902009-10-19T11:27:05.146-07:002009-10-19T11:27:05.146-07:00Another post about fusioncharts within sharepoint:...Another post about fusioncharts within sharepoint: http://translate.google.com/translate?client=tmpg&hl=es&u=http%3A%2F%2Fsurpoint.blogspot.com%2F2009%2F07%2Fgraficos-dinamicos-en-sharepoint.html&langpair=es|enAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-5126212184582868802009-07-27T20:52:11.599-07:002009-07-27T20:52:11.599-07:00Hi,
I observed that in the blog sObjectData is ...Hi,<br /> I observed that in the blog sObjectData is not displaying the content. Since it has html tags (object tag) it is not displaying the actual content. I modified the post accordingly by replacing the "<" with "<". <br /><br />Sorry for the inconvenience caused.Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-47390149030796272962009-07-27T11:57:24.217-07:002009-07-27T11:57:24.217-07:00The sObjectData value got truncated... here is the...The sObjectData value got truncated... here is the rest of the string.<br /><br />/Charts/FCF_Pie3D.swfUnknownhttps://www.blogger.com/profile/01670339294032259897noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-14862722134234332752009-07-27T11:55:43.510-07:002009-07-27T11:55:43.510-07:00Hi Sridhar,
Thanks for the update. Still can'...Hi Sridhar,<br /><br />Thanks for the update. Still can't get this to work. Do you see anything in the code that could be the problem? The URL is generating XML. Any help would be appreciated.<br /><br /><br />My complete Script:<br /><br />function fnXmlHttp(AspFileName,strXML) <br />{ <br />var objXMLHttp= new ActiveXObject("Microsoft.XMLHTTP"); <br />var sResponse; <br />try <br />{ <br />objXMLHttp.open("POST",AspFileName,false) //POSTING THE DATA <br />objXMLHttp.setRequestHeader("Content-Type", "text/xml"); <br />objXMLHttp.send(strXML) <br />} <br />catch(e) <br />{ <br />} <br />if (parseInt(objXMLHttp.Status) != 200) <br />{ <br />sResponse = "N,Cannot connect to the Server."; <br />} <br />else <br />{ <br />sResponse=new String(objXMLHttp.responseText); <br />if (sResponse == "") <br />{ <br />sResponse = "N,Error at server. Please contact administrator."; <br />} <br />} <br />return sResponse; <br /><br />} <br /><br /><br />var sXML; <br />var bLoad; <br /><br />var sSiteUrl = "http://itbu.broadcom.com/erp/90Upgrade/_vti_bin/owssvr.dll?"; <br /><br />// This Parameter Contains List Id too <br />var sCmdParameters = "Cmd=Display&Query=Status&List=%7B1303AC29%2D3783%2D487C%2D869F%2D310798CFA00C%7D&XMLDATA=TRUE" <br /><br />// Request the RPC Call <br />sXML = fnXmlHttp(sSiteUrl + sCmdParameters,""); <br /><br />// Create the XML Object Instance <br />var objXML = new ActiveXObject("MSXML2.DOMDocument"); <br /><br />// Load the XML <br />bLoad = objXML.loadXML(sXML); <br /><br />// Check whether the XML is loaded into the document <br />if(bLoad) <br />{ <br />// Declare all local variables <br />var iNotStarted = 0; <br />var iInProgress = 0; <br />var iCompleted = 0; <br />var iDeferred = 0; <br />var iWaitingonsomeoneelse = 0; <br />var sObjectData; <br /><br />var objData = objXML.documentElement.childNodes(1); <br /><br />// Loop through all the variables <br />for (i=0;i { <br />var Status = objData.childNodes(i).attributes.getNamedItem("ows_Status").value; <br /><br />switch(Status) <br />{ <br />case "Not Started": <br />iNotStarted = iNotStarted + 1; break; <br />case "In Progress": <br />iInProgress = iInProgress + 1; break; <br />case "Completed": <br />iCompleted = iCompleted + 1; break; <br />case "Deferred": <br />iDeferred = iDeferred + 1; break; <br />case "Waiting on someone else": <br />iWaitingonsomeoneelse = iWaitingonsomeoneelse + 1; break; <br />default: <br />break; <br />} <br /><br />} <br /><br />// Create the Object for the Fusion Chart <br />// Opening Object Tag <br />sObjectData = "http://itbu.broadcom.com/erp/90Upgrade/FusionCharts/Charts/FCF_Pie3D.swf"; <br />document.write(sObjectData); <br />}Unknownhttps://www.blogger.com/profile/01670339294032259897noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-65780486345209441792009-07-27T11:53:48.518-07:002009-07-27T11:53:48.518-07:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/01670339294032259897noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-84269833119910014272009-07-23T21:34:30.002-07:002009-07-23T21:34:30.002-07:00Hi,
Thanks for your comment!!!
One thing I ...Hi,<br /> Thanks for your comment!!!<br /><br /> One thing I am able to identify in the sCmdParameters is that "=" sign is missing immediately after "List" keyword.<br /><br />Following is the modified sCmdParameters:<br /><br />var sCmdParameters = "Cmd=Display&Query=Status&List=%7B1303AC29%2D3783%2D487C%2D869F%2D310798CFA00C%7D&XMLDATA=TRUE"<br /><br />and also make sure that the following url in the browser should return an xml:<br /><br />http://itbu.broadcom.com/erp/90Upgrade/_vti_bin/owssvr.dll?Cmd=Display&Query=Status&List=%7B1303AC29%2D3783%2D487C%2D869F%2D310798CFA00C%7D&XMLDATA=TRUESridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-48082383734031880632009-07-23T11:14:03.345-07:002009-07-23T11:14:03.345-07:00Hey Sridhar,
Cool application of graphical represe...Hey Sridhar,<br />Cool application of graphical representation. however I can't get it to work. here are my parameters:<br />var sSiteUrl = "http://itbu.broadcom.com/erp/90Upgrade/_vti_bin/owssvr.dll?"; <br /><br />// This Parameter Contains List Id too <br />var sCmdParameters = "Cmd=Display&Query=Status&List%7B1303AC29%2D3783%2D487C%2D869F%2D310798CFA00C%7D&XMLDATA=TRUE"<br />// Opening Object Tag <br />sObjectData = http://itbu.broadcom.com/erp/90Upgrade/FusionCharts/Charts/FCF_Pie3D.swf"; <br /><br />Do you see anything wrong? Do you just upload the .swf files? when I put the concatenated URL in the browser it gives me an error. I'd love to use this.Unknownhttps://www.blogger.com/profile/01670339294032259897noreply@blogger.com