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"

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 ARSlis

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).

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). T

Re: ITSM naming convention sucks

2009-03-26 Thread ccrashh
ion 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 p

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" wrote: > "In my opinion, ITSP followed some best naming conventions." > > Well considering that as far a

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

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 g

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 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

Re: Remedy ODBC Drivers and 7.1

2009-02-25 Thread ccrashh
uestion 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] >

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 serve

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 btnCr

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 (str

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 ___

Re: Remedy Deve3loper Studio 7.5???

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

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 docume

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 wro

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

2009-02-04 Thread ccrashh
NG: 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. >

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.

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

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 wrote: > How to create many entries in Re

Re: Application Query Delete Entry

2009-01-08 Thread ccrashh
-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'

Re: Application Query Delete Entry

2009-01-08 Thread ccrashh
plication-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 >

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 ha

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 wrote: > Hi Friends, > I am facing

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

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

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

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

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.

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 _

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,

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

Interesting "Bug" in 7.1

2008-12-22 Thread 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 s

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, Se

Re: Sybase V15 - PATH keyword

2008-12-17 Thread ccrashh
e15. 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 key

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" wrote: > I am getting an exit code: 127 set fields action error w

Re: Vista Issues with 7.0 User tool.

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

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

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'

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

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?

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

Re: Core Fields Expand Box

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

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

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

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-c