Question

Upload CSV file records

Hi ,

I would like to read a CSV file when user uploads it manually using upload control. The file will have around 150 columns( they are not Pega standard properties and also has some special character or long headers) out of which I would need only 10 columns so is there any way we can read only those by ignoring other columns structure. I see this code rules are final so please suggest me any better ways of doing it.

Customer doesn’t want to have any standard template for this as that is generated by some other portal.

Comments

Keep up to date on this post and subscribe to comments

October 31, 2019 - 5:19pm

Just thought as mentioned in  below article you can refer pxUploadCSVResults   flowaction and pagelist class create property which required to parse only. It might ignore the fields which is not exists.

https://community1.pega.com/community/pega-support/question/upload-csv-file-ui-data-portal-and-then-parse-csv-records 

November 1, 2019 - 1:00am
Response to Deva_Prathapaneni

 

Thank you for your reply.

I am using the same one but the problem is it expects the required CSV file column name expected same like pega property. For example in file I have coulmn “Was there Any Issue(Primary communication)” so it is throwing a validation message by saying this is not a valid property.

Another problem is that this file has some complex data for some columns with some carriage returns and news line I.e paragraphs and that file is being generated by some other systems.

 

November 2, 2019 - 1:02pm
Response to Narender Lakshetty

I think with out template defining in pega OOTB will not support parsing the file. You can try some customizations.

November 4, 2019 - 12:14pm
Response to Deva_Prathapaneni

Yeah..thank you.