tag:blogger.com,1999:blog-124201859545181164.post1780628986132832283..comments2023-09-05T03:31:26.458-07:00Comments on My Techy Thoughts: JQuery to Build Fusion Charts for SharePoint ListSridhar Babu Kolapallihttp://www.blogger.com/profile/12879032012674034075noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-124201859545181164.post-44378932077402182212014-10-07T02:55:20.365-07:002014-10-07T02:55:20.365-07:00Thanks for the above article. It help me a lot.I d...Thanks for the above article. It help me a lot.I discussed your article with my friends also. You did a good job but we have no experience regarding JQuery.<br /><br /><a href="http://www.arx.com" rel="nofollow"> digital signature </a>Anonymoushttps://www.blogger.com/profile/05521903245653355590noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-25944494321822901582012-06-10T13:00:37.354-07:002012-06-10T13:00:37.354-07:00Hi Sridhar,
I need to access the list using accou...Hi Sridhar,<br /><br />I need to access the list using account userid and password, how can i send the login credentials from your code ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-62998981995800194122012-06-01T07:59:28.136-07:002012-06-01T07:59:28.136-07:00Figured it out.. I replaced the method "GET&...Figured it out.. I replaced the method "GET" with "POST" and the chart will refresh when the browser is refreshed.<br /><br />// Ajax call using a JavaScript<br />$.ajax({<br />url: sSiteUrl + sCmdParameters,<br />type: "POST",<br />dataType: "xml",<br />data: "",<br />complete: processResult,<br />contentType: "text/xml; charset=\"utf-8\""<br />});<br /><br /><br />MikeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-26481920720217330982012-05-31T13:15:06.493-07:002012-05-31T13:15:06.493-07:00I'm having the same issue as Kenny: "I h...I'm having the same issue as Kenny: "I having issues with the data not updating without me loading the RPC link in another window. Is there a known reason for this?" <br /><br />Thanks,<br /><br />MikeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-49519843628169539612012-01-26T14:35:17.376-08:002012-01-26T14:35:17.376-08:00Hi Sridhar!
Great information!
Can this same tec...Hi Sridhar!<br /><br />Great information!<br /><br />Can this same technique be used to build Column fusion charts?<br /><br />Thanks!Anonymoushttps://www.blogger.com/profile/17335354055441131577noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-60626885475112311392012-01-25T09:19:32.512-08:002012-01-25T09:19:32.512-08:00Great Stuff! Do you have an example of how you ca...Great Stuff! Do you have an example of how you can do this with a "Multi-Series Column 3D"?Charlienoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-89435517417507117362011-07-25T02:21:28.668-07:002011-07-25T02:21:28.668-07:00fadffadfAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-78620984773325437792011-07-25T02:21:03.229-07:002011-07-25T02:21:03.229-07:00vsdfgvsdfgAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-55180950842783271722011-07-25T02:20:45.962-07:002011-07-25T02:20:45.962-07:00trhtyjtrhtyjAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-18366151271681878722010-10-14T08:35:42.403-07:002010-10-14T08:35:42.403-07:00Hey, great post...I'm still learning a lot eve...Hey, great post...I'm still learning a lot everyday about jquery and javascript. <br /><br />I'm having some problems though...When I edit the script, nothing happens? I've followed all the steps, and can't seem to figure out why it's not working.<br /><br />I noticed that the sObjectDate Class ID doesn't change in your tutorial:<br /><br />sObjectData = "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" ";<br /><br /><br />Am I supposed to change this? Right now, when I click save in My Source Editor, Nothing happens...Please Help!<br /><br />-Bobbybobbyhttp://bnoonan@ilshealth.comnoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-30060961866887803162010-07-27T12:29:36.790-07:002010-07-27T12:29:36.790-07:00Hey Shridar,
I like this post and kinda implement...Hey Shridar,<br /><br />I like this post and kinda implemented it, but the only issue i have been facing is, it isn't pulling the information/ table contents from the list, instead if i give values directly in the code that you gave, its producing me a nice chart.<br /><br />I think i have the problem with the list address.. could you please elaborate me on where and how to pull this URL, and <br /><br />FYI: i am using WSS, not MOSSpavannoreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-29103373999604499682010-05-24T10:55:28.427-07:002010-05-24T10:55:28.427-07:00I mean Gantt Chat view which is available OOTB...I mean Gantt Chat view which is available OOTB...Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-46179383022797645742010-05-24T10:51:55.762-07:002010-05-24T10:51:55.762-07:00Hi Chris,
Definitely we can modify this code ...Hi Chris,<br /> <br /> Definitely we can modify this code to get the Gantt Chat.<br /><br />Before modifying this please check whether Gantt Chat suffice your requirements... <br />We can also customize its CSS using a simple javascript and custom CSS styles.Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-78079084916478306292010-05-24T09:10:32.817-07:002010-05-24T09:10:32.817-07:00Can this code be modified for the Gantt chart?Can this code be modified for the Gantt chart?Unknownhttps://www.blogger.com/profile/07492927050838354030noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-47213832988639925572010-05-18T11:04:46.219-07:002010-05-18T11:04:46.219-07:00I having issues with the data not updating without...I having issues with the data not updating without me loading the RPC link in another window. Is there a known reason for this?Kennyhttps://www.blogger.com/profile/10562916949910525406noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-32316145029891654002010-03-04T07:59:40.128-08:002010-03-04T07:59:40.128-08:00Hi,
Thanks, this was very helpful to come up with...Hi,<br /><br />Thanks, this was very helpful to come up with fusioncharts. However I have noticed that if I don't use the &Query=SomeField argument then the xml output I will get is not always updated.<br /><br />Is there any walkaround?<br /><br />Thanks<br /><br />David.Kaiz0ku ChaGohttps://www.blogger.com/profile/02472052628817000258noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-50225716731712038542010-03-02T23:24:38.808-08:002010-03-02T23:24:38.808-08:00Hi Steven,
Thanks for your comments. Yes w...Hi Steven,<br /> <br /> Thanks for your comments. Yes we can use the fields in the infopath for these charts too.<br /><br />You have to publish all the list of required fields as a extended properties to the list created using InfoPath form. <br /><br />Once fields are available as extended properties you can follow the approach mention in the blog to generate the charts.<br /><br />Please let me know if you need any further assistance, we don't need to be expert in JQuery. With the steps mentioned here are enough for generating the charts.Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-13531083142432358802010-03-02T23:20:58.782-08:002010-03-02T23:20:58.782-08:00HI Alex,
After getting the complete list of S...HI Alex,<br /><br /> After getting the complete list of Status, yes we can break up the status depending on the module (We have to extract both Status and Modile from the List). This has to be implemented in the javascript logic before providing as input to the fusion chart.Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-41974914444497325572010-02-21T12:49:30.996-08:002010-02-21T12:49:30.996-08:00We have really found your thoughts very helpfull, ...We have really found your thoughts very helpfull, but we are trying how to get data from a list created by Infopath. We have done this with the Switch(case) example you provided. But given our limited experience we do not know how to get data from multiple columns to build a multiseries bar chart. Do you have any examples or guidance. We have zero experience with JQueryAnonymoushttps://www.blogger.com/profile/15038059251583853266noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-73747009135323408782009-11-06T09:15:04.890-08:002009-11-06T09:15:04.890-08:00Hi Ben,
We can have multiple Content Editor We...Hi Ben,<br /><br /> We can have multiple Content Editor Web Parts. Here we are building the graph (<object>) dynamically and assigning as inner HTML to the div tag. This means that if we have mutiple graphs we have to create multiple div tags with different names in the CEWPs. <br /><br />I tried the similar solution in one of my project where we are displaying mutiple diffrent kinds charts (Fusion Charts).<br /><br />Comming to the second question, View=GUID "Specifies the GUID of the list view to use. If null, the default view is used." <br />Whenever we are passing the Query paramete in the url, view parameter will not be considered. If the Query parameter is not specified then request will be considered with specified view (guid) or a default view.<br /><br />You can get more info wrt Display method in the Microsoft Site @<br />http://msdn.microsoft.com/en-us/library/ms416599.aspxSridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-19596071291025716482009-11-05T09:31:55.425-08:002009-11-05T09:31:55.425-08:00Hi,
Great solution. I've been looking for som...Hi,<br /><br />Great solution. I've been looking for something like this for a long time. <br /><br />Can you advise how / whether it is possible to display two CEWPs with these charts on the same web part page at the same time? I've tried various methods but always end with one of the CEWPs being empty. If I do manage to display two charts, the second is always a duplicate of the first.<br /><br />Also, I cant get the &View=GUID option to have any effect. I'm picking up the GUID from the View Settings URL and including in the Display parameters, but all I get returned is an empty document. <br /><br />var sCmdParameters = "Cmd=Display&List=%7BBA5C80E3%2D1150%2D43BD%2DBAFE%2D528A6F83AD91%7D&View=%7BE67D1A75%2D74CA%2D42AB%2DBBD3%2D68930A99795B%7D&XMLDATA=TRUE" ;<br /><br />Am I missing something?<br /><br />Thanks in advance <br /><br />Benout on a limbhttps://www.blogger.com/profile/16432893186491073832noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-7924673036685518462009-08-11T05:56:19.305-07:002009-08-11T05:56:19.305-07:00Hi Alex,
We can filter the values in different...Hi Alex,<br /><br /> We can filter the values in different ways as described below:<br /><br />1. Creating a view for a module and providing the view id(View=guid of the view) as a parameter in the query string (we should not pass the query parameter).<br /><br />2. Instead of using owssvr.dll, we can go with the web services (lists.asmx) for the corresponding list where we can pass the query as part of the soap request.<br /><br />You can go with any of the above approaches which we implemented in our projects too...Sridhar Babu Kolapallihttps://www.blogger.com/profile/12879032012674034075noreply@blogger.comtag:blogger.com,1999:blog-124201859545181164.post-23685097877074981372009-08-06T09:25:20.771-07:002009-08-06T09:25:20.771-07:00Hi,
It is possible to filter out the results. I ...Hi,<br /><br />It is possible to filter out the results. I have a list of status' that is 3500 lines long. I would like to split it up into a stacked 3d column chart split up by another category called "Module." <br /><br />Doing this only gives me a long long list of status':<br />http://siteURL/_vti_bin/owssvr.dll?Cmd=Display&Query=Pass%5fx002f%5fFail&List=%7BE12316E2%2D6E38%2D4161%2DB022%2D9B16428B2211%7D&XMLDATA=TRUEUnknownhttps://www.blogger.com/profile/01165632872460921803noreply@blogger.com