Question
HCL Technologies B.V.
NL
Last activity: 4 Nov 2019 12:15 EST
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.
Swedbank AB
SE
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://collaborate.pega.com/question/upload-csv-file-ui-data-portal-and-then-parse-csv-records
HCL Technologies B.V.
NL
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.