Yes my PeopleSoft database is on Oracle... I used the AIE engine to do the data interchange on a staging form.. On this staging form I created filters to validate the data that has to go into the CTM:People form and the User form.. As a part of the validations I also manupulated data such as the full name to be in the format that the ITSM configuration tool puts it -> Firstname + Middle Initial if it exists + Last name. I also created filters to manupulate phone numbers and extensions like Remedy ITSM does.. You will need to create workflow for inserting data into the CTM:PeoplePermissions group form for default groups that you want new users to be in.. This is just the gist of it.. If you want any other specific details feel free to write to me.. Joe
----- Original Message ---- From: SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, May 14, 2008 4:48:41 PM Subject: Re: AD and CTM:People ** Joe - Can you share how are you did the PeopleSoft integration? We are working on that here too. Is your PeopleSoft in Oracle or SQL? Joe DeSouza <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 05/14/2008 03:47 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: AD and CTM:People ** A staging form with data checks for everything including duplicate login ID's is what I did when I had to integrate Remedy with the PeopleSoft database recently.. works like a charm.. Creates new users from Peoplesoft with all the necessary permissions they require, and updates existing users.. Joe ----- Original Message ---- From: Kathy Morris <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, May 14, 2008 4:34:55 PM Subject: Re: AD and CTM:People ** I am concerned about error-checking - perhaps I should build workflow to send out notifications when there records make it to the staging table and do not merge into the CTM:People In a message dated 5/14/2008 10:58:03 A.M. Pacific Daylight Time, [EMAIL PROTECTED] writes: ** That is the way I did it, including defaulting some NULL fields that Remedy requires. I have an escalation that pulls the AD data (via a vendor form) into a staging table, which then uses filters to do validations and auto-population of some data, then if it passes all the validations, passes it into the CTM:People form and all the related forms that need populated. It sounds like you already have that, but need to use a LOWER() function in your Push Fields that passes the Remedy Login Name field. Something else that will be useful for you is to set up another filter to find users to automatically disable too. In my filter to do that, I have: (( 'userAccountControl' = 514) OR ( 'userAccountControl' = 546) OR ( 'userAccountControl' = 65538) OR ( 'userAccountControl' = 66050)) The userAccountControl field are set to those values when a person is de-activated, so you can create a filter to set them to “Obsolete” in CTM:People as well as set Support Staff? To No and remove all their permissions. This helps quite a bit in keeping license costs down because you’re not wasting licenses by maintaining them for people that are no longer with the company. Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, May 14, 2008 11:37 AM To: arslist@ARSLIST.ORG Subject: AD and CTM:People ** Hi, AR System: 7.0.1 Thru workflow, data is passed from Active Directory into Remedy vendor tables then thru escalations into Remedy CTM:People. We have users that sometimes enter the field values in upper/lower case. Whenever they enter uppercase/lower case or leave certain fields BLANK, the record does not get into the CTM:People form. I would like to build workflow that changes the case to LOWERCASE and does error-checking on records that come from AD that don't make it into the CTM:People form. Am I approaching this correctly, or is there a better way? ________________________________ Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL Food. __Platinum Sponsor: www.rmsportal.comARSlist: "Where the Answers Are" html___ Private and confidential as detailed here. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.comARSlist: "Where the Answers Are" html___ ________________________________ Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL Food. __Platinum Sponsor: www.rmsportal.comARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
