Support Article

Issue in importing records to data table

SA-28219

Summary



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 Messages



Not applicable


Steps to Reproduce



1. 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 Cause



A 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.

Resolution



Apply HFix-29451, through hotfix manager.

 

Published September 21, 2016 - Updated September 29, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.