Discussion
Pegasystems Inc.
JP
Last activity: 16 Nov 2021 15:46 EST
How to build uploading CSV file function
Hi,
It is a very common requirement that user uploads a CSV file from local machine to a page list on clipboard. In this post, I am sharing how to build such function. Also this How-To includes a few additional tips:
- How to avoid PRRuntimeException error
- How to allow Japanese characters in the CSV file
- How to map different names between header in CSV file and actual properties
Please see attached for the document.
Thanks,
Coforge DPA
GB
Hope you are doing well.
The post is extremely helpful and detailed.
I have also implemented the a similiar requirement in my project but got stuck with an issue which has got me to this post.
Just wanted to know if you faced something similiar or not.
Issue:
1. I am using "File Path with Form" control from the flowaction pxUploadCSVResults
2. Without uploading the file, if press submit it gives me an error
3. Now second time, if i upload a correct file and try to progress it results in same error.
It seems that "hiddenfilepath" remains blank if I upload the file after any errors.
It works fine , if i initiate the whole process again.
Did you face anything like this?
Regards
Bhavya
Accenture
GB
@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
