Hi,

If you want to process a CSV in some location when file is available best approach is go with File Listener

Create 3 File Listeners with each filename

And Create a Data Table and When make sure each file listener process each file and store data in Data Table (to distinguise each file data create a colume with some code)

Later write an activity to apply your logic on data.

===========================================================

Another Approach

If files are in same server location then we can achieve with pxParseExcelFile OOTB Activity

1.Create a BinaryFile Excel Template files with same properties

2. In activity set file path to property pxrequestor.pyFileUpload 

3. use  pxParseExcelFile OOTB Activity pass required parameter

Hi, for the file processing, you can use file listener. However if you have to define the order in which they need to be processed, that has to be defined inside the BPM as File Listener would pick and process as soon as the file is available.

Suggest to try out something like this:

1. Define a DB to accommodate all file contents (Normalised data?)
2. Once the file arrive, tag the data along with the file name / create separate tables for each file to store data
3. Have an Agent processing which can check if all data is received, and in order, you can work on its processing

Hope it helps.

Thanks for all your replies.

My requirement got changed - I need to retrieve the list of files from MSTeams channel and need to be processed.

have you come across the Pega- MSSharepoint integration ?

Does Pega 7.3 supports this integration?

Your help on this integration would be appreciated.

Thanks,