http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/http://www.intersoftsolutions.comenCopyright 2002 - 2015 Intersoft Solutions Corp. All rights reserved.60http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/Fri, 30 Oct 2009 00:23:17 GMTGlayaarThis issue has been reported by another customer and a bug report has been submitted for the developer. If there is any update regarding this issue, we will inform you.http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/Thu, 29 Oct 2009 14:32:15 GMTJohn.Bonin@dot.gov<p>More information.  </p> <p> </p> <p>1.  The text export seems to mess up if there are more than 50-60 records, possible overflow problem?</p> <p> </p> <p>2.  If you convert a column to a TemplatedColumn, the problems I am experiencing withthe ExporttGrid show up.  I have modified your sample if you want to see it, but all you need to do is create a TemplateColumn and then in the InitializeRow event modify the template text.  </p> <p> </p> <p>I'll send a sample if you need one.</p> <p> </p> <p>This is my last hope, if I can't get export to run then looks like I need to find a replacement.</p> <p> </p> <p> </p>http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/Thu, 29 Oct 2009 08:16:31 GMTJohn.Bonin@dot.gov<p>Hi Glenn,</p> <p>Ok that takes care of the problem with the Address filed, but now run the Sample called "Exporting".  First don't touch anything and export to text.  Look at Product ID 59 and notice that the end of the Product Name "ult" is on a seperate line.  Now apply your code to it (note I am using the VB samples) to Product Name and run the page and export.  Notice 59 is correct now but Product ID 34 and 70 are messed up.  There are no comma's in this data.  Now apply the above code to the only other string field "QuantityPerUnit", re run and export, and see other fields are messed up.  This appears to only occur with Text.  What other data maybe causing this?</p> <p>In my Data, it appers to be Dates that are causing the problem.</p>http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/Thu, 29 Oct 2009 00:03:43 GMTGlayaar<p>The text file issue occurs because there is a <i>,</i> character in the Address column while we are using <i>,</i>  as a column separator. In order to remedy this issue you could enclosed the Address data in a <i>" " &nbsp;</i>during Export server side event<i>&nbsp;</i>in order to set the data as a single column data. Here is the snippet:<br /></p><pre>protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e){ foreach (WebGridRow wgRow in e.Table.Rows) { wgRow.Cells.GetNamedItem("Address").Value = "\"" &#43; wgRow.Cells.GetNamedItem("Address").Value &#43; "\""; wgRow.Cells.GetNamedItem("Address").Text = "\"" &#43; wgRow.Cells.GetNamedItem("Address").Text &#43; "\""; } }</pre> <p> </p> <p />http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/Thu, 29 Oct 2009 00:03:35 GMTGlayaar<p>The text file issue occurs because there is a <i>,</i> character in the Address column while we are using <i>,</i>  as a column separator. In order to remedy this issue you could enclosed the Address data in a <i>" " &nbsp;</i>during Export server side event<i>&nbsp;</i>in order to set the data as a single column data. Here is the snippet:<br /></p><pre>protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e){ foreach (WebGridRow wgRow in e.Table.Rows) { wgRow.Cells.GetNamedItem("Address").Value = "\"" &#43; wgRow.Cells.GetNamedItem("Address").Value &#43; "\""; wgRow.Cells.GetNamedItem("Address").Text = "\"" &#43; wgRow.Cells.GetNamedItem("Address").Text &#43; "\""; } }</pre> <p> </p> <p />http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/Wed, 28 Oct 2009 08:44:19 GMTJohn.Bonin@dot.gov<p>Anything more on this?  This is still happening with the SP1 Refresh.</p>http://www.intersoftsolutions.com/Community/WebGrid/More-Export-problems/Mon, 26 Oct 2009 08:11:04 GMTJohn.Bonin@dot.gov<p>Hi,</p> <p> There appears to be a big bug in the Export functions (use any, client, server and any type).  Using the webUI samples for 2009 R1 SP1 run the sample "ProgrammaticExportServerSide", select the "Export Grid" button in the Grid tray, select Excel and view the Excel listing.  Now take TEXT and export.  Compare the 2 outputs and they are not the same!  Excel has extra records with only an address field with all other columns blank.  Then look at the Text notice that some records have portion of the text that belongs to other columns in the record above.  I have attached 2 samples, Excel and Text of the Northwind export.  You can run the Client Side script on the ProgrammaticExportClientSide, running it first for Excel and then Text and notice the same problems.</p><pre>As an example: Here is the Excell export </pre><pre>VINET Vins et alcools Chevalier Paul Henriot Accounting Manager 59 rue de l'Abbaye Reims 51100 France 26.47.15.10 26.47.15.11 </pre> <p>Here is the Text export:</p><pre>VINET,Vins et alcools ,Paul Henriot,Accounting Manager,59 rue de l'Abbaye,Reims, ,51100,France,26.47.15.10,26.47.15.11</pre> <p>You can change the file extension of the text file to csv and open it in Excel and then compare the 2 sheets and there are big differences.  </p> <p> </p>