Is there anyway to process an incoming file into Pega, at a particular time based on a schedule?
I have a requirement where the incoming file (text format, just with an account number) could come on any day of the week, put into a shared directory, and the Pega application needs to then process it on every Monday at 6 AM.
The current Configuration that I have is a File Listener(with Service File) which processes the file as soon as it is put in the shared directory.
Here are some options I am considering, but I have some roadblocks for each of these.
1) There is an option in the Service File, to process the file asynchronously (queue for Agent). Not sure if this will work. But there is no documentation on how to really queue these items so that a Queue processor can be scheduled at a particular time to pick them up and process.
2) Read the file using the file listener as usual and store the records in a Table and later process them using a scheduled job. ---- This is extra work. I am considering this as last option.
3) Leave the File Listener as is, have the incoming file written to another temp directory. Schedule a job that can copy the file from the temp directory to the File Listener directory at the time you want the file to be picked up. --- I need to figure out how to copy the file. I also feel that if someone places a file by mistake into the File Listener directory, it can be picked up.
I have a requirement where the incoming file (text format, just with an account number) could come on any day of the week, put into a shared directory, and the Pega application needs to then process it on every Monday at 6 AM.
The current Configuration that I have is a File Listener(with Service File) which processes the file as soon as it is put in the shared directory.
Here are some options I am considering, but I have some roadblocks for each of these.
1) There is an option in the Service File, to process the file asynchronously (queue for Agent). Not sure if this will work. But there is no documentation on how to really queue these items so that a Queue processor can be scheduled at a particular time to pick them up and process.
2) Read the file using the file listener as usual and store the records in a Table and later process them using a scheduled job. ---- This is extra work. I am considering this as last option.
3) Leave the File Listener as is, have the incoming file written to another temp directory. Schedule a job that can copy the file from the temp directory to the File Listener directory at the time you want the file to be picked up. --- I need to figure out how to copy the file. I also feel that if someone places a file by mistake into the File Listener directory, it can be picked up.
4) Disable or remove File Listener. Schedule an activity, which can read and/or upload the file and then invoke the Service File that was created earlier. This would be the most ideal, since I already have the down stream processing configured, using the Service File.
5) the other extreme non-popular option could be writing a java step in a scheduled activity to read the file and process it whenever. -- want to avoid this
Please advise. Thank you