Re: CM - Demo Installation possible ?
** Robert,I guess you are referring to Change Management v7, because you're talking about CMDB2. You can of course only buy the Change Management module and install it (of course on a licensed Remedy server) without the need for installing Incident or Problem management. I guess this will cause the CMDB to also be installed (no license cost attached), and also the Approval Server. Because it is version 7 you now should have licenses in place BEFORE you can install any of the ITSM applications. You should talk to your sales rep if you would like to get some demo licenses.--Michiel On 10/2/06, Kern, Robert SBA <[EMAIL PROTECTED]> wrote: ** Hello list, just a general query ... as of now we don't have any of the modules running. Was just wondering if it is possible to buy and run the Change Management only (it's packed with CMDB2.0, right ?) and if something like a "demo installation" of CM alone is something that may technically be possible. Before bugging sales, just want to bug the experts first :-) Thanks, Robert __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
REMOVE ME FROM the LIST
** Thanks & Regards __20060125___This posting was submitted with HTML in it___
Re: Question about search result
Frank, What do you mean by "9/20/2006 12:00:00 AM"+(60*60*1)"? Wouldn't that be "9/20/2006 1:00:00 AM?" Dwayne Martin James Madison University Original message >Date: Fri, 29 Sep 2006 10:38:42 -0400 >From: Frank Caruso <[EMAIL PROTECTED]> >Subject: Re: Question about search result >To: arslist@ARSLIST.ORG > > ** Because you are saying less than or equal to > "9/20/2006 12:00:00 AM". You need to change query to > something like <"9/21/2006" or "9/20/2006 12:00:00 > AM"+(60*60*1) > > On 9/29/06, Addis Solomon <[EMAIL PROTECTED]> > wrote: > > ** > When I define an advance search saying > 'Create date' >= "09/10/06" and 'Create date' > <= "09/20/06", The result is not including the > the 20th date. In other words the result is only > for < 20 but not including the 20th date. Does > anybody know why it is doing this? > > I greatly appreciate your help. > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > __20060125___This posting was > submitted with HTML in it___ > > -- > Frank Caruso > Specific Integration, Inc. > Senior Remedy Engineer > www.specificintegration.com > 703-376-1249 __20060125___This > posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Question about search result
** Woops .. was trying to make the math clear but forgot a number should be (60*60*24*1) 60 seconds * 60 minutes * 24 hours * 1 = 1 day in secondsOn 10/2/06, Dwayne Martin <[EMAIL PROTECTED]> wrote: Frank,What do you mean by "9/20/2006 12:00:00 AM"+(60*60*1)"?Wouldn't that be "9/20/2006 1:00:00 AM?"Dwayne MartinJames Madison University Original message >Date: Fri, 29 Sep 2006 10:38:42 -0400>From: Frank Caruso <[EMAIL PROTECTED]>>Subject: Re: Question about search result>To: arslist@ARSLIST.ORG>> ** Because you are saying less than or equal to> "9/20/2006 12:00:00 AM". You need to change query to> something like <"9/21/2006" or "9/20/2006 12:00:00 > AM"+(60*60*1)>> On 9/29/06, Addis Solomon <[EMAIL PROTECTED]>> wrote:>> **> When I define an advance search saying > 'Create date' >= "09/10/06" and 'Create date'> <= "09/20/06", The result is not including the> the 20th date. In other words the result is only> for < 20 but not including the 20th date. Does > anybody know why it is doing this?>> I greatly appreciate your help.>>> __> Do You Yahoo!?> Tired of spam? Yahoo! Mail has the best spam > protection around> http://mail.yahoo.com> __20060125___This posting was> submitted with HTML in it___>> -- > Frank Caruso> Specific Integration, Inc.> Senior Remedy Engineer> www.specificintegration.com> 703-376-1249 __20060125___This > posting was submitted with HTML in it___Dwayne MartinComputing SupportJames Madison University___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: CM - Demo Installation possible ?
** Hello Michiel, good to know that there are demo licenses available. Looking forward to witness what "monster installation" this is going to be then (never dealt with any of the modules). Thanks again, Robert From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel BeijenSent: Monday, October 02, 2006 9:54 AMTo: arslist@ARSLIST.ORGSubject: Re: CM - Demo Installation possible ? ** Robert,I guess you are referring to Change Management v7, because you're talking about CMDB2. You can of course only buy the Change Management module and install it (of course on a licensed Remedy server) without the need for installing Incident or Problem management. I guess this will cause the CMDB to also be installed (no license cost attached), and also the Approval Server. Because it is version 7 you now should have licenses in place BEFORE you can install any of the ITSM applications. You should talk to your sales rep if you would like to get some demo licenses.--Michiel On 10/2/06, Kern, Robert SBA <[EMAIL PROTECTED]> wrote: ** Hello list, just a general query ... as of now we don't have any of the modules running. Was just wondering if it is possible to buy and run the Change Management only (it's packed with CMDB2.0, right ?) and if something like a "demo installation" of CM alone is something that may technically be possible. Before bugging sales, just want to bug the experts first :-) Thanks, Robert __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
UK Remedy User Group Conference - 12th October 2006 London
The next UK RUG is on the 12th of October in London. Venue: One Great George Street, Westminster, London, SW1P 3AA 9 am - 6 pm The event is FREE, but please complete the registration at http://www.ukrug.org/ * Separate Business and Technical Tracks. * Invited speakers from BMC, including Doug Mueller. * All day Partner Fair including technology, consulting and reseller partners offering solutions and services to enhance your investment. * Sponsored drinks reception. * A stone's throw from Parliament in the heart of Westminster. * Free registration thanks to the sponsorship of the Partner Fair exhibitors. For more information and to register for the event visit: http://www.ukrug.org/ We look forward to seeing you at the event! Jim Halliday, Dave Saville & Peter Tyrrell UKRUG Committee Partner Fair: BMC http://www.bmc.com/products/products_services_detail/0,,0_0_0_801,00.html Abydos http://www.abydos-workflow.com AlarmPoint Systems http://www.alarmpoint.com Dexterra http://www.dexterra.com Fusion http://www.fusion.co.uk Indus http://www.indus.com Kineticdata http://www.kineticdata.com newScale http://www.newscale.com Panacea Workflow Systems http://www.pws-europe.com Scapa Technologies http://www.scapatech.com Tertio-SMS http://www.tertio-sms.com TuringSMI -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
New Atlanta Servlet Engine No Longer Included with 7.0.01
There is a new Statement of Direction document available on the supportweb under "ARS System -> 7.00.01" documentation. BMC is switching to Apache Foundation Tomcat in the 7.0.01 maintenance release. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: New Atlanta Servlet Engine No Longer Included with 7.0.01
** Well... I guess they've made up my mind about which direction to go in. Hrm. I'm just glad it's an opensource direction, and not something like requiring BEA. Down with ServletExec! :-) -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 "Heider, Stephen" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 10/02/2006 08:25 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject New Atlanta Servlet Engine No Longer Included with 7.0.01 There is a new Statement of Direction document available on the supportweb under "ARS System -> 7.00.01" documentation. BMC is switching to Apache Foundation Tomcat in the 7.0.01 maintenance release. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls?
According to our support vendor the color of the new Vertical and Horizontal Navigation controls in 7.0.00 can not be changed, both in Windows and Mid Tier. Does anyone know if the upcoming 7.0.01 maintenance release will allow the developer to change the colors of these controls? The blue color looks great but does not fit our color theme. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls?
You can change the colours, however you need to do it through the .css files, either on the mid-tier or for user tool in the user tool install directory and the admin tool install directory. I have managed to successfully change them with no issues via this method. On 02/10/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: According to our support vendor the color of the new Vertical and Horizontal Navigation controls in 7.0.00 can not be changed, both in Windows and Mid Tier. Does anyone know if the upcoming 7.0.01 maintenance release will allow the developer to change the colors of these controls? The blue color looks great but does not fit our color theme. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ITSM 7.0 Integrations White Paper
** All - There's a good new document (90 pages) on supportweb (Documentation/Service Desk: Incident Management/Problem Management) documenting various ways of integrating external systems into the new ITSM suite. "This paper is for people who administer any of the BMC Remedy IT ServiceManagement 7.0 (BMC Remedy ITSM 7.0) applications or modules and who want to use the associated application interface forms to enable externa lapplications, such as web services, to create, modify, and search for tickets within the BMC Remedy ITSM 7.0 applications. This paper focuses particularly on web services. For information about other integration types, see the BMC® Remedy® Action Request System® (AR System®) guide, AR System 7.0- Integrating with Plug-ins and Third-Party Products. To take full advantage of the information presented in this paper, you need a working knowledge of the AR System and the BMC Remedy ITSM 7.0 applications’ common foundation. The applications covered by this paper include: .. BMC Remedy Service Desk: Incident Management 7.0 (Incident Management). .. BMC Remedy Service Desk: Problem Management 7.0 (Problem Management). .. BMC Remedy Change Management 7.0 (Change Management). .. BMC Remedy Asset Management 7.0 (Asset Management). A section that discusses integration with the BMC Remedy Task Management (Task Management) module is included, also. The information contained in this paper includes: .. Descriptions of the interface form’s inputs and outputs. .. Descriptions of the web services inputs and outputs, (which provide a real, working example of how to use the interface forms)." -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 __20060125___This posting was submitted with HTML in it___
Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls?
Hi Stephen, I heard about a local .css file that can be edited to change the colours of the navigation bars. But I dont know and didn't check out which file it is. greets Mario "Heider, Stephen" <[EMAIL PROTECTED] > To Sent by: "Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject <[EMAIL PROTECTED] ARS 7.0.01 - Change Color of ORG> Vertical/Horizontal Navigation Controls? 02.10.2006 15:59 Please respond to [EMAIL PROTECTED] RG According to our support vendor the color of the new Vertical and Horizontal Navigation controls in 7.0.00 can not be changed, both in Windows and Mid Tier. Does anyone know if the upcoming 7.0.01 maintenance release will allow the developer to change the colors of these controls? The blue color looks great but does not fit our color theme. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Receiving error when attempting to remove field on View Form
Title: Receiving error when attempting to remove field on View Form ** I have been working with a DBA who setup a table on the AR System database. I noted that one field on the table needed to be removed but since the DBA had removed the column from the oracle table, I keep getting the errors from the view when I try to remove the field from the view itself: Failure during SQL operation to the database : ORA-00904: "EMP_NUM": invalid identifier (ARERR 552). I basically cannot save the form by removing this field and every time I try to add another field I get the same error. It seems that the view form is now corrupt. I have also tried to export the form into a .def file and edited the def file and moved the num-fields down one and removed the part of the file that references the field but I still get the same error that is above. I rather not delete the form and all workflow because of this. Does anyone know of a way out of this? I also removed any references to the field and even tried to change the field name used in the view for the field to another field but I still get the same result. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 __20060125___This posting was submitted with HTML in it___
Re: Server - DB question
Axton, Any issues or did it perform just as it does on SUN servers? Thanks, Dave >Date:Sun, 1 Oct 2006 10:26:03 -0400 >From:Axton Grams <[EMAIL PROTECTED]> >Subject: Re: Server - DB question > >I have in the past. > >Axton Grams > >Shellman, David wrote: >> It seems that the Microsoft App Server to Microsoft SQL Server or SUN >> App Server to Oracle (on SUN Servers) are popular combinations. Any one >> using Microsoft App Server to Oracle on Microsoft servers? >> >> Thanks, >> Dave >> >> Dave Shellman Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls?
Stephen, I found the values to change, thanks. With almost every other UI object in ARS the developer can set the color in the Admin Tool. With these new objects it seems that every computer that runs the WUT will need to copy this file into the folder where aruser.exe resides. Is there any way to update the colors of these objects one time in the css file in the folder where aradmin.exe resides and have all WUT clients see the new color without manually updating each computer? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Earl Sent: Monday, October 02, 2006 10:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls? You can change the colours, however you need to do it through the .css files, either on the mid-tier or for user tool in the user tool install directory and the admin tool install directory. I have managed to successfully change them with no issues via this method. On 02/10/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: > According to our support vendor the color of the new Vertical and > Horizontal Navigation controls in 7.0.00 can not be changed, both in > Windows and Mid Tier. > > Does anyone know if the upcoming 7.0.01 maintenance release will allow > the developer to change the colors of these controls? > > The blue color looks great but does not fit our color theme. > > > Stephen > > __ > _ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Job Listing - The Woodlands, Texas
** Remedy Development Position in The Woodlands, Texas Software Develop Analyst II Provide software solutions that meet current requirements with the flexibility to adhere to future requirements and enhancements. Plan, coordinate and manage team projects. To design, develop, implement, enhance and maintain automated information processing systems within a team oriented organization. Uphold the quality and integrity of all automated application systems so as to ensure all assigned tasks conform with and follow a pre-defined strategic direction. Analysts dissect, separate, and examine the relationships of information through close investigation. Employees typically examine one or more phases of a particular company issue or opportunity in order to discover the nature, extent, and causes. Data/Information is interpreted, translated, reported and meaningful conclusions are drawn. Recommendations made typically affect work results of a department/organization to a noticeable degree. This position does not have supervisory responsibilities. 3 year system design, 7 years programming and 5 years analysis. Telecom experience preferred. Bachelor's degree in computer science or 12 years experience. This position is accountable for custom development, administration and integration of Remedy Action Request System. Responsibilities include working independently or within a team to gather customer requirements, prepare analysis documentation, application development, end user support and system maintenance. This position responds to user requests for reporting or enhancements to system capabilities. Current working knowledge of SQL databases, software design, and system administration is required. Previous experience in a technical support environment would be preferred. Technical proficiency in relevant operating systems, applications and programming languages is required: Remedy Action Request System 5.1 & 6.3, Remedy Mid-Tier, Microsoft Windows Server, UNIX, MS SQL Server 2000/2005, Development, Administration, Web-based application development with .NET, VB .NET, C# .NET, Web services, Data access. Additional programming experience or certification desired but not required: Java, Remedy Approved Consultant (RAC), Remedy Skilled Professional (RSP) certification, Advanced Remedy training classes. Please send resumes to [EMAIL PROTECTED]. Eric W. Dunn Programmer Analyst III - Remedy/Collaboration McLeod USA, Inc. - Network Engineering 8665 New Trails Dr. The Woodlands, TX 77381 (281)465-1265 (281)465-1951 fax NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. __20060125___This posting was submitted with HTML in it___
Re: Server - DB question
Performs the same. Just the usual headaches of working with a M$ server. Axton Grams On 10/2/06, Shellman, David <[EMAIL PROTECTED]> wrote: Axton, Any issues or did it perform just as it does on SUN servers? Thanks, Dave >Date:Sun, 1 Oct 2006 10:26:03 -0400 >From:Axton Grams <[EMAIL PROTECTED]> >Subject: Re: Server - DB question > >I have in the past. > >Axton Grams > >Shellman, David wrote: >> It seems that the Microsoft App Server to Microsoft SQL Server or SUN >> App Server to Oracle (on SUN Servers) are popular combinations. Any one >> using Microsoft App Server to Oracle on Microsoft servers? >> >> Thanks, >> Dave >> >> Dave Shellman Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Receiving error when attempting to remove field on View Form
It looks like the column was dropped frmo the table/view the view form points to. Add the column back to the view/table, then delete the field from the view form. Alternatively, you can export your workflow against this form, delete the form, recreate it with your modified def, then reimport the workflow. Axton Grams On 10/2/06, Lammey, Peter A. <[EMAIL PROTECTED]> wrote: ** I have been working with a DBA who setup a table on the AR System database. I noted that one field on the table needed to be removed but since the DBA had removed the column from the oracle table, I keep getting the errors from the view when I try to remove the field from the view itself: Failure during SQL operation to the database : ORA-00904: "EMP_NUM": invalid identifier (ARERR 552). I basically cannot save the form by removing this field and every time I try to add another field I get the same error. It seems that the view form is now corrupt. I have also tried to export the form into a .def file and edited the def file and moved the num-fields down one and removed the part of the file that references the field but I still get the same error that is above. I rather not delete the form and all workflow because of this. Does anyone know of a way out of this? I also removed any references to the field and even tried to change the field name used in the view for the field to another field but I still get the same result. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Out Of the Box Helpdesk Escalations
** Heather, I don't think this what is causing the cases in the "Pending" status not to escalate, but there is one other filter I noticed (in HD 5.5) that you will need to update to check for the "Resolved" status instead of "Work in Progress" in the Run-If statement: HPD:HPD-ChangeSetAssigneeMngr This filter modifies the recipient of the escalation with the new manager's name if the case assignment changes. --Thomas - Original Message - From: Heather Megyesi Newsgroups: gmane.comp.crm.arsystem.general Sent: Friday, September 29, 2006 15:26 Subject: Out Of the Box Helpdesk Escalations I am trying to edit the out of the box helpdesk escalations to trigger if acall is not resolved rather than if a call is in work in progress. I have edited the following filters that looked at work in progress so thatthey now look at resolved.*HPD:HPD-CreateEscalation*HPD:HPD-DelEscalation01*HPD:HPD-DelEscalation02a*HPD:HPD-ChangePriorityOnEscalationSo, now if a call is in work in progress it does escalate. The PROBLEM I amhaving, no matter what I do, I can't get a ticket that is in a Pendingstatus to escalate. I can't find where it is skipping those calls in a pending status.Anyone know?ThanksHeather __20060125___This posting was submitted with HTML in it___
Re: Remedy V7 - Character Sets
Barb, We are in the process of investigating the same options. We had a conference call Friday with our BMC/Remedy Sales rep and other backline folks. Below is my interpretation of the call. The phrasing may not be exactly correct but the overall process/issues descriptions are pretty close. Version 7.x supports uni-code at the database and server level. The installation of additional language sets is required for the application server if it's a SUN server. My understanding is that the Windows OS supports uni-code so additional language sets are not required for the application server. If the server is connecting to an Oracle instance, then the database needs to be setup with utf-8. Also the oracle client needs to be configured so that the conversation between the app server and the database ore the same. The real issue becomes the clients. The desktop clients do not support uni-code. It seems that there is a potential for corruption if a record created with one language and it is modified with a client using a different language. Some of this could simply be what looks like corruption as an individual with a desktop client viewing a record in another language may see odd characters because the client will not display the language correctly because of the desktop client. This is not an issue if viewed with Mid-tier which does support uni-code. It maybe possible to add workflow to minimize risks of corruption with desktop client. We're still thinking about ramifications of only using Mid-tier or adding workflow that incorporates Locale and Client-Type keyword. I also found a white paper on the Support web site called BMC(r) Remedy(r) Action Request System(r) 7.0 and Unicode that was published in July. I found the white paper shortly before our conference call and have not had a chance to read it yet. My suggestion is to work with your sales rep to get a better understanding of the potential issues early in the process. Dave >Date:Thu, 28 Sep 2006 13:42:14 -0500 >From:Barb Wagner <[EMAIL PROTECTED]> >Subject: Remedy V7 - Character Sets > >Hi All > >Does anyone know - with Remedy V7 - if I need to have multiple character >sets available (IE L1 - Latin 1 and TC - Traditional Chinese) besides >having a unicode database installed and the appropriate character sets >available would I need to run more than one Instance of the ARS >Server? Or as long as the character sets are available ... ARS will make >the currect decision on what to use > >Example: We need to have English, French, German and Traditional Chinese >available ... the first 3 would be supported in L1, but we are going to >need TC to support the Traditional Chinese > >Anyone had any experience with this? > >Thank you for any info you may have > >Barb Wagner Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Receiving error when attempting to remove field on View Form
I was thinking of doing that Axton but if it doesn't work then the repercussions are that I have start from square one since all the workflow would be corrupt right? Has anyone actually tried this? If so that would raise my confidence and I guess I could try to purge the view form and reimport it via an altered def file... Im waiting for Remedy BMC to get back to me on this to see if they can provide any advice on this. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Monday, October 02, 2006 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Receiving error when attempting to remove field on View Form It looks like the column was dropped frmo the table/view the view form points to. Add the column back to the view/table, then delete the field from the view form. Alternatively, you can export your workflow against this form, delete the form, recreate it with your modified def, then reimport the workflow. Axton Grams On 10/2/06, Lammey, Peter A. <[EMAIL PROTECTED]> wrote: > ** > > > I have been working with a DBA who setup a table on the AR System database. > I noted that one field on the table needed to be removed but since the > DBA had removed the column from the oracle table, I keep getting the > errors from the view when I try to remove the field from the view itself: > > Failure during SQL operation to the database : ORA-00904: "EMP_NUM": > invalid identifier (ARERR 552). > > I basically cannot save the form by removing this field and every time > I try to add another field I get the same error. > It seems that the view form is now corrupt. > > I have also tried to export the form into a .def file and edited the > def file and moved the num-fields down one and removed the part of the > file that references the field but I still get the same error that is above. > > I rather not delete the form and all workflow because of this. > > Does anyone know of a way out of this? > I also removed any references to the field and even tried to change > the field name used in the view for the field to another field but I > still get the same result. > > Thanks > Peter Lammey > ESPN MIT Technical Services & Applications Management > 860-766-4761 __20060125___This posting was > submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: HBR is back and a question on ServiceDesk 7. (U)
** UNCLASSIFIED Howard I was unaware you were no longer with Remedy. Thanks for your excellent help in the past and I wish all the best with CedarCrestone!! Pete From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richter, HowardSent: Friday, September 29, 2006 1:40 PMTo: arslist@ARSLIST.ORGSubject: HBR is back and a question on ServiceDesk 7. ** First I am back. Now for my question, does anyone have flowcharts for ServiceDesk 7.0 primarily the Problem management piece, that they can share? I am looking at using the tasking function that is missing (and will be back in 7.0.l) to handle change request. Thanks, hbr Howard Richter Remedy Manager [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Receiving error when attempting to remove field on View Form
The only way you will have to start from scratch is if you recreate the view form with different fieldids. If you delete the view form, all workflow directly related to that view form will also be deleted. All remote workflow that references that view form will be broken until a form of the same name is recreated. If the fields ids persist, then remote workflow will continue to reference the view form properly. Axton Grams On 10/2/06, Lammey, Peter A. <[EMAIL PROTECTED]> wrote: I was thinking of doing that Axton but if it doesn't work then the repercussions are that I have start from square one since all the workflow would be corrupt right? Has anyone actually tried this? If so that would raise my confidence and I guess I could try to purge the view form and reimport it via an altered def file... Im waiting for Remedy BMC to get back to me on this to see if they can provide any advice on this. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Monday, October 02, 2006 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Receiving error when attempting to remove field on View Form It looks like the column was dropped frmo the table/view the view form points to. Add the column back to the view/table, then delete the field from the view form. Alternatively, you can export your workflow against this form, delete the form, recreate it with your modified def, then reimport the workflow. Axton Grams On 10/2/06, Lammey, Peter A. <[EMAIL PROTECTED]> wrote: > ** > > > I have been working with a DBA who setup a table on the AR System database. > I noted that one field on the table needed to be removed but since the > DBA had removed the column from the oracle table, I keep getting the > errors from the view when I try to remove the field from the view itself: > > Failure during SQL operation to the database : ORA-00904: "EMP_NUM": > invalid identifier (ARERR 552). > > I basically cannot save the form by removing this field and every time > I try to add another field I get the same error. > It seems that the view form is now corrupt. > > I have also tried to export the form into a .def file and edited the > def file and moved the num-fields down one and removed the part of the > file that references the field but I still get the same error that is above. > > I rather not delete the form and all workflow because of this. > > Does anyone know of a way out of this? > I also removed any references to the field and even tried to change > the field name used in the view for the field to another field but I > still get the same result. > > Thanks > Peter Lammey > ESPN MIT Technical Services & Applications Management > 860-766-4761 __20060125___This posting was > submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: HBR is back and a question on ServiceDesk 7. (U)
** Damn. Now I have to update my address list Good luck Howard in your new position and job. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joran, Peter P CTR OSD CIOSent: Monday, October 02, 2006 8:00 AMTo: arslist@ARSLIST.ORGSubject: Re: HBR is back and a question on ServiceDesk 7. (U) ** UNCLASSIFIED Howard I was unaware you were no longer with Remedy. Thanks for your excellent help in the past and I wish all the best with CedarCrestone!! Pete From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richter, HowardSent: Friday, September 29, 2006 1:40 PMTo: arslist@ARSLIST.ORGSubject: HBR is back and a question on ServiceDesk 7. ** First I am back. Now for my question, does anyone have flowcharts for ServiceDesk 7.0 primarily the Problem management piece, that they can share? I am looking at using the tasking function that is missing (and will be back in 7.0.l) to handle change request. Thanks, hbr Howard Richter Remedy Manager [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
I need guide
** I am new ARS Administrator and the company I am working for utilizes all customed applications. I am not given any training on their system and it makes my work difficult. Is it normal for companies to put new people to work with out giving any training on the system? Please advise me on how should I handle this. Thank you in advance. Get your email and more, right on the new Yahoo.com __20060125___This posting was submitted with HTML in it___
Re: I need guide
** Unfortunately, it is not uncommon. The first thing you should have done you already did - sign up here. The second thing you should do is log into Remedy's support site (I assume your company has valid support) and download any ARS documentation for the version you are running, and then read it. The third thing you should do (good luck with this one) is to get your boss to at least give you the first Admin training course. After that, just open the admin tool and create a new form to get the feel for the application - it's not that hard to use, and the only code syntax you need in the workflow is SQL. If you want some practice creating a form and some workflow, I would start with a basic bug tracker. It's easy to build and actually useful when you're done. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Monday, October 02, 2006 8:29 AMTo: arslist@ARSLIST.ORGSubject: I need guide ** I am new ARS Administrator and the company I am working for utilizes all customed applications. I am not given any training on their system and it makes my work difficult. Is it normal for companies to put new people to work with out giving any training on the system? Please advise me on how should I handle this. Thank you in advance. Get your email and more, right on the new Yahoo.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: I need guide
** You can also learn a whole lot by reverse engineering the current system in place. You can learn the admin tool, learn the applications with their workflow and learn standard naming conventions (assuming there are some). If the previous developers took the time to document, you can also learn the companies business practices or processes via the workflow. just my 2 cents... Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Monday, October 02, 2006 10:38 AMTo: arslist@ARSLIST.ORGSubject: Re: I need guide ** Unfortunately, it is not uncommon. The first thing you should have done you already did - sign up here. The second thing you should do is log into Remedy's support site (I assume your company has valid support) and download any ARS documentation for the version you are running, and then read it. The third thing you should do (good luck with this one) is to get your boss to at least give you the first Admin training course. After that, just open the admin tool and create a new form to get the feel for the application - it's not that hard to use, and the only code syntax you need in the workflow is SQL. If you want some practice creating a form and some workflow, I would start with a basic bug tracker. It's easy to build and actually useful when you're done. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Monday, October 02, 2006 8:29 AMTo: arslist@ARSLIST.ORGSubject: I need guide ** I am new ARS Administrator and the company I am working for utilizes all customed applications. I am not given any training on their system and it makes my work difficult. Is it normal for companies to put new people to work with out giving any training on the system? Please advise me on how should I handle this. Thank you in advance. Get your email and more, right on the new Yahoo.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. __20060125___This posting was submitted with HTML in it___
Re: I need guide
** Good add, Eric. If Sync Search Database hasn't been run for your apps, run it before you go home tonight - it will be done by the time you get in tomorrow. You will then be able to look at the Related Items tab of any field and see the workflow related to that field. Also, turn on the logs while executing a single action, to see what workflow fires, what it does, and in what order. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dunn, EricSent: Monday, October 02, 2006 8:48 AMTo: arslist@ARSLIST.ORGSubject: Re: I need guide ** You can also learn a whole lot by reverse engineering the current system in place. You can learn the admin tool, learn the applications with their workflow and learn standard naming conventions (assuming there are some). If the previous developers took the time to document, you can also learn the companies business practices or processes via the workflow. just my 2 cents... Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Monday, October 02, 2006 10:38 AMTo: arslist@ARSLIST.ORGSubject: Re: I need guide ** Unfortunately, it is not uncommon. The first thing you should have done you already did - sign up here. The second thing you should do is log into Remedy's support site (I assume your company has valid support) and download any ARS documentation for the version you are running, and then read it. The third thing you should do (good luck with this one) is to get your boss to at least give you the first Admin training course. After that, just open the admin tool and create a new form to get the feel for the application - it's not that hard to use, and the only code syntax you need in the workflow is SQL. If you want some practice creating a form and some workflow, I would start with a basic bug tracker. It's easy to build and actually useful when you're done. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Monday, October 02, 2006 8:29 AMTo: arslist@ARSLIST.ORGSubject: I need guide ** I am new ARS Administrator and the company I am working for utilizes all customed applications. I am not given any training on their system and it makes my work difficult. Is it normal for companies to put new people to work with out giving any training on the system? Please advise me on how should I handle this. Thank you in advance. Get your email and more, right on the new Yahoo.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail.__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Break out Member List from AP:Role form (Approval Server)?
** Axton, My first reply gave her the "lite" version of the solution, presuming she would work out the rest. The more detailed solution that I provided after does just as you said. Thad "Axton Grams" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 10/01/2006 07:23 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Break out Member List from AP:Role form (Approval Server)? Be careful with the solutions provided because login names that are substrings of other login names will result in broken member lists. For example, consider the following member value: AGRAMS;AGRAMS2 Now, if you replage AGRAMS with '', you get the following: ;2 A safer approach is to add the delimiter to the beginning and end of the string using a set fields: ex., ;AGRAMS;AGRAMS2; Then replace the leading and trailing delimiter and value with the delimiter. i.e., replace ";AGRAMS;" with ";" The result following: ex., ;AGRAMS2; You can then proceed to trim the leading and trailing delimiters. Axton Grams Thad Esser wrote: > ** > I'm not a DBA, but can get around in SQL/Oracle fairly well. Can you > clarify what you mean by: "...using pipes - | - instead of percent signs!" > > I'm aware of double pipes that get used for concatenation, but I'm > curious how you use them "instead of" percent signs? > > Thanks, > *Thad*/ > "Perfection is achieved, not when there is nothing more to add, but when > there is nothing left to take away."// /- Antoine de Saint-Exupéry > > > *"Rebecca Hammond" <[EMAIL PROTECTED]>* > Sent by: "Action Request System discussion list(ARSList)" > > > 09/28/2006 03:28 PM > Please respond to > arslist@ARSLIST.ORG > > > > To > arslist@ARSLIST.ORG > cc > > Subject > Re: Break out Member List from AP:Role form (Approval Server)? > > > > > > > > > ** > This is great – although we’re in Prod. Code lockdown, so I can’t do > this now ;-) However, I’m going to definitely save it and try to > implement as an enhancement! Thank you! > > I did figure it out, in SQL*Plus, at least to find the affected records > – if anyone’s interested, I can send you the query syntax (darn Oracle, > and using pipes - | - instead of percent signs!) > > > > > *From:* Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] *On Behalf Of *Thad Esser* > Sent:* Thursday, September 28, 2006 1:44 PM* > To:* [EMAIL PROTECTED] > Subject:* Re: Break out Member List from AP:Role form (Approval Server)? > > ** > Rebecca, > > It is what it would like in a set fields of a filter. For my setup, I > have a filter guide on the SHR:People form that when triggered, goes > through all the forms and deletes the users or updates records > associated with them as appropriate. In the case of AP:Role, I push a > value to a "Command field" (display only char field) on the AP:Role > form, where a filter detects that and does the set fields below. > Specifically: > > --- The "Delete Person" filter guide searches the AP:Role form for roles > where the Login Name is the only value in the member list, and then > displays an error if it finds any, > --- Having passed the above, the next filter pushes to the AP:Role form: > Push If: > ( 'Member List' LIKE (( "%" + $Login Name$) + "%" )) AND ( > 'Status' = "Active") > If none, take no action. If any, modify all. > Command = "REMOVE-USER-FROM-MEMBER-LIST " + $Login Name$ > Change History = (($Full Name$ + " (") + $Login Name$) + ") is > being removed from Remedy and has been removed from the list of > approvers for this role." > > Then over on the AP:Role form, I have the following filter on Modify: > Run If: > 'Command' LIKE "REMOVE-USER-FROM-MEMBER-LIST %" > --- Action 1, Set Fields: > Command = ( ";" + REPLACE($Command$, > "REMOVE-USER-FROM-MEMBER-LIST ", "")) + ";" > Member List = ( ";" + $Member List$) + ";" > (parses the login name out of the command field and adds semi-colons so > we can avoid partial matches, e.g. jdoening matching when trying to > remove jdoe) > > --- Action 2, Set Fields: > Member List = REPLACE($Member List$, $Command$, ";") > (pulls out the login name, replacing it with a semi-colon so that login > names are still separated properly) > > --- Action 3, Set Fields: > Member List = SUBSTR($Member List$, 1, LENGTH($Member List$) - 2) > (cuts off the leading and trailing semi-colons that we added in action 1 > to make our search easier) > > I hope that clarifies things for you. > * > Thad*/ > "Perfection is achieved, not when there is nothing more to add, but when > there is nothing left to take away."// /- Antoine de Saint-Exupéry > > *"Rebecca Hammond" <[EMAIL PROTECTED]>* > Sent by: "Action Request System discussio
Group Permissions
Title: Group Permissions ** Is there any easy way (through Remedy User or Remedy Admin) to show all the forms, active links and escalations that have a particular Group associated with it? We are using ARS 6.3…... Lisa Kemes Tyco Electronics Remedy Support 100 Amp Drive Harrisburg, PA 17112 717-810-3361 P Please consider your environmental responsibility before printing this e-mail __20060125___This posting was submitted with HTML in it___
Re: pop up msg box in 6.3 is too small STILL ! !
That particular fix works for resizing custom pop-up boxes.. i really would like to know how to resize the system pop-up boxes, for err and such James ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: I need guide
** I will assume some Remedy training and it is just a new application. If you don't know Remedy, Do not touch the application(s) until you have at least taken some web based training and preferably taken a course or two. Otherwise you are likely going to break the system. so, assuming you know Remedy, then, along with the other suggestions: With the User tool turn on client side logging, and do some typical tasks. Look at the log to see what workflow is fired. ... Daniel -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Dunn, EricSent: October 2, 2006 11:48To: arslist@ARSLIST.ORGSubject: Re: I need guide** You can also learn a whole lot by reverse engineering the current system in place. You can learn the admin tool, learn the applications with their workflow and learn standard naming conventions (assuming there are some). If the previous developers took the time to document, you can also learn the companies business practices or processes via the workflow. just my 2 cents... Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cookSent: Monday, October 02, 2006 10:38 AMTo: arslist@ARSLIST.ORGSubject: Re: I need guide ** Unfortunately, it is not uncommon. The first thing you should have done you already did - sign up here. The second thing you should do is log into Remedy's support site (I assume your company has valid support) and download any ARS documentation for the version you are running, and then read it. The third thing you should do (good luck with this one) is to get your boss to at least give you the first Admin training course. After that, just open the admin tool and create a new form to get the feel for the application - it's not that hard to use, and the only code syntax you need in the workflow is SQL. If you want some practice creating a form and some workflow, I would start with a basic bug tracker. It's easy to build and actually useful when you're done. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Monday, October 02, 2006 8:29 AMTo: arslist@ARSLIST.ORGSubject: I need guide ** I am new ARS Administrator and the company I am working for utilizes all customed applications. I am not given any training on their system and it makes my work difficult. Is it normal for companies to put new people to work with out giving any training on the system? Please advise me on how should I handle this. Thank you in advance. Get your email and more, right on the new Yahoo.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail.__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Group Permissions
** In the admin tool you can select, in the object tree, Groups. From there you can see which alinks, form havethat permission.On 10/2/06, Kemes, Lisa < [EMAIL PROTECTED]> wrote: ** Is there any easy way (through Remedy User or Remedy Admin) to show all the forms, active links and escalations that have a particular Group associated with it? We are using ARS 6.3…... Lisa Kemes Tyco Electronics Remedy Support 100 Amp Drive Harrisburg, PA 17112 717-810-3361 P Please consider your environmental responsibility before printing this e-mail __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Group Permissions
Title: Group Permissions ** ARInside allows you to look at it this way yes L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, LisaSent: Monday, October 02, 2006 10:32 AMTo: arslist@ARSLIST.ORGSubject: Group Permissions ** Is there any easy way (through Remedy User or Remedy Admin) to show all the forms, active links and escalations that have a particular Group associated with it? We are using ARS 6.3…... Lisa Kemes Tyco Electronics Remedy Support 100 Amp Drive Harrisburg, PA 17112 717-810-3361 P Please consider your environmental responsibility before printing this e-mail __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Group Permissions
** Thanks so much Frank. I really do try to research the answer first, but totally missed the boat on this one. There it is, in black and white! Thanks again! Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank CarusoSent: Monday, October 02, 2006 12:55 PMTo: arslist@ARSLIST.ORGSubject: Re: Group Permissions ** In the admin tool you can select, in the object tree, Groups. From there you can see which alinks, form havethat permission. On 10/2/06, Kemes, Lisa < [EMAIL PROTECTED]> wrote: ** Is there any easy way (through Remedy User or Remedy Admin) to show all the forms, active links and escalations that have a particular Group associated with it? We are using ARS 6.3…... Lisa Kemes Tyco Electronics Remedy Support 100 Amp Drive Harrisburg, PA 17112 717-810-3361 P Please consider your environmental responsibility before printing this e-mail __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Count Rows selected
I know I can count the number of rows selected in a table by using a table loop guide. The actual "counting" isn't the issue. What I would like to do is count when I select the rows. For instance, if I select a row in a table, the Menu/Row Choice active links on that table trigger. If I shift-click or ctrl-click another row in the table, the Menu/Row Choice active links DON'T trigger. Short of creating a button that says "Count Number of Rows Selected", does anyone have a way to count the rows selected AS you are selecting them? I tried playing with Gain Focus and Lose Focus events, but that didn't work (sometimes the count was right, but the rows weren't "highlighted"). Thanks for any help. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls?
funny you should ask that, it's something I'm looking to do myself, I find it frustrating these objects cannot have preferences for colours etc... via the admin tool myself. On 02/10/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: Stephen, I found the values to change, thanks. With almost every other UI object in ARS the developer can set the color in the Admin Tool. With these new objects it seems that every computer that runs the WUT will need to copy this file into the folder where aruser.exe resides. Is there any way to update the colors of these objects one time in the css file in the folder where aradmin.exe resides and have all WUT clients see the new color without manually updating each computer? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Earl Sent: Monday, October 02, 2006 10:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls? You can change the colours, however you need to do it through the .css files, either on the mid-tier or for user tool in the user tool install directory and the admin tool install directory. I have managed to successfully change them with no issues via this method. On 02/10/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: > According to our support vendor the color of the new Vertical and > Horizontal Navigation controls in 7.0.00 can not be changed, both in > Windows and Mid Tier. > > Does anyone know if the upcoming 7.0.01 maintenance release will allow > the developer to change the colors of these controls? > > The blue color looks great but does not fit our color theme. > > > Stephen > > __ > _ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Import Question
ARS 7.x Can you import assignee group from a csv. Everytime I do it, my assignee group always goes to Public, even though my csv file contains different values. Is this a bug or am I doing something wrong. Thanks Kevin ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: pop up msg box in 6.3 is too small STILL ! !
James, Are you by any chance using a Fire Fox browser? I seem to remember a BUG in the v6.3 mid-tier with the specific browser like what your describing. (And they say it is fixed in v7's mid-tier.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, SUBSCRIBE arslist James <[EMAIL PROTECTED]> wrote: That particular fix works for resizing custom pop-up boxes.. i really would like to know how to resize the system pop-up boxes, for err and such James ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy Web service client - get list operation - RESOLVED
Remedy does support returning more than one record, and it turns out that the issue was not with the web service client but with the wsdl generation from the Admin tool. You have to modify the output mapping from the default. Here is an example of the default mapping, which returns only one record: ROOT Field1 Field2 etc. Here is an example of the customization, which can be done in the admin tool, and which will return more than one record: ROOT [unmapped - blue circle is empty] getListValues [must use this string, i.e. "getListValues", and map the Form to this element rather than to ROOT] Field1 Field2 etc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Atul Vohra Sent: Tuesday, September 26, 2006 7:22 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Web service client - get list operation As far as I remember, remedy does not "support" the getlist function i.e. it just gets the first record. > - Original Message - > From: "Jim O'Hara" <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Subject: Remedy Web service client - get list operation > Date: Tue, 26 Sep 2006 19:58:23 -0400 > > > I am not the programmer and don't know much Java. But a programmer > here is having trouble with a Remedy web service that has a getlist operation. > They are only retrieving one record, when several meet the criteria. > > Does anyone have a simple code sample or pseudo code for retrieving > via getlist? > > Thanks, > Jim O'Hara > > __ > _ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Group Permissions
Lisa, You likely know this, but I wanted to complete the answer. You will note that the "Escalation" object is not available in that UI because they, like filters, do not have "permissions" related to them. ("They apply to all users because they are part of the AR server.") -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Kemes, Lisa <[EMAIL PROTECTED]> wrote: ** Thanks so much Frank. I really do try to research the answer first, but totally missed the boat on this one. There it is, in black and white! Thanks again! Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Monday, October 02, 2006 12:55 PM To: arslist@ARSLIST.ORG Subject: Re: Group Permissions ** In the admin tool you can select, in the object tree, Groups. From there you can see which alinks, form havethat permission. On 10/2/06, Kemes, Lisa < [EMAIL PROTECTED]> wrote: > ** > > > Is there any easy way (through Remedy User or Remedy Admin) to show all the forms, active links and escalations that have a particular Group associated with it? > > We are using ARS 6.3…... > > Lisa Kemes > Tyco Electronics > Remedy Support > 100 Amp Drive > Harrisburg, PA 17112 > 717-810-3361 > P > Please consider your environmental > responsibility before printing this e-mail -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com 703-376-1249 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Passing Email Attachments into the HPD ticket
** Hi, Our users send an email from Outlook and workflow generates a HPD ticket. The email attachments are not working. I was told though that the attachments once did work, however I did not see any workflow pointing to this functionality. The attachment is pushed into the AR System Email Messages form, and the HPD ticket is generated via a custom form 'ExternalTickets', however the attachment is not being passed into the ticket. There is workflow pushing info into AR System Email Attachment join form and AR System Email Association form. Is there a simpler way of pushing the attachments thru to the form without going thru the entire template process? I have attempted to create a template before, without success. I found this KBEmail Template Example for AR Administrator## File exported Fri Mar 07 10:30:40 2003##AR-Message-Begin Do Not Delete This LineSchema: Email SubmitServer: padres.Remedy.COMLogin: Password: Action: Submit# Values: Submit, QueryFormat: Short# Values: Short, FullSubmitter ! 2!: Short Description ! 8!: Attach!536880912!: <== (Manually add this line based upon the attachment field name and database ID)#AR-Message-End Do Not Delete This LineEmail Template Example for End UserThe end user will need to add all the required values. They'll also need to supply the attachment file name including extension after the attachment field parameter. Then insert your attachment file anywhere in the email.Example of Email Template Filled Out## File exported Fri Mar 07 10:30:40 2003##AR-Message-Begin Do Not Delete This LineSchema: Email SubmitServer: bogus.remedy.comLogin: DemoPassword: Action: Submit# Values: Submit, QueryFormat: Short# Values: Short, FullSubmitter ! 2!: DemoShort Description ! 8!: Submitting email with attachment file.Attach!536880912!: filter.log#AR-Message-End Do Not Delete This LineThen attach your file called filter.log to the email.IF THE ATTACHMENT NAME INCLUDING EXTENSION IS NOT SUPPLIED IN THE EMAIL TEMPLATE THE EMAIL SUBMISSION WILL FAIL below: __20060125___This posting was submitted with HTML in it___
Re: New Atlanta Servlet Engine No Longer Included with 7.0.01
If I understand this document correct; an upgrade to 7.00.01 of mid.tier and there is no support for servletexec from Remedy? Another interesting direction; if you want to run the collector in SLM you need to install JBOSS. -- Jarl On 10/2/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: There is a new Statement of Direction document available on the supportweb under "ARS System -> 7.00.01" documentation. BMC is switching to Apache Foundation Tomcat in the 7.0.01 maintenance release. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: pop up msg box in 6.3 is too small STILL ! !
** The bug is with Diary and Text edit windows only showing 1 or 2 lines of data.From what I hear it has been fixed in v7.On 10/2/06, Carey Matthew Black <[EMAIL PROTECTED]> wrote:James, Are you by any chance using a Fire Fox browser? I seem to remember a BUG in the v6.3 mid-tier with the specificbrowser like what your describing. (And they say it is fixed in v7'smid-tier.)-- Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Love, then teachSolution = People + Process + ToolsFast, Accurate, Cheap Pick two.On 10/2/06, SUBSCRIBE arslist James < [EMAIL PROTECTED]> wrote:> That particular fix works for resizing custom pop-up boxes.. i really> would like to know how to resize the system pop-up boxes, for err and such >> James___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: pop up msg box in 6.3 is too small STILL ! !
** not that i'm aware of there are rouge people doing their own thing, however... we are mostly ie the boxes i'm refereing to are mostly the err boxes, and the filters that i've created.. any help would be appreciated thanks On 10/2/06, Frank Caruso <[EMAIL PROTECTED]> wrote: ** The bug is with Diary and Text edit windows only showing 1 or 2 lines of data.From what I hear it has been fixed in v7. On 10/2/06, Carey Matthew Black <[EMAIL PROTECTED] > wrote: James,Are you by any chance using a Fire Fox browser? I seem to remember a BUG in the v6.3 mid-tier with the specificbrowser like what your describing. (And they say it is fixed in v7'smid-tier.)--Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy) Love, then teachSolution = People + Process + ToolsFast, Accurate, Cheap Pick two.On 10/2/06, SUBSCRIBE arslist James < [EMAIL PROTECTED]> wrote:> That particular fix works for resizing custom pop-up boxes.. i really> would like to know how to resize the system pop-up boxes, for err and such >> James ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Import Question
Kevin, Based on the supplied information I can not tell if it is a bug or a human error. :) A few question to try to short it out. Can you supply a sample data value for a row or three? Are you using group ID format or English string formats? Have you looked at what a CSV file, that was exported using the User Tool, looks like for the values your trying to import? You might have better luck with an ARX formatted file. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Kevin Shaffer <[EMAIL PROTECTED]> wrote: ARS 7.x Can you import assignee group from a csv. Everytime I do it, my assignee group always goes to Public, even though my csv file contains different values. Is this a bug or am I doing something wrong. Thanks Kevin ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Import Question
** What format are you using for the assignee group? Group ids or name?Using the group id format, like "1001;" with csv will work; I'm not sure about using the name format.Are you just trying to do a single group, multiple groups, mixed users and groups, or what? Joe KubasekOn 10/2/06, Kevin Shaffer <[EMAIL PROTECTED]> wrote: ARS 7.xCan you import assignee group from a csv. Everytime I do it, my assigneegroup always goes to Public, even though my csv file contains differentvalues. Is this a bug or am I doing something wrong. ThanksKevin___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: New Atlanta Servlet Engine No Longer Included with 7.0.01
Jarl, > and there is no support for servletexec from Remedy? ServletExec continues to be supported. This is covered in the FAQ section of the document: Will ServletExec continue to be supported in releases after BMC Remedy AR System version 7.0.00? There are two facets to this question: Compatibility o BMC intends to continue test the BMC Remedy AR System product with ServletExec. There are no current plans to remove ServletExec from the compatibility matrix for current or future releases. Customer Support o Customers who received ServletExec as part of a release prior to BMC Remedy AR System version 7.0.01 may contact BMC for "first level" support of ServletExec in relation to the use of ServletExec with BMC Remedy AR System. BMC retains its support relationship with New Atlanta and can represent customer issues or report defects directly to New Atlanta. o New customers who purchase a release of BMC Remedy AR System after version 7.0.01 may contact BMC for support of BMC Remedy AR System in relation to the use of ServletExec with AR System. However, customers who purchased ServletExec directly from New Atlanta may be referred back to New Atlanta for defects or issues with ServletExec itself. -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Monday, October 02, 2006 11:45 AM To: arslist@ARSLIST.ORG Subject: Re: New Atlanta Servlet Engine No Longer Included with 7.0.01 If I understand this document correct; an upgrade to 7.00.01 of mid.tier and there is no support for servletexec from Remedy? Another interesting direction; if you want to run the collector in SLM you need to install JBOSS. -- Jarl On 10/2/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: > There is a new Statement of Direction document available on the > supportweb under "ARS System -> 7.00.01" documentation. BMC is > switching to Apache Foundation Tomcat in the 7.0.01 maintenance release. > > > > Stephen > > __ > _ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Import Question
Usually, when I do an import I take out all the quotes out of the file. Though I usually use excel to edit cvs files, excel puts qoutes around everything. Not sure if this is your problem. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian Analects Cell: (406) 697-8083 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, October 02, 2006 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Import Question Kevin, Based on the supplied information I can not tell if it is a bug or a human error. :) A few question to try to short it out. Can you supply a sample data value for a row or three? Are you using group ID format or English string formats? Have you looked at what a CSV file, that was exported using the User Tool, looks like for the values your trying to import? You might have better luck with an ARX formatted file. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Kevin Shaffer <[EMAIL PROTECTED]> wrote: > ARS 7.x > > Can you import assignee group from a csv. Everytime I do it, my > assignee group always goes to Public, even though my csv file contains different > values. Is this a bug or am I doing something wrong. > > Thanks > > Kevin ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Perform-Action-Apply
** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operation on the current window. For Search windows, the search is performed. Is this the same as just doing a commit? It seems to do a little bit more, like open a message box and close the window. Anyone know what exactly this process does? I am wondering if I can remove this from our Change Request piece so that I may add more workflow afterwards while the window is open. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian AnalectsCell: (406) 697-8083 __20060125___This posting was submitted with HTML in it___
Re: Perform-Action-Apply
Bob, While I am not sure of exactly what your doing I would be cautious of "removing it" or even moving it to a later execution order. You might find that some workflow expected it to happen at that time and that by moving it you are some how breaking other things. Just a thought... One alternate suggestion... How about put all of the "new stuff" into an active link guide and simply add a call guide action before the action in question. That way you get to add as much stuff as you want and you do not have to make a "major" change to the existing workflow. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: ** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operation on the current window. For Search windows, the search is performed. Is this the same as just doing a commit? It seems to do a little bit more, like open a message box and close the window. Anyone know what exactly this process does? I am wondering if I can remove this from our Change Request piece so that I may add more workflow afterwards while the window is open. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian Analects Cell: (406) 697-8083 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
[Soap Question] Problem with the <= in a query
Hello listers, I have a quick question about Soap. We have a soap interface we are running and when I pass in a qualification like this: 'rad_Status' <= "Pending" I get an error: Fault: org.xml.sax.SAXParseException: The content beginning "<=" is not legal markup. Perhaps the "=" (d;) character should be a letter. Detail: I have tried using the html equivalent: 'rad_Status'%3C%3D%20%22Pending%22 Which yields a "Bad Qualification" error. I have also tried escaping the < value: 'rad_Status' \<= "Pending" That didn't doesn't work either. Anyone have any idea on how to get around this? Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Perform-Action-Apply
Title: RE: Perform-Action-Apply ** Carey: Exactly. It depends on what the Active Link is doing. What exactly is the PERFORM-ACTION-APPLY code? James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carey Matthew Black Sent: Monday, October 02, 2006 12:47 PM To: arslist@ARSLIST.ORG Subject: Re: Perform-Action-Apply Bob, While I am not sure of exactly what your doing I would be cautious of "removing it" or even moving it to a later execution order. You might find that some workflow expected it to happen at that time and that by moving it you are some how breaking other things. Just a thought... One alternate suggestion... How about put all of the "new stuff" into an active link guide and simply add a call guide action before the action in question. That way you get to add as much stuff as you want and you do not have to make a "major" change to the existing workflow. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: > ** > > From the Documentation: > > > > PERFORM-ACTION-APPLY > > Performs the Apply or Save operation on the current window. For Search > windows, the search is performed. > > Is this the same as just doing a commit? It seems to do a little bit > more, like open a message box and close the window. Anyone know what > exactly this process does? I am wondering if I can remove this from > our Change Request piece so that I may add more workflow afterwards while the window is open. > > > > > Bob Halstead > Advanced Services "The superior man cannot be known > in little matters, > Bresnan Communications The small man may not be entrusted > with great concerns, > Billings, Montana but he may be known in > little matters." > Office: (406) 869-5624 > Confucius, The Confucian Analects > Cell: (406) 697-8083 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Perform-Action-Apply
** Robert: I agree with Carey, do not remove this workflow. However, you may add workflow before this Active Link. I would look very closely at all of the active links for this particular form and see if I could move it to a larger sequence number or bundle your additional workflow into an Active Link Guide and trigger it from one Active Link. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 12:31 PMTo: arslist@ARSLIST.ORGSubject: Perform-Action-Apply ** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operation on the current window. For Search windows, the search is performed. Is this the same as just doing a commit? It seems to do a little bit more, like open a message box and close the window. Anyone know what exactly this process does? I am wondering if I can remove this from our Change Request piece so that I may add more workflow afterwards while the window is open. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian AnalectsCell: (406) 697-8083 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Perform-Action-Apply
** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form is passed the taskID. The prcess in question is assigned to the save button on the task form. The problem is, and it's a small problem, I would like the keep the task form open after they save it. Currently this only happens when they are modifing an existing task. On a new task it automatically closes the form. I was just wondering if I could replace this process with just a commit command instead, which is why I would like to know what exactly this process does and the code/actions behind it. In the end, if it's too much work to just replace the command I won't do it. But I would like to know for future reference as it could be a viable command to use in future development. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian AnalectsCell: (406) 697-8083 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:07 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I agree with Carey, do not remove this workflow. However, you may add workflow before this Active Link. I would look very closely at all of the active links for this particular form and see if I could move it to a larger sequence number or bundle your additional workflow into an Active Link Guide and trigger it from one Active Link. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 12:31 PMTo: arslist@ARSLIST.ORGSubject: Perform-Action-Apply ** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operation on the current window. For Search windows, the search is performed. Is this the same as just doing a commit? It seems to do a little bit more, like open a message box and close the window. Anyone know what exactly this process does? I am wondering if I can remove this from our Change Request piece so that I may add more workflow afterwards while the window is open. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian AnalectsCell: (406) 697-8083 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Perform-Action-Apply
** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and then immediately open the window in Modify mode where the current user can input more. I'm assuming one of two things: 1. The user has the ability through either a Fixed or Float license to modify or 2. The summitter mode is locked so that users with read licenses can modify only their own summitted actions. If neither is true, you will have to figure out how to do this. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:27 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form is passed the taskID. The prcess in question is assigned to the save button on the task form. The problem is, and it's a small problem, I would like the keep the task form open after they save it. Currently this only happens when they are modifing an existing task. On a new task it automatically closes the form. I was just wondering if I could replace this process with just a commit command instead, which is why I would like to know what exactly this process does and the code/actions behind it. In the end, if it's too much work to just replace the command I won't do it. But I would like to know for future reference as it could be a viable command to use in future development. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian AnalectsCell: (406) 697-8083 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:07 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I agree with Carey, do not remove this workflow. However, you may add workflow before this Active Link. I would look very closely at all of the active links for this particular form and see if I could move it to a larger sequence number or bundle your additional workflow into an Active Link Guide and trigger it from one Active Link. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 12:31 PMTo: arslist@ARSLIST.ORGSubject: Perform-Action-Apply ** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operation on the current window. For Search windows, the search is performed. Is this the same as just doing a commit? It seems to do a little bit more, like open a message box and close the window. Anyone know what exactly this process does? I am wondering if I can remove this from our Change Request piece so that I may add more workflow afterwards while the window is open. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian AnalectsCell: (406) 697-8083 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Import Question
Let me rephrase the question because I have tracked back my issue to Filters that are firing that seem to overwrite my values that I am importing in ... I guess my question now is has anyone imported data into the COM:Company table on v7 and have the data mappings defined or is there a pre-req of what data should be in the system before importing company data From: "Halstead, Robert" <[EMAIL PROTECTED]> Reply-To: arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG Subject: Re: Import Question Date: Mon, 2 Oct 2006 15:22:26 -0400 Usually, when I do an import I take out all the quotes out of the file. Though I usually use excel to edit cvs files, excel puts qoutes around everything. Not sure if this is your problem. Bob Halstead Advanced Services "The superior man cannot be known in little matters, Bresnan Communications The small man may not be entrusted with great concerns, Billings, Montana but he may be known in little matters." Office: (406) 869-5624 Confucius, The Confucian Analects Cell: (406) 697-8083 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, October 02, 2006 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Import Question Kevin, Based on the supplied information I can not tell if it is a bug or a human error. :) A few question to try to short it out. Can you supply a sample data value for a row or three? Are you using group ID format or English string formats? Have you looked at what a CSV file, that was exported using the User Tool, looks like for the values your trying to import? You might have better luck with an ARX formatted file. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Kevin Shaffer <[EMAIL PROTECTED]> wrote: > ARS 7.x > > Can you import assignee group from a csv. Everytime I do it, my > assignee group always goes to Public, even though my csv file contains different > values. Is this a bug or am I doing something wrong. > > Thanks > > Kevin ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Perform-Action-Apply
** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to get around this, but if I can't just replace the RSH:GenericSave with a commit command it will have to do. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:37 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and then immediately open the window in Modify mode where the current user can input more. I'm assuming one of two things: 1. The user has the ability through either a Fixed or Float license to modify or 2. The summitter mode is locked so that users with read licenses can modify only their own summitted actions. If neither is true, you will have to figure out how to do this. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:27 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form is passed the taskID. The prcess in question is assigned to the save button on the task form. The problem is, and it's a small problem, I would like the keep the task form open after they save it. Currently this only happens when they are modifing an existing task. On a new task it automatically closes the form. I was just wondering if I could replace this process with just a commit command instead, which is why I would like to know what exactly this process does and the code/actions behind it. In the end, if it's too much work to just replace the command I won't do it. But I would like to know for future reference as it could be a viable command to use in future development. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:07 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I agree with Carey, do not remove this workflow. However, you may add workflow before this Active Link. I would look very closely at all of the active links for this particular form and see if I could move it to a larger sequence number or bundle your additional workflow into an Active Link Guide and trigger it from one Active Link. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 12:31 PMTo: arslist@ARSLIST.ORGSubject: Perform-Action-Apply ** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operation on the current window. For Search windows, the search is performed. Is this the same as just doing a commit? It seems to do a little bit more, like open a message box and close the window. Anyone know what exactly this process does? I am wondering if I can remove this from our Change Request piece so that I may add more workflow afterwards while the window is open. Bob Halstead __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls?
then we all should do an enhancement request at bmc for that. I think most of us would like to change these colours to their corporate identity design. greets Mario Stephen Earl <[EMAIL PROTECTED] M> To Sent by: "Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject <[EMAIL PROTECTED] Re: ARS 7.0.01 - Change Color of ORG> Vertical/Horizontal Navigation Controls? 02.10.2006 20:00 Please respond to [EMAIL PROTECTED] RG funny you should ask that, it's something I'm looking to do myself, I find it frustrating these objects cannot have preferences for colours etc... via the admin tool myself. On 02/10/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: > Stephen, > > I found the values to change, thanks. With almost every other UI object > in ARS the developer can set the color in the Admin Tool. With these > new objects it seems that every computer that runs the WUT will need to > copy this file into the folder where aruser.exe resides. > > Is there any way to update the colors of these objects one time in the > css file in the folder where aradmin.exe resides and have all WUT > clients see the new color without manually updating each computer? > > Stephen > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Earl > Sent: Monday, October 02, 2006 10:04 AM > To: arslist@ARSLIST.ORG > Subject: Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation > Controls? > > You can change the colours, however you need to do it through the .css > files, either on the mid-tier or for user tool in the user tool install > directory and the admin tool install directory. > > I have managed to successfully change them with no issues via this > method. > > On 02/10/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: > > According to our support vendor the color of the new Vertical and > > Horizontal Navigation controls in 7.0.00 can not be changed, both in > > Windows and Mid Tier. > > > > Does anyone know if the upcoming 7.0.01 maintenance release will allow > > > the developer to change the colors of these controls? > > > > The blue color looks great but does not fit our color theme. > > > > > > Stephen > > > > __ > > _ UNSUBSCRIBE or access ARSlist Archives at > > http://www.wwrug.org > > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Perform-Action-Apply
** Robert: You can replace the workflow with your own custom workflow, but be very careful. I would either: 1. Disable and replace this workflow. 2. Create my own workflow and remove the form from the listing of forms in the RSH:GernericSave Active Link after making a copy of the AL. I would also copy the modified AL. I've done both and find that 1. is easier if the workflow affects only actions on one form. I would use two if the workflow affects two or more forms (that is the original workflow, not your modifications to it.) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to get around this, but if I can't just replace the RSH:GenericSave with a commit command it will have to do. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:37 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and then immediately open the window in Modify mode where the current user can input more. I'm assuming one of two things: 1. The user has the ability through either a Fixed or Float license to modify or 2. The summitter mode is locked so that users with read licenses can modify only their own summitted actions. If neither is true, you will have to figure out how to do this. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:27 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form is passed the taskID. The prcess in question is assigned to the save button on the task form. The problem is, and it's a small problem, I would like the keep the task form open after they save it. Currently this only happens when they are modifing an existing task. On a new task it automatically closes the form. I was just wondering if I could replace this process with just a commit command instead, which is why I would like to know what exactly this process does and the code/actions behind it. In the end, if it's too much work to just replace the command I won't do it. But I would like to know for future reference as it could be a viable command to use in future development. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:07 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I agree with Carey, do not remove this workflow. However, you may add workflow before this Active Link. I would look very closely at all of the active links for this particular form and see if I could move it to a larger sequence number or bundle your additional workflow into an Active Link Guide and trigger it from one Active Link. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 12:31 PMTo: arslist@ARSLIST.ORGSubject: Perform-Action-Apply ** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operation on the current window. For Search windows, the search is performed. Is this the same as just doing a commit? It seems to do a little bit more, like open a message box and close the window. Anyone know what exactly this process does? I am wondering if I can remove this from our Change Request piece so that I may add more workflow afterwards while the window is open. Bob Halstead __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125
Re: Menu to retreive field label names...under certain conditions
I didn't see anything on this...since that's so rare...I'm assuming it is because it was posted Friday afternooneverybody took off early. :-) Reposting. And here's my sql statement on my menu: select a.fieldname, a.fieldid from field a where helptext like 'Field Level Help%' and a.schemaid = (select schemaid from arschema where name = '$SCHEMA$') and exists (select b.fieldid from field_dispprop b where a.schemaid = b.schemaid and a.fieldid = b.fieldid and b.vuiid = (select c.vuiid from vui c where c.schemaid = a.schemaid and c.vuiname = '$VUI$')) Like I stated, that pulls the right fields, but displays the database name of the fields. If you see where I can do it different and get the label names, I'd appreciate it. Thanks. Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Powell Sent: Friday, September 29, 2006 2:34 PM To: arslist@ARSLIST.ORG Subject: Menu to retreive field label names...under certain conditions Hi list. I've researched the past list entries with negative results. I want to provide sight impaired users with a field that contains a list of all fields on a form that have a defined Help Text. To do this, I obviously need some sort of menu to give those users the ability to select from. I know that you can build a Data Dictionary menu that displays the field labels on a form, and I can select the type, such as if I want character fields, or tables, etc. The problem there is that the menu displays all fields of the selected type, regardless if their hidden, visible, etc. I only want to select those that have help text. We have built a SQL menu that looks up the field where we have defined specific leading Help Text. For example, on any given form, all fields that I want to display in the menu have a Help Text leading value of "Help Text For". The SQL menu does a lookup on the fields table and selects the schemaid that matches the schema I am on, evaluates the fields related to that schemaid that have this leading help text and then presents me a list of those fields where the Help Text is prefixed in that manner. Problem partially solved. However, the trouble with that is, the menu pulls back the database name of the field, NOT the label name. As we know, database names are sometimes very cryptic, especially in the ITSM forms. Does anybody know of a way to build a menu that will: 1) At a minimum, only show me the fields where the Help Text has my prefix, but present me the label names instead of the database names? 2) Optimally, not only show me the fields where the Help Text has my prefix, and present me the label names instead of the database name but also limit that to fields that are specific to the VUI I am currently on? ARS 6.3 Patch 17 ITSM 5.5 SQL Server 2000 Microsoft Server 2003 Thanks in advance, Tim Powell ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Perform-Action-Apply
** That is exactly what I would do, but again, what if the process does something behind the scenes like set fields in the form or something else that is critical. Fom a documentation stand point, it would be rather "mean" to have this function do something that the doc's said it didn't. That's really my only scare. Trail and error time i guess. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:57 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: You can replace the workflow with your own custom workflow, but be very careful. I would either: 1. Disable and replace this workflow. 2. Create my own workflow and remove the form from the listing of forms in the RSH:GernericSave Active Link after making a copy of the AL. I would also copy the modified AL. I've done both and find that 1. is easier if the workflow affects only actions on one form. I would use two if the workflow affects two or more forms (that is the original workflow, not your modifications to it.) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to get around this, but if I can't just replace the RSH:GenericSave with a commit command it will have to do. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:37 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and then immediately open the window in Modify mode where the current user can input more. I'm assuming one of two things: 1. The user has the ability through either a Fixed or Float license to modify or 2. The summitter mode is locked so that users with read licenses can modify only their own summitted actions. If neither is true, you will have to figure out how to do this. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:27 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form is passed the taskID. The prcess in question is assigned to the save button on the task form. The problem is, and it's a small problem, I would like the keep the task form open after they save it. Currently this only happens when they are modifing an existing task. On a new task it automatically closes the form. I was just wondering if I could replace this process with just a commit command instead, which is why I would like to know what exactly this process does and the code/actions behind it. In the end, if it's too much work to just replace the command I won't do it. But I would like to know for future reference as it could be a viable command to use in future development. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:07 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I agree with Carey, do not remove this workflow. However, you may add workflow before this Active Link. I would look very closely at all of the active links for this particular form and see if I could move it to a larger sequence number or bundle your additional workflow into an Active Link Guide and trigger it from one Active Link. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 12:31 PMTo: arslist@ARSLIST.ORGSubject: Perform-Action-Apply ** From the Documentation: PERFORM-ACTION-APPLY Performs the Apply or Save operat
Re: Perform-Action-Apply
** Robert: What is the number code after the Perform-Action-Apply (if there is one.) If there is no number, then all that is happening is that the Active Link is doing a commit and close window in one action. You can feel 'safe' to modify this workflow to do what I described if the situation is as I described. Otherwise, you will have to create a set of workflow that compiles with the BMC license agreement and does what you want it to. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:15 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** That is exactly what I would do, but again, what if the process does something behind the scenes like set fields in the form or something else that is critical. Fom a documentation stand point, it would be rather "mean" to have this function do something that the doc's said it didn't. That's really my only scare. Trail and error time i guess. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:57 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: You can replace the workflow with your own custom workflow, but be very careful. I would either: 1. Disable and replace this workflow. 2. Create my own workflow and remove the form from the listing of forms in the RSH:GernericSave Active Link after making a copy of the AL. I would also copy the modified AL. I've done both and find that 1. is easier if the workflow affects only actions on one form. I would use two if the workflow affects two or more forms (that is the original workflow, not your modifications to it.) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to get around this, but if I can't just replace the RSH:GenericSave with a commit command it will have to do. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:37 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and then immediately open the window in Modify mode where the current user can input more. I'm assuming one of two things: 1. The user has the ability through either a Fixed or Float license to modify or 2. The summitter mode is locked so that users with read licenses can modify only their own summitted actions. If neither is true, you will have to figure out how to do this. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:27 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form is passed the taskID. The prcess in question is assigned to the save button on the task form. The problem is, and it's a small problem, I would like the keep the task form open after they save it. Currently this only happens when they are modifing an existing task. On a new task it automatically closes the form. I was just wondering if I could replace this process with just a commit command instead, which is why I would like to know what exactly this process does and the code/actions behind it. In the end, if it's too much work to just replace the command I won't do it. But I would like to know for future reference as it could be a viable command to use in future development. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:07 PMTo: arslist@ARSLIST.ORGSubject: Re: Per
Re: Perform-Action-Apply
** The task is also calling the RSM:GenericSave AL. On the task, I get a ARNOTE: 41102 (since it's above 1, i'm guessing it's just a note), didn't see a message action in any of the active links off the button so it's within the process. On the change save, I don't get any ARNOTE. Funny thing though, on the task save it closes the window. On the change save it re-opens the window in modify mode. With the change request, It only does the reopen in "CREATE" mode. If the form is in "SET" mode it doesn't close the window at all and just saves. Why couldn't bmc just use a simple commit.. It becomes a pain in the *&%#$# if you want to enhance their app in any way, or add to it... Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 3:20 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: What is the number code after the Perform-Action-Apply (if there is one.) If there is no number, then all that is happening is that the Active Link is doing a commit and close window in one action. You can feel 'safe' to modify this workflow to do what I described if the situation is as I described. Otherwise, you will have to create a set of workflow that compiles with the BMC license agreement and does what you want it to. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:15 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** That is exactly what I would do, but again, what if the process does something behind the scenes like set fields in the form or something else that is critical. Fom a documentation stand point, it would be rather "mean" to have this function do something that the doc's said it didn't. That's really my only scare. Trail and error time i guess. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:57 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: You can replace the workflow with your own custom workflow, but be very careful. I would either: 1. Disable and replace this workflow. 2. Create my own workflow and remove the form from the listing of forms in the RSH:GernericSave Active Link after making a copy of the AL. I would also copy the modified AL. I've done both and find that 1. is easier if the workflow affects only actions on one form. I would use two if the workflow affects two or more forms (that is the original workflow, not your modifications to it.) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to get around this, but if I can't just replace the RSH:GenericSave with a commit command it will have to do. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:37 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and then immediately open the window in Modify mode where the current user can input more. I'm assuming one of two things: 1. The user has the ability through either a Fixed or Float license to modify or 2. The summitter mode is locked so that users with read licenses can modify only their own summitted actions. If neither is true, you will have to figure out how to do this. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:27 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form
Re: Perform-Action-Apply
** scratch my last message.. I found the active link that closes the window lol.. had to dig a little deeper. The same link also displayed the messagebox. And set a field that i'm not sure what it does. I'll get back to you all when I dig a little deeper on this. I really want to know what this process does and how it works. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 3:20 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: What is the number code after the Perform-Action-Apply (if there is one.) If there is no number, then all that is happening is that the Active Link is doing a commit and close window in one action. You can feel 'safe' to modify this workflow to do what I described if the situation is as I described. Otherwise, you will have to create a set of workflow that compiles with the BMC license agreement and does what you want it to. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:15 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** That is exactly what I would do, but again, what if the process does something behind the scenes like set fields in the form or something else that is critical. Fom a documentation stand point, it would be rather "mean" to have this function do something that the doc's said it didn't. That's really my only scare. Trail and error time i guess. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:57 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: You can replace the workflow with your own custom workflow, but be very careful. I would either: 1. Disable and replace this workflow. 2. Create my own workflow and remove the form from the listing of forms in the RSH:GernericSave Active Link after making a copy of the AL. I would also copy the modified AL. I've done both and find that 1. is easier if the workflow affects only actions on one form. I would use two if the workflow affects two or more forms (that is the original workflow, not your modifications to it.) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to get around this, but if I can't just replace the RSH:GenericSave with a commit command it will have to do. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:37 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and then immediately open the window in Modify mode where the current user can input more. I'm assuming one of two things: 1. The user has the ability through either a Fixed or Float license to modify or 2. The summitter mode is locked so that users with read licenses can modify only their own summitted actions. If neither is true, you will have to figure out how to do this. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:27 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Well I would like to keep the window open for one. Basically he's my process. A user starts to enter a new change request. They can create tasks for that change request. In that task they can create an outage which is another form. They first have to save the task before they can create an outage.The outage form is passed the taskID. The prcess in question is assigned to the save button on the task form. The problem is, and it's a small problem, I would like the keep the task form open after they save it. Currently this only happens when they are modifing an existing task. On a new task it automatically closes the form. I was just wondering if I could replace this process
Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls?
** I wish there were. You could build workflow, I suppose, to load the correct arsystem.css file (by copying it into the correct directory) through an init-form, but I haven’t tried that yet. For now, you need to route them to the Mid-Tier, where all users use the same arsystem.css, or, distribute your customized arsystem.css file to be installed in the User directory. I really wish there were a server-side solution to this. Sounds like a perfect enhancement request. J -Original Message- From: Heider, Stephen [mailto:[EMAIL PROTECTED] Sent: Monday, October 02, 2006 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls? Stephen, I found the values to change, thanks. With almost every other UI object in ARS the developer can set the color in the Admin Tool. With these new objects it seems that every computer that runs the WUT will need to copy this file into the folder where aruser.exe resides. Is there any way to update the colors of these objects one time in the css file in the folder where aradmin.exe resides and have all WUT clients see the new color without manually updating each computer? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Earl Sent: Monday, October 02, 2006 10:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.01 - Change Color of Vertical/Horizontal Navigation Controls? You can change the colours, however you need to do it through the .css files, either on the mid-tier or for user tool in the user tool install directory and the admin tool install directory. I have managed to successfully change them with no issues via this method. On 02/10/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: > According to our support vendor the color of the new Vertical and > Horizontal Navigation controls in 7.0.00 can not be changed, both in > Windows and Mid Tier. > > Does anyone know if the upcoming 7.0.01 maintenance release will allow > the developer to change the colors of these controls? > > The blue color looks great but does not fit our color theme. > > > Stephen > > __ > _ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Perform-Action-Apply
** Robert: I feel your pain is the word. The reason that it closes is because most original work comes from one of the consoles whereas changes are done directly in the form. It is quite interesting in the thought pattern, and this could be done better as it was in ITSM 5.5 where the calling form was saved on the called form. If the form was not called, it was closed and reopened as a modify. If the form was called, it was called as a dialog, thus you could close the form and return control to the calling form. I guess this was 'lost' during the changes between 5.5 and 7.0. The popup ARNOTE is to let the user know that the task was indeed generated. Let me know if you need more assistance. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:36 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The task is also calling the RSM:GenericSave AL. On the task, I get a ARNOTE: 41102 (since it's above 1, i'm guessing it's just a note), didn't see a message action in any of the active links off the button so it's within the process. On the change save, I don't get any ARNOTE. Funny thing though, on the task save it closes the window. On the change save it re-opens the window in modify mode. With the change request, It only does the reopen in "CREATE" mode. If the form is in "SET" mode it doesn't close the window at all and just saves. Why couldn't bmc just use a simple commit.. It becomes a pain in the *&%#$# if you want to enhance their app in any way, or add to it... Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 3:20 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: What is the number code after the Perform-Action-Apply (if there is one.) If there is no number, then all that is happening is that the Active Link is doing a commit and close window in one action. You can feel 'safe' to modify this workflow to do what I described if the situation is as I described. Otherwise, you will have to create a set of workflow that compiles with the BMC license agreement and does what you want it to. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:15 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** That is exactly what I would do, but again, what if the process does something behind the scenes like set fields in the form or something else that is critical. Fom a documentation stand point, it would be rather "mean" to have this function do something that the doc's said it didn't. That's really my only scare. Trail and error time i guess. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:57 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: You can replace the workflow with your own custom workflow, but be very careful. I would either: 1. Disable and replace this workflow. 2. Create my own workflow and remove the form from the listing of forms in the RSH:GernericSave Active Link after making a copy of the AL. I would also copy the modified AL. I've done both and find that 1. is easier if the workflow affects only actions on one form. I would use two if the workflow affects two or more forms (that is the original workflow, not your modifications to it.) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to get around this, but if I can't just replace the RSH:GenericSave with a commit command it will have to do. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:37 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I would suggest trying to do the following: Commit the action (this maybe caused by the Perform-Action-Apply) and th
Re: Perform-Action-Apply
** Ok, after I turned on logging of active links on the client, I finally understood how and when things are getting accessed. First off, I would like to compliment bmc for their exceptional job of making the save process pretty complicated on their change request form =P The button on the task form which performs the process in question, to believe it or not, doesn't get any clickage. In fact, one of the first things the form does on open is disable that button and enable a second button that fires totally different workflow. In the end, the save on the task form does a push fields action to the task form (since it's it opens as a dialog). Oh, do I dare to mention that there are 4, yes count em 4 buttons the form that "save" the form!! The change form, on the other hand does call the process, and through some really complicated workflow re-opens the same window in a modify state. I wasn't able to find the close window action though before the window itself was turned into a modify. I saw the open window for modify but was missing the close. Not sure how the first one gets closed. Still a mystery. In the end, I just created a test form that run's that process with logging on. From the logs, it seems the process does exactly what the docs say. As it's not calling any other active links.The process saves the request in "CREATE" mode and does a search in "QUERY" mode. Why bmc made this into a process is beyond me, why not just do a commit? Maybe its because it does one or the other based on the form mode, I don't know, but would seem like a good guess at this point. Just glad I wasted a few hours just trying to figure out if I can replace something that doesn't need to be replaced but instead replace a "close window" action instead lol. Oh well, hope this helps some other poor sole that wants to know what this process does and who needed a little bit of insight to bmc's home grown apps. lol. A BIG thank you goes out to James for putting up with my ranting and help =) and another to Carey. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 4:17 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I feel your pain is the word. The reason that it closes is because most original work comes from one of the consoles whereas changes are done directly in the form. It is quite interesting in the thought pattern, and this could be done better as it was in ITSM 5.5 where the calling form was saved on the called form. If the form was not called, it was closed and reopened as a modify. If the form was called, it was called as a dialog, thus you could close the form and return control to the calling form. I guess this was 'lost' during the changes between 5.5 and 7.0. The popup ARNOTE is to let the user know that the task was indeed generated. Let me know if you need more assistance. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:36 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The task is also calling the RSM:GenericSave AL. On the task, I get a ARNOTE: 41102 (since it's above 1, i'm guessing it's just a note), didn't see a message action in any of the active links off the button so it's within the process. On the change save, I don't get any ARNOTE. Funny thing though, on the task save it closes the window. On the change save it re-opens the window in modify mode. With the change request, It only does the reopen in "CREATE" mode. If the form is in "SET" mode it doesn't close the window at all and just saves. Why couldn't bmc just use a simple commit.. It becomes a pain in the *&%#$# if you want to enhance their app in any way, or add to it... Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 3:20 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: What is the number code after the Perform-Action-Apply (if there is one.) If there is no number, then all that is happening is that the Active Link is doing a commit and close window in one action. You can feel 'safe' to modify this workflow to do what I described if the situation is as I described. Otherwise, you will have to create a set of workflow that compiles with the BMC license agreement and does what you want it to. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:15 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** That is exactly what I would do, but again, what if the process does something be
Re: Perform-Action-Apply
** Oh, and I got your email Jay, but didn't see it till I sent out my last one lol. Thankyou for that though =) Next time i'll just enable logging on the client first when trying to figure out something on change management side lol. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 4:17 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: I feel your pain is the word. The reason that it closes is because most original work comes from one of the consoles whereas changes are done directly in the form. It is quite interesting in the thought pattern, and this could be done better as it was in ITSM 5.5 where the calling form was saved on the called form. If the form was not called, it was closed and reopened as a modify. If the form was called, it was called as a dialog, thus you could close the form and return control to the calling form. I guess this was 'lost' during the changes between 5.5 and 7.0. The popup ARNOTE is to let the user know that the task was indeed generated. Let me know if you need more assistance. James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:36 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The task is also calling the RSM:GenericSave AL. On the task, I get a ARNOTE: 41102 (since it's above 1, i'm guessing it's just a note), didn't see a message action in any of the active links off the button so it's within the process. On the change save, I don't get any ARNOTE. Funny thing though, on the task save it closes the window. On the change save it re-opens the window in modify mode. With the change request, It only does the reopen in "CREATE" mode. If the form is in "SET" mode it doesn't close the window at all and just saves. Why couldn't bmc just use a simple commit.. It becomes a pain in the *&%#$# if you want to enhance their app in any way, or add to it... Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 3:20 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: What is the number code after the Perform-Action-Apply (if there is one.) If there is no number, then all that is happening is that the Active Link is doing a commit and close window in one action. You can feel 'safe' to modify this workflow to do what I described if the situation is as I described. Otherwise, you will have to create a set of workflow that compiles with the BMC license agreement and does what you want it to. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 2:15 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** That is exactly what I would do, but again, what if the process does something behind the scenes like set fields in the form or something else that is critical. Fom a documentation stand point, it would be rather "mean" to have this function do something that the doc's said it didn't. That's really my only scare. Trail and error time i guess. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 2:57 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** Robert: You can replace the workflow with your own custom workflow, but be very careful. I would either: 1. Disable and replace this workflow. 2. Create my own workflow and remove the form from the listing of forms in the RSH:GernericSave Active Link after making a copy of the AL. I would also copy the modified AL. I've done both and find that 1. is easier if the workflow affects only actions on one form. I would use two if the workflow affects two or more forms (that is the original workflow, not your modifications to it.) James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Halstead, RobertSent: Monday, October 02, 2006 1:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Perform-Action-Apply ** The commit is actually done by the Perform-Action-Apply, along with the window close. but again this is just from observation. The save button, it turns out, fires off an active link called RSH:GenericSave which ONLY calls the Perform-Action-Apply. which just runs that command. This is probablly shipped with remedy's change app. Will the active link still fire if I add a new active link to execute right after the RSH:GenericSave on the same form? Even if the form closes? Just seems like a sloppy way to ge
ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectively?
** Hi all, So, I know that I can install ARS 6.3 and 7.0 on the same App. Server, but today, when I called Support about an installation question, they implied that although I can install the ARServers, I might not be able to install ITSM 7.0 on my ARS 7.0 instance (since I have ITSM 6.0 on my ARS 6.3 instance). Does anyone know if this is true? Has anyone installed 6.3/7.0 on the same box, with the appropriate ITSM versions on the servers? Thanks! -Rebecca __20060125___This posting was submitted with HTML in it___
Re: ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectiv ely?
** Rebecca: We are trying that here, except our Oracle server has a major problem James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rebecca HammondSent: Monday, October 02, 2006 3:57 PMTo: arslist@ARSLIST.ORGSubject: ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectively? ** Hi all, So, I know that I can install ARS 6.3 and 7.0 on the same App. Server, but today, when I called Support about an installation question, they implied that although I can install the ARServers, I might not be able to install ITSM 7.0 on my ARS 7.0 instance (since I have ITSM 6.0 on my ARS 6.3 instance). Does anyone know if this is true? Has anyone installed 6.3/7.0 on the same box, with the appropriate ITSM versions on the servers? Thanks! -Rebecca__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
OT: Error Message on Solaris Server
** Sorry for the OT, but our Oracle server is down and when we reboot it we get a message to run metadb. I'm very leery of doing this before I find out what is wrong with the server. Anyone else encountered this message and what did you do to fix it? Off-list is fine, I will feedback to the list if necessary. James McKenzie L-3 GSI __20060125___This posting was submitted with HTML in it___
Newbie Question
I am new to Remedy ARS administration and I'm beginning to get "Is this possible?" type questions from my users. I've got two that keep cropping up and I haven't been able to find a definitive answer. Any enlightenment anyone can offer will be greatly appreciated. Thanks in advance. 1. Is there any was that Rich Text Format (RTF) fields can be used in ARS? They want to be able to use difference fonts, colors, bolding, etc. 2. Is there any way to implement spell checking for text fields? Once again, thank you for any information you can offer. Mike Colledge Southwest Gas Corporation ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectively?
** I did it (Win2k3/SQL), but I had them in separate database instances, only one of which could be active at a time. I don't know about having both of them available - there would be licensing issues at least. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rebecca HammondSent: Monday, October 02, 2006 3:57 PMTo: arslist@ARSLIST.ORGSubject: ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectively? ** Hi all, So, I know that I can install ARS 6.3 and 7.0 on the same App. Server, but today, when I called Support about an installation question, they implied that although I can install the ARServers, I might not be able to install ITSM 7.0 on my ARS 7.0 instance (since I have ITSM 6.0 on my ARS 6.3 instance). Does anyone know if this is true? Has anyone installed 6.3/7.0 on the same box, with the appropriate ITSM versions on the servers? Thanks! -Rebecca__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Newbie Question
Answer 1) RTF on the native user client is not possible.. On the midtier however if your web developers are willing to play around to modify the code behind those pages.. I'm not sure you would be achieving a business advantage doing that given the work involved... Answer 2) DDE is your answer to it. There is a good example of how to do this on the Admin guides where they explain the use of the DDE action of an Active Link... Follow that example and replicate it on the field you want to run your spell check over... Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mike Colledge Sent: Monday, October 02, 2006 7:35 PM To: arslist@ARSLIST.ORG Subject: Newbie Question I am new to Remedy ARS administration and I'm beginning to get "Is this possible?" type questions from my users. I've got two that keep cropping up and I haven't been able to find a definitive answer. Any enlightenment anyone can offer will be greatly appreciated. Thanks in advance. 1. Is there any was that Rich Text Format (RTF) fields can be used in ARS? They want to be able to use difference fonts, colors, bolding, etc. 2. Is there any way to implement spell checking for text fields? Once again, thank you for any information you can offer. Mike Colledge Southwest Gas Corporation ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Error Message on Solaris Server
** I'd first go for a system level restore if you have a backup of the system before it went down.. might loose some transactional info that way but at least you would be good to go from the point it went down at.. Cheers Joe -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Monday, October 02, 2006 7:17 PMTo: arslist@ARSLIST.ORGSubject: OT: Error Message on Solaris Server** Sorry for the OT, but our Oracle server is down and when we reboot it we get a message to run metadb. I'm very leery of doing this before I find out what is wrong with the server. Anyone else encountered this message and what did you do to fix it? Off-list is fine, I will feedback to the list if necessary. James McKenzie L-3 GSI__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Menu to retreive field label names...under certain conditions
That's because you are querying the field table where the fieldname column stores the database name of the field. What you should be doing is run a query on the field_dispprop table to get the field name for the view by seeking the vuid from the vui table.. so basically your sql statement will be querying the field_dispprop table using the results of what you get from selecting the vuid from the vui table, using the results of what you get by selecting the field id from the field table... so its a nested select statemet just like you have written but a couple of levels more deep.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Timothy Powell Sent: Monday, October 02, 2006 5:00 PM To: arslist@ARSLIST.ORG Subject: Re: Menu to retreive field label names...under certain conditions I didn't see anything on this...since that's so rare...I'm assuming it is because it was posted Friday afternooneverybody took off early. :-) Reposting. And here's my sql statement on my menu: select a.fieldname, a.fieldid from field a where helptext like 'Field Level Help%' and a.schemaid = (select schemaid from arschema where name = '$SCHEMA$') and exists (select b.fieldid from field_dispprop b where a.schemaid = b.schemaid and a.fieldid = b.fieldid and b.vuiid = (select c.vuiid from vui c where c.schemaid = a.schemaid and c.vuiname = '$VUI$')) Like I stated, that pulls the right fields, but displays the database name of the fields. If you see where I can do it different and get the label names, I'd appreciate it. Thanks. Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Powell Sent: Friday, September 29, 2006 2:34 PM To: arslist@ARSLIST.ORG Subject: Menu to retreive field label names...under certain conditions Hi list. I've researched the past list entries with negative results. I want to provide sight impaired users with a field that contains a list of all fields on a form that have a defined Help Text. To do this, I obviously need some sort of menu to give those users the ability to select from. I know that you can build a Data Dictionary menu that displays the field labels on a form, and I can select the type, such as if I want character fields, or tables, etc. The problem there is that the menu displays all fields of the selected type, regardless if their hidden, visible, etc. I only want to select those that have help text. We have built a SQL menu that looks up the field where we have defined specific leading Help Text. For example, on any given form, all fields that I want to display in the menu have a Help Text leading value of "Help Text For". The SQL menu does a lookup on the fields table and selects the schemaid that matches the schema I am on, evaluates the fields related to that schemaid that have this leading help text and then presents me a list of those fields where the Help Text is prefixed in that manner. Problem partially solved. However, the trouble with that is, the menu pulls back the database name of the field, NOT the label name. As we know, database names are sometimes very cryptic, especially in the ITSM forms. Does anybody know of a way to build a menu that will: 1) At a minimum, only show me the fields where the Help Text has my prefix, but present me the label names instead of the database names? 2) Optimally, not only show me the fields where the Help Text has my prefix, and present me the label names instead of the database name but also limit that to fields that are specific to the VUI I am currently on? ARS 6.3 Patch 17 ITSM 5.5 SQL Server 2000 Microsoft Server 2003 Thanks in advance, Tim Powell ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectiv ely?
** Unrelated to the install (I hope)? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Monday, October 02, 2006 7:04 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectiv ely? Rebecca: We are trying that here, except our Oracle server has a major problem James McKenzie From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rebecca Hammond Sent: Monday, October 02, 2006 3:57 PM To: arslist@ARSLIST.ORG Subject: ARS 6.3/7.0 on same server, with ITSM 6 and ITSM 7, respectively? ** Hi all, So, I know that I can install ARS 6.3 and 7.0 on the same App. Server, but today, when I called Support about an installation question, they implied that although I can install the ARServers, I might not be able to install ITSM 7.0 on my ARS 7.0 instance (since I have ITSM 6.0 on my ARS 6.3 instance). Does anyone know if this is true? Has anyone installed 6.3/7.0 on the same box, with the appropriate ITSM versions on the servers? Thanks! -Rebecca __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
I was trying to sign up so i could post a job on your site and i never got that far and now i am receiving alot of email. Please take me off your email list. Thank you
** Susan Bonnell Senior Technical Recruiter Analysts International [EMAIL PROTECTED] Direct: (303) 779-3520 Toll Free: 866-765-2849 ext 8223520 www.analysts.com www.jobsatanalysts.com __20060125___This posting was submitted with HTML in it___
Re: I was trying to sign up so i could post a job on your site and i never got that far and now i am receiving alot of email. Please take me off your email list. Thank you
--Tim - Original Message Friday Humor came early this week. --Tim - Original Message From: "Bonnell, Susan" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, October 2, 2006 10:49:45 PM Subject: [ARSLIST] I was trying to sign up so i could post a job on your site and i never got that far and now i am receiving alot of email. Please take me off your email list. Thank you ** Susan Bonnell Senior Technical Recruiter Analysts International [EMAIL PROTECTED] Direct: (303) 779-3520 Toll Free: 866-765-2849 ext 8223520 www.analysts.com www.jobsatanalysts.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: I was trying to sign up so i could post a job on your site and i never got that far and now i am receiving alot of email. Please take me off your email list. Thank you
And the ARSList award for longest subject line masquerading as a message is... Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Monday, October 02, 2006 8:10 PM To: arslist@ARSLIST.ORG Subject: Re: I was trying to sign up so i could post a job on your site and i never got that far and now i am receiving alot of email. Please take me off your email list. Thank you --Tim - Original Message Friday Humor came early this week. --Tim - Original Message From: "Bonnell, Susan" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, October 2, 2006 10:49:45 PM Subject: [ARSLIST] I was trying to sign up so i could post a job on your site and i never got that far and now i am receiving alot of email. Please take me off your email list. Thank you ** Susan Bonnell Senior Technical Recruiter Analysts International [EMAIL PROTECTED] Direct: (303) 779-3520 Toll Free: 866-765-2849 ext 8223520 www.analysts.com www.jobsatanalysts.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Menu to retreive field label names...under certain conditions
Tim, Uh... and you have to parse the right part of a "display property" out of one of two different columns in that field_dispprop table. (If memory serves.) I started to try to reply the other day.. but it is still a bit incomplete... but I think it still might spark a few ideas out there as is... so here it is... incomplete and all: " An interesting request. How about this as an idea... Create a view form on top of a RDMB view that you create. The RDBMS view would look at field, field_prop (or is it field_props or field_properties ?), arschema and fields_by_vui (the table that I will describe next) to get the following set of data columns where your special tag is the leading part of the field.helpText column. aschema.name, vuiId, Vui_name, field.fieldId, fieldLabel_for_vui field.helpText The "fields_by_vui form" is no small task, but very possible too. The field Label for the given views. And think you will be best served by doing that part via either an escalation and a chunk of filters or an ARS API program to populate a form that maps. aschema.name, field.fieldId, field_prop.vuiId, Vui_name, (not ID for easier use in the menu) fieldLabel_for_vui You can look to the special $PROCESS$ command "Application-Map-Ids-To-Names-L " for help if you want to make your API/Filter work a whole lot easier. The only "hard part" that I see is knowing when you re-cache the "fields_by_vui form" data. that could be done manually if your system is fairly stable, or you could automate it with the Server Event form and a filter or two. Then a Search menu should be able to use the $ SCHEMA $ keyword and the $VUI$ keyword to return the right fields for the user. You might even discover that the performance of some of those joins is so poor that you just want to build out "fields_by_vui form" a bit more and just join it with field to get the Helptext. Or just dump the "prefix" idea in the helptext and use "fields_by_vui form" as the "control" for what field to process and just check the modified data of your "fields_by_vui form" record vs the field table to grab updated help text nightly. Lots of ways to skin this cat, but non that I see as "just a menu". ( I think your requirements are a bit to ... specific ... for what ARS Objects are designed for. :) I doubt that is what you wanted to hear, but maybe it will help anyway. " -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Joe D'Souza <[EMAIL PROTECTED]> wrote: That's because you are querying the field table where the fieldname column stores the database name of the field. What you should be doing is run a query on the field_dispprop table to get the field name for the view by seeking the vuid from the vui table.. so basically your sql statement will be querying the field_dispprop table using the results of what you get from selecting the vuid from the vui table, using the results of what you get by selecting the field id from the field table... so its a nested select statemet just like you have written but a couple of levels more deep.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Timothy Powell Sent: Monday, October 02, 2006 5:00 PM To: arslist@ARSLIST.ORG Subject: Re: Menu to retreive field label names...under certain conditions I didn't see anything on this...since that's so rare...I'm assuming it is because it was posted Friday afternooneverybody took off early. :-) Reposting. And here's my sql statement on my menu: select a.fieldname, a.fieldid from field a where helptext like 'Field Level Help%' and a.schemaid = (select schemaid from arschema where name = '$SCHEMA$') and exists (select b.fieldid from field_dispprop b where a.schemaid = b.schemaid and a.fieldid = b.fieldid and b.vuiid = (select c.vuiid from vui c where c.schemaid = a.schemaid and c.vuiname = '$VUI$')) Like I stated, that pulls the right fields, but displays the database name of the fields. If you see where I can do it different and get the label names, I'd appreciate it. Thanks. Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Powell Sent: Friday, September 29, 2006 2:34 PM To: arslist@ARSLIST.ORG Subject: Menu to retreive field label names...under certain conditions Hi list. I've researched the past list entries with negative results. I want to provide sight impaired users with a field that contains a list of all fields on a form that have a defined Help Text. To do this, I obviously need some sort of menu to give those users the ability to select from. I know that you can build a Data Dictionary menu that displays the field labels on a form, and I can select the type, such as if I want character fields, or tables, etc. The problem there is that th
Re: [Soap Question] Problem with the <= in a query
Sean, I have not tested this... But I think your first dealing with an XML issue. "<" instead of "<" Now if ARS will understand that... well that might be a different problem. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 10/2/06, Sean Garrison <[EMAIL PROTECTED]> wrote: Hello listers, I have a quick question about Soap. We have a soap interface we are running and when I pass in a qualification like this: 'rad_Status' <= "Pending" I get an error: Fault: org.xml.sax.SAXParseException: The content beginning "<=" is not legal markup. Perhaps the "=" (d;) character should be a letter. Detail: I have tried using the html equivalent: 'rad_Status'%3C%3D%20%22Pending%22 Which yields a "Bad Qualification" error. I have also tried escaping the < value: 'rad_Status' \<= "Pending" That didn't doesn't work either. Anyone have any idea on how to get around this? Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Installation question
Title: Installation question ** John, I'm not sure if you got a response to this... but here goes... You assume correct.. The first server doesn't have to be shut down during the install of the second server... The second server can be set up independently and now the new apps have the ability to ignore the import of workflow during the installation process so none of the forms will be written to as well. All you would need to do is install the application in the same path as was done on the first server as some of the application meta data will have references to some binaries contained in this path... Cheers Joe -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of John HansonSent: Friday, September 29, 2006 4:56 PMTo: arslist@ARSLIST.ORGSubject: Installation question** Hello all! We've completed the installation of ARS 6.3, email, mid-tier, CMDB, and Help Desk on the first of our servers, and now we're getting ready to do the second server. The servers will be set up in a server group, both connecting to the same database. I have a couple questions before I start in on the second set of installations: does the first server need to have ARS shut down during the installation on the second server, or can it continue to run? I would assume that the first server could keep chugging along since the second server isn't supposed to update any of the database tables when using the 'shared' database option. Second, when installing CMDB on the first machine, I made sure to first go in and delete all of the BMC* and OBJSTR* forms, workflow, and menus, and the cmdb install directory prior to rerunning the installation, as it was having issues otherwise. Now that the first server is up and running with everything installed on it, will the second server generate errors during the CMDB and HD installations if it notices that the forms and workflow are already there, or will it accept the existing data during the install? Thanks, John HansonRemedy Administrator/DeveloperThe Standard1100 SW Sixth AvenuePortland, OR 97204Telephone (971) 321-7153[EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Menu to retreive field label names...under certain conditions
Here's something I posted to the list back in 2004. It might help in this situation... The MS SQL Server Solution: Maybe there's an easier way to do it, but here's what I came up with. I use a lot of charindex and substring calls to chop out the field label. Notice that the propLong field has to be converted to a varchar data type so I can perform normal string operations. Here it is: -- select substring( substring(convert(varchar(255), propLong), charindex('\20\4\', (convert(varchar(255), propLong))) + 6, datalength(convert(varchar(255), proplong))), charindex('\', substring(convert(varchar(255), propLong), charindex('\20\4\', (convert(varchar(255), propLong))) + 6, datalength(convert(varchar(255), proplong + 1, charindex('\', substring( substring(convert(varchar(255), propLong), charindex('\20\4\', (convert(varchar(255), propLong))) + 6, datalength(convert(varchar(255), proplong))), charindex('\', substring(convert(varchar(255), propLong), charindex('\20\4\', (convert(varchar(255), propLong))) + 6, datalength(convert(varchar(255), proplong + 1, 255)) - 1 ) Label_Value from field_dispprop where fieldId='536870913' and schemaId=( select schemaid from arschema where name='Test01') -- Assume that the database name of the field is 'Test01' and its field ID is 536870913. Tim Widowfield [EMAIL PROTECTED] v: 937-878-9045 f: 937-878-9055 m: 937-369-7012 http://www.widowfield.com - Original Message From: Joe D'Souza <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, October 2, 2006 9:43:06 PM Subject: Re: [ARSLIST] Menu to retreive field label names...under certain conditions That's because you are querying the field table where the fieldname column stores the database name of the field. What you should be doing is run a query on the field_dispprop table to get the field name for the view by seeking the vuid from the vui table.. so basically your sql statement will be querying the field_dispprop table using the results of what you get from selecting the vuid from the vui table, using the results of what you get by selecting the field id from the field table... so its a nested select statemet just like you have written but a couple of levels more deep.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Timothy Powell Sent: Monday, October 02, 2006 5:00 PM To: arslist@ARSLIST.ORG Subject: Re: Menu to retreive field label names...under certain conditions I didn't see anything on this...since that's so rare...I'm assuming it is because it was posted Friday afternooneverybody took off early. :-) Reposting. And here's my sql statement on my menu: select a.fieldname, a.fieldid from field a where helptext like 'Field Level Help%' and a.schemaid = (select schemaid from arschema where name = '$SCHEMA$') and exists (select b.fieldid from field_dispprop b where a.schemaid = b.schemaid and a.fieldid = b.fieldid and b.vuiid = (select c.vuiid from vui c where c.schemaid = a.schemaid and c.vuiname = '$VUI$')) Like I stated, that pulls the right fields, but displays the database name of the fields. If you see where I can do it different and get the label names, I'd appreciate it. Thanks. Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Powell Sent: Friday, September 29, 2006 2:34 PM To: arslist@ARSLIST.ORG Subject: Menu to retreive field label names...under certain conditions Hi list. I've researched the past list entries with negative results. I want to provide sight impaired users with a field that contains a list of all fields on a form that have a defined Help Text. To do this, I obviously need some sort of menu to give those users the ability to select from. I know that you can build a Data Dictionary menu that displays the field labels on a form, and I can select the type, such as if I want character fields, or tables, etc. The problem there is that the menu displays all fields of the selected type, regardless if their hidden, visible, etc. I only want to select those that have help text. We have built a SQL menu that looks up the field where we have defined specific leading Help Text. For example, on any given form, all fields that I want to display in the menu have a Help Text leading value of "Help Text For". The SQL menu does a lookup on the fields table and selects the schemaid that matches the schema I am on, evaluates the fields related to that schemaid that have this leading help text and then presents me a list of those fields where the Help Text is prefixed in that manner. Problem partially
Found While Searching for Something Else -- Using TransactSQL to Get Form View Alias
I was rummaging through my sent mail boxes and found this message from Aug 2005, back when I worked for cMango. Somebody out there may find it useful. == Form view aliases (e.g. "Help Desk Case", "Help Desk Cases") are contained in the propShort or propLong column of the field_dispprop table. Experience shows that if you assign alias names, the property string is so long that AR System sets propShort to null and moves it to propLong. This SQL script finds the 206 property (Singular Alias) and the 207 property (Plural Alias) in propLong and chops out the string values. The LEFT and RIGHT functions don't work on TEXT fields, so I used SUBSTRING instead. On my system, the schemaId for the SPRT:Issue schema is 223, so when I run the script I get: Singular AliasPlural Alias -- Issue Issues I assume you know how to get the schemaId and vuiId. Here it is: - -- GetLongAndShortAliases_1.1.sql -- -- Author: [EMAIL PROTECTED] -- Note: Assumes alias will be in propLong, because adding aliases -- makes the view's property string too large to fit in propShort -- -- Changed: Uses the number after the CHAR indicator (\4\), which is the -- actual length of the alias string. That works better than finding the -- trailing backslash. declare @schemaId nvarchar(30) declare @vuiid nvarchar(30) set @schemaID = '223'; set @vuiid = '10003000'; select -- Column 1: 206 is the property for Singular Alias. 4 means CHAR replace( substring( substring(propLong, (patindex('%\206\4\%', propLong) + 9), (datalength(propLong) - (patindex('%206\4\%', propLong, 0, cast (substring( substring(propLong, (patindex('%\206\4\%', propLong) + 7), (datalength(propLong) - (patindex('%\206\4\%', propLong, 0, patindex('%\%', substring(propLong, (patindex('%\206\4\%', propLong) + 7), (datalength(propLong) - (patindex('%\206\4\%', propLong)) as int) + 2), '\', '') SingularAlias, -- Column 2: 207 is the property for Plural Alias. 4 means CHAR replace( substring( substring(propLong, (patindex('%\207\4\%', propLong) + 9), (datalength(propLong) - (patindex('%\207\4\%', propLong, 0, cast (substring( substring(propLong, (patindex('%\207\4\%', propLong) + 7), (datalength(propLong) - (patindex('%\207\4\%', propLong, 0, patindex('%\%', substring(propLong, (patindex('%\207\4\%', propLong) + 7), (datalength(propLong) - (patindex('%\207\4\%', propLong)) as int) + 2), '\','') PluralAlias from arsystem.dbo.field_dispprop where fieldId is null and propLong is not null and propLong like '%\206\4\%' and schemaId = @schemaId and vuiId = @vuiId -- -- -- Useful for testing Try 'HPD:%' and 'SHARE:%'. -- -- schemaId in --(select -- schemaId -- from -- arsystem.dbo.arschema -- where -- name like 'SPRT%') - End of Script I tested this in Query Analyzer, but it should work in isql, too. == Tim Widowfield [EMAIL PROTECTED] v: 937-878-9045 f: 937-878-9055 m: 937-369-7012 http://www.widowfield.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Migrating Form Views
Dear All, I tried to migrate a new view of the HPD: HelpDesk form from our development to production server, and to my amazement, discovered that Migrator does not migrate the fields on the view. Permissions to the view are determined at the field level, so all fields must be migrated separately. Well, this view has 307 fields, so I spent most the evening identifying those fields where the labels did not match the database name, and then migrated them over. It was brutal! Does anyone know of an easier, softer way to accomplish this task? Any suggestions/recommendations are appreciated. Many Thanks. Audrey Franklin New York University [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org