Peter W
-
Content count
8 -
Joined
-
Last visited
Posts posted by Peter W
-
-
Hi
I have a sharepoint list with 211 items in it.
This data covers a single entry per day for the last 211 days, i want to connect up a single series bar chart and group the data by month and have a drill down to day.
Except it will do the grouping to month, but when I drill down to the day I get missing days, it renders find and I look in the debug information and it says an error but this error seems to be old and related to the preview.
Can you tell me how much is too much data, and what can I do to get this data added to the chart.
Thanks
Peter
Debug information
Debug Information:
Renderer: Flash
Flash Player installed: true
Browser Information:
App code name: Mozilla
App name: Microsoft Internet Explorer
Version: 4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; CMNTDF; .NET4.0C; .NET4.0E; InfoPath.3)
Platform: Win32
User agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; CMNTDF; .NET4.0C; .NET4.0E; InfoPath.3)
Invoker: WebPart Menu
SharePoint Version: 14.0.4762.1000
ErrorLog entries:
Date: 03/07/2012 16:57:55
Title: too much data
Exception: too much data
Type: Error
Stack Trace: at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)
at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)
at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)
at Collabion.Charts.WebServicePage.OnInit(EventArgs e)
Inner Stack Trace:
Inner Exception:
Additional Information:
Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx
----------------------------------------------------------------------------------
Date: 03/07/2012 16:57:30
Title: too much data
Exception: too much data
Type: Error
Stack Trace: at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)
at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)
at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)
at Collabion.Charts.WebServicePage.OnInit(EventArgs e)
Inner Stack Trace:
Inner Exception:
Additional Information:
Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx
----------------------------------------------------------------------------------
Date: 03/07/2012 16:53:42
Title: too much data
Exception: too much data
Type: Error
Stack Trace: at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)
at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)
at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)
at Collabion.Charts.WebServicePage.OnInit(EventArgs e)
Inner Stack Trace:
Inner Exception:
Additional Information:
Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx
----------------------------------------------------------------------------------
Date: 03/07/2012 16:52:46
Title: Chart settings could not be retrieved. Please check your connection settings and try again.
Exception: The data provider could not be found. Please select another data provider or contact your administrator.
Type: Error
Stack Trace: at Collabion.Charts.Business.ProviderManager.GetProvider(String webPartId, String name)
at Collabion.Charts.Business.WebService.GetProviderConfiguration(String webPartId, String name)
at Collabion.Charts.WebServicePage.OnInit(EventArgs e)
Inner Stack Trace:
Inner Exception:
Additional Information:
Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx
----------------------------------------------------------------------------------
Date: 03/07/2012 16:44:41
Title: Chart preview could not be generated. Please check your chart settings and try again.
Exception: Chart preview could not be generated. Please check your chart settings and try again.
Type: Error
Stack Trace: at Collabion.Charts.Business.Helpers.DataTableHelper.ApplyGroupBy(DataTable sourceTable, GroupByOperation groupBy)
at Collabion.Charts.Business.Providers.ListDataProvider.<>c__DisplayClassc.<GetDataFromStorage>b__9()
at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
at Collabion.Charts.Business.Providers.ListDataProvider.GetDataFromStorage()
at Collabion.Charts.Business.Providers.Base.DataProviderBase.GetData()
at Collabion.Charts.Business.ChartBuilder.GetData(IDataProvider provider, ChartConfiguration configuration, Boolean preview)
at Collabion.Charts.Business.ChartBuilder.GetXml(ChartConfiguration configuration, IDataProvider provider, Boolean preview)
at Collabion.Charts.Business.WebService.GetChartXmlPreview(String chartConfiguration)
at Collabion.Charts.WebServicePage.OnInit(EventArgs e)
Inner Stack Trace:
Inner Exception:
Additional Information:
Request: https://sharepoint.anonanonuk.com/_layouts/CollabionCharts/WebService.aspx
----------------------------------------------------------------------------------
Chart XML:<chart previewanimation="1" exportenabled="1" exportatclient="0" exportshowmenuitem="1" exporthandler="/_layouts/CollabionCharts/FCExporter.aspx" exportcallback="CC_onAfterExportObjectSaving" exportaction="download" showsecondarylimits="1" showdivlinesecondaryvalue="1" animation="1" caption="Test" yaxisname="Items" pyaxisname="Items"><set label='Jan'12' value="130670" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dJan%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Feb'12' value="178021" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dFeb%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Mar'12' value="180989" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dMar%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Apr'12' value="219966" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dApr%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='May'12' value="213304" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dMay%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Jun'12' value="200475" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dJun%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/><set label='Jul'12' value="6650" link='newchart-xmlurl-https%3a%2f%2fsharepoint.anonanonuk.com%2fservices%2fdpcs%2f_layouts%2fCollabionCharts%2fWebService.aspx%3fmethod%3dGetDrillDownChartXml%26webPartId%3dg_4ee546dc_aa53_4096_b3aa_9c48e6ecc939%26label%3dDate%26value%3dJul%26apos%3b12%26series%3d0%26isGetDrillDownGrouping%3dFalse'/></chart>
Operating System Details
OS Version: 6.1.7601.65536
OS Platform: Win32NT
OS ServicePack: Service Pack 1
OS Version String: Microsoft Windows NT 6.1.7601 Service Pack 1
-
Thanks for the response, I got mixed up with SQL Views. I am using the v1.0.0.0 we bought last week.
Thanks
Hi Peter,
We have been supporting SharePoint list views since beta1 release of Collabion Charts for SharePoint. After that release, we released the second beta and on June 1 we released the full and final version 1 of the product. You may download the product from our website http://collabion.com
Thanks
Vishal
-
Hi
It would be great if you could specify some way of creating a multi series data set from a single date field.
So my data is a bit like this
Qty - Date
12 - Jan 2011
15 - Feb 2011
...
19 - Jan 2012
14 - Feb 2012
I would like to be able to have multiple series so I can have one per year in the date field.
Thanks
-
Hi
Just started using collabion, and its good.
I am swaping from the google chart webpart from armein http://www.amrein.com/apps/page.asp?Q=5749 for a number of reasons, however there is one thing I am really missing its the ability to add Search Filter(s) that the "user" can select it would be great if you could add something along these lines.
I know you can exlude a serise via the legend but the filter is not possible at the user level.
Thanks
Peter
-
Hi
It would be very helpful if we could connect to a SQL View not just a SQL Table, can this be made possible?
Thanks
-
Hi
I too would be keen to know how this feature is progressing, as I am keen to implement it.
Thanks
Peter
Hi,
We would get back to you once we have any news from our end.
Happy FusionCharting!
-
Hi
I am trying to connect to a sharepoint list via collabion charts that is on another sharepoint site its the same server just another site, its one up the hierarchy from where I want the chart. Is this possible, it feels like it should be simple to implement as its just a url but I cant seem to do it.
Any help appreciated
Peter
Drill Down Day X Axis Format
in Collabion Charts for SharePoint
Posted · Edited by Peter W · Report reply
Hi
I have a month drilling down into a day on Sharepoint and I get the time format in the day drill down and I cant seem to remove it, it makes the chart look very messy can I remove it somehow?
I attach a screen shot of the drill down and you can see all the 00:00 bits
Peter