Re: ITSM Company Name Change Challenge
Hi, The version for download uses the 7.1 API. I have a more recent version that I did not get around to publish. I can give you the newer version compiled with the 7.6.04 SP2 API, and we can see if that works better. If it does, I will publish it for everyone else to download. Please contact me directly, and I will give you a link to download it. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. After playing with the RRR|LoginConvert tool for a little while, I've encountered an issue. When running it on a Windows 2008 R2 Standard server with ARS 7.6.04 SP1, it crashes on certain forms. Among the forms we've found that it crashed are AAS:Activity, AAS:CFG Rules, HPD:Help Desk and AAS:WorkInfo. It will crash consistently on these and other forms. We are running it with the -noupdate and -nodiary flags. We've tried a few different combinations of flags as well. This is a crash report: Problem signature: Problem Event Name: APPCRASH Application Name: rrrLoginConv.exe Application Version: 1.0.0.0 Application Timestamp: 4cf31f18 Fault Module Name: ntdll.dll Fault Module Version: 6.1.7600.16915 Fault Module Timestamp: 4ec49d10 Exception Code: c005 Exception Offset: 00032a10 OS Version: 6.1.7600.2.0.0.272.7 Locale ID: 1033 Additional Information 1: 0a9e Additional Information 2: 0a9e372d3b4ad19135b953a78882e789 Additional Information 3: 0a9e Additional Information 4: 0a9e372d3b4ad19135b953a78882e789 Has anybody else seen this? Any ideas on how we can work through this? This tool seems to do what we want, otherwise. Thanks, Tiffany Alexander On Tue, Aug 20, 2013 at 2:00 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, Yes, it is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main?tool=rrrLoginConv It can do a dry-run that reports fields with occurrences of a specific string. It will take some time if you do this on all forms in all fields though. You could maybe search for fields containing the string comp or something like that, and then use RRR|LoginConv to scan those fields only. You might even find some archive forms or similar that you will skip entirely. When you have found the fields you want to change, RRR|LoginConv can do a merge-update of the records that need updating leaving modify-by/modify-date unchanged, and all filter skipped. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Tiffany, You may want to contact RRR to find out if this is possible...but they have a tool named something along the line of 'Login Convert'it goes through all character fields in all forms (that you specify, I think you can have it just 'scan' and converts text string 'x' to 'y'this may be possible to use it to change your Company name in all records in all forms.one way or another, this is a huge change, and will take significant time to change all of the values...but I think this may be an option for you. On Tue, Aug 20, 2013 at 11:27 AM, Tiffany Alexander tiffanyaalexan...@gmail.com wrote: ** Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from
Re: ITSM Company Name Change Challenge
After playing with the RRR|LoginConvert tool for a little while, I've encountered an issue. When running it on a Windows 2008 R2 Standard server with ARS 7.6.04 SP1, it crashes on certain forms. Among the forms we've found that it crashed are AAS:Activity, AAS:CFG Rules, HPD:Help Desk and AAS:WorkInfo. It will crash consistently on these and other forms. We are running it with the -noupdate and -nodiary flags. We've tried a few different combinations of flags as well. This is a crash report: Problem signature: Problem Event Name: APPCRASH Application Name: rrrLoginConv.exe Application Version: 1.0.0.0 Application Timestamp: 4cf31f18 Fault Module Name: ntdll.dll Fault Module Version: 6.1.7600.16915 Fault Module Timestamp: 4ec49d10 Exception Code: c005 Exception Offset: 00032a10 OS Version: 6.1.7600.2.0.0.272.7 Locale ID: 1033 Additional Information 1: 0a9e Additional Information 2: 0a9e372d3b4ad19135b953a78882e789 Additional Information 3: 0a9e Additional Information 4: 0a9e372d3b4ad19135b953a78882e789 Has anybody else seen this? Any ideas on how we can work through this? This tool seems to do what we want, otherwise. Thanks, Tiffany Alexander On Tue, Aug 20, 2013 at 2:00 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, Yes, it is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main?tool=rrrLoginConv It can do a dry-run that reports fields with occurrences of a specific string. It will take some time if you do this on all forms in all fields though. You could maybe search for fields containing the string comp or something like that, and then use RRR|LoginConv to scan those fields only. You might even find some archive forms or similar that you will skip entirely. When you have found the fields you want to change, RRR|LoginConv can do a merge-update of the records that need updating leaving modify-by/modify-date unchanged, and all filter skipped. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Tiffany, You may want to contact RRR to find out if this is possible...but they have a tool named something along the line of 'Login Convert'it goes through all character fields in all forms (that you specify, I think you can have it just 'scan' and converts text string 'x' to 'y'this may be possible to use it to change your Company name in all records in all forms.one way or another, this is a huge change, and will take significant time to change all of the values...but I think this may be an option for you. On Tue, Aug 20, 2013 at 11:27 AM, Tiffany Alexander tiffanyaalexan...@gmail.com wrote: ** Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from auditing, and there are additional considerations for menus where another company is a valid option as well as the Operating Company, such as with Products. This looks like a bigger and bigger project the more we look at it. We have limited resources and would like to minimize the time we have to spend on this, and each option would involve significant time and testing. So, List, we turn to you for ideas. Has anyone successfully changed the company name with the data wizard? What issues did you run into with it? What options outside of this list do you see as viable? Thanks! Tiffany Alexander Remedy Admin _ARSlist: Where the Answers Are and have been for 20 years_
Re: ITSM Company Name Change Challenge
How about adding the new name as an alias to the old one? Rick On Aug 20, 2013 10:37 AM, Tiffany Alexander tiffanyaalexan...@gmail.com wrote: ** Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from auditing, and there are additional considerations for menus where another company is a valid option as well as the Operating Company, such as with Products. This looks like a bigger and bigger project the more we look at it. We have limited resources and would like to minimize the time we have to spend on this, and each option would involve significant time and testing. So, List, we turn to you for ideas. Has anyone successfully changed the company name with the data wizard? What issues did you run into with it? What options outside of this list do you see as viable? Thanks! Tiffany Alexander Remedy Admin _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
ITSM Company Name Change Challenge
Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from auditing, and there are additional considerations for menus where another company is a valid option as well as the Operating Company, such as with Products. This looks like a bigger and bigger project the more we look at it. We have limited resources and would like to minimize the time we have to spend on this, and each option would involve significant time and testing. So, List, we turn to you for ideas. Has anyone successfully changed the company name with the data wizard? What issues did you run into with it? What options outside of this list do you see as viable? Thanks! Tiffany Alexander Remedy Admin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM Company Name Change Challenge
Tiffany, You may want to contact RRR to find out if this is possible...but they have a tool named something along the line of 'Login Convert'it goes through all character fields in all forms (that you specify, I think you can have it just 'scan' and converts text string 'x' to 'y'this may be possible to use it to change your Company name in all records in all forms.one way or another, this is a huge change, and will take significant time to change all of the values...but I think this may be an option for you. On Tue, Aug 20, 2013 at 11:27 AM, Tiffany Alexander tiffanyaalexan...@gmail.com wrote: ** Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from auditing, and there are additional considerations for menus where another company is a valid option as well as the Operating Company, such as with Products. This looks like a bigger and bigger project the more we look at it. We have limited resources and would like to minimize the time we have to spend on this, and each option would involve significant time and testing. So, List, we turn to you for ideas. Has anyone successfully changed the company name with the data wizard? What issues did you run into with it? What options outside of this list do you see as viable? Thanks! Tiffany Alexander Remedy Admin _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM Company Name Change Challenge
Hi, Yes, it is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main?tool=rrrLoginConv It can do a dry-run that reports fields with occurrences of a specific string. It will take some time if you do this on all forms in all fields though. You could maybe search for fields containing the string comp or something like that, and then use RRR|LoginConv to scan those fields only. You might even find some archive forms or similar that you will skip entirely. When you have found the fields you want to change, RRR|LoginConv can do a merge-update of the records that need updating leaving modify-by/modify-date unchanged, and all filter skipped. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Tiffany, You may want to contact RRR to find out if this is possible...but they have a tool named something along the line of 'Login Convert'it goes through all character fields in all forms (that you specify, I think you can have it just 'scan' and converts text string 'x' to 'y'this may be possible to use it to change your Company name in all records in all forms.one way or another, this is a huge change, and will take significant time to change all of the values...but I think this may be an option for you. On Tue, Aug 20, 2013 at 11:27 AM, Tiffany Alexander tiffanyaalexan...@gmail.com wrote: ** Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from auditing, and there are additional considerations for menus where another company is a valid option as well as the Operating Company, such as with Products. This looks like a bigger and bigger project the more we look at it. We have limited resources and would like to minimize the time we have to spend on this, and each option would involve significant time and testing. So, List, we turn to you for ideas. Has anyone successfully changed the company name with the data wizard? What issues did you run into with it? What options outside of this list do you see as viable? Thanks! Tiffany Alexander Remedy Admin _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM Company Name Change Challenge
Thank you, LJ and Misi! This looks like just what we need! On Tue, Aug 20, 2013 at 2:00 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, Yes, it is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main?tool=rrrLoginConv It can do a dry-run that reports fields with occurrences of a specific string. It will take some time if you do this on all forms in all fields though. You could maybe search for fields containing the string comp or something like that, and then use RRR|LoginConv to scan those fields only. You might even find some archive forms or similar that you will skip entirely. When you have found the fields you want to change, RRR|LoginConv can do a merge-update of the records that need updating leaving modify-by/modify-date unchanged, and all filter skipped. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Tiffany, You may want to contact RRR to find out if this is possible...but they have a tool named something along the line of 'Login Convert'it goes through all character fields in all forms (that you specify, I think you can have it just 'scan' and converts text string 'x' to 'y'this may be possible to use it to change your Company name in all records in all forms.one way or another, this is a huge change, and will take significant time to change all of the values...but I think this may be an option for you. On Tue, Aug 20, 2013 at 11:27 AM, Tiffany Alexander tiffanyaalexan...@gmail.com wrote: ** Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from auditing, and there are additional considerations for menus where another company is a valid option as well as the Operating Company, such as with Products. This looks like a bigger and bigger project the more we look at it. We have limited resources and would like to minimize the time we have to spend on this, and each option would involve significant time and testing. So, List, we turn to you for ideas. Has anyone successfully changed the company name with the data wizard? What issues did you run into with it? What options outside of this list do you see as viable? Thanks! Tiffany Alexander Remedy Admin _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM Company Name Change Challenge
I once did something similar with the older version of ITSM (when it was Viadyne owned) using a stored procedure, but if there is a tool out there (RRR) might as well use it instead of reinventing the wheel. The script took me over a good couple of days to write as it took me quite long to take an inventory of all the forms that have fields that have Company Name or the ID in them, and then write the SQL stored procedure to replace the name. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Tuesday, August 20, 2013 1:47 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM Company Name Change Challenge ** Tiffany, You may want to contact RRR to find out if this is possible...but they have a tool named something along the line of 'Login Convert'it goes through all character fields in all forms (that you specify, I think you can have it just 'scan' and converts text string 'x' to 'y'this may be possible to use it to change your Company name in all records in all forms.one way or another, this is a huge change, and will take significant time to change all of the values...but I think this may be an option for you. On Tue, Aug 20, 2013 at 11:27 AM, Tiffany Alexander tiffanyaalexan...@gmail.com wrote: ** Hello List! I've encountered an interesting challenge. The name of my company has changed. It is not optional that we change or remove all visible references to the old company name. This includes the company for all support groups, the company for all assets, the company for all products, the company for all people, etc. Our company name is the Operating Company in ITSM and most of our data is associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 (either SP1 or SP2 depending on the module). Since the Operating Company is so pervasive, this is something we want to approach carefully. We researched the Data Wizard and we've tried it in a test environment. The Data Wizard appears not to change all records (only enabled records in some cases). It does not touch all ITSM or SRM forms. It does not update SLM. We have also had issues with the Data Wizard hanging during simple updates in the past, so we are tentative about this as an option. The other thing we have considered is hiding/defaulting the Company name where possible rather than changing the Operating Company value. This would involve changing a large number of forms, modifying tiered menus containing Company, removing Company fields from auditing, and there are additional considerations for menus where another company is a valid option as well as the Operating Company, such as with Products. This looks like a bigger and bigger project the more we look at it. We have limited resources and would like to minimize the time we have to spend on this, and each option would involve significant time and testing. So, List, we turn to you for ideas. Has anyone successfully changed the company name with the data wizard? What issues did you run into with it? What options outside of this list do you see as viable? Thanks! Tiffany Alexander Remedy Admin _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
