Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

CSV Upload file does not work

SA-16739

Summary



CSV file is used to populate data type. However, the file is not read and it fails in the custom java of the OOTB activity pxUploadCSVResults.


Error Messages

** Java Exception: java.lang.StringIndexOutOfBoundsException: String index out of range: -1


Steps to Reproduce



1. Log in through Pega Operator
2. Navigate to Data Table Editor
3. Click Import
4. Choose the CSV file
5. Click Upload


Root Cause



CSV file has extra spaces (LF (Line Feed) got added) which caused the issue while importing to populate the records.


Resolution



Make the following change to the operating environment:

1. Open the CSV file in notepad++
2. Navigate to View > Show Symbol > Show All Characters
3. In line5 notice LF field. Remove the same and save the file
4. Try to import the CSV file
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

0% found this useful

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us