Nice thought.. I will need to strip the extension part out first though if I
were to go that way.. Will need to toy over that idea and see if I can come
out with something better than that..
I still wish Remedy did have a TRANSLATE equivalent! Would have made life so
much more easier..
Cheers
Jo
Since it seems like no matter what, this is gonna suck, how about this?
Create another field. Then have it set the first number out of the field
you are trying to clean. You can use the results of a function to populate
the value in another function. So test for the location of the first
number
Rick,
Not sure if you can use the ASCII range, never tried it..
Thad,
Yes same phone number issue and while doing it directly at SQL yes I did use
Upper before Translate so I have to translate less...
The actual select statement that I designed, as a result of all the
formatting that was necess
Joe,
Sorry, I'm not sure there's an easy answer to this one without using the
SQL. I think you'll have to loop through the string one character at a
time to doing your find and replace. Some thoughts though:
1. Does this have to do with your phone number formatting issue? Would
it be easier
Hello All,
We are migrating legacy data from a 5.X Server to a 7X server using AR
Migrator 7.00.01.
Core Fields are not being migrated. I know the core field lengths were
increased with Version 7, but don't think it would be an issue because
smaller core field lengths from pre-7 versions are being
Can ranges of characters (like ASCII ranges) be used in the REPLACE
function?
Rick
On Fri, Mar 28, 2008 at 3:00 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote:
> ** Has anyone implemented the equivalent of the Oracle TRANSLATE function
> in Remedy?
>
> I have a field where I wish to translate all the
That won't work; there is something else firing on close window or something
else. Turn on the AL logs, find out what it is (more than likely display
only fields getting set by a close window AL); if they are display only
fields, disable the change flag on those fields. Alternatively, add an AL
o
Has anyone implemented the equivalent of the Oracle TRANSLATE function in
Remedy?
I have a field where I wish to translate all the alpha characters into lets
say ^ and then replace ^ with null to make that field free of alpha
characters.
The only way I can think it is possible right now is to hav
Ah, yes - of course. I'll try that now.
Thank you,
Ron
Tools Admin
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, March 28, 2008 2:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Migrating HD 6 cases to Incident 7?
** The big
There is another way that will still require some customizations. Copy over the
HPD:Helpdesk from 6 and then import the records into the form they came from.
Create the workflow needed to create a new Incident and relate the old helpdesk
ticket. This will reduce your need to map fields.
-O
I don't get that error. I am on a windows box, but using an oracle db. I
am also on 7.0.1 Patch 002. So it is either the version of Remedy, or the
db. I would still put in a ticket on it. sounds like a bug to me.
Brian
On Fri, Mar 28, 2008 at 4:11 PM, Elry <[EMAIL PROTECTED]> wrote:
> Yes..
The biggest thing, Ron, is not to try to push directly into HPD:HelpDesk.
Push into the Interface_create form, which already has filters in place to
grab some of the arcane data elements needed from other forms. It'll save
you a ton of work.
Rick
On Fri, Mar 28, 2008 at 2:22 PM, Ron Legters <[EM
Can anyone point me to some doc re migrating existing HD6 cases to
incident 7? I've searched BMC support to no avail, and I've searched the
ARSList and found a reference to a webcast from BMC that doesn't appear
to be there any longer. I'm only moving over a couple of hundred active
cases so it doe
Yes...
It is a bit unusual, but we were able to replicate it in three
different environments.
Try creating a field called "Function" to see if you guys can
replicate the error.
If you can - then I think I will put in for an enhancement request.
On Mar 28, 2:27 pm, Brian Goralczyk <[EMAIL PROT
Classification: UNCLASSIFIED
Caveats: NONE
Related topic with the Drop-Down List:
On the Summary+ field on the Requester Console, we have the Summary menu
set as some have recommended here: drop-down list with a menu. The query
works correctly if I make the menu editable, but it doesn't force
Thanks Misi. This give me a good direction to start looking. I
appreciate you taking the time to give the suggestions.
On Mar 26, 3:40 pm, Misi Mladoniczky <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I do not know exactly what happened. I suspect a filter that pushes some
> fields to the form "CTM:People
Some add'l info:
(dbx) stop in ARTermination
dbx: warning: 'ARTermination' has no debugger info -- will trigger on first
instruction
(2) stop in ARTermination
(dbx) rerun
Running: sendrem
(process id 2990)
RTC: Enabling Error Checking...
RTC: Running program...
[EMAIL PROTECTED] ([EMAIL PROTECTED]
Yea, I have never seen it on a field before. But at least it was an easy
fix.
On Fri, Mar 28, 2008 at 1:22 PM, Grooms, Frederick W <
[EMAIL PROTECTED]> wrote:
> I have seen something like this before. All I had to do was just open
> the form in the Admin tool and change the database name of the
I have seen something like this before. All I had to do was just open
the form in the Admin tool and change the database name of the field.
When the Admin tool saved the form it created the view automatically.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
OK, I think I'm onto something here. The command works just fine with the
7.1 version of arimportcmd (against either a 6.3 or 7.1 server), but the
same command using the same files reports an error on the 6.3 version of
arimportcmd. Since I can't think of a reason that the 7.1 version would
intro
I second Drew's suggestion, change the order up, close window, and then
commit changes.
If you have the commit first, for some strange reason, it closes the
window first, I've never understood why. Just give it a try.
I know that if I'm opening another window, and closing the current one,
that I
A very simple program (does nothing, really, except create an arcontrol
struct):
[EMAIL PROTECTED] scratch]$ cat sendrem.c
#include
#include
#include
#include
int main
(
int argc,
char *argv[]
)
{
ARControlStructcontrol;
ARFieldValueList fieldList;
AREntryIdType
Can someone tell me the issues with changing Oracle and Remedy to be case
insensitive? I have seen many posts in the past about performance hits
and not being able to use "LIKE" searches, but do those things still
apply?
ARS 7.01
ITSM 7.02
Oracle 10g
Thanks!
Melissa
_
Rick,
Have you looked at the help information in the Admin tool? Just go search
arimportcmd or look at Using the BMC Remedy Import CLI.
Maybe that will help. I can't offer anymore than that as I have never used
the tool that way. Personally, I would just write a perl script that would
load the
I haven't run into this exactly, but I have run into a case where a view was
manually created in the database and then a form with the same name was
created and Remedy wasn't able to create the view. That caused some grief.
On Fri, Mar 28, 2008 at 12:09 PM, Elry <[EMAIL PROTECTED]> wrote:
> Hi F
You also might want to use run process of PERFORM-ACTION-APPLY to do a save.
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Tanner, Doug
Sent: Friday, March 28, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Commit Changes
Hi Folks:
(A) Environment:
Windows Server 2003
MSSQL Database 2000
ARS: 7.1.00 Build 200708221849
(B) Error Message
"Creation of one of the SQL views for the form failed within the SQL
database.
Operation completed successfully, but the SQL view is not in place.
(ARWARN 69)."
(C) Root Cause:
Ke
What you are trying should work just fine, there is additional workflow
that is firing, put some AL/Filter logging on it
Doug
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark
Sent: Friday, March 28, 2008 12:07 PM
Hi Mark
Add a Run Process of Set-Change-Flag 0 after the Commit Changes and before
the Close Window
HTH
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
See the ESS Concepts Guide
t
Try Close Window, Commit Changes instead.
Drew
On Fri, 28 Mar 2008, Brittain,
Mark
wrote:
Hi All & TGIF
This one is cooking my noodle becaue it should work as it.
I want to use a save button instead of the one on the top right corner of the
form. Attached to the save button I have an act
Hi All & TGIF
This one is cooking my noodle becaue it should work as it.
I want to use a save button instead of the one on the top right corner of the
form. Attached to the save button I have an active link that performs two if
actions
Commit Changes
Close Window.
When I press the save but
Nope - the password is "password". Portmapper is in place.
Rick
On Fri, Mar 28, 2008 at 5:52 AM, Roger Medsker <[EMAIL PROTECTED]> wrote:
> **
>
> Rick,
>
>
>
> Do you have a special character in the password? That may be throwing the
> command line interpreter off. I've gotten into the habit o
If the server isn't registered with the port mapper I believe you can pass
the port number using the -a parameter.
--- J.T. Shyman
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Chad M Whilding
Sent: Friday, March 28, 2008 9
Hi everyone,
we have a home grown order management system where there is the main
order ticket that can have approval tickets and tasks attached to it.
Acctually there is much more, but it doesn't matter here.
All of the tickets belonging to the main order ticket need to have
same Assignee Group.
Rick,
Two problems my colleague Jayson has discovered
If the encrypted password has a / in it, the import fails. There may be
other potential characters that cause a problem.
If the server is NOT registered with the portmapper and you try and us a
mapping, the import fails.
Regards,
Chad Whildi
Rick,
Do you have a special character in the password? That may be throwing the
command line interpreter off. I've gotten into the habit of always putting
quotes around my password; even if it doesn't have a special character. You
might also try using the parameters to specify the mapping file
You also have to enter each field into SHR:ARDBCFields and you must
stop and start remedy services after you have done this.
Field ID: 955750016
Form GUID:MAINHELPDESK
Vendor Field ID: 95575
GUID:
Submitter:
The field ID is the ID of your field in
Dear ARS Listers -
This is a reminder of the upcoming Washington D.C. Area Remedy Users Group
(WARUG) meeting on Friday 11 April 2008 again at the Booz Allen Hamilton
building in Mclean, VA. The agenda for the meeting is as follows:
8:00 - 9:00 Refreshments - Attendees Arrive,
Outstanding! This really helps - THANK YOU to all who replied!!
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Powell
Sent: Thursday, March 27, 2008 4:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Installation Question...
**
For what it's
Thanks - I know where they exist. The problem is when I search all
the Filters there are no references to these Notifications.
Ty
On 3/28/08, Saravanan Palaniappan <[EMAIL PROTECTED]> wrote:
> This exist in the sys: notification messages.
>
> Thanks & Regards
> Saravanan Palaniappan
> ITSM
>
>
Hi list,
I have a requirement to add SLA due date for response and resolution
in the ITSM 7 over view console table.
The field (SVTDueDate) is available in the SLM:Measurement form which
stores the SLA Duet Date for both response and resolution records for
each of the Help Desk and Chan
++
Please Read The Disclaimer At The Bottom Of This Email
++
Hi list,
I was wondering if anybody seen this behaviour.
I have configured a service request definition which creates a single work
Folks,
How have you managed to ensure ITIL guidelines are followed when minor changes
are made to CIs?
eg. when a PC asset changes Status or location how do you ensure that they go
thru' a minimal Change Request process.
I believe there is an automated method within the Remedy suite?
On that sa
Wait, I forgot one important thing that really addresses the core or
your question.
When I compare my PTG Archive and the current workflow, I get an
comparison report which contains all changes documented. I can save
this report or print it.
I'm using this tool since a few years and recommend it
Hi,
I'm using the Panacea Workflow Studio (www.pws-europe.com), which is a
migration and a developmer tool. With the Workflow Studio you can
export any workflow into a XML Archive they're calling PTG.
Having workflow inside a PTG I can browse it like I would browse it
inside of the Admin Tool. I
Hello,
we have three ARS systems: development, integration and production.
Since using the Version 6 we have the problem, that when you login on
for instance the dev server with your user tool and you log out and
log in on the integration server with your use tool, then you will get
a white screen
46 matches
Mail list logo