i have a grid that exports fine as long as it is not grouped. the exporter and the code behind are using essentially the code from here
http://help.infragistics.com/Help/NetAdvantage/Silverlight/2011.2/CLR4.0/html/xamGrid_Asynchronous_Export_to_Excel.html
when i allow grouping the grid will not export. it also fails to through the exception in the catch. if i debug and step through i can capture it
mesage
"There was an error generating the XML document."
Innerexception
"Exception of type 'System.OutOfMemoryException' was thrown."
i do not understand why this is occuring, it is not in the known issues for export
any help would be apprciated
Hello,
Thank you for your post. I have been looking into the issue that you have described and I could not managed to reproduce it. I have created a sample application in order to test the exporting of the XamGrid into excel, using the asynch method when there is grouping applied to the grid and I have managed to export 10000 group rows into an excel worksheet. I have tested the sample application using the latest service release of version 12.1. I am attaching the sample application that I have created and the MS Excel document which is result of the exporting of the XamGrid.
Please let me know if you can reproduce the same issue with my sample application or I have misunderstood your scenario in any way.
Looking forward to hearing from you.
Sincerely,
Krasimir
Developer Support Engineer
Infragistics
www.infragistics.com/support
so for giggles i pulled the code out of you sample. i re wrote my page to use your exporting piece of it. got the same error message
There was an error generating the XML document
Thank you for your replies. I have been investigating the issue that you have described and I have tested the sample application that I have created for you, in Silverlight 4 with the RTM and the latest service release of version 11.2 and I was able to export grouped XamGrid, with 20 000 rows. I am attaching the excel file. I have also managed reproduce the issue that you have described, which seems to be a known issue and our developers are currently working on resolving it. It seems that when exporting XamGrid that contains a large amount of rows (I was not able to export more than 30-35k rows that are not grouped), an OutOfMemoryException is being thrown.
Would you please confirm that the issue that you are describing is appearing when exporting large amount of rows?
i do NOT believe it is the large amounts of data. the grid i am trying to export only has 550 rows. i wrote a seperate sample with 300 rows and it exports. its very easy to fake a clean set of data and have the feature work. however the data is not grouped in xlsx when i export it no matter what i set this to:
ExcludeGroupBy
i am pretty sure it has to do with the way it handles data. the set that does not work has nulls in the database
Hi,
I reviewed the thread you and Krasimir have had and working with his sample I modified the class definition so that some of the properties are Nullable<int>. Of course there where some other changes to accommodate a nullable property, including the calculation of the average. And I was able to load the xamGrid and export the grouped xamGrid to excel successfully using Krasimir’s sample.
Could you share your sample? If you could zip it up and attach it to thread we can review and try to see what is causing an issue.
i can not send a full sample as it is not permitted here. i can add a post a dummy class that would match it
it exports if its not grouped, it only fails when its grouped
myClass
public EntityCollection<Assessment> Assessments { get; set; } [Include] public Cateogry Cateogry { get; set; } public Nullable<int> CatID { get; set; } public Nullable<DateTime> DateAdded { get; set; } public string DRConsultant { get; set; } // [Composition] [Include] [Composition] public EntityCollection<myChildClass> myChildClass{ get; set; } public DateTime ModifiedDate { get; set; } public string Owner { get; set; } public int RegID { get; set; } public Nullable<int> Region { get; set; } [Include] public Region Region1 { get; set; } [Required(ErrorMessage = "The Name of the Regulation is Required.")] [Display(Name = "Regulation", GroupName = "Regulation", Description = "This is the Desc for Reg")] public string Regulation { get; set; }
Do you mean if they are easy to uninstall? They can be removed from the Control Panel's Add/Remove programs dialog. In the Add/Remove Programs dialog on the left-hand side you will see a "View installed updates" link. Click on that and in the new list you will see the Silverlight service release for 11.2.20112.2068 (after it's installed). Select this update and uninstall and you'll go back to the previous version you had.
i have not installed the latest service release. are the easy to roll out of incase some other issue arises from installing it?
Hi spicish2222,
You produced this error after installing the latest service release for 11.2 SL4? (11.2.20112.2068)
I've built another sample and I'm trying whatever I can think of to try and reproduce this. I'll get back to you shortly.
stack
i built a new test page in the app, same unable to generate xml error.
see attached