Incorrect format of CSV coming for Rich Text Editor properties
SummaryDeveloper has used properties having Rich Editor Control in their application.
The property get stored in DB accordingly.
Now, when user is trying to extract data from database via
Business Intelligence Exchange (BIX) and populating them as a CSV file, they noticed that all the Rich Text Editor values are appearing in incorrect format. It is corrupting the entire CSV file.
Error MessagesTags are being included in the csv file generated after extraction.
Steps to Reproduce1. Create a property of type single value and add a Rich Text Editor control into that.
2. Add that property into
BIX extract rule.
3. Run your application and put some values into that Rich Text Editor area.
4. Now, execute the Bix Extract into CSV format. The CSV file would come up in a wrong format containing all HTML tags.
Root CauseBIX is used for the extraction of rich text properties which is beyond the scope of BIX.
ResolutionThe main purpose of BIX is to extract the data not to transform it.
BIX does not support extraction from rich text properties, because the extraction of rich properties includes transformation or modification of data.
Published January 18, 2017 - Updated January 31, 2017