Re: Login id change....
Hi, We have published a tool called RRR|LoginConv at https://www.rrr.se/cgi/tools/main#rrrLoginConv that should do the job for you. It will much through all records in all forms and substitute a list of login names to new ones. You can limit the program to certain fields and forms if you like. A sample config could look like this: Smith = SMITH Abc = ABC etc. It will use the Merge-operation to update only the fields where an exact match is found. It will deal with the various 6-60999-fields if you have login names there. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > We have a user who had a login ID in AD of (For example...) "Smith" . > When they logged into Remedy 7.5 > and were validated by LDAP they would do various transactions/events > using the "Smith" username. Now > the AD username has been changed to "SMITH" so they have to use this to > login to Remedy. Is there any way > of renaming the "Smith" records in the database to the new username of > "SMITH"? Any guidance or suggestions > are welcome and appreciated. > > Portions of this message may be confidential under an exemption to Ohio's > public records law or under a legal privilege. If you have received this > message in error or due to an unauthorized transmission or interception, > please delete all copies from your system without disclosing, copying, or > transmitting this message. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Login id change....
Great! Thanks! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Wednesday, August 26, 2009 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Login id change Hi, We have published a tool called RRR|LoginConv at https://www.rrr.se/cgi/tools/main#rrrLoginConv that should do the job for you. It will much through all records in all forms and substitute a list of login names to new ones. You can limit the program to certain fields and forms if you like. A sample config could look like this: Smith = SMITH Abc = ABC etc. It will use the Merge-operation to update only the fields where an exact match is found. It will deal with the various 6-60999-fields if you have login names there. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > We have a user who had a login ID in AD of (For example...) "Smith" . > When they logged into Remedy 7.5 > and were validated by LDAP they would do various transactions/events > using the "Smith" username. Now > the AD username has been changed to "SMITH" so they have to use this to > login to Remedy. Is there any way > of renaming the "Smith" records in the database to the new username of > "SMITH"? Any guidance or suggestions > are welcome and appreciated. > > Portions of this message may be confidential under an exemption to Ohio's > public records law or under a legal privilege. If you have received this > message in error or due to an unauthorized transmission or interception, > please delete all copies from your system without disclosing, copying, or > transmitting this message. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Login id change....
I use a stored procedure in the DB that looks in arschema for forms of type 'regular'and loop through those forms doing update statements where c2 or c4 = smith, set appropriately to SMITH _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of copits.rich...@bwc.state.oh.us Sent: Wednesday, August 26, 2009 12:29 PM To: arslist@ARSLIST.ORG Subject: Login id change ** We have a user who had a login ID in AD of (For example.) "Smith" . When they logged into Remedy 7.5 and were validated by LDAP they would do various transactions/events using the "Smith" username. Now the AD username has been changed to "SMITH" so they have to use this to login to Remedy. Is there any way of renaming the "Smith" records in the database to the new username of "SMITH"? Any guidance or suggestions are welcome and appreciated. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Login id change....
Hi, RRR|LoginConv works on all fields, not only 2 and 4. Any exact match will be converted. It will also convert Status-History and Diary-fields as well as any exact occurrence enclosed in single or double quotes. If you must convert a lot of user names, RRR|LoginConv will do this in one pass based on a configuration file. Best Regards - Misi, RRR AB, http://rrr.se > I use a stored procedure in the DB that looks in arschema for forms of > type > 'regular'and loop through those forms doing update statements where c2 > or c4 = smith, set appropriately to SMITH > > _ > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of copits.rich...@bwc.state.oh.us > Sent: Wednesday, August 26, 2009 12:29 PM > To: arslist@ARSLIST.ORG > Subject: Login id change > > > ** > > We have a user who had a login ID in AD of (For example.) "Smith" . When > they logged into Remedy 7.5 > > and were validated by LDAP they would do various transactions/events using > the "Smith" username. Now > > the AD username has been changed to "SMITH" so they have to use this to > login to Remedy. Is there any way > > of renaming the "Smith" records in the database to the new username of > "SMITH"? Any guidance or suggestions > > are welcome and appreciated. > > > Portions of this message may be confidential under an exemption to Ohio's > public records law or under a legal privilege. If you have received this > message in error or due to an unauthorized transmission or interception, > please delete all copies from your system without disclosing, copying, or > transmitting this message. _Platinum Sponsor: rmisoluti...@verizon.net > ARSlist: "Where the Answers Are"_ > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Login id change....
Hi, I want to make sure I'm understanding you correctly. Does your tool look for all character fields (or fields that can contain text) and search for the old login name and replace it with the new login name within the entire text? If that's the case, that sounds quite scary to me. I can image that it would be relatively easy to replace text unintentionally because someone's username happens to match something else. For example, if someone change their login from Smith to Jones (perhaps they got married), that would mean that all references to Smith in, say, Incident descriptions, summaries, etc., would need to be changed. In fact, it could be quite incorrect to change them. You would end up changing things like "Mary Smith called to report..." to "Mary Jones called to report...". Am I getting that right? Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Thursday, August 27, 2009 2:11 AM To: arslist@ARSLIST.ORG Subject: Re: Login id change Hi, RRR|LoginConv works on all fields, not only 2 and 4. Any exact match will be converted. It will also convert Status-History and Diary-fields as well as any exact occurrence enclosed in single or double quotes. If you must convert a lot of user names, RRR|LoginConv will do this in one pass based on a configuration file. Best Regards - Misi, RRR AB, http://rrr.se > I use a stored procedure in the DB that looks in arschema for forms of > type > 'regular'and loop through those forms doing update statements where c2 > or c4 = smith, set appropriately to SMITH > > _ > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of copits.rich...@bwc.state.oh.us > Sent: Wednesday, August 26, 2009 12:29 PM > To: arslist@ARSLIST.ORG > Subject: Login id change > > > ** > > We have a user who had a login ID in AD of (For example.) "Smith" . When > they logged into Remedy 7.5 > > and were validated by LDAP they would do various transactions/events using > the "Smith" username. Now > > the AD username has been changed to "SMITH" so they have to use this to > login to Remedy. Is there any way > > of renaming the "Smith" records in the database to the new username of > "SMITH"? Any guidance or suggestions > > are welcome and appreciated. > > > Portions of this message may be confidential under an exemption to Ohio's > public records law or under a legal privilege. If you have received this > message in error or due to an unauthorized transmission or interception, > please delete all copies from your system without disclosing, copying, or > transmitting this message. _Platinum Sponsor: rmisoluti...@verizon.net > ARSlist: "Where the Answers Are"_ > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Login id change....
Hi, No, it does not replace things that way. First, exact match of char-fields up to 255 will be done. You can set another max size if you like. It also converts the user-name-part of Status-History and Diary-fields. No other text in the Diary-field will be changed. Quoted replacement CAN be done. If the text is surrounded by single- or double-quotes, it will replace the text. Not changed: Mary Smith calls support... Changed: "Jones", "Smith", "Mladoniczky" This option must be used for example if you use row level access using 60xxx-fields. Separator list replacement CAN also be done, where "Mary Smith calls support" would not be changed, but "Jones, Smith, Mladoniczky" would be changed. You can of course disable both the Quoted-replacement and the Separator-list-replacement. You can also limit the replacement to specific field ids and forms. Another thing you can do with the tool is to replace things other than Login-names. For example if you want to change the content of a Category-field or something similar. Finally. If you use the login name "Smith" with a upper case "S" and lower case "mith", I guess that this could possibly change a text field by mistake. In most cases, there should be no problem. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > Hi, > > I want to make sure I'm understanding you correctly. Does your tool look > for all character fields (or fields that can contain text) and search for > the old login name and replace it with the new login name within the > entire text? > > If that's the case, that sounds quite scary to me. I can image that it > would be relatively easy to replace text unintentionally because someone's > username happens to match something else. For example, if someone change > their login from Smith to Jones (perhaps they got married), that would > mean that all references to Smith in, say, Incident descriptions, > summaries, etc., would need to be changed. In fact, it could be quite > incorrect to change them. You would end up changing things like "Mary > Smith called to report..." to "Mary Jones called to report...". > > Am I getting that right? > > Lyle > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky > Sent: Thursday, August 27, 2009 2:11 AM > To: arslist@ARSLIST.ORG > Subject: Re: Login id change > > Hi, > > RRR|LoginConv works on all fields, not only 2 and 4. > > Any exact match will be converted. > > It will also convert Status-History and Diary-fields as well as any exact > occurrence enclosed in single or double quotes. > > If you must convert a lot of user names, RRR|LoginConv will do this in one > pass based on a configuration file. > > Best Regards - Misi, RRR AB, http://rrr.se > >> I use a stored procedure in the DB that looks in arschema for forms of >> type >> 'regular'and loop through those forms doing update statements where >> c2 >> or c4 = smith, set appropriately to SMITH >> >> _ >> >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org] On Behalf Of copits.rich...@bwc.state.oh.us >> Sent: Wednesday, August 26, 2009 12:29 PM >> To: arslist@ARSLIST.ORG >> Subject: Login id change >> >> >> ** >> >> We have a user who had a login ID in AD of (For example.) "Smith" . >> When >> they logged into Remedy 7.5 >> >> and were validated by LDAP they would do various transactions/events >> using >> the "Smith" username. Now >> >> the AD username has been changed to "SMITH" so they have to use this to >> login to Remedy. Is there any way >> >> of renaming the "Smith" records in the database to the new username of >> "SMITH"? Any guidance or suggestions >> >> are welcome and appreciated. >> >> >> Portions of this message may be confidential under an exemption to >> Ohio's >> public records law or under a legal privilege. If you have received this >> message in error or due to an unauthorized transmission or interception, >> please delete all copies from your system without disclosing, copying, >> or >> transmitting this mes
Re: Login id change....
Excellent, that sounds much better than what I was thinking. :-) It sounds like you've thought it through well and have put together a nice tool. Thanks, Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Wednesday, September 02, 2009 9:45 AM To: arslist@ARSLIST.ORG Subject: Re: Login id change Hi, No, it does not replace things that way. First, exact match of char-fields up to 255 will be done. You can set another max size if you like. It also converts the user-name-part of Status-History and Diary-fields. No other text in the Diary-field will be changed. Quoted replacement CAN be done. If the text is surrounded by single- or double-quotes, it will replace the text. Not changed: Mary Smith calls support... Changed: "Jones", "Smith", "Mladoniczky" This option must be used for example if you use row level access using 60xxx-fields. Separator list replacement CAN also be done, where "Mary Smith calls support" would not be changed, but "Jones, Smith, Mladoniczky" would be changed. You can of course disable both the Quoted-replacement and the Separator-list-replacement. You can also limit the replacement to specific field ids and forms. Another thing you can do with the tool is to replace things other than Login-names. For example if you want to change the content of a Category-field or something similar. Finally. If you use the login name "Smith" with a upper case "S" and lower case "mith", I guess that this could possibly change a text field by mistake. In most cases, there should be no problem. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > Hi, > > I want to make sure I'm understanding you correctly. Does your tool look > for all character fields (or fields that can contain text) and search for > the old login name and replace it with the new login name within the > entire text? > > If that's the case, that sounds quite scary to me. I can image that it > would be relatively easy to replace text unintentionally because someone's > username happens to match something else. For example, if someone change > their login from Smith to Jones (perhaps they got married), that would > mean that all references to Smith in, say, Incident descriptions, > summaries, etc., would need to be changed. In fact, it could be quite > incorrect to change them. You would end up changing things like "Mary > Smith called to report..." to "Mary Jones called to report...". > > Am I getting that right? > > Lyle > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky > Sent: Thursday, August 27, 2009 2:11 AM > To: arslist@ARSLIST.ORG > Subject: Re: Login id change > > Hi, > > RRR|LoginConv works on all fields, not only 2 and 4. > > Any exact match will be converted. > > It will also convert Status-History and Diary-fields as well as any exact > occurrence enclosed in single or double quotes. > > If you must convert a lot of user names, RRR|LoginConv will do this in one > pass based on a configuration file. > > Best Regards - Misi, RRR AB, http://rrr.se > >> I use a stored procedure in the DB that looks in arschema for forms of >> type >> 'regular'and loop through those forms doing update statements where >> c2 >> or c4 = smith, set appropriately to SMITH >> >> _ >> >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org] On Behalf Of copits.rich...@bwc.state.oh.us >> Sent: Wednesday, August 26, 2009 12:29 PM >> To: arslist@ARSLIST.ORG >> Subject: Login id change >> >> >> ** >> >> We have a user who had a login ID in AD of (For example.) "Smith" . >> When >> they logged into Remedy 7.5 >> >> and were validated by LDAP they would do various transactions/events >> using >> the "Smith" username. Now >> >> the AD username has been changed to "SMITH" so they have to use this to >> login to Remedy. Is there any way >> >> of renaming the "Smith" records in the database to the new username of >> "SMITH"? Any gu