Hi.I am new in pega and working with 6.2 version.There is a requirement to insert data to database from an excel sheet( having multiple rows of data).the data also needs to be shown in an window before inserting it to database.can anyone help me.The excel sheet format is predefined.
can you pls illustrate the whole process step by step.as usr will only fiil up the required data set in excel sheet.click on attach and browse button to browse to the path where excel sheet is kept and then to show whole excel data in an window and then click on submit button to insert data into database.and while doing so it will check whether same data exist in the data base or not.suppose the excel contain 7 rows of data.while inserting it shows Duplicate=1,data Inserted=6
1.i will tell what done in our application cannot show you how it is done(client restrictions)
2.users will enter the data in the excel but I think there might some references in that excel like mostly headers
3.Now after file upload is done you will use parse delimited rule in the post activity of the upload file button action.
4.Now you will map the data from the file to the clipboard it might be a list or single page Mapping is done based on those headers
5.Now once data is available to you in clipboard ,and through looping on each paqe you can check the existence of the inserted item(as you are inserting in DB then you might have a key to identify the Unique Data)
6.then as u can identify the duplicates you can the user in the screen .
7.i assume the first screen you will use file upload, second will show file contents from clipboard to ui ,third insert it and also validate the data as u need.
can you pls give me in detail process like activity steps to upload the excel file,parsing it so that clipboard page gets populated.in short the entire steps/activity.I have found an activity "MSOParseExcelFile" @baseclass but unable to customised it as per my requirement.
I do not know the answer. So why am I replying ? Because if I needed to know this, I would bring up something like a decision table or decision tree rule, or a data table rule, or any other rule I could think of that has an “edit in excel” sort of button on it. Then I would use Pega tracer while I click that button (and while I return from excel), to peek at how the core Pega app achieves the excel-to-db linkage.
Similar feature exists in Application Profile wizard in 6.2 version. If you have not already done, tracing this might help you with rules that needs to be implemented. This feature does not have step of showing parsed content (from uploaded excel sheet) on UI screen. It directly inserts all rows from Excel sheet into database.
Application menu -> New Application -> Application Profile. In this wizard Import feature is used in last step of wizard: 'Project Explorer'.