Re: Estimation for Remedy development

2006-12-07 Thread Ramya Mudambi
Hi Jason, I have worked on the remedy estimator model. The estimation would vary from one requirement to the other. Pls. have a look at the attached estimator... This is one of the simplest ways... depends how complex u would like to make it :-) Have a great day ! With regards,

Check for duplicate values while creating tkts automatically in HD

2006-12-07 Thread Ananthakrishnan
Hi, I have one requirement in my present project. Here the tickets are getting created automatically by reading the values from an .csv file. This is currently being done as follows : 1) I have created one temporary form which stores the values which are read from the .csv file (by using

Java Extended API for J2SE5.0 ?

2006-12-07 Thread Julio Lima
Hi, I was wondering if anybody have heard anything like an API more elaborated than the supplied by Remedy. For example, using Java 5 Annotation Feature, automatic conversion from AR Data Types to Java (or JDBC) Data Types, Connection Pooling, Caching, etc. Regards, JLima

Re: Daylight savings time again

2006-12-07 Thread Mike White
I need to chime-in on this as well. I've read that there are patches for 6.3 and 7.0. How about 6.0? As I understand it, this release is on the cusp, but still supported. It'll go end-of-life (unsupported) when ARS 7.5 is released - later in 2007. It seems to me that there should be a patch

Re: Daylight savings time again

2006-12-07 Thread Barber, Sue
Since Remedy people are reading this, when I called Remedy support about this about 2 weeks ago, I was told there was no patch and none needed - just to make sure the system and java are all patched. It is a good thing this list is here or we might have been really unhappy campers!

Re: Fwd: Question: SQL

2006-12-07 Thread Ashton, Jim (JUS)
What event is the filter attached to? What happens if you add a 2nd attachment to a particular request? Does it return 1 if you do? -Original Message- From: Tyrone Dee [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 06, 2006 3:32 PM To: Ashton, Jim (JUS); arslist@ARSLIST.ORG Subject:

Re: Check for duplicate values while creating tkts automatically in HD

2006-12-07 Thread Misi Mladoniczky
Hi, Your design seems good. Have you checked the logfiles? One guess is that the order of execution is mixed up. Or you may have missed the Merge-execute-on-checkbox. Why use SQL when you can do an ordinary Set-Fields-From-Form-Call? I usually use $LASTCOUNT$ instead of checking tmp-fields.

Re: Fwd: Question: SQL

2006-12-07 Thread Tyrone Dee
Hey Jim - thanks for your help - much appreciated ! I have an attachment pool - with 10 attachments and right now I am only trying it on one of the attachments to see if my SQL statement is correct. I only have on filter that fires on modify - executing at 500. Set Fields - Read Value from SQL

Re: OT: Remedy HTML Email and Outlook 2007

2006-12-07 Thread patrick zandi
Stephen, Have you made your server allowed in the trusted zone ? Have you made your blocker allowed from that server ? I have not tested 2007 yet, however the whole thing is integrated into Word heavily. I leave all my Pictures on the server website, and when they get emails.. it just points

Re: Fwd: Question: SQL

2006-12-07 Thread Jim Ashton
What if you try an active link that executes on After Modify instead? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are

Re: Fwd: Question: SQL

2006-12-07 Thread Heider, Stephen
Have you tried: Action 1 (if run from a filter): Set Fields zTmpField1 = UPPER($File1$) Action 1 (if run from an active link): Set Fields zTmpField1 = UPPER($File1$) WHERE RequestID = $RequestID$ Action 2: Set Fields SQL SELECT CHARINDEX('SOW', $zTmpField1$) and store to zTmpInt1 After it

Web service - Qualification syntax?

2006-12-07 Thread Mathieu Pitre
Hi all, ARS6.3 I am trying to create a web service on a form and I am wondering if I can have one operation set which can use multiple type of query. Let me explain what I am trying to do here... The web service is using an inventory form that contains most of the information related to our

Table Color with Editable Columns

2006-12-07 Thread L. J. Head
Remedy 6.3 Midtier 6.3 Patch 15 I have a table with a result color of Red for certain rows in the table. One of the columns is set to Editable. When I look at this in Firefox the entire row is red. When I look at this in IE the entire row is red with exception of the 'editable' column. Any

Re: Fwd: Question: SQL

2006-12-07 Thread Tyrone Dee
That is a great idea, but I have 16 attachments in my attachment pool and I really don't want to create 16 temporary fields because users can and do add more then one attachment at a time. The user wants me to check for key letters in a file name and send him an email only when new files or

Remedy ARS 7.01 and ITSM 7.X Education Plans

2006-12-07 Thread Lammey, Peter A.
We are planning to start our project to look to upgrade our ARS 6.3 and ITSM 5.6 apps to ARS 7.01 and ITSM 7.1 starting early next year. Ive been looking at the training programs on the Supportweb but there seems to be quite a few classes scheduled but I am not sure what would be the most

Re: Fwd: Question: SQL

2006-12-07 Thread Heider, Stephen
You could use 1 temp field with 32 filters/active links (16 to set the temp field and 16 to check the temp field right after). Another option is to create SQL function in your database and pass in all the filenames (separate by a semi-colon or similar character) along with the text to search.

Re: Remedy ARS 7.01 and ITSM 7.X Education Plans

2006-12-07 Thread Tony Worthington
I did/am doing the same track, with the exception of the AR class. Plus Asset SLM. I'll be going to SD/Change next week, so I can't speak of its value yet, but I wouldn't think about touching CMDB2 without the implementation/best practices class. You'll also want the ITSM7 App Admin

Re: Remedy ARS 7.01 and ITSM 7.X Education Plans

2006-12-07 Thread Rick Cook
Peter, it really all depends on when BMC will allow non-partners to actually take the ITSM 7 classes. As far as I know, that hasn't happened yet, though they keep saying soon. So my suggestion would be to run this past the Head Cheese(s) at BMC Education, and see what (s)he says about it. Rick

Re: Web service - Qualification syntax?

2006-12-07 Thread Carey Matthew Black
Mathieu, It should work. If everything is done right. So I am not sure where your issue is. However here is where I would start my testing. (HTH) Verify that: the form field 'AssetTag' is a field that holds data(NOT-Display Only) on your target form the value your passing to the WebService

Re: Check for duplicate values while creating tkts automatically in HD

2006-12-07 Thread Carey Matthew Black
Why use a Set Field action when the qualification can be part of the Push action? A Push action is normally a Search followed by one of the following a Create, Update first, Update all, or Do Nothing. It seems to me that your trying to hard to make something that is simple to complicated.

Re: COM Automation

2006-12-07 Thread Hall Chad - chahal
Very interesting idea. But one of our goals is to allow a separate team of application testers to write their own test scripts without the need for any actual Remedy development. Our developers don't really have the extra cycles to define test scripts in active link guides. They're hoping to

Re: OT: Remedy HTML Email and Outlook 2007 - Work-Around

2006-12-07 Thread Heider, Stephen
I found some more information. It's not good news. Outlook 2007 introduced a new model for rendering HTML email. It no longer uses Internet Explorer, it uses Word 2007 and Word 2007 does not support certain HTML elements. As such, you can't use an email that contains a form with a submit

Re: Web service - Qualification syntax?

2006-12-07 Thread Mathieu Pitre
Carey, Looks like there is an issue with the qualification because if I split both the qualification is two is works: 1- Original qualification: ('Server-Name' = XPATH(/ROOT/Server-Name)) OR ('AssetTag' = XPATH(/ROOT/AssetTag)) This one works only with the server-name 2- Qualification

Re: Identify which filter created a notification

2006-12-07 Thread Jesse Kona
I wrote a control panel that can search the metatables. It can search for notifications by a string in the subject or the body, or by recipient. The defs are about 1 meg zipped, so I won't send it to the list, but it is in the Developer Downloads section of the BMC supportweb under the name

Re: ITSM 7.01 - Install Takes LONG time

2006-12-07 Thread Ross Mitcham
The first install of the application will always take longer than the subsequent installs. Depending on the configuration of the database, the timeframes that you are talking about 3+ hours are not abnormal. The first install always takes longer as it needs to install the Asset Lite forms and

Re: AR7 Categorizations

2006-12-07 Thread Tim Richardson
Hi Tony, At one of our clients we're doing the same thing. We've discussed the ITIL approach of services that run over telecom equipment as well as the appropriate CMDB Class structures to use. We've played around with issues such as what location is affected if the telecom equipment

Re: ITSM 7.01 - Install Takes LONG time

2006-12-07 Thread Mike Parker
Hi Ross: Is it true that you only need to install the DSL data once? I looked at a different installation (with the 7.00 apps) and the *.arx files that it uses for the DSL data were identical in every respect - which would lead me to believe that you only need to do it once... From: Ross

Re: Anyone using cmdb2.0.1/Asset 7.0 patch 2 and extended the cmdb?

2006-12-07 Thread Tim Richardson
Hi Cindy, Send me an email ([EMAIL PROTECTED]) We've got this configuration in place at a couple of our clients and have had some problems, but not the one you are talking about. In fact, we're getting ready to move to patch 003 at one client... There were some tricks we had to

Re: Estimation for Remedy development

2006-12-07 Thread parikshit saxena
Hi Ramya Could you please throw some more light on the process to use this estimator? I was not able to understand by just viewing at the xls. Thanks Parikshit - Original Message From: Ramya Mudambi [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, 7 December, 2006 2:16:55 PM

Re: AR7 Categorizations

2006-12-07 Thread Danny Butler
I tend to agree that there are no current Best Practices for categorizations. With AR6, we really used no rhyme or reason for CTI. The result is that we now have categorizations that are meaningless and make reporting extremely difficult. In our upgrade process, we have been through much debate

A Sybase question

2006-12-07 Thread Maria Elena Hernandez
Hi there, I've seen a lot of status as Maintenance Token running the sp_who command. The problem is, my user conecctions are running out, what cand I do? Does anyone can help me? Mariel - Este mensaje y cualquier archivo que se adjunte al mismo es

Report to file via Mid-tier

2006-12-07 Thread Mike Balogh
Hi - I know this question has been asked in the past but I have been unable to find any specific answers. I am working with a client on ARS version 6.3 and am looking for a way within Mid-tier to produce a report export to file by pushing a single button. Query criteria and the report format

Question about Groups

2006-12-07 Thread Heynewgirl
I have a problem that many of you might find easy. But I am stumped. In my environment we do not have queue managers. All the tickets go thru the help desk. In late August I loaded 6.3 onto a new server. When we were running our previous version ( 5.5), rules were turned off so that basically

Re: ARS 7.0 Install as non-root user

2006-12-07 Thread Dwayne Martin
I am planning to install ARS 7.0.01 as non-root on a Red-Hat Linux server (Oracle 10 db). I came upon the exchange shown below, which suggests installing as root, then changing the object ownerships afterwards. The only disadvantage I see is that I would need to get root permissions, which I

Re: Question about Groups

2006-12-07 Thread Rick Cook
Hmmm...several suggestions come to mind, most of which involve the creative use of a pen or other sharp office utensils. But seriously... The easy way would be to disable the filters that send out the notifications, and make copies of them with this group exempted from the Run If qualification.

Re: Question about Groups

2006-12-07 Thread Heynewgirl
You just described my situation exactly. They have infact put a ban on their use of Remedy until this is fixed. I am about to use the sharp implement on myself. Your last line sums this situation up my problem correctly. On Dec 7, 11:39 am, Rick Cook [EMAIL PROTECTED] wrote: Hmmm...several

Re: Question about Groups

2006-12-07 Thread Jason Miller
Must love your users, Must love your users. You could also try using a filter on the AR System Email Messages form to manipulate the TO: field or delete the record all together. I have used this in my dev environment to route all emails to myself that were not sent to me or users who have

Re: ARS 7.0 Install as non-root user

2006-12-07 Thread Dwayne Martin
Thank you, Axton! This is very helpful Dwayne Original message Date: Thu, 7 Dec 2006 14:50:28 -0500 From: Axton [EMAIL PROTECTED] Subject: Re: ARS 7.0 Install as non-root user To: arslist@ARSLIST.ORG ** Installing as non-root works well on solaris for the 7.0.01 release.

Re: Question about Groups

2006-12-07 Thread ARSList
We had a similar situation, although not quite as complex as yours. If your manager does not want to get email from the new group (1) and does not want to show up in the group drop-down (2), why is the manager in that group? 1. doesnt want to get any email from this group. 2. does not want to

Re: Crystal report formula requirement

2006-12-07 Thread ARSList
Maybe I forgot - looking at it again: You can either create sub-report as part of an existing report, OR you can create a subreport separately and save it. Then you can add that sub-report into another Report. This is where I forgot, that you can not literally take only a section of

Re: Report to file via Mid-tier

2006-12-07 Thread ARSList
I thought this could be done in ARS 6.3 (not sure about a single click) using Crystal Reports Enterprise. Nick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Balogh Sent: Thursday, December 07, 2006 10:25 AM To:

Re: OT subscribing to ARSLIST?

2006-12-07 Thread ARSList
I am trying to subscribe under a different user/email and it appears that I cannot subscribe to ARSLIST.org I can sign-up and set my email, but when I look at SUBSCRIBER's CORNER, I get either You are not subscribed to any lists on this server. or when I do a SHOW All Lists I get: There are

Re: Daylight savings time again

2006-12-07 Thread Easter, David
Hi Mike, As per the posted web page, 6.0.1 users will be affected but no DST patch will be made available for the 6.0.1 release. Only 6.3 and 7.0.01 are to be patched. Unfortunately, the affected libraries in 6.0.1 (and 5.1.2) are not being patched by the vendor that supplies BMC with those

Re: Archiving Data in Remedy

2006-12-07 Thread Guillaume Rheault
Mike, For Oracle 9i, 10g you can move a table online, which has the effect of reorganizing the table. Since this operation is online, the table is still available, since a copy of it is done in memory, and this copy is the one accessed, while the reorging occurs. You can also rebuild indexes

Re: Question about Groups (U)

2006-12-07 Thread Heynewgirl
yes they want to receive their own email just not all the others. In our environment everyone in IT got everysingle email. We are small and thats what the rule was and will continue to be. She wants the ability to transfer tickets to groups she isnt a part of. So now that I am thinking ...she

Re: OT subscribing to ARSLIST?

2006-12-07 Thread Axton
http://listserv.rbugs.com/cgi-bin/wa.exe?SUBED1=arslistA=1 On 12/7/06, ARSList [EMAIL PROTECTED] wrote: ** I am trying to subscribe under a different user/email and it appears that I cannot subscribe to ARSLIST.org I can sign-up and set my email, but when I look at SUBSCRIBER's CORNER, I

Re: Daylight savings time again

2006-12-07 Thread Axton
Who is the third party and are you still using their products? Axton Grams On 12/7/06, Easter, David [EMAIL PROTECTED] wrote: Hi Mike, As per the posted web page, 6.0.1 users will be affected but no DST patch will be made available for the 6.0.1 release. Only 6.3 and 7.0.01 are to be

Re: Identify which filter created a notification

2006-12-07 Thread Peter Romain
Thanks Jesse, I'll certainly download the utility from Supportweb as it looks really useful. For my particular issue I need to identify the filter using workflow as the emails and alerts are created so the looking back to the data dictionary doesn't help much. Thanks again Cheers Peter

Re: Daylight savings time again

2006-12-07 Thread Easter, David
Sorry - I'm not legally allowed to disclose that kind of information. -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of

Re: Incident Management Patch 3 /ITSM 7.00

2006-12-07 Thread Mary C.
Check the install logs, because if there is an error regarding Field ID 301438012 not being related to the form, then a Defect has been created. Active Link RQC:SRC:GetRequestInfo_100_Init could not be imported. A few other Active Links are imported, but the qualifier references the

Re: Question about Groups

2006-12-07 Thread Siti Hawa Bee SHAIK FARID
Hi Katherine, I had a similar situation as well. My manager find the email notification irritating cause she been receiving email each time helpdesk save a ticket. Since she is part of the Support Group and she need to see the case in AR User, so I just simply set her notification method in

Re: Incident Management Patch 3 /ITSM 7.00

2006-12-07 Thread Kevin Shaffer
** Thanks ... The defect number from Remedy is SW00255618. I was able to get the patch to install without errorby copying field id 301438012 on the SRM:Request form to the RQC:ServiceRequestForm. From:"Mary C." [EMAIL PROTECTED]Reply-To:arslist@ARSLIST.ORGTo:arslist@ARSLIST.ORGSubject:Re:

Re: Remedy Issue

2006-12-07 Thread Rakesh Kiruba
Hi Murtuza, The table is pointing to a View in an external database. Not only in this table also in tables in all other forms are also getting the same error. This error has happened after moving the code to a new server. This error is not there in the old server and also I have tried re

Re: Web service - Qualification syntax?

2006-12-07 Thread Jarl Grøneng
Turn on web service logging on mid-tier and examine these logs. They migth give you an answer. -- Jarl On 12/7/06, Mathieu Pitre [EMAIL PROTECTED] wrote: Carey, Looks like there is an issue with the qualification because if I split both the qualification is two is works: 1- Original