RE: Changing a Remedy Login ID In Bulk
I just realised I was responding to an email from May 2015. A bit of a delayed response I’m afraid. I was in an archive data file and it was the top message. I’ll blame age. Cheers Ben From: Ben Chernys Sent: December-18-18 8:21 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Changing a Remedy Login ID In Bulk We wrote a Meta-Update script called Databot <http://www.softwaretoolhouse.com/> which works exactly like the BMC Data Wizard (by default). It will read a spreadsheet of changes in login id (amongst all the other possibilities) and effect the changes across all forms (according to the config). It works by SQL but can be configured to use the Merge API on an individual form basis when needed for workflow and integrations. Adding your own forms is as easy as adding a line to a spreadsheet. It is extensible – that is, you can configure your own “Data Admin” jobs and sports an “Undo” feature. It is free with Meta-Update and is included in free Meta-Update trials. Cheers, Ben Chernys Senior Software Architect Canada / Deutschland Mobile:+49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Email:<mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. <http://www.softwaretoolhouse.com/product/SthMupd/index.html> Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/product/SthArch/index.html> Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions. Archive output to different servers, HTML pages with links to attachments or archive forms. <http://www.softwaretoolhouse.com/product/Databot/index.html> Meta-Databot is an automated, extensible BMC Data Wizard. It reads a file of data changes and sports an Undo feature. Pre ITSM 18.08? Clarify? HP? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) mailto:arslist@ARSLIST.ORG> > On Behalf Of Timothy Powell Sent: May-14-15 9:56 AM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Re: Changing a Remedy Login ID In Bulk ** I can’t speak to ITSM 8.1 because we have not yet upgraded to it, but in ITSM 7.6.04, you can do this using the Out-of-Box Data Wizard. In 7.6.04 this is located at: Application Administration Console/Custom Configuration (tab)/Foundation/Data Management Tool/Data Wizard Console HTH, Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: Thursday, May 14, 2015 11:23 AM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change "jdowe" to "jdowe1", is it possible to do this through export & re-import. _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com <http://www.avg.com> Version: 2015.0.5863 / Virus Database: 4342/9775 - Release Date: 05/14/15 _ARSlist: "Where the Answers Are" and have been for 20 years_ -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Changing a Remedy Login ID In Bulk
We wrote a Meta-Update script called Databot <http://www.softwaretoolhouse.com/> which works exactly like the BMC Data Wizard (by default). It will read a spreadsheet of changes in login id (amongst all the other possibilities) and effect the changes across all forms (according to the config). It works by SQL but can be configured to use the Merge API on an individual form basis when needed for workflow and integrations. Adding your own forms is as easy as adding a line to a spreadsheet. It is extensible – that is, you can configure your own “Data Admin” jobs and sports an “Undo” feature. It is free with Meta-Update and is included in free Meta-Update trials. Cheers, Ben Chernys Senior Software Architect Canada / Deutschland Mobile:+49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Email:<mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. <http://www.softwaretoolhouse.com/product/SthMupd/index.html> Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/product/SthArch/index.html> Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions. Archive output to different servers, HTML pages with links to attachments or archive forms. <http://www.softwaretoolhouse.com/product/Databot/index.html> Meta-Databot is an automated, extensible BMC Data Wizard. It reads a file of data changes and sports an Undo feature. Pre ITSM 18.08? Clarify? HP? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) On Behalf Of Timothy Powell Sent: May-14-15 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Changing a Remedy Login ID In Bulk ** I can’t speak to ITSM 8.1 because we have not yet upgraded to it, but in ITSM 7.6.04, you can do this using the Out-of-Box Data Wizard. In 7.6.04 this is located at: Application Administration Console/Custom Configuration (tab)/Foundation/Data Management Tool/Data Wizard Console HTH, Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: Thursday, May 14, 2015 11:23 AM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change "jdowe" to "jdowe1", is it possible to do this through export & re-import. _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com <http://www.avg.com> Version: 2015.0.5863 / Virus Database: 4342/9775 - Release Date: 05/14/15 _ARSlist: "Where the Answers Are" and have been for 20 years_ -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
AD: Changing a Remedy Login ID In Bulk
We have a script that does this through the API and changes all forms’ data (status history, assignments, etc). Input is a set of new and old logins. It runs off a configuration spreadsheet and so bespoke forms and fields can be added to the easily. The script generates a CSV of all forms and fields changed. It is not a free product though the script is available for free. Cheers Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: May-14-15 09:23 To: arslist@ARSLIST.ORG Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. No virus found in this message. Checked by AVG - www.avg.com Version: 2015.0.5863 / Virus Database: 4342/9775 - Release Date: 05/14/15 _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 smime.p7s Description: S/MIME cryptographic signature
Re: Changing a Remedy Login ID In Bulk
I suppose, but consider things like pending approvals, which are all dependent on the login ID present when the record was created. Unless you update those records to match, they become orphans. Rick On May 14, 2015 8:24 AM, Scott Hallenger vadr...@yahoo.com wrote: ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _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: Changing a Remedy Login ID In Bulk
Scott, You may want to check out this utility https://communities.bmc.com/docs/DOC-33524 On Thu, May 14, 2015 at 9:22 AM, Scott Hallenger vadr...@yahoo.com wrote: ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _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: Changing a Remedy Login ID In Bulk
Yes...Curtis has offered that tool for Free, to the best of my knowledge... On Thu, May 14, 2015 at 9:58 AM, Scott Hallenger vadr...@yahoo.com wrote: ** LJ thank you. That tool sounds like a winner. I didn't see anything about costs though. Are you going to blow my mind and tell me its free! On Thursday, May 14, 2015 11:29 AM, LJ LongWing lj.longw...@gmail.com wrote: ** Scott, You may want to check out this utility https://communities.bmc.com/docs/DOC-33524 On Thu, May 14, 2015 at 9:22 AM, Scott Hallenger vadr...@yahoo.com wrote: ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _ARSlist: Where the Answers Are and have been for 20 years_ _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
Changing a Remedy Login ID In Bulk
Hello Lister's,I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Changing a Remedy Login ID In Bulk
I can’t speak to ITSM 8.1 because we have not yet upgraded to it, but in ITSM 7.6.04, you can do this using the Out-of-Box Data Wizard. In 7.6.04 this is located at: Application Administration Console/Custom Configuration (tab)/Foundation/Data Management Tool/Data Wizard Console HTH, Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: Thursday, May 14, 2015 11:23 AM To: arslist@ARSLIST.ORG Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _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: Changing a Remedy Login ID In Bulk
LJ thank you. That tool sounds like a winner. I didn't see anything about costs though. Are you going to blow my mind and tell me its free! On Thursday, May 14, 2015 11:29 AM, LJ LongWing lj.longw...@gmail.com wrote: **Scott,You may want to check out this utilityhttps://communities.bmc.com/docs/DOC-33524 On Thu, May 14, 2015 at 9:22 AM, Scott Hallenger vadr...@yahoo.com wrote: **Hello Lister's,I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import._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