jburke4

Charting Sharepoint List Data

Recommended Posts

Hello,

 

I have been beating myself up trying to get this to work. I am able to pull data from a sharepoint list as an xml document no problem. I am able to create the standard xml document to display a manually entered list of data into a fusion chart no problem. What I am unable to do is to pull data automatically from a sharepoint list and display it as a fusionchart thereby automating this process so that as data is entered into the list the chart is instantly updated.

 

Here is how I pull data from the list to an xml document:

 

 

http://MyServer/[site]/_vti_bin/owssvr.dll?Cmd=Display&List={listGuid}&XMLDATA=TRUE

 

Here is an example of the data returned:

 

 

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">- <s:Schema id="RowsetSchema">- <s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30">- <s:AttributeType name="ows_DocIcon" rs:name="Type" rs:number="1"> <s:datatype dt:type="string" dt:maxLength="512" /> </s:AttributeType>- <s:AttributeType name="ows_Name_x0020_of_x0020_injured_x002" rs:name="Name of injured worker" rs:number="2"> <s:datatype dt:type="string" dt:maxLength="512" /> </s:AttributeType>- <s:AttributeType name="ows_Company" rs:name="Company" rs:number="3"> <s:datatype dt:type="string" dt:maxLength="512" /> </s:AttributeType>- <s:AttributeType name="ows_Date_x0020_and_x0020_time_x0020_" rs:name="Date and time of incident" rs:number="4"> <s:datatype dt:type="datetime" dt:maxLength="8" /> </s:AttributeType>- <s:AttributeType name="ows_Claim_x0020_Status" rs:name="Claim Status" rs:number="5"> <s:datatype dt:type="string" dt:maxLength="512" /> </s:AttributeType>- <s:AttributeType name="ows_Financial" rs:name="Financial" rs:number="6"> <s:datatype dt:type="float" dt:maxLength="8" /> </s:AttributeType>- <s:AttributeType name="ows_OSHA_x0020_Recordable" rs:name="OSHA Recordable" rs:number="7"> <s:datatype dt:type="boolean" dt:maxLength="1" /> </s:AttributeType>- <s:AttributeType name="ows_Contact_x0020_Log" rs:name="Contact Log" rs:number="8"> <s:datatype dt:type="string" dt:maxLength="1073741823" /> </s:AttributeType> </s:ElementType> </s:Schema>- <rs:data> <z:row ows_Name_x0020_of_x0020_injured_x002="jane doe" ows_Company="subsidiary2" ows_Date_x0020_and_x0020_time_x0020_="2010-09-13 14:00:00" ows_Claim_x0020_Status="Open" ows_Financial="1100.00000000000" ows_OSHA_x0020_Recordable="1" ows_Contact_x0020_Log="<div class=ExternalClass693C873314504FFF907BB8BD8A141304><div>comments about this case.</div></div>" /> <z:row ows_Name_x0020_of_x0020_injured_x002="john doe" ows_Company="subsidiary1" ows_Date_x0020_and_x0020_time_x0020_="2010-05-21 00:00:00" ows_Claim_x0020_Status="Open" ows_Financial="30265.1000000000" ows_OSHA_x0020_Recordable="1" ows_Contact_x0020_Log="<div class=ExternalClassEEF871C79503466FA4A55BEF02D6C9FF><div>comments about this case.</div></div>" /> </rs:data> </xml>

 

Here is an xml used for fusionchart:

 

<chart>

<categories>

<category label="Claim Amount" />

</categories>

<dataset SeriesName="subsidiary1">

<set value="30265.10" />

</dataset>

<dataset SeriesName="subsidiary2">

<set value="1100" />

</dataset>

</chart>

 

I need to pull data from the list as demonstrated above and update the data in the fusionchart xml but have no clue how to. I would prefer to do this directly in the fusionchart xml but if I have to use a java script that is fine too. Any help would be appreciated.

Share this post


Link to post
Share on other sites

How about this? Is it possible to change the data that is charted from the following:

 

 

<chart>

<set label="2007" value="3.13" />

<set label="2008" value="9.27" />

<set label="2009" value="9.27" />

<set label="2010ytd" value="0" />

 

</chart>

 

 

 

So that rather than using label and value from above it uses ows_Name_x0020_of_x0020_injured_x002=" " and ows_Company=" " as the below excerp from an xml document shows

 

 

- <rs:data>

<z:row ows_Name_x0020_of_x0020_injured_x002="Full Name" ows_Company="Department" ows_Date_x0020_and_x0020_time_x0020_="Date" ows_Claim_x0020_Status="Closed" ows_Financial="Dollar Amount" ows_OSHA_x0020_Recordable="0" ows_Contact_x0020_Log="<div class=ExternalClass7D50E8C57E9944BABC2C1830F2A5940A><div></div></div>" />

- <rs:data>

 

Edited by jburke4

Share this post


Link to post
Share on other sites
Guest Rajroop

Hi jburke4,

 

We have recently released the beta of FusionCharts for SharePoint. FusionCharts for SharePoint helps you create interactive & data-driven charts in SharePoint, without having to write a line of code. The charts are created using a wizard and can connect to various data sources such as SharePoint Lists, CSV, MS SQL, Oracle, Excel & BDC. You can add drill-down and export capabilities to each chart and configure both cosmetic and functional aspects.

 

You can download the fully-functional version from www.fusioncharts.com/sharepoint - we would love to have your feedback on this.

 

Please post your suggestions and any bugs as replies to the FusionCharts for SharePoint forum thread at:

FusionCharts for SharePoint beta impression

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now