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.com ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________ Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL Food.__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"
