Ned Shryock posted Message 53 in Message Board Dated : February 24, 1999 at 14:02:47 EST Subject: Payroll and BaaN IV Mfg Is anyone using PeopleSoft Payroll and BaaN IV Manufacturing? We are considering this combination and want to link PS - Time and Attendance to BaaN IV hours accounting. I understand we could run seperatley but is anyone actually doing this and if so what has been your experience? Thank you, ***************** End Of Article ****************** Marko posted Message 54 in Message Board Dated : February 24, 1999 at 17:38:40 EST Subject: MS Word integration with PeopleSoft I am told that Peoplesoft comes with the ability to provide data to MS Word for purposes of mail merge, etc. Does Peoplesoft support WordPerfect? Thanks! ***************** End Of Article ****************** kalyan posted Message 55 in Message Board Dated : February 24, 1999 at 20:47:10 EST Subject: Re: external interface to PS AP v7 with one-time vendors we did this in public sector version 7.0 we first loaded all the vendors into PS as onetime vedors from the flat file and then loaDED vouchers against those vendors from the same flat file in the same order and the trick is u have to inactive that vendor once u load the voucher against him and then and only then u should load the next voucher against next vendor but the whole thing can be done from one flatfile and one sqr. : Chris, : We are having the exact same requirement : set up a one time Vendor from a legacy system, and also populate a related voucher to PS AP. If you get any solution not requiring a non trivial SQR, I would love to hear it ! : Will also let you know, of our final solution. : Thanks, : Vikram Muratee : 846-866-3177 : at Rotary International : Evanston, IL : vmuratee@yahoo.com : : : : : We are attempting to interface a file from an external system to our PS AP system. The file contains refund information for one-time vendors (for out-of-stock items etc.) that need to be paid via AP. This file is processed via EDI and the "VCHR" template (v.7) The problem is, these one-time vendors are not set up in the AP vendor tables before the refund file goes against it. The users want us to setup the vendors on the fly as this file is being processed. However, there are no EDI templates for "vendor", and we are faced with writing a nontrivial SQR to accomplish this. We'd really like to avoid "reinventing the wheel", so if anybody out there in PeopleSoftLand has any ideas, SQRs, etc on this subject, we'd be most appreciative! (We'll even buy you lunch next time you're in Dallas!) : : Thank you in advance : : Chris Richter, Sr. Analyst : : Boy Scouts of America, Natl. HQ : : 972.580.2551 : : crichter@netbsa.org ***************** End Of Article ****************** Mike Dybis posted Message 56 in Message Board Dated : February 25, 1999 at 07:29:40 EST Subject: Re: MS Word integration with PeopleSoft The way PeopleSoft interfaces to MS Word is a two step process. First, there is an SQR to extract the data from the appropriate tables and format an ASCII file to be used by the MS Word mail merge process. Second, there is a MS Word template with a macro attached that reads the ASCII file and performs the mail merge process. I'm not familiar with WordPerfect so I'm not sure if a similar process could be performed. Hope this helps. : I am told that Peoplesoft comes with the ability to provide data to MS Word for purposes of mail merge, etc. Does Peoplesoft support WordPerfect? : Thanks! ***************** End Of Article ****************** dw posted Message 57 in Message Board Dated : February 26, 1999 at 12:20:27 EST Subject: Re: Message Agent API Calls from Java? The 99 limit is not how many requester can be serviced but how many services are handling requests. The message agent uses the "Burger King" queuing method where requests are serviced by a pool of services. Even one service handler could eventually handle 100,000 requests but if you had one request that was long, you could cause the others to wait. Think about it the next time you're in McDonalds :-) ***************** End Of Article ****************** Stan posted Message 58 in Message Board Dated : February 26, 1999 at 15:14:56 EST Subject: RE: Web API now available I have an API dll that can hook up a web page to PeopleSoft's Application. Anyone that would like to try it out. I have a demo version for $99. The Full version with docs and examples is $10,000. ***************** End Of Article ****************** Hector Ramirez posted Message 59 in Message Board Dated : March 01, 1999 at 13:11:44 EST Subject: Re: Inventory Interface : Hi Al, : Is anybody out there is working on Inventory Interface for Peoplesoft 7.5?? If yes let me share the knowledge : : Venu ***************** End Of Article ****************** Marco L. Rivera posted Message 60 in Message Board Dated : March 01, 1999 at 16:11:24 EST Subject: Signed numbers in SQR? Anyone know how to output a Cobol signed number in SQR to a flatfile??? Thanks. ***************** End Of Article ****************** Mike Dybis posted Message 61 in Message Board Dated : March 02, 1999 at 06:04:02 EST Subject: Re: Signed numbers in SQR? Check the SQR user group website for suggestions or to pose the question. The URL is WWW.SQRUG.COM. I've found alot of good technical tips and suggestions there. : Anyone know how to output a Cobol signed number in SQR to a flatfile??? : Thanks. ***************** End Of Article ****************** Hartono Sutirman posted Message 62 in Message Board Dated : March 02, 1999 at 22:52:55 EST Subject: Interfacing to other Database I'm using Oracle database 7.3.3 for peoplesoft 7.0 Asia Pasific Version and I need to read and write to another Oracle Database 7.3.3 that used by Oracle Application 10.7 Can peoplesoft read and write the tables from another oracle database ?? thanks in advance ***************** End Of Article ****************** Cheryl Stine posted Message 63 in Message Board Dated : March 05, 1999 at 08:22:23 EST Subject: Message Agent I am trying to update an effective dated panelgroup via the message agent (from a VB app). I can add new rows and update data on existing rows (in correction mode). I want to be able to change the effdt field on an existing row in correction mode just like you can do directly on the panels. When I try, it simply adds a new row. Does anyone know if this possible to do, and if so, what are the details I need to have (API calls, msg definition settings). Thanks! Cheryl Stine ***************** End Of Article ****************** Daytona posted Message 64 in Message Board Dated : March 10, 1999 at 20:28:45 EST Subject: PeopleSoft G/L ***************** End Of Article ****************** Rob Collins posted Message 65 in Message Board Dated : March 11, 1999 at 16:54:10 EST Subject: external interfaces to PS Billing module We are preparing to implement the PS Billing module (version 7), and would like to know if anyone out there has had any experience with interfacing external "legacy" data. Thank you very much! ***************** End Of Article ****************** SHANKAR posted Message 66 in Message Board Dated : March 18, 1999 at 02:46:03 EST Subject: Alliance solution center Dear Fans, I was told that there is quite a lot of info on Message Agents and Interfacing with VB kind of stuff in PeopleSoft Aillance Solution Center web site - but could not find anything in that sight - do i have to have a customer connection to download some thing. please advice me cheers ***************** End Of Article ****************** DW posted Message 67 in Message Board Dated : March 18, 1999 at 13:27:52 EST Subject: Re: Alliance solution center Here you go... URL is http://www4.peoplesoft.com/allconn/stsbenchm.nsf/d7007f3c3f166fe988256658005b3275/157e6d56657dc9b5882566b8007fd9ac?OpenDocument ***************** End Of Article ****************** Anh posted Message 68 in Message Board Dated : March 24, 1999 at 07:20:57 EST Subject: Re: Interfacing to other Database : I'm using Oracle database 7.3.3 for peoplesoft 7.0 Asia Pasific Version : and I need to read and write to another Oracle Database 7.3.3 that used by Oracle Application 10.7 : Can peoplesoft read and write the tables from another oracle database ?? : thanks in advance As long as you have DB Links set up appropriately, you should be able to access these databases from SQL PLus. ***************** End Of Article ****************** Dennis Gross posted Message 69 in Message Board Dated : March 24, 1999 at 16:51:20 EST Subject: SQL Server Accessibility I have a very strange problem on my PC. We basically use 2 databases, a production database (lets call it PROD), and a development database (DEV). I am able to log in to PROD via PeopleTools; when I try to log in to DEV i get the following error message: "SQL Error. Stmt #2 Error Position: 0 Return: 8200 - Cannot connect to requested database". I am able to access both databases in SQL Server 6.5, our backend. I am also able to access both databases from another PC. its only my PC that has this problem. I've checked all the configuration files against our standard config and everything seems to match. Can someone help? ***************** End Of Article ****************** Gavin John Fowler posted Message 70 in Message Board Dated : March 25, 1999 at 06:13:17 EST Subject: Re: SQL Server Accessibility Can you get into the DB from ISQL ? From another ODBC aplication - eg MS Query32 ? Are both DB's on the same server ? ***************** End Of Article ****************** shankar posted Message 71 in Message Board Dated : March 25, 1999 at 06:41:55 EST Subject: Run reports using Message agents Dear Friends, I am using Message Agent APIs in my c and c++ program to do panel level operations is it possible to run a report as we do from our panels ( clicking the run button) using messageagent from an external C program. Please help ASAP thanks ***************** End Of Article ****************** Dennis Gross posted Message 72 in Message Board Dated : March 25, 1999 at 08:14:25 EST Subject: Re: SQL Server Accessibility : Can you get into the DB from ISQL ? From another ODBC aplication - eg MS Query32 ? : Are both DB's on the same server ? Yes, I can get into the DB from ISQL and perform queries on them both (I'm not sure about MS Query32?) Both databases are on the same server. ***************** End Of Article ****************** Altan Khendup posted Message 73 in Message Board Dated : March 28, 1999 at 20:09:37 EST Subject: Re: SQL Server Accessibility The error looks to be a connectivity problem in the ODBC connections. I am assuming you are trying to connect in 2-tier mode. If it's 3-tier mode you need to check your settings in the Configuration Manager to validate the information there. Remember that for 2-tier connectivity, Peoplesoft uses the ODBC drivers to connect (coupled with the MS Sql client libraries). Since you've identified that it is only with your PC, here is a quick list of things to check: * Do you have a valid ODBC entry? Make sure everything is set per the manual. * If you have a valid ODBC entry does it work using the MS Query or MS Access? This is the quickest way to see if the ODBC driver is setup properly. If you can connect to the database using either Access or Query then Psoft should work. If in 3-tier mode check the Configuration Manager for: * Proper hostname * Proper DB Paths * Proper Port #'s After verifying all of these things you'll find your answer. I'd bet it's something in the ODBC drivers. HTH and good luck! ***************** End Of Article ****************** Gavin John Fowler posted Message 74 in Message Board Dated : March 31, 1999 at 02:07:29 EST Subject: Re: SQL Server Accessibility Network OK ? Slow networks can give timeouts which MAY manifest themselves under various guises. Have youtried Trace ? ***************** End Of Article ****************** K.Ranapratap posted Message 75 in Message Board Dated : April 01, 1999 at 18:33:38 EST Subject: conversion of data from legacy systems to Peoplesoft The data from the legacy systems is to be loaded in to the Peoplesoft. Is there any document prepared by the Peoplesoft which gives all the list of tables and fields group by say vendor info, customer info. , item info., ledger info. Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Steve Foley posted Message 76 in Message Board Dated : April 05, 1999 at 14:52:06 EST Subject: Re: conversion of data from legacy systems to Peoplesoft Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Dave Gordon posted Message 77 in Message Board Dated : April 06, 1999 at 10:30:01 EST Subject: Re: conversion of data from legacy systems to Peoplesoft Hi Steve, I think you mean Import Manager. SQA robot is an automated testing tool - it's used to run test scripts. Import Manager is slow, but it does a good job of applying the same edit rules you'd apply if the data was entered by hand. This isn't always necessary, though. A lot of folks use SQR and SQL scripts, various delivered RDBMS tools and third-party tools to directly populate the database. It requires some knowledge of how the system actually operates, but in many cases, it's the only way to get the data into the system in a reasonable amount of load time. Regards, Dave : Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Gary Flynn posted Message 78 in Message Board Dated : April 06, 1999 at 14:32:19 EST Subject: Re: Interface to C++ module ? : If that is the case, Any idea about, how to invoke a C++ executable from PeopleSoft(PeopleCode !!)with some parameters and retrieve back some values that executable returns, into PeopleSoft(Panel !!) ?? Have you looked at the Exec, Winexec, and Declare Peoplecode statements? ***************** End Of Article ****************** Gary Flynn posted Message 79 in Message Board Dated : April 06, 1999 at 14:45:01 EST Subject: External Authentication Questions I'm looking at ways to use external authentication mechanisms with Peoplesoft. 1) Is the DataMover Encrypt_Password the only way to encrypt the operID password? 2) If PSAUTH fails when validating the operID and password from the workstation and I return TRUE from PsTuxAuthExit will the login succeed? (assuming I validate the operID exists in PSOPRDEFN and authenticate externally) thanks! ***************** End Of Article ****************** Hugh Jass posted Message 80 in Message Board Dated : April 09, 1999 at 16:04:14 EST Subject: Re: conversion of data from legacy systems to Peoplesoft As a matter of fact in Peoplebooks you will find a section called "Tables Loading Sequence" and this should give you an idea of what tables and fields are required for data conversion. ***************** End Of Article ****************** Reagan Lee posted Message 81 in Message Board Dated : April 11, 1999 at 14:03:34 EST Subject: Re: conversion of data from legacy systems to Peoplesoft Dave, Steve actually has a point. SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. First you record a script loading one record. On your script, you replace any number of values with variables. You tell define the order in which these variables are stored in a comma-delimited file. Create a loop on the script. Reference the import file in the script. The next time you run your script it will insert your import file values where you defined variables. It's almost like a super-human performing data entry. The script loops through all lines on your import file. For a small amount of records (but too much to enter manually), this is a good alternative especially when you don't want to figure out the tables and edits that are involved. I have used this to load vendor and customer information. It works, but the data must be clean. Otherwise, the script will stop in the middle and you must determine where to restart. It means you have to modify the import file to start at the correct row on the file. Hope this helps. : Hi Steve, : I think you mean Import Manager. SQA robot is an automated testing tool - it's used to run test scripts. : Import Manager is slow, but it does a good job of applying the same edit rules you'd apply if the data was entered by hand. This isn't always necessary, though. A lot of folks use SQR and SQL scripts, various delivered RDBMS tools and third-party tools to directly populate the database. It requires some knowledge of how the system actually operates, but in many cases, it's the only way to get the data into the system in a reasonable amount of load time. : Regards, : Dave : : Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : : : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Dave Gordon posted Message 82 in Message Board Dated : April 13, 1999 at 10:58:27 EST Subject: You Learn Something New Every Day :SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. Hi Reagan, That's an interesting technique; however, I think I'd rather stick with Import Mangler for small, clean data sets. I don't mind looking behind the panels to figure out which tables are being loaded, and I usually drop to a SQL prompt and do a "select count(*)" to ensure all the data got loaded. However, I'm also a belt, suspenders, velcro and superglue kinda guy ... Regards, Dave ***************** End Of Article ****************** Chris Richter posted Message 83 in Message Board Dated : April 19, 1999 at 09:13:00 EST Subject: 1099-Rs Has anyone out there ever modified their PeopleSoft AP system to generate 1099-Rs? We did it years ago on our mainframe system by cloning and modifying the 1099-MISC process, and are contemplating doing the same with PeopleSoft. If anyone out there has already done this and would be willing to share info with us, it would be greatly appreciated! Thanks ***************** End Of Article ****************** Reagan Lee posted Message 84 in Message Board Dated : April 23, 1999 at 01:22:08 EST Subject: Re: 1099-Rs : Has anyone out there ever modified their PeopleSoft AP system to generate 1099-Rs? We did it years ago on our mainframe system by cloning and modifying the 1099-MISC process, and are contemplating doing the same with PeopleSoft. If anyone out there has already done this and would be willing to share info with us, it would be greatly appreciated! Thanks Hi Chris, I can share with you how we did it. It is definitely not the recommended method but it worked and made our AP supervisor very happy. First we ran the normal 1099 processes except for printing. We wanted to print on a standard 1099 sheet with three forms. Then, we created a query joining VENDOR_1099 with M1099_BALANCE. The query was output to Excel where we had the flexibility to add/remove rows or modify the information. Why? Because we implemented mid-year and did not convert vendor balances from our legacy system. We could have given the vendor two forms from two systems, but that would have confused our vendors. We mailed merged this data into a Word document that had the fields laid out like the form. We had complete control on how it printed. Of course, we only had a few hundred vendors that were sent 1099, so this process wasn't too cumbersome. If you need more specifics, feel free to send me an email at rwklee@yahoo.com. Hope this helps. ***************** End Of Article ****************** Giri Vissa posted Message 85 in Message Board Dated : April 24, 1999 at 11:02:25 EST Subject: Re: conversion of data from legacy systems to Peoplesoft To estimate data conversion effort, any useful parameters? From Table loading sequence peoplebook, we can find out the number of required and optional tables to load. For example, Public Sector HRMS 7 has around 500 required+optional tables. Based on this number can we arrive at useful effort estimates for data conversion? Giri : Dave, : Steve actually has a point. SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. : First you record a script loading one record. On your script, you replace any number of values with variables. You tell define the order in which these variables are stored in a comma-delimited file. Create a loop on the script. Reference the import file in the script. The next time you run your script it will insert your import file values where you defined variables. It's almost like a super-human performing data entry. The script loops through all lines on your import file. : For a small amount of records (but too much to enter manually), this is a good alternative especially when you don't want to figure out the tables and edits that are involved. : I have used this to load vendor and customer information. It works, but the data must be clean. Otherwise, the script will stop in the middle and you must determine where to restart. It means you have to modify the import file to start at the correct row on the file. : Hope this helps. : : Hi Steve, : : I think you mean Import Manager. SQA robot is an automated testing tool - it's used to run test scripts. : : Import Manager is slow, but it does a good job of applying the same edit rules you'd apply if the data was entered by hand. This isn't always necessary, though. A lot of folks use SQR and SQL scripts, various delivered RDBMS tools and third-party tools to directly populate the database. It requires some knowledge of how the system actually operates, but in many cases, it's the only way to get the data into the system in a reasonable amount of load time. : : Regards, : : Dave : : : Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : : : : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Giri Vissa posted Message 86 in Message Board Dated : May 03, 1999 at 05:34:29 EST Subject: Implementing Student Admin w/o PS Financials Universities are implementing integrated administrative systems using PeopleSoft packages for Higher Education and Financials. In terms of implementation options, what are the disadvantages of implementing the Student Admin modules in the Higher Education package without implementing PeopleSoft Financials? Giri ***************** End Of Article ****************** Kirsten posted Message 87 in Message Board Dated : May 04, 1999 at 16:17:56 EST Subject: Tips on Message Agent I am going to write an interfacebetween Peoplesoft and an external system. What design issues should I consider in the begining??? I am planning to use C APIs. Thanx in advance. Bye, Gary. ***************** End Of Article ****************** Brian Hundt posted Message 88 in Message Board Dated : May 11, 1999 at 18:50:43 EST Subject: Billing Interface I'm currently in the process of building an interface from a package called 'Interworld' to the PeopleSoft Billing module. Has anyone had any experience with this or something similar to it? Thanks. ***************** End Of Article ****************** Rohit posted Message 89 in Message Board Dated : May 13, 1999 at 15:06:45 EST Subject: Re: Run reports using Message agents : Dear Friends, : I am using Message Agent APIs in my c and c++ program to do panel level operations is it possible to run a report as we do from our panels ( clicking the run button) using messageagent from an external C program. : Please help ASAP : thanks Shankar, I think I might have a work around for you. Assuming that your reports are run through the Process Scheduler : 1.Put a derived work record field on the panel you are working on. 2. At FieldChange event, write peoplecode that invokes the process scheduler (ScheduleProcess command). 3. When you enter data into the panel, pass a value to the derived record field so that FieldChange is triggered. 4. You will have to map this field too in the MessageAgent definition. Preferable keep it as the last field to map so that the process is triggerred after the values are passed. Voila - you should have your results. All the best. ***************** End Of Article ****************** Pedro Garcia posted Message 90 in Message Board Dated : May 13, 1999 at 17:04:47 EST Subject: Re: PeopleSoft calling function in C/C++ DLL : Is there a way for PeopleSoft to call a C or C++ function : in a Windows DLL? ***************** End Of Article ****************** C. Hanel posted Message 91 in Message Board Dated : May 21, 1999 at 14:06:48 EST Subject: Re: PeopleSoft opening its APIs : Hello. I'm a reporter with InfoWorld Magazine, working on a story that PeopleSoft plans to open its APIs for third-party developers to create better integration interfaces -- somewhat the way SAP announced last fall that it was opening its BAPIs. We've got confirmation from PeopleSoft that they're doing this, but not a lot of details yet on how this will work. What would open PeopleSoft APIs mean to you? Do you consider this news important? Feel free to post a message or call me at (650) 525-3465. Thank you. ***************** End Of Article ****************** C. Hanel posted Message 92 in Message Board Dated : May 21, 1999 at 14:29:27 EST Subject: Re: PeopleSoft opening its APIs (and ending M.A. support?) Along the same lines, I've heard the the Message Agent will 'not be supported' in the future. I'm assuming PS wouldn't go there until they actually publish some APIs, but what does that do to third party developers (SeekerSoft, Advis, etc.)? We're in the process of figuring out a way to integrate multiple backends (PS, Tesseract, Restrac, etc.) into a cohesive front-end (maybe web, maybe VB or some combo). Reverse engineering and doing updates direct to the PS DB is dangerous and unsupported, and with no APIs, near as I can tell all you have to work with is the Message Agent. If it's going away, soon, I don't want to start developing to it now. So...does anyone know when PS actually plans to publish some APIs? : Hello. I'm a reporter with InfoWorld Magazine, working on a story that PeopleSoft plans to open its APIs for third-party developers to create better integration interfaces -- somewhat the way SAP announced last fall that it was opening its BAPIs. We've got confirmation from PeopleSoft that they're doing this, but not a lot of details yet on how this will work. What would open PeopleSoft APIs mean to you? Do you consider this news important? Feel free to post a message or call me at (650) 525-3465. Thank you. ***************** End Of Article ****************** Rob Collins posted Message 93 in Message Board Dated : May 25, 1999 at 16:20:38 EST Subject: Re: 1099-Rs : : Has anyone out there ever modified their PeopleSoft AP system to generate 1099-Rs? We did it years ago on our mainframe system by cloning and modifying the 1099-MISC process, and are contemplating doing the same with PeopleSoft. If anyone out there has already done this and would be willing to share info with us, it would be greatly appreciated! Thanks : : Hi Rob, : I can share with you how we did it. It is definitely not the recommended method but it worked and made our AP supervisor very happy. : First we ran the normal 1099 processes except for printing. We wanted to print on a standard 1099 sheet with three forms. Then, we created a query joining VENDOR_1099 with M1099_BALANCE. The query was output to Excel where we had the flexibility to add/remove rows or modify the information. Why? Because we implemented mid-year and did not convert vendor balances from our legacy system. We could have given the vendor two forms from two systems, but that would have confused our vendors. : We mailed merged this data into a Word document that had the fields laid out like the form. We had complete control on how it printed. Of course, we only had a few hundred vendors that were sent 1099, so this process wasn't too cumbersome. : If you need more specifics, feel free to send me an email at rwklee@yahoo.com. : Hope this helps. ***************** End Of Article ****************** David Thompson-Hall posted Message 94 in Message Board Dated : May 26, 1999 at 15:44:41 EST Subject: Re: Message Agent API Calls from Java? I would add that the question of how many services to run on your application server is a tricky one, but if you do know your user load, it's not too bad. For instance, say you do have 100 users concurrently. If you start up 10 instances of the Message Agent, then in theory each person is waiting in a line with 10 others. (All the setup for this is done using the Tuxedo manager on your Application server. I'm not clear on the issue of Load balancing and the like, but I can tell you that PS does a nice seminar called "3 Tier Seminar" where they review this stuff on a technical level - a good place to send your DBAs or whomever is doing ongoing support for your Application Server...) : The 99 limit is not how many requester can be serviced but how many services are handling requests. The message agent uses the "Burger King" queuing method where requests are serviced by a pool of services. Even one service handler could eventually handle 100,000 requests but if you had one request that was long, you could cause the others to wait. Think about it the next time you're in McDonalds :-) ***************** End Of Article ****************** Jorge Zavala posted Message 95 in Message Board Dated : May 27, 1999 at 22:33:32 EST Subject: Re: Message Agent limitations DO somebody has any experience integrating Peoplesoft with Microsoft Exchange Server. I want to sent some information gather in a Exchange Electronic Form to store into a workflow procees within Peoplesoft ***************** End Of Article ****************** John Theobald posted Message 96 in Message Board Dated : June 15, 1999 at 15:27:19 EST Subject: Re: Run reports using Message agents You can also use the PeopeSoft OpenQuery API. This API was designed to allow you to run PeopleSoft queries from 3rd party programs. It works great from VB, VBA, and C++. Check out your PeopleBooks for further information. ***************** End Of Article ****************** Allan Young posted Message 97 in Message Board Dated : June 15, 1999 at 15:43:23 EST Subject: Need an Interface? Contact me if you would like more information on an incredible interface engine that is currently going to market. it's less expensive than you would think and uses PeopleSoft as it's baseline. It can be customized to meet you're specific organizations interface needs. Email me or call at 404-238-0579. ***************** End Of Article ****************** Allan Young posted Message 98 in Message Board Dated : June 15, 1999 at 15:46:55 EST Subject: Re: Tips on Message Agent Have you started your interface? I know several awesome developers who can help your company write an outstanding interface at a very low cost. Contact me if interested -Allan Young, IT Agent, Inc 404-238-0579 : I am going to write an interfacebetween Peoplesoft and an external system. What design issues should I consider in the begining??? I am planning to use C APIs. : Thanx in advance. : Bye, : Gary. ***************** End Of Article ****************** steve posted Message 99 in Message Board Dated : June 17, 1999 at 06:41:41 EST Subject: Volume batch input from Unipay(payroll system) to HRMS - any advice Volume batch input from Unipay(payroll system) to HRMS : - We are going to have a sizeable batch interface from our payroll system to Peoplesoft HRMS approx 1000 starters/leavers per week plus 1000's of changes The interface need to run overnight each 24 hours the intention at the moment is to write this interface utilising SQL/SQR Is it better to attempt to update all of the databases ie personel, employment, job, etc in a single hit (sqr) , or in seperate processes ? Has anyone got any general advice ? ***************** End Of Article ****************** steve posted Message 100 in Message Board Dated : June 17, 1999 at 09:50:32 EST Subject: Volume batch input from Unipay(payroll system) to HRMS, advice wanted Volume batch input from Unipay(payroll system) to HRMS : - We are going to have a sizeable batch interface from our payroll system to Peoplesoft HRMS approx 1000 starters/leavers per week plus 1000's of changes The interface need to run overnight each 24 hours the intention at the moment is to write this interface utilising SQL/SQR Is it better to attempt to update all of the databases ie personel, employment, job, etc in a single hit (sqr) , or in seperate processes ? Has anyone got any general advice ? ***************** End Of Article ****************** John Eaton posted Message 101 in Message Board Dated : June 17, 1999 at 15:07:50 EST Subject: VBScript I am trying to call ProcessMessage function in the message agent from my VBScript web page. The function takes a long*. I dim a variable and then pass it and I get a type mismatch. Even with I try to convert my variable with CLng I still get the error. Anyone have any suggestions. Thanks ***************** End Of Article ****************** Filip Hanik posted Message 102 in Message Board Dated : June 24, 1999 at 16:52:15 EST Subject: Re: VBScript Try this Dim nReplyOption& Dim Mag As CMagAutoServer Dim Result As Variant Set Mag = CreateObject("PeopleTools.MessageAgent") Result = Mag.StartMessage("ACT_AGT", "AgentList", False) Result = Mag.ProcessMessage(nReplyOption) That should work : I am trying to call ProcessMessage function in the message agent from my VBScript web page. The function takes a long*. I dim a variable and then pass it and I get a type mismatch. Even with I try to convert my variable with CLng I still get the error. Anyone have any suggestions. : Thanks ***************** End Of Article ****************** Van posted Message 103 in Message Board Dated : June 26, 1999 at 12:24:46 EST Subject: Re: Conversion Hi, Well the first time we did the conversion at my company(PS VER 7.5), we used SQL*Loader for loading flat file into Temporary Table. Then, we uses PL/SQL to create store procedure wich is doing some manipulating data from Temporary table before insert into PeopleSoft Table. I had try out Import Manager, but we encouter some problem for some of the table like PS_JOB, we uses Import Manager as a tools for validating our Data only. thats what we did. Thanks Van : :SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. : Hi Reagan, : That's an interesting technique; however, I think I'd rather stick with Import Mangler for small, clean data sets. I don't mind looking behind the panels to figure out which tables are being loaded, and I usually drop to a SQL prompt and do a "select count(*)" to ensure all the data got loaded. However, I'm also a belt, suspenders, velcro and superglue kinda guy ... : Regards, : Dave ***************** End Of Article ****************** miki,kudo posted Message 104 in Message Board Dated : June 28, 1999 at 12:51:37 EST Subject: Interfacing PS with Credit Card Authoristion Software ICVERIFY I need some help for developing interface for Peoplesoft Distribution module with ICVERIFY, a Credit Card Authoristion Software I have written SQR for reading the data, But I need some ones guidance to finish the job like Scheduling, files directory, etc, It will be of great help if some one gives their guidance at the earliest thank you ***************** End Of Article ****************** Meena Sinha posted Message 105 in Message Board Dated : June 29, 1999 at 14:33:45 EST Subject: Re: General Ledger Interface for HR using SQR : Hi, I am interesed in your package as I am currently working on G/L interface SQR for a public school : I have developed a module, which can be added to the HR package of Peoplesoft, which creates General Ledger interface files for posting into Accounts. : It can be run by the end-user. It runs using SQR, and one main feature is its flexibility, meaning Account Codes can be changed on-line for immediate effect. It also takes care of Accruals. Also, you can run GLs for multiple paygroups in the batch mode. : If anybody is interested in the package, please email me at 'sbhowmik@juno.com' : Thanx. : - sb. ***************** End Of Article ****************** GP posted Message 106 in Message Board Dated : July 02, 1999 at 10:24:08 EST Subject: GL Interface-Public Sector product v7.5 The Budget Encumbrances and the GL Interface Module are used to facilitate flow of data to and from GL. The Deduction Tables, earnings tables and other tables use Account Numbers (and not account codes [a combination of chartfields] that are pulled in from GL by running a process). Are account Numbers extracted from the account codes? If not, does finance provide these account numbers? Any ideas on this issue? ***************** End Of Article ****************** Kalyan posted Message 107 in Message Board Dated : July 05, 1999 at 12:32:21 EST Subject: Interface Techniques Dear Friends, In SAP whn u want to import data from a flat file (Legacy system file),we use the BDCs,which go thru the SAP screens/transactions and then update the database.Similarly,How does it happen in PeopleSoft?In peopleSoft,we r told that the tables(called Records in PS) r updated directly.But a screen (called a Panel in PS)may contain more than one table.Pl. throw some light on this issue. I request u all to pl. give the process in Detail ASAP. Thanx, Kalyan ***************** End Of Article ****************** Anthony Wilson posted Message 108 in Message Board Dated : July 05, 1999 at 19:05:12 EST Subject: Import Manager In PeopleSoft this is accomplished in a variety of ways. If I understand your requirements, though, you want the data to be edited as it is imported. There are basically two ways to import data into the PeopleSoft system, while still using the edits that have been applied to a record definition - Import Manager and Message Agent. Which one you choose depends on your actual requirements. The Import Manager updates one specific record with the data from a flat file. This flat file can be applied to more that one record, but the different records will not be updated at the same time. The data will be edited with non-panel specific edits. The advantage of the Import Manager is that it is very easy to set up and execute. The disadvantage is that only one record can be updated at a time, if the file being imported contains multiple dependencies, this method may not work. NOTE: This is most useful during conversions. The Message Agent updates the PeopleSoft system through the use of Message Forms. These forms are designed to comply with the requirements of the actual panel group they are updating. This method allows you to update multiple records through the use of panel definitions. The advantage of the Message Agent is that it actually performs as though a user where entering the data through a panel. The disadvantage is that this requires allot of set up and testing. NOTE: Don't use this method for one time only solutions. If neither of these solutions will work for your particular problem, you will probably need to create an SQR program. The advantage of SQR programs is that they are easy to create and test and they allow a maximum of flexibility and control. NOTE: You will you the method for most of you external interfaces. I hope this helps, Anthony Wilson ***************** End Of Article ****************** tul posted Message 109 in Message Board Dated : July 07, 1999 at 13:16:07 EST Subject: Application System Download Dear friends, Pl. help in the following: How do you extract an application system without data? How do you extract an application system with data? Regards Tul ***************** End Of Article ****************** Mark Tuente posted Message 110 in Message Board Dated : July 13, 1999 at 09:37:13 EST Subject: Re: conversion of data from legacy systems to Peoplesoft There are tools who take care of these things. SmartDB for example has put all the application logic and constraints into their product. Have a look at www.smartdb.com. They might help you with your problem. ***************** End Of Article ****************** ZJS posted Message 111 in Message Board Dated : July 13, 1999 at 10:31:36 EST Subject: Posting to external GL system We are implementing HR/BEN/PAYROLL 7.5 and maintaining our external financials system. Are there any PeopleSoft programs that may be a good starting point to pull payroll transactions from PeopleSoft to create GL journal entries in the external system? How have others tackled this interface? Thanks. ***************** End Of Article ****************** Dave Gordon posted Message 112 in Message Board Dated : July 13, 1999 at 11:47:29 EST Subject: Re: Posting to external GL system Hi ZJS, GLX001A and GLX001B are delivered sample programs for interfacing to legacy financial systems. Regards, Dave : We are implementing HR/BEN/PAYROLL 7.5 and maintaining our external financials system. Are there any PeopleSoft programs that may be a good starting point to pull payroll transactions from PeopleSoft to create GL journal entries in the external system? How have others tackled this interface? : : Thanks. ***************** End Of Article ****************** Simon Paul posted Message 113 in Message Board Dated : July 16, 1999 at 20:42:02 EST Subject: interface Payroll and extra (billing) information to PS GL - Dave? Dear Anyone_that_can_help (Dave?) At my client, Payroll/HR is a billable service and we have a billing calculation engine that interfaces to PS billing. We also calculate some extra costs associated with the payroll. After processes we already have, the additional costs get into PS_HR_ACCT_LINE and the processed Billing info resides in PS_HR_ACCT_ENTRY. What we'd like is to be able to post the cost (Payroll), the extra costs, and the revenue (from Billing side) as one journal entry. My preference would be to use standard interfaces as much as possible but I am beginning to lean toward a custom version of PayGL01.sqr which would grab the three lots of data from the various sources and create the single journal straight into headers and lines. Any thoughts on this or other solutions? Simon Paul ***************** End Of Article ****************** Dave Gordon posted Message 114 in Message Board Dated : July 17, 1999 at 12:34:13 EST Subject: Hack PayGL01 Hi Simon, I'd have to agree with you - modifying PayGL01 is probably the most straightforward approach. Be careful with rounding errors, though, because successive arithmatic operations in SQR can accumulate small differences, which tend to show up as one or two cents in large dollar amounts. This is a function of the way SQR stores real numbers, and isn't a fault, just a limitation on what's practical. My rule of thumb is probably too conservative, but here goes: If a calculation requires more than three successive operations, giving results with more than seven significant places, code it in COBOL. Someone from SQRibe might have an opposing viewpoint, but that's mine. Regards, Dave ***************** End Of Article ****************** Anthony Wilson posted Message 115 in Message Board Dated : July 17, 1999 at 14:12:55 EST Subject: Numeric Precision with SQR The problem with performing calculations in SQR is that it doesn't allow you to define variables with numeric precision. For example: 7.5% of $22.50 is how much? 22.50 x .075 = 1.6875. SQR will store this amount as 1.6875 even though you may actually want 1.68 (truncated) or 1.69 (rounded). Now, this problem is compounded each time you perform another calculation with the results. For example: two times the result would be 3.375. Even though with numeric precision the results would have been 3.36 (truncated) or 3.38 (rounded). There is a solution to this problem. PeopleSoft provides some custom functions that allow you to achieve numeric precision within SQR programs. They are stored in number.sqc. Use PS_SQR_Trunc to provide your calculations with truncated precision and use PS_SQR_Round for rounding precision. These functions should allow you to avoid using a COBOL program and still provide the numeric precision you need. Hope this helps, Anthony Wilson ***************** End Of Article ****************** Simon Paul posted Message 116 in Message Board Dated : July 17, 1999 at 22:54:54 EST Subject: Re: Hack PayGL01 Dave, Thanks for the input. I'll move ahead with payGL01. I don't think the precision will be an issue and we will consider the use of the functions that Anthony describes in his post (Thanks Anthony!). Simon Paul : Hi Simon, : I'd have to agree with you - modifying PayGL01 is probably the most straightforward approach. Be careful with rounding errors, though, because successive arithmatic operations in SQR can accumulate small differences, which tend to show up as one or two cents in large dollar amounts. This is a function of the way SQR stores real numbers, and isn't a fault, just a limitation on what's practical. : My rule of thumb is probably too conservative, but here goes: If a calculation requires more than three successive operations, giving results with more than seven significant places, code it in COBOL. Someone from SQRibe might have an opposing viewpoint, but that's mine. : Regards, : Dave ***************** End Of Article ****************** Peter Cooke posted Message 117 in Message Board Dated : July 20, 1999 at 08:37:18 EST Subject: Password change I would like to be able to add support for the PeopleSoft product to our "Password Synchronization" product. We currently have agents for Unix, NT, Oracle, Sybase, NetWare, AS/400, Web Servers etc etc. Is there an API call, script or command within the product to set the password for a user, eg CHANGE_PASSWORD ( "PETER", "xyz" ) If so, what is it ? What platforms does your product run on ? Can I get hold of a copy for development purposes ? Thanks! Peter ***************** End Of Article ****************** Lee posted Message 118 in Message Board Dated : July 22, 1999 at 13:37:09 EST Subject: Scanning Interface Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. ***************** End Of Article ****************** Mike Dybis posted Message 119 in Message Board Dated : July 23, 1999 at 07:44:35 EST Subject: Re: Scanning Interface I'm sure there are more, but the only scanner interface I've dealt with is the Restrac Resume Reader for PeopleSoft. You might be able to get some infor from Restrac's web page. : Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. ***************** End Of Article ****************** Zuke posted Message 120 in Message Board Dated : July 26, 1999 at 18:11:36 EST Subject: Re: Scanning Interface : Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. Personics is another option ***************** End Of Article ****************** Greg Tucker posted Message 121 in Message Board Dated : July 28, 1999 at 09:16:32 EST Subject: Message Agent - Help! Need Makefile for HP/UX C From the PeopleBooks I can't figure out what shared libs I need to link in or what compiler flags to use. If someone has a makefile or some info on where to find one, please email me at gregt@mindspring.com. Thanks in Advance! ***************** End Of Article ****************** Savitha Devarakonda posted Message 122 in Message Board Dated : July 30, 1999 at 18:37:33 EST Subject: Optimizer settings in Oracle Hi all, When running an AR Update in Peoplesoft Financials, we run into a infinite loop, as AR does not work well with Cost based Optimizer. So we have to change the optimzer setting to Rule based everytime we want to run AR update process. I have tried deleting statistics on the tables . But it still does not work. Oracle version is 7.3.3.0 on NT. Peopletools version 7.01 can anybody helps us on this? Thanks ***************** End Of Article ****************** Greg Schuler posted Message 123 in Message Board Dated : August 03, 1999 at 13:01:49 EST Subject: PO interface I need some info and help on creating an interface between our existing PO system, PO Writer Plus, and PeopleSoft. Specifically, I need to load requisition information for inventory reorders from PO Writer into PeopleSoft. I know, why not use PS Inventory - we will, but not for 18 mos. If anyone has worked with PO Writer let me know. This seems to be the main stumbling block. ***************** End Of Article ****************** Ted Johnson posted Message 124 in Message Board Dated : August 04, 1999 at 09:56:48 EST Subject: PS Financials without PS Student Admin We are currently converting our financials to PS. The problem we are running into is that when we purchased the software we did not buy the AR package. The thinking from above was that all of our AR is student oriented (it isn't), and they were told that we could bring up just the AR part of Student Admin (you can't). We are staying with our current student records system and have no plans now or in the future to use student admin, and are planning on keeping our current AR system from our old financial software because it interacts closely with our student records package. However now the implementation team is balking at having to write an interface between the two systems, and wants to change the GL used by the AR system to match the PS GL. Our current AR system is very flexable in that we use different divisions to account for different types of charges, and therefore send out different types of statements to different addresses for the same person. For example we may send the students tuition/room charges home to the parent, but the health services chagres all go directly to the student on a separate bill. We need to keep this flexability in whatever software we may eventually migrate. Will the standard PS AR system provide this flexability? Does anyone have any suggestions, opinions, ideas on what direction we might go. Thank you, Ted Johnson IS Department Wake Forest University ***************** End Of Article ****************** sub posted Message 125 in Message Board Dated : August 04, 1999 at 14:38:25 EST Subject: Re: Optimizer settings in Oracle hi savitha, first, its not in an infinite loop; it's just taking too long to complete. infinite loop problems can never be solved by changing the optimizer mode. second, how are you changing the optimizer mode to rule-based ? just deleting the statistics does not put oracle back to rule-based mode. you have to bring down the database, and then bring up the database instance after changing the optimizer_mode parameter to 'rule' in the initialization file. if thats a problem, you should try to have two instances running against the database, one with each type of optimization, and use the different ones for the different purposes. btw, as far as i recall, oracle version 7.3 and up are supposed to run best in the cost-based mode. hope that helps. - sub. ***************** End Of Article ****************** Filip Hanik posted Message 126 in Message Board Dated : August 05, 1999 at 16:12:59 EST Subject: Re: Message Agent - Help! Need Makefile for HP/UX C All the libraries are under bin/client/your-os the message agent API is defined under Peopletools/src/Psmsgapi.h Filip : From the PeopleBooks I can't figure out what shared libs I need to link in or what compiler flags to use. : If someone has a makefile or some info on where to find one, please email me at gregt@mindspring.com. : Thanks in Advance! ***************** End Of Article ****************** Greg Tucker posted Message 127 in Message Board Dated : August 06, 1999 at 09:01:52 EST Subject: Libs in dev/bin in I see alot of shared libs in dev/bin on the Unix box. I don't know which ones on link in and in what order. On the NT box I do see dev\bin\client\Win86 with a bunch of DLLs but I want to write a C program on the UNIX side. Anyone out there have a UNIX makefile? ***************** End Of Article ****************** Henry E.P. Sutjipto posted Message 128 in Message Board Dated : August 09, 1999 at 23:13:56 EST Subject: PeopleSoft-Oracle interface I'm trying to design an interface between PS HRMS 7.0 with Oracle Application (i.e. Project, Financials). Any idea what is the best way to maintain an online connection between those modules? Thks. ***************** End Of Article ****************** A. Bola posted Message 129 in Message Board Dated : August 10, 1999 at 12:10:50 EST Subject: Payroll Interface my client in implementing PS Payroll Interface V7.5. We are interfacing basic employee details from, Job, Employment, Personal Data and Job_Earn_Dist records only. Not deductions etc. I have populated, pay grp, pay run id, balance id, pay calendar and have tried to run the interface after setting up the fields etc in the 13 interface tables. This is the error i am getting... can any help? what is the file Status? PeopleSoft prcs_bat Started Using RDBMS ORACLE Database name HRPSTEST Process instance 4817 PeopleSoft Payroll -- Version 7.50 Copyright (c) 1988-1998 PeopleSoft, Inc. All Rights Reserved Payroll Interface Started at 17:06:28.45. DB Type:[SQLBASE | ORACLE | INFORMIX | DB2 | DB2ODBC | DB2400 | DB2UNIX | SYBASE | MICROSFT]:ORACLE Database:[hrpstest]:HRPSTEST Username:[PS ]:PS Password:[********]: Run Control ID[ ]: 14 Process Instance:[0]:4817 SQL Trace:[0]: for Operator ID :PS and Batch Run ID :14 and PI Run Number :0009 and Process Date :1999-08-10 and Run Type :L and Run Option :N and Reprocess Option :N and Export Full Set : CheckPoint/Restart Data CheckPoint Interval:0005 Loading Interface Definitions for PI System = TRC Started at 17:06:29.36. Ended at 17:06:29.45. Started import/load of payroll data at: 17.06.29.000000 Error on Open for Input File Name: TRACE.DAT File ID: 01 File Status: 35. Unable to open external file for read: Check Messages!!! <<< Checkpoint Taken >>> IMPORT/LOAD PROCESS COMPLETED PeopleSoft prcs_bat Terminating ***************** End Of Article ****************** Jay Jayaram posted Message 130 in Message Board Dated : August 10, 1999 at 16:01:04 EST Subject: Re: Payroll Interface Looks like it cannot find a file it needs to open. Maybe you do not have the right directory to create the file - maybe c:\temp or whatever the %Temp% variable is. : my client in implementing PS Payroll Interface V7.5. We are interfacing basic employee details from, Job, Employment, Personal Data and Job_Earn_Dist records only. Not deductions etc. I have populated, pay grp, pay run id, balance id, pay calendar and have tried to run the interface after setting up the fields etc in the 13 interface tables. This is the error i am getting... can any help? what is the file Status? : PeopleSoft prcs_bat Started : Using RDBMS ORACLE : Database name HRPSTEST : Process instance 4817 : PeopleSoft Payroll -- Version 7.50 : Copyright (c) 1988-1998 PeopleSoft, Inc. : All Rights Reserved : : Payroll Interface Started at 17:06:28.45. : DB Type:[SQLBASE | ORACLE | INFORMIX | DB2 | : DB2ODBC | DB2400 | DB2UNIX | SYBASE | : MICROSFT]:ORACLE : : : Database:[hrpstest]:HRPSTEST : : : Username:[PS ]:PS : : : Password:[********]: : : Run Control ID[ ]: 14 : : : Process Instance:[0]:4817 : : : : SQL Trace:[0]: : : for Operator ID :PS : : and Batch Run ID :14 : : and PI Run Number :0009 : and Process Date : :1999-08-10 : and Run Type :L : and Run Option : :N : and Reprocess Option :N : and Export Full Set : : : CheckPoint/Restart Data : CheckPoint Interval:0005 : : Loading Interface Definitions for PI System = TRC : : Started at 17:06:29.36. : Ended at 17:06:29.45. : : Started import/load of payroll data at: 17.06.29.000000 : Error on Open for Input : : File Name: TRACE.DAT : File ID: 01 : : File Status: 35. : Unable to open external file for read: : : Check Messages!!! : <<< Checkpoint Taken >>> : IMPORT/LOAD PROCESS COMPLETED : PeopleSoft prcs_bat Terminating ***************** End Of Article ****************** Dave Gordon posted Message 131 in Message Board Dated : August 10, 1999 at 22:33:16 EST Subject: Payroll Interface Initial Load Hi A, Prior to doing an export, the process compares the last batch of data sent to the payroll system with existing records, so it doesn't send old news. You need to run the initial load process, in order to "prime the pump." Set run type to initial load, run option to new, and export to full set of records. Regards, Dave ***************** End Of Article ****************** raj posted Message 132 in Message Board Dated : August 18, 1999 at 17:24:52 EST Subject: MICR Check Printing direct from PS AP Hi, Has anyone done straight check print from PS on a Lexmark printer? Any details would be appreciated. Raj ***************** End Of Article ****************** Scott Hicks posted Message 133 in Message Board Dated : August 20, 1999 at 09:54:58 EST Subject: Re: MICR Check Printing direct from PS AP : Hi, : Has anyone done straight check print from PS on a Lexmark : printer? : Any details would be appreciated. : Raj Hi Raj; What in particular are you wondering? We print cheques from AP onto a Lexmark. ***************** End Of Article ****************** sri posted Message 134 in Message Board Dated : August 30, 1999 at 04:59:35 EST Subject: upgradation!urgent please! We are upgrading from Peoplesoft application version 7 to version 7.5 kindly let me know what all are the issues to be considered.please treat this on priority thanks in advance Sri ***************** End Of Article ****************** john Ferguson posted Message 135 in Message Board Dated : September 16, 1999 at 15:24:35 EST Subject: PLEASE... Payroll GL Interface Has anyone written an interface from HR 7.5 to Fin 6.0? I have been tasked to do so and could use any help I can get. I have to create a flat file containing all of the info. I need to be able to summarize from the pay line for all employer paid items. i.e. FICA, Medicair, Taxes, etc. If anyone has something that could help me out I would greatly appreciate it. Thanks. ***************** End Of Article ****************** Anthony H. Rainey posted Message 136 in Message Board Dated : September 21, 1999 at 09:54:12 EST Subject: PeopleSoft/AFIN Interface Has anyone developed and interfaces between PeopleSoft and AFIN (Advantage Financial)? ***************** End Of Article ****************** Steve North posted Message 137 in Message Board Dated : September 22, 1999 at 12:16:19 EST Subject: Re: Run reports using Message agents Using HRMS 7.02. I have a number of issues using the Query API. 1. Using Microsoft Access to run an exisiting PS query, I have found that data types other than 'char' cause errors. This seems to occur only when the non-char field does not contain data in every row of the returned dataset. I currently have to convert all fields of this type to char in PS Query to get the Access query working. 2. Again using MS Access to run PS Queries; Why do I get errors when the query contains expressions. I am using expressions to convert non-char data type fields to char (see issue 1). The peoplesoft interface prompts for a parameter for these expressions. This problem does not occur all the time. I seem to be able to re-enter the expressions within Peoplesoft to get around the problem in some cases. In others however, I have had to completely re-write the query (which is time consuming when using unioned select statements each using several tables and up to 10 criteria expressions per select). If I could only predict where and when the errors occur, the problems would be greatly allieviated. Are these known interface problems and is there a backdoor method that I could adopt to overcome them (perhaps via the psquery% tables). ***************** End Of Article ****************** Vidhya posted Message 138 in Message Board Dated : September 30, 1999 at 16:42:15 EST Subject: Re: PLEASE... Payroll GL Interface I had written an SQR for payroll - GL interface and it produces 6 ASCIIflat files (each for more readability and tracking), one for cash receipts( Gross TMRS, FRRS, FICA, withholding, EIC ), Employee Matching, Cash distribution, Pay fund, Individual fund, Header which contains the total credits and debits and the no of journal entries. Another SQR to be written on the Financials side to read these flat files and load to the Journal header and details tables. Hope this helps, Vidhya : Has anyone written an interface from HR 7.5 to Fin 6.0? I have been tasked to do so and could use any help I can get. I have to create a flat file containing all of the info. I need to be able to summarize from the pay line for all employer paid items. i.e. FICA, Medicair, Taxes, etc. If anyone has something that could help me out I would greatly appreciate it. : Thanks. ***************** End Of Article ****************** Dan Nguyen posted Message 139 in Message Board Dated : October 13, 1999 at 10:13:02 EST Subject: conversion to packed decimal format While sending data from PeopleSoft to IBM mainframe, I need to convert number to packed decimal format. Has anyone ever known the best way to handle this problem. Thanks. ***************** End Of Article ****************** Dave Gordon posted Message 140 in Message Board Dated : October 14, 1999 at 11:29:08 EST Subject: Re: conversion to packed decimal format Hi Dan, The last time I had a problem like that, I wrote the extraction program in COBOL, reading the required tables and writing to a file. If you have any questions about COBOL programs for the PeopleSoft environment, EMail me at dagordo@ibm.net. But do it soon, because I'm changing ISP's at the end of the month. Regards, Dave ***************** End Of Article ****************** Randy posted Message 141 in Message Board Dated : October 22, 1999 at 12:12:59 EST Subject: Re: conversion to packed decimal format Dan, This is a SQC with two procedures. One converts packed decimal to ASCII and the other goes the other way. Take a look at them - the Packed Decimal to number formats are in here with a basic instruction on how to use them !*********************************************************************** ! * ! $Header:: /PT75/SQR/CNVTPACD.SQC 11 ! * !*********************************************************************** begin-procedure PAC_DEC_CNVT($NUMBER_IN, :#NUMBER_OUT) ! converts numbers from Packed Decimal to ASCII numbers. ! this procedure also assumes that the number in has had the decimal point removed ! EX $number_in = '1234E' ! #number_out = 12345 ! EX $number_in = '1234N' ! #number_out = -12345 let $num = ltrim(rtrim($number_in, ' '), ' ') let #len = length($num) let #NUMBER_OUT = 0 let #multiplier = 1 if #len > 1 let #first = #len - 1 let $num1 = substr($num, 1 , #first ) let $num2 = substr($num, #len, 1) move $num1 to #num1 let #NUMBER_OUT = #num1 * 10 else let #NUMBER_OUT = 0 let $num2 = $num end-if if #len <> 0 evaluate $num2 when = '{' let #multiplier = 1 let #num2 = 0 break when = 'A' let #multiplier = 1 let #num2 = 1 break when = 'B' let #multiplier = 1 let #num2 = 2 break when = 'C' let #multiplier = 1 let #num2 = 3 break when = 'D' let #multiplier = 1 let #num2 = 4 break when = 'E' let #multiplier = 1 let #num2 = 5 break when = 'F' let #multiplier = 1 let #num2 = 6 break when = 'G' let #multiplier = 1 let #num2 = 7 break when = 'H' let #multiplier = 1 let #num2 = 8 break when = 'I' let #multiplier = 1 let #num2 = 9 break when = '}' let #multiplier = -1 let #num2 = 0 break when = 'J' let #multiplier = -1 let #num2 = 1 break when = 'K' let #multiplier = -1 let #num2 = 2 break when = 'L' let #multiplier = -1 let #num2 = 3 break when = 'M' let #multiplier = -1 let #num2 = 4 break when = 'N' let #multiplier = -1 let #num2 = 5 break when = 'O' let #multiplier = -1 let #num2 = 6 break when = 'P' let #multiplier = -1 let #num2 = 7 break when = 'Q' let #multiplier = -1 let #num2 = 8 break when = 'R' let #multiplier = -1 let #num2 = 9 break when-other let #multiplier = 1 let #num2 = 0 break END-EVALUATE LET #NUMBER_OUT = (#NUMBER_OUT + #num2) * #multiplier END-IF end-procedure begin-procedure PAC_DEC_out(#num, #length, :$NUMBER_OUT) ! converts numbers from ASCII to Packed Decimal numbers. ! this procedure also removes the decimal point by multiplying by 100 ! the #length then zero fills the number on the left to fit an output rec ! ! EX #num = '123.45' ! #length = 8 ! $number_out = '0001234E' ! EX #num = -123.45 ! #length = 8 ! $number_out = '0001234N' if #num >= 0 let $neg = 'N' let #num = #num * 100 ! remove the decimal else let $neg = 'Y' let #num = #num * -100 ! remove the decimal end-if let $num = edit(#num, '99999999999') let $num = ltrim(rtrim($num, ' '), ' ') let #len = length($num) if #len > 1 let #first = #len - 1 let $num1 = substr($num, 1 , #first ) let $num2 = substr($num, #len, 1) else let $num1 = '' let $num2 = $num end-if let $NUMBER_OUT = '{' if #len <> 0 if $neg = 'N' !value is positive evaluate $num2 when = '0' let $num2 = '{' break when = '1' let $num2 = 'A' break when = '2' let $num2 = 'B' break when = '3' let $num2 = 'C' break when = '4' let $num2 = 'D' break when = '5' let $num2 = 'E' break when = '6' let $num2 = 'F' break when = '7' let $num2 = 'G' break when = '8' let $num2 = 'H' break when = '9' let $num2 = 'I' break when-other let $num2 = '{' break end-evaluate else ! value is negative evaluate $num2 when = '0' let $num2 = '}' break when = '1' let $num2 = 'J' break when = '2' let $num2 = 'K' break when = '3' let $num2 = 'L' break when = '4' let $num2 = 'M' break when = '5' let $num2 = 'N' break when = '6' let $num2 = 'O' break when = '7' let $num2 = 'P' break when = '8' let $num2 = 'Q' break when = '9' let $num2 = 'R' break when-other let $num2 = '{' break END-EVALUATE end-if LET $NUMBER_OUT = $num1 || $num2 LET $NUMBER_OUT = lpad($number_out, #length, '0' ) END-IF end-procedure ***************** End Of Article ****************** Matthew Holroyd posted Message 142 in Message Board Dated : October 25, 1999 at 10:10:43 EST Subject: Web enabling Peoplesoft 7.5 I am looking into ways of web enabling PS 7.5 and have heard several techniques are available. I'm completely new to PS and so would appreciate any help available. Does anyone have opinions on what are the best ways to do this? We are currently running a 2 tier setup with DB2 database, and will be enabling for IE4. Any opinions on any of the following would be most appreciated, with reasons behind pros and cons, performance issues etc. x.500 Peoplesoft's web tools RCMS Please email any comments. Thanks Matt ***************** End Of Article ****************** Raghu posted Message 143 in Message Board Dated : October 26, 1999 at 09:32:51 EST Subject: About Payroll Interface Tables(PARTIC & PARTIC_EXPT) Hi All , I need to know how these Payroll Interface tables (PI_PARTIC and PI_PARTIC_EXPT) get populated when we process an export/import . How does these two tables work when they are in compare process . What does EXPORT_ROW field of PARTIC_EXPT contains after the process . Can anyone out there explain me the process related to these tables as PS doc does not have sufficient info. That would be a great help . Thanks in advance , raghu ***************** End Of Article ****************** Rajan posted Message 144 in Message Board Dated : October 28, 1999 at 04:29:31 EST Subject: Invoke Import Manager If I need to invoke Import Manager from an external application/ batch process how exactly can I do it? Even though PeopleSoft Documentation tells us to use calling psimp with certain parameters, when I try to do it it's giving error. Can somebody tell me the correct way to do it? Thanks ***************** End Of Article ****************** Salil Baig posted Message 145 in Message Board Dated : October 28, 1999 at 04:42:30 EST Subject: Import Manager does not invokes from external application Problem : I have been unsuccessfully trying to invoke Import Manager from an external application through psimp.exe with some command line parameters. This is the message which greets me every time in a modal window. "Missing or invalid version of SQL library PSSBS (0,0)" I'll appriciate any help or leads in debugging this out. Salil Baig. ***************** End Of Article ****************** Tony DeLia posted Message 146 in Message Board Dated : October 28, 1999 at 11:44:46 EST Subject: Re: conversion to packed decimal format Dan, I posted some Mainframe conversion routines on my site... http://www.sqrtools.com A) TDNUMMF.SQC - Mainframe Signed Number Conversion (Inbound/Outbound) This converts To/From Packed-Display Format using the standard overpunch in the last digit... note this is not actual packed data... B) TDUNPK.SQC - SQR Unpack Routine (Converting TRUE packed data to ASCII)... Example: ()+ or x'28292B' translates to -28292 You can navigate directly using the Latest Updates section or look under the Techniques section of the site... Tony DeLia PS - More updates to follow... : While sending data from PeopleSoft to IBM mainframe, I need to convert number to packed decimal format. Has anyone ever known the best way to handle this problem. : Thanks. ***************** End Of Article ****************** Rohit posted Message 147 in Message Board Dated : October 28, 1999 at 14:49:28 EST Subject: Re: Web enabling Peoplesoft 7.5 Hi Matthew, To begin with, you have to have a 3-Tier environment for deploying the web client. 2 Tier will NOT do. When you start up your tuxedo server processes through PSADMIN, the JSL and JSH processes facilitate the web client to talk to the database. Make sure you have a web server which has the delivered HTML and Javaclient applet files in its directories. You will have to configure your tuxedo processes & web server and make changes to the HTML files in the web server directories so that the java applets point to the correct port # of the JSL process. I hope this makes some sense. Write to me if you want to know more. Rohit : : I am looking into ways of web enabling PS 7.5 and have heard several techniques are available. I'm completely new to PS and so would appreciate any help available. : Does anyone have opinions on what are the best ways to do this? We are currently running a 2 tier setup with DB2 database, and will be enabling for IE4. : Any opinions on any of the following would be most appreciated, with reasons behind pros and cons, performance issues etc. : x.500 : Peoplesoft's web tools : RCMS : Please email any comments. : Thanks : Matt ***************** End Of Article ****************** walter posted Message 148 in Message Board Dated : November 01, 1999 at 06:03:55 EST Subject: Re: PeopleSoft calling function in C/C++ DLL : Is there a way for PeopleSoft to call a C or C++ function : in a Windows DLL? ***************** End Of Article ****************** Buddy MacDonald posted Message 149 in Message Board Dated : November 02, 1999 at 21:21:29 EST Subject: Interface to Time and Labor Rapid Time. Has anyone written an interface to Time and Labor version 7.5 Rapid Time by Employee tables? Our time is captured in an external time capture module and the plan is to have an SQR load the TL tables. I am looking for a sample SQR to use as a guide. I have not found anything delivered by PeopleSoft. If anyone has something that could help me out I would greatly appreciate it. Buddy ***************** End Of Article ****************** William Kristler posted Message 150 in Message Board Dated : November 12, 1999 at 13:32:51 EST Subject: Fast Database Queries What we are looking to do is get faster "Read Only" queries of the peoplesoft database, but with some security. I know that we could directly access the Oracle database via ODBS (or JDBC), but we would before to do this. Is it possible to access the PSQRYSRV directly? The documentation I've seen so far says to go through PeopleSoft Query (PSQED.EXE), but someone in my group thought they heard of a way to access it via Java directly. Any ideas? Thanks, -Bill ***************** End Of Article ****************** Atul posted Message 151 in Message Board Dated : November 21, 1999 at 04:34:06 EST Subject: Re: upgradation!urgent please! If you have a lot of customizations,You should run a compare report between current production system and vanilla 7.5 This should give you a list of new PS objects and the changed ones. Migrating the new ones is not a problem. For the changed ones, see if it makes sense to use the new 7.5 object and apply your customizations or move the old objects and bring it to speed with the new release. If you want to move from vanilla to vanilla 7.5, you have to follow the PS instructions for Upgrade. I guess this will bring the PS objects to sink by performing a lot of Alter tables, Creates and Drop etc. Before you do this, read the instructions very carefully as it has quite a few twists and turns. ***************** End Of Article ****************** Naveen Vatsavayi posted Message 152 in Message Board Dated : November 22, 1999 at 10:17:34 EST Subject: Data Transfer, using a Message Agent, in PeopleSoft itself. We have an approval process for some of our panels. For example, an employee has the option of giving his tax percentage(according to Govt. laws), through the web. That data should be written to a Temprary table which is a replica of the basd table. Once the manager of that employee Approves the percentage, ONLY then the data should be written to the main tables. This is to stop the flow of unapproved data into the main tables and to the various interfaces from there. When the manager gives his approval, we then want to send the data into the base tables and into the Audit tables. This can be done through Peoplecode, by coding lots of Inserts to different tables, which will turn up to be a Maintenance nightmare on the longer run. Hence we want to use the Message Agent option. I am aware of the process of sending or receiving data from external applications, through the message agents. But i am missing the vital link, ie, how to send data from one panel to another panel(or to a record), through a message agent. As we are sitting on a tight rope here, it would be quite helpful if you can get back to me with any details by close of business today. Please don't bother yourself, if you are quite busy. ***************** End Of Article ****************** Rohit posted Message 153 in Message Board Dated : November 22, 1999 at 16:32:39 EST Subject: Re: Data Transfer, using a Message Agent, in PeopleSoft itself. Navin, I dont know of any way the Message agent puts data from one panel to another. However, there is a way out for you. The Database Agent - which is a combination of a query and message agent. What you need to do is write a Query on the temporary table to select the data that needs to be sent to the correct panels. Save the query as a Database Agent query. Create a business process and insert an activity. In the activity, insert a Database Agent icon and point it to the (Core) panel you want to send the data to. (As you would with the message agent). Perform the Field mapping - each field of the query to a field on the panel. Since you say that the data is going to many tables, if the core panel does not do the entire work for you, you may have to create other Database agent definitions and point to the other panels as well. After you are done, Create a Database agent process definition. Make sure you run the database agent only in a 3tier environment, and you can only run this process on a windows based environment. The DBAG processes can give you quiet a pain in the bu*t, but they are worth it once they get working. Hope this helps. Good luck. Rohit : We have an approval process for some of our panels. For example, an employee : has the option of giving his tax percentage(according to Govt. laws), through the : web. That data should be written to a Temprary table which is a replica of the basd : table. Once the manager of that employee Approves the percentage, ONLY then : the data should be written to the main tables. This is to stop the flow of unapproved : data into the main tables and to the various interfaces from there. : When the manager gives his approval, we then want to send the data into the base : tables and into the Audit tables. This can be done through Peoplecode, by coding : lots of Inserts to different tables, which will turn up to be a Maintenance nightmare : on the longer run. Hence we want to use the Message Agent option. : I am aware of the process of sending or receiving data from external applications, : through the message agents. But i am missing the vital link, ie, how to send data from : one panel to another panel(or to a record), through a message agent. : As we are sitting on a tight rope here, it would be quite helpful if you can get back to : me with any details by close of business today. Please don't bother yourself, if you : are quite busy. ***************** End Of Article ****************** atefnet posted Message 154 in Message Board Dated : November 27, 1999 at 11:28:31 EST Subject: Re: P/S Payroll System Design : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Angela Johanson posted Message 155 in Message Board Dated : December 14, 1999 at 15:06:57 EST Subject: Chrystal Reports Does PeopleSoft have an option to export the data to a Chrystal Report? Thanks. ***************** End Of Article ****************** soft lu posted Message 156 in Message Board Dated : December 15, 1999 at 03:39:58 EST Subject: Configuration for Mail I am studying workflow by myself, but I don't know how to config the ps with lotus notes. I am tring to send email from peoplesoft and I can not get mail in notes. By the way, when running psnotes.exe, system tell me "Can not find nNotes.dll". After copying dll file to system, psnotes.exe shows nothing. Is there any one can give me a config list? ***************** End Of Article ****************** Paddy posted Message 157 in Message Board Dated : December 17, 1999 at 17:18:32 EST Subject: Re: Payroll interface : Does anyone have a list of payroll systems that PeopleSoft can interface with? : Were using Centrepay -Paypoint Vu 2.10.1 : Thanks. Apart from ADP, Payroll Interface v.7.5 has addressed issues to Payplus product. I remember to have read some info from PS resolutions ***************** End Of Article ****************** Martin posted Message 158 in Message Board Dated : January 04, 2000 at 10:52:08 EST Subject: Re: Payroll interface : Does anyone have a list of payroll systems that PeopleSoft can interface with? : Were using Centrepay -Paypoint Vu 2.10.1 : Thanks. PS only provides ADP - but I have implemented an interface to PayPoint. It was mostly very straightforward once you understand how it works ! regards ***************** End Of Article ****************** Guest posted Message 159 in Message Board Dated : January 07, 2000 at 19:21:03 EST Subject: Message Agent and CUSTOMER table I am attempting to add a customer record using message agent. If I add the customer inputting fields that are only found in the CUSTOMER table (level 0) then I have no problems. If I attempt to add a customer with "Bill to Customer" (on panel CUSTOMER_GEN2), "Bill to Address" (on panel CUSTOMER_ADDRESS), and "Primary" (on panel CUSTOMER_ADDRESS) set to "Y", then I get the error "Unable to update value. (54,10)". Table and field are not specified. I don't see that i'm doing anything different from what an online user is doing when adding a new customer. Any thoughts ?? (same occurs for ship-to and sold-to) ***************** End Of Article ****************** David posted Message 160 in Message Board Dated : January 13, 2000 at 13:30:21 EST Subject: T&L - Project Costing integration Has anyone sucessfully done prior period adjustment to project costing from Time and Labor? Did you pass hours AND dollar amounts to Project Costing ? Will you share your knowledge wwith me? Currently on Oracle DB, PTOOLS 7.55, Psoft 7.50 TIA ***************** End Of Article ****************** Kurt Crowley posted Message 161 in Message Board Dated : January 14, 2000 at 13:06:22 EST Subject: version 8, business components, message agent level > 2 This is a somewhat broad (and probably asked) question, BUT, has anyone seen/used the 'business components' or other data access methods of version 8? we struggled with message agent limitations (level 2 + scrolls) and are curious if ps will really deliver complete ps data access WITH business edits. also has anyone used ActiveWorks Adapter for Peoplesoft? ***************** End Of Article ****************** Eugene Vincent posted Message 162 in Message Board Dated : January 23, 2000 at 10:00:28 EST Subject: Re: About Payroll Interface Tables(PARTIC & PARTIC_EXPT) Hi; I will identify and outline the two tables you were asking about. The PI_PARTIC table is used to determine which employees to review (apply compare) in the current payroll interface process. The table is build using two primary factors. 1) The Active Employees for Export (Employment Status Codes) setup for the interface are used to determine the active employees or employees to include in the selection process. The Active Employees for Export are established in the Administer Payroll Interface, Setup, Interface System Table 2 panel. This list of active employee status codes can be overridden through the Run Control Active Employees Check Box. If you turn this check box off, than selection process will include all employment status codes. When this box is checked, than only those employment status codes defined in the Interface System Table 2 panel are used to select employees. 2) When employee is terminated and the terminated status is not included in the active employee list the effective date of the termination must fall within the pay period being processed or the termination status will not be submitted to payroll. The work around for customers with late paper work processing is to always include the termination status codes within the Active Employee list of status codes. There are fixes for this issue,but currently not supported by PeopleSoft. 3) Normally you would include terminated employees during the payroll year, so address changes can be submitted to payroll when applied within PeopleSoft. The basic problem of including terminations is care must be applied, if your payroll vendor deletes terminations (ADP clears terminations in February of new Calendar year for prior year terminations, Pro-Business keeps terminations on file). The PI_PARTIC will include a record for each employee determined to meet the active employee requirements for the Pay Period being processed. If your active employee list includes terminations, than the PI_PARTIC will contain a row for all employees. This table continues to grow for each pay period being processed. The PI_PARTIC table once build is used to drive the rest of the compare process. This table carries basic information about the employee being processed. It will include the Payroll Company (PI_CONFIG_ID), PeopleSoft Company and Paygroup, Payroll Employee Id, PeopleSoft Employee Id, Employment Status and interface processing information. The processing information will indicate if employee has change activity during the process, or triggered a stop event. The PI_PARTIC_STATUS on record will indicate if employee completed compare or had an error message issued during the compare process. The PI_CHANGE_IND has little meaning during the process, but the PI_CHANGE_TYPE is used to indicate if Employee had a Data Change, or if Employee is a new hire,or if employee is rehired or terminated. This field is also used to indicate the stop events (process control indicator). Some special process routines use this field to help handle exporting information for payroll vendor. Mostly, what is delivered is handling the build of ADP/DOS records. The PI_PARTIC table is build during the compare process within the PIPCMPAR COBOL program. After the table is build it is than used to drive the rest of the compare process. During the build process the PI_PARTIC_STATUS is set to "P" (In Progress). During the compare process this field will wither be updated to "C" (Compared) or "E" (Compare Error). Please note that once an employee is issued an "E" the program will not send any change information to the Payroll Vendor. Once, the reason for employee getting error condition is corrected the employee will start sending changes. The PI_PARTIC_EXPT is used to store the selected PeopleSoft Data in what is refered to as the "Payroll Vendor's Image". When employee is selected the PeopleSoft information is obtained (All based on table definitions) and formatted into how the Payroll Vendor expects to see the data. This may mean that the PeopleSoft definitions are tranlsated into Payroll Definitions and Dates are formatted based on the Payroll Vendors required format. Decimals are applied if defined in the table setup to numeric fields. When you think about a field on the PI_PARTIC_EXPT table think of it in an ASCII Payroll Vendor structure. PeopleSoft uses a string structure to build a EXPORT_ROW data. The data is ordered in the EXPORT_ROW based on the order defined in the PI_DEFN_FIELD table. When the 250 bytes are filled, another 250 byte EXPORT_ROW field is established. If a field does not fit on a single 250 byte row, the data is split and the remainder of the data is inserted into the next 250 byte EXPORT_ROW field. Each Record definition will have it's own set of 250 byte EXPORT_ROW transactions. When the EXPORT_ROW is being build each field is started with a change indicator. The change indicator is a 1 byte field that indicates if the field being posted has changed. The indicators will be either 0 (No Change), 1 (Field Changed), or 2 (Field included as Change because it is associated with a Group definition). Grouped fields are fields on the PI_DEFN_FIELDS table that have the same group identifer. These are normally assigned to fields in which the Payroll Vendor has stated that if any field is changed than these other fields must also be included with the primary change (Pay Rate Changed, must also include Rate Type, etc.). So when the fields are strung on the EXPORT_ROW it would look like: cfffffffcffffffcffffffff (Where c would be the change indicator and f would be the field formated per Payroll Vendor requirements. When a record is defined as a multiple to multiple record, each unique occurrance will have separate 250 byte rows established to meet the complete record layout for the record definition. When a employee is compared the program will only create new data in the PI_PARTIC_EXPT table when employee has some type of change activity. When employee has eny type of change, all impacted records are inserted under the new PI_RUN_NUM on the PI_PARTIC_EXPT. If employee does not have any changes for the current Pay Period the PI_PARTIC_EXPT is not changed for employee unless the Compare is being processed using the Run Control Option of Full Set of Records. When this option is used the new PI_RUN_NUM will contain all employees selected from the PI_PARTIC table even if they have no changes for current pay period. Program still keeps track of the fields being changed and still records on the PI_PARTIC table the correct PI_CHANGE_TYPE information to indicate if employee has any changes. When the Payroll Interface gets to the Export process, the PI_CHANGE_IND from the PI_PARTIC_EXPT table is used to select the records that should be used to build the Payroll Vendors Data. If the Full Set of Records run control option is used, than the program will select all of the data for the current PI_RUN_NUM and build all fields and all records, even when no change is recorded for employee. Also, the table setup and formatting determines how much of the data is used to format the employee data. If the Payroll Vendor is using Physical Record layouts, than the field change indicator has not bearing on how the data is formated. Because a Physical Record layout will include all fields. The change indicator on a field is only used when field changes are submitted. If you need additional information about the Payroll Interface Tables, Please E-Mail me at EugeneV863@aol.com or you can call me at (315) 625-4898. Gene Vincent Sr. Tech. Consultant V.I.T., Inc. ***************** End Of Article ****************** Chester posted Message 163 in Message Board Dated : January 24, 2000 at 14:08:28 EST Subject: Re: Registering the Message Agent - Solved I can't seem to find the whitepaper mentioned here. I am developing Active Server Integration on PS 7.5 Message Agent, and intending to use its API. Where is this whitepaper published by Alliance Solution Center, and are there any other sources on how to use the Message Agent. : PeopleSoft has a published whitepaper on a sample message agent implementation with VB. It was published under the Alliance Solution Center. They even have a snipet of sample code illustrating the connect method. ***************** End Of Article ****************** waja posted Message 164 in Message Board Dated : January 25, 2000 at 10:54:31 EST Subject: Re: Chrystal Reports : Does PeopleSoft have an option to export the data to a Chrystal Report? Thanks. Yes.If you write a query ,you can direct the output to Crystal/Nvision(XL) etc... Hope that helps Waja ***************** End Of Article ****************** waja posted Message 165 in Message Board Dated : January 25, 2000 at 11:32:37 EST Subject: Payroll Interface I am intrested in learning INDEPTH about Payroll interface. Peoplebooks donot seem to help. Can someone give me tips(website/books .etc..) where I can learn Payroll Interface. Appreciate your help Waja ***************** End Of Article ****************** tyoer posted Message 166 in Message Board Dated : January 25, 2000 at 15:37:41 EST Subject: Just testing my friends computer HI this is a test ***************** End Of Article ****************** Vishwa posted Message 167 in Message Board Dated : February 02, 2000 at 10:33:24 EST Subject: How to start MESSAGE AGENT ??? Hi , I need some help on Message Agent . I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . Oracle 8.1.5 on Solaris 2.6 & Windows NT 4.0 Server as file Server I am trying to run the Databse Agent from command line .The command line parameters are as following psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . Process Instance=0 Activity Name=Deliver Reports Message Definition Name=Report Delivery Topic Name=//rpt inst:7000 Query Name = _DBAG__REPORT_DELIVERY 15.06.28:run query 15.06.28:fetch rows Message Agent not started 15.06.28:done Now Can you please tell me How do I START a Message Agent ?? I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. Looking forward for help , Warm regards Vishwa ***************** End Of Article ****************** Mathieu LEBRATI posted Message 168 in Message Board Dated : February 15, 2000 at 05:23:37 EST Subject: Re: How to start MESSAGE AGENT ??? Are you sure the PSAPISRV is running on your Application Server ? : Hi , : I need some help on Message Agent . : I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . : Oracle 8.1.5 on Solaris 2.6 & : Windows NT 4.0 Server as file Server : : I am trying to run the Databse Agent from command line .The command line parameters are as following : psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T : When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and : Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . : Process Instance=0 : Activity Name=Deliver Reports : Message Definition Name=Report Delivery : Topic Name=//rpt inst:7000 : Query Name = _DBAG__REPORT_DELIVERY : 15.06.28:run query : 15.06.28:fetch rows : Message Agent not started : 15.06.28:done : : Now Can you please tell me How do I START a Message Agent ?? : I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. : : Looking forward for help , : : Warm regards : Vishwa ***************** End Of Article ****************** Mathieu LEBRATI posted Message 169 in Message Board Dated : February 15, 2000 at 05:30:33 EST Subject: Re: Configuration for Mail The executable for the VIM or MAPI email software must be in the search path so that the system can find it, or you can specify a location in the Configuration Manager Workflow tab. For Lotus Notes, the NOTESDB directory must also be in the path. You'll find all installation steps in PeopleBook PT750ENG.NFO : I am studying workflow by myself, but I don't know how to config the ps with lotus notes. I am tring to send email from peoplesoft and I can not get mail in notes. By the way, when running psnotes.exe, system tell me "Can not find nNotes.dll". After copying dll file to system, psnotes.exe shows nothing. Is there any one can give me a config list? ***************** End Of Article ****************** Jim Mabey posted Message 170 in Message Board Dated : February 17, 2000 at 01:31:13 EST Subject: EDI loading vendor payment request from 3rd party What's the recommended method of transferring payment requests to Peoplesoft from a 3rd party application? Need to process Utility Billing refunds and other misc. payments. Don't want to have to key in manually. Thanks. ***************** End Of Article ****************** Mathieu LEBRATI posted Message 171 in Message Board Dated : February 21, 2000 at 08:27:07 EST Subject: Re: EDI loading vendor payment request from 3rd party You can use standard EDI transaction to load Invoice. See the Application Fundamentals PeopleBooks for more detail about this transaction. : What's the recommended method of transferring payment requests to Peoplesoft from a 3rd party application? Need to process Utility Billing refunds and other misc. payments. Don't want to have to key in manually. : Thanks. ***************** End Of Article ****************** Lalita Kambhampati posted Message 172 in Message Board Dated : February 22, 2000 at 14:41:48 EST Subject: Re: EDI loading vendor payment request from 3rd party You can do that using the Payment Interface option. Refer to the documentation for more details : http://www4.peoplesoft.com/contdoc.nsf/8aed139ec41bb3c1882566fa00055a05/36e11bb5378ce0f88825672e006efe2b?OpenDocument - Lalita : What's the recommended method of transferring payment requests to Peoplesoft from a 3rd party application? Need to process Utility Billing refunds and other misc. payments. Don't want to have to key in manually. : Thanks. ***************** End Of Article ****************** ketan posted Message 173 in Message Board Dated : February 28, 2000 at 18:01:26 EST Subject: Re: How to start MESSAGE AGENT ??? Hi If you are running PeopleSoft in 3-Tier then all the PeopleSoft Client (Web, PeopleSoft Panel or Any other) uses the Message Agent to run the business rules coded in PeopleCode. So, again verify with your DBA or Admin people that you are running all the services to run the PeopleSoft in 3-tier Ketan : Hi , : I need some help on Message Agent . : I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . : Oracle 8.1.5 on Solaris 2.6 & : Windows NT 4.0 Server as file Server : : I am trying to run the Databse Agent from command line .The command line parameters are as following : psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T : When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and : Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . : Process Instance=0 : Activity Name=Deliver Reports : Message Definition Name=Report Delivery : Topic Name=//rpt inst:7000 : Query Name = _DBAG__REPORT_DELIVERY : 15.06.28:run query : 15.06.28:fetch rows : Message Agent not started : 15.06.28:done : : Now Can you please tell me How do I START a Message Agent ?? : I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. : : Looking forward for help , : : Warm regards : Vishwa ***************** End Of Article ****************** ketan posted Message 174 in Message Board Dated : February 28, 2000 at 18:03:10 EST Subject: Re: How to start MESSAGE AGENT ??? Hi If you are running PeopleSoft in 3-Tier then all the PeopleSoft Client (Web, PeopleSoft Panel or Any other) uses the Message Agent to run the business rules coded in PeopleCode. So, again verify with your DBA or Admin people that you are running all the services to run the PeopleSoft in 3-tier Ketan : Hi , : I need some help on Message Agent . : I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . : Oracle 8.1.5 on Solaris 2.6 & : Windows NT 4.0 Server as file Server : : I am trying to run the Databse Agent from command line .The command line parameters are as following : psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T : When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and : Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . : Process Instance=0 : Activity Name=Deliver Reports : Message Definition Name=Report Delivery : Topic Name=//rpt inst:7000 : Query Name = _DBAG__REPORT_DELIVERY : 15.06.28:run query : 15.06.28:fetch rows : Message Agent not started : 15.06.28:done : : Now Can you please tell me How do I START a Message Agent ?? : I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. : : Looking forward for help , : : Warm regards : Vishwa ***************** End Of Article ****************** Vishwa posted Message 175 in Message Board Dated : February 29, 2000 at 04:38:48 EST Subject: Word Macros - Adding a NEW Field Hi I want to include an additional FIElD in the FORM Letter template LTROF1. Can anyone tell me How to add a MERGE field to this WOrd template ? I am not very comfortable with Word Macros ? ***************** End Of Article ****************** Brian posted Message 176 in Message Board Dated : March 01, 2000 at 17:11:53 EST Subject: EDI Integration Quick question: If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? ***************** End Of Article ****************** Dave posted Message 177 in Message Board Dated : March 01, 2000 at 18:06:41 EST Subject: AR EDI Hello all, Did anyone implement EDI in AR? I am planning to implement EDI 820 and I am not getting a list of required fields. Also can I accept incoming payments without a MICR ID or CUST ID with only the the item ID for identification? Will it work ? Thanks in advance Dave ***************** End Of Article ****************** Kasper de Bruin posted Message 178 in Message Board Dated : March 02, 2000 at 03:23:54 EST Subject: Web Requisition Interface I am not a VB, or C programmer. I would like to build a web interface for Requisitions. I can extract data from peoplesoft using odbc, and I can place data in tables using the same method. Is there a way to import requisition data from tables into the peoplesoft system. ***************** End Of Article ****************** Vikram posted Message 179 in Message Board Dated : March 02, 2000 at 10:48:13 EST Subject: Re: EDI Integration You will need an EDI service provider - a VAN. You will also require translation s/w such as Sterlings' Gentran and PS EDI manager. For a list of vendors apporved by PS for EDI check PS site. HTH - Vikram : Quick question: : If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? ***************** End Of Article ****************** Amy Christenson posted Message 180 in Message Board Dated : March 02, 2000 at 12:03:04 EST Subject: Interfacing Outlook and T&L We want to create a form in outlook that our users will use to enter time and labor, then import this data into PS T&L. Can this be done? Any suggestions on the best route ie message agent, sqr... Thanks! ***************** End Of Article ****************** brian posted Message 181 in Message Board Dated : March 02, 2000 at 12:31:56 EST Subject: Re: EDI Integration : You will need an EDI service provider - a VAN. You will also require translation s/w such as Sterlings' Gentran and PS EDI manager. For a list of vendors apporved by PS for EDI check PS site. : HTH : - Vikram : : : Quick question: : : If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? We already have a coomplete EDI infrastructure (hardware, software, VAN, communications,etc..). What I am trying to figure out is if the PS EDI Manager performs the same functions as other EDI software, and if so do I still need to use it, and why? Thanks ***************** End Of Article ****************** Terry posted Message 182 in Message Board Dated : March 11, 2000 at 09:34:44 EST Subject: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy I have a client who has a requirement to interface SAP with a number of other systems including Peoplesoft. The interface needs to be synchronous or asynchronous and it should be able to detect whether the SAP system is down and store the data until the SAP system is back up. I heard about a product from d.d. synergy called CCcom and I was wondering if anyone has any experience with their product? Thank you in advance for any information you might be able to provide. Terry TMHR Consulting ***************** End Of Article ****************** Amy posted Message 183 in Message Board Dated : March 20, 2000 at 16:00:14 EST Subject: Re: T&L - Project Costing integration We successfully passed prior period and dollar amounts to Projects. If you would like more information, please contact me directly. Amy : Has anyone sucessfully done prior period adjustment to project costing from Time and Labor? Did you pass hours AND dollar amounts to Project Costing ? Will you share your knowledge wwith me? Currently on Oracle DB, PTOOLS 7.55, Psoft 7.50 : TIA ***************** End Of Article ****************** Vikram posted Message 184 in Message Board Dated : March 22, 2000 at 17:34:38 EST Subject: Re: EDI Integration : : You will need an EDI service provider - a VAN. You will also require translation s/w such as Sterlings' Gentran and PS EDI manager. For a list of vendors apporved by PS for EDI check PS site. : : HTH : : - Vikram : : : : : Quick question: : : : If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? : We already have a coomplete EDI infrastructure (hardware, software, VAN, communications,etc..). What I am trying to figure out is if the PS EDI Manager performs the same functions as other EDI software, and if so do I still need to use it, and why? : Thanks The PS EDI Manager and Translation s/w such as Gentran are complimentary and one cannot be replaced by the other. Briefly: When the EDI file comes in Via VAN, Gentran translates the data into PS readable format, this file is the input for EDI manager. This is INBOUND transaction, for OUTBOUND transaction, Gentran converts EDI Manger output into an "EDI transmittable" format. HTH Vikram ***************** End Of Article ****************** kcrowley posted Message 185 in Message Board Dated : March 23, 2000 at 17:10:27 EST Subject: Business rules via Edit mode My question is whether anyone has found a way to "test" PeopleSoft business rules from an external application. Obviously, MessageAgent will verify business rules upon an update , BUT i wonder if anyone has found a method (either on the database level or even dll level (psmas.dll) ) to CHECK a transaction without the implicit commit. Thanks, Kurt ***************** End Of Article ****************** Deanna posted Message 186 in Message Board Dated : March 28, 2000 at 22:16:23 EST Subject: Interface Payroll 7.02 E&G with GL 7.50 E&G We are currently upgrading to FIN 7.5 E&G from FIN 7.01 E&G and have discovered that the delivered Payroll/GL interface is not valid between HR 7.01 and GL 7.50, AND PeopleSoft has no resolution for this. Has anyone else encountered this problem? How have you dealt with it? Any info. at all would be appreciated. ***************** End Of Article ****************** Terry posted Message 187 in Message Board Dated : April 01, 2000 at 13:19:36 EST Subject: Re: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy Thank you for your follow-up message. I was actually able to find some information about CCcom from d.d. synergy. Let me know if you want a copy of their white paper. It should also be up on their web site at: www.ddsynergy.ca. Terry : I have a client who has a requirement to interface SAP with a number of other systems including Peoplesoft. The interface needs to be synchronous or asynchronous and it should be able to detect whether the SAP system is down and store the data until the SAP system is back up. : I heard about a product from d.d. synergy called CCcom and I : was wondering if anyone has any experience with their product? : Thank you in advance for any information you might be able to provide. : Terry : TMHR Consulting ***************** End Of Article ****************** Joe Weessies posted Message 188 in Message Board Dated : April 03, 2000 at 19:01:37 EST Subject: Re: Web Requisition Interface Check out the Application Engine process - REQLOAD. This is a PS built way to enter in requisitions from outside systems. This will show you the tables and the process to be used. You will have to setup some other panels to get this to work but it is all right there to build upon. JoeW : I am not a VB, or C programmer. I would like to build a web interface for Requisitions. I can extract data from peoplesoft using odbc, and I can place data in tables using the same method. Is there a way to import requisition data from tables into the peoplesoft system. ***************** End Of Article ****************** Margot Brown posted Message 189 in Message Board Dated : April 11, 2000 at 09:36:21 EST Subject: Re: Scanning Interface : I'm sure there are more, but the only scanner interface I've dealt with is the Restrac Resume Reader for PeopleSoft. You might be able to get some infor from Restrac's web page. : : Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. ***************** End Of Article ****************** Brian posted Message 190 in Message Board Dated : April 18, 2000 at 16:12:41 EST Subject: Import Orders into OM I am trying to import orders placed over the web into PS Order Management 7.5. What is the best way to import the data into the PeopleSoft dB? We are currently running 3-tier on Oracle dB. Thanks in advance, Brian ***************** End Of Article ****************** Dan posted Message 191 in Message Board Dated : April 21, 2000 at 16:11:45 EST Subject: Re: Interface Payroll 7.02 E&G with GL 7.50 E&G We upgraded our HR and FS at the same time! : We are currently upgrading to FIN 7.5 E&G from FIN 7.01 E&G and have discovered that the delivered Payroll/GL interface is not valid between HR 7.01 and GL 7.50, AND PeopleSoft has no resolution for this. Has anyone else encountered this problem? How have you dealt with it? Any info. at all would be appreciated. ***************** End Of Article ****************** Hunter Praywell posted Message 192 in Message Board Dated : May 11, 2000 at 16:00:03 EST Subject: Purchase Order Interface into Purchasing We use a third party purchasing system issue and manage our purchase orders. These New, Changed and Cancelled POs created in the third party system and interfaced directly into our PSFT PO prod. tables. It works miserably, as it does not perform all the complex data validations when loading external data directly into our production tables. If anyone has built a smooth interface, with necessary validations and reject / clean-up tables, v. 7.5x or higher, can you contact me and give me some hints on how to get these new, changed and cancelled PO transactions into the Purchasing module with maximum validation and minimum PAIN? Req. tables? PO Build tables? Yes, we're looking for a consultant, and we work in Hawaii, but I'll post this in the right forum. 808-838-5464 ***************** End Of Article ****************** Michael W. Kreider posted Message 193 in Message Board Dated : May 18, 2000 at 21:35:40 EST Subject: WMS API Warehouse Management Integration with PkMS We have the WMS API's and have integrated with PkMS from Manhattan Associates. We would like to talk with someone else who has implemented the Peoplesoft WMS API's. We have a need to upgrade the application from 7.52 to 7.53. ***************** End Of Article ****************** rgk posted Message 194 in Message Board Dated : May 24, 2000 at 14:59:33 EST Subject: Re: conversion to packed decimal format : While sending data from PeopleSoft to IBM mainframe, I need to convert number to packed decimal format. Has anyone ever known the best way to handle this problem. : Thanks. My company sells a 3rd party product called REELExchange. It is a UNIX application that allows you to take data from an IBM Mainframe and convert it into standard UNIX data format. We can convert IBM Zoned Decimal and Packed Decimal fields, read tapes that span multiple volumes, read unlabeled data sets, etc. In addition to reading IBM mainframe tapes, we can also write UNIX data to an IBM Standard Label fomats. Cost is $3000 plus $540 per year for support & upgrades. ***************** End Of Article ****************** Hector Hernandez posted Message 195 in Message Board Dated : June 02, 2000 at 15:10:59 EST Subject: Inventory Transactions Interface Hello All, I need to interface all inventory transactions from an external system into PeopleSoft. For most transactions, i am pretty sure i am writing the data from flat files into the right set of tables. I am using SQR to do this, i can even visualize the info i am importing into PeopleSoft. But..... when you enter transactions online into Inventory, and save the panel, a bunch of PeopleCodes are executed, these do things like summarize the transaction info for the record PS_TRANSACTION_INV and update my item availble quantities. This i can NOT for my life do with SQR... so, i am importing the data fine, but my inventory status is not being updated!!!!! Anyone knows what i am doing wrong here? or how i could ago about importing all these transactions and getting all those PeopleCodes to run so my inventory gets updated... or anyone has any idea at all that could help me import these transactions correctly???? Thank you all in advance. Hector Hernandez. ps: i would appreciate sending me answers via email as well? ***************** End Of Article ****************** TECH_TEAM posted Message 196 in Message Board Dated : June 06, 2000 at 16:37:21 EST Subject: Re: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy A company called Crossworlds provides products to Integrate different ERP systems as well as integrate other sytems like CRMs e.t.c to your ERP. The product for Integrating ERP's is called Crossworld Enterprise vist web site www.crossworlds.com for more information. ***************** End Of Article ****************** christophe ledieu posted Message 197 in Message Board Dated : June 17, 2000 at 13:09:39 EST Subject: Re: Inventory Transactions Interface Hi Hector. There is a bunch of transactions PeopleSoft Inventory can do ! I am not too sure what you actually have to do (putaway, adjustments, MSR, bin-to-bin, ...) but by having faced the problem a couple of times, what I can tell you is not to simulate anything else than a receiving (putaway) using a SQR. Basically, when you don't have staging tables to populate (ex : staged_inf_inv, demand_inf_inv, ...), don't even try to do it, or you'll end up with all the possible discrepancies in your stock. The business rules enforced via the manifold transaction panels are very complicated, and can change based on the setup. And it is a lost of time to even think about figuring them out in a comprehensive way. Instead, try to use a message agent / database agent. Just in case you don't know what that is, it is standard tool that simulates an entry into a panel (like a user would do it). The pros is that all peoplecode business rules are enforced via the panel, even those you are not aware of. The cons is that it's not easy to write, and very slow in terms of processing (for instance, an adjustment or bin-to-bin transfer can take up to 5 seconds to execute. If you have large amounts of data to process on a daily basis, it is probably not a good idea to use this workflow tool...!) Hope this helps. Chris. : Hello All, : I need to interface all inventory transactions from an external system into PeopleSoft. For most transactions, i am pretty sure i am writing the data from flat files into the right set of tables. I am using SQR to do this, i can even visualize the info i am importing into PeopleSoft. But..... when you enter transactions online into Inventory, and save the panel, a bunch of PeopleCodes are executed, these do things like summarize the transaction info for the record PS_TRANSACTION_INV and update my item availble quantities. This i can NOT for my life do with SQR... so, i am importing the data fine, but my inventory status is not being updated!!!!! Anyone knows what i am doing wrong here? or how i could ago about importing all these transactions and getting all those PeopleCodes to run so my inventory gets updated... or anyone has any idea at all that could help me import these transactions correctly???? : Thank you all in advance. : Hector Hernandez. : ps: i would appreciate sending me answers via email as well? ***************** End Of Article ****************** christophe ledieu posted Message 198 in Message Board Dated : June 17, 2000 at 13:21:43 EST Subject: Re: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy Hi Terry. I've used a tool that does what U need. It is called OSCAR and really cool for real time interfacing. You can call an OSCAR service from a panel (windows) or from a UNIX platform. Hope this helps. Chris. : I have a client who has a requirement to interface SAP with a number of other systems including Peoplesoft. The interface needs to be synchronous or asynchronous and it should be able to detect whether the SAP system is down and store the data until the SAP system is back up. : I heard about a product from d.d. synergy called CCcom and I : was wondering if anyone has any experience with their product? : Thank you in advance for any information you might be able to provide. : Terry : TMHR Consulting ***************** End Of Article ****************** Rob posted Message 199 in Message Board Dated : June 20, 2000 at 16:43:16 EST Subject: ODBC Database Link Does anyone have any ideas on creating a Database link between PeopleSoft (on Oracle) and a legacy system (on SQL Server 7)? I know there is a way to create a DB link using SQL to pass the information. Any ideas? ***************** End Of Article ****************** Kishan posted Message 200 in Message Board Dated : June 27, 2000 at 06:40:42 EST Subject: AP: Document sequencing not working. We are using PeopleSoft 7.5 and loading vouchers from a leagacy system. The Vouchers are being loaded in to the PS_...._EC tables using a home written interface program. The next thing we do is copy the table contents to the work tables using VCHREC. After the VCHREC process all the DOC_... fields are blank or NULLed, with the exception of DOC_TYPE which is set to "VOUCHER". Finally we use the APPBVCHR process to edit the vouchers. What we are finding is that the vouchers Document sequences are not being set, but the document sequence date-time stamp is being set. We've checked that the Business units document sequence option is set. We've checked that the VOUCHER document type has a valid range. We've even created on-line vouchers which have document sequences. Can anyone help us with this problem? ***************** End Of Article ****************** Rob posted Message 201 in Message Board Dated : June 27, 2000 at 16:40:49 EST Subject: Re: AP: Document sequencing not working. Don'y know much about Document sequencing but have ou applied R-MSTERZ-HR5AH : We are using PeopleSoft 7.5 and loading vouchers from a leagacy system. The Vouchers are being loaded in to the PS_...._EC tables using a home written interface program. : The next thing we do is copy the table contents to the work tables using VCHREC. After the VCHREC process all the DOC_... fields are blank or NULLed, with the exception of DOC_TYPE which is set to "VOUCHER". : Finally we use the APPBVCHR process to edit the vouchers. What we are finding is that the vouchers Document sequences are not being set, but the document sequence date-time stamp is being set. : We've checked that the Business units document sequence option is set. : We've checked that the VOUCHER document type has a valid range. : We've even created on-line vouchers which have document sequences. : Can anyone help us with this problem? ***************** End Of Article ****************** Tony DeLia posted Message 202 in Message Board Dated : July 15, 2000 at 19:27:05 EST Subject: FREE Book Preview - Essential Guide to PeopleSoft Development and Customization Hello PeopleSoftFans, I posted some sample PDF files for the "Essential Guide to PeopleSoft Development and Customization" (Manning Publications - Delia, Landres, Rivera, Sankaran) on my website - http://www.sqrtools.com - The book is being printed and will be distributed in a couple weeks... The PDF samples include Chapter 9 (PeopleSoft Application Processor), Chapter 16 (Working with Scrolls), Chapter 35 (What is Application Engine), plus the Table of Contents, Index, Preface, etc... any feedback is, as always, greatly appreciated! Thanks! Tony DeLia http://www.sqrtools.com ***************** End Of Article ****************** Fryslan posted Message 203 in Message Board Dated : July 18, 2000 at 08:32:39 EST Subject: HELP!!!! I don't know where to go with my problem, so I hope that anyone here knows a solution that he or she can e-mail to me. Using Chrystal Reports 4.6, I am trying to create a report based on two tables on a SQL Server. The first two or three fields that I enter are ok, but when I add any more that might exceed the length of the line (option continue on following line is checked) I get this #*&$!! Dr Watson thing or the application just stops running. Who knows what to do here? Please e-mail me instead of submitting a reply here, because this is the first time for me here and I will probably not be able to find this board again. Thank you. ***************** End Of Article ****************** Sharad posted Message 204 in Message Board Dated : July 18, 2000 at 12:48:55 EST Subject: Runnning an Import from the command line I have created an Import File Definition. I need to invoke the Import Manager and run the import definition I have created, directly from the command line(without bringing up the Import Manager screen). What command-line parameters do I need to use. Thanks ***************** End Of Article ****************** ESTELLA langot posted Message 205 in Message Board Dated : July 19, 2000 at 02:09:29 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Pamela Jordan posted Message 206 in Message Board Dated : July 24, 2000 at 10:13:23 EST Subject: Problems printing SQR Reports within PeopleSoft Hello, The platforms I'm running PeopleSoft on is a NT Workstation. I need help with printing PeopleSoft reports to the HP8100 printer. The printer is setup as a LPR printer with IP address. When I try to send a SQR report, from within PeopleSoft, to this printer, they are not getting there. I have no problems printing documents from other applications to this printer, so I know the problem is not with the printer. Can anyone give me some suggestions? ***************** End Of Article ****************** Wayne Pinckley posted Message 207 in Message Board Dated : July 26, 2000 at 17:54:10 EST Subject: Re: Problems printing SQR Reports within PeopleSoft Pamela, Make sure that you capture the printer to the LPT1 port. SQR may be printing as a dos program and not seeing the printer defined for Windows. Hope this helps Wayne ***************** End Of Article ****************** Brian DeVaul posted Message 208 in Message Board Dated : July 27, 2000 at 10:49:42 EST Subject: Re: Inventory Transactions Interface : Hi Hector. : There is a bunch of transactions PeopleSoft Inventory can do ! : I am not too sure what you actually have to do (putaway, adjustments, MSR, bin-to-bin, ...) but by having faced the problem a couple of times, what I can tell you is not to simulate anything else than a receiving (putaway) using a SQR. : Basically, when you don't have staging tables to populate (ex : staged_inf_inv, demand_inf_inv, ...), don't even try to do it, or you'll end up with all the possible discrepancies in your stock. : The business rules enforced via the manifold transaction panels are very complicated, and can change based on the setup. : And it is a lost of time to even think about figuring them out in a comprehensive way. : Instead, try to use a message agent / database agent. : Just in case you don't know what that is, it is standard tool that simulates an entry into a panel (like a user would do it). : The pros is that all peoplecode business rules are enforced via the panel, even those you are not aware of. : The cons is that it's not easy to write, and very slow in terms of processing (for instance, an adjustment or bin-to-bin transfer can take up to 5 seconds to execute. If you have large amounts of data to process on a daily basis, it is probably not a good idea to use this workflow tool...!) : Hope this helps. : Chris. : : Hello All, : : I need to interface all inventory transactions from an external system into PeopleSoft. For most transactions, i am pretty sure i am writing the data from flat files into the right set of tables. I am using SQR to do this, i can even visualize the info i am importing into PeopleSoft. But..... when you enter transactions online into Inventory, and save the panel, a bunch of PeopleCodes are executed, these do things like summarize the transaction info for the record PS_TRANSACTION_INV and update my item availble quantities. This i can NOT for my life do with SQR... so, i am importing the data fine, but my inventory status is not being updated!!!!! Anyone knows what i am doing wrong here? or how i could ago about importing all these transactions and getting all those PeopleCodes to run so my inventory gets updated... or anyone has any idea at all that could help me import these transactions correctly???? : : Thank you all in advance. : : Hector Hernandez. : : ps: i would appreciate sending me answers via email as well? I'm been running into the same problem. Wish to interface with VB for putaway, but having a horrible time with message agent to work with the 2nd Level data entry panels of express putaway. PS did NOT ship the message agent examples described in the book with the installation. Without the message agent defination examples I'm at a lost as to get them to work. Any help would be much appreciated. ***************** End Of Article ****************** François Roy posted Message 209 in Message Board Dated : July 27, 2000 at 12:46:58 EST Subject: Re: conversion to packed decimal format I found a clear description of packed decimal as understood by IBM mainframes at http://student.cqu.edu.au/lists/archives/ic-forum/1998/04/msg00001.html Basically, each byte represents two digits (each half-byte containing a digit 0-9) with the last byte being the exception: the rightmost 4 bits of the last byte represent the sign (hex D is negative; either hex C or F for positive). ***************** End Of Article ****************** Scott Beard posted Message 210 in Message Board Dated : August 02, 2000 at 15:05:32 EST Subject: EDI - Bringing in PO Vouchers and calculating Distrib Lines I'm trying to bring in PO Vouchers. The problem is calculating the distrib lines since this data will not be coming in from the vendor. Has anyone tackled this yet? Thanks for any help!! ***************** End Of Article ****************** Christina posted Message 211 in Message Board Dated : August 08, 2000 at 12:23:10 EST Subject: Re: Chrystal Reports : : Does PeopleSoft have an option to export the data to a Chrystal Report? Thanks. : : Yes.If you write a query ,you can direct the output to Crystal/Nvision(XL) etc... : Hope that helps : Waja ***************** End Of Article ****************** Christin posted Message 212 in Message Board Dated : August 08, 2000 at 12:24:34 EST Subject: Re: Chrystal Reports Does anybody know where to buy Chrystal Reports books from the net? A response would be greatly appreciated. ***************** End Of Article ****************** Christina posted Message 213 in Message Board Dated : August 08, 2000 at 12:25:03 EST Subject: Re: Chrystal Reports : Does anybody know where to buy Chrystal Reports books from the net? A response would be greatly appreciated. ***************** End Of Article ****************** James Cherian posted Message 214 in Message Board Dated : August 11, 2000 at 08:28:16 EST Subject: Interface with 3rd Party Application We have the HR module of PeopleSoft (HRMS 7.01 & PeopleTools 7.06). Does anyone know what is the best way to transfer data to an Oracle based 3rd party application. Everytime the PeopleSoft Human Resource table is updated, some of the data need to be sent to a file in the 3rd party application (Oracle database), and the table has to be updated. I am quite new to PeopleSoft and Oracle. Any help will be appreciated. Thanks. ***************** End Of Article ****************** Wayne Pinckley posted Message 215 in Message Board Dated : August 16, 2000 at 21:46:12 EST Subject: Re: Interface with 3rd Party Application James, Some of the HR tables are effective dated, you can use that date to determine if the row needs to be pulled off in an interface. For example if you run an interface once a week, then you would select rows created since the last time the process was run. Some tables are not effective dated, for those tables you create an audit record, and if the data is changed, a row is written to the audit table. You read the audit table to determine which rows have been modified since the last time the process was run, and use that information to get the information. ***************** End Of Article ****************** Paul posted Message 216 in Message Board Dated : August 19, 2000 at 13:31:12 EST Subject: Interface file Hi Does anyone help me sharing the AETNA healthcare interface file. Thanks Raj. ***************** End Of Article ****************** Jo posted Message 217 in Message Board Dated : August 23, 2000 at 02:59:10 EST Subject: Integration with 3rd party Hi, Grateful for any help in finding information on how you go about interfacing PeopleSoft (HRMS 7.5) with a 3rd party application (Call centre setup) for read and update through the 3rd party. ?message agent API's Thanx ***************** End Of Article ****************** Myrna Nevarez posted Message 218 in Message Board Dated : August 24, 2000 at 12:59:11 EST Subject: Interfacing to P3 Hi. I need to Interface Projects to P3 and I am having trouble finding any documentation on setting up the Import.BTC file in Primavera. Has anyone done this interface? ***************** End Of Article ****************** JOHN LU posted Message 219 in Message Board Dated : August 28, 2000 at 12:01:16 EST Subject: Migrating PS FIN from Oracle to SQLServer Does anyone have docs or info on how to migrate an existing PS database from Oracle to SQLServer (i.e. using Data Mover). ***************** End Of Article ****************** Alex Ocher posted Message 220 in Message Board Dated : August 30, 2000 at 14:13:25 EST Subject: Using JNI to connect to Message Agent on AIX Hello all, Did anybody tried using Message Agent on AIX? If so, I have a question: I'm trying to connect to PeopleSoft using shared library via Java Native Interface (JNI) and it does not. However the same library does work with standard C++ compiler. I'm using the following Makefile: JAVA_HOME=/usr/java_dev2 libtest.so: Test.o rm -f libtest.so ld -brtl -bexpall Test.o -o libtest.so /opt/peoplesoft/pt758/msgapi/api/ *.a -bnoentry -lc -lC -bM:SRE -ldl Test.class: Test.java ${JAVA_HOME}/sh/javac Test.java ${JAVA_HOME}/sh/javah -jni Test Test.o: Test.cc Test.class xlC -Dunix \ -I/opt/peoplesoft/pt758/msgapi/inc \ -DAIX -g -c -I. -I${JAVA_HOME}/include -o Test.o Test.cc clean: rm -f *.class *.o Test.h libtest.so Test.java: public class Test { int my_int_var; public Test() { my_int_var = 777; } public static void main(String argv[]) throws java.io.IOException { System.out.println("(Java code) JNI example"); System.loadLibrary("test"); Test t = new Test(); double y = t.myNative(42,"Hello!"); } public native double myNative(int number, String text); } Test.cc: #include #include #include #include "Test.h" #include PSMSGHANDLE hCtx; JNIEXPORT jdouble JNICALL Java_Test_myNative (JNIEnv *env, jobject obj, jint number, jstring text) { PSOPERATOR Opr; int Result; int nReplyOption; strcpy(Opr.szOprId, "XX"); strcpy(Opr.szOprPswd, "XX"); Result = PSMsgConnect(PSMSG_APIVERSION, "test:7000", &Opr, &hCtx); if (Result != PSMSG_OK) printf("Error in Connect\n"); return 9.7; } When I try to run it: java Test (Java code) JNI example SIGILL 4 (*) illegal instruction (not reset when caught) si_signo [4]: SIGILL: (*) illegal instruction (not reset when caught) si_errno [0]: Error 0 si_code [30]: Error 0 [addr: 0x0] stackpointer=2ff21bc8 Writing java dump to javacore48938.967660702.txt... OK SIGABRT 6 (*) abort process stackpointer=2ff215e8 Abort process The combination above does not work. However, the generated shared library works fine with the regular C++ code: good.cpp: #include #include JNIEXPORT jdouble JNICALL Java_Test_myNative (JNIEnv *env, jobject obj, jint number, jstring text); int main(int argc, char **argv) { Java_Test_myNative(0, 0, 0, 0); return 0; } To compile: xlC -brtl -I. -I{JAVAHOME}/include good.cpp -o good libtest.so When I run it: ./good it works fine. I'm having this problem on AIX machines only; other OSes (HPUX, Solaris, etc.) are fine. Thank you in advance. ***************** End Of Article ****************** Ken posted Message 221 in Message Board Dated : August 31, 2000 at 12:49:02 EST Subject: Re: PeopleSoft-Oracle interface Let me know if you find out anything ... Next year we are scheduled to interface PeopleSoft 7.5 Payroll with Oracle 11.0 Financials. ***************** End Of Article ****************** Benedict De Castro posted Message 222 in Message Board Dated : September 04, 2000 at 03:44:37 EST Subject: Re: P/S Payroll System Design : : i am a student in fourth year,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Ong SH posted Message 223 in Message Board Dated : September 05, 2000 at 09:35:08 EST Subject: Re: Import Orders into OM I know EDI Manager in PS can be used to import data into PS OM, but havent implemented it yet. : I am trying to import orders placed over the web into PS Order Management 7.5. What is the best way to import the data into the PeopleSoft dB? We are currently running 3-tier on Oracle dB. : Thanks in advance, : Brian ***************** End Of Article ****************** ALLAN GOMEZ posted Message 224 in Message Board Dated : September 06, 2000 at 05:05:50 EST Subject: Re: P/S Payroll System Design : : i am a student in FORTH YEAR,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** ALLAN GOMEZ posted Message 225 in Message Board Dated : September 06, 2000 at 05:07:30 EST Subject: Re: P/S Payroll System Design : : i am a student in FORTH YEAR,my computer project is payroll system design and i need some points to help me in the main structure of my project.I need a design that can help me to gather information. ***************** End Of Article ****************** ALLAN GOMEZ posted Message 226 in Message Board Dated : September 06, 2000 at 05:11:06 EST Subject: Re: Payroll interface : Does anyone have a design of a payroll system that can be integrated with finger scan? : Were using visual basic ver.6.0 : Thanks. ***************** End Of Article ****************** ALLAN GOMEZ posted Message 227 in Message Board Dated : September 06, 2000 at 05:14:32 EST Subject: Re: Payroll DESIGN INTEGRATED WITH FINGER SCAN : I am intrested in learning Payroll Design with the integration of finger scan. : : Peoplebooks donot seem to help. : Can someone give me tips(website/books .etc..) where I can learn Payroll Design that is integrated with finger scan. : Appreciate your help : Waja ***************** End Of Article ****************** Michael Bryant posted Message 228 in Message Board Dated : September 14, 2000 at 11:32:12 EST Subject: Interface to PS 7.5 from Web Any ideas on methods for a bi-directional interface to PS 7.5 from a 3rd party HR vendor specializing in XML. I would appreciate ideas for real-time and batched. Thank you in advance ***************** End Of Article ****************** Kevin Chelius posted Message 229 in Message Board Dated : September 19, 2000 at 17:09:30 EST Subject: Integrating PS HR or Payroll I work for an employee portal company and many of our clients use PeopleSoft HR and/or PeopleSoft Payroll. I'm investigating methods to automate our access to these systesm. Currently, we employ a datafile method, whereby the company outputs from PS to a datafile. We then input the datafile. I'd like to build a bridge from PS to our portal. I would appreciate guidance on the right direction to persue. Where can I get information on the PS API's and archetecture? Are there middleware companies which already have figured out how to do this? Thanks Kevin ***************** End Of Article ****************** Steve posted Message 230 in Message Board Dated : September 20, 2000 at 11:52:44 EST Subject: Re: Problems printing SQR Reports within PeopleSoft Hello Pamela, Here is a little "tips" to print a SQR report. When you wanna launch the report, when the "Process Scheduler Request" appears write the full printer path. For example: //network_name/printer_name. I hope it helps you. Best Regards. Steve. -------------------------------------------------------- : Hello, : The platforms I'm running PeopleSoft on is a NT Workstation. I need help with printing PeopleSoft reports to the HP8100 printer. The printer is setup as a LPR printer with IP address. When I try to send a SQR report, from within PeopleSoft, to this printer, they are not getting there. I have no problems printing documents from other applications to this printer, so I know the problem is not with the printer. Can anyone give me some suggestions? ***************** End Of Article ****************** Sonny Chen posted Message 231 in Message Board Dated : October 02, 2000 at 04:27:12 EST Subject: JDBC/ODBC question I am consider that the ODBC calls to Peoplessoft. However, follow the set up panle, I need to set up not only username and password, but also the server and so on. It looks like I need to put too many static input to run the ODBC. Also, the driver for the JDBCODBC driver which is needed to setup and runing. Is anyone knows how to do that? Thanks ***************** End Of Article ****************** darshana hettiarachci posted Message 232 in Message Board Dated : October 04, 2000 at 01:10:19 EST Subject: Re: P/S Payroll System Design : : : i am a student in FORTH YEAR,my computer project is payroll system design and i need some points to help me in the main structure of my project.I need a design that can help me to gather information. ***************** End Of Article ****************** Nandu posted Message 233 in Message Board Dated : October 09, 2000 at 05:53:51 EST Subject: Interface Tables with Tuxedo Dear All, Can I extract data from PeopleSoft Interface Tables using Tuxedo API? Are Interface Tables available for all the modules of PeopleSoft? Thanks & Regards Nandu ***************** End Of Article ****************** Nandu posted Message 234 in Message Board Dated : October 09, 2000 at 06:04:15 EST Subject: Interface Tables using Message Agent API Dear All, Can I use Message Agent API to extract data from Interface Tables? I need your suggestion how to extract data from Interface Tables. Thanks & Regards Nandu ***************** End Of Article ****************** Ray MacInnis posted Message 235 in Message Board Dated : October 16, 2000 at 18:56:44 EST Subject: Interface Between P/O & A/P on Different Database Instances Can anyone share any positive or negative experiences on building and managing an interface from the PS P/O and A/P modules running on different servers or database instances. Currently our A/P, G/L and Projects modules reside on 1 server. We are implementing Purchasing and Inventory on another server, and would have to build an interface to share data between the two instances. Thanks for any help. ***************** End Of Article ****************** evguenia posted Message 236 in Message Board Dated : October 19, 2000 at 15:09:47 EST Subject: retrieving data in XML format Hi, My java application needs to interface to PeopleSoft Student Administation. We are on 7.59 now. I'd like to be able to retrieve student data as xml streams and avoid going directly at oracle tables. I could not find any technical documetation in either 7.59 or what is publicly available through customer connection on 8 that could help me understand how to do this. Any help appreciated. ***************** End Of Article ****************** marie posted Message 237 in Message Board Dated : November 07, 2000 at 22:19:35 EST Subject: Re: Message Agent and CUSTOMER table : I am attempting to add a customer record using message agent. If I add the customer inputting fields that are only found in the CUSTOMER table (level 0) then I have no problems. If I attempt to add a customer with "Bill to Customer" (on panel CUSTOMER_GEN2), "Bill to Address" (on panel CUSTOMER_ADDRESS), and "Primary" (on panel CUSTOMER_ADDRESS) set to "Y", then I get the error "Unable to update value. (54,10)". Table and field are not specified. I don't see that i'm doing anything different from what an online user is doing when adding a new customer. : Any thoughts ?? (same occurs for ship-to and sold-to) Reply: I am having the same problems and was wondering if you were able to solve your initial problem? Can you shed some light on this? MV ***************** End Of Article ****************** Richard Cruse posted Message 238 in Message Board Dated : November 10, 2000 at 10:46:34 EST Subject: Resolution Issue I have a question about PeopleSoft. Is there a way to make the text on the menu bar as well as in the text fields LARGER? The Problem: We are having a time getting Sapiens/COMSTAR and PeopleSoft to work together amiably. Sapiens/COMSTAR likes to be displayed at 1024 x 768 while PeopleSoft *unfortunately* is unreadable at that resolution (it refers, I believe, 800 x 600). It's too much of a pain to have everyone switch their resolution back and forth so we are trying to implement a java-enable browser version of Sapiens/COMSTAR that will effectively work around the problem. However, as a backup, we thought that if we increased the size of everyone's screen from a 17" to a 21" that that might fix the problem. Sounds logical-right? Well...it did not quite work. The buttons and text on the 21" monitors at 800 x 600 are larger than they are on the 17" monitors at the same resoltion but switching the larger monitors up to 1024 x 768 makes the text and buttons too small to work with. About half as small as they are on the 17" (800 x 600). Help? Thanks much for any info you may have, Richard Cruse ***************** End Of Article ****************** Carol Wheeler posted Message 239 in Message Board Dated : November 17, 2000 at 16:51:18 EST Subject: Re: Interface Between P/O & A/P on Different Database Instances : Can anyone share any positive or negative experiences on building and managing an interface from the PS P/O and A/P modules running on different servers or database instances. : Currently our A/P, G/L and Projects modules reside on 1 server. We are implementing Purchasing and Inventory on another server, and would have to build an interface to share data between the two instances. : Thanks for any help. Normally, the financials and the distribution (PO & IN) reside on the same server. Because of the delivered interface between the modules. Everytime a transaction is generated in either PO or Inv, and line is written to the chart field accounts. Normally, the PO & AP modules share files (i.e. vendor, location, etc.) The financial modules also use the inventory master files. I would not recommend setting your system up this way. Have you thought of using three tier instead. ***************** End Of Article ****************** Zack Hu posted Message 240 in Message Board Dated : November 21, 2000 at 14:21:16 EST Subject: Re: How to start MESSAGE AGENT ??? You need to create the necessary message agent definition used by your db agent. : Hi : If you are running PeopleSoft in 3-Tier then all the PeopleSoft Client (Web, PeopleSoft Panel or Any other) uses the Message Agent to run the business rules coded in PeopleCode. So, again verify with your DBA or Admin people that you are running all the services to run the PeopleSoft in 3-tier : Ketan : : Hi , : : I need some help on Message Agent . : : I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . : : Oracle 8.1.5 on Solaris 2.6 & : : Windows NT 4.0 Server as file Server : : : : I am trying to run the Databse Agent from command line .The command line parameters are as following : : psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T : : When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and : : Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . : : Process Instance=0 : : Activity Name=Deliver Reports : : Message Definition Name=Report Delivery : : Topic Name=//rpt inst:7000 : : Query Name = _DBAG__REPORT_DELIVERY : : 15.06.28:run query : : 15.06.28:fetch rows : : Message Agent not started : : 15.06.28:done : : : : Now Can you please tell me How do I START a Message Agent ?? : : I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. : : : : Looking forward for help , : : : : Warm regards : : Vishwa ***************** End Of Article ****************** Zack Hu posted Message 241 in Message Board Dated : November 21, 2000 at 14:24:43 EST Subject: Re: Connect method in Message Agent The port number is the application server port number. Usually, it is 7000. But you admin may confiqure to be around 7000 neighborhood. : When accessing PeopleSoft through the Message Agent using VB, use the OLE automation interface and not the C interface. I have never been able to use the C interface, but have done some prototyping using the OLE automation interface and it has worked successfully. : : : : Hi all, : : I am trying to use Message Agent API from VB. I am having problems in the connect method. In the Peoplebooks, they mention about Port Number as a parameter. I don't know exactly what it means. Any help in this regard is highly appreciated. : : Thanks in advance. ***************** End Of Article ****************** Krzysztof posted Message 242 in Message Board Dated : November 29, 2000 at 11:19:02 EST Subject: PSFT with Vantive Im looking for some description of integration CRM Vantive with PSFT Reciveables. Do you know anything about using QuickConnect? or anything similar? ***************** End Of Article ****************** David Potter posted Message 243 in Message Board Dated : November 29, 2000 at 19:47:56 EST Subject: Delivered psmsgapi.h gives syntax error when compiling in MS Visual C++ Hello, In the PeopleTools PeopleBook Message Agent section there is a simple Message Agent program written in C/C++. When I try to use that exact code in Microsoft Visual C++ and try to compile it I get the following error. Could anyone please give advice on this? This is very much appreciated. Thanks, David 818-977-3427 david.potter@warnerbros.com d:\pt705\src\inc\psmsgapi.h(112) : error C2061: syntax error : identifier 'PSMSGHANDLE' d:\pt705\src\inc\psmsgapi.h(112) : error C2059: syntax error : ';' d:\pt705\src\inc\psmsgapi.h(120) : error C2061: syntax error : identifier 'INT' d:\pt705\src\inc\psmsgapi.h(127) : error C2061: syntax error : identifier 'nFieldSize' d:\pt705\src\inc\psmsgapi.h(127) : error C2059: syntax error : ';' d:\pt705\src\inc\psmsgapi.h(128) : error C2061: syntax error : identifier 'fFieldMapUse' d:\pt705\src\inc\psmsgapi.h(128) : error C2059: syntax error : ';' d:\pt705\src\inc\psmsgapi.h(133) : error C2061: syntax error : identifier 'fFieldMapTransfer' ***************** End Of Article ****************** David Potter posted Message 244 in Message Board Dated : November 29, 2000 at 20:25:03 EST Subject: Re: VBScript I get the following error: C:\_DEV>cscript 3.vbs Microsoft (R) Windows Script Host Version 5.1 for Windows Copyright (C) Microsoft Corporation 1996-1999. All rights reserved. C:\_DEV\3.vbs(2, 9) Microsoft VBScript compilation error: Expected end of statement I actually was not expecting it would work because the VB Script documentation gives the following syntax for the Dim statement Dim varname[([subscripts])][, varname[([subscripts])]] . . . So how could I Dim variables as a certain datatype as in your example ? : Try this : Dim nReplyOption& : Dim Mag As CMagAutoServer : Dim Result As Variant : Set Mag = CreateObject("PeopleTools.MessageAgent") : Result = Mag.StartMessage("ACT_AGT", "AgentList", False) : Result = Mag.ProcessMessage(nReplyOption) : That should work : : I am trying to call ProcessMessage function in the message agent from my VBScript web page. The function takes a long*. I dim a variable and then pass it and I get a type mismatch. Even with I try to convert my variable with CLng I still get the error. Anyone have any suggestions. : : Thanks ***************** End Of Article ****************** Dave posted Message 245 in Message Board Dated : November 29, 2000 at 22:18:32 EST Subject: Will pay for help writing a message agent program. Hello, I need help writing a message agent program in C for Peopletools 7.05. I am happy to pay you for your time. dphs@earthlink.net 818-550-0670 ***************** End Of Article ****************** Zack Hu posted Message 246 in Message Board Dated : December 07, 2000 at 11:23:03 EST Subject: Re: Delivered psmsgapi.h gives syntax error when compiling in MS Visual C++ You have to include psmsg.lib in your VC++ lib path. : Hello, : In the PeopleTools PeopleBook Message Agent section there is a simple Message Agent program written in C/C++. When I try to use that exact code in Microsoft Visual C++ and try to compile it I get the following error. Could anyone please give advice on this? This is very much appreciated. : Thanks, : David : 818-977-3427 : david.potter@warnerbros.com : : d:\pt705\src\inc\psmsgapi.h(112) : error C2061: syntax error : identifier 'PSMSGHANDLE' : d:\pt705\src\inc\psmsgapi.h(112) : error C2059: syntax error : ';' : d:\pt705\src\inc\psmsgapi.h(120) : error C2061: syntax error : identifier 'INT' : d:\pt705\src\inc\psmsgapi.h(127) : error C2061: syntax error : identifier 'nFieldSize' : d:\pt705\src\inc\psmsgapi.h(127) : error C2059: syntax error : ';' : d:\pt705\src\inc\psmsgapi.h(128) : error C2061: syntax error : identifier 'fFieldMapUse' : d:\pt705\src\inc\psmsgapi.h(128) : error C2059: syntax error : ';' : d:\pt705\src\inc\psmsgapi.h(133) : error C2061: syntax error : identifier 'fFieldMapTransfer' ***************** End Of Article ****************** Zack Hu posted Message 247 in Message Board Dated : December 07, 2000 at 11:29:26 EST Subject: Re: Interface Tables using Message Agent API If you only want to do extraction, you'll be better off using sqr or some other means. Message Agent API only makes sense if you want to input. otherwise, it is much too painful to be worthwhile. Zack : Dear All, : Can I use Message Agent API to extract data from Interface Tables? : I need your suggestion how to extract data from Interface Tables. : Thanks & Regards : Nandu ***************** End Of Article ****************** Hari posted Message 248 in Message Board Dated : December 18, 2000 at 17:59:02 EST Subject: Open Query API Hello, We are in the process of interfacing a third party application with Peoplesoft and have written a COM for this. The process is to go from an ASP page to a DSN (w / Peoplesoft driver) via a wrapper (COM). We are having some problems doing this with Oracle and DB2 backends. Any suggestions / also looking for consultants with Experiance with the Open Query API. Cheers. ***************** End Of Article ****************** Hunter Praywell posted Message 249 in Message Board Dated : December 28, 2000 at 04:05:41 EST Subject: Re: Interface Between P/O & A/P on Different Database Instances Carol's post is on the money, though I'm no big fan of the Purchasing module, the overwhelming benefit of this solution is the tight integration of these two modules. In addition to the Carol's table sharing requirements, integrated AP / PO systems allow purchasing users to research the status of a vendor invoice, and AP to research whether a PO exists, when it was created, terms and receipt status. For instance, if you vendor calls your purchasing agent to complain that a bill isn't paid, the agent can go online to inquire as to the status of the vendor's voucher, payment date, match exceptions and so on(all in the AP module). Additionally, our AP and PO users constantly need to see each other's applications to clear AP matching exceptions. If you have sized your boxes correctly, I can't think of a reason why you would want to store the data for these applications on different boxes. ***************** End Of Article ****************** ccweng posted Message 250 in Message Board Dated : January 07, 2001 at 21:33:15 EST Subject: defraging tables Can ALL Peoplesoft's tables be 'defrag' using data mover by export/truncate/import? Will I hit into any problem on importing back the data, such as caused by referential integrity, constraints, or whatever? What would be the safest way to do so? I'm on PS 5.8 / Oracle 7.3.4 / Solaris 2.6 Many thanks. ***************** End Of Article ****************** ahmed posted Message 251 in Message Board Dated : January 16, 2001 at 07:17:53 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** shelly goodman posted Message 252 in Message Board Dated : January 18, 2001 at 09:58:09 EST Subject: Learning Christal Reports Our company will be updating our system to a windows application and many reports will be using Christal Reports. I would like to learn as much as I can about them and would like to know where I can get this information. Thank you. ***************** End Of Article ****************** Steve _D posted Message 253 in Message Board Dated : January 18, 2001 at 15:39:41 EST Subject: Well, first of all it's Crystal Reports There are lots of education centers with Crystal Classes, many community colleges offer them, and there are plenty of good books on the subject. ***************** End Of Article ****************** Sudhir posted Message 254 in Message Board Dated : January 20, 2001 at 09:04:12 EST Subject: HRMS Demo Query Hi All The following Query is in regard to PS HRMS Demo Version 7.5 - Single User. Please help me. 1.We are building Messaging Agents in Java to transport data from Peoplesoft (PS) database to some other ERP. PS has some pre-defined plug-ins given in the People Tools Integration part. Two of them are: MsgConnect(Version, IP,...) MsgStartMessage(MessageDefn, ActivityNAme,...) Now the problem we are facing here is 1. What IP should be given as we are using the HRMS Demo Version 7.5 as the base. The Demo is SIngle-User, so physically everything i.e. the Database Server, Application Server n the client are on the same machine. 2. In the second Plug-in, what is the MessageDefn? Is it the name of the Java Adapters developed or someting else? 2) What are the ODBC drivers that should be mentioned for this database connectivity? Is it same as the machine on which the Demo is installed, or any port number or something else? 3)When we are extracting data from the PS database, is it to be extracted from the Panels or Background tables? 4)How can data be extracted / fed from / to PS version 7 n below. Apparently there seems to no backward compatibility. Please reply ASAP. Thnx n Rgds Sudhir Nilekar ***************** End Of Article ****************** Bryan Selwood posted Message 255 in Message Board Dated : January 23, 2001 at 06:21:23 EST Subject: ActiveWorks (Webmethods) and Pivotal Has anyone worked with ActiveWorks (now Webmethods) and Pivotal. We are looking for help/pointers about the PivotalLink product and the use of it with ActiveWorks EAI engine. Has anyone used either systems or both together? ***************** End Of Article ****************** kurt posted Message 256 in Message Board Dated : January 25, 2001 at 10:02:59 EST Subject: Re: Integrating PS HR or Payroll on 7.x you can use the Message Agent api, but from my experience it is not totally reliable, and best used for small , non-critical updates. in version 8, i believe the options are much better , but it sounds like you are tied to the version of your clients. if you need details, you can email me : I work for an employee portal company and many of our clients use PeopleSoft HR and/or PeopleSoft Payroll. I'm investigating methods to automate our access to these systesm. Currently, we employ a datafile method, whereby the company outputs from PS to a datafile. We then input the datafile. I'd like to build a bridge from PS to our portal. : I would appreciate guidance on the right direction to persue. Where can I get information on the PS API's and archetecture? : Are there middleware companies which already have figured out how to do this? : Thanks : Kevin ***************** End Of Article ****************** Dan posted Message 257 in Message Board Dated : January 30, 2001 at 05:56:33 EST Subject: Re: Message Agent and CUSTOMER table Unable to Update 54,10 is a very generic error. The most typical cause is trying to map to a field on a lower level before mapping all fields on the current. if you give the full message definition including all fields it may be easier. Dan. Dan Byer Technical Architect @Business Europe Ltd. : : I am attempting to add a customer record using message agent. If I add the customer inputting fields that are only found in the CUSTOMER table (level 0) then I have no problems. If I attempt to add a customer with "Bill to Customer" (on panel CUSTOMER_GEN2), "Bill to Address" (on panel CUSTOMER_ADDRESS), and "Primary" (on panel CUSTOMER_ADDRESS) set to "Y", then I get the error "Unable to update value. (54,10)". Table and field are not specified. I don't see that i'm doing anything different from what an online user is doing when adding a new customer. : : Any thoughts ?? (same occurs for ship-to and sold-to) : : Reply: I am having the same problems and was wondering if you were able to solve your initial problem? : Can you shed some light on this? : MV ***************** End Of Article ****************** Jon K. Lazar posted Message 258 in Message Board Dated : January 31, 2001 at 06:13:42 EST Subject: MICR printers - consumables - checkstock Kyocera MICR line - see the benefit of the secure Micr font/signature card that is removed from the printer as a secure feature. 14 - 18 - 28 page per minute Checkstock; All styles, color, and specifications. 888-731-8560 ***************** End Of Article ****************** Jon K. Lazar posted Message 259 in Message Board Dated : January 31, 2001 at 06:15:53 EST Subject: Standard Register 5418 Micr consumables We provide Toner, Maintenance kits and an upgrade for this printer. 888-731-8560 Jon K. Lazar ***************** End Of Article ****************** Cheryl Stine posted Message 260 in Message Board Dated : February 01, 2001 at 14:35:35 EST Subject: anyone using ps8 app messaging/comp interfaces/bsns interlinks? Has anyone used the new integration technologies available in ps8 - application messaging, component interfaces and business interlinks? If so, how is it working out for you? ***************** End Of Article ****************** fakhruddin posted Message 261 in Message Board Dated : February 02, 2001 at 02:31:23 EST Subject: Re: Payroll DESIGN INTEGRATED WITH FINGER SCAN : : I am intrested in learning Payroll Design with the integration of finger scan. : : : : Peoplebooks donot seem to help. : : Can someone give me tips(website/books .etc..) where I can learn Payroll Design that is integrated with finger scan. : : Appreciate your help : : Waja ***************** End Of Article ****************** karthik posted Message 262 in Message Board Dated : February 05, 2001 at 07:18:47 EST Subject: Re: PeopleSoft calling function in C/C++ DLL : : Is there a way for PeopleSoft to call a C or C++ function : : in a Windows DLL? ***************** End Of Article ****************** mmm posted Message 263 in Message Board Dated : February 07, 2001 at 13:01:21 EST Subject: Infinium GL interface to P/S Can anyone clue me in as to what is needed to interface Infinium's GL system to P/S? Or where I can locate the necessary information? ***************** End Of Article ****************** Alan posted Message 264 in Message Board Dated : February 07, 2001 at 19:04:43 EST Subject: Re: anyone using ps8 app messaging/comp interfaces/bsns interlinks? : Has anyone used the new integration technologies available in ps8 - application messaging, component interfaces and business interlinks? If so, how is it working out for you? ::Yeah, I'd like to see this answer too. I just upgrade a client from 7.5 to 8.0 and didn't get the chance to use any of the integration tools. The client simply wanted to migrate to the new environment for the 4 tier Arch. I felt so imcomplete about it all that I took the PeopleTool 8.12 Delta Class to make up for what they didn't do. What I want to know is are people really taking advantage of the new functionality. It seems a wonderful thing, but my last client was not even looking at it. ***************** End Of Article ****************** ABDULLAH ALAMRI posted Message 265 in Message Board Dated : February 13, 2001 at 02:37:33 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 18 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Haroun Bin Omar E. Manabilang posted Message 266 in Message Board Dated : February 15, 2001 at 02:05:31 EST Subject: Re: P/S Payroll System Design : : : : i am a student in THIRD YEAR,my computer project is payroll system design and i need some points to help me in the main structure of my project.I need a design that can help me to gather information. ***************** End Of Article ****************** rurup posted Message 267 in Message Board Dated : February 16, 2001 at 05:52:19 EST Subject: Re: Learning Christal Reports : Our company will be updating our system to a windows application and many reports will be using Christal Reports. I would like to learn as much as I can about them and would like to know where I can get this information. : Thank you. ***************** End Of Article ****************** Mark posted Message 268 in Message Board Dated : February 20, 2001 at 12:15:10 EST Subject: Anyone integrated into PS Public Sector 7.5 Purchasing? Hi, We are in the early stages of integrating a third party eprocurement system with PeopleSoft Public Sector 7.5 Purchasing. I believe using the message agent to get data into PS is the right tool. My biggest concern is how to get REQLOAD, REQEDIT, BCM, and REQPOST to look for work, process the requisition and send back appropriate failure/success messages to the calling eprocurement software. I'm starting to think that something like this has never been done??? Any help would be greatly appreciated. ***************** End Of Article ****************** Krit posted Message 269 in Message Board Dated : February 21, 2001 at 12:17:12 EST Subject: Learning Crystal Reports : Our company will be updating our system to a windows application and many reports will be using Christal Reports. I would like to learn as much as I can about them and would like to know where I can get this information. : Thank you. Try Seagate.com. They are the originators of the software. They have live training classes too ***************** End Of Article ****************** kaushal kishore posted Message 270 in Message Board Dated : February 24, 2001 at 06:07:34 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Balaji Raya posted Message 271 in Message Board Dated : February 26, 2001 at 15:49:25 EST Subject: Calling C++ from Java using JNI on HPUX involves String operations I am able to call C++ function from Java (JDK 1.3) using JNI. But I am unable to make a shared code, which involves String operations. I think the String operations (Standard) comes under lib++ library which is Archive on HPUX, but not as Shared. Sample C++ code: #include class Hello { int Number(int); String Name(String); }; int Hello::Number(int numb) { cout << "Received Number: " << numb << endl; return (numb++); } String Hello::Name(String lastName) { String fullName = "Yahoo……"; cout << "Received Name: " << lastName << endl; firstName += lastName; return (fullName); } Sample JAVA code to call above C++ class: public class Hello { static { System.loadLibrary("Hello"); } Hello() { cplusPtr = initCplusSide(); } public native String Name(int cplusPtr, String lastName); public native void Number(int cplusPtr, int i); private native int initCplusSide(); private int cplusPtr; // Stores C++ Hello object pointer public static void main (String [] args) { Hello hai = new Hello(); hai.Number(hai.cplusPtr, 10); hai.Name(hai.cplusPtr, "Gates"); } I am looking for a sample makefile to make shared library on HP Unix for the above C++ code and sample JNI code for the above Java code. Any help would be greatly appreciated. Thanks Balaji Raya ***************** End Of Article ****************** Balaji Raya posted Message 272 in Message Board Dated : February 26, 2001 at 15:51:47 EST Subject: Calling C++ from Java using JNI on HPUX involves String operations I am able to call C++ function from Java (JDK 1.3) using JNI. But I am unable to make a shared code, which involves String operations. I think the String operations (Standard) comes under lib++ library which is Archive on HPUX, but not as Shared. Sample C++ code: #include class Hello { int Number(int); String Name(String); }; int Hello::Number(int numb) { cout << "Received Number: " << numb << endl; return (numb++); } String Hello::Name(String lastName) { String fullName = "Yahoo……"; cout << "Received Name: " << lastName << endl; firstName += lastName; return (fullName); } Sample JAVA code to call above C++ class: public class Hello { static { System.loadLibrary("Hello"); } Hello() { cplusPtr = initCplusSide(); } public native String Name(int cplusPtr, String lastName); public native void Number(int cplusPtr, int i); private native int initCplusSide(); private int cplusPtr; // Stores C++ Hello object pointer public static void main (String [] args) { Hello hai = new Hello(); hai.Number(hai.cplusPtr, 10); hai.Name(hai.cplusPtr, "Gates"); } I am looking for a sample makefile to make shared library on HP Unix for the above C++ code and sample JNI code for the above Java code. Any help would be greatly appreciated. Thanks Balaji Raya ***************** End Of Article ****************** Dave posted Message 273 in Message Board Dated : February 28, 2001 at 12:31:42 EST Subject: Re: conversion to packed decimal format This has helped me out a great deal. I also have to convert some data over to the mainframe, and this will definitely ease our "pain" with the packed numbers. Thanks! : Dan, : This is a SQC with two procedures. One converts packed decimal to ASCII and the other goes the other way. : Take a look at them - the Packed Decimal to number formats are in here with a basic instruction on how to use them : !*********************************************************************** : ! * : ! $Header:: /PT75/SQR/CNVTPACD.SQC 11 : ! * : !*********************************************************************** : begin-procedure PAC_DEC_CNVT($NUMBER_IN, :#NUMBER_OUT) : ! converts numbers from Packed Decimal to ASCII numbers. : ! this procedure also assumes that the number in has had the decimal point removed : ! EX $number_in = '1234E' : ! #number_out = 12345 : ! EX $number_in = '1234N' : ! #number_out = -12345 : let $num = ltrim(rtrim($number_in, ' '), ' ') : let #len = length($num) : let #NUMBER_OUT = 0 : let #multiplier = 1 : if #len > 1 : let #first = #len - 1 : let $num1 = substr($num, 1 , #first ) : let $num2 = substr($num, #len, 1) : move $num1 to #num1 : let #NUMBER_OUT = #num1 * 10 : else : let #NUMBER_OUT = 0 : let $num2 = $num : end-if : if #len <> 0 : evaluate $num2 : when = '{' : let #multiplier = 1 : let #num2 = 0 : break : when = 'A' : let #multiplier = 1 : let #num2 = 1 : break : when = 'B' : let #multiplier = 1 : let #num2 = 2 : break : when = 'C' : let #multiplier = 1 : let #num2 = 3 : break : when = 'D' : let #multiplier = 1 : let #num2 = 4 : break : when = 'E' : let #multiplier = 1 : let #num2 = 5 : break : when = 'F' : let #multiplier = 1 : let #num2 = 6 : break : when = 'G' : let #multiplier = 1 : let #num2 = 7 : break : when = 'H' : let #multiplier = 1 : let #num2 = 8 : break : when = 'I' : let #multiplier = 1 : let #num2 = 9 : break : when = '}' : let #multiplier = -1 : let #num2 = 0 : break : when = 'J' : let #multiplier = -1 : let #num2 = 1 : break : when = 'K' : let #multiplier = -1 : let #num2 = 2 : break : when = 'L' : let #multiplier = -1 : let #num2 = 3 : break : when = 'M' : let #multiplier = -1 : let #num2 = 4 : break : when = 'N' : let #multiplier = -1 : let #num2 = 5 : break : when = 'O' : let #multiplier = -1 : let #num2 = 6 : break : when = 'P' : let #multiplier = -1 : let #num2 = 7 : break : when = 'Q' : let #multiplier = -1 : let #num2 = 8 : break : when = 'R' : let #multiplier = -1 : let #num2 = 9 : break : when-other : let #multiplier = 1 : let #num2 = 0 : break : END-EVALUATE : LET #NUMBER_OUT = (#NUMBER_OUT + #num2) * #multiplier : END-IF : : end-procedure : begin-procedure PAC_DEC_out(#num, #length, :$NUMBER_OUT) : ! converts numbers from ASCII to Packed Decimal numbers. : ! this procedure also removes the decimal point by multiplying by 100 : ! the #length then zero fills the number on the left to fit an output rec : ! : ! EX #num = '123.45' : ! #length = 8 : ! $number_out = '0001234E' : ! EX #num = -123.45 : ! #length = 8 : ! $number_out = '0001234N' : if #num >= 0 : let $neg = 'N' : let #num = #num * 100 ! remove the decimal : else : let $neg = 'Y' : let #num = #num * -100 ! remove the decimal : end-if : : let $num = edit(#num, '99999999999') : let $num = ltrim(rtrim($num, ' '), ' ') : let #len = length($num) : if #len > 1 : let #first = #len - 1 : let $num1 = substr($num, 1 , #first ) : let $num2 = substr($num, #len, 1) : else : let $num1 = '' : let $num2 = $num : end-if : let $NUMBER_OUT = '{' : if #len <> 0 : if $neg = 'N' !value is positive : evaluate $num2 : when = '0' : let $num2 = '{' : break : when = '1' : let $num2 = 'A' : break : when = '2' : let $num2 = 'B' : break : when = '3' : let $num2 = 'C' : break : when = '4' : let $num2 = 'D' : break : when = '5' : let $num2 = 'E' : break : when = '6' : let $num2 = 'F' : break : when = '7' : let $num2 = 'G' : break : when = '8' : let $num2 = 'H' : break : when = '9' : let $num2 = 'I' : break : when-other : let $num2 = '{' : break : end-evaluate : else ! value is negative : evaluate $num2 : when = '0' : let $num2 = '}' : break : when = '1' : let $num2 = 'J' : break : when = '2' : let $num2 = 'K' : break : when = '3' : let $num2 = 'L' : break : when = '4' : let $num2 = 'M' : break : when = '5' : let $num2 = 'N' : break : when = '6' : let $num2 = 'O' : break : when = '7' : let $num2 = 'P' : break : when = '8' : let $num2 = 'Q' : break : when = '9' : let $num2 = 'R' : break : when-other : let $num2 = '{' : break : END-EVALUATE : end-if : LET $NUMBER_OUT = $num1 || $num2 : LET $NUMBER_OUT = lpad($number_out, #length, '0' ) : END-IF : end-procedure ***************** End Of Article ****************** venkat posted Message 274 in Message Board Dated : March 05, 2001 at 11:26:30 EST Subject: Re: Runnning an Import from the command line I think you cannot use command line to run the import manger scripts : I have created an Import File Definition. : I need to invoke the Import Manager and run the import definition I have created, directly from the command line(without bringing up the Import Manager screen). : What command-line parameters do I need to use. : Thanks ***************** End Of Article ****************** hashim posted Message 275 in Message Board Dated : March 12, 2001 at 11:49:01 EST Subject: Re: P/S Payroll System Design : : : i am a student in FORTH YEAR,my computer project is payroll system design and i need some points to help me in the main structure of my project.I need a design that can help me to gather information. ***************** End Of Article ****************** Dan Byer posted Message 276 in Message Board Dated : March 14, 2001 at 10:47:20 EST Subject: Re: HRMS Demo Query Sudhir, 1) The IP address is whatever machine is running your message agents, in 7.5 they will probably be on the same machine as the server, make sure they are started. 2) The Message Definition is a 'map' which you create in pstools. It maps which Panels/underlying records to retrieve the data from. The message agent needs the name of it to know which panel route/fields to use. 3) I think the ODBC driver you refer to is used simply to extract the name of the message definitions if you are using a gui tool to wrap the calls. 4) The data is exctracted from the tables 'through' the panels, so the message agent needs a panel route defined to get to the data. 5) PS5/6/7 and below all support a Message Agent with a very slightly different API, so you could write a bridge that extracted from one and placed in another. Not sure if this is the most advised method. Dan Dan Byer Technical Architect @Business Europe Ltd www.atbusiness.co.uk : Hi All : The following Query is in regard to PS HRMS Demo Version 7.5 - Single User. Please help me. : 1.We are building Messaging Agents in Java to transport data from Peoplesoft (PS) database to some other ERP. PS has some pre-defined plug-ins given in the People Tools Integration part. Two of them are: : MsgConnect(Version, IP,...) : MsgStartMessage(MessageDefn, ActivityNAme,...) : Now the problem we are facing here is : 1. What IP should be given as we are using the HRMS Demo Version 7.5 as the base. The Demo is SIngle-User, so physically everything i.e. the Database Server, Application Server n the client are on the same machine. : 2. In the second Plug-in, what is the MessageDefn? Is it the name of the Java Adapters developed or someting else? : 2) What are the ODBC drivers that should be mentioned for this database connectivity? Is it same as the machine on which the Demo is installed, or any port number or something else? : 3)When we are extracting data from the PS database, is it to be extracted from the Panels or Background tables? : 4)How can data be extracted / fed from / to PS version 7 n below. Apparently there seems to no backward compatibility. : Please reply ASAP. : Thnx n Rgds : Sudhir Nilekar ***************** End Of Article ****************** jason puno posted Message 277 in Message Board Dated : March 19, 2001 at 15:09:18 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** jason puno posted Message 278 in Message Board Dated : March 19, 2001 at 15:21:42 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Jason Puno posted Message 279 in Message Board Dated : March 19, 2001 at 22:05:30 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** del posted Message 280 in Message Board Dated : March 21, 2001 at 10:35:29 EST Subject: Entity Relationship Diagrams help you peoplesoft experts, are there any entity relation diagrams for the project/grant modules in any of the peoplesoft peoplebooks? or for that matter anywhere to be found? we are trying to map our legacy data to these modules and we need any help that we can get. thanks in advance del ***************** End Of Article ****************** Melissa posted Message 281 in Message Board Dated : March 30, 2001 at 19:48:08 EST Subject: Re: anyone using ps8 app messaging/comp interfaces/bsns interlinks? I just finished a v8 application messaging integration project. The new technology definitely makes integration easier, but there is a decent amount of learning involved. Feel free to email me if you have any specific questions. ***************** End Of Article ****************** sadat posted Message 282 in Message Board Dated : March 31, 2001 at 04:50:34 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** yanee w. posted Message 283 in Message Board Dated : April 01, 2001 at 07:43:00 EST Subject: Re: P/S Payroll System Design : : i am a student in fouth year in university ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Anil Pandey posted Message 284 in Message Board Dated : April 02, 2001 at 14:00:14 EST Subject: For Peopsoft7.5 message agent - is java api available Need help.... Is java api available for peoplesoft 7.5. Is there a third party vendor who has developed these api's. Thanks in advance ...... ***************** End Of Article ****************** Sush posted Message 285 in Message Board Dated : April 12, 2001 at 10:22:39 EST Subject: Updating using JMAC *Urgent * I am currently using Peopletools v7.54 and Oracle 8i and JMAC to connect to the message agent for retrieval and updating data within the Database. I have successfully achieved the retrieval part, but miserably failed on the updating side. However, the trace seems to think that the Update has succeeded as is clearly states - Applying value = "xxxx" and "Update Ok", although the update is not reflected in the panel and the database. When creating the message definition, all keys have been mapped, and correction mode has been specified. There is no problem when I update using the Peoplesoft client, it only occurs when using the message agent via JMAC. Has anyone else experienced similar problem ? I would greaty appreciate any advice. Many thanks SD ***************** End Of Article ****************** Sivaram posted Message 286 in Message Board Dated : April 16, 2001 at 20:41:49 EST Subject: Interface to Other B2B Application. Hai All, I am trying to write some C API calls to connect to PS and trying to connect to some b2B applications. I would like to know the following, 1. Using PS 7.5 Is that the message agent is the best way to connect and retrieve data or is there are any other tools.If so please advice. 2. In 8 what is the best way to achieve the above. Reply to s_selladurai@hotmail.com Thanks. ***************** End Of Article ****************** Randi Pritchett-McIntosh posted Message 287 in Message Board Dated : April 17, 2001 at 22:49:47 EST Subject: Payroll Interface I am trying to get information on the payroll interface module for 7.51. Peoplesoft know longer offers that class. Does anyone have any reading materials that you can refer to me. Thanks, Randi ***************** End Of Article ****************** Mike Philby posted Message 288 in Message Board Dated : April 19, 2001 at 20:10:09 EST Subject: Re: Interface to Other B2B Application. : Hai All, I am trying to write some C API calls to connect to PS and trying to connect to some b2B applications. : I would like to know the following, : 1. Using PS 7.5 Is that the message agent is the best way to connect and retrieve data or is there are any other tools.If so please advice. : 2. In 8 what is the best way to achieve the above. : Reply to s_selladurai@hotmail.com : Thanks. I never really got the Message Agent API to work properly. It can handle simple selects and updates but not much else. If you're thinking of pushing large amounts of data through it, try an odbc connection instead. Now with V8 Component Interfaces, that's a different story. I wrote integration points between version 8 and a VB application with much success, some where fairly complex. While it's very hard to debug, when it works, it works well. Some of the record peoplecode doesn't work well with CI's, like panel transfers, and the new page peoplecode is not supported, but if you think about it, your interfacing with the whole panelgroup/component not just a page. Look for all record peoplecode to fire, set the fields in the order that they would be set by a user using the page, so that the prompts work properly. If you set them out of order, like State = 'AK' and Country = 'USA', you'll receive an error. Field Change events fire after a save or when the next scroll level is accessed assuming the interactive mode is turned off, otherwise it's realtime. You have to install the CI API interface. This is a COM object and can be instantiated within VB or C, etc. Let me know if I can help any other way. Thanks, MiKeP ***************** End Of Article ****************** Mike Philby posted Message 289 in Message Board Dated : April 19, 2001 at 20:24:07 EST Subject: Re: version 8, business components, message agent level > 2 : This is a somewhat broad (and probably asked) question, BUT, has anyone seen/used the 'business components' or other data access methods of version 8? we struggled with message agent limitations (level 2 + scrolls) and are curious if ps will really deliver complete ps data access WITH business edits. also has anyone used ActiveWorks Adapter for Peoplesoft? I never really got the Message Agent API to work properly. It can handle simple selects and updates but not much else. If you're thinking of pushing large amounts of data through it, try an odbc connection instead. Now with V8 Component Interfaces, that's a different story. I wrote integration points between version 8 and a VB application with much success, some where fairly complex. While it's very hard to debug, when it works, it works well. Some of the record peoplecode doesn't work well with CI's, like panel transfers, and the new page peoplecode is not supported, but if you think about it, your interfacing with the whole panelgroup/component not just a page. Look for all record peoplecode to fire, set the fields in the order that they would be set by a user using the page, so that the prompts work properly. If you set them out of order, like State = 'AK' and Country = 'USA', you'll receive an error. Field Change events fire after a save or when the next scroll level is accessed assuming the interactive mode is turned off, otherwise it's realtime. You have to install the CI API interface. This is a COM object and can be instantiated within VB or C, etc. The Application Messaging also works well, better brush up on your XML and it's not realtime like CI's. It is a great way to push data through near realtime, and PeopleSoft uses quite a bit to integrate their many modules. Let me know if I can help any other way. Thanks, MiKeP ***************** End Of Article ****************** sarjan posted Message 290 in Message Board Dated : April 25, 2001 at 15:28:08 EST Subject: Peopletools-urgent Anybody got a pirated version of Peoplesoft 7.54 or atleast the licence key for my testing. ***************** End Of Article ****************** EDM posted Message 291 in Message Board Dated : April 25, 2001 at 15:58:59 EST Subject: Re: Peopletools-urgent Your intention is illegal. Peoplesoft software is a licensed product. : Anybody got a pirated version of Peoplesoft 7.54 or atleast the licence key for my testing. ***************** End Of Article ****************** Thio Cher Kuan posted Message 292 in Message Board Dated : April 25, 2001 at 23:53:29 EST Subject: Starting Message Agent using Perl? Hi, I would like to know if perl could be used to start Message Agent. Thanks! regards Cher Kuan ***************** End Of Article ****************** Sivaram posted Message 293 in Message Board Dated : April 26, 2001 at 11:12:24 EST Subject: Re: Starting Message Agent using Perl? hi, I don't see any documentation which says we can use PERL to write MA programs.Is there anything in particular features you want make use of in PERL in this. VB ,C/C++ and Java are widely used.If you can use one of these you can get a good support.If you need some samples let me know I can give it to you. Rgds : Hi, : I would like to know if perl could be used to start Message Agent. : Thanks! : regards : Cher Kuan ***************** End Of Article ****************** Cher Kuan posted Message 294 in Message Board Dated : April 26, 2001 at 21:53:45 EST Subject: Re: Starting Message Agent using Perl? Hi, Thanks for your advise!! Anyway, I am writing some CGI scripts using PERL, so I only wished to be consistent in my usage. There is actually no particular features in PERL that I must use. regards Cher Kuan : hi, I don't see any documentation which says we can use PERL to write MA programs.Is there anything in particular features you want make use of in PERL in this. : VB ,C/C++ and Java are widely used.If you can use one of these you can get a good support.If you need some samples let me know I can give it to you. : Rgds : : Hi, : : I would like to know if perl could be used to start Message Agent. : : Thanks! : : regards : : Cher Kuan ***************** End Of Article ****************** Bollingh Mark posted Message 295 in Message Board Dated : April 27, 2001 at 01:45:15 EST Subject: Flat file creation for Import manager Hi, I have to create a flat file to load the old information that comes from different sources, into the different tables of peoplesoft. Does somebody know how I can create those flat files easly? I did try to create a flat file for the table PS_PERSONAL_DATA, but I have problems when I try to load the information. The tool that I did use to creat the flat file was Excel, and did save the file as Formated text (prn). Greetings Mark Bollingh ***************** End Of Article ****************** Sivaram posted Message 296 in Message Board Dated : April 27, 2001 at 19:19:20 EST Subject: 2 phase commit Hai I am currently looking at possibilities of 2 phase commit in Peoplesoft. The scenario is that you have 2 peoplesoft system running at two different servers and there is this external application calls a transaction which need to be commited on both the Peoplesoft system . The external application resource manager first announces that it is going to commit and ask whether all the other services are ready to commit.If everybody is ready it commits the transaction. Is this kind of a transaction commit is supported in Peoplesoft . I doubt in 7.5 and how about in PS 8. Thanks in Advance. Rgds ***************** End Of Article ****************** srinivasan posted Message 297 in Message Board Dated : May 07, 2001 at 05:02:04 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Shahab posted Message 298 in Message Board Dated : May 07, 2001 at 12:40:14 EST Subject: Re: anyone using ps8 app messaging/comp interfaces/bsns interlinks? Yeah I just completed a demo project for PS8 using Component Interfaces and Business Interlinks. I have also worked on a PS75 project to build an PS adapter via Message Agents. I would say new PS8 technologies, though more complicated, are definetely much more structured, organized and provide a better way to integrate than its predecessor. Feel free to contact if any help is needed. ***************** End Of Article ****************** Shahab posted Message 299 in Message Board Dated : May 07, 2001 at 12:53:57 EST Subject: Re: Interface to PS 7.5 from Web : Any ideas on methods for a bi-directional interface to PS 7.5 from a 3rd party HR vendor specializing in XML. I would appreciate ideas for real-time and batched. Thank you in advance I have just completed a integration project between a third party HRMS and PS75. The data was contructed in XML packets/documents. For both, batch as well as interactive integrations, I used Message Agent APIs to talk to PS. let me know if you need additional help. ***************** End Of Article ****************** Thio Cher Kuan posted Message 300 in Message Board Dated : May 08, 2001 at 07:11:13 EST Subject: Starting COBOL process using C? Dear all, Is it possible to start a COBOL process in PS using C? Thabks for any help rendered! regards Cher Kuan ***************** End Of Article ****************** richard torres posted Message 301 in Message Board Dated : May 11, 2001 at 09:43:05 EST Subject: Re: Inventory Transactions Interface : : Hi Hector. : : There is a bunch of transactions PeopleSoft Inventory can do ! : : I am not too sure what you actually have to do (putaway, adjustments, MSR, bin-to-bin, ...) but by having faced the problem a couple of times, what I can tell you is not to simulate anything else than a receiving (putaway) using a SQR. : : Basically, when you don't have staging tables to populate (ex : staged_inf_inv, demand_inf_inv, ...), don't even try to do it, or you'll end up with all the possible discrepancies in your stock. : : The business rules enforced via the manifold transaction panels are very complicated, and can change based on the setup. : : And it is a lost of time to even think about figuring them out in a comprehensive way. : : Instead, try to use a message agent / database agent. : : Just in case you don't know what that is, it is standard tool that simulates an entry into a panel (like a user would do it). : : The pros is that all peoplecode business rules are enforced via the panel, even those you are not aware of. : : The cons is that it's not easy to write, and very slow in terms of processing (for instance, an adjustment or bin-to-bin transfer can take up to 5 seconds to execute. If you have large amounts of data to process on a daily basis, it is probably not a good idea to use this workflow tool...!) : : Hope this helps. : : Chris. : : : Hello All, : : : I need to interface all inventory transactions from an external system into PeopleSoft. For most transactions, i am pretty sure i am writing the data from flat files into the right set of tables. I am using SQR to do this, i can even visualize the info i am importing into PeopleSoft. But..... when you enter transactions online into Inventory, and save the panel, a bunch of PeopleCodes are executed, these do things like summarize the transaction info for the record PS_TRANSACTION_INV and update my item availble quantities. This i can NOT for my life do with SQR... so, i am importing the data fine, but my inventory status is not being updated!!!!! Anyone knows what i am doing wrong here? or how i could ago about importing all these transactions and getting all those PeopleCodes to run so my inventory gets updated... or anyone has any idea at all that could help me import these transactions correctly???? : : : Thank you all in advance. : : : Hector Hernandez. : : : ps: i would appreciate sending me answers via email as well? : I'm been running into the same problem. Wish to interface with VB for putaway, but having a horrible time with message agent to work with the 2nd Level data entry panels of express putaway. PS did NOT ship the message agent examples described in the book with the installation. Without the message agent defination examples I'm at a lost as to get them to work. Any help would be much appreciated. ***************** End Of Article ****************** rich torres posted Message 302 in Message Board Dated : May 11, 2001 at 09:43:34 EST Subject: Re: Inventory Transactions Interface : : Hi Hector. : : There is a bunch of transactions PeopleSoft Inventory can do ! : : I am not too sure what you actually have to do (putaway, adjustments, MSR, bin-to-bin, ...) but by having faced the problem a couple of times, what I can tell you is not to simulate anything else than a receiving (putaway) using a SQR. : : Basically, when you don't have staging tables to populate (ex : staged_inf_inv, demand_inf_inv, ...), don't even try to do it, or you'll end up with all the possible discrepancies in your stock. : : The business rules enforced via the manifold transaction panels are very complicated, and can change based on the setup. : : And it is a lost of time to even think about figuring them out in a comprehensive way. : : Instead, try to use a message agent / database agent. : : Just in case you don't know what that is, it is standard tool that simulates an entry into a panel (like a user would do it). : : The pros is that all peoplecode business rules are enforced via the panel, even those you are not aware of. : : The cons is that it's not easy to write, and very slow in terms of processing (for instance, an adjustment or bin-to-bin transfer can take up to 5 seconds to execute. If you have large amounts of data to process on a daily basis, it is probably not a good idea to use this workflow tool...!) : : Hope this helps. : : Chris. : : : Hello All, : : : I need to interface all inventory transactions from an external system into PeopleSoft. For most transactions, i am pretty sure i am writing the data from flat files into the right set of tables. I am using SQR to do this, i can even visualize the info i am importing into PeopleSoft. But..... when you enter transactions online into Inventory, and save the panel, a bunch of PeopleCodes are executed, these do things like summarize the transaction info for the record PS_TRANSACTION_INV and update my item availble quantities. This i can NOT for my life do with SQR... so, i am importing the data fine, but my inventory status is not being updated!!!!! Anyone knows what i am doing wrong here? or how i could ago about importing all these transactions and getting all those PeopleCodes to run so my inventory gets updated... or anyone has any idea at all that could help me import these transactions correctly???? : : : Thank you all in advance. : : : Hector Hernandez. : : : ps: i would appreciate sending me answers via email as well? : I'm been running into the same problem. Wish to interface with VB for putaway, but having a horrible time with message agent to work with the 2nd Level data entry panels of express putaway. PS did NOT ship the message agent examples described in the book with the installation. Without the message agent defination examples I'm at a lost as to get them to work. Any help would be much appreciated. ***************** End Of Article ****************** Vikram Patil posted Message 303 in Message Board Dated : May 11, 2001 at 20:40:23 EST Subject: Message Agent not present Hi, I am trying to connect to the Peoplesoft Application Server from a Java program. I have developed a C wrapper that would inturn make the MSG Agent API calls. Its failing at the PSMsgConnect function. The return code is 2 i.e described as "Message Agent not present" in the PSMSG.H file. Could anybody help ome on this. thanks, Vikram. ***************** End Of Article ****************** Donna Lee posted Message 304 in Message Board Dated : May 14, 2001 at 13:27:29 EST Subject: Import data into Peoplesoft with App Eng & Component Interf Hi, I have a file from a legacy system. This file has salary increases that need to be loaded into the Employees job data. We were going to write an SQR to insert these rows into the job table, but needed to duplicate all the Peoplecode and edits etc. I wanted to use APP engine as this is a weekly batch process, but then I want to reuse the Component Interface so that I can make use of the existing edits on the Job page. In my investigation, I can have the file loaded into temp tables in App Engine, but I don't know how or if I can then call a component interface to load these rows into the job component. Any ideas or help would be really appreciated. Donna. ***************** End Of Article ****************** petersmith posted Message 305 in Message Board Dated : May 15, 2001 at 16:12:08 EST Subject: Interfacing to Quotation package. Good day, Can anyone advise me if they have had any experience interfacing to a third party Quotations solution? Delivered PeopleSoft Maintain Quotations functionality does not meet client requirements. In actuality, if we could import from the existing Access database they use in PeopleSoft quotations we can meet most of their requirements. Anyone had any experience doing this? Thanks for your time in reading the posting. Hope to get lucky and get a response posting! Thanks! ***************** End Of Article ****************** Mike Philby posted Message 306 in Message Board Dated : May 15, 2001 at 19:54:05 EST Subject: Re: Import data into Peoplesoft with App Eng & Component Interf Yes, you should be able to add rows using CI's with App Engine, as far as how I never actualy used CI's and App Engine together. There are some good PC examples using App Messaging and CI's. If you have Financials you should be able to find an app message called CASH_ADVANCE and/or TIME_REPORT. Open the message and click on CASH_ADVANCE_SUBMIT / TIME_REPORT submit peoplecode. This should give you an idea on how to access a CI and it's objects using PeopleCode. Thanks, MiKeP : Hi, : I have a file from a legacy system. This file has salary increases that need to be loaded into the Employees job data. We were going to write an SQR to insert these rows into the job table, but needed to duplicate all the Peoplecode and edits etc. I wanted to use APP engine as this is a weekly batch process, but then I want to reuse the Component Interface so that I can make use of the existing edits on the Job page. : In my investigation, I can have the file loaded into temp tables in App Engine, but I don't know how or if I can then call a component interface to load these rows into the job component. : Any ideas or help would be really appreciated. : Donna. ***************** End Of Article ****************** Nonie Cronin posted Message 307 in Message Board Dated : May 16, 2001 at 07:46:37 EST Subject: Autosys adapter for PeopleSoft Hi, I'm having problems configuring the AutoSys adapter for peoplesoft. Does anyone have any experience with it ????? Thank Nonie ***************** End Of Article ****************** Steve posted Message 308 in Message Board Dated : May 16, 2001 at 09:09:56 EST Subject: Application Messages and XML Hi - we are converting flat files from legacy systems into XML documents in order to use the publish/subscribe technology supplied by PS App Messages to get the data into the database. The PeopleBooks say that we need software capable of doing an "HTTP Post" when integrating 3rd party data. We are new to this arena, and are not quite sue what this means. Is it as simple as FTPing our XML document to the proper directory (assuming we have defined the messages, set up the gateway server, etc)? Any clues would be appreciated! ***************** End Of Article ****************** Mike Philby posted Message 309 in Message Board Dated : May 16, 2001 at 13:45:31 EST Subject: Re: Application Messages and XML From: syoung2@imf.org To: mphilby@yahoo.com Subject: RE: PeopleSoft 8 App Messages Date: Wed, 16 May 2001 12:19:02 -0400 Thanks, Mike... this was very helpful. -----Original Message----- From: m p [mailto:mphilby@yahoo.com] Sent: Wednesday, May 16, 2001 11:29 AM To: Young, Steven Subject: RE: PeopleSoft 8 App Messages Steve - Something needs to post the message to the URL, whether it is a program you write (which you'll need if you are posting in batch) or by posting an XML file from an HTML web page. I've never used the psxmlpost.exe program you are refering too, but I imagine that it is simply a program that was written to post a XML file to an HTTP gateway. When I say "post" I am refering to the method of sending information to a web server via the HTTP protocol. This is not a PeopleDoft way of sending data to a web server, the HTTP Post method is a standard means of sending data from a client (web browser) to a web server and is used all the time. It is similar to using the FTP protocol and invoking the "put" method. HTTP is a protocol and Post is a method of that protocol, FTP is a protocol and Put is a method of that protocol, but they are distinctly different protocols and behave differently. HTTP Post allows you to submit data to a gateway server via using a web HTTP:// url. To FTP, you need to have an FTP Server/gateway on the receiving side, and you put data to a FTP:// url. An example of this is when you fill out a form on a web page and click a button, this submits the info on the form to a web server. When you do this you are actually posting a message to the web server. The web server processes the message and sends a response back to you in the form of HTML. The best way to understand this is to write a simple VB program that will post an XML string to the application messaging gateway URL. By doing this, which is what I had to do before I understood it, you will see what happens when and how. In VB, first you build a XML message, stuff it into a string, use the HTTP protocol found in the INET control, and invoke the Post Method, to the URL of the App Messaging Gateway, you then wait for a response from the gateway, when you receive the response, you process it to make sure your message was excepted. Hope this was of help. Thanks, MiKeP --- "Young, Steven" wrote: > Mike, > > Thank you very much for taking the time to send this > information.... it was > very helpful. I would appreciate it if you would > send me the samples this > weekend that you referred to. > > We have defined all the messages, channels, nodes, > etc., as well as > configured the message gateway servlet. My > confusion stems from the meaning > of the term "post", and what that actually entails. > All the info I have > received seems to assume the posting of a message > from an online program or > web page. But we will be doing this in batch.... > i.e. converting files to > XML message docs, and then triggering the PS > Subscribe process for the docs. > Some info suggests that we simply FTP an XML > document to the URL/Port# > associated with the Java servlet (message gateway > servlet). If that is the > case, then what purpose does psxmlpost.exe serve > (the program was referred > to in the Integration tools training guide as a way > of submitting an XML doc > as a message to PS)? That seems to imply that there > is more to triggering > the subscription process than just putting the XML > doc in the right > location. Can you "dumb down" your explanation for > me a bit??? We are new > to this - Thanks Again > > -Steve > > -----Original Message----- > From: m p [mailto:mphilby@yahoo.com] > Sent: Wednesday, May 16, 2001 10:10 AM > To: Young, Steven > Subject: Re: PeopleSoft 8 App Messages > > > Hi Steve: > > HTTP Post is simply the HTTP protocol that is used > to > post an XML document, it is not a FTP. In other > words, an HTML web page could be used to submit a > XML > file to a HTTP web server. I might have a HTTP Post > program that I could send to you when I get home > this > weekend (I don't have it with me). It may be posted > on the PeopleSoft Alliance Connection somewhere, but > I > don't know for sure. > > I don't know if you know MS VB, but the INET control > that comes with VB has a HTTP protocol tool that can > be used to post or submit the file. On a web page, > when you see a gray button on a page, (like the > search > button on Yahoo) when clicked, it is posting info > that > you supplied on the web page to the server. > > I have heavy experience with XML, HTTP, HTML, VB, > App > Messaging, Component Interfaces and subscription > PeopleCode as well as PIA 8. Are there any > opportunities that you know of where you are? I'd > love to work with this technology again. > > Thanks, > > MiKeP > > --- "Young, Steven" wrote: > > Mike, > > > > I saw your response on the PeopleSoft forum, and > > hoped you would be able to > > provide some insight on XML. We are using some > > middleware (Mercator) to > > convert flat files to XML documents, and want to > > post those to PS (using > > HTTP Post) and use the PS subscription process to > > load the data. I am new > > to the XML/messaging arena, and am a bit confused > on > > just what an "HTTP > > Post" entails mechanically. Is this simply a > matter > > of FTPing the XML > > document to the appropriate directory (assuming we > > have setup the messages, > > gateway server, etc. correctly)? Other than > saying > > that we need software > > capable of performing an HTTP Post, the > PeopleBooks > > do not say much about > > what this actually involves for 3rd party > > integration. > > > > Any clues would be much appreciated. > > > > Steve Young > > IMF, Washington, D.C. : Hi - we are converting flat files from legacy systems into XML documents in order to use the publish/subscribe technology supplied by PS App Messages to get the data into the database. The PeopleBooks say that we need software capable of doing an "HTTP Post" when integrating 3rd party data. We are new to this arena, and are not quite sue what this means. Is it as simple as FTPing our XML document to the proper directory (assuming we have defined the messages, set up the gateway server, etc)? Any clues would be appreciated! ***************** End Of Article ****************** Mohan posted Message 310 in Message Board Dated : May 17, 2001 at 11:08:40 EST Subject: PS Adapter & Metadata Architecture We are trying to Integrate with a Peoplesoft Applications through a middleware tool developed by our client. Part of this is we have to build a DTD from the Peoplesoft objects. I have gone through the documents in the web site saying the below In Peopletools 8 Metadata architecture * Application objects reside in a centralized data repository. What we are thinking is to build a mechanism to access this centralized data respository to build our DTD which is going to be a input to our tool, will be later used to get the data TO/FROM Peoplesoft application using one of the Peoplesoft Integration Method, probably Application Messaging or Component Interface. Can anyone help me providing more information about Metadata architecture (centralized data repository). Send me the documents explains more about it. The structure of it and how it is stored? How we can access?.. etc. Thanks ***************** End Of Article ****************** Ratan posted Message 311 in Message Board Dated : May 18, 2001 at 16:31:15 EST Subject: Business Interlinks Configuration Hello, I have developed a Business Interlink Design-Time(XML) and Run-time plug-in(in Java), under Windows NT operating system. But having problems in configuring them to use in Application Designer. Did anyone try to do this before? Any help will be appreciated. Thanks, Ratan ***************** End Of Article ****************** Ratan posted Message 312 in Message Board Dated : May 18, 2001 at 16:31:21 EST Subject: Business Interlinks Configuration Hello, I have developed a Business Interlink Design-Time(XML) and Run-time plug-in(in Java), under Windows NT operating system. But having problems in configuring them to use in Application Designer. Did anyone try to do this before? Any help will be appreciated. Thanks, Ratan ***************** End Of Article ****************** Patrick Markert posted Message 313 in Message Board Dated : May 23, 2001 at 13:49:36 EST Subject: Want to purchase PeopleSoft Client Contact List Our company provides consulting and staffing services to companies using PeopleSoft. If you have a list of contacts who buy these types of services in the Peoplesoft arena, I would be very interested in purchasing this information. Please contact me at 404-233-1717 x100 ***************** End Of Article ****************** amitesh sinha posted Message 314 in Message Board Dated : May 24, 2001 at 04:32:33 EST Subject: Re: P/S Payroll System Design I am system analyst and is responsible for designing payroll system for a university. Help me in all possible ways. ***************** End Of Article ****************** Bruce Tobin posted Message 315 in Message Board Dated : May 25, 2001 at 09:17:23 EST Subject: Java access to component interface. We have successfully called a component we built via the component interface from VB, but when we attempt to duplicate our client code in Java we get the following exception on the component save() method: bea.jolt.ApplicationException: TPESVCFAIL - application level service failure at bea.jolt.JoltRemoteService.decodeCALL(JoltRemoteService.java:405) at bea.jolt.JoltRemoteService.call(JoltRemoteService.java:323) at psft.pt8.net.NetReqRepSvc.sendRequest(NetReqRepSvc.java:376) at psft.pt8.net.NetService.requestService(NetService.java:144) at psft.pt8.joa.JOAService.joaRequestService(JOAService.java:49) at psft.pt8.joa.CISvc.save(CISvc.java:47) at psft.pt8.joa.CI.invokeMethod(CI.java:240) at PeopleSoft.Generated.CompIntfc.ZValidation10.save(ZValidation10.java: 240) The save is supposed to fail (our component is doing validation and we need to pass validation error messages back to the calling program), but it seems to be failing too early for the required messages to be passed back. In our VB code the PSMessages collection of the Session object contains the error messages after the save fails, but in our Java code this collection is empty. Is there a fundamental difference in the way the Java libraries and the VB libraries handle application errors? ***************** End Of Article ****************** Sweat Shop Patrol posted Message 316 in Message Board Dated : May 31, 2001 at 19:07:53 EST Subject: How many H1B's does it take to Screw in a Light Bulb? How many H1B's does it take to Screw in a light Bulb? Answer: 20 Read On... One to offer themselves at illegal below market rates. One to perform industrial espionage on light bulb design and fabrication. One to compose misleading project plans and resource allocations. One to provide fabricated false job history and experience for H1B IT workers. One to provide false certifications or other bull-sh*t re: H1B IT workers. One to SPAM the whole web marketing their offshore associates, bottom feeding and busting the IT marketplace. One to be online all the time sending corporate proprietary information back to the offshore 'Mother Company' One to provide pirated copies of software tools and products. One to look out for alert US Domestic IT employees or the boss! One to provide advise on cheating US Taxes One to hold the confiscated passports of H1B Slaves. One to 'front' for the group by submitting resumes of US domestic IT workers who will never really be assigned to the project. One to coach H1B's about how to lie and bullsh*t effectively with employers, the INS, merchants, and US Citizens. One to round up the neighbors unfortunate dogs and cats for the day's curry pot. One to write a project plan for ladder climbing and light bulb engagement. One to climb the labber and engage the light bulb. Four to turn the ladder. This wee bit of humor brought to you by the Sweat Shop Patrol to provide a little respite from the savage IT marketplace brought about by H1B fraud, spying, and other illegal activity. Please do your part by contacting your elected senators, the INS, and the IRS regarding the H1B raid on American IT jobs and US Corporate Information. The career you save may very well be your own. Fight the New World Order and the war on US IT workers! Very Truely Yours, Sweat Shop Patrol ***************** End Of Article ****************** hawkeye posted Message 317 in Message Board Dated : June 01, 2001 at 09:24:06 EST Subject: Re: How many H1B's does it take to Screw in a Light Bulb? You lost your job. Well, all that anyone can say is "you werent good enough". better luck next time. contact an H1B, he might be gracious enough to teach you a thing or two .. that'll help you a lot good luck ***************** End Of Article ****************** Mary posted Message 318 in Message Board Dated : June 04, 2001 at 11:40:51 EST Subject: Micr Encoding - Paychecks We are currently printing paychecks on pre-printed forms from MVS,using a modified SQR PAY003. We are looking at printing paychecks using MICR Encoding. There is an existing printer in-house currently printing SAP AP checks utilizing SAPScript to pass control character info. Does anyone know if it is possible to modify PAY003 to interface directly with this printer via MVS? Or will we need to create something similar to the SAPScript? Are there any other methods? Also,is there functionality in PS 8.0 that will interface with MICR Encoded print technology? ***************** End Of Article ****************** Mark Bollingh posted Message 319 in Message Board Dated : June 05, 2001 at 07:42:21 EST Subject: invoke method I'm using the API's of PeopleSoft, and they are working quid nice, except one, where I do receive the message "Unexpected exception during InvokeMethod (-1,-1)". This message pop's up after the inserting 3 records. I'm using VBA inside Excel, and did recompile already more than one the API Did somebody did had that error before, and is there an answer to that problem. ***************** End Of Article ****************** rdegster posted Message 320 in Message Board Dated : June 06, 2001 at 09:05:32 EST Subject: Re: Micr Encoding - Paychecks We have PS 7.5 and are printing checks via a delivered SQR that encodes micr characters. The requirements are the SQR must run locally and the printer needs a special card. Please e-mail me for further information. The program handles logos as well. Prior to that we were using a modified version of PAY003 with Westcorp Software to print the checks. ***************** End Of Article ****************** Eric posted Message 321 in Message Board Dated : June 06, 2001 at 11:31:40 EST Subject: Message Agent: retrieving list of message names Hi, Does anybody know what's the best way to retrieve the list of messages that exist for the Message Agent ? I know how to retrieve the attributes/fields etc once I know the Message name using the PSMSG... functions. ***************** End Of Article ****************** Uma posted Message 322 in Message Board Dated : June 07, 2001 at 12:44:54 EST Subject: MessageAPI 811 Have anyone worked on version 811 of PeopleSoft Message API ? ***************** End Of Article ****************** PSfan posted Message 323 in Message Board Dated : June 11, 2001 at 10:11:35 EST Subject: Working with Component Interface Hi All, I am trying to work with Component Interfaces (CI). I need to know if CI's are Service based or Schema based? Is CI an object which we can access and manipulate or is it more like a function call that perfor,s some sort or service? I would really appreciate if anyone could refer a website for Component Interfaces. Thanks, PSfan ***************** End Of Article ****************** M. Philby posted Message 324 in Message Board Dated : June 13, 2001 at 10:25:07 EST Subject: Re: Working with Component Interface CI is an object both inside an outside of PeopleSoft. It is more of a service based object. Think of CI's as the message agent on steroids. A CI is an interface to a Component (PanelGroup), most of the PeopleCode behinde the Component, Page and Record will fire while manipulating data. All three scroll levels are suppported and work. You can use them to pull or push data to/from PeopleSoft realtime. If you do find a site dedicated to CI's I'd be interested in knowing about it. I have over 16 months experience developing CI's and integrating them with third party applications through the CI API. Also, if you know of any current openings for a PeopleSoft application developer with extensive version 8.1x experience please let me know. Thanks, M. Philby : Hi All, : I am trying to work with Component Interfaces (CI). I need to know if CI's are Service based or Schema based? Is CI an object which we can access and manipulate or is it more like a function call that perfor,s some sort or service? : I would really appreciate if anyone could refer a website for Component Interfaces. : Thanks, : PSfan ***************** End Of Article ****************** M. Philby posted Message 325 in Message Board Dated : June 13, 2001 at 10:29:10 EST Subject: Re: invoke method You may not be using the .item and .insertitem method correctly. Make sure when inserting items to use the insertitem method after the first row. You must use the .itme method for the first row, since the first row is a given. If you have PS Financials, open the TIME_REPORT_SUBMIT applicaiton message. I wrote the message peoplecode and it uses a CI to save a message for the time capturing component of the T&E module. It is a good example of how to save multiple rows and multiple scrolls of data. Thanks, M.Philby : I'm using the API's of PeopleSoft, and they are working quid nice, except one, where I do receive the message "Unexpected exception during InvokeMethod (-1,-1)". This message pop's up after the inserting 3 records. : I'm using VBA inside Excel, and did recompile already more than one the API : Did somebody did had that error before, and is there an answer to that problem. ***************** End Of Article ****************** M. Philby posted Message 326 in Message Board Dated : June 13, 2001 at 10:32:12 EST Subject: Re: MessageAPI 811 Are you are refering to the Component Interface API for version 8.1x or the Applicaiton Messaging system for 8.1x? I have experience using both tools. Several postings on this site may answer some of your questions. If not, feel free to contact me. : Have anyone worked on version 811 of PeopleSoft Message API ? ***************** End Of Article ****************** kris posted Message 327 in Message Board Dated : June 13, 2001 at 13:38:09 EST Subject: Best Computer Training Center In NJ In article <3a6e53a8.0@news1.mweb.co.za>, I am writing to you about the best computer training center in New Jersey. I am attaching some information that I found from one of the best IT consulting companies out there. They did a good job for my friends In article <3a6e53a8.0@news1.mweb.co.za>, "Jan & Theo" wrote: > You asked me about hot IT fields > In article <92qg6d$83n$1@nnrp1.deja.com>, >>In your artcile you had asked me which was the best job for Indians and Asians in the information >>technology field> >>>We strongly believe that the best job for Computer consultants is in the functional areas of Siebel. If >>>you missed the boat in SAP...this is the next boat that takes you to the isle of wealth. >>>Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation >>>Programs anywhere. >>>To contact them, call them at 973-463-1260 >>>Crestech University >>>Enterprise Technology Education for the Global Village >>>188 Route 10 West,Suite 202, East Hanover, NJ 07936 >>>Phone : 973-463-1260, Fax : 973-463-1265 >>>www.crestech.org, Email : info@infotechri.com, >>>IBM, Cisco & Siebel Partners. We very strongly see and believe as per the market demand ,the best job for computer consultants is in the functional areas of Siebel .If you have missed the SAP program ,this is the next boat that takes you to the isle of wealth . Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere. To contact them, call them at 973-463-1260 Crestech.org Enterprise Technology Education for the Global Village 188 Route 10 West,Suite 202, East Hanover, NJ 07936 Phone : 973-463-1260, Fax : 973-463-1265 www.crestech.org, Email : info@infotechri.com, IBM, Cisco & Siebel Partners. Presently , as per the market requirements and demand the best job for computer consultants is in the functional areas of Siebel in IT field.If you are really looking for the wealthiest future do not miss this boat. Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere. To contact them, call them at 973-463-1260 CRESTECH.ORG. Enterprise Technology Solutions for the Global Village 188 Route 10 West,Suite 202, East Hanover, NJ 07936 Phone : 973-463-1260, Fax : 973-463-1265 www.infotechRI.com, Email : info@infotechri.com, IBM, Cisco & Siebel Partners. In IT field we believe that the best job for the computer consultants is in the functional areas of Siebel . If you have missed the SAP flight ,this is the next flight which takes you to the right destination. Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere. To contact them, call them at 973-463-1260 CRESTECH.ORG. Enterprise Technology Solutions for the Global Village 188 Route 10 West,Suite 202, East Hanover, NJ 07936 Phone : 973-463-1260, Fax : 973-463-1265 www.infotechRI.com, Email : info@infotechri.com, IBM, Cisco & Siebel Partners. ***************** End Of Article ****************** kris posted Message 328 in Message Board Dated : June 13, 2001 at 13:38:14 EST Subject: Best Computer Training Center In NJ In article <3a6e53a8.0@news1.mweb.co.za>, I am writing to you about the best computer training center in New Jersey. I am attaching some information that I found from one of the best IT consulting companies out there. They did a good job for my friends In article <3a6e53a8.0@news1.mweb.co.za>, "Jan & Theo" wrote: > You asked me about hot IT fields > In article <92qg6d$83n$1@nnrp1.deja.com>, >>In your artcile you had asked me which was the best job for Indians and Asians in the information >>technology field> >>>We strongly believe that the best job for Computer consultants is in the functional areas of Siebel. If >>>you missed the boat in SAP...this is the next boat that takes you to the isle of wealth. >>>Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation >>>Programs anywhere. >>>To contact them, call them at 973-463-1260 >>>Crestech University >>>Enterprise Technology Education for the Global Village >>>188 Route 10 West,Suite 202, East Hanover, NJ 07936 >>>Phone : 973-463-1260, Fax : 973-463-1265 >>>www.crestech.org, Email : info@infotechri.com, >>>IBM, Cisco & Siebel Partners. We very strongly see and believe as per the market demand ,the best job for computer consultants is in the functional areas of Siebel .If you have missed the SAP program ,this is the next boat that takes you to the isle of wealth . Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere. To contact them, call them at 973-463-1260 Crestech.org Enterprise Technology Education for the Global Village 188 Route 10 West,Suite 202, East Hanover, NJ 07936 Phone : 973-463-1260, Fax : 973-463-1265 www.crestech.org, Email : info@infotechri.com, IBM, Cisco & Siebel Partners. Presently , as per the market requirements and demand the best job for computer consultants is in the functional areas of Siebel in IT field.If you are really looking for the wealthiest future do not miss this boat. Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere. To contact them, call them at 973-463-1260 CRESTECH.ORG. Enterprise Technology Solutions for the Global Village 188 Route 10 West,Suite 202, East Hanover, NJ 07936 Phone : 973-463-1260, Fax : 973-463-1265 www.infotechRI.com, Email : info@infotechri.com, IBM, Cisco & Siebel Partners. In IT field we believe that the best job for the computer consultants is in the functional areas of Siebel . If you have missed the SAP flight ,this is the next flight which takes you to the right destination. Infotech Research International, Inc. in New Jersey offer one of the best Siebel Consultant Generation Programs anywhere. To contact them, call them at 973-463-1260 CRESTECH.ORG. Enterprise Technology Solutions for the Global Village 188 Route 10 West,Suite 202, East Hanover, NJ 07936 Phone : 973-463-1260, Fax : 973-463-1265 www.infotechRI.com, Email : info@infotechri.com, IBM, Cisco & Siebel Partners. ***************** End Of Article ****************** Patrick Markert posted Message 329 in Message Board Dated : June 14, 2001 at 10:43:50 EST Subject: Want to purchase Vantive Client Contact List Our company provides consulting and staffing services to companies using Vantive. If you have a list of contacts who buy these types of services in the Vantive arena, I would be very interested in purchasing this information. Please contact me at 404-233-1717 x100 ***************** End Of Article ****************** Tjeng-Bo Lie posted Message 330 in Message Board Dated : June 14, 2001 at 13:20:38 EST Subject: Component Interface FindKeys Maximum Rowset I need to use Component Interface in PS 8.13 to get all rows returned in a collection, and I got this message back: More instances of FOO were found than can be returned. (91,66) The number of returned instances exceeded the maximum. Increase the precision of the find key values to narrow the search. The maximum mentioned seem to be set at 300. Is there a way to increase this maximum? If not, is there a way to get the next 300 rows, etc. until all is returned? TIA, =-Tjeng-Bo-> ***************** End Of Article ****************** ahmad posted Message 331 in Message Board Dated : June 15, 2001 at 20:06:30 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Mohan posted Message 332 in Message Board Dated : June 20, 2001 at 15:19:56 EST Subject: Component Interface & Application Messaging We are trying to Integrate with a Peoplesoft Application (PS 8) through a middleware tool developed by our client. I want to know the below things :- 1. How do we access the metadata of PS Component Interface Objects defined through the Peoplesoft Application Designer from the External System (Non-Peoplesoft System). What are the list of PS Tables stores this information? 2. What are the list of delivered PS Component Interface API's? or How many delivered CI API's are there?. 3. We want to access the Peoplesoft application synchronously, which is the best integration method start? Component Interface or Application Messaging? 4. What are the list of things we should have to write the interface using Java. Provide Any other information to be considered for the above integration. Thanks Mohan ***************** End Of Article ****************** Sivaram posted Message 333 in Message Board Dated : June 20, 2001 at 20:07:48 EST Subject: Component Interface in PS 8 Once we create the CI in peoplesoft we generate the API's. When we want to send in data to Peoplesoft CI ,will it accept XML as an input. Is there a standard format where an external application need to follow such that the Peoplesoft java classes can understand ? Is the third party application need to generate XML or XSD or CI gives a XSD or XML file. Appreciate yoru help. ***************** End Of Article ****************** Sivaram posted Message 334 in Message Board Dated : June 20, 2001 at 20:54:08 EST Subject: Component Interface in PS 8 Hi All, 1.Could you tell me where can I find some documentation for the Java classes and methods generated by the Build API in Component Interface. ***************** End Of Article ****************** Sivaram posted Message 335 in Message Board Dated : June 20, 2001 at 21:04:40 EST Subject: Component Interface in PS 8 Hi All, 1.Could you tell me where can I find some documentation for the Java classes and methods generated by the Build API in Component Interface. ***************** End Of Article ****************** Sivaram posted Message 336 in Message Board Dated : June 20, 2001 at 21:12:46 EST Subject: Component Interface in PS 8 & Business Interlink. Hi All , I could Understand from CI and BI documentation in Peoplebooks that CI is for inbound and BI supports both inbound as well as Outbound. So my question is,Is there any particular reason why we use CI for inbound why not BI for both inbound and outbound. Appreciate your help, ***************** End Of Article ****************** Sivaram posted Message 337 in Message Board Dated : June 20, 2001 at 21:28:42 EST Subject: Component Interface in PS 8 & Business Interlink. Hi All , I could Understand from CI and BI documentation in Peoplebooks that CI is for inbound and BI supports both inbound as well as Outbound. So my question is,Is there any particular reason why we use CI for inbound why not BI for both inbound and outbound. Appreciate your help, ***************** End Of Article ****************** Mark Bollingh posted Message 338 in Message Board Dated : June 21, 2001 at 07:57:27 EST Subject: Re: Component Interface in PS 8 Hi, The methods that are generated are the same as those of the classic API's under VBA. The thing is don't forget to load the different class files in your java program. For more help, there is only the help of PeopleSoft him self. : Hi All, : 1.Could you tell me where can I find some documentation for the Java classes and methods generated by the Build API in Component Interface. ***************** End Of Article ****************** Sivaram posted Message 339 in Message Board Dated : June 21, 2001 at 13:09:18 EST Subject: Re: Message Agent: retrieving list of message names Hi, I could help, I have the exact query written forthis purpose.Remind me to send it to you. : Hi, : Does anybody know what's the best way to retrieve the list of messages that exist for the Message Agent ? I know how to : retrieve the attributes/fields etc once I know the Message name : using the PSMSG... functions. ***************** End Of Article ****************** RG posted Message 340 in Message Board Dated : June 21, 2001 at 18:56:28 EST Subject: Re: Business Interlinks Configuration Ratan We are also trying to deploy business interlinks for Tax and Credit card processing. The tax is a delivered process and still does not work. What problems are you having. ***************** End Of Article ****************** Chris posted Message 341 in Message Board Dated : June 25, 2001 at 20:05:56 EST Subject: Interfaces from HRMS8 to Financials 7.5 Currently, we are implementing HR version 8, using E&G 7.5 Financials. Work is beginning on AP & GL interfaces from Payroll. Anyone willing to share an outline of the route we should take to accomplish this? From app messaging XML to ???? Thanks in advance! ***************** End Of Article ****************** Eric posted Message 342 in Message Board Dated : June 26, 2001 at 05:34:02 EST Subject: Re: Message Agent: retrieving list of message names Hi Sivaram, I tried to email but it seems your hotmail account was deactivated. Can you sent your queries to erick@wrq.com ? Kind regards, Eric ***************** End Of Article ****************** greg posted Message 343 in Message Board Dated : June 27, 2001 at 08:07:40 EST Subject: Re: VBScript : : I get the following error: : C:\_DEV>cscript 3.vbs : Microsoft (R) Windows Script Host Version 5.1 for Windows : Copyright (C) Microsoft Corporation 1996-1999. All rights reserved. : C:\_DEV\3.vbs(2, 9) Microsoft VBScript compilation error: Expected end of statement : I actually was not expecting it would work because the VB Script documentation gives the following syntax for the Dim statement : Dim varname[([subscripts])][, varname[([subscripts])]] . . . : So how could I Dim variables as a certain datatype as in your example ? : : : Try this : : Dim nReplyOption& : : Dim Mag As CMagAutoServer : : Dim Result As Variant : : Set Mag = CreateObject("PeopleTools.MessageAgent") : : Result = Mag.StartMessage("ACT_AGT", "AgentList", False) : : Result = Mag.ProcessMessage(nReplyOption) : : That should work : : : I am trying to call ProcessMessage function in the message agent from my VBScript web page. The function takes a long*. I dim a variable and then pass it and I get a type mismatch. Even with I try to convert my variable with CLng I still get the error. Anyone have any suggestions. : : : Thanks ***************** End Of Article ****************** Sunitha posted Message 344 in Message Board Dated : June 28, 2001 at 09:34:35 EST Subject: Connect method in Message Agent Hi, Can anyone help me in telling how to use Message Agent API in a VB program?How to go about in this direction?I would be greatful if any sample VB program is provided to me.Thanks. -Sunitha. ***************** End Of Article ****************** Sivaram posted Message 345 in Message Board Dated : June 28, 2001 at 21:26:23 EST Subject: Business Interlink Hi Anybody succefully implemented Business Interlinks in peoplesoft ? Please sahre some information on that. Thanks. ***************** End Of Article ****************** Gustavo Liamgot posted Message 346 in Message Board Dated : July 01, 2001 at 20:28:59 EST Subject: Estella Langot Hello: I am Gustavo Liamgot (or Lamgott in russian) from Buenos Aires, Argentina. My father born in Kiev (Ucraine) Where your family from? Where your surname from? Reply me, please! Gustavo Liamgot P.S.: sorry for my english! ***************** End Of Article ****************** Emery B. Ronquillo posted Message 347 in Message Board Dated : July 06, 2001 at 02:20:52 EST Subject: Re: P/S Payroll System Design : : i am a student of STI,our topic in Thesis is a payroll system and we need some points to help us in the main structure of our project. ***************** End Of Article ****************** Savitha M.S. posted Message 348 in Message Board Dated : July 06, 2001 at 05:14:18 EST Subject: Interfacing with legacy system Hi, We are in a process of implementing peoplesoft 8.13 in our organization. We do have some systems which is already running on Sybase ASE 11.5. Now the problem is we need some data entered in legacy systems to peoplesoft databases. What would be the right solution? Is it component interface or application messaging. Where can i find more details about these on web. What manual we have got only talks about between 2 peoplesoft databases. I request to give pointers if anybody has already worked on this problem. TIA, Savvy ***************** End Of Article ****************** Bharat D Thakker posted Message 349 in Message Board Dated : July 06, 2001 at 14:38:48 EST Subject: Re: Interfacing with legacy system I would do a data mapping between the Legacy System and Peoplesoft Tables and write Application Engine Programs to upload Peoplesoft databases. : Hi, : We are in a process of implementing peoplesoft 8.13 in our organization. We do have some systems which is already running on Sybase ASE 11.5. : Now the problem is we need some data entered in legacy systems to peoplesoft databases. : What would be the right solution? Is it component interface or application messaging. Where can i find more details about these on web. What manual we have got only talks about between 2 peoplesoft databases. I request to give pointers if anybody has already worked on this problem. : TIA, : Savvy ***************** End Of Article ****************** Annie B. Degala posted Message 350 in Message Board Dated : July 06, 2001 at 21:00:25 EST Subject: P/S Payroll System Design i am a 4th yr. college, taking up bachelor of science in computer science. we are developing a payroll system of the hospital. i want to ask some sample of payroll system and other data about payroll system. i guess it will help a lot on my system development. thanx a lot. ***************** End Of Article ****************** Recruiter posted Message 351 in Message Board Dated : July 17, 2001 at 17:19:03 EST Subject: Re: Payroll interface : Does anyone have a list of payroll systems that PeopleSoft can interface with? : Were using Centrepay -Paypoint Vu 2.10.1 : Thanks. THIS IS NOT A RECRUITIZNG EFFORT. I am replying because I know a little bit. During my experience I have come across 3, ADP, Ceridian, and ProBusiness. Thanks ***************** End Of Article ****************** Bruce Tobin posted Message 352 in Message Board Dated : July 18, 2001 at 08:46:53 EST Subject: Re: Java access to component interface. >Is there a fundamental difference in the way the Java >libraries and the VB libraries handle application errors? To answer my own question, yes, there is a fundamental difference. The Java classes deliberately discard any PeopleSoft messages in the event of a save error. This is a serious bug IMO. ***************** End Of Article ****************** Suraj posted Message 353 in Message Board Dated : July 19, 2001 at 00:42:52 EST Subject: Business Interlink Run-time plug-in... I want to write a Business Interink Run-time plug-in using Java. The examples in PeopleBooks explain the method using only C++ and VB. What are the requirements for Java? Are there any package/classes specifically needed? Any help on this will be highly appreciated. I am new to PeopleSoft OIF... Thanks Suraj. ***************** End Of Article ****************** Alexej Kupin posted Message 354 in Message Board Dated : July 21, 2001 at 20:04:01 EST Subject: Java API for PS 7.5 Dear all, PS 7.5 does not provide Java-API (only Messaging Agent as C-library) So many people(like me) are thinking how to communicate with PS 7.5 from a Java Program... PS 7.5 does not provide a CORBA-Server :( So I think the only one way is to wrap the C-library with Java's JNI... Did someone done it already? Or know anything? I founded that BEA's eLink did it(for each OS!) but you have to buy all BEA servers! :))) I also founded that IPlanet did something equal (with few success) but we have to buy the whole IPlanet suite! Do anybody know a free or comercial java wrapper for PS 7.5 API ?! Thanks Alexej ***************** End Of Article ****************** Suraj posted Message 355 in Message Board Dated : July 22, 2001 at 20:49:20 EST Subject: Integration involving PS OIF and MQSeries Hi, Can any body help me with some information on how to use Business Interlinks, Component Interface, Application Messaging etc. with MQSeries? Any information on the above will be highly appreciated. Thanks in Advance, Suraj. ***************** End Of Article ****************** koko posted Message 356 in Message Board Dated : July 23, 2001 at 07:53:13 EST Subject: Re: P/S Payroll System Design : : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Anjan Bellur posted Message 357 in Message Board Dated : July 30, 2001 at 17:44:23 EST Subject: PeopleSoft 7.5 APIs Hello All, I have been hunting for APIs for PeopleSoft 7.5 . Unfortunately, I don't believe any exist. Do any of you have suggestions on how to get around this issue. I am working on some backend integration with this product. Thanks. ***************** End Of Article ****************** Bruce Tobin posted Message 358 in Message Board Dated : August 02, 2001 at 09:50:28 EST Subject: Re: Integration involving PS OIF and MQSeries : Hi, : Can any body help me with some information : on howto use Business Interlinks, Component : Interface, Application Messaging etc. with MQSeries? PeopleSoft 8.13 (and above, presumably) ships with an application messaging gateway adapter for MQSeries. Unfortunately it uses the simplified AMI interface to MQSeries, which requires extra setup on the MQ side to use (if you're still on the 5.1 release of MQ, like we are; supposedly the 5.2 install configures AMI by default). If you don't want to use AMI, it's pretty easy to adapt the SimpleFileHandler adapter they ship to write to a queue instead of a file. ***************** End Of Article ****************** Sivaram posted Message 359 in Message Board Dated : August 03, 2001 at 09:57:59 EST Subject: Re: PeopleSoft 7.5 APIs Hi There isn't a set of API's files as such for 7.5 , If you want to connect to Peoplesoft from an external system you need to have the connect,start message ,process message sequence of API written using VB ,Java or C . What kind of language are you using ? You can refer to the Peoplebooks to write the coding. Rgds : Hello All, : I have been hunting for APIs for PeopleSoft 7.5 . Unfortunately, I don't believe any exist. : Do any of you have suggestions on how to get around this issue. I am working on some backend integration with this product. : Thanks. ***************** End Of Article ****************** Sivaram posted Message 360 in Message Board Dated : August 03, 2001 at 10:00:28 EST Subject: Re: PeopleSoft 7.5 APIs If you are using java you need to include psjmac.jar file which you can find in docs directory under PS_HOME.I hope this is useful.If you using C I think there are some .H files need to be included before you write the API commands. : Hello All, : I have been hunting for APIs for PeopleSoft 7.5 . Unfortunately, I don't believe any exist. : Do any of you have suggestions on how to get around this issue. I am working on some backend integration with this product. : Thanks. ***************** End Of Article ****************** Sivaram posted Message 361 in Message Board Dated : August 03, 2001 at 10:01:52 EST Subject: Re: Java API for PS 7.5 Hi, From the version 7.54 onwards Java is supported. There are some API's for java available in Peoplesoft. Which version are you using. : Dear all, : PS 7.5 does not provide Java-API : (only Messaging Agent as C-library) : So many people(like me) are thinking how : to communicate with PS 7.5 from a Java Program... : PS 7.5 does not provide a CORBA-Server :( : So I think the only one way is to wrap the C-library : with Java's JNI... : : Did someone done it already? Or know anything? : I founded that BEA's eLink did it(for each OS!) : but you have to buy all BEA servers! :))) : I also founded that IPlanet did something equal : (with few success) but we have to buy the whole : IPlanet suite! : Do anybody know a free or comercial java wrapper : for PS 7.5 API ?! : Thanks Alexej ***************** End Of Article ****************** Sivaram posted Message 362 in Message Board Dated : August 03, 2001 at 10:04:00 EST Subject: Re: Business Interlink Run-time plug-in... Hi, Yes there are some packaged need to included. However BI will not work untill the version 8.14 using any Runtime plugin written in Java,VB or C . There are some bugs detected. Are you on a integration project. Let me know I can help on the project. Rgds : I want to write a Business Interink Run-time plug-in using Java. : The examples in PeopleBooks explain the method using only C++ and VB. : What are the requirements for Java? Are there any package/classes specifically needed? : Any help on this will be highly appreciated. : I am new to PeopleSoft OIF... : Thanks : Suraj. ***************** End Of Article ****************** Amit Chauhan posted Message 363 in Message Board Dated : August 06, 2001 at 18:28:37 EST Subject: Re: Message Agent: retrieving list of message names Hi, Can you please send the same queries to my account too : amit_chauhan@yahoo.com Thanks Amit : Hi, I could help, I have the exact query written forthis purpose.Remind me to send it to you. : : Hi, : : Does anybody know what's the best way to retrieve the list of messages that exist for the Message Agent ? I know how to : : retrieve the attributes/fields etc once I know the Message name : : using the PSMSG... functions. ***************** End Of Article ****************** Sandeep S. Kulkarni posted Message 364 in Message Board Dated : August 08, 2001 at 11:05:02 EST Subject: Re: P/S Payroll System Design : : : i am a student in grade 5 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. Thanks for the coparation ***************** End Of Article ****************** Sadao posted Message 365 in Message Board Dated : August 09, 2001 at 22:23:31 EST Subject: Component Interface using Java I'm using PeopleTools8.12, and I'm making Java programs which access PS8 through Component Interface. Now I Can't get field values in occurs level 0. Maybe the get*() method doesn't work correctly. Why? ***************** End Of Article ****************** Anand posted Message 366 in Message Board Dated : August 13, 2001 at 01:59:13 EST Subject: Billing Interface with Legacy We are preparing to implement the PS Billing module (version 8), and would like to know if anyone out there has had any experience with interfacing external "legacy" data. Thank you very much! Anand ***************** End Of Article ****************** Vimi posted Message 367 in Message Board Dated : August 14, 2001 at 04:18:08 EST Subject: Re: Component Interface & Application Messaging : We are trying to Integrate with a Peoplesoft Application (PS 8) through a middleware tool developed by our client. : I want to know the below things :- : 1. How do we access the metadata of PS Component Interface Objects defined through the Peoplesoft Application Designer from the External System (Non-Peoplesoft System). What are the list of PS Tables stores this information? : 2. What are the list of delivered PS Component Interface API's? or How many delivered CI API's are there?. : 3. We want to access the Peoplesoft application synchronously, which is the best integration method start? Component Interface or Application Messaging? : 4. What are the list of things we should have to write the interface using Java. : Provide Any other information to be considered for the above integration. : Thanks : Mohan DId get the solutions to your problems. Pl. lemme also know. Thanks ***************** End Of Article ****************** Vimi posted Message 368 in Message Board Dated : August 14, 2001 at 04:18:14 EST Subject: Re: Component Interface & Application Messaging : We are trying to Integrate with a Peoplesoft Application (PS 8) through a middleware tool developed by our client. : I want to know the below things :- : 1. How do we access the metadata of PS Component Interface Objects defined through the Peoplesoft Application Designer from the External System (Non-Peoplesoft System). What are the list of PS Tables stores this information? : 2. What are the list of delivered PS Component Interface API's? or How many delivered CI API's are there?. : 3. We want to access the Peoplesoft application synchronously, which is the best integration method start? Component Interface or Application Messaging? : 4. What are the list of things we should have to write the interface using Java. : Provide Any other information to be considered for the above integration. : Thanks : Mohan DId get the solutions to your problems. Pl. lemme also know. Thanks ***************** End Of Article ****************** Vimi posted Message 369 in Message Board Dated : August 14, 2001 at 06:20:46 EST Subject: Interface between PS 7.5 and Third Party Tools - Urgent 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 ***************** End Of Article ****************** James posted Message 370 in Message Board Dated : August 14, 2001 at 15:05:20 EST Subject: Remote Call We currently have 3 instances on our APPS Server and each has there own set of .gnt. So when the user tries to run a remote call it ABORTS on PTPNTEST COBOL program. I've turned the trace logging, and the .out and the .err file are empty. If antbody shed some light on this , it would be great. Thanks James Parsons ***************** End Of Article ****************** vishwanath posted Message 371 in Message Board Dated : August 14, 2001 at 16:35:43 EST Subject: Re: Billing Interface with Legacy We have just done few interfaces in Ver 8 for Billing Module. any questions let me know regards VISHWA : We are preparing to implement the PS Billing module (version 8), and would like to know if anyone out there has had any experience with interfacing external "legacy" data. : Thank you very much! : Anand ***************** End Of Article ****************** James B posted Message 372 in Message Board Dated : August 15, 2001 at 09:11:49 EST Subject: Re: Remote Call Can you give a bit more detail about your environment? Like what version and platform? Also, isn't PTPNTEST the small test program that PeopleSoft delivered to test Remote Call functionality? How was it invoked? via peoplecode? or via app-engine/cobol? ***************** End Of Article ****************** Sivaram posted Message 373 in Message Board Dated : August 15, 2001 at 09:53:39 EST Subject: Re: Component Interface using Java Interesting Ha. This is a bug reported by Peoplesoft.This wasn't solved untill the version 8.14 . I have also gone through the same problem.If you need the level 0 you have to upgrade.Applying patches on 8.12 will not help. Good luck. : I'm using PeopleTools8.12, : and I'm making Java programs which access PS8 through Component Interface. : Now I Can't get field values in occurs level 0. : Maybe the get*() method doesn't work correctly. : Why? ***************** End Of Article ****************** Ram posted Message 374 in Message Board Dated : August 15, 2001 at 16:31:01 EST Subject: Re: retrieving data in XML format Hii. Regarding your query I guess it would be possible to get the output in XMl format from SQL server 2000 database. Sql server 2000 supports XML. Please contact me for further clarifications Ram ***************** End Of Article ****************** Stan posted Message 375 in Message Board Dated : August 16, 2001 at 10:00:24 EST Subject: Re: Billing Interface with Legacy : We are preparing to implement the PS Billing module (version 8), and would like to know if anyone out there has had any experience with interfacing external "legacy" data. : Thank you very much! : Anand The key table that needs to be populated in peoplesoft billing is the INTFC_BI table, however, more information is needed to know if you will bring over notes, adjustments, etc from your external system. There are key fields that need to be populated with specific values based on this information. Please email me @ williams@broughton-sys.com and we can communicate further on the detail information you are asked to bring over from the third party system. Stan ***************** End Of Article ****************** James P posted Message 376 in Message Board Dated : August 16, 2001 at 11:57:12 EST Subject: Re: Remote Call : Can you give a bit more detail about your environment? Like what version and platform? : Also, isn't PTPNTEST the small test program that PeopleSoft delivered to test Remote Call functionality? How was it invoked? via peoplecode? or via app-engine/cobol? Peoplesoft 8.12.0 and AIX 4.3.3 ***************** End Of Article ****************** James P posted Message 377 in Message Board Dated : August 16, 2001 at 12:01:05 EST Subject: Re: Remote Call : : Can you give a bit more detail about your environment? Like what version and platform? : : Also, isn't PTPNTEST the small test program that PeopleSoft delivered to test Remote Call functionality? How was it invoked? via peoplecode? or via app-engine/cobol? : Peoplesoft 8.12.0 and AIX 4.3.3 The PTPNTEST was invoked by 4tier PS/tools. ***************** End Of Article ****************** James P posted Message 378 in Message Board Dated : August 16, 2001 at 12:04:20 EST Subject: Re: Remote Call : : Can you give a bit more detail about your environment? Like what version and platform? : : Also, isn't PTPNTEST the small test program that PeopleSoft delivered to test Remote Call functionality? How was it invoked? via peoplecode? or via app-engine/cobol? : Peoplesoft 8.12.0 and AIX 4.3.3 Plus we ahve another Server that the Remote Call woeks fine. And checked and rechecked the Differences between the 2 Servers and it seems that cobol is NOT loaded on the Server were the Remote Call is not working, so would this cause it not to work.. If you have any idea's please email directly jamesP@407etr.com ***************** End Of Article ****************** XYZ posted Message 379 in Message Board Dated : August 16, 2001 at 18:44:38 EST Subject: Delete record using Message Agent API Hi, Does anyone know, how to delete a record from peoplesoft using Message Agent API. Am able to insert, update and select using JMAC library for java. But it doesnt have anything related to deleting record. If anyone can tell how to delete the record, then that will be very helpful. Thanks XYZ ***************** End Of Article ****************** Sivaram posted Message 380 in Message Board Dated : August 17, 2001 at 01:22:51 EST Subject: Re: Interface between PS 7.5 and Third Party Tools - Urgent 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 ***************** End Of Article ****************** Rosey posted Message 381 in Message Board Dated : August 20, 2001 at 16:02:40 EST Subject: Interfaces Help! Can anyone answer this question? I work as a foreign recruiter for a college that uses PeopleSoft for its admissions data base. Is there any personal database program I can use (Filemaker, Excel...etc.) which would easily transfer into PeopleSoft? I would like the college to be able to avoid entering my data by hand. Thanks, Rosey ***************** End Of Article ****************** Sivaram posted Message 382 in Message Board Dated : August 21, 2001 at 10:53:53 EST Subject: Re: Interfaces Hi, There are lot of ways to do this.Sinplest would be writing a SQR program to read your excel data and update to Peoplesoft.Hope this helps. : Help! Can anyone answer this question? I work as a foreign recruiter for a college that uses PeopleSoft for its admissions data base. Is there any personal database program I can use (Filemaker, Excel...etc.) which would easily transfer into PeopleSoft? I would like the college to be able to avoid entering my data by hand. : Thanks, : Rosey ***************** End Of Article ****************** sivaram posted Message 383 in Message Board Dated : August 21, 2001 at 10:59:25 EST Subject: Re: Delete record using Message Agent API Hi XYZ, there is a way to delete.You can delete only the level 1 rows or above as a rule in peoplesoft.In your message agent definition level mapping you can select the radio button delete row if found. This will delete the record you have selected. : Hi, : Does anyone know, how to delete a record from peoplesoft using Message Agent API. Am able to insert, update and select using JMAC library for java. But it doesnt have anything related to deleting record. : If anyone can tell how to delete the record, then that will be very helpful. : Thanks : XYZ ***************** End Of Article ****************** Amit Chauhan posted Message 384 in Message Board Dated : August 22, 2001 at 15:48:39 EST Subject: Re: Delete record using Message Agent API Thanks Sivaram, I'll try this and let you know. Thanks Amit : Hi XYZ, there is a way to delete.You can delete only the level 1 rows or above as a rule in peoplesoft.In your message agent definition level mapping you can select the radio button delete row if found. This will delete the record you have selected. : : : Hi, : : Does anyone know, how to delete a record from peoplesoft using Message Agent API. Am able to insert, update and select using JMAC library for java. But it doesnt have anything related to deleting record. : : If anyone can tell how to delete the record, then that will be very helpful. : : Thanks : : XYZ ***************** End Of Article ****************** Melissa posted Message 385 in Message Board Dated : August 22, 2001 at 17:59:35 EST Subject: Re: Interfaces What version of PSft are you on? You may be able to use Import Manager which reads in data from a *.prn file. This type of file can be made out of excel. (Save as file type space delimited, *.prn.)v8 has some new integrations that can also read in data from a flat file. ***************** End Of Article ****************** MM posted Message 386 in Message Board Dated : August 23, 2001 at 04:28:04 EST Subject: PeopleSoft Application layer/business logic level integration Greetings, I have an integration server that can send and receive XML documents and can use SOAP. Does PeopleSoft have any connector (like ERP SAP's XML business connector) to integrate at the application layer/business logic level? Thanks, MM. ***************** End Of Article ****************** Charles Solomon posted Message 387 in Message Board Dated : August 23, 2001 at 16:52:54 EST Subject: Open a new explorer window with VBScript Hello, I appologize for my ignorance, but I am looking for a way that I can cause Internet Explorer to open pointed at a particular site in a new window. I want to kick this off from a ".vbs" file that gets run from the desktop. I don't know anything about coding in VBScript currently, but was hoping that someone could post a simple line of code to do it. (or point me to a site with good examples of VBScript). Thanks, Charles Solomon ***************** End Of Article ****************** Dayanand posted Message 388 in Message Board Dated : August 23, 2001 at 20:56:14 EST Subject: Message Agent (error while connecting to ps appserver) Hi we are using message agent to connect to ps from our app. the code(given below) is not able to connect to the ps. ............................................................ import psft.pt75.beans.ma.*; public class MessageAgent { public static void main(String[] args) { MagClient magClient = new MagClient(); MagResult res = magClient.connect("PSServer:9000","PS", "PS"); ErrorItem[] errItems = res.getErrorItems(); for (int i=0; i. Maybe I need to pass some more parameters to the RemoteCall! Help ! ***************** End Of Article ****************** Rolfer posted Message 393 in Message Board Dated : August 28, 2001 at 10:54:39 EST Subject: Christal Report send as rtf-file I have a Report and want to send this per email in rtf-format. How can I hold the field formats of CR? ***************** End Of Article ****************** Bharat D Thakker posted Message 394 in Message Board Dated : August 28, 2001 at 13:06:47 EST Subject: Re: Calling App Engine from RemoteCall In Peoplesoft 8.0, CallAppEngine is used to call App. Engine Programs instead of RemoteCall. : I am trying to call Application Engine from peoplecode using RemoteCall . When I run the Application Engine process separately -it runs fine but the RemoteCall is not working. The call looks like this - : RemoteCall("PSRCCBL", "PSCOBOLPROG", "PTPEMAIN", "PSRUNCTL", "SRV03", "RC", &RETURNCODE, "PI", &PROCESSINSTANCE); : It allocates a ProcessInstance to the process but always gives a message like - : 0 requests found for . : Maybe I need to pass some more parameters to the RemoteCall! : Help ! ***************** End Of Article ****************** M Chandra posted Message 395 in Message Board Dated : August 28, 2001 at 14:35:35 EST Subject: Re: Calling App Engine from RemoteCall But we have Peoplesoft 7.6 here. It does not provide the CallAppEngine call. It has to be called using RemoteCall. : In Peoplesoft 8.0, CallAppEngine is used to call App. Engine Programs instead of RemoteCall. : : : I am trying to call Application Engine from peoplecode using RemoteCall . When I run the Application Engine process separately -it runs fine but the RemoteCall is not working. The call looks like this - : : RemoteCall("PSRCCBL", "PSCOBOLPROG", "PTPEMAIN", "PSRUNCTL", "SRV03", "RC", &RETURNCODE, "PI", &PROCESSINSTANCE); : : It allocates a ProcessInstance to the process but always gives a message like - : : 0 requests found for . : : Maybe I need to pass some more parameters to the RemoteCall! : : Help ! ***************** End Of Article ****************** Vishwa posted Message 396 in Message Board Dated : September 01, 2001 at 08:02:01 EST Subject: Re: Billing Interface with Legacy Thanks for reply Vishwa. I would like to give u a borad picture of what v hv done so far; 1. Listed all the required fields from the INTFC_BI and INTFC_BI_NOTE( PREsently these are the two tables v r going to populate - requirement for S/w Industry) 2. Fundamentally for each line of External system will be generating a LINE row and 2 AE rows and a >1 NOTE row in the PS side. (Reading the flat file, creating multiple lines as said above in an App Eng Prog and call a CompInterface to write to Staging area.) 3. Run the Billing Interface program (done for sample data worked). No errors in Billing Interface - Errors and Billing Interface - Pending 4. Change the staus to ready and generate the Invoice. Before define the grouping criteria. But in reality we will be using Applicaton Messaging for this. I would like to know fro you that is it the way u hv followed or is it something different. Have u tried out with App Msgng. Awaiting your reply anand chanchi : We have just done few interfaces in Ver 8 for Billing Module. : any questions let me know : regards : VISHWA : : We are preparing to implement the PS Billing module (version 8), and would like to know if anyone out there has had any experience with interfacing external "legacy" data. : : Thank you very much! : : Anand ***************** End Of Article ****************** John Martin posted Message 397 in Message Board Dated : September 04, 2001 at 14:03:01 EST Subject: Message Agent API - Java or VB examples? Might some kind soul have wisdom and/or example code to share on using the 7.5 Message Agent to update employee personal data? (i.e., the stuff you'd find in PS_PERSONAL_DATA -- home address, phone, and the like.) Unfortunately I don't have access to PBooks. Thanks in advance! John jm930@hotmail.com ***************** End Of Article ****************** Greg Weir posted Message 398 in Message Board Dated : September 06, 2001 at 15:49:55 EST Subject: Re: Message Agent (error while connecting to ps appserver) Try adding this to your code: private static final String propertiesFile = "address for PeopleSoft/pstools.properties"; MagResult res = magClient.loadPSToolsProperties(propertiesFile); if (res.getSucceeded() == false) { System.out.println("Error loading PS Tools Properties "); } Before the line: magClient.connect("PSServer:9000","PS", "PS"); : Hi : we are using message agent to connect to ps from our app. the code(given below) is not able to connect to the ps. : ............................................................ : import psft.pt75.beans.ma.*; : public class MessageAgent : { : public static void main(String[] args) : { : MagClient magClient = new MagClient(); : MagResult res = magClient.connect("PSServer:9000","PS", "PS"); : ErrorItem[] errItems = res.getErrorItems(); : for (int i=0; i