tag:blogger.com,1999:blog-34020393.post322860545067872546..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: Java, XPath, XML and FacebookJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-34020393.post-19967905413609192202022-07-12T08:36:54.553-07:002022-07-12T08:36:54.553-07:00Hi Jim,
I'm trying to use XPATH for the parame...Hi Jim,<br />I'm trying to use XPATH for the parameter in the FindNodes method of the XMLDoc class. <br />This works fine:<br />Local array of XmlNode &aMessageNodes = &MessagesNode.FindNodes("Message[Body='XXXX']");<br /><br />But the upper-case function does not seem to be working:<br />Local array of XmlNode &aMessageNodes = &MessagesNode.FindNodes("Message[upper-case(Body)='XXXX']");<br /><br />I'm not that familiar with XPATH so my syntax may be incorrect. But I'm wondering if the issue is that upper-case is only supported by XPATH 2.0. If this is the case, I wonder if you'd have any workaround?<br /><br />I also tried using Translate but it didn't return anything in the array, and I can't figure out if I have a syntax issue:<br /><br />Local array of XmlNode &aMessageNodes = &MessagesNode.FindNodes("Message[translate(Body, 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')='XXXX']");<br /><br />Andyhttps://www.blogger.com/profile/13110846241603105539noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-75876266813537415012018-02-23T14:49:59.089-08:002018-02-23T14:49:59.089-08:00@Paul, unfortunately, all functions accessed throu...@Paul, unfortunately, all functions accessed through a URL must be prefixed with IScript. I believe it is a requirement to ensure security. If you have an existing function that doesn't follow this naming convention, you can write a new iScript function that invokes your existing function. Keep in mind that iScript functions do not have parameters, or return values. Input comes from %Request and output goes to %Response. For this reason, it is common to create an iScript wrapper over existing functions.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-28480513937182048202018-02-21T12:45:06.116-08:002018-02-21T12:45:06.116-08:00Hi Jim,
I've to a write a function in the web...Hi Jim,<br /><br />I've to a write a function in the weblib which is not named as Iscript_xxx, which I'm trying to access through URL. I cannot and donot want to use the function with Iscript_xxx.<br /><br />But when logged in with limited security, I was getting "Authorization Error -- Contact your Security Administrator". But when using admin user, I can able to see the function results.<br /><br />Can I know where can I assign the security to fix this error. This is not a Iscipt_xxx function which I can give access to PL's, instead, it is a regular Function (not named with pre-fix IScript_xxx) which I'm trying to access.<br /><br />Appreciate your help.<br /><br />Thank you,Anonymoushttps://www.blogger.com/profile/11249367119098953791noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-47353507481897987462012-11-27T08:12:42.639-08:002012-11-27T08:12:42.639-08:00@Mohit, I have no experience with XML Publisher. I...@Mohit, I have no experience with XML Publisher. I suggest you post your question on the <a href="https://forums.oracle.com/forums/forum.jspa?forumID=433" rel="nofollow">PeopleSoft Business Intelligence OTN Forum</a>.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-10505913154059290392012-11-27T06:04:41.295-08:002012-11-27T06:04:41.295-08:00Hi Jim,
In my xml parent and child records have th...Hi Jim,<br />In my xml parent and child records have the same fields but different values. In xml publisher, at every place it's showing only parent record values not the child one. Please let me know if we can give record.field or can use some alias for fields in XML Publisher.<br />Thanks!!Anonymoushttps://www.blogger.com/profile/11466273682128746211noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-29888393851517224512012-08-15T09:41:24.391-07:002012-08-15T09:41:24.391-07:00@Rasika, Facebook has changed a lot since I posted...@Rasika, Facebook has changed a lot since I posted this 4 years ago. Unfortunately, I don't have current example.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-15734554500029796162012-08-07T05:19:14.905-07:002012-08-07T05:19:14.905-07:00Hi Jim,
I would like to know how can we integrate...Hi Jim,<br /><br />I would like to know how can we integrate facebook with peoplesoft.<br />And what all steps I need to follow for the sameRasikahttps://www.blogger.com/profile/02034451280524947027noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-68677704916218253092011-10-25T05:38:22.848-07:002011-10-25T05:38:22.848-07:00Thanks Jim! The post is quiet helpful!Thanks Jim! The post is quiet helpful!Thathagaihttps://www.blogger.com/profile/17023268351115976445noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-27211645914995358772011-10-23T22:06:45.534-07:002011-10-23T22:06:45.534-07:00@Thathagai, I just posted this on Rest-like servic...@Thathagai, I just posted this on <a href="http://jjmpsj.blogspot.com/2011/10/rest-like-peoplesoft-services.html" rel="nofollow">Rest-like services</a>.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-52199646377034027472011-10-23T20:19:53.591-07:002011-10-23T20:19:53.591-07:00@Thathagai, The RVP for PeopleTools 8.52 says REST...@Thathagai, The <a href="https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=REFERENCE&id=1327656.1" rel="nofollow">RVP for PeopleTools 8.52</a> says REST will be in 8.52. This means that Full REST is not possible with just plain PeopleTools (verbs, HTTP status codes). If you are not planning an 8.52 upgrade, then your REST plans should consider how much REST you need. Do you just need HTTP URL's? If so, then a call into PeopleSoft could use the <a href="http://download.oracle.com/docs/cd/E18083_01/pt851pbr0/eng/psbooks/tiba/htm/tiba14.htm#g37cff77f5a85d1f8_ef90c_113e48db06c__7e0f" rel="nofollow">HTTP Listening Connector</a> with all the query string parameters, etc (look for <i>Setting Credentials in Query Strings</i>). Your PeopleSoft synchronous service operation will have an OnRequest handler to return results. If you use an Any to Local routing, then the only required query string parameter is the <b>Operation</b> parameter. Your PeopleCode service operation handler could return XML, JSON, or anything. This is actually how I do a fair amount of my Ajax.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-86145869106685560522011-10-23T07:53:56.825-07:002011-10-23T07:53:56.825-07:00Thanks for providing a way to consume REST formatt...Thanks for providing a way to consume REST formatted data but is there a way to provide data in RESTful style from peopelsoftThathagaihttps://www.blogger.com/profile/17023268351115976445noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-71221454686458184012011-09-22T13:30:36.755-07:002011-09-22T13:30:36.755-07:00Yes, that's it. Thanks, I appreciate it.Yes, that's it. Thanks, I appreciate it.Kerstinhttps://www.blogger.com/profile/05917396198982468830noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-11117084293629801032011-09-22T13:17:34.027-07:002011-09-22T13:17:34.027-07:00@Kerstin, I am not familiar with ExactTarget. Is i...@Kerstin, I am not familiar with ExactTarget. Is it the marketing solution described <a href="http://openviewpartners.com/news/facebook-collect%E2%80%99-helps-retailer-drive-multichannel-results-with-exacttarget/" rel="nofollow">here</a>? Sounds like a very good integration for PeopleSoft Applications.<br /><br />Now, how to bypass? Using the Graph API it is possible to collect a good amount of data about group members, etc. I don't have a current example. It is extremely critical, however to make sure you understand Facebook's terms of use. Last time I read them, they said you could access just about any information, you just couldn't store it.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-87121208789797903702011-09-22T13:06:12.423-07:002011-09-22T13:06:12.423-07:00Hi Jim! I am looking into launching Facebook Coll...Hi Jim! I am looking into launching Facebook Collect and wondering how I can get new data from Facebook to PeopleSoft, bypassing ExactTarget. Is it possible? Thanks!Kerstinhttps://www.blogger.com/profile/05917396198982468830noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-28956353366282110862011-09-21T13:09:13.586-07:002011-09-21T13:09:13.586-07:00@Steve, when I wrote this post, Facebook had a ver...@Steve, when I wrote this post, Facebook had a very different API. Now when I integrate with Facebook I first look at the <a href="http://developers.facebook.com/docs/plugins/" rel="nofollow">Facebook Social Plugins</a>. If one of those meets my needs, then I use the Pagelet Wizard to create a pagelet. The Pagelet design is pretty much the same as outlined in my post on <a href="http://jjmpsj.blogspot.com/2008/03/google-gadgets-for-your-peoplesoft.html" rel="nofollow">Google Gadgets</a>. Otherwise, I have to resort to the Facebook <a href="http://developers.facebook.com/docs/reference/api/" rel="nofollow">Graph API</a>.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-73756090102317784942011-09-21T12:20:51.493-07:002011-09-21T12:20:51.493-07:00Hi Jim,
I'm a PeopleSoft CRM developer, and ...Hi Jim, <br /><br />I'm a PeopleSoft CRM developer, and looking into the possibility of sending Facebook friend requests from CRM. This would have to include searching for names, etc, but sending friend request from CRM once found.<br /><br />Let me know if, from your experience with Facebook APIs, this would be a fairly straightforward solution to attempt.<br /><br />Thanks for your time and commentsStevehttps://www.blogger.com/profile/04033268926021181635noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-64203562643504774492011-07-13T08:31:31.265-07:002011-07-13T08:31:31.265-07:00@Praveen, no idea. I suggest you log a support req...@Praveen, no idea. I suggest you log a support request.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-11107935535791147462011-07-13T03:08:21.430-07:002011-07-13T03:08:21.430-07:00Hi Jim,
We are facing some issue like, whenever u...Hi Jim,<br /><br />We are facing some issue like, whenever users signing in to Peoplesoft, the left hand menu is not expanded/displaying. They can either refresh the page, or use the “-“ box to minimize and then maximize. The menu then appears correctly.<br /><br />Please give me some idea why it is happening like this.<br /><br />Thanks in Advance.<br /><br />Regards,<br />PraveenPraveenhttps://www.blogger.com/profile/08865587929527946332noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-8755536960558022372011-03-10T14:26:21.530-08:002011-03-10T14:26:21.530-08:00@Nazly, I'm not aware of anything delivered. T...@Nazly, I'm not aware of anything delivered. The current Facebook JavaScript API is fairly easy to use from PeopleSoft.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-52991507205467965172011-03-10T11:14:16.253-08:002011-03-10T11:14:16.253-08:00Hi Jim,
I am working in consulting Peoplesoft Ca...Hi Jim, <br /><br />I am working in consulting Peoplesoft Campus Solutions; I would like if you know campus has integration with facebook or another social network that Oracle had Developed. Why? For xample, an any student wants to view his grades, advance, schedule or dats from his instructor. <br /><br />Thanks so much for any help that you can give me.<br /><br />Note: Sorry, my English is not very good.<br /><br />Bibiana Córdoba<br />luna_cor@hotmail.comAnonymoushttps://www.blogger.com/profile/18087672234489596862noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-79687672719587714412009-10-27T12:38:26.221-07:002009-10-27T12:38:26.221-07:00@Blain, right, sorry. You are at a serious disadva...@Blain, right, sorry. You are at a serious disadvantage for trying to implement integration without the integration tools class. I know my response gives you some pointers, but certainly doesn't lay out the full solution. Hopefully browsing through itttoolbox and otn forums will give you enough info to piece this together.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-2118906339224973622009-10-27T11:57:54.859-07:002009-10-27T11:57:54.859-07:00Thanks Jim. I would love go the University lack o...Thanks Jim. I would love go the University lack of funds like everyone else.Unknownhttps://www.blogger.com/profile/17807988868464403807noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-74507326856798018242009-10-23T13:48:46.564-07:002009-10-23T13:48:46.564-07:00@blain, I assume your third party has an HTTP list...@blain, I assume your third party has an HTTP listener? If so, then you create a new node for your third party system and set it's connector to HTTPTARGET. Set the HTTP properties accordingly. When you publish a message from a PeopleSoft component, the integration broker will use the HTTPTARGET to communicate with the third party.<br /><br />What version of PeopleTools are you using? If you are using PT 8.48 or higher, create a service, service operation, and routing rules, etc. If you are using PT 8.47 or lower, use node transactions to specify which messages a node should receive.<br /><br />You can allow PeopleSoft to publish a structured message and then use a transform program registered on the PT 8.48 routing or PT 8.47 relationship. A transform program uses XSL or PeopleCode or both to change the shape of an XML document.<br /><br />I know this isn't a full example, but hopefully it is enough to get you started. The Oracle University PeopleSoft Integration Tools class describes this in detail.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-42561674011252325202009-10-23T12:26:40.974-07:002009-10-23T12:26:40.974-07:00Jim
We are in the discovery stages Integration Br...Jim<br /><br />We are in the discovery stages Integration Broker. What we need to do is setup asynchronous messaging between our PeopleSoft 8.9 (tools 8.48.9) HRMS and a third party system. My research has lead me to believe that I use Nonrowset-based messages and use the XMLDoc and Operation classes to accomplish this. My problem...I can't find any examples of how to set these messages up. Can you give some code examples to accomplish sending a message to a third party?<br /><br />Thank you<br />BlainUnknownhttps://www.blogger.com/profile/17807988868464403807noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-8492332745278346472008-12-10T09:14:00.000-08:002008-12-10T09:14:00.000-08:00@Stephen, good question. To create Facebook users,...@Stephen, good question. To create Facebook users, Facebook would need to expose an API for creating users. I am not aware of one. Generally speaking, free sites like Facebook, GMail, etc, don't allow automated account creation to avoid spam and other malicious uses.<BR/><BR/>If you have a Facebook account, can you use PeopleSoft to update HR data? Absolutely. Just use the Facebook API. I prefer FQL. You can find the Facebook API at <A HREF="http://developers.facebook.com/" REL="nofollow">http://developers.facebook.com/</A>.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.com