Parsing CSV File
In are application we have two field which one is already populated to match the data that we have in the excel sheet that we will pull information from which is name. The other is the user count which is the data that we need to pull into are application from the excel spreadsheet using the name associated with that user count. Example if the name is Tech in the excel spread sheet and the user count for tech is 30 then are application needs to look for the name tech in are the spread sheet and match it with the name in the application then take the user count in the application and populate the user count in the application with 30. Please contact me if you have an idea about how to go about this.
Here is the process that happens:
1. First we will get an email and attached to it will be the excel csv file. Which in the excel sheet will hold 3 row of data which will be a name, ID, and User count.
2. Out of the 3 rows of data we will only need 2 of the row for the application which are the name and user count.
3. The application needs to be able to open up the excel sheet and find the name in the excel spread sheet and match it with the name in the application and look for the associated user count with that name and populate the application user count with the user count in the spreadsheet every time we are sent an email with the attached spread sheet. There also need to be a condition that states if the user count is null in the excel sheet and the user count is populated then don't populate the user count in the application.
In are application we have two field which one is already populated to match the data that we have in the excel sheet that we will pull information from which is name. The other is the user count which is the data that we need to pull into are application from the excel spreadsheet using the name associated with that user count. Example if the name is Tech in the excel spread sheet and the user count for tech is 30 then are application needs to look for the name tech in are the spread sheet and match it with the name in the application then take the user count in the application and populate the user count in the application with 30. Please contact me if you have an idea about how to go about this.
Here is the process that happens:
1. First we will get an email and attached to it will be the excel csv file. Which in the excel sheet will hold 3 row of data which will be a name, ID, and User count.
2. Out of the 3 rows of data we will only need 2 of the row for the application which are the name and user count.
3. The application needs to be able to open up the excel sheet and find the name in the excel spread sheet and match it with the name in the application and look for the associated user count with that name and populate the application user count with the user count in the spreadsheet every time we are sent an email with the attached spread sheet. There also need to be a condition that states if the user count is null in the excel sheet and the user count is populated then don't populate the user count in the application.
***Moderator Edit-Vidyaranjan: Updated Platform Capability***
Pegasystems Inc.
US
I don't believe there is any OOTB process in Pega for importing data like this.
If I understand the problem correctly, I think I would try defining a class in the app with properties that correspond to the data in the CSV file, and map that class to a table in the database. Then import the data into the table using the database facilities. This gives you a class in the Pega app that has the data in place, allowing you to access the data within the app.