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

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

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

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

Re: ITSM naming convention sucks

2009-03-26 Thread ccrashh
). -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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

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

Re: Application Query Delete Entry

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

Re: Application Query Delete Entry

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

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

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

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

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

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,

Re: Vista Issues with 7.0 User tool.

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

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

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

Re: Sybase V15 - PATH keyword

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

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

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?

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

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

Re: Core Fields Expand Box

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

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

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