In this post, I will share how to build uploading CSV file function to Page List using pxUploadCSVResults activity. Please see attached for the tutorial.
This document includes the following tips:
How to handle embedded page (pyWorkPage) and top page (non-case context)
How to avoid PRRuntimeException error
How to allow Japanese characters in the Shift-JIS formatted CSV file
How to map different names between header in CSV file and actual properties
@KOMARINA The first step in the activity is to clear the error messages so that doesn’t help. As i said, its not able to pass the hiddenfilepath on second upload.
@Bhavya I was using similar functionality to upload file and parse in Pega to do some processing and i am able to process it after i get an error without having to initiate the whole process, only difference is i am parsing an excel file instead of a csv. I am sure you might have set all the params right, but please check again, here are my params
My customer was able to make it by following the How-to document, so it must be either your code or CSV file. Please go through the document to see if your code is missing anything. If not, then suspect CSV file. Validate if property name exactly matches header name. Get rid of “Address” column from the file and try one by one to identify the bottleneck.
Also, you can’t have space in the header name like “Phone number”. Even if you enter space in between when you create a property, PRPC will trim it. Having space in the CSV file should lead to the same error as yours, shown as below.
The reference Phone number is not valid. Reason: invalid property name: 'Phone number'
The problem is with the CSV file. I downloaded a sample CSV file from google and uploaded it. It worked as expected but why is the CSV file that I created is not working. Both these files have same headers.
When we create a CSV file sometimes the values could get corrupted while saving, that’s the reason for error. After creating the CSV file, if we save-as the file again(new file or replace the file), then we can upload it without any error.
