SmartTools.Charts

SmartToolsB2.jpg

The SmartTools.Charts component shows Silverlight charts based on data stored in SharePoint lists or document libraries. To render the Silverlight charts, Visifire is used (http://www.visifire.com/). The Visifire Silverlight control is automatically deployed by the installation of the SmartTools.Charts component.

To see the SmartTools.Charts in action, watch the embedded video below (make sure to switch to full screen). The high resolution video can be seen and dowloaded here http://vimeo.com/2922315. Note to download the full resolution video, check the download link a the bottom of the Vimeo page! http://vimeo.com/2922315

Cannot resolve video macro, invalid parameter 'type'.

Last edited Jan 22, 2009 at 5:59 PM by JanTielens, version 6

Comments

DaveHeffernan Jul 19, 2010 at 1:36 PM 
This forum link explains the issue I was having

http://smarttools.codeplex.com/Thread/View.aspx?ThreadId=49939

Seems that the chart gets confused when you add a list web part for the list feeding the chart on to the same page!

DaveHeffernan Jun 3, 2010 at 10:45 AM 
Fantastic web part but I'm also having the same issue as kdsteflik and sflindgren, the web part works perfectly on some installations but on others any view chosen in the properties is being ignored and the chart just loads using the default view! Any help would be really appreciated.

Cheers

sflindgren Apr 8, 2010 at 9:52 PM 
I too am having the same issue as kdsteflik. Seems like a great web part for showing my data, but one GIANT issue I have is being able to filter or limit my data by the view. Can someone help with this issue? I have tried the list name and list view ID, both have no effecton what data is being shown.

Thanks

msalamon Mar 11, 2010 at 8:48 PM 
When will SmartTools be made to work with SP 2010?

kdsteflik Mar 4, 2010 at 5:48 PM 
Great webpart! The webpart doesn't seem to recognize any filters or sorting on the List View being used to drive it. Any thoughts/suggestions?

Khaloudinet Feb 15, 2010 at 12:54 PM 
Hello,
Thanks for your job, but I didn't manage to install this tool. I have this error:

***** SOLUTION DEPLOYMENT *****
***** ERROR *****
Timeout error
CodePlex.SharePointInstaller.InstallException: Timeout error ---> CodePlex.SharePointInstaller.InstallException: Timeout error
at CodePlex.SharePointInstaller.InstallProcessControl.WaitForJobCompletionCommand.Execute()
--- End of inner exception stack trace ---
at CodePlex.SharePointInstaller.InstallProcessControl.WaitForJobCompletionCommand.Execute()
at CodePlex.SharePointInstaller.InstallProcessControl.TimerEventInstall(Object myObject, EventArgs myEventArgs)
***** SOLUTION RETRACTION *****
***** ERROR *****
Timeout error
CodePlex.SharePointInstaller.InstallException: Timeout error
at CodePlex.SharePointInstaller.InstallProcessControl.WaitForJobCompletionCommand.Rollback()
at CodePlex.SharePointInstaller.InstallProcessControl.TimerEventRollback(Object myObject, EventArgs myEventArgs)

Could you please help me.

Thanks.

jmdyas Feb 4, 2010 at 1:13 AM 
Any chance you may add support for stacked charts (multiple data series)?

bugsgrewal Dec 3, 2009 at 4:47 PM 
I have installed the package on the server, added the MIME types for silverlight, but I am not seeing the extended menu in the site actions or any web parts. I am using a custom master page. Is there anything I need to check or activate the features from some where.

I have already Restarted IIS

Smcdonn Nov 11, 2009 at 1:20 AM 
Great tool - I extended it so that you can connect out of the box filter web parts to it. Essentially it lets you drill down, pretty neat and something you may want to include in future releases.
http://www.sharepointsteve.com/2009/11/customizing-the-smart-tools-grouped-chart-to-accept-connections-from-filter-web-parts/

RoyB Oct 29, 2009 at 10:09 AM 
Great, thanks a lot Jan. really useful.

I'm trying to extend to use for stacked charts. Do you or anyone else know if it is possible to refer to two list views within the template rather than refer to the webpart form fields for dataseries source?

willw_magic Oct 8, 2009 at 2:52 PM 
Awesome tool, great visuals. But I do have a question: Is there anyway to group multiple lists with the similar data as to display a total of the two? I have two lists, which have different permissions but same data. Basically, I want to be able to display a summary view of whats going on between the two (in a chart form). The only way I can think of is to tie a workflow into each of them which writes to a 3rd master list everytime either of them are updated. That is cumbersome and relies on workflows, which I don't have much faith in.

PlanetParker Sep 17, 2009 at 2:36 AM 
I have not yet used Jan's SmartTools.Charts, but if they are indeed based on VISIfire, then this post may help you: http://planetparker.com/blog/Lists/Posts/Post.aspx?ID=43

grub1221 Jul 15, 2009 at 8:51 PM 
Hi guys,
This tool is amazing. I do have one caveat/question though. Are you able to graph multiple data sources in one chart from the GUI/Webpart within SharePoint. I have tried to no avail. Example; just like on Jan's Site I have Month, Budget, and Actual in a SharePoint List. Is there a way to pull both columns (Budget and Actual) into the graph with what you are given? Thank you!

Brian
www.tehsharepointer.blogspot.com

MPankau Jun 24, 2009 at 12:36 PM 
The datasource names and any group-by fields are case sensitive. I was getting similar errors when referencing the "Assigned To" field when the actual field name is "Assigned to".

beanyjon Jun 9, 2009 at 10:57 AM 
I am also having the problem with the web parts being blank, have added the MIME types and installed silverlight pluggins on servers and test machines.
PaveenBattula i do not understand the location path? do i enter this underneath the script in the source editor or in the content link? also how did you decide on that path? the defualt save path is "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\SmartTools.Charts" but how do i express this in the content link as it requires a url? sorry if this i am missing somthing really obviouse.

PraveenBattula May 21, 2009 at 10:55 AM 
Hi guys,
To whom the charts are not loading or just the web part is showing blank, it means the file VisiFire2.js is not calling. For this, do this.
1. Add a web part called Content Editor Web part to your page on the top of all chart web parts.
2. Add the below line in it by opening source editor.
<script type="text/javascript" src="/_layouts/SmartTools.Charts/VisiFire2.js"></script>

12 hive/layouts/SmartTools.Charts/ - This is the location where the js and xap files are present.
3. Now check in and publish your page.

That's it!!!
Nice work guys.
-Praveen.

cn1109 May 11, 2009 at 7:52 PM 
That's the same question I have. I've spend hours trying to see how I can modify the project and so far nothing. I've tried using WSPBuilder in VS2008 and keeping the same tree structure. I'm able to compile the wsp file but when I try to install it, it doesn't work. It gives me a reference error.

doranmichigan May 9, 2009 at 12:27 PM 
Thanks for the web part. Works very nice. I am using a Custom Master Page.

Got the Mime Types added in IIS
Added this to the MasterPage <head> section <SharePoint:DelegateControl runat="server" ControlId="AdditionalPageHead" AllowMultipleControls="true"/>

I have downloaded and tried to use the "The SmartPart Web Part project template for Visual Studio" to make some changes, to the SmartTools.Chart code, but have failed. I can go in and change the Web Part "XAML Template" code, once the Chart is install, but I would like add in a Title, X Axis and Y Axis Title box to enter for user without having to change the "XAML Template" manually for them.

Do you have the actual solution file for this to share?

he_pennypacker May 2, 2009 at 2:18 AM 
Nevermind, I figured it out. It seems that this error is displayed if you don't select any source data for the chart. Anyway, all the chart web parts are working now.

he_pennypacker Apr 30, 2009 at 5:52 AM 
Hi Jan. Thanks for your great work on these Smart Tools. I have successfully installed the jquery and whats new features, but I have the same error as mttime, pvenkat and andrewmorgan; "Value does not fall within the expected range". Any pointers in overcoming this?

AndrewMorgan Apr 25, 2009 at 11:55 PM 
Hi,

The tool looks great but i'm having an error when i try and load data. the error i'm getting is below. Please Help. I have looked for a parameter of Format in the settings but i cannot find it.

Cheers

Value cannot be null. Parameter name: format

Details: System.ArgumentNullException: Value cannot be null. Parameter name: format at System.String.Format(IFormatProvider provider, String format, Object[] args) at System.String.Format(String format, Object arg0, Object arg1) at SmartTools.Charts.ChartWebPart.RenderContents(HtmlTextWriter writer)

mitchel316 Apr 24, 2009 at 1:56 PM 
Hi All,

Can anyone please step me through on how to install this tool please. Thank you.

Chris.

pvenkat07rd003 Mar 12, 2009 at 10:17 AM 
Hi Jan,
These are very wonderful. I installed Chart setup in MOSS 2007. Windows Server 2003 + .Net Frame work 3.0 are installed in my server. I changed the MIME settings for adding Silver light types. I created a Task List and for that I added the "Tasks Chart" WebPart. After adding that one I got the below error message.

Value does not fall within the expected range.

Details: System.ArgumentException: Value does not fall within the expected range. at Microsoft.SharePoint.SPListCollection.GetListByName(String strListName, Boolean bThrowException) at Microsoft.SharePoint.SPListCollection.get_Item(String strListName) at SmartTools.Charts.ChartWebPart.RenderContents(HtmlTextWriter writer)

Can you help please on this issue.

Thanks,
Rao

CP_AlonF Mar 2, 2009 at 6:35 AM 
Hi,
I wonder if it is possible to get data for charts from external web service for real time data charts.
Instead of inserting the data into the lists each interval i'm getting the data.
Is any one know an existing workaround that using visifire with web service in SharePoint.
Thanks
Alon F.

MtTime Feb 27, 2009 at 4:32 PM 
Hi Jan,
Excellent set of tools! Simply brilliant!!
I have installed the SmartTools.Charts but when I add as a WebPart, I'm getting the following error (installed on WSS v3):
Value does not fall within the expected range.
Details: System.ArgumentException: Value does not fall within the expected range. at Microsoft.SharePoint.SPListCollection.GetListByName(String strListName, Boolean bThrowException) at Microsoft.SharePoint.SPListCollection.get_Item(String strListName) at SmartTools.Charts.ChartWebPart.RenderContents(HtmlTextWriter writer)

Any chance anyone knows what is throwing this exception?

Thanks!

meerasharif Feb 13, 2009 at 10:15 AM 
Hi Jan,

I have added sharepoint chart webpart, but when i add the list to the webpart, it showing blank instead of charts, could you please help me to resolve this.

Thanks
Meera

whoajack Feb 11, 2009 at 5:59 PM 
I tried changing the "Group By" field, and it recognized the change, but then only displayed one value although list items did exist with 3 or more different values.
Also, I changed the "List or Document Library", which displayed "Tasks" out of box. I changed that text to the actual name of the list, and all it did was shrink the chart a lot. Not sure if that value matters, as was working fine before I changed anything.

chare1 Feb 2, 2009 at 2:52 PM 
Is it possible to do a stacked column chart as well as format dates?

bernisclav Jan 29, 2009 at 4:05 PM 
cool look! But I have problems showing percents. I type in my sharepoint list 45 (for 45%) and the chart shows a 4500% bar!! If the number already has a zero (10,20,ecc) it show one addittional zero only, otherwise always too additional zeros! (Mi SharePoint SErver is in Spanish)

emartini Jan 29, 2009 at 12:25 PM 
Very nice job for all the smartTools, (automatic controls & install). Thanks a lot.
But... I've the same problem than cduncan, (I've done all the same task) even after an IIS reset. I've to wait 1 day to see it work ?
(I'm in WSS V3 french...)

CommunityLegalAid Jan 23, 2009 at 3:21 PM 
This looks very cool. I will definitely be trying it out. Thanks for the great work!

JanTielens Jan 21, 2009 at 1:10 PM 
Yes, if you're using Win2003 Server, the MIME types have to be added manually.

stevencwong Jan 20, 2009 at 2:14 AM 
cduncan, i had the same problem but it was because the MIME types were missing on web server. Follow this to fix: http://blogs.msdn.com/tims/archive/2008/03/18/configuring-a-web-server-to-host-silverlight-content.aspx

S.

DavidGoebel Dec 31, 2008 at 4:11 PM 
The chart is working today - woot! Maybe the mime types just needed some time to take effect on the server?

VegasGuy55 Dec 31, 2008 at 5:20 AM 
Check the Issue Tracker if you're using anythnig other than the default master page.

DavidGoebel Dec 30, 2008 at 9:08 PM 
I am having the same issue as cduncan.

cduncan Dec 24, 2008 at 5:47 PM 
The deployment of this was simple. SmartTools is amazing. However, I feel I am missing something to get this Chart web part working properly. I am just getting a blank web part after adding it to my site and pointing it to my list.
.Net 3.5 framework installed
Silverlight plugin is on server
Registered the MIME types .xap , .xaml and .xbap