Update Username in a Names field that allows mutiple values
I have project tracking database that lists team members in a Names field that allows multiple values.
My question is this. When someones name changes, is there a way to have a script or agent run at night to go to the address book or library database and update the name with the new name.
Field: prjTeamMembers, Names Field allows multiple values. Uses the NAB
If I have a list of team members, Susan Smith, John Johnson, and Taylor Thomas - I am wondering if Susan Smith's name changes to Susan Anderson, is there something I can write that at night that would update her name to the correct name? Or does this have to stay as a manual process and someone has to go in and update the field.
Any help is always appreciated. Thanks!
My question is this. When someones name changes, is there a way to have a script or agent run at night to go to the address book or library database and update the name with the new name.
Field: prjTeamMembers, Names Field allows multiple values. Uses the NAB
If I have a list of team members, Susan Smith, John Johnson, and Taylor Thomas - I am wondering if Susan Smith's name changes to Susan Anderson, is there something I can write that at night that would update her name to the correct name? Or does this have to stay as a manual process and someone has to go in and update the field.
Any help is always appreciated. Thanks!
ASKER
That process is not available for me to use.
At this time, I am going to have the manually replace the name. In the meantime, I have been pointed in the direction of learning about ReplaceArray if I need to automate this process going further.
At this time, I am going to have the manually replace the name. In the meantime, I have been pointed in the direction of learning about ReplaceArray if I need to automate this process going further.
> That process is not available for me to use.
Could you please explain why not. Your reasons have to be VERY convincing, for the standard process covers almost every aspect of changing a user's name.
Could you please explain why not. Your reasons have to be VERY convincing, for the standard process covers almost every aspect of changing a user's name.
ASKER
Access to the Domino is not permitted. For me to "use" this function I would need to write a reason to the powers that be to "use it" and explain how it works. They do not allow this function on the custom databases at this time. Mostly they use it to maintain high level ACL access, group membership and mailboxes rather then custom databases in our environment.
So you are there for the Admins, and not the other way round?? Incompetent lot...
This one is free, they'd have NOTHING to do for it, it works out of the box, virtually all you have to do is specify the Administration server in the ACL. ANY normal Domino environment does this, it is standard functionality. Can you play their demand back to them? I'd ask them to justify to your manager that you have to reinvent the wheel, which might cost you a few weeks to develop and test...
This one is free, they'd have NOTHING to do for it, it works out of the box, virtually all you have to do is specify the Administration server in the ACL. ANY normal Domino environment does this, it is standard functionality. Can you play their demand back to them? I'd ask them to justify to your manager that you have to reinvent the wheel, which might cost you a few weeks to develop and test...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have no cards to play in this hand, and the company just bought sharepoint....... yes, really.
I will add the ArrayAppend and AppendToTextList to the list to research. I do updates when I have a 1:1 ratio. There is another form in the database that has employeeName, id, and supervisor and I update those overnight once a week. But that is a 1:1 and I have a key.
I am going on Maternity leave shortly and I was trying to streamline a process in a database, to update a team member name, but this is turning out to be more work that is needed for only 1 or 2 changes. It is not worth it, and I will just have to document how to have them go in and edit the document and change the name in the list. I do wish that more of the "out of box" functions were available to me to use, but alas, I am just a lowly cube dweller.
I will add the ArrayAppend and AppendToTextList to the list to research. I do updates when I have a 1:1 ratio. There is another form in the database that has employeeName, id, and supervisor and I update those overnight once a week. But that is a 1:1 and I have a key.
I am going on Maternity leave shortly and I was trying to streamline a process in a database, to update a team member name, but this is turning out to be more work that is needed for only 1 or 2 changes. It is not worth it, and I will just have to document how to have them go in and edit the document and change the name in the list. I do wish that more of the "out of box" functions were available to me to use, but alas, I am just a lowly cube dweller.
That's what I was afraid of but something stopped me from writing it down: it's exactly that attitude in Admins that makes managers move away from Domino. When (not If) they lose their jobs as Domino Admins, it's their own fault. This makes me so... aaaaargh... *steam comes out of my ears*
An even shorter way would be to write a simple Formula agent that replaces "CN=Jill Doe/O=ACME" by "Jill Whatever-Doe/O=ACME", in specific fields.
An even shorter way would be to write a simple Formula agent that replaces "CN=Jill Doe/O=ACME" by "Jill Whatever-Doe/O=ACME", in specific fields.
ASKER
I agree with you completely. I have had days where I just have to raise my hands up and say "Oh well, out of my control, I will do the best I can". I still have not been able to use xpages until I prove my test case.
I think I need to research working with multivalue fields further before I can do anything about this and for now the managers can update the names or wait until I get back :)
I think I need to research working with multivalue fields further before I can do anything about this and for now the managers can update the names or wait until I get back :)
I hope your leave shall be pleasant for you, but on the other hand "they" will get more and more aware of the "shortcomings" of Domino (caused by the Admins, as usual). Not really your problem, for the time being.
And you can quote me, of course. ;-)
And you can quote me, of course. ;-)
ASKER
Thanks for the well wishes, it will be nice to have a leave. Some are aware of the shortcoming but .... decide to go other routes.
Thanks for the help as always Sjef, I appreciate it!
Thanks for the help as always Sjef, I appreciate it!
:-)
Also in the ACL, right under where you set theAdministration server, you need to indicate that Names fields are to be updated.
Note that this can be a resource consuming activity, if the server becomes too busy, see Creating an $AdminP view to limit the number of documents cosiderd for name updates.
See also: Domino infocenter on the Administration Process