Posted: 23 Jan 2018 14:20 EST Last activity: 27 Mar 2019 2:37 EDT
Bulk Upload functionality -Excel Bulk Upload
What's the best way to upload data through excel sheet and create WO? I've an requirement to loan set of columns (ex, Loan#, State, Address) and create an case for each items ( for each row). Would appreciate your response! Thanks!!
Download and upload activities(Processing of excel data and creating work object). An OOTB "MSOParseExcelFile" activity can be used to parse your input and map it to clipboard page.
A user interfaces section that uses controls for downloading and uploading the template. Following above steps would load excel data in a page list format at the clipboard, The above steps will load excel data to page list property (from above example: excelDetails() ) with multiple number of rows (number of rows given your input excel sheet).
Iterate each row and create work object as per your requirement.
I've configured everything as per the description but on click of Download or Import button, the activity is not getting called. I have unchecked the authentication option but still having the same issue. Any Idea? I'm using Pega7.2.2 version through google Chrome
After parsing I am getting data on the clipboard, however I am getting everything as classless inside Code-Pega-List page. Please find screenshot of Pages and Classes tab of the Activity used for parsing.
Can you guide me what could be wrong in my implementation?
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.