Posted by [IP Address: 207.82.165.244] 'Sivaram' on August 17, 2001 at 01:22:51 EST:
In Reply to: Interface between PS 7.5 and Third Party Tools - Urgent posted by [IP Address: 207.82.165.244] 'Vimi' on August 14, 2001 at 06:20:46 EST:
Hi,
1. For you to insert something to Peoplesoft when something happens in third party system the only way to go about is the message agent , If you want online. If it is a batch you can use SQR process to do this.I hope you know about Message agent. This is basically you call the API's supplied.If you need more infor on this let me know.
2.In peoplesoft 7.5x the only way this could happen is by calling a Exec function from Savepostchg peoplecode event.
As you said you can call a Java program from the savepostchg event.
Example.
Call a sample.bat file from the savepost chg event which contains the java executable something like this.
java sample.class &EMPLID,&EFFDT
call the bat file like this,
&command = "Sample.bat " | &emplid | , | &EFFDT;
&Result = Exec(&command,False);
( I hope you know the exec command )
If you are running 3 tier you can specify a server directory else client.
Yes, You have to have this in all online panels which needs this functionality.You can keep this as a function and call it from all the other online panels.
I hope I have answered you questions. If you need more infor let me know.
: Hi there-
: We are trying to build a generic interface between Peoplesoft 7.55 and a third party tool...We need to do following two things:
: 1. We need to perform operations like Insert / Update / Delete on Peoplesoft tables when these operations happen in the third party tool...So want to know the APIs which should be used for the same so that the above operations are taken care of.
: 2. When and event of Insert / Update / Delete is performed on Peoplesoft, want to send the object type, primary keys and the operation performed (I / U/ D) to the third party. This will be done on on-line entries only...Want to know here I could call some Java method from Peoplecode so that i could write code on all the panels on savePostchg or so to trap the events.
: Or if you know of some better method for any of the above, pl. do lemme know. I'm urgently looking for some solution.
: Thanks for all the help.
: Pl. mail me at the following e-mail id:
: vimin@india.infogain.com
: vimi.nijhawan@signaltreesolutions.com