test
Test my first ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Crystal Reports Error
Hi List, I am getting below error while scheduling a crystal report. I am unable to select any group and get the error. An error has occurred: List of Values failure: fail to get values. [Cause of error: Failed to open the connection. Group List] Please let me know if any one has face such issue before. Thanks, Rajat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry
Dear all, ARS. 7.1 patch 4 / OS. NT2003 SRV Edition / DB. MS SQL SRV 2005 It states in the performance and optimisation manual, only one node in a server group should be used as the server for admin changes (i.e forms, workflow etc..) but both should be accessed when making other changes (i.e adding threads to a particular queue). I added two threads to the list queue through the admin tool to node1 and node2 in a server group. I did a restart and got the following errors on both. 390603 : Entry does not exist in database. (ARERR 302) 390603 : The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry:NTG00156348 I enabled the SQL/Filter/API logs and noticed few errors relating to escalation SYS:NPC:IM1-TriggerGroupNTG (attached to form NTE:SYS-NT Process Control) which runs every 1 minute. The escalation updates field z1D Action with the value START GROUP NOTIFICATION. It fails with the first error: 390603 : Entry does not exist in database. (ARERR 302) This action in turn causes a filter NTE:NPC:CreateGroupNTG_050_PNTG to do an insert to form NTE:SYS-Group NT Control which fails with the second error: 390603 : The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry:NTG00156348 When removing the two threads I have added and doing a restart I get no errors. I also noticed that form NTE:SYS-NT Process Control still has some old entries with submit dates as far back as 2007, some 22 of them in total. Regards frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Asset 7.03 - Adding fields To Contracts. AST:AssetSupport
All, I am working with the CMDB 2.0 and Asset Management 7.03. I am looking into adding fields to the Contracts forms. I know the Contracts are not CI's. Is the proper way to add fields to the Contract form (AST:AssetSupport) to go directly into the Administrator tool and add the fields? I know the class manager is used for the CI's. I just want to make sure I am following the correct method since I have never performed this. Thanks, Bala Patel Remedy Administrator ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Asset 7.03 - Adding fields To Contracts. AST:AssetSupport
You are right, remember that there are two forms that are joined for each contract. -Original Message- From: Bala Patel patelb...@ymail.com To: arslist@ARSLIST.ORG Sent: Mon, 8 Jun 2009 9:32 am Subject: Asset 7.03 - Adding fields To Contracts. AST:AssetSupport ** All, ? ? I am working with the CMDB 2.0 and Asset Management 7.03.? I am looking into adding fields to the Contracts forms.? I know the Contracts are not CI's.? Is the proper way to add fields to the Contract form (AST:AssetSupport) to go directly into the Administrator tool and add the fields? I know the class manager is used for the CI's. I just want to make sure I am following the correct method since I have never performed this. ? Thanks, ? Bala Patel Remedy Administrator ? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry
I am currently getting these same errors frequently. I have opened a ticket with BMC and they really did not find anything. I am still researching the problem, I will let you know if I find anything. Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frex Popo Sent: Monday, June 08, 2009 4:14 AM To: arslist@ARSLIST.ORG Subject: The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry ** Dear all, ARS. 7.1 patch 4 / OS. NT2003 SRV Edition / DB. MS SQL SRV 2005 It states in the performance and optimisation manual, only one node in a server group should be used as the server for admin changes (i.e forms, workflow etc..) but both should be accessed when making other changes (i.e adding threads to a particular queue). I added two threads to the list queue through the admin tool to node1 and node2 in a server group. I did a restart and got the following errors on both. 390603 : Entry does not exist in database. (ARERR 302) 390603 : The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry:NTG00156348 I enabled the SQL/Filter/API logs and noticed few errors relating to escalation SYS:NPC:IM1-TriggerGroupNTG (attached to form NTE:SYS-NT Process Control) which runs every 1 minute. The escalation updates field z1D Action with the value START GROUP NOTIFICATION. It fails with the first error: 390603 : Entry does not exist in database. (ARERR 302) This action in turn causes a filter NTE:NPC:CreateGroupNTG_050_PNTG to do an insert to form NTE:SYS-Group NT Control which fails with the second error: 390603 : The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry:NTG00156348 When removing the two threads I have added and doing a restart I get no errors. I also noticed that form NTE:SYS-NT Process Control still has some old entries with submit dates as far back as 2007, some 22 of them in total. Regards frex _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
How to expand BMC banner in the form header?
Hi, I added new fields on a OOB form and needed to extend the BMC Banner found on top of the form (This is the blue banner with the BMC REMEDY IT SERVICE MANAGEMENT - xx and the area where you can find the Help and bmcsoftware). I tried to go Form Manage Views Form Properties Appearance tab and tried to Save the image to disk thinking that I will be able to modify the image but when I saved this a .bmp image, i got this error message: No Image Conversion will take place. Save anyway? I clicked Yes. When I accessed the file, it gave me the error: file not found. Has anyone modified the banner before? Can you guide me on how to do this? Is there an existing file created on install that I can modify? Any help is appreciated. Thanks, Tina -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043428p3043428.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to expand BMC banner in the form header?
Try saving it with a different format (EX: jpg / bmp) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of tina flores Sent: Monday, June 08, 2009 10:55 AM To: arslist@ARSLIST.ORG Subject: How to expand BMC banner in the form header? Hi, I added new fields on a OOB form and needed to extend the BMC Banner found on top of the form (This is the blue banner with the BMC REMEDY IT SERVICE MANAGEMENT - xx and the area where you can find the Help and bmcsoftware). I tried to go Form Manage Views Form Properties Appearance tab and tried to Save the image to disk thinking that I will be able to modify the image but when I saved this a .bmp image, i got this error message: No Image Conversion will take place. Save anyway? I clicked Yes. When I accessed the file, it gave me the error: file not found. Has anyone modified the banner before? Can you guide me on how to do this? Is there an existing file created on install that I can modify? Any help is appreciated. Thanks, Tina -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043 428p3043428.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to expand BMC banner in the form header?
Hi Doug, Thanks for the prompt reply. I saved it as .jpg and it worked this time. I'm now editing the banner via Paint. Tanner, Doug wrote: Try saving it with a different format (EX: jpg / bmp) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of tina flores Sent: Monday, June 08, 2009 10:55 AM To: arslist@ARSLIST.ORG Subject: How to expand BMC banner in the form header? Hi, I added new fields on a OOB form and needed to extend the BMC Banner found on top of the form (This is the blue banner with the BMC REMEDY IT SERVICE MANAGEMENT - xx and the area where you can find the Help and bmcsoftware). I tried to go Form Manage Views Form Properties Appearance tab and tried to Save the image to disk thinking that I will be able to modify the image but when I saved this a .bmp image, i got this error message: No Image Conversion will take place. Save anyway? I clicked Yes. When I accessed the file, it gave me the error: file not found. Has anyone modified the banner before? Can you guide me on how to do this? Is there an existing file created on install that I can modify? Any help is appreciated. Thanks, Tina -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043 428p3043428.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043428p3043522.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to expand BMC banner in the form header?
When you save it add .jpg or .jpeg to the end of whatever you are calling your file. -Chris Grassi -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tanner, Doug Sent: Monday, June 08, 2009 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: How to expand BMC banner in the form header? Try saving it with a different format (EX: jpg / bmp) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of tina flores Sent: Monday, June 08, 2009 10:55 AM To: arslist@ARSLIST.ORG Subject: How to expand BMC banner in the form header? Hi, I added new fields on a OOB form and needed to extend the BMC Banner found on top of the form (This is the blue banner with the BMC REMEDY IT SERVICE MANAGEMENT - xx and the area where you can find the Help and bmcsoftware). I tried to go Form Manage Views Form Properties Appearance tab and tried to Save the image to disk thinking that I will be able to modify the image but when I saved this a .bmp image, i got this error message: No Image Conversion will take place. Save anyway? I clicked Yes. When I accessed the file, it gave me the error: file not found. Has anyone modified the banner before? Can you guide me on how to do this? Is there an existing file created on install that I can modify? Any help is appreciated. Thanks, Tina -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043 428p3043428.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Passing variables between Applications and Tasks
According to Support, there is no way to do it with CAI Event configuration alone, you'd have to customize the application. That being said, there is an RFE Pending Review to enhance the TMS for this functionality: RFE SW00329718. Since the work around is simply to use the [View] parent button, the effort to customize hardly seems worth it. Hopefully Engineering feels differently. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahesh Chandra Sent: Friday, June 05, 2009 7:25 PM To: arslist@ARSLIST.ORG Subject: Re: Passing variables between Applications and Tasks --0015174c150e3a1f28046ba4b789 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Our primary user community works only on Incidents or Tasks. Since we completely bypass the Work Order system, we wanted to figure out a way to pass the variables from Work Order to Task but haven=92t had any luck. Even I was successful in passing variables between Tasks but couldn't figur= e out a way to fetch information from the parent system (Work Orders/ Change)= , finally gave up since I had many other critical issues on my plate. As far as my research goes, this would basically require understanding the CAI system and how each Event works. Please share your experience when you are done. Good Luck. Thanks Mahesh On Fri, Jun 5, 2009 at 5:39 PM, Savant, don...@dts donald.sav...@dts.ca.go= v wrote: ** Does anyone know if it=92s possible to pass variable data from ITSM applications (e.g. Change mgmt or Work Orders) to Task and/or Task Groups= ? I=92ve successfully configured variables to pass from one task to another= and from one task group to another but everything I=92ve read appears to be limited within the Task mgmt System(TMS) itself. I haven=92t seen anythi= ng which shows how to pass data from the parent to the task or task group. Thanks in advance. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are --0015174c150e3a1f28046ba4b789 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable ** div p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: VerdanaOur=A0primary user community works only on Incidents or Task= s. Since we completely bypass the=A0Work Order system, we wanted to figure = out a way to pass the variables from Work Order to Task but haven=92t had a= ny luck. /span/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: Verdana=A0/span/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: VerdanaEven I was successful in passing variables=A0between Tasks= =A0but couldn#39;t figure out a way to fetch information from the parent s= ystem (Work Orders/ Change), finally=A0gave up=A0since I had many other cri= tical issues=A0on my plate. /span/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: Verdana=A0/span/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: VerdanaAs far as my research goes, this would basically require und= erstanding the=A0CAI system and how each Event works./span/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptfont face=3DTimes Ne= w Roman=A0/font/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: VerdanaPlease share your experience when you are done. Good Luck./= span/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: Verdanaspan style=3DFONT-FAMILY: Verdana/span/span=A0/p p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: Verdanaspan style=3DFONT-FAMILY: VerdanaThanks/span/span/p= p class=3DMsoNormal style=3DMARGIN: 0in 0in 0ptspan style=3DFONT-FA= MILY: Verdana/spanspan style=3DFONT-FAMILY: VerdanaMahesh/span/p= brbr/div div class=3Dgmail_quoteOn Fri, Jun 5, 2009 at 5:39 PM, Savant, don...@d= TS span dir=3Dltrlt;a href=3Dmailto:donald.sav...@dts.ca.gov;Donald= .sav...@dts.ca.gov/agt;/span wrote:br blockquote class=3Dgmail_quote style=3DPADDING-LEFT: 1ex; MARGIN: 0px 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid**=20 divfont face=3DArial, sans-serif size=3D2 divDoes anyone know if it=92s possible to pass variable data from ITSM ap= plications (e.g. Change mgmt or Work Orders) to Task and/or Task Groups? I= =92ve successfully configured variables to pass from one task to another an= d from one task group to another but everything I=92ve read appears to be l= imited within the Task mgmt System(TMS) itself.=A0 I haven=92t seen anythin= g which shows how to pass data from the parent to the task or task group. T= hanks in advance./div divfont face=3DTimes New Roman, serif size=3D3=A0/font/div/fon= t/div_Platinum
Re: ARS 7.5 Install Question
If you install Tomcat 6 before installing AR System, then you can choose not to install anything as part of the AR System installation. That way, you'll only have Tomcat 6 on the system from the beginning. Both Atrium Core (CMDB) and AR System 7.5.00 support Tomcat 6. It was done this way because AR System 7.5.00 still supports Tomcat 5.5 - so the earliest supported version of Tomcat was included as the JSP engine for IIS users. Atrium Core 7.5.00 has a minimum version of Tomcat 6 and does not support Tomcat 5.5. Note that AR System does not require Tomcat specifically as a JSP engine. You may choose to use another supported JSP engine (e.g. ServletExec) if you wish. Or, if using a web or application server other than IIS, you may use the JSP engine that comes with the web/app server (e.g. JBoss, WebLogic, WebSphere, etc.) as long as they're listed in the Compatibility Matrix. Tomcat was included purely as a convenience to IIS users - who otherwise would have to go find a JSP engine - and is not intended to convey a preference or requirement for AR System. -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, June 05, 2009 8:26 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.5 Install Question ** Mark, This is incomplete, but it might help a little. Tomcat 5.x is used by everything except Web Services and I think AIE, which require Tomcat 6. BMC recommends that the Tomcat 6 components be on another server, for that reason at least. Uninstalling the CMDB does not work with the Uninstaller or the Add/Remove programs. The only way I have found that worked was that there is a cleanup executable buried deep in the install directory (sorry, can't remember the particulars). It does work. I have heard that the fix for that will be in patch 3. Also, do NOT trust the HTML logs as official judges of whether an installation works. They are no longer reliable in that regard in 7.5, especially with Approval and Assignment. Rick On Fri, Jun 5, 2009 at 6:47 PM, Mark Lev mark@rightstarsystems.commailto:mark@rightstarsystems.com wrote: ** Can anyone help me understand and perhaps provide wisdom on this? When I install ARS 7.5 it installs Tomcat 5.x When I install CMDB it installs Tomcat 6.x I don't seem to have any choice in the matter, and I would prefer to use just one version, different ports. When I installed Tomcat 6 manually, neither ARS or CMDB will recognize it. Uninstalling 7.5 is just so much fun, as I discovered. NOT! Nothing like having to go into the registry to remove stuff, no uninstall and/or it doesn't uninstall everything. I must have missed something, don't understand something, or it has not clicked why this makes sense that they do it this way. Windows SQL IIS Patch 01 used to install Thanks, Mark _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ADM:timing test
13:25 EST ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
SRM Help
I am trying to create an SRD that has several PDT's attached. All of the PDT's are executed in the same phase / sequence when the SRD is selected. Each PDT has a different approver and is not dependant of any of the other PDT's. I have read the manuals what seems like a bazillion times and cannot determine how to set this up. AOT approvals? Work Order approvals? Entitlements? Any assistance is greatly appreciated. Thank you ! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Email Error Help Needed
Hi All, I have a very interesting thing happening with incoming email. I have an email that goes out by doing a push field to the AR System Email Messages form. I have to do it this way instead of a notify because the To can be longer than 255 characters. The outbound email goes just fine. Problem is if someone does a reply. The email is received by the mailbox but does not get processed by the Email Engine. In the AR System Email Error Log I get Message number 4952, generated by the AR System Mail Daemon. In the arerror.log file I get a ARERR 20108. All other incoming email to this mailbox works fine. It is only the replies from the email were I am doing the push to the ARS Messages that have a problem. Can't find any reference to the two error message numbers. Any help greatly appreciated, Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to expand BMC banner in the form header?
Tina, The blue banner at the top of most of the OOB forms is just a background image of a blue bar with the BMC logo in the right corner. Before you try a lot of image manipulation, try this: 1- Open the form in ARAdmin 2- Form Menu - Current View - Properties - Appearance. 3- In the background section, change the Horizontal field from Left to Fill. This will stretch the image to the right, and how far is determined by which fields are VISIBLE when the form is displayed. 4- Press OK. You'll see the difference immediately. If you don't like it, don't save it. 5- Save the form If you have added only a narrow field on the right the worst that will happen is that the BMC logo will widen slightly. I have done this with a few forms that I no longer care are exactly 1024x768, and it works well as long as the new view isn't a LOT wider than the old one. If you want to export the image use the Save To Disk button and save it as image.bmp or image.jpg (adding the .bmp file extension yourself. Just type it). You can then modify the saved image in something like Paint or the Snag-it image editor or just about any other graphics program. Of course, BMC might object to distortion of their logo :-) Hope this helps... Doug Blair On Jun 8, 2009, at 9:55 AM, tina flores wrote: Hi, I added new fields on a OOB form and needed to extend the BMC Banner found on top of the form (This is the blue banner with the BMC REMEDY IT SERVICE MANAGEMENT - xx and the area where you can find the Help and bmcsoftware). I tried to go Form Manage Views Form Properties Appearance tab and tried to Save the image to disk thinking that I will be able to modify the image but when I saved this a .bmp image, i got this error message: No Image Conversion will take place. Save anyway? I clicked Yes. When I accessed the file, it gave me the error: file not found. Has anyone modified the banner before? Can you guide me on how to do this? Is there an existing file created on install that I can modify? Any help is appreciated. Thanks, Tina -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043428p3043428.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are Doug -- Doug Blair d...@blairing.com +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are inline: bmc_skilled_pro_ar.png ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: How to expand BMC banner in the form header?
Hi Doug, Thank you for this great tip!!! (using the Horizontal Fill) I'll use this going forward. I tried it and works like a charm. No more screen grabber and editing for me. Have a nice day. Tina Doug Blair wrote: Tina, The blue banner at the top of most of the OOB forms is just a background image of a blue bar with the BMC logo in the right corner. Before you try a lot of image manipulation, try this: 1- Open the form in ARAdmin 2- Form Menu - Current View - Properties - Appearance. 3- In the background section, change the Horizontal field from Left to Fill. This will stretch the image to the right, and how far is determined by which fields are VISIBLE when the form is displayed. 4- Press OK. You'll see the difference immediately. If you don't like it, don't save it. 5- Save the form If you have added only a narrow field on the right the worst that will happen is that the BMC logo will widen slightly. I have done this with a few forms that I no longer care are exactly 1024x768, and it works well as long as the new view isn't a LOT wider than the old one. If you want to export the image use the Save To Disk button and save it as image.bmp or image.jpg (adding the .bmp file extension yourself. Just type it). You can then modify the saved image in something like Paint or the Snag-it image editor or just about any other graphics program. Of course, BMC might object to distortion of their logo :-) Hope this helps... Doug Blair On Jun 8, 2009, at 9:55 AM, tina flores wrote: Hi, I added new fields on a OOB form and needed to extend the BMC Banner found on top of the form (This is the blue banner with the BMC REMEDY IT SERVICE MANAGEMENT - xx and the area where you can find the Help and bmcsoftware). I tried to go Form Manage Views Form Properties Appearance tab and tried to Save the image to disk thinking that I will be able to modify the image but when I saved this a .bmp image, i got this error message: No Image Conversion will take place. Save anyway? I clicked Yes. When I accessed the file, it gave me the error: file not found. Has anyone modified the banner before? Can you guide me on how to do this? Is there an existing file created on install that I can modify? Any help is appreciated. Thanks, Tina -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043428p3043428.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are Doug -- Doug Blair d...@blairing.com +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- View this message in context: http://n2.nabble.com/How-to-expand-BMC-banner-in-the-form-header--tp3043428p3044775.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SRM Help
As far as I know, approvals are defined on SRD and not AOT or PDT. You may want to use an Advanced Interface Form and add custom workflow for this. Thanks Mahesh On Mon, Jun 8, 2009 at 12:32 PM, Tami Palacky tpala...@gmail.com wrote: ** I am trying to create an SRD that has several PDT's attached. All of the PDT's are executed in the same phase / sequence when the SRD is selected. Each PDT has a different approver and is not dependant of any of the other PDT's. I have read the manuals what seems like a bazillion times and cannot determine how to set this up. AOT approvals? Work Order approvals? Entitlements? Any assistance is greatly appreciated. Thank you ! _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Creating the two tables with the add/remove buttons in between to swap data between tables effect
Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and moved to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
The move must modify a field that will eliminate the entry from the first table and then refresh the first table. -Original Message- From: Schryver, Curt cschry...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Mon, 8 Jun 2009 3:28 pm Subject: Creating the two tables with the add/remove buttons in between to swap data between tables effect ** Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and moved to the right, it should no longer appear in the left side.? See image for a better example of what I mean. ? http://arsystem.comxa.com/2tables.jpg ? ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i ? Thanks, ? Curt ? Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com ? ? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Automated Change Requests created from CI Maintenance Schedules
Hello List, I am curious if I am the only person trying to use this functionality. :-) I need to add maintenance schedules to CI's, and have them automatically create change requests (via change templates) based on the schedule type/frequency. BMC said this functionality is not currently available - ITSM Patch 8 due in Feb 2010 will incorporate this features. Has anyone gotten Change Requests automatically genereated via Maintenance Schedules attached to CI's? Thanks, Remedy 7.1 Patch 002 Windows Jase Brandon Quality Technology Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
IE8 on Remedy 7.1 Patch 6
We LONG ago moved most of our window open options to 'New' from 'Current' because of the difference in how previous versions of IE handled remedy's 'Close Window' functionality. This keeps us from having blank search form laying around when we issue close window actions. Anywayrecently had a user upgrade to IE8 and said he has been getting intermittent situations where the window used to close reliably in IE7, but now about half the time doesn't close and he has to close it manually. I'm curious if anyone else has heard similar reports. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
Curt, You have two tables: Table A is on the left, with A.Value referring to what's showing in the list. Table B is on the right, with B.Value as the values. Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like %; + 'A.Value' + ;%) Refresh Table A. The tricky part, if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd | | From: | | --| |Schryver, Curt cschry...@tycoelectronics.com | --| | | To:| | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |06/08/2009 12:28 PM | --| | | Subject: | | --| |Creating the two tables with the add/remove buttons in between to swap data between tables effect | --| | | Sent by: | | --| |Action Request System discussion list(ARSList) arslist@ARSLIST.ORG | --| ** Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and moved to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
7.X Developer Needed
Site-R in Emmitsburg, MD, has an urgent need for a Remedy Developer. The position can be located on www.catapulttechnology.com . If you, or anyone know, with version 7 experience is looking, will you forward this on to them. Lawrence Parker IT Service Support Tools EDS Remedy Engineering 1968 Gilbert Street Norfolk, VA 23511 Tel: +1 757 963-1008 Mobile: +1 757 285-2368 E-mail: lawrence.par...@nmci-isf.com We deliver on our commitments so you can deliver on yours. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
I would do it slightly different. Left would be a join of Left and Right...the join would be something like SELECT left.description FROM left, right Where left.description not in ( select right.description from right ) And the table on the right would be just a regular display of what's on the right The SQL above isn't tested...and more sudo code than actual...but should work depending on your db and version. Then when you add from left to right, refresh both tables...the item you just added to the right should be removed from the left, and vis versa if removing from the right. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect Curt, You have two tables: Table A is on the left, with A.Value referring to what's showing in the list. Table B is on the right, with B.Value as the values. Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like %; + 'A.Value' + ;%) Refresh Table A. The tricky part, if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd | | From: | | --- ---| |Schryver, Curt cschry...@tycoelectronics.com | --- ---| | | To:| | --- ---| |arslist@ARSLIST.ORG | --- ---| | | Date: | | --- ---| |06/08/2009 12:28 PM | --- ---| | | Subject: | | --- ---| |Creating the two tables with the add/remove buttons in between to swap data between tables effect | --- ---| | | Sent by: | | --- ---| |Action Request System discussion list(ARSList) arslist@ARSLIST.ORG | --- ---| ** Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and moved to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
This one is almost there. It will break when you have values in the table that are substrings of other rows or values in the table that are the same value as other rows. Try adding this to Thad's response: - Add a hidden column in the table for the instanceid for both tables - Store the list of values in the char field as described (but store the instanceid for each record, not a text value); - create a new display-only field to store an external qual (qualfield) - parse the semi-colon separated list of values and generate a qualification, e.g.: '179' = guid1 OR '179' = guid2 ... Set the left table to use External Qual: NOT(EXTERNAL($qualfield$)) Set the right table to use External Qual: (EXTERNAL($qualfield$)) You will need to set the qualfield to 1=1 if it gets set null. The one limitation is that the qual can only be 4k chars on Oracle. Not sure of where clause limits with SQL Server and others. Assuming a 30 char instanceid and the overhead of the rest of the qualification (14 chars), you will be limited to a selection of ~90 items. If ARS supported using IN, the list could be longer at ~121 items. You could opt to use the entry_id instead of the instanceid, which would buy you more selections (137, or 222 if ARS supported IN sql token), the key here is to use a unique value to represent the selection of each record. Failure to adhere to this will result in breakage at some point. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 8, 2009 at 3:22 PM, Thad K Essertkes...@regence.com wrote: Curt, You have two tables: Table A is on the left, with A.Value referring to what's showing in the list. Table B is on the right, with B.Value as the values. Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like %; + 'A.Value' + ;%) Refresh Table A. The tricky part, if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd | | From: | | --| |Schryver, Curt cschry...@tycoelectronics.com | --| | | To: | | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |06/08/2009 12:28 PM | --| | | Subject: | | --| |Creating the two tables with the add/remove buttons in between to swap data between tables effect |
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
LJ, Wouldn't that be something like: SELECT description FROM left MINUS SELECT description FROM right That should give you unique values on left that are not in unique values from right Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect I would do it slightly different. Left would be a join of Left and Right...the join would be something like SELECT left.description FROM left, right Where left.description not in ( select right.description from right ) And the table on the right would be just a regular display of what's on the right The SQL above isn't tested...and more sudo code than actual...but should work depending on your db and version. Then when you add from left to right, refresh both tables...the item you just added to the right should be removed from the left, and vis versa if removing from the right. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect Curt, You have two tables: Table A is on the left, with A.Value referring to what's showing in the list. Table B is on the right, with B.Value as the values. Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like %; + 'A.Value' + ;%) Refresh Table A. The tricky part, if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Schryver, Curt Sent: Monday, June 08, 2009 2:28 PM To: arslist@ARSLIST.ORG Subject: Creating the two tables with the add/remove buttons in between to swap data between tables effect Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and moved to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
I agree that InstanceIDs would be better, however my code wouldn't break unless the values themselves had semi-colons in them. ;eBiz; wouldn't overlap ;eBiz eCommerce; (note the semicolons at the beginning and ending of each value in the list - as well the role they play in the qualification). But yeah, use the instance ids if you have them available (or make 'em available). Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd | | From: | | --| |Axton axton.gr...@gmail.com | --| | | To:| | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |06/08/2009 02:27 PM | --| | | Subject: | | --| |Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect | --| | | Sent by: | | --| |Action Request System discussion list(ARSList) arslist@ARSLIST.ORG | --| This one is almost there. It will break when you have values in the table that are substrings of other rows or values in the table that are the same value as other rows. Try adding this to Thad's response: - Add a hidden column in the table for the instanceid for both tables - Store the list of values in the char field as described (but store the instanceid for each record, not a text value); - create a new display-only field to store an external qual (qualfield) - parse the semi-colon separated list of values and generate a qualification, e.g.: '179' = guid1 OR '179' = guid2 ... Set the left table to use External Qual: NOT(EXTERNAL($qualfield$)) Set the right table to use External Qual: (EXTERNAL($qualfield$)) You will need to set the qualfield to 1=1 if it gets set null. The one limitation is that the qual can only be 4k chars on Oracle. Not sure of where clause limits with SQL Server and others. Assuming a 30 char instanceid and the overhead of the rest of the qualification (14 chars), you will be limited to a selection of ~90 items. If ARS supported using IN, the list could be longer at ~121 items. You could opt to use the entry_id instead of the instanceid, which would buy you more selections (137, or 222 if ARS supported IN sql token), the key here is to use a unique value to represent the selection of each record. Failure to adhere to this will result in breakage at some point. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 8, 2009 at 3:22 PM, Thad K Essertkes...@regence.com wrote: Curt, You have two tables: Table A is on the left, with A.Value referring to what's showing in the list. Table B is on the right, with B.Value as the
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
It may work, if I was familiar with the minus command...:)I'll hafta read up on that one :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect LJ, Wouldn't that be something like: SELECT description FROM left MINUS SELECT description FROM right That should give you unique values on left that are not in unique values from right Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect I would do it slightly different. Left would be a join of Left and Right...the join would be something like SELECT left.description FROM left, right Where left.description not in ( select right.description from right ) And the table on the right would be just a regular display of what's on the right The SQL above isn't tested...and more sudo code than actual...but should work depending on your db and version. Then when you add from left to right, refresh both tables...the item you just added to the right should be removed from the left, and vis versa if removing from the right. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect Curt, You have two tables: Table A is on the left, with A.Value referring to what's showing in the list. Table B is on the right, with B.Value as the values. Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like %; + 'A.Value' + ;%) Refresh Table A. The tricky part, if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Schryver, Curt Sent: Monday, June 08, 2009 2:28 PM To: arslist@ARSLIST.ORG Subject: Creating the two tables with the add/remove buttons in between to swap data between tables effect Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and moved to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ODBC Driver 7.1
Hi All - I am trying to install the Remedy User Tool (7.1 p 6) and when I go to the ODBC Data Source Admin console and try to add a System DSN I can't find the AR System ODBC Driver. I looked in the install folder and the dll is there but if I look in the registry it doesn't find it. Any ideas? I have tried to uninstall the client and reinstall (3 times) and same thing. If I look in User DSN I do see it but I can't open it. I get a registry component is missing. I am trying to install this on my Crystal Reports Server XI R2 server so I can run web reports. Window 2003 64 bit IIS / Tomcat Java 1.5_16 MidTier's ARWebReportViewer 7.1 p 6 Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst cparge...@lhs.org System Office tel: 503-415-5149 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
You may have better luck with NOT EXISTS. Axton On Mon, Jun 8, 2009 at 5:08 PM, LJ Longwinglj.longw...@gmail.com wrote: It may work, if I was familiar with the minus command...:)I'll hafta read up on that one :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect LJ, Wouldn't that be something like: SELECT description FROM left MINUS SELECT description FROM right That should give you unique values on left that are not in unique values from right Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect I would do it slightly different. Left would be a join of Left and Right...the join would be something like SELECT left.description FROM left, right Where left.description not in ( select right.description from right ) And the table on the right would be just a regular display of what's on the right The SQL above isn't tested...and more sudo code than actual...but should work depending on your db and version. Then when you add from left to right, refresh both tables...the item you just added to the right should be removed from the left, and vis versa if removing from the right. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect Curt, You have two tables: Table A is on the left, with A.Value referring to what's showing in the list. Table B is on the right, with B.Value as the values. Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like %; + 'A.Value' + ;%) Refresh Table A. The tricky part, if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Schryver, Curt Sent: Monday, June 08, 2009 2:28 PM To: arslist@ARSLIST.ORG Subject: Creating the two tables with the add/remove buttons in between to swap data between tables effect Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and moved to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect
Right you are. Some days the brain doesn't work as good as others. I tend to (always) go for the options that should never break. Axton On Mon, Jun 8, 2009 at 4:40 PM, Thad K Essertkes...@regence.com wrote: I agree that InstanceIDs would be better, however my code wouldn't break unless the values themselves had semi-colons in them. ;eBiz; wouldn't overlap ;eBiz eCommerce; (note the semicolons at the beginning and ending of each value in the list - as well the role they play in the qualification). But yeah, use the instance ids if you have them available (or make 'em available). Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd | | From: | | --| |Axton axton.gr...@gmail.com | --| | | To: | | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |06/08/2009 02:27 PM | --| | | Subject: | | --| |Re: Creating the two tables with the add/remove buttons in between to swap data between tables effect | --| | | Sent by: | | --| |Action Request System discussion list(ARSList) arslist@ARSLIST.ORG | --| This one is almost there. It will break when you have values in the table that are substrings of other rows or values in the table that are the same value as other rows. Try adding this to Thad's response: - Add a hidden column in the table for the instanceid for both tables - Store the list of values in the char field as described (but store the instanceid for each record, not a text value); - create a new display-only field to store an external qual (qualfield) - parse the semi-colon separated list of values and generate a qualification, e.g.: '179' = guid1 OR '179' = guid2 ... Set the left table to use External Qual: NOT(EXTERNAL($qualfield$)) Set the right table to use External Qual: (EXTERNAL($qualfield$)) You will need to set the qualfield to 1=1 if it gets set null. The one limitation is that the qual can only be 4k chars on Oracle. Not sure of where clause limits with SQL Server and others. Assuming a 30 char instanceid and the overhead of the rest of the qualification (14 chars), you will be limited to a selection of ~90 items. If ARS supported using IN, the list could be longer at ~121 items. You could opt to use the entry_id instead of the instanceid, which would buy you more selections (137, or 222 if ARS supported IN sql token), the key here is to use a unique value to represent the selection of each record. Failure to adhere to this will result in breakage at some point. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations