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 29, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.