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

2010-01-25 Thread 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: Check to make sure Char field doesn't contain a Percent sign (%)

2010-01-25 Thread 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


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

2009-07-14 Thread 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 iamfo...@gmail.com 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

2009-07-10 Thread 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 mbritt...@navisite.com 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.commailto:mbritt...@navisite.com
 (315) 453-2912 x5418 (Phone)
 (315) 317.2897 (Cell)

 Reduce Cost of IT with Managed Hosting and Application Services from NaviSite.
 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

2009-03-26 Thread 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 gavin.cole...@computacenter.com
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

2009-03-26 Thread 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 joe_rem...@yahoo.com 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 mchand...@gmail.com
 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 m...@worsy.co.uk 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/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

ITSM naming convention sucks

2009-03-20 Thread 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: ITSM naming convention sucks

2009-03-20 Thread 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


Re: LDAP integration in Remedy V6.3

2009-02-25 Thread 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 daniel.fra...@sbcglobal.net 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


Remedy ODBC Drivers and 7.1

2009-02-24 Thread 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

2009-02-19 Thread 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

2009-02-13 Thread 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???

2009-02-11 Thread 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


arsvcdsp process

2009-02-06 Thread 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

2009-02-05 Thread 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 rgha...@centerbeam.com 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.comhttp://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

2009-02-04 Thread 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 bryancwat...@gmail.com 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 ccra...@gmail.com 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

2009-02-04 Thread 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
christopher.pru...@eds.com 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

2009-01-28 Thread 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?

2009-01-09 Thread 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 d90...@yahoo.com 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

2009-01-08 Thread 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 kaushal.coold...@gmail.com 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:
 ACTL          1: Run Process
 ACTL             Application-Query-Delete-Entry
 KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete
 ACTL               Process: Application-Query-Delete-Entry
 KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete
 ACTL                   Failed
 ACTL                  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: Active Link works on dev; not on prod

2009-01-08 Thread 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 joe_rem...@yahoo.com 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 gary.opela@tinker.af.mil
 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:

 WFLG /* Wed Jan 07 2009 14:35:26 */
 WFLG Workflow Trace Log -- ON
 ACTL /* Wed Jan 07 2009 14:35:28 */
 ACTL Start active link processing -- Operation - On Menu Choice
 ACTL    For Schema - HD: My Stats
 ACTL    Linked to field - Table Properties: (536870936)
 ACTL    On screen type - CREATE
 ACTL Checking HD: MS: Set Table Qual on Table Properties: Change (10)
 ACTL    - Passed qualification -- perform if actions
 ACTL          0: Set Fields
 ACTL            Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 
 'Create Date' = 04/01/2008)
 ACTL Checking HD: MS: Refresh tbl_My Tickets (50)
 ACTL    - Passed qualification -- perform if actions
 ACTL          0: Set Characteristics
 ACTL            For field -- Tickets (536870932)
 ACTL              Refresh field
 ACTL          1: Set Fields
 ACTL            Ticket Count: (536870937) = 21
 ACTL /* Wed Jan 07 2009 14:35:28 */
 ACTL Stop active link processing - On Menu Choice
 WFLG /* Wed Jan 07 2009 14:35:34 */
 WFLG Workflow Trace Log -- OFF

 Prod:

 WFLG /* Wed Jan 07 2009 14:34:54 */
 WFLG Workflow Trace Log -- ON
 ACTL /* Wed Jan 07 2009 14:35:02 */
 ACTL Start active link processing -- Operation - On Menu Choice
 ACTL    For Schema - HD: My Stats
 ACTL    Linked to field - Table Properties: (536870936)
 ACTL    On screen type - CREATE
 ACTL Checking HD: MS: Set Table Qual on Table Properties: Change (10)
 ACTL    - Passed qualification -- perform if actions
 ACTL          0: Set Fields
 ACTL            Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 
 'Create Date' = 04/01/2008)
 ACTL Checking HD: MS: Refresh tbl_My Tickets (50)
 ACTL    - Passed qualification -- perform if actions
 ACTL          0: Set 

Re: Application Query Delete Entry

2009-01-08 Thread ccrashh
Huh...didn't even notice the Log stating ACTLjust 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 kaushal.coold...@gmail.com 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 conny.mar...@t-systems.com 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 kaushal.coold...@gmail.com 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:
   ACTL          1: Run Process
   ACTL             Application-Query-Delete-Entry
   KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete
   ACTL               Process: Application-Query-Delete-Entry
   KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete
   ACTL                   Failed
   ACTL                  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: Application Query Delete Entry

2009-01-08 Thread 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 conny.mar...@t-systems.com 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 ACTLjust 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 kaushal.coold...@gmail.com 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 conny.mar...@t-systems.com 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 kaushal.coold...@gmail.com 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:
ACTL          1: Run Process
ACTL             Application-Query-Delete-Entry
KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete
ACTL               Process: Application-Query-Delete-Entry
KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete
ACTL                   Failed ACTL                  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


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

2009-01-06 Thread 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 open a window on a set field action with multiple request match

2009-01-06 Thread 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


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

2009-01-06 Thread 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 salmabeg...@gmail.com 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: File / Send Mail feature question

2009-01-06 Thread 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: Creating Decrementing value in Table

2008-12-30 Thread 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: How to submit and modify incidents/problems through email.

2008-12-30 Thread 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

2008-12-29 Thread 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


Re: OT: ARUtilities holiday special (ending soon)

2008-12-18 Thread 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: Vista Issues with 7.0 User tool.

2008-12-17 Thread 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 kevin.beg...@lmco.com 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 kevin.beg...@lmco.com 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: set fields by process error

2008-12-17 Thread 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 anne.ra...@its.nc.gov 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 h2Test header/h2brtestbr 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: Demote ARS 7.1 to ARS 6.3

2008-12-17 Thread 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 abel...@schoolspecialty.com 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


Re: Sybase V15 - PATH keyword

2008-12-17 Thread 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 caruso.fr...@gmail.com 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 ccra...@gmail.com 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: Vista Issues with 7.0 User tool.

2008-12-17 Thread 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 kevin.beg...@lmco.com 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)

2008-12-17 Thread 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


Sybase V15 - PATH keyword

2008-12-17 Thread 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


Core Fields Expand Box

2008-11-28 Thread 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 something to something
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


Re: Core Fields Expand Box

2008-11-28 Thread 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


Re: Core Fields Expand Box

2008-11-28 Thread 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 something to something
 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: BMC Remedy ARS + ITSM Interview Questions

2008-11-28 Thread 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


Count Rows selected

2006-10-02 Thread 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