Re: Check to make sure Char field doesn't contain a Percent sign (%)

[ccrashh]

Sigh...nevermind. Answered my own question: use "%[%]%"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Check to make sure Char field doesn't contain a Percent sign (%)

[ccrashh]

I know you can do a Run If with LIKE "%[a-z]%" to check for the
existence of alpha characters from a to z in a field.  However, how
can you check to see if a char field contains a "%" sign?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Need help for upgrading ARS( Custom build code ) 5.x to 7.x

[ccrashh]

First, you should go to 6.x then 7.x.  If you use the email engine,
good luck :)  Also, be aware that system fields like Submitter and
Last Modified By changed in length (so if you had them in a certain
layout, all of a sudden the "expand box" will appear and might overlap
the field to it's right).  We had that happen on a whole bunch of
forms.  I think we download some tool to run through all the forms and
set the Expand Box option on those fields to "Hide".





On Jul 13, 8:12 am, cyberhut  wrote:
> Hi All,
>
> Can anyone provide me the details with steps on how to upgrade remedy ARS
> from 5.x to 7.x. The task is to upgrade with data , interfaces. And also
> suggest me whether i should upgrade first to 6.x and then to 7.x.
>
> Thanks in advance,
>
> --
> View this message in 
> context:http://www.nabble.com/Need-help-for-upgrading-ARS%28-Custom-build-cod...
> Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.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: Close Window

[ccrashh]

Well...I would have code on the table double-click (that is, remove
the table's usual Table Drill Down check and capture the Table Double-
Click in an active link).  On this active link, I would do an Open
Window (Modify, though I would normally use a Dialog and have a Save
button or some such).  Then, on the same active link I would pass an
Event to the Child window (the one you just opened in Modify mode).
On the child window, have an AL that triggers on the event to set,
say, a flag field that says "Close on Modify" - I assume you meant
"After Modify" in your question, since you mentioned opening Assigned
Tickets from a table - the AL to Close Window would have that flag as
a Run If qualification.

That way, only if the Modify form is opened via a double-click on a
table field will you cause the Close Window action On Modify.

Hope that helps.

Steve

On Jul 9, 10:48 am, "Brittain, Mark"  wrote:
> Hi All,
>
> Not sure if I can do this one but thought I would ask. I want to do a close 
> window "After Submit" but only if a record is displayed as itself without a 
> list (e.g. Display Type = Detail Only).
>
> Typically users find their assigned tickets using a table field on a display 
> only form. They display the ticket by double clicking on a ticket. The above 
> action works fine in this case. However if they did a search of tickets, 
> getting a list (split window), when they save the ticket, the whole list 
> closes. Is there a qualification that says execute if the window is display 
> only?
>
> Thanks
> Mark
>
> 
> Mark Brittain
> Remedy Developer
> NaviSite
> mbritt...@navisite.com
> (315) 453-2912 x5418 (Phone)
> (315) 317.2897 (Cell)
>
> Reduce Cost of IT with Managed Hosting and Application Services from NaviSite.
> Visitwww.NaviSite.comToday.
>
>   
> 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 atwww.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: ITSM naming convention sucks

[ccrashh]

So then you would scamble through looking at each one to see what each
Active Link in the guide actually does?  How about:

HPD-HD-CUS:xxx-1_CheckForExistingCustomer
HPD-HD-CUS:xxx-2_SetCustomerInfoFromContactForm
etc.

Not sure what the other descriptive text could be...but xxx indicates
that it triggers in a guide and nowhere else...I find it easier to
find code if it is clearly labelled.

On Mar 24, 12:46 pm, Joe DeSouza  wrote:
> Its a good naming convention - I won't go so far as to say its the best.
>
> There are a few things in the ITSP naming convention that I personally do not 
> favor. For eg. AL's found in a guide that are used specifically in the guide 
> alone and nowhere else.. Why different kind of names for each? Why do we need 
> to know what each do? As a developer when looking at the list I would rather 
> see them named as a functional name what the guide does. For eg if the Guide 
> sets customer information and there are 5 AL's in that guide ordered 1 to 5 I 
> would name them something like
> HPD:GuideSetCustomerInfo01
> HPD:GuideSetCustomerInfo02
> HPD:GuideSetCustomerInfo03
> HPD:GuideSetCustomerInfo04
> HPD:GuideSetCustomerInfo05
>
> And name the Guide something like HPD:GuideSetCustomerInfo
>
> This is just one odd example of how it would make it easier for a developer 
> to trace what someone else has worked on without running workflow logs for 
> everything..
>
> Joe
>
> 
> From: Mahesh Chandra 
> To: arsl...@arslist.org
> Sent: Monday, March 23, 2009 11:54:31 PM
> Subject: Re: ITSM naming convention sucks
>
> **
> As per ITSP naming convention the standard format of an Active Link is:
>  
> [z][SchemaCode]:[#]-[Field Name/Button/Function]-[Firing 
> Condition][###E]-[Description]-[IndicatorSuffix][Status]
>  
> Where
>  
> z (lowercase) The lowercase z in front of the active link name indicates a 
> Global Workflow Filter
> Schema Code Schema Code (Reference Schema Code in case of Global Active Link) 
> -  3 Uppercase characters (usually the same as the entry-id prefix of the 
> schema)
> # Grouping Code:
>  
> 0 = Initialization (Window Open, Query,  Set Defaults, Display, Copy to New)
>  
> 1 = Execution (Submit, Modify)
>  
> 2 = Post Execution (After Submit, After Modify)
>  
> 3 = Close (Window Close)
>  
> 4 – 5 (Unassigned/Reserved)
>  
> 9 = In session (Button, Return, Menu/Row Choice, Gain Focus, Lose Focus0
>  
> z = Guide (Active Links Called by Guides only)
>  
> ###[E] Execution Order (3 digits). Append E if Else Action exists
>  
> Description Functional Description of the Workflow performed
>  
> Indicator Suffix E = Error
> N = Note
> W = Warning
> R = Run Process
> Q = SQL
> G = Call Guide
> J### - Goto execution order
> PCDE = Push where CDE is the 3 character code
>  
> Status + = New Workflow, requires testing (once tested the prefix can be 
> removed)
> @ = Existing Workflow has been temporarily deactivated
> # = Existing deactivated workflow with the intent of deleting from the system
>  
>  
>  
> HPD:INC: ContactSearch_120_GPn-G
>  
> Even though this piece of workflow doesn’t exist in ITSP, I think this is the 
> breakout.
>  
> HPD Module Name
> INC 3 Character Schema Code stored in SYS:Form List (ITSP) and Schema Names 
> (ITSM 7)
> ContactSearch Field Name
> 120 Execution Order
> Gpn (not sure)
> G Indicator Suffix for Call Guide
>  
> In my opinion, ITSP followed some best naming conventions.
>  
> Thanks
> Mahesh
>
> On Fri, Mar 20, 2009 at 8:15 AM, Matt Worsdell  wrote:
>
> Not BMC's fault, ITSM is based on ITSP which was produced by a VAR (name
> withheld to protect the guilty).
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of ccrashh
> Sent: 20 March 2009 12:53
> To: arsl...@arslist.org
> Subject: ITSM naming convention sucks
>
> BMC has to be kidding with their ITSM suite's naming convention...for
> instance:
>
> On the HPD:HelpDesk form, the Customer Search button (inexplicably
> called Contact Search even though it is under the Customer Information
> section) has several Active Links associated to it (31 or so).  If you
> were to go to the list of active links and sort by name, the first one
> that appears is:
>
>     HPD:INC:ContactSearch_120_GPn-G
>
> However, the first one that triggers is:
>
>     HPD:INC:ContactSearch_Info_035_GetPersonInfo
>
> Which is 19th in the list of 31 Active Links.  WTF.  Why would anyone
> do things this way?  How can any real Remedy ARS developer work with
> this crap without wanting to put his/

Re: ITSM naming convention sucks

[ccrashh]

Out of curiousity...what do you do if the code triggers on more than
one action?:

CC_NIM:Btn_OpenIncidentTask-MRC_Somefield-000-OpenHelpDesk

Like that?



On Mar 24, 5:56 am, "Coleman, Gavin" 
wrote:
> "In my opinion, ITSP followed some best naming conventions."
>
> Well considering that as far as know the naming convention is not explained 
> anywhere in the ITSP or ITSM documentation, I can't see how you can believe 
> that. Remedy allows you up to 80 characters to name workflow items, and it 
> seems that ITSP and ITSM does not use all of these characters. My Active Link 
> workflow has a naming convention as follows
>
>  1.  Prefix for custom work (CC_)
>  2.  Form abbreviation (NIM:) - New Incident Console
>  3.  Execute on abbreviation (MRC - Menu Row Choice, Btn - Button, WL - 
> Window Loaded). If more than one Execute on is specified, then the 
> abbreviation I use is the most relevant
>  4.  Name of Button, Table, Field etc (E.g. Btn_OpenIncidentTask)
>  5.  Execution Order (-000-)
>  6.  Details of Actions (OpenHelpDesk)
>
> Thus, we get
>
> CC_NIM:Btn_OpenIncidentTask-000-OpenHelpDesk
>
> If an AL or Filter is part of a Guide, then the suffix _GUIDE is applied. If 
> the AL or Filter calls a Guide, then the suffix _CallGuide is applied.
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: ITSM naming convention sucks

[ccrashh]

Ah...that might explain some of the different naming conventions I
have seen across modules.  Man, this is going to be a pain...

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

ITSM naming convention sucks

[ccrashh]

BMC has to be kidding with their ITSM suite's naming convention...for
instance:

On the HPD:HelpDesk form, the Customer Search button (inexplicably
called Contact Search even though it is under the Customer Information
section) has several Active Links associated to it (31 or so).  If you
were to go to the list of active links and sort by name, the first one
that appears is:

 HPD:INC:ContactSearch_120_GPn-G

However, the first one that triggers is:

 HPD:INC:ContactSearch_Info_035_GetPersonInfo

Which is 19th in the list of 31 Active Links.  WTF.  Why would anyone
do things this way?  How can any real Remedy ARS developer work with
this crap without wanting to put his/her fist through the monitor?

Here's a tip...fix the naming convention!

For example:

 HPD-INC-CUS:SR-b035-GetPersonInfo
 ...
 HPD-INC-CUS:SR-b120-GPn-G  --- of course, this should be renamed
to something more explicit like:
 HPD-INC-CUS:SR-b120-CallGuide_CF

(CF being an acronym for the ContactFound guide...which I would rename
to HD-INC-CF:ContactFound)

See, now this naming convention makes sense.  Broken down it is the
 HPD module
 INC form (though, I would change this to HD probably to match the
form's actual acronym)
 CUS (for Customer - so we know this has something to do with the
Customer information on the form)
 SR - for Search (so if this were the Create button, I would use
CR, and MD for Modify)
 b - for button (other abbreviations would be s = submit,
m=modify, mc = menu choice, etc.)
 035 or 120 - execution order
GetPersonInfo - or other - description of the functionality (can
be followed by things like -E for Error, or -G
  for a Goto, etc.)

So, if I were to modify all the ALs accordingly, sorting by name gives
us the Active Links in order of their functionality and execution
order within that functionality.

What BMC has provided is total crap...'natch.

And my contract may require me to work on this...double sigh.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: LDAP integration in Remedy V6.3

[ccrashh]

Sorry, responded to you rather than the group.  What do you mean by
"...SID to the fields that are presented to the LDAP"?


On Feb 25, 9:39 am, Dan Fraser  wrote:
> I am currently running Remedy V6.3 integrated with Windows Active Directory.  
> My question is, how can I add the SID to the fields that are presented to the 
> LDAP
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Remedy ODBC Drivers and 7.1

[ccrashh]

No, it isn't a password issue.  It's definitely a problem with the way
7.1 creates the User Datasource.  They even have a "bug" filed for it
- but are also calling it "as designed".  Bizzare...

On Feb 24, 2:02 pm, "Marty.Thorin" 
wrote:
> The first question to ask is "What is in your password?"  I do not care
> about A through Z, nor 1 through 9: the other characters.  Remedy is not
> picky but Crystal tries to parse passwords.
>
> Thorin
>
> -Original Message-
> From: ccrashh [mailto:ccra...@gmail.com]
> Sent: Tuesday, February 24, 2009 10:37 AM
> Subject: Remedy ODBC Drivers and 7.1
>
> Has anyone else seen this issue?  When trying to run an embedded Crystal
> Report, we got the error:
>
> "An error occurred while generating the Crystal Report: 0x80047e48 -
> Logon Failed (ARERR 1904)"
>
> What we discovered is that the AR System ODBC driver existed as a Data
> Source but did not have a server name (that is, if you go to Windows
> Start/Administrative Tools/Data Sources (ODBC), there should be a line
> for the AR System ODBC driver...if not, you can add it).  Now, if there
> is no AR System ODBC driver listed as a User Data Source, you can still
> run the report via a 6.3 User Tool.  The User Data Source is created and
> set properly (i.e. with a server name).  However, if you run the report
> from a 7.1 User tool, it does NOT create the data source.
>
> As well, on SOME machines, even if the data source is there but there is
> no Server Name, you get the error above - on other machines, as long as
> the Data Source exists, the report runs even if there is no Server Name.
> We can't figure out why, and what is happening.
>
> BMC says that this is "as designed" - that is, each Client Workstation
> has to manually set the AR System ODBC driver.  Sigh.
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum
> Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Remedy ODBC Drivers and 7.1

[ccrashh]

Has anyone else seen this issue?  When trying to run an embedded
Crystal Report, we got the error:

"An error occurred while generating the Crystal Report: 0x80047e48 -
Logon Failed (ARERR 1904)"

What we discovered is that the AR System ODBC driver existed as a Data
Source but did not have a server name (that is, if you go to Windows
Start/Administrative Tools/Data Sources (ODBC), there should be a line
for the AR System ODBC driver...if not, you can add it).  Now, if
there is no AR System ODBC driver listed as a User Data Source, you
can still run the report via a 6.3 User Tool.  The User Data Source is
created and set properly (i.e. with a server name).  However, if you
run the report from a 7.1 User tool, it does NOT create the data
source.

As well, on SOME machines, even if the data source is there but there
is no Server Name, you get the error above - on other machines, as
long as the Data Source exists, the report runs even if there is no
Server Name.  We can't figure out why, and what is happening.

BMC says that this is "as designed" - that is, each Client Workstation
has to manually set the AR System ODBC driver.  Sigh.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

SOLVED: Attachments and Webservices

[ccrashh]

Solved it myself:

Using VB.NET, attach a webservice (in the sample below I called the
attached webservice wsTestAttach) to the project (use the Web
Reference structure):

Imports System.IO

 Private Sub btnCreateAttach_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles btnCreateAttach.Click

Dim myService As wsTestAttach.TestAttachmentService = New
wsTestAttach.TestAttachmentService
Dim myName As wsTestAttach.AuthenticationInfo = New
wsTestAttach.AuthenticationInfo

Dim sName As String
Dim od As New OpenFileDialog
Dim input As FileStream

If od.ShowDialog() = DialogResult.OK Then
input = File.OpenRead(od.FileName)
End If

Dim fi As FileInfo = New FileInfo(od.FileName)
Dim ltemp As Long = fi.Length
Dim ilung As Integer = Convert.ToInt32(ltemp)

Dim doc(ilung) As Byte
input.Read(doc, 0, ilung)
input.Close()

sName = od.FileName.Substring(od.FileName.LastIndexOf("\") +
1)

myService.OpCreate(sName, doc, ilung, "assign to text", "short
desc", wsTestAttach.StatusType.Assigned, "someuser")

End Sub

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Attachments and Webservices

[ccrashh]

I have a webservice that only has one operation (Create).  There is an
attachment field on the form I want to populate.  I can easily create
the webservice, but can find no sample code (vb.net) to test consuming
the ws.  The attachment field is looking for the following values:

attachmentName (string)
attachmentData (base64Binary)
attachmentOrigSize (integer)

Has anyone had any luck publishing a webservice that takes an
attachment?  Do you have some vb.net snippet I can use to test it?

Thanks for any help.

Steve

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Remedy Deve3loper Studio 7.5???

[ccrashh]

@Elry...

That's good to know.  I haven't had a chance to work with it yet, but
will try to download it at home soon.  I was worried that it was
geared to work with the ITSM suite and the piss poor naming
convention, among other bloated issues, that BMC/Remedy employs :) lol

Steve

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Remedy Deve3loper Studio 7.5???

[ccrashh]

@Icarus4

Oh my god...Can you say "cluttered"?  I just took a look at the
Introduction PDF for the Developer Studio, and the screenshot is
horrendous.  Of course, I assume I can close some/most of the windows.
Hope so.

As a developer of fully customized solutions, rather than modifying
the out-of-the-box ITSM suite, I wonder about this change.  Is it
better?  Will it enable me to build a full solution quicker?  If not,
then the update is no good.  I haven't had a chance to use it yet, so
have no opinion (other than the cluttered screenshot mention above).

Steve

On Feb 10, 6:13 am, Icarus4  wrote:
> Well guys... I'm really wondering what you are all waiting for? A tool that
> does everything for you?
>
> Personally I spent 30 minutes so far on it and could quite easily find back
> the functions I need. I know I will definitely have to read the manual to
> get familiar with all interface details but so did I back in 2001 with
> Remedy 4.5 and then Remedy 6.3 later
>
> I have two 22" wide screens running at 1680x1050 and I'm just amazed to
> finally have the possibility to work on my form fully displayed on one side
> and have my properties on the other side finally a real workspace.
>
> Also I have the feeling it is now faster to develop. I am working on a
> system that is located at the other end of the world and generally have to
> develop using Terminal Service because of the response time. My first
> attempts to develop on 7.5 appeared to be much, much, much faster but on
> that one I will see the real difference in a couple of months as the system
> is not yet in production.
>
> Conclusion... for me BMC is really doing a great job on improving this
> system and everything I've seen so far (ARS 7.5, ITSM 7.5, CMDB 7.5 wth
> Tibco and the the new Atrium Impact Simulator, Dev Studio, Import Tool, etc)
> is looking promising and I can't wait for the next version as I have the
> feeling there will be some big changes again.
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

arsvcdsp process

[ccrashh]

Everything I have read about this process (Application Dispatcher -
arsvcdsp) points to it being used with the Approval server and the
Application Pending form.  But by default, upon installing ARS, this
process gets started.  Is this (arsvcdsp) the Application Dispatcher
referenced in these documents?  And, if so, does this mean that this
process is not required at all?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Remedy license usage monitoring utility

[ccrashh]

Well, I don't know about a free one, but you can check out www.wave-form.com.
We use their product here and it does everything we need it to do.
Plus, it's a Remedy module you install.  Very nice, very compact.
There's a trial version you can download.

Steve

On Feb 5, 1:59 pm, Rootuja Ghatge  wrote:
> Hi all,
>
>             Is there a free utility/tool out there to monitor & measure 
> licenses usage (both Fixed & Floating) that can be used to review the peak 
> time usage & derive some conclusions from there as to how many and what type 
> of licenses to buy?
>
> Thanks in advance,
> Rootuja
>
> _
> Rootuja Ghatge
> Senior Application Developer
>
> CenterBeam, Inc.
> 30 Rio Robles
> San Jose, CA 95134
> Direct  (408) 750-0718
> Fax     (408) 750-0559http://www.centerbeam.com
> 
>
> This email may contain confidential and privileged material for the sole use 
> of the intended recipient. Any review or distribution by others is strictly 
> prohibited. If you are not the intended recipient please contact the sender 
> and delete all copies.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: WARNING: don't use 6.3 User tool with 7.1 Server

[ccrashh]

Sorry about the length of time getting back to you all...

Yes, I logged a ticket with BMC.  They were able to reproduce the
issue (amazing, eh?).  So they have opened a bug report.  Not sure of
the number.

On Jan 13, 5:00 pm, Bryan Waters  wrote:
> Have you logged a defect with BMC?  If so, can you please share?
>
> Thanks,
> Bryan
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Tuesday, January 13, 2009 7:06 AM
> To: arsl...@arslist.org
> Subject: Re: WARNING: don't use 6.3 User tool with 7.1 Server
>
> Hey ccrashhh
>
> Long time no parler dudecomment ca va...
>
> I agree - we just started our UAT and TRA - we quickly discovered this
> to be an issue.
>
> Glad to see someone else out there can replicate.
>
> Have a good one eh...
>
> On Jan 6, 8:52 am, ccrashh  wrote:
> > They are certainly compatible (User 6.3 vs 7.1 Server)...with one
> > annoying exception:  your forms and code will ALWAYS cache.  That's
> > right...each and every time you open a form using User 6.3 on a 7.1
> > Server installation of Remedy ARS, it will overwrite the existing arf
> > and arv files.  Fun times.
>
> > In as large an organization as I am in, it takes time to rollout
> > certain tools.  We decided to upgrade the backend while the QA people
> > dicked around with the 7.1 User tool.  They still haven't "approved"
> > it for rollout, but we were assured by BMC/Remedy that things would be
> > hunky-dory.  Not so much.  We have users all over the world, and many
> > are now complaining that the application is so slow as to be
> > unusable.
>
> > We tested packet traffic using Wireshark and noticed that opening a
> > form in Query mode with a 6.3 User tool on a 6.3 Server meant around
> > 10 packets with a total size of about 1900 bytes.  Opening the same
> > form in the same way against a 7.3 Server had 215 packets and about
> > 190,000 bytes.  A factor in size of about a 100.  We then realized
> > that the 6.3 User tool was forcing a constant recache of the forms/
> > code.  Sigh.
>
> > Just a heads up to any in a situation like this.  If Users are
> > complaining about slow speeds with the arserver 7.1, check which
> > version of the User tool they are using.
>
> 
> ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist:"Where the Answers Are"
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Escalation question

[ccrashh]

I set up a very robust scheduler application.  I made it act a bit
like the Windows Task Scheduler.  You can set up a very specific
schedule at which you want something to happen/trigger...every 2nd
Saturday of the month, for instance.  It works by calculating when the
first trigger time will be.  Then, when that date/time is reached
(uses an Escalation that triggers using that date/time field, of
course) code calculates the next trigger time.

Steve

On Feb 3, 1:00 pm, "Pruitt, Christopher J"
 wrote:
> I have been trying to figure out a way to make an Escalation run on the
> Second Saturday of every month. I know you can schedule it to run at
> during a specific Hour of the Day, or Day of the Month or even a Week
> Day but none of these options allow you to run it on a specific day of
> the Month where it is, say a Second Saturday or Third Monday, etc.
>
> Anyone had any success in this area of Escalation scheduling?
>
> Configuration:
>
> AR System 7.1
> Oracle 10g
> Sun Solaris OS 5.9
>
> Christopher Pruitt
> Consultant Specialist
> EDS, an HP Company
> mailto: christopher.pru...@eds.com
> We deliver on our commitments
> so you can deliver on yours.
> Confidentiality Notice: This message and any files transmitted with it
> are intended for the sole use of the entity or individual to whom it is
> addressed, and may contain information that is confidential, privileged,
> and exempt from disclosure under applicable law. If you are not the
> intended addressee for this e-mail, you are hereby notified that any
> copying, distribution, or dissemination of this e-mail is strictly
> prohibited. If you have received this e-mail in error, please
> immediately destroy, erase, or discard this message. Please notify the
> sender immediately by return e-mail if you have received this e-mail by
> mistake.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Solaris 10 and Remedy ARS

[ccrashh]

We had an interesting problem with a test envirornment.  Even if we
set the ar.conf file to register with the portmapper, we got an
RPCBind error (Authentication Failure).  We discovered that the latest
version of Solaris uses some different settings.  We found the
following solution at 
http://www.mail-archive.com/arsperl-us...@arsperl.org/msg00610.html:

1. the portmapper ("rpcbind") is under the control of the "Service
Management
Facility" (SMF) on solaris10.  SMF seems (to me, at least) very
bloated with
lots of gratuitous stuff, including "properties".  One of the
properties for
rpc/bind is "config/local_only" which apparently controls whether the
portmapper can be reached from other hosts. It was set to "true", so
other
hosts were out of luck.  I set it to "false" using:

  svccfg -s svc:/network/rpc/bind
  svc:/network/rpc/bind> setprop config/local_only = false
  svc:/network/rpc/bind> quit

  svcadm refresh svc:/network/rpc/bind

2. the 2nd cause was also related to a property, "config/
enable_tcpwrappers",
which was set to "true", meaning access to rpcbind was filtered by
tcpwrappers,
so I added a line to "/etc/hosts.allow" as follows:

  rpcbind:  ALL

And made sure /etc/hosts.allow was readable by rpcbind ("chmod 644
/etc/hosts.allow").


Just a heads up.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: How to create many entries in Remedy form at a time from C# code?

[ccrashh]

I'm afraid you will have to use CreateEntry...trying to do any kind of
bulk insert is a royal pain, since you also have to get the NextID
from arschema and increment it.  The safest way is, definitely, the
Remedy APIs.

Steve

On Jan 8, 4:52 pm, maggie2007  wrote:
> How to create many entries in Remedy form at a time from C# code?
>
> I need to  create many entries in Remedy form which is on customer's Remedy
> server (note: I cannot use Remedy Administrator).
>
> Similar like SQL server bulk insert. Is there any such command or functions?
>
> If not, the only way is to loop for each entry, call Remedy C# API
> CreateEntry? I just worry that this will be slow.
>
> --
> View this message in 
> context:http://www.nabble.com/How-to-create-many-entries-in-Remedy-form-at-a-...
> Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Application Query Delete Entry

[ccrashh]

But won't this process, because it is initiated from the client-end,
force the client to wait until the whole thing is completed?  Or will
the API-Call just trigger and then return as a completed process to
the client?  I don't use client-side Run Processes much, so haven't
explored their impact.  I could test this, but am lazy :)

Steve

On Jan 8, 8:16 am, Conny Martin  wrote:
> I think there is no problem with performance. The only API-Call which you'll 
> see is an ARExecuteProcessForActivelink. From then on all is running within 
> the server.
>
> -Ursprüngliche Nachricht-
> Von: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] Im Auftrag von ccrashh
> Gesendet: Donnerstag, 8. Januar 2009 14:11
> An: arsl...@arslist.org
> Betreff: Re: Application Query Delete Entry
>
> Huh...didn't even notice the Log stating "ACTL"just assumed filters.  The 
> documentation flags Application-Query-Delete-Entry as Filter only, and not 
> Active Links.  Does the lack of a checkbox mean it will work but isn't 
> supported?  Or is this just another example of bad documentation?
>
> For the record, I think it is bad, performance-wise, to delete x number of 
> records via client-side code.  This should be invoked via a filter.
>
> Steve
>
> On Jan 8, 7:56 am, kush  wrote:
>
>
>
> > Hi friends,
> > thanks for your help...
> > @@ has solved my problem.
>
> > Thanks folks for you help once again.
>
> > -
> > Kaushal.
>
> > On Jan 8, 5:15 pm, Conny Martin  wrote:
>
> > > If you're using this in an AL you must precede the command with @@:
> > > The AL runs on the client and try's to start an executable file named 
> > > Application-Query-Delete-Entry.
>
> > > -Ursprüngliche Nachricht-
> > > Von: Action Request System discussion list(ARSList)
> > > [mailto:arsl...@arslist.org] Im Auftrag von ccrashh
> > > Gesendet: Donnerstag, 8. Januar 2009 12:53
> > > An: arsl...@arslist.org
> > > Betreff: Re: Application Query Delete Entry
>
> > > Turn on SQL logging on as well.  It is probably failing there, and this 
> > > will tell you why.
>
> > > Also, I would try using a numeric value for the expression:
>
> > > 'chkBoxApplicationStatus' = 0 (or whatever the value is for Delete)
>
> > > Steve
>
> > > On Jan 8, 6:27 am, Kaushal Pandya  wrote:
>
> > > > Hi Friends,
> > > > I am facing problem with 'Application-Query-Delete-Entry' process.
> > > > I have written this action like this:
> > > > Application-Query-Delete-Entry "KP_UserApplicationForm"
> > > > 'chkBoxApplicationStatus' = "Delete"
> > > > to delete all the record for which 'chkBoxApplicationStatus' =
> > > > "Delete".
>
> > > > while running on user tool its giving an error like:
> > > > The system cannot find the file specified.
>
> > > > and in log file it captures:
> > > >           1: Run Process
> > > >              Application-Query-Delete-Entry
> > > > "KP_UserApplicationForm" 'chkBoxApplicationStatus' = "Delete"
> > > >                Process: Application-Query-Delete-Entry
> > > > "KP_UserApplicationForm" 'chkBoxApplicationStatus' = "Delete"
> > > >                    Failed                   Return
> > > > Code: 01
>
> > > > Any idea what could be the reason for this?
> > > > Please help to resolve this issue.
>
> > > > Thanks in advance,
> > > > Kaushal.
>
> > > > __
> > > >  _ UNSUBSCRIBE or access ARSlist Archives
> > > > atwww.arslist.orgPlatinum Sponsor:www.rmsportal.comARSlist:"Where
> > > > the Answers Are"
>
> > > 
> > > ___  UNSUBSCRIBE or access ARSlist Archives 
> > > atwww.arslist.orgPlatinumSponsor:www.rmsportal.comARSlist:"Where the 
> > > Answers Are"
>
> > > 
> > > ___  UNSUBSCRIBE or access ARSlist Archives
> > > atwww.arslist.orgPlatinum Sponsor:www.rmsportal.comARSlist:"Where the 
> > > Answers Are"
>
> > __
> > _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist:"Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum 
> Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Application Query Delete Entry

[ccrashh]

Huh...didn't even notice the Log stating "ACTL"just assumed
filters.  The documentation flags Application-Query-Delete-Entry as
Filter only, and not Active Links.  Does the lack of a checkbox mean
it will work but isn't supported?  Or is this just another example of
bad documentation?

For the record, I think it is bad, performance-wise, to delete x
number of records via client-side code.  This should be invoked via a
filter.

Steve

On Jan 8, 7:56 am, kush  wrote:
> Hi friends,
> thanks for your help...
> @@ has solved my problem.
>
> Thanks folks for you help once again.
>
> -
> Kaushal.
>
> On Jan 8, 5:15 pm, Conny Martin  wrote:
>
>
>
> > If you're using this in an AL you must precede the command with @@: The AL 
> > runs on the client and try's to start an executable file named 
> > Application-Query-Delete-Entry.  
>
> > -Ursprüngliche Nachricht-
> > Von: Action Request System discussion list(ARSList) 
> > [mailto:arsl...@arslist.org] Im Auftrag von ccrashh
> > Gesendet: Donnerstag, 8. Januar 2009 12:53
> > An: arsl...@arslist.org
> > Betreff: Re: Application Query Delete Entry
>
> > Turn on SQL logging on as well.  It is probably failing there, and this 
> > will tell you why.
>
> > Also, I would try using a numeric value for the expression:
>
> > 'chkBoxApplicationStatus' = 0 (or whatever the value is for Delete)
>
> > Steve
>
> > On Jan 8, 6:27 am, Kaushal Pandya  wrote:
>
> > > Hi Friends,
> > > I am facing problem with 'Application-Query-Delete-Entry' process.
> > > I have written this action like this:
> > > Application-Query-Delete-Entry "KP_UserApplicationForm"
> > > 'chkBoxApplicationStatus' = "Delete"
> > > to delete all the record for which 'chkBoxApplicationStatus' =
> > > "Delete".
>
> > > while running on user tool its giving an error like:
> > > The system cannot find the file specified.
>
> > > and in log file it captures:
> > >           1: Run Process
> > >              Application-Query-Delete-Entry
> > > "KP_UserApplicationForm" 'chkBoxApplicationStatus' = "Delete"
> > >                Process: Application-Query-Delete-Entry
> > > "KP_UserApplicationForm" 'chkBoxApplicationStatus' = "Delete"
> > >                    Failed
> > >                   Return Code: 01
>
> > > Any idea what could be the reason for this?
> > > Please help to resolve this issue.
>
> > > Thanks in advance,
> > > Kaushal.
>
> > > __
> > > _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > Platinum Sponsor:www.rmsportal.comARSlist:"Where the Answers Are"
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives 
> > atwww.arslist.orgPlatinumSponsor:www.rmsportal.comARSlist:"Where the 
> > Answers Are"
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist:"Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Active Link works on dev; not on prod

[ccrashh]

My question exactly.  I thought the same thing, but would have to
test.  If they don't work (and I would never rely on LASTCOUNT) I
would take the table field qualification and simply build a SQL Count
statement to return the number of matching records.  It would be
safer, especially if the User has the number of records to be returned
set to a smaller number in the User tool - not sure if that screws
things up eitherAND if table chunking affects things.

Steve

On Jan 7, 5:44 pm, Joe DeSouza  wrote:
> Does LASTCOUNT and COLCOUNT($ID$) work correctly when table chunking is 
> enabled?
>
> I don't remember so just thinking out loud here before you think its the 
> solution..
>
> Joe
>
> 
> From: "Opela, Gary L CTR USAF AFMC 72 CS/SCBAH" 
> To: arsl...@arslist.org
> Sent: Wednesday, January 7, 2009 4:29:56 PM
> Subject: Re: Active Link works on dev; not on prod
>
> Hey, that looks like it might just work. I don't know why they don't call it 
> ROWCOUNT.
>
> From the 6.3 documentation:
>
> COLCOUNT
> (column) or (table)
> int
>
> For a table or results list field, returns the total number of rows.
> For a column field, returns the total number of non-NULL rows in a given 
> column.
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Greg Donalson
> Sent: Wednesday, January 07, 2009 3:27 PM
> To: arsl...@arslist.org
> Subject: Re: Active Link works on dev; not on prod
>
> Hi Gary,
>
> You can always do  'Ticket Count' = COLCOUNT($tbl_Tickets$).  I would suggest 
> using this - I do not like to rely on LASTCOUNT.
>
> Greg Donalson
> Schlumberger
>
> Desk - 713-513-2331
> Cell - 281-515-6538
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72
> CS/SCBAH
> Sent: Wednesday, January 07, 2009 3:15 PM
> To: arsl...@arslist.org
> Subject: Re: Active Link works on dev; not on prod
>
> The solution; use the $LASTCOUNT$ keyword. Since I'm running it immediately 
> after refreshing the table, it should always pull the correct count.
>
> Gary
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
> Sent: Wednesday, January 07, 2009 2:54 PM
> To: arsl...@arslist.org
> Subject: Re: Active Link works on dev; not on prod
>
> **
>
> I thought setting an Integer field equal to a table puts the row number of 
> the currently selected row into the Integer field
>
> Fred
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72
> CS/SCBAH
> Sent: Wednesday, January 07, 2009 2:50 PM
> To: arsl...@arslist.org
> Subject: Active Link works on dev; not on prod
>
> AR Server 6.3/ WUT 6.3/ Windows 2k3/ MSSQLServer
>
> So, I just developed a form and some active links on dev, then imported them 
> into prod, and one of the ALs doesn't work.
>
> So, the active link does a set fields. It sets 'Ticket Count' = $tbl_Tickets$
>
> On dev, this will set the Ticket Count integer field to the number of records 
> in the tbl_Tickets table.
>
> This works fine in dev, but not in prod. Below are the logs from each table 
> refresh:
>
> Dev:
>
>  /* Wed Jan 07 2009 14:35:26 */
>  Workflow Trace Log -- ON
>  /* Wed Jan 07 2009 14:35:28 */
>  Start active link processing -- Operation - On Menu Choice
>     For Schema - HD: My Stats
>     Linked to field - Table Properties: (536870936)
>     On screen type - CREATE
>  Checking HD: MS: Set Table Qual on Table Properties: Change (10)
>     -> Passed qualification -- perform if actions
>           0: Set Fields
>             Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 
> 'Create Date' >= "04/01/2008")
>  Checking HD: MS: Refresh tbl_My Tickets (50)
>     -> Passed qualification -- perform if actions
>           0: Set Characteristics
>             For field -- Tickets (536870932)
>               Refresh field
>           1: Set Fields
>             Ticket Count: (536870937) = 21
>  /* Wed Jan 07 2009 14:35:28 */
>  Stop active link processing - On Menu Choice
>  /* Wed Jan 07 2009 14:35:34 */
>  Workflow Trace Log -- OFF
>
> Prod:
>
>  /* Wed Jan 07 2009 14:34:54 */
>  Workflow Trace Log -- ON
>  /* Wed Jan 07 2009 14:35:02 */
>  Start active link processing -- Operation - On Menu Choice
>     For Schema - HD: My Stats
>     Linked to field - Table Properties: (536870936)
>     On screen type - CREATE
>  Checking HD: MS: Set Table Qual on Table Properties: Change (10)
>     -> Passed qualification -- perform if actions
>           0: Set Fields
>             Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 
> 'Create Date' >= "04/01/2008")
>  Checking HD: MS: Refresh tbl_My Tickets (50)
>     -> Passed qualification -- perform if actions
>           0: Set Characteristics
>             For field -- Tick

Re: Application Query Delete Entry

[ccrashh]

Turn on SQL logging on as well.  It is probably failing there, and
this will tell you why.

Also, I would try using a numeric value for the expression:

'chkBoxApplicationStatus' = 0 (or whatever the value is for Delete)

Steve

On Jan 8, 6:27 am, Kaushal Pandya  wrote:
> Hi Friends,
> I am facing problem with 'Application-Query-Delete-Entry' process.
> I have written this action like this:
> Application-Query-Delete-Entry "KP_UserApplicationForm"
> 'chkBoxApplicationStatus' = "Delete"
> to delete all the record for which 'chkBoxApplicationStatus' =
> "Delete".
>
> while running on user tool its giving an error like:
> The system cannot find the file specified.
>
> and in log file it captures:
>           1: Run Process
>              Application-Query-Delete-Entry
> "KP_UserApplicationForm" 'chkBoxApplicationStatus' = "Delete"
>                Process: Application-Query-Delete-Entry
> "KP_UserApplicationForm" 'chkBoxApplicationStatus' = "Delete"
>                    Failed
>                   Return Code: 01
>
> Any idea what could be the reason for this?
> Please help to resolve this issue.
>
> Thanks in advance,
> Kaushal.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: File / Send Mail feature question

[ccrashh]

Actually, the Subject line gets populated with the form's Current View
name.  For instance, if your schema name is SHR_ApplicationSettings,
and View1's singular Alias is "Application Setting", then the Subject
of the email will be "Application Setting".  If you opened it in View2
and it's singular Alias was "Blah" then that will be the contents of
the Subject line.

Steve

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: How to submit and modify incidents/problems through email.

[ccrashh]

The ARSystem Email Messages form will automatically parse and submit
tickets if the format of the incoming email is as follows:

char-set: windows-1252
#
#  File exported Tue Jan  6 09:04:16 2009
#
Schema: Some_Form
Server: SomeServer
Login:
Password:
Action: Submit
# Values: Submit, Query
Format: Short
# Values: Short, Full

  Z_Short_Desc !8!: N/A
 Z_Assigned_To !4!:
 Submitter !2!: $USER$
Status !7!: Active
# Values: Inactive, Active


You create this .arm file by clicking Tools/Export Mail Templates and
choosing the form and view you want to use (you can create a nice
little EmailTemplateView which contains only the fields you want
someone to be able to access via email).

If an email comes into the ARSystem Email Messages form with that
format above, APIs will automatically parse it out and submit (or
whatever is set as the Action) a ticket to the form listed as the
Schema:

Steve

On Jan 5, 6:54 am, Salma  wrote:
> Hi Steve,
>
> I didnt know there is OOTB functionality to subit incidents through emails .
> Can u please explain me  more on this .  
>
> Regards,
> Salma
>
> ccrashh wrote:
>
> > Er...everyone seems to be assuming that you are using the Out-of-the-
> > box (OOTB) crap...I mean...solution from BMC/Remedy.  Is this the
> > case?  Are you asking about processing emails in a OOTB environment or
> > a custom application?
>
> > Steve
>
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> --
> View this message in 
> context:http://www.nabble.com/How-to-submit-and-modify-incidents-problems-thr...
> Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: how to open a window on a set field action with multiple request match

[ccrashh]

Simple.  Do a SQL Count first, using the same qualification as your
statement but written as:

SELECT COUNT(*) FROM ..

Then have an Active Link trigger if this number is greater that 1.

On the Open Window, use the qualification statement and have the
Window Type set to Modify and the Display Type set to List Only.  This
should open the Results list as specified in the form's properties.

An alternative is to do an Open Window to a new form that has a table
field and pass the qualification, which you use with a EXTERNAL
($passedqualification$) in the table's qualification.  This has the
added benefit of allowing you to customize which columns are
displayed.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

WARNING: don't use 6.3 User tool with 7.1 Server

[ccrashh]

They are certainly compatible (User 6.3 vs 7.1 Server)...with one
annoying exception:  your forms and code will ALWAYS cache.  That's
right...each and every time you open a form using User 6.3 on a 7.1
Server installation of Remedy ARS, it will overwrite the existing arf
and arv files.  Fun times.

In as large an organization as I am in, it takes time to rollout
certain tools.  We decided to upgrade the backend while the QA people
dicked around with the 7.1 User tool.  They still haven't "approved"
it for rollout, but we were assured by BMC/Remedy that things would be
hunky-dory.  Not so much.  We have users all over the world, and many
are now complaining that the application is so slow as to be
unusable.

We tested packet traffic using Wireshark and noticed that opening a
form in Query mode with a 6.3 User tool on a 6.3 Server meant around
10 packets with a total size of about 1900 bytes.  Opening the same
form in the same way against a 7.3 Server had 215 packets and about
190,000 bytes.  A factor in size of about a 100.  We then realized
that the 6.3 User tool was forcing a constant recache of the forms/
code.  Sigh.

Just a heads up to any in a situation like this.  If Users are
complaining about slow speeds with the arserver 7.1, check which
version of the User tool they are using.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: How to submit and modify incidents/problems through email.

[ccrashh]

Er...everyone seems to be assuming that you are using the Out-of-the-
box (OOTB) crap...I mean...solution from BMC/Remedy.  Is this the
case?  Are you asking about processing emails in a OOTB environment or
a custom application?


Steve

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Creating Decrementing value in Table

[ccrashh]

Why would there be a perfomance impact?  How are you adding this new
record?  You already know that the highest value is 5, so when you add
a new record (in your example called Test6) that the new Order ID
would be the current max order id + 1.  So when you do a Push Fields
to create a new record, you push 6 to the order id.

I really am curious as to how adding a new record is causing you to
have performance issues.

Steve

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Creating Decrementing value in Table

[ccrashh]

I think the easiest approach is, as Mike said, an Update SQL
statement:

UPDATE childtablename
SET counter = counter - 1
WHERE parentrequestid = '$request_id$' AND counter >
'$counterbeingdeleted$'

childtablename = the schema of the child form
counter = field on the childtablename that stores the 1, 2, 3, etc.
parentrequestid = I am assuming you have some foreign key stored on
the childtable that is the Request ID of the parent record.
counterbeingdeleted = the counter value of the record being deleted
(ie 2).

This way you don't have to run through a Push Fields filter.

Steve

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Interesting "Bug" in 7.1

[ccrashh]

If you create a SET FIELDS action in an Active Link on a form with a 0
byte (unlimited) field using the 6.3 version of the Admin tool (even
if the server is 7.1), you can cut and paste or type several thousand
characters (try about 4000).  If you try to do the same thing in an
Active Link, on the same form and field, with the 7.1 Admin Tool, it
will not let you cut and paste and/or type more than about 1900
characters into the SET FIELDS action.  Give it a shot.  Truly fun.

The problem is worse than thatyou can import such an Active Link
onto a 7.1 server, no problem.  You just can't modify the set fields
itself.

You can't run Remedy Developer Plus from the 7.1 Admin tool against it
either.  It will hang the minute it hits that active link.

Fun times.  You can imagine the run-around I got from BMC Support.  I
had to debug and solve this myself.

Now...is this a bug in 7.1 or something BMC/Remedy "fixed" because it
was "not working correctly" in 6.3?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT: ARUtilities holiday special (ending soon)

[ccrashh]

It can be worth the effort, if you have a good contract.  They come in
piles sometimes, then dry up for a while.  SI Systems has always
treated me well.

The only feature from RDP that I think would be good to have is it's
ability to tell you all the code that impacts a field (uses it in Run
If, Set Fields If, Set Fields, Push Fields If, Push Fields, Table
Qualification, Table Field Column, Menu, etc)  That's really handy.

Steve

On Dec 17, 6:19 pm, rem...@arutilities.com wrote:
> Hey Steve,
>
> Tell me some of the things that RDP does that ARUtilities should, and I
> will give you a free license key for ARUtilities 7.0
> If i can add some new features everyone would be happy, and I haven't had
> the chance to look at RDP.
>
> And, yes, still at CGI. I am wondering though how i would be able to break
> out into the self employment world that you did. Do you know the best
> headhunter to contact? And is it worth the effort?
>
> Les
>
>
>
> > You are such a shill :)
>
> > Heh.  Downloaded your latest version.  My contract, if you remember,
> > is at DFAIT, and we are having huge issues with RDP.  Though
> > ARUtilities doesn't fully replace RDP, it has some tools we can use.
> > Been trying to get the manager here to put in a purchase request.
>
> > Steve O'Leary
>
> > PS:  still at CGI?
>
> > On Dec 17, 11:12 am, rem...@arutilities.com wrote:
> >> Hello everyone,
> >> This is just a note to let you know that ARUtilities is available at a
> >> very special price until January 1st 2009.
>
> >> ARUtilities is a tool set used by many Remedy Developers around the
> >> world
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Sybase V15 - PATH keyword

[ccrashh]

Actually, we just discovered it is, in fact, a Sybase issue.  They
have released a patch that removes PATH as a keyword.  Go figure...BMC
passed the buck and they were correct :)

Steve


On Dec 17, 12:25 pm, Frank Caruso  wrote:
> Not exactly but am having similar issue  upgrading to Sybase15. The  
> installer needs to enclose keywords in quotes but it does not. BMC is  
> calling it a Sybase issue
>
> On Dec 17, 2008, at 10:54 AM, ccrashh  wrote:
>
> > We are trying to install ARS 7.1 onto a Sybase V15 database, and are
> > getting errors due to the PATH keyword.  Some of the Remedy base forms
> > use PATH as a fieldname, which is causing errors during install.  Has
> > anyone else come across this issue? Are you aware of a workaround?
>
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: set fields by process error

[ccrashh]

Have you tried this?

SET FIELDS:  process_char to "echo " + $Emain Body$ + "  | /home/
aramey/html2text-0.003/html2text.pl"

And then simply doing the PROCESS as:

$PROCESS$ $process_char$

Steve

On Dec 11, 10:44 am, "Ramey, Anne"  wrote:
> I am getting an exit code: 127 set fields action error when trying to use the 
> following in a set fields action to strip HTML from an email body:
> $PROCESS$ "echo ""$Email Body$"" | /home/aramey/html2text-0.003/html2text.pl "
>
> The process works fine when I run it from the command line:
> btw, it does work from the command line:
> r...@ncc db#  echo "Test headertest> Anne Ramey
> > test" | /home/aramey/html2text-0.003/html2text.pl
>
> Starting /home/aramey/html2text-0.003/html2text.pl ...
> Test header
> ===
>
> test
> Anne Ramey test
>
> Anyone know what exit code 127 means? or see any syntax errors?  I can't find 
> the set field error exit codes anywhere in the documentation.
>
> AR System 7.0.1 Patch 5, ITSM 7.0.03 patch 7 on Red Hat Linux.  Oracle 
> backend.
>
> Thanks,
>
> Anne Ramey
> ***
> E-mail correspondence to and from this address may be subject to the North 
> Carolina Public Records Law and may be disclosed to third parties only by an 
> authorized State Official.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Vista Issues with 7.0 User tool.

[ccrashh]

Isn't it always out of our control?  Sigh :)

Good luck with it.  Let us know your findings...I am sure many of us
will hit the same issue at some point.

Steve

On Dec 17, 11:29 am, "Begosh, Kevin"  wrote:
> That is out of my control :)
>
> Kevin Begosh, RSP
> Tech Ops
> Enterprise Business Services
> 301-791-3540 Phone
> 410-422-3623 Cell
> kevin.beg...@lmco.com
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of ccrashh
> Sent: Wednesday, December 17, 2008 11:28 AM
> To: arsl...@arslist.org
> Subject: Re: Vista Issues with 7.0 User tool.
>
> Not to be trite, but the "solution" is probably to downgrade to
> XP :).  Our department took one look at the resource hog that is
> Vista, and the crap that is the new version of Office and ran
> screaming...thank god.
>
> But yeah, as someone else posted, the spellchecker caused some issues
> when we tested it out.   There were others that screwed up apps, but
> they had more to do with drivers.
>
> Steve
>
> On Dec 16, 1:28 pm, "Begosh, Kevin"  wrote:
> > We are currently having some issues with a Vista user enterprise edition
> > with the user tool.  He is using the user tool version 7.0 and when he
> > clicks on any of the quick links or navigation bars nothing happens.  He
> > is able to open forms from the object list but none of the quick links
> > appear to work.  We are on AR Server 7.1 patch 4, UNIX OS.  Has anyone
> > heard of this or had any issue with this.   BMC said that there has been
> > no reports of any issues with this.
>
> > Kevin Begosh, RSP
>
> > 301-791-3540 Phone
>
> > 410-422-3623 Cell
>
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist:"Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Vista Issues with 7.0 User tool.

[ccrashh]

Not to be trite, but the "solution" is probably to downgrade to
XP :).  Our department took one look at the resource hog that is
Vista, and the crap that is the new version of Office and ran
screaming...thank god.

But yeah, as someone else posted, the spellchecker caused some issues
when we tested it out.   There were others that screwed up apps, but
they had more to do with drivers.

Steve

On Dec 16, 1:28 pm, "Begosh, Kevin"  wrote:
> We are currently having some issues with a Vista user enterprise edition
> with the user tool.  He is using the user tool version 7.0 and when he
> clicks on any of the quick links or navigation bars nothing happens.  He
> is able to open forms from the object list but none of the quick links
> appear to work.  We are on AR Server 7.1 patch 4, UNIX OS.  Has anyone
> heard of this or had any issue with this.   BMC said that there has been
> no reports of any issues with this.
>
> Kevin Begosh, RSP
>
> 301-791-3540 Phone
>
> 410-422-3623 Cell
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT: ARUtilities holiday special (ending soon)

[ccrashh]

You are such a shill :)

Heh.  Downloaded your latest version.  My contract, if you remember,
is at DFAIT, and we are having huge issues with RDP.  Though
ARUtilities doesn't fully replace RDP, it has some tools we can use.
Been trying to get the manager here to put in a purchase request.

Steve O'Leary

PS:  still at CGI?

On Dec 17, 11:12 am, rem...@arutilities.com wrote:
> Hello everyone,
> This is just a note to let you know that ARUtilities is available at a
> very special price until January 1st 2009.
>
> ARUtilities is a tool set used by many Remedy Developers around the world.
>
> For product details visit:http://www.arutilities.com/remedydevelopers.html
>
> I would like to thank everyone for your continued support.
>
> supp...@arutilities.com
> feedb...@arutilities.comhttp://www.arutilities.com
>
> Les Ganton
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Demote ARS 7.1 to ARS 6.3

[ccrashh]

I agree with the above posts - I don't think you can run a standard
"downgrade" like that.  Easiest approach is to remove everything from
your staging server, clear out the database, reinstall ARServer 6.3,
then import the code/data from your Production server.  This would be
safer than attempting to tweak things to downgrade it live.

On Dec 16, 12:58 pm, Amy  wrote:
> Our ARS environment is completely messed up and I need to revert back
> to our old configuration so that our staging server can mirror our
> production server.  Right now staging has ARS 7.1 with ITSM 6.3.  I
> need it to be ARS 6.3 with ITSM 6.3.  The server is on RedHat Linux.
>
> 1. Is there any uninstall required for ARS 7.1 other than removing the
> files from the server?
> 2. Do I need to worry about the ITSM installation or will I need to
> uninstall/reinstall it?
> 3. Is there anything else I should know before I start??
>
> I am the Remedy admin, NOT the UNIX admin, but since no one has time
> to do this right now I will be performing the installations myself.
> Unfortunately none of the UNIX admins or consultants who have done
> this before wrote anything down so pretty much all I have is the BMC
> documentation.  Any help you could provide would be much appreciated!
>
> Thanks!
>
> Amy Belile
> Remedy & OracleAS Portal Engineer
> School Specialty
> 3195 Wilson Dr NW
> Grand Rapids MI 49534
> 920-882-5630 Phone
> abel...@schoolspecialty.comwww.schoolspecialty.com
>
> Helping educators engage and inspire
> students of all ages and abilities to learn.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Sybase V15 - PATH keyword

[ccrashh]

We are trying to install ARS 7.1 onto a Sybase V15 database, and are
getting errors due to the PATH keyword.  Some of the Remedy base forms
use PATH as a fieldname, which is causing errors during install.  Has
anyone else come across this issue?  Are you aware of a workaround?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: BMC Remedy ARS + ITSM Interview Questions

[ccrashh]

I had an interview with RIM in the spring, and the first question they
asked me was:  What is an Active Link?

It would like asking someone who has been teaching for more than 10
years to recite the alphabet.  The interview essentially went downhill
from there.

On Nov 28, 7:44 am, "Frank, Gordon M. (CMS/CTR)"
<[EMAIL PROTECTED]> wrote:
> Some of the responses I am seeing on ARSList are a little complex.
>
> Here's some more common questions (remember your Resume will tell your
> capabilities):
>
> 1. What is the difference between and Active Link and a Filter?
> 2. What is a .def file used for?
> 3. What is a .arx file?
> 4. Who is Doug Mueller?
> 5. What is a use for an Active Link Guide?
> 6. What type of field it the "Worklog" field?
> 7. Name two DBMSs in which Remedy ARS can run on top of?
> 8. What does ARS stand for?
> 9. What are the core fields?
> 10. What does $MENU$ do?
>
> And so on. You'd be amazed at the number of interviews I've conducted
> and the interviewee couldn't answer these basic questions.
>
> A database question I like to ask is: What's the difference between
> SYSMAN and SYSTEM in an Oracle world?
>
> A very simple UNIX question is: What does LS do?
>
> Gordon M. Frank
>
> Remedy Skilled Professional
>
> ITIL V3 Certified
>
> Lockheed Martin
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:[EMAIL PROTECTED] On Behalf Of Salma
> Sent: Thursday, November 27, 2008 2:02 AM
> To: [EMAIL PROTECTED]
> Subject: BMC Remedy ARS + ITSM Interview Questions
>
> Dear Team,
>
> As i have completed my 1 year with ARS and ITSM application , planning
> to
> take up some interviews. Please can any one help me with some interview
> questions which are commonly asked . So that i can prepared for my
> interview
> .
>
> Please post me all the question which you guys faced during ur
> interviews .
>
> And also apart from ARS or ITSM , any possibilty of asking questions
> from
> other topics like Database, OS , Network , If yes please let me the same
> .
>
> Thanks in advance ,
>
> Salma
> --
> View this message in 
> context:http://www.nabble.com/BMC-Remedy-ARS-%2B-ITSM-Interview-Questions-tp2071
> p2071.html
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Core Fields Expand Box

[ccrashh]

Yes, thank you (I sent you an email).

Thanks again.

Steve

On Nov 28, 10:23 am, "Martin, Conny" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> We've done this using the Java-API. If you are interested in some code 
> snippet, let me know.
>
> Kind Regards Conny
>
> -Ursprüngliche Nachricht-
> Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
> Im Auftrag von ccrashh
> Gesendet: Freitag, 28. November 2008 15:56
> An: [EMAIL PROTECTED]
> Betreff: Core Fields Expand Box
>
> Someone asked this way back in 2007, but no one replied.
>
> In typical hamfisted fashion, BMC has shoved out a modification that impacts 
> every regular form - that is, the core character fields have increased from 
> 30 to 254.  This means, of course, that if you left the Expand Box option to 
> Default in the field properties, every one of the fields (Submitter, Last 
> Modified By, and Assigned To) has an Expand Box showing.  In most cases, this 
> has caused the GUI on our forms to look ridiculous.  Does anyone know of a 
> quick way to change the Expand Box option to Hide?  I was hoping for a cool 
> SQL statement like
>
> UPDATE field_dispprop
> SET  to 
> WHERE fieldid=4
>
> The above would update all Assigned To fields.  Of course, the option for the 
> expand box is in the proplong or propshort columns so it looks like crap and 
> is essentially unmodifiable.  Anyone know of an API call for this?
>
> Thanks for any help
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum 
> Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Core Fields Expand Box

[ccrashh]

You can't change the length of Core fields - unless you mean try to do
it at the database level?

Steve

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Core Fields Expand Box

[ccrashh]

Someone asked this way back in 2007, but no one replied.

In typical hamfisted fashion, BMC has shoved out a modification that
impacts every regular form - that is, the core character fields have
increased from 30 to 254.  This means, of course, that if you left the
Expand Box option to Default in the field properties, every one of the
fields (Submitter, Last Modified By, and Assigned To) has an Expand
Box showing.  In most cases, this has caused the GUI on our forms to
look ridiculous.  Does anyone know of a quick way to change the Expand
Box option to Hide?  I was hoping for a cool SQL statement like

UPDATE field_dispprop
SET  to 
WHERE fieldid=4

The above would update all Assigned To fields.  Of course, the option
for the expand box is in the proplong or propshort columns so it looks
like crap and is essentially unmodifiable.  Anyone know of an API call
for this?

Thanks for any help

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Count Rows selected

[ccrashh]

I know I can count the number of rows selected in a table by using a
table loop guide.  The actual "counting" isn't the issue.  What I would
like to do is count when I select the rows.  For instance, if I select
a row in a table, the Menu/Row Choice active links on that table
trigger.  If I shift-click or ctrl-click another row in the table, the
Menu/Row Choice active links DON'T trigger.

Short of creating a button that says "Count Number of Rows Selected",
does anyone have a way to count the rows selected AS you are selecting
them?  I tried playing with Gain Focus and Lose Focus events, but that
didn't work (sometimes the count was right, but the rows weren't
"highlighted").

Thanks for any help.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org