on 05-16-2016 7:31 PM
Hello All,
We have a requirement where we want to pick up file from File Location and dynamically post it to SAP based on the current date.
For example we have multiple folders one for each year and each one has one file for each month
2015
Jan.txt
Feb.txt
Mar.txt
Apr.txt
May.txt
Jun.txt
...
...
...
Dec.txt
2016
Jan.txt
Feb.txt
Mar.txt
Apr.txt
May.txt
If the current date is 05/01/2016 then we have to go to 2016 folder and pick up the May.txt file.
Alternatively is there a way to pass the File Name which needs to be picked ?
Thanks,
Kiran
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Bhavesh for the info. I never knew we had Integration Directory APIs. That makes PI even more powerful. What use cases have you used it ?
Also the business kind of agreed to not go with dynamic file location approach for now. But we will surely use it if we have to.
Based on latest update we have to use it. So I will be looking up blogs for it.
Appreciate your inputs.
Thanks,
Kiran
Have you considered Using an OS command before message processing in the file channel? you can write a BAT file or shell script to move the file from where PI can pick it up. its a fairly simple process instead of using a java mapping or adapter module.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Kiran!
As Bhavesh said, there is no direct way. One thought: what if to execute Operation System command before checking for a file? There you could use some OS script to move needed file to separate predefined folder and pick the file out from there.
Just as idea .
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.