ARS 7.1.0 patch 004
Hello List, We are currently on ARS 6.3/MT 6.3/FB 6.3 on Solaris 8,9i(Unicode) database and have a custom built application.We would like to move to ARS 7.1 p4,primarily to support Japanese and German languages and also to not fall off-support with the release of the new 7.5 version. I would like members of this community who have upgraded/installed 7.1,to give suggestions/inputs on some concerns below and other details that you think are relevant. 1. Is Windows platform a better option considering stability, support and maintainence? 2. Should we go for incremental upgrade from 6.3, or have a fresh install and then move the code and data?Will there be any issues of any workflow or service not working after moving the code? 3. Are there any issues with multilingual data in one server, as version prior to 7.0 needed one server instance for one language. Thanks, Veerain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Resolving dynamic field references in a Set field action
Hi Eric, Thanks for all your help..:) Regards, Veerain On 1/18/08, Roys, Eric [EMAIL PROTECTED] wrote: ** Veerain, FYI, The simple example I provided for you can now be found on developer.bmc.com ( http://developer.bmc.com/jiveProd/entry.jspa?externalID=2798categoryID=506 ) Happy coding J -Eric -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Veerain G *Sent:* Friday, January 04, 2008 1:16 AM *To:* arslist@ARSLIST.ORG *Subject:* Resolving dynamic field references in a Set field action ** Hello Listers, ARS and MT 6.3 Solaris I have trying to add content to a field on one form which has references to fields of another form and then read this content through workflow. Consider the following scenario.I have 2 regular forms A and B. *Form A* :Character field-* FormAfield1,* *Form B* :Character fields -*FormBfield2*,Ticket ID,Company,Button field-* button1* In Form A the field *FormAfield1* has some text and references to fields from form B For e.g in *FormAfield1* I have, This is a test for $Ticket ID$ and Company $Company$ If I write an activelink on Form B Button1 to read *FormAfield1 *value from Form A to *FormBfield2*,the field references do not get populated with the record values on Form B. Is there any way to resolve the dynamic fields(Ticket ID and Company) from *FormAfield1,* when reading values through a Set fields Action?Or is this even possible? Kindly Help! Thanks and Regards, Veerain __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Resolving dynamic field references in a Set field action
Hello Listers, ARS and MT 6.3 Solaris I have trying to add content to a field on one form which has references to fields of another form and then read this content through workflow. Consider the following scenario.I have 2 regular forms A and B. *Form A* :Character field-* FormAfield1,* *Form B* :Character fields -*FormBfield2*,Ticket ID,Company,Button field-* button1* In Form A the field *FormAfield1* has some text and references to fields from form B For e.g in *FormAfield1* I have, This is a test for $Ticket ID$ and Company $Company$ If I write an activelink on Form B Button1 to read *FormAfield1 *value from Form A to *FormBfield2*,the field references do not get populated with the record values on Form B. Is there any way to resolve the dynamic fields(Ticket ID and Company) from * FormAfield1,* when reading values through a Set fields Action?Or is this even possible? Kindly Help! Thanks and Regards, Veerain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Reporting using BI Cognos
Hello Listers, Ben and Terry,thanks for your replies. Yes I do agree that we can connect without using the AR ODBC driver. I have tried to connect to Cognos through the Database directly and not using the Oracle driver.I used some functions to convert the integer date and the selection fields which are numeric. Are are any other hindrances or field types that have to be taken care of when reporting directly or through the Oracle driver? Any suggestions/tips and tricks will be of great help. Cognos mentions that it supports ODBC 3.5 and above, but even with the ARODBC70 it does not seem to work.Just thought of checking if any of the AR listers has been successful with Cognos and AR ODBC. Thanks and Regards, Veerain On 9/20/07, Ben Cantatore [EMAIL PROTECTED] wrote: Ok, I think I understand the reluctance, yes, you see the tables and their cryptic names. The key is to ignore the tables and report of the views, which off of my oracle ODBC driver, I'm able to do just fine. Perhaps the solution for you is to create a simple report with the Oracle driver and show them and see how they respond. Ben Cantatore Remedy Administrator Avon (914) 935-2946 *Terrence D Paskiewicz [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/19/2007 12:25 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Reporting using BI Cognos That's how we feel too. Unfortunately, our Remedy Support Team doesn't agree and we're limited to using the Remedy ODBC driver. One question: If you use an Oracle ODBC driver, do you see the table names and field names, or are you looking at table numbers and field numbers? - Terry -- Sr. Business Systems Analyst Corporate Information Technology ITCS Reporting Services Abbott 200 Abbott Park Road Dept: GA67, Bldg: NWJ46 Abbott Park, IL 60064-6370 Phone (847)937-1889* [EMAIL PROTECTED] [EMAIL PROTECTED] -- This communication may contain information that is proprietary, confidential, or exempt from disclosure. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. *Ben Cantatore [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/19/2007 11:17 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Reporting using BI Cognos Since you're not reporting within Remedy, I see absolutely no reason why you shouldn't use an Oracle driver to report on the data. Ben Cantatore Remedy Administrator Avon (914) 935-2946 *Terrence D Paskiewicz [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/19/2007 11:26 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Reporting using BI Cognos Hello Veerain, Please forgive my lack of Remedy terminology - I'm a report developer, not a Remedy admin or developer. We have some people here trying to do the same thing using Cognos 8.2. They attempted to connect via the Remedy ODBC but were not successful. Cognos 8.2 requires ODBC drivers to be compliant with ODBC spec 3.5 or higher. The Remedy-supplied ODBC drivers from AR 6.0 and 6.3 are written to an ODBC spec lower than 3.5. According to Remedy AR 7.0 release notes, the ODBC driver is enhanced and has ODBC spec 3.5 compatibility. I hope this helps. - Terry Let's see... Remedy AR 6.0.3 HP Ux 11 Oracle 10g -- Sr. Business Systems Analyst Corporate Information Technology ITCS Reporting Services Abbott 200 Abbott Park Road Dept: GA67, Bldg: NWJ46 Abbott Park, IL 60064-6370 Phone (847)937-1889* [EMAIL PROTECTED] [EMAIL PROTECTED] -- This communication may contain information that is proprietary, confidential, or exempt from disclosure. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. *Veerain G [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/18/2007 11:43 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Reporting using BI Cognos ** Hello Listers, ARS 5.1.2.and ARS 6.3 Oracle 9i Solaris We have BI Cognos 8.2 used for reporting in our organisation.Could Cognos be used for Remedy reporting
Can we have dynamic form titles?
Hello Listers, ARS 5.1.2 and ARS 6.3 Oracle 9i Solaris Midtier 5.1.2 in-house helpdesk application. Is it possible to pass parameters to the form alias.For a view of a form I give an alias in the View propertiesaliases and labels.Here i am not able to specify a dynamic value.Suppose when the user opens a record the form title should read as 'Ticket info for $Company$', where $Company$ should be the company name value for that ticket that has been opened. Any thoughts on how this could be done? Thanks and Regards, Veerain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Can we have dynamic form titles?
Hello Listers, Sorry i missed stating that I am trying to work on a display only form.Thisform does not hold any value in the View PropertiesRequest Identifier field. Carey,I will try on mid tier as per your suggestions. Thanks to you and Mark. I am also trying this on the User tool. Any further ideas on how to get this working? Thanks and Regards, Veerain On 9/20/07, Worley Mark A Ctr 2 SOS/SYOS [EMAIL PROTECTED] wrote: Veerain, Actually, it can be done, but at a cost. In the View Properties | Request Aliases, you can change the Request Identifier to a different field. By playing with this and the aliases, you can make the title display as you've requested. The cost is that the ticket number is no longer displayed in the title. I suppose you could get around this by creating a hidden field, and workflow to update it, that has all the data you want for the title... HTH Mark //SIGNED// MARK A. WORLEY, Contractor, 2 SOS/SYOS Remedy ARS Support, SAIC Commercial: (402) 294-8226 DSN: 271-8226 mailto:[EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, September 20, 2007 09:26 To: arslist@ARSLIST.ORG Subject: Re: Can we have dynamic form titles? Veerain, If you only care about the Mid-Tier then I think there might be a way to do this after the form is populated with data that could supply a $Company$ value. There is a special clause in the Active Link Run Process action that understands (for the Mid-Tier) that any Run Process starting with javascript: is actually a call to javascript. My understanding/guess is that the special prefix is striped from the Run Process action and the remaining values are evaluated in the javascript eval() function. So if you know the DHTML to change the title for a page, and your browser supports it... then you should be able to do this. Lot's of if's in there... but you might be dealing with multiple browsers, and I have no idea if the title attribute for a page can be dynamically changed. But you have a shot at making it work all the same. HTH. -- 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 9/20/07, Veerain G [EMAIL PROTECTED] wrote: ** Hello Listers, ARS 5.1.2 and ARS 6.3 Oracle 9i Solaris Midtier 5.1.2 in-house helpdesk application. Is it possible to pass parameters to the form alias.For a view of a form I give an alias in the View propertiesaliases and labels.Here i am not able to specify a dynamic value.Suppose when the user opens a record the form title should read as 'Ticket info for $Company$', where $Company$ should be the company name value for that ticket that has been opened. Any thoughts on how this could be done? Thanks and Regards, Veerain __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Reporting using BI Cognos
Hello Listers, ARS 5.1.2.and ARS 6.3 Oracle 9i Solaris We have BI Cognos 8.2 used for reporting in our organisation.Could Cognos be used for Remedy reporting. Is there anyone who has been able to create Remedy reports in Cognos by connecting through the Remedy ODBC? Any suggestions/pointers to get this working would be highly appreciated. I have searched through the archives and do not find much help in there.Myearlier posts on this have not got any replies,so just trying again! Please help!!! Thanks and Regards, Veerain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ARS reporting using Cognos
Hello Everyone, I had posted this message a couple of days back. Is there anyone who is using Cognos for creating reports from Remedy? The ODBC connection does not seem to work here.Is there any other way to connect and get reports. Any help on this issue will be greatly apprecated. Thanks and Regards, Veerain -- Forwarded message -- From: Veerain G [EMAIL PROTECTED] Date: Aug 15, 2007 11:44 AM Subject: ARS reporting using Cognos To: arslist@arslist.org Hello Listers, I have a question regarding Cognos connection to ARS.Is it possible to get reports off Remedy through Cognos,by connecting to Remedy using the ARS ODBC? Cognos support mentions that it could connect to any ODBC with specification of 3.5 or higher. ARS 5.1.2,Oracle 9i,Solaris,Cognos 8 Thanks and Regards, Veerain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ARS reporting using Cognos
Hello Listers, I have a question regarding Cognos connection to ARS.Is it possible to get reports off Remedy through Cognos,by connecting to Remedy using the ARS ODBC? Cognos support mentions that it could connect to any ODBC with specification of 3.5 or higher. ARS 5.1.2,Oracle 9i,Solaris,Cognos 8 Thanks and Regards, Veerain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are