Issue in importing records to data table
User is importing the data from the CSV file. If the CSV file contains a String as "abc" , after importing it to data table, it is imported as ""abc"".
The 'extra double quotes' are appended to the Strings having double quotes.
Error MessagesNot applicable
Steps to Reproduce1. Find an existing data table with records.
2. Export the records to CSV file.
3. Update a field in the CSV file by adding a text within double quote and save, that is "xyz".
4. Import the csv file again to the data table and view the records. The particular field would have updated as ""xyz"" (extra double quotes).
Root CauseA defect in Pegasystems’ code or rules.
When the CSV file is edited in excel and saved, if any of the fields contain double quotes, it precedes it with another double quote.
But, when this csv file is imported, it has to parse it correctly by removing this additional double quote which was added.The activity
@baseclass.pxUploadCSVResults was failing to parse the fields with double quotes.
ResolutionApply HFix-29451, through hotfix manager.
Published September 21, 2016 - Updated September 29, 2016