Hi Joe,
Records are getting inserted directly into the database tables using stored procedures. Sorry I should have mentioned that it's and Oracle db. Thanks again. _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, September 06, 2007 4:57 PM To: arslist@ARSLIST.ORG Subject: Re: Loading people into the CTM:People form - customers Then this utility will not really help you. By saying updating the database directly, what exactly do you mean? What tool are they using if they aren't using the Import tool? An Escalation that updates CTM:People from some other external table? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mary Dollus Sent: Thursday, September 06, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: Loading people into the CTM:People form - customers ** Hi Joe. Well I built the form because we have an external process that has to be interfaced with and they also store people data; however there is a ton more associated data for each person. And I didn't want to modify the People form to try to save on customizations to OTB stuff. so I built a sort of staging form so their people data can hold the typical stuff (name, address, etc) but also their extra info. The required CTM:People fields need to be filled in so we can open tickets in the IM app (Help Desk) and automating it is the only way since there are so many customers. Sure. if you have it that would be great. merge won't work for me because they are updating the database directly rather than ARImport. However I may be able to see what's happening. Thanks a ton! Mary _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, September 06, 2007 4:07 PM To: arslist@ARSLIST.ORG Subject: Re: Loading people into the CTM:People form - customers Mary, Have you built that staging form yourself and having problems with it? OR Are you using a 3rd party utility where this staging form is a part of?? I have a utility that could help in mass load of people data and can send that to you if you would like to use that. It was given to me by BMC support. It contains a number of filters defined to trigger on MERGE. Let me know if you want to consider using that. I'll try to find it and send it across.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mary Dollus Sent: Thursday, September 06, 2007 4:50 PM To: arslist@ARSLIST.ORG Subject: Re: Loading people into the CTM:People form - customers ** Ok thanks Rick!!! I'll keep digging. For the Client Type of Customer it doesn't seem that Site needs to be loaded. or at least it's worked for me so far without it. It would be so much easier if we could assign Roles to AR_ESCALATOR... :-) _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, September 06, 2007 3:37 PM To: arslist@ARSLIST.ORG Subject: Re: Loading people into the CTM:People form - customers ** Mary, there are other validations going on - even for arcane things like the phone number. Adding the qualification like you did for those Filters worked for me - you just have to turn the logs on and see where it failed, then where the data can't be cleaned to the point where this isn't necessary, add the exclusion to another Filter until it stops running into them. Here are the other Filters I encountered: CTM:PPL:VerifyManageInfo_141_Check CTM:PPL:VerifyManageInfo_142_Check CTM:PPL:VerifySite_100_Check CTM:PPL:VerifySite_101_Check Also, check this CTM:Support Group Assoc Lookup Active Link: CTM:SGL:AddGrp_016_AddSGA-E, which has a bug related to evaluating the wrong field as $NULL$ (in patch 3). HTH! Rick On 9/6/07, Mary Dollus <[EMAIL PROTECTED]> wrote: Hi Everyone, I'm having issues trying to get data loaded into the CTM:People form. I figured out all I need to load and am able to get the data to load via the import tool and also by a filter firing on a staging form. We're bringing the data into a staging form and then pushing only the necessary fields over to the CTM:People form so we can keep customization to a minimum. So what is happening is.. the records are entered in the staging form and every so often an escalation checks the form and if it sees changes it sets a field to Update. Then when the staging form is modified a filter fires... checks conditions... and is supposed to push data to the CTM:People form. However, some rule checking is taking place on the People form and it's causing my action to fail with this error message: "As the General Access of this ticket, you do not have permission to submit or modify the People profile Status from "" to "Enabled"." The filters causing the issue are: CTM:PPL:GetStatusRuleSet_030 CTM:PPL:GetStatusRulesRead_031 CTM:PPL:StatusRulesErr_032 I even tried adding $USER$ != "AR_ESCALATOR" however that didn't help. Has anyone encountered this? Thanks!!! Mary Dollus __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"