Re: Updating user profile in People form...RESOLVED
Yes Joe, You are absolutely correct. But unfortunately we don't have database access as there are other third party applications running. Thanks again for sharing information. Vinit Joe DeSouza wrote: > > Vinit, > > Actually if thats all what you wanted to do, you didn't have to delete the > records in the CTM:People form. Running a simple update at the DB level > could have achieved the same thing within a few seconds. > > UPDATE CTM_People SET Submitter = Remedy_Login_ID where Remedy_Login_ID IS > NOT NULL AND Submitter = 'AR_ESCALATOR'; > Commit; > > This would have done the same thing in a few seconds.. > > Cheers > > Joe > > > > > > From: "Decou, Candace M" > To: arslist@ARSLIST.ORG > Sent: Tuesday, January 20, 2009 2:22:30 PM > Subject: Re: Updating user profile in People form...RESOLVED > > Excellent - thanks for sharing the resolution. Now we all know. > :) > Candace > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of vinitPatil > Sent: Tuesday, January 20, 2009 1:21 AM > To: arslist@ARSLIST.ORG > Subject: Re: Updating user profile in People form...RESOLVED > > Hello All, > > Thanks for your continuous support.. > > The issue has been solved. Here are the details.. > > First I deleted all the People records from CTM:People because the value > for Submitter field for all the records was "AR_ESCALATOR". Then again I > re-imported records from AD but this time I set the "Submitter" field as > Login ID of the user. Also I set the change permissions of Organization, > Department and Site field as Submitter. So here user automatically became > submitter for the record. Now he can change Organization, Department and > Site. > > Thanks & Regards, > Vinit > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > > - Thanks & Regards, Vinit -- View this message in context: http://www.nabble.com/Updating-user-profile-in-People-form...-tp21525709p21577836.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Updating user profile in People form...RESOLVED
Vinit, Actually if thats all what you wanted to do, you didn't have to delete the records in the CTM:People form. Running a simple update at the DB level could have achieved the same thing within a few seconds. UPDATE CTM_People SET Submitter = Remedy_Login_ID where Remedy_Login_ID IS NOT NULL AND Submitter = 'AR_ESCALATOR'; Commit; This would have done the same thing in a few seconds.. Cheers Joe From: "Decou, Candace M" To: arslist@ARSLIST.ORG Sent: Tuesday, January 20, 2009 2:22:30 PM Subject: Re: Updating user profile in People form...RESOLVED Excellent - thanks for sharing the resolution. Now we all know. :) Candace -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of vinitPatil Sent: Tuesday, January 20, 2009 1:21 AM To: arslist@ARSLIST.ORG Subject: Re: Updating user profile in People form...RESOLVED Hello All, Thanks for your continuous support.. The issue has been solved. Here are the details.. First I deleted all the People records from CTM:People because the value for Submitter field for all the records was "AR_ESCALATOR". Then again I re-imported records from AD but this time I set the "Submitter" field as Login ID of the user. Also I set the change permissions of Organization, Department and Site field as Submitter. So here user automatically became submitter for the record. Now he can change Organization, Department and Site. Thanks & Regards, Vinit ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Updating user profile in People form...RESOLVED
Excellent - thanks for sharing the resolution. Now we all know. :) Candace -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of vinitPatil Sent: Tuesday, January 20, 2009 1:21 AM To: arslist@ARSLIST.ORG Subject: Re: Updating user profile in People form...RESOLVED Hello All, Thanks for your continuous support.. The issue has been solved. Here are the details.. First I deleted all the People records from CTM:People because the value for Submitter field for all the records was "AR_ESCALATOR". Then again I re-imported records from AD but this time I set the "Submitter" field as Login ID of the user. Also I set the change permissions of Organization, Department and Site field as Submitter. So here user automatically became submitter for the record. Now he can change Organization, Department and Site. Thanks & Regards, Vinit vinitPatil wrote: > > Hi Candace, > > Thank you for ur reply.. > > I agree with your point that the true data for site needs to be first > entered into the form SIT:Site. > On the People form a menu is connected to Site field which just fetch all > the Sites from the SIT:Site form. But People form it self stores Site > value with corresponding user record. Site field is required as long as > the user is Office-Based Employee. There are number of fields on People > form related to Site such as Site Country, Site City, Site Street, Site > ID, Site State Province, Site Zip/Postal Code, Timezone etc. These fields > are used to display the Site Address field which is Display-Only. > Let me check with changing Submitter. I hope this will give me a hint. > > Thanks & Regards, > Vinit > > > Decou, Candace M wrote: >> >> I believe the problem is that the true data for Site needs to be first >> entered into the form SIT:Site. On the People form, there is just a >> menu for the Site field associated with the underlying data in the Site >> form. So you must have the data in the Site form first. You will >> likely need to look at the permissions on that form and set up your push >> fields to that form before you will be able to set the correct fields on >> the People form. >> >> You will likely need to have Contact Admin permissions in order to >> perform this also and I doubt that your normal users have that >> permission set. >> >> Hope this helps. >> >> :-) >> >> Candace >> >> >> >> >> >> ____________ >> >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz >> Sent: Sunday, January 18, 2009 3:18 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Updating user profile in People form... >> >> >> >> ** >> >> Vinit >> >> have a look for this field on the User form. I believe that if you >> modify the People form, it might try to make a modification on the User >> form. If not that, then turn on your logging and have a look. It looks >> like there is a Push happening on the People form which is causing the >> error message. Let me know >> >> >> >> thanks >> >> >> >> shafqat >> >> --- On Sun, 1/18/09, LisaD wrote: >> >> From: LisaD >> Subject: Re: Updating user profile in People form... >> To: arslist@ARSLIST.ORG >> Date: Sunday, January 18, 2009, 6:56 PM >> >> In addition to giving Change permission to Public and General >> Access, do you >> also have the field flagged as "Allow any User to Submit"? >> >> If you want to send me the active link off line, I would be >> happy to take a >> look at it as well. >> >> lisa.westerfi...@maryville.com >> >> Also, Have you logged >> >> vinitPatil wrote: >> > >> > Hello All, >> > >> > I've imported almost 4000 people records from AD to CTM:People >> form. >> The >> > Site field is Null for all the records as there is no such >> field in AD. So >> > we've decided to let users update there Site, Organization and >> Department >> > values. We've more than 70 Sites, 20 Organizations and almost >> 90 >> > departments. I've already populated this data using Data >> Management >> tool. >> > >> > What I've done is; when user clicks on "Requester Console&quo
Re: Updating user profile in People form...RESOLVED
Hello All, Thanks for your continuous support.. The issue has been solved. Here are the details.. First I deleted all the People records from CTM:People because the value for Submitter field for all the records was "AR_ESCALATOR". Then again I re-imported records from AD but this time I set the "Submitter" field as Login ID of the user. Also I set the change permissions of Organization, Department and Site field as Submitter. So here user automatically became submitter for the record. Now he can change Organization, Department and Site. Thanks & Regards, Vinit vinitPatil wrote: > > Hi Candace, > > Thank you for ur reply.. > > I agree with your point that the true data for site needs to be first > entered into the form SIT:Site. > On the People form a menu is connected to Site field which just fetch all > the Sites from the SIT:Site form. But People form it self stores Site > value with corresponding user record. Site field is required as long as > the user is Office-Based Employee. There are number of fields on People > form related to Site such as Site Country, Site City, Site Street, Site > ID, Site State Province, Site Zip/Postal Code, Timezone etc. These fields > are used to display the Site Address field which is Display-Only. > Let me check with changing Submitter. I hope this will give me a hint. > > Thanks & Regards, > Vinit > > > Decou, Candace M wrote: >> >> I believe the problem is that the true data for Site needs to be first >> entered into the form SIT:Site. On the People form, there is just a >> menu for the Site field associated with the underlying data in the Site >> form. So you must have the data in the Site form first. You will >> likely need to look at the permissions on that form and set up your push >> fields to that form before you will be able to set the correct fields on >> the People form. >> >> You will likely need to have Contact Admin permissions in order to >> perform this also and I doubt that your normal users have that >> permission set. >> >> Hope this helps. >> >> :-) >> >> Candace >> >> >> >> >> >> ____________ >> >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz >> Sent: Sunday, January 18, 2009 3:18 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Updating user profile in People form... >> >> >> >> ** >> >> Vinit >> >> have a look for this field on the User form. I believe that if you >> modify the People form, it might try to make a modification on the User >> form. If not that, then turn on your logging and have a look. It looks >> like there is a Push happening on the People form which is causing the >> error message. Let me know >> >> >> >> thanks >> >> >> >> shafqat >> >> --- On Sun, 1/18/09, LisaD wrote: >> >> From: LisaD >> Subject: Re: Updating user profile in People form... >> To: arslist@ARSLIST.ORG >> Date: Sunday, January 18, 2009, 6:56 PM >> >> In addition to giving Change permission to Public and General >> Access, do you >> also have the field flagged as "Allow any User to Submit"? >> >> If you want to send me the active link off line, I would be >> happy to take a >> look at it as well. >> >> lisa.westerfi...@maryville.com >> >> Also, Have you logged >> >> vinitPatil wrote: >> > >> > Hello All, >> > >> > I've imported almost 4000 people records from AD to CTM:People >> form. >> The >> > Site field is Null for all the records as there is no such >> field in AD. So >> > we've decided to let users update there Site, Organization and >> Department >> > values. We've more than 70 Sites, 20 Organizations and almost >> 90 >> > departments. I've already populated this data using Data >> Management >> tool. >> > >> > What I've done is; when user clicks on "Requester Console" >> link I check >> > his site. If it is null then I ask him to update the profile. >> I've a >> > display only form by which user can update his Organization, >> Department >> > and Site. >> > >> > I am using Push field action to u
Re: Updating user profile in People form...
Hi Candace, Thank you for ur reply.. I agree with your point that the true data for site needs to be first entered into the form SIT:Site. On the People form a menu is connected to Site field which just fetch all the Sites from the SIT:Site form. But People form it self stores Site value with corresponding user record. Site field is required as long as the user is Office-Based Employee. There are number of fields on People form related to Site such as Site Country, Site City, Site Street, Site ID, Site State Province, Site Zip/Postal Code, Timezone etc. These fields are used to display the Site Address field which is Display-Only. Let me check with changing Submitter. I hope this will give me a hint. Thanks & Regards, Vinit Decou, Candace M wrote: > > I believe the problem is that the true data for Site needs to be first > entered into the form SIT:Site. On the People form, there is just a > menu for the Site field associated with the underlying data in the Site > form. So you must have the data in the Site form first. You will > likely need to look at the permissions on that form and set up your push > fields to that form before you will be able to set the correct fields on > the People form. > > You will likely need to have Contact Admin permissions in order to > perform this also and I doubt that your normal users have that > permission set. > > Hope this helps. > > :-) > > Candace > > > > > > > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz > Sent: Sunday, January 18, 2009 3:18 PM > To: arslist@ARSLIST.ORG > Subject: Re: Updating user profile in People form... > > > > ** > > Vinit > > have a look for this field on the User form. I believe that if you > modify the People form, it might try to make a modification on the User > form. If not that, then turn on your logging and have a look. It looks > like there is a Push happening on the People form which is causing the > error message. Let me know > > > > thanks > > > > shafqat > > --- On Sun, 1/18/09, LisaD wrote: > > From: LisaD > Subject: Re: Updating user profile in People form... > To: arslist@ARSLIST.ORG > Date: Sunday, January 18, 2009, 6:56 PM > > In addition to giving Change permission to Public and General > Access, do you > also have the field flagged as "Allow any User to Submit"? > > If you want to send me the active link off line, I would be > happy to take a > look at it as well. > > lisa.westerfi...@maryville.com > > Also, Have you logged > > vinitPatil wrote: > > > > Hello All, > > > > I've imported almost 4000 people records from AD to CTM:People > form. > The > > Site field is Null for all the records as there is no such > field in AD. So > > we've decided to let users update there Site, Organization and > Department > > values. We've more than 70 Sites, 20 Organizations and almost > 90 > > departments. I've already populated this data using Data > Management > tool. > > > > What I've done is; when user clicks on "Requester Console" > link I check > > his site. If it is null then I ask him to update the profile. > I've a > > display only form by which user can update his Organization, > Department > > and Site. > > > > I am using Push field action to update the corresponding > record in People > > form. But when AL fires it gives a message like "ARERR [331] > You do > not > > have write access (for this entry) to field : 26001" > > > > I've given Public and General Access to this field. But still > its > giving > > me same error. > > > > Does anyone have done this before? Please help me, I don't > know where > I > > went wrong. > > > > Thanks & Regards, > > Vinit > > > > > - > Lisa D > -- > View this message in context: > > http://www.nabble.com/Updating-user-profile-in-People-form...-tp21525709 > p21531418.html > Sent from the ARS (Action Request System) mailing list archive > at Nabble.com. > > > > __
Re: Updating user profile in People form...
I believe the problem is that the true data for Site needs to be first entered into the form SIT:Site. On the People form, there is just a menu for the Site field associated with the underlying data in the Site form. So you must have the data in the Site form first. You will likely need to look at the permissions on that form and set up your push fields to that form before you will be able to set the correct fields on the People form. You will likely need to have Contact Admin permissions in order to perform this also and I doubt that your normal users have that permission set. Hope this helps. :-) Candace From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shafqat Ayaz Sent: Sunday, January 18, 2009 3:18 PM To: arslist@ARSLIST.ORG Subject: Re: Updating user profile in People form... ** Vinit have a look for this field on the User form. I believe that if you modify the People form, it might try to make a modification on the User form. If not that, then turn on your logging and have a look. It looks like there is a Push happening on the People form which is causing the error message. Let me know thanks shafqat --- On Sun, 1/18/09, LisaD wrote: From: LisaD Subject: Re: Updating user profile in People form... To: arslist@ARSLIST.ORG Date: Sunday, January 18, 2009, 6:56 PM In addition to giving Change permission to Public and General Access, do you also have the field flagged as "Allow any User to Submit"? If you want to send me the active link off line, I would be happy to take a look at it as well. lisa.westerfi...@maryville.com Also, Have you logged vinitPatil wrote: > > Hello All, > > I've imported almost 4000 people records from AD to CTM:People form. The > Site field is Null for all the records as there is no such field in AD. So > we've decided to let users update there Site, Organization and Department > values. We've more than 70 Sites, 20 Organizations and almost 90 > departments. I've already populated this data using Data Management tool. > > What I've done is; when user clicks on "Requester Console" link I check > his site. If it is null then I ask him to update the profile. I've a > display only form by which user can update his Organization, Department > and Site. > > I am using Push field action to update the corresponding record in People > form. But when AL fires it gives a message like "ARERR [331] You do not > have write access (for this entry) to field : 26001" > > I've given Public and General Access to this field. But still its giving > me same error. > > Does anyone have done this before? Please help me, I don't know where I > went wrong. > > Thanks & Regards, > Vinit > - Lisa D -- View this message in context: http://www.nabble.com/Updating-user-profile-in-People-form...-tp21525709 p21531418.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Updating user profile in People form...
Vinit have a look for this field on the User form. I believe that if you modify the People form, it might try to make a modification on the User form. If not that, then turn on your logging and have a look. It looks like there is a Push happening on the People form which is causing the error message. Let me know thanks shafqat --- On Sun, 1/18/09, LisaD wrote: From: LisaD Subject: Re: Updating user profile in People form... To: arslist@ARSLIST.ORG Date: Sunday, January 18, 2009, 6:56 PM In addition to giving Change permission to Public and General Access, do you also have the field flagged as "Allow any User to Submit"? If you want to send me the active link off line, I would be happy to take a look at it as well. lisa.westerfi...@maryville.com Also, Have you logged vinitPatil wrote: > > Hello All, > > I've imported almost 4000 people records from AD to CTM:People form. The > Site field is Null for all the records as there is no such field in AD. So > we've decided to let users update there Site, Organization and Department > values. We've more than 70 Sites, 20 Organizations and almost 90 > departments. I've already populated this data using Data Management tool. > > What I've done is; when user clicks on "Requester Console" link I check > his site. If it is null then I ask him to update the profile. I've a > display only form by which user can update his Organization, Department > and Site. > > I am using Push field action to update the corresponding record in People > form. But when AL fires it gives a message like "ARERR [331] You do not > have write access (for this entry) to field : 26001" > > I've given Public and General Access to this field. But still its giving > me same error. > > Does anyone have done this before? Please help me, I don't know where I > went wrong. > > Thanks & Regards, > Vinit > - Lisa D -- View this message in context: http://www.nabble.com/Updating-user-profile-in-People-form...-tp21525709p21531418.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Updating user profile in People form...
In addition to giving Change permission to Public and General Access, do you also have the field flagged as "Allow any User to Submit"? If you want to send me the active link off line, I would be happy to take a look at it as well. lisa.westerfi...@maryville.com Also, Have you logged vinitPatil wrote: > > Hello All, > > I've imported almost 4000 people records from AD to CTM:People form. The > Site field is Null for all the records as there is no such field in AD. So > we've decided to let users update there Site, Organization and Department > values. We've more than 70 Sites, 20 Organizations and almost 90 > departments. I've already populated this data using Data Management tool. > > What I've done is; when user clicks on "Requester Console" link I check > his site. If it is null then I ask him to update the profile. I've a > display only form by which user can update his Organization, Department > and Site. > > I am using Push field action to update the corresponding record in People > form. But when AL fires it gives a message like "ARERR [331] You do not > have write access (for this entry) to field : 26001" > > I've given Public and General Access to this field. But still its giving > me same error. > > Does anyone have done this before? Please help me, I don't know where I > went wrong. > > Thanks & Regards, > Vinit > - Lisa D -- View this message in context: http://www.nabble.com/Updating-user-profile-in-People-form...-tp21525709p21531418.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"