Error advanced export

Brad Chapman asked on September 12, 2018 02:08

Hey Guys Is anyone familiar with this issue? When exporting recorded data from a BizForm to Excel and unchecking "Current page only", the user gets an error and the following is logged:

Message: '.', hexadecimal value 0x00, is an invalid character.

Exception type: System.ArgumentException Stack Trace: at System.Xml.XmlUtf8RawTextWriter.InvalidXmlChar(Int32 ch, Byte* pDst, Boolean entitize) at System.Xml.XmlUtf8RawTextWriter.WriteElementTextBlock(Char* pSrc, Char* pSrcEnd) at System.Xml.XmlUtf8RawTextWriter.WriteString(String text) at System.Xml.XmlWellFormedWriter.WriteString(String text) at DocumentFormat.OpenXml.OpenXmlElement.WriteTo(XmlWriter xmlWriter) at DocumentFormat.OpenXml.OpenXmlCompositeElement.WriteContentTo(XmlWriter w) at DocumentFormat.OpenXml.OpenXmlElement.WriteTo(XmlWriter xmlWriter) at DocumentFormat.OpenXml.OpenXmlCompositeElement.WriteContentTo(XmlWriter w) at DocumentFormat.OpenXml.OpenXmlPartRootElement.WriteTo(XmlWriter xmlWriter) at DocumentFormat.OpenXml.OpenXmlPartRootElement.SaveToPart(OpenXmlPart openXmlPart) at DocumentFormat.OpenXml.Packaging.OpenXmlPackage.SavePartContents() at DocumentFormat.OpenXml.Packaging.OpenXmlPackage.Dispose(Boolean disposing) at DocumentFormat.OpenXml.Packaging.OpenXmlPackage.Dispose() at CMS.ImportExport.DataExportHelper.ExportToExcel(DataSet dataSet, Stream stream) at CMS.ImportExport.DataExportHelper.ExportData(DataExportFormatEnum format, HttpResponse response)

Kentico v9.0.51

I've implemented a work around to export to CSV instead of Excel and this resolves the issue.

Cheers, Brad

bizform kentico v9.0.51

Recent Answers

David te Kloese answered on September 12, 2018 09:27

Can you try the same for a different form? It works on my test environment...

What kind of data fields have you stored in it?

0 votesVote for this answer Mark as a Correct answer

Brad Chapman answered on September 20, 2018 07:11

I've checked further. The issue only occurs on one form that I can see and goes away if I uncheck the email column of data. This is a standard Bizform using a standard email capture field. Weird.

Obviously there's some funky data that has slipped through the Bizform validation.

0 votesVote for this answer Mark as a Correct answer

Brad Chapman answered on September 20, 2018 08:38

I resolved the issue by deleting several rows that contained suspect data. This is a validated email bizform field yet a spam bot had inserted the string: "čĊx-crlf-safe-ba30fd97b4127db56e9f4d3d9c030d71646fd2e7: no" into the email field. This then caused the follow-up data export process to fail when attempting to create the XLSX file. This may or may not be a known issue so some feedback would be great.

0 votesVote for this answer Mark as a Correct answer