Re: SQL Statements and Logs

[Rick Ponzo]

Hi Lisa,

This may apply to your situation:

Use the Direct SQL action to submit any legal SQL command to the database.
The Direct SQL action has a different result than the SQL command you use
to set a field value in the Set Fields action. In the Set Fields action, 
you use

SQL to query the database for information and then use the returned value
to set a field. With the Direct SQL action, the SQL command is not expected
to return data. For example, you can define a Direct SQL action to perform
inserts or updates to a database.

I pulled this from the Workflow Objects 7.0 manual, page 64.

Rick Ponzo
IntegrITS Corp




Kemes, Lisa wrote:

**
I have a SQL Statement on my Active Link that's like:  Select * from 
gbl_ship...@xyz_gewp2.
 
It's not working, so I turned on the SQL Logs (in the Admin Tool)  and 
it's showing: Select * from gbl_ship_to_someth...@aaa_dkw2.  (I'm 
making names up here).
 
The fact is that my SQL Statement on my AL is different than it is in 
the logs.
 
When I run gbl_ship...@xyz_gewp2 straight from the database it works, 
so I don't think it's a db problem.
 
Anyone ever see this before?
 
ARS 7.1

Oracle 10i
Windows 2003 Server
 
 
*Lisa Kemes** *

AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
lisa.ke...@tycoelectronics.com
 
 
 
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" 
html___ 


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

Re: Permissions & Roles

[Rick Ponzo]

I don't know if you've had this answered...but you would map the role to 
the group in the Roles form.


Rick

arsadm wrote:
** Hi All... I created a new custom permission group, i want to map 
this group to roles. So that people of that group can modify some 
fields in the existing form. Can anyone please help from this ??? 
Thanks in advance. ARS 7.1.00 Patch : 001 200711161033 5 MS SQL 2005


View this message in context: Permissions & Roles 

Sent from the ARS (Action Request System) mailing list archive 
 at 
Nabble.com.
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" 
html___ 


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

Re: escalation

[Rick Ponzo]

Rick,

I believe you misunderstood Matt... One of the properties on the field 
is "Disable Change Flag" located on the Display Tab of the field 
properties. If the Disable Change Flag box is checked then the field is 
ignored during the modify process.



Rick Ponzo
IntegrITS


Trevino, Rick wrote:

**

Matt, thanks for the input, the change flag does get updated by the 
escalation, but it does not trigger the filter.


I will try the display field process

Thanks again !



*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Matt Reinfeldt

*Sent:* Friday, October 10, 2008 10:55 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: escalation

Rick,

Is it possible that you have disabled the change flag on the field 
you’re using as the “flag”? That could account for the filter not 
seeing a modification to it. I’ve always used a Display-Only field 
called “Operation” for these types of events. I have the escalations 
set a value in that field, such as “EXECUTE DATA RUN” and have a 
filter kick off a filter guide to process the specific work needing to 
be done when that value is seen. Has always worked for me.


Good luck,

Matt Reinfeldt

*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Trevino, Rick

*Sent:* Friday, October 10, 2008 10:49 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: escalation

**

John, yes the flag gets set on the form, I thought with me setting the 
flag on the form that would modify it and trigger the filter, but it 
does not work,


But if I go and change anything on the form it will trigger the filter,

Thanks!

*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *John Atherly

*Sent:* Friday, October 10, 2008 10:39 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: escalation

**
Is the flag being set on the form if not is the Escalation runnning?


John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120

*"Trevino, Rick" <[EMAIL PROTECTED]>*
Sent by: "Action Request System discussion list(ARSList)" 



10/10/2008 11:30 AM

Please respond to
arslist@ARSLIST.ORG



To



arslist@ARSLIST.ORG

cc



Subject



escalation






**
Good morning everyone,
Does anyone know how to trigger a filter from an escalation,
I have tried to set up a flag and set it with an escalation so it can 
modify the form, to trigger the filter on modify and it does not work, 
but if I modified the form manually it will kick off the filter.

Has anyone had to do this before,
Thanks Rick

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the 
Answers Are" html___ 


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

6.3 to 7.1 upgrade - webservice question

[Rick Ponzo]

Has anyone experienced issues with the upgrade from 6.3 to 7.1 with 
regard to Web Services?


Thanks,
Rick Ponzo

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

Re: WebService error

[Rick Ponzo]

Hi Chintan,

Take a look at the filter log.  The error may be because of workflow 
that does a push fields action to another form, which is where the error 
comes from.


Rick Ponzo

Chintan Shah wrote:

** Hello all,

I am setting a required field from a web-service client.
But, when I open the form with the request ID that was returned on 
response, I get this error msg
ARERR [326] Required field cannot be reset to a NULL value : 

I thought I should be getting this error message on my create 
response, instead I got a successful ticket number back which means 
all the required fields are properly set.


When I check the mid-tier logs, it has
Jun 17, 2008 2:13:59 PM - WARNING (com.remedy.midtier.WORKFLOW) : 
(Thread 32) Caught exception while binding action list - dropping 
action : ARERR [-1] Message not found
Jun 17, 2008 2:13:59 PM - FINE (com.remedy.midtier.WORKFLOW) : (Thread 
32) com.remedy.arsys.goat.ActionSetFields: Error binding set-fields 
action 1 - dropping action



This is seen just after a successful ticket number is created.

I am on
Midtier version  Version 6.03.00 patch 021

Has anyone seen anything like this?

Thanks
Chintan.

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___




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

Re: OT: BBQ tour

[Rick Ponzo]

Hey Rick,

I don't know how you plan to get down south, but if you pass thorough 
Arizona you'll want to try Joe's Real BBQ 
(http://www.joesrealbbq.com/).  This place has been on many of the 
cooking channels nationally.


If you are going south down the coast through California then you'll 
want to pass through Santa Maria where they have some of the best BBQ in 
the west.  I was co-owner of a restaurant in Long Beach that served 
Santa Maria style BBQ and it was extremely popular.  Santa Maria is 
known for BBQ using rubs rather than sauces, although they have sauces 
too.  They also have unique BBQ beans that you can only find there.


I hope you both have a great trip!

Regards,
Rick Ponzo


Rick Cook wrote:
** My son just graduated from HS, and will leave for the Marines in 
October.  Sometime between now and then, he and I are going to drive 
cross-country on a BBQ tour.  We'll start and end in Seattle, but we 
intend to hit all of the areas of the country famous for BBQ:  Texas, 
Louisiana, the rest of the South, North Carolina, Memphis, Chicago, 
and Kansas City.


We're still planning the specifics, and here's where all y'all come in:

I would love to know THE places to go in your part of the country 
(assuming it's one I mentioned above - this will be almost entirely 
SOUTH of the Mason-Dixon line) for outstanding BBQ, whether they're 
famous or a hole-in-the-wall.  We'll stay away from big chains for the 
most part (we have Famous Dave's up here), unless it is a 
local/regional one with a good local reputation.


Thanks in advance for sharing!

Rick
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 


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

Re: Field Conversion

[Rick Ponzo]

Jean,

The data is stored in the database using the Field ID, not the label 
value.  Changing the label will not affect the data.  If you are 
considering deleting the old field and creating a new field then you 
will lose the data.  The way to do that is to create the new field and 
copy all of the old data to the new field. 


Rick Ponzo



Hugo Kom Lan wrote:

** Hi everyone,
 
I've been working with a form for a while where there is a stored 
field called, say, xInitialValue. Now I want to convert this field to 
a temporary field zInitialValue because we don't need those values 
stored anylonger. Does anyone know what the repercussion of such a 
conversion will be? What would happen to the values already stored in 
the database under the old field name xInitialValue?

We are using Oracle 9i
ARS 6.0
 
Thanks for your help!
 
Jean



Use video conversation to talk face-to-face with Windows Live 
Messenger. Get started! 
<http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_042008>__Platinum 
Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 


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

Re: Open Window to act like an Error Message

[Rick Ponzo]

Lisa,

After the call to the open window you can use a Goto Action and set the 
execution order to 1000, which should be higher than any workflow that 
will execute after it.


Rick Ponzo



Kemes, Lisa wrote:

**

I hate how the Messages look in the AR User Tool, so I create pretty 
dialogue boxes and use the open window action to relay my messages. 
But when it's an error message (and I want the action to stop) the 
Open Window Dialog box doesn't work. (it works, but the action does 
not stop when they click the close button, the action just keeps 
going) Whether it’s a push, or set, etc…action...


Is there any way to make a "purty" error message?

*Lisa Kemes/ /*
AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
[EMAIL PROTECTED]


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 


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

Re: Web Service - OpGetList

[Rick Ponzo]

If you look at chapter 13 of the advance guide for 6.3 you should find 
exactly what you're looking for.





Francois Seegers wrote:

We are running 7.0.1 patch 5 at the moment and the web service we will be
consuming run on 6.3.  I am testing this first on a virtual machine with 7.1
installed.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
Sent: 25 February 2008 06:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service - OpGetList

Francois,

Which version are you running?

Rick Ponzo


Francois Seegers wrote:
  

Hi Rick,

This is between 2 Remedy server and the forms resides on each server
respectively.  Which manual do you refer to.  The manuals I have reference
do not fully explain this process.

Regards
Francois

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
Sent: 25 February 2008 04:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service - OpGetList

Hi Francois,

I'm assuming you are talking about two different Remedy forms, and even 
if you aren't, yes, this is very feasible. I can't explain the whole 
process...it's better that you use the example in the Remedy manual 
because there are many details in the process.



Rick Ponzo


Francois Seegers wrote:
  


**

Hi All,

Can one use the OpGetList operation in a web service to return 
multiple records and use the results to populate another form with the 
results received from the OpGetList?


*Scenario:*

* *

Ø Form A holds for example 10 records with a flag set to “No”.

Ø Using web service to retrieve the records where this flag is set to 
“No” and create them in Form B


Regards

Francois

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date: 
2008/02/24 12:19 PM


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

  



  

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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date:


2008/02/24
  

12:19 PM
 


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date:


2008/02/24
  

12:19 PM
 






___
  

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

  




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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date: 2008/02/24

12:19 PM
 


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date: 2008/02/24

12:19 PM
 


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

  


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

Re: Web Service - OpGetList

[Rick Ponzo]

Francois,

Which version are you running?

Rick Ponzo


Francois Seegers wrote:

Hi Rick,

This is between 2 Remedy server and the forms resides on each server
respectively.  Which manual do you refer to.  The manuals I have reference
do not fully explain this process.

Regards
Francois

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
Sent: 25 February 2008 04:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service - OpGetList

Hi Francois,

I'm assuming you are talking about two different Remedy forms, and even 
if you aren't, yes, this is very feasible. I can't explain the whole 
process...it's better that you use the example in the Remedy manual 
because there are many details in the process.



Rick Ponzo


Francois Seegers wrote:
  

**

Hi All,

Can one use the OpGetList operation in a web service to return 
multiple records and use the results to populate another form with the 
results received from the OpGetList?


*Scenario:*

* *

Ø Form A holds for example 10 records with a flag set to “No”.

Ø Using web service to retrieve the records where this flag is set to 
“No” and create them in Form B


Regards

Francois

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date: 
2008/02/24 12:19 PM


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 




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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date: 2008/02/24

12:19 PM
 


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date: 2008/02/24

12:19 PM
 


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

  


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

Re: Web Service - OpGetList

[Rick Ponzo]

Hi Francois,

I'm assuming you are talking about two different Remedy forms, and even 
if you aren't, yes, this is very feasible. I can't explain the whole 
process...it's better that you use the example in the Remedy manual 
because there are many details in the process.



Rick Ponzo


Francois Seegers wrote:

**

Hi All,

Can one use the OpGetList operation in a web service to return 
multiple records and use the results to populate another form with the 
results received from the OpGetList?


*Scenario:*

* *

Ø Form A holds for example 10 records with a flag set to “No”.

Ø Using web service to retrieve the records where this flag is set to 
“No” and create them in Form B


Regards

Francois

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.0/1296 - Release Date: 
2008/02/24 12:19 PM


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 


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

Re: How to copy the content of the field 112 into another field?

[Rick Ponzo]

Hi Mark,

One way is to have a filter pull the Group Name from the Group Form into 
a hidden field whenever the Assignee Group field is changed.  Set this 
filter to execute AFTER the filter that copies the Group Name into the 
diary field.  Set the diary field to pick up the name from this new 
field instead of the Assignee Group field when there is a change in 
Assignee Group.


I know there are other ways to do this...but this works for me every time.

Rick Ponzo


Mark Milke wrote:

Hello!

I'm still using ARS 6.3. Is there a way to copy the groups names
visible in the User Tool into another Tool via Workflow or do I really
have to start a bunch of queries to the DB to figure out the Group
name behind the ID?

The backgroud of my question is:
I have a regular form, where the user is allowed to set the Assignee
Group field manually, i.e. via the attached menu. When he changes the
value however, I have to put the old Assignee Group string into the
Diary field. I was trying to do this with a filter, but I have a bunch
of IDs instead of the real group names...

Thanks in advance for your suggestions.

Mark

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

  


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

Re: Multi-qualified Web Service Search

[Rick Ponzo]

Is Status the name of the element on the input mapping?  If not, it 
should be.


Rick Ponzo



versicle wrote:

Yes. Here is the error I'm receiving when passing a NULL value:

ERROR (4558): Qualification line error;

Also here is the Qualification:
'Status' = XPATH(/ROOT/Status)


Rick Ponzo-2 wrote:
  
When you created the web service did you set the data elements value 
Nillable = True for each of the fields?


Rick Ponzo


versicle wrote:


All,

I have created a WS based on the HelpDesk form and we have a business
requirement from a web Portal to be able to search for tickets based on
one
or MORE of the following fields, Customer Last Name, Ticket Number,
Company,
Status, and Priority. I have created an search operation and mapped all
of
the fields above. However, I only receive responses when each of the
fields
has a value entered for the search otherwise an error is returned. Is
there
a way to have a wildcard in the search or a NULL value for one of those
fields I dont care about when executing the search?

I am running ARS 7.1 patch001 and IM 7.0.03 patch006 on Solaris 10.

Thanks,

Mike
  
  

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





  


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

Re: Multi-qualified Web Service Search

[Rick Ponzo]

When you created the web service did you set the data elements value 
Nillable = True for each of the fields?


Rick Ponzo


versicle wrote:

All,

I have created a WS based on the HelpDesk form and we have a business
requirement from a web Portal to be able to search for tickets based on one
or MORE of the following fields, Customer Last Name, Ticket Number, Company,
Status, and Priority. I have created an search operation and mapped all of
the fields above. However, I only receive responses when each of the fields
has a value entered for the search otherwise an error is returned. Is there
a way to have a wildcard in the search or a NULL value for one of those
fields I dont care about when executing the search?

I am running ARS 7.1 patch001 and IM 7.0.03 patch006 on Solaris 10.

Thanks,

Mike
  


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

Re: Changing Form View Depending on Operation

[Rick Ponzo]

Mike,
After considering that option please ignore my suggestion  Let me 
think about it some more!


Thanks,
Rick


Rick Ponzo wrote:
If I understand what you're asking you can accomplish this using an 
Active Link that fires on Search.  Your action would be Open Window, 
selecting the view that you would want to display.


Regards,
Rick Ponzo


Kendhammer, Mike wrote:

Hello,

 


Hopefully I can explain this...

 


I have a form that I open in Search mode, opens a particular view (Query
View).  Once the search button is clicked to perform the search, I would
like the resulting form that opens in Modify mode open in a different
view (Modify View).

 

 


I haven't seen any settings or commands that might be available that
would change the view that you are using.

 


And other than maybe using field 1005 for the Advanced Search Bar, I am
unaware of a way to capture the search qualification in a separate field
should the user enter data directly into one or more fields, then use
the data from that field in the qualification of an Open Window action.

 

 


Can this be accomplished?
 


Thanks!

Mike

 


System specs:

ARS 7.0.1 patch 2

HP-UX 11i

Oracle 10g

 



___ 


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

  


___ 


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



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

Re: Changing Form View Depending on Operation

[Rick Ponzo]

If I understand what you're asking you can accomplish this using an 
Active Link that fires on Search.  Your action would be Open Window, 
selecting the view that you would want to display.


Regards,
Rick Ponzo


Kendhammer, Mike wrote:

Hello,

 


Hopefully I can explain this...

 


I have a form that I open in Search mode, opens a particular view (Query
View).  Once the search button is clicked to perform the search, I would
like the resulting form that opens in Modify mode open in a different
view (Modify View).

 

 


I haven't seen any settings or commands that might be available that
would change the view that you are using.

 


And other than maybe using field 1005 for the Advanced Search Bar, I am
unaware of a way to capture the search qualification in a separate field
should the user enter data directly into one or more fields, then use
the data from that field in the qualification of an Open Window action.

 

 

Can this be accomplished? 

 


Thanks!

Mike

 


System specs:

ARS 7.0.1 patch 2

HP-UX 11i

Oracle 10g

 



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

  


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

Re: need help to figure out $TIME$!

[Rick Ponzo]

One observation - your first qualification uses AND, your second uses OR.


Rick Ponzo



Elinore AR wrote:

can any of you folks help me?

i am trying to test $TIME$ if it falls between 06:00-18:00 CST (server
is in CST)

this is the qualification i am using:

( ($TIME$ >= (60 * 60 * 6)) AND ($TIME$ < (60 * 60 * 18)) )

and it's not working!

when i try to reverse the qual to test if $TIME$ is between
18:00-06:00 CST like this:

( ($TIME$ >= (60 * 60 * 18) ) OR ( $TIME$ < (60 * 60 * 6)) )

it works just fine.

what's wrong with the 1st qualification?

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

  


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

Re: Competitors to Remedy ARS?

[Rick Ponzo]

SugarCRM may be an option.  Some people re-sell it, but it can also be 
found for a free download.


Rick Ponzo


Alec Alec wrote:

Is HotBasic open source, or have an affordable licensing model?
Sent via BlackBerry from T-Mobile

-Original Message-
From: Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]>

Date: Thu, 4 Oct 2007 09:57:00 
To:arslist@ARSLIST.ORG

Subject: Re: Competitors to Remedy ARS?


Or HotBasic.  With HotBasic you type this:

CREATE newForm AS FORM
END CREATE
newForm.SHOWMODAL

and then hit the F5 key and voila! A Windows form appears on the screen.

Then do this:

CREATE newForm AS FORM
CREATE newEditField AS EDIT
END CREATE
END CREATE
newForm.SHOWMODAL

and your form now appears with a character field on it.

Very, very easy.  Much easier than .Net, yet with comparable
capabilities.

Norm

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn
Sent: Thursday, October 04, 2007 9:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

Perhaps you should give more requirements.  You mentioned that you want
something like ARS, but don't really care about ITSM or any specific
type of module.  It sounds like you're wanting to build custom database
driven applications, right?  If so, rather than looking at something
like Remedy, you'd be better off finding a traditional development
language that has a good interface to build forms and back end workflow.
I don't know of any as easy as Remedy, but .NET would be a good option
for something similar.

Shawn Pierson

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alec Alec
Sent: Thursday, October 04, 2007 9:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?


I require the email functionality.  



Sent via BlackBerry from T-Mobile

-Original Message-
From: "Opela, Gary L Contr OC-ALC/ITMA"
<[EMAIL PROTECTED]>

Date: Thu, 4 Oct 2007 09:36:35 
To:arslist@ARSLIST.ORG

Subject: Re: Competitors to Remedy ARS?


Just install an unlicensed version of remedy. I think it allows you up
to 1000 records creation, and 3 user licenses. This is good practice too
to hone your remedy development skills, so you benefit in your job as
well.

Now, if you are deploying/selling this application to end users, I'm not
sure how that would play in with remedy's licensing model. So, if you
are not going to be the only one using it, then this might not work.

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E CTR USAF
AFRL/RYOD
Sent: Thursday, October 04, 2007 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

Sorry for jumping in therethis seems interesting to me as well.
:) 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Powell
Sent: Thursday, October 04, 2007 10:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

How many users? 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alec Alec
Sent: Thursday, October 04, 2007 9:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

Largest form would be less than 2500 row, probably less than 1000


Sent via BlackBerry from T-Mobile

-Original Message-
From: "Pickering, Christopher"
  <[EMAIL PROTECTED]>

Date: Thu, 4 Oct 2007 08:15:10 
To:arslist@ARSLIST.ORG

Subject: Re: Competitors to Remedy ARS?


How much data would you expect the system to hold?

Chris Pickering 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alec Alec
Sent: Wednesday, October 03, 2007 5:58 PM
To: arslist@ARSLIST.ORG
Subject: Competitors to Remedy ARS?

Are there any less expensive, freeware, open source, etc. competitors to
the Remedy ARS product?

I have a small home project that I would like to complete, but can't
afford ARS for home.   I am looking only for the engine, no attached HD
app, etc.


Thanks!
Alec

Sent via BlackBerry from T-Mobile


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



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


___

Re: Competitors to Remedy ARS? 2000 record limit on unlicensed servers

[Rick Ponzo]

There may be another issue.  I've honestly never read the whole license 
agreement, but I'm sure an unlicensed server is not supposed to be used 
for anything that may be considered a "production" environment.


Rick Ponzo



Ben Chernys wrote:

It's a maximum of 2000 at any given time.  Insertion is not permitted into a 
form if that form has 2000 or more records.  Deletion of records will permit 
insertion once the current total number of records is reduced to under 2000.

Note that I do not know yet if 7.1 has changed any of this.  Up until 7.0.x 
this was always the case.  The Administrator's related workflow always failed 
on unlicensed servers because of this limit.

3 fixed licenses, 0 floating.  No ARS app licenses.

Ben

  

- --- Original Message --- -
From:  "Watson, Benjamin A."
<[EMAIL PROTECTED]>
To:arslist@ARSLIST.ORG
Sent: Thu, 4 Oct 2007 08:19:06

I could see an unlicensed server using e-mail
approach the 2000 record
limit on the e-mail form fairly easily.

I suppose you could delete old records?  I guess
that begs refinement of
the max record limit on an unlicensed Remedy
install.

Is it 2000 records at any given time, or 2000
records for the entire
history/life of the form?

Ben

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of L. J. Head
Sent: Thursday, October 04, 2007 9:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

Unlicensed server can do Email 


-Original Message-
From: Action Request System discussion
list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alec Alec
Sent: Thursday, October 04, 2007 8:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

I require the email functionality.  



Sent via BlackBerry from T-Mobile

-Original Message-
From:  "Opela, Gary L Contr OC-ALC/ITMA"
<[EMAIL PROTECTED]>

Date:	   Thu, 4 Oct 2007 09:36:35 
To:arslist@ARSLIST.ORG

Subject: Re: Competitors to Remedy ARS?


Just install an unlicensed version of remedy. I
think it allows you up
to
1000 records creation, and 3 user licenses. This is
good practice too to
hone your remedy development skills, so you benefit
in your job as well.

Now, if you are deploying/selling this application
to end users, I'm not
sure how that would play in with remedy's licensing
model. So, if you
are
not going to be the only one using it, then this
might not work.

Thanks,


Gary Opela, Jr

Sr. Remedy Developer

Leader Communications, Inc.

405 736 3211


-Original Message-
From: Action Request System discussion
list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Cupp,
Michael E CTR USAF
AFRL/RYOD
Sent: Thursday, October 04, 2007 9:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

Sorry for jumping in therethis seems
interesting to me as well.
:) 


-Original Message-
From: Action Request System discussion
list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy
Powell
Sent: Thursday, October 04, 2007 10:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

How many users? 


-Original Message-
From: Action Request System discussion
list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alec Alec
Sent: Thursday, October 04, 2007 9:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Competitors to Remedy ARS?

Largest form would be less than 2500 row, probably
less than 1000


Sent via BlackBerry from T-Mobile

-Original Message-
From:  "Pickering, Christopher"
	  
<[EMAIL PROTECTED]>


Date:	   Thu, 4 Oct 2007 08:15:10 
To:arslist@ARSLIST.ORG

Subject: Re: Competitors to Remedy ARS?


How much data would you expect the system to hold?

Chris Pickering 


-Original Message-
From: Action Request System discussion
list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Alec Alec
Sent: Wednesday, October 03, 2007 5:58 PM
To: arslist@ARSLIST.ORG
Subject: Competitors to Remedy ARS?

Are there any less expensive, freeware, open
source, etc. competitors to
the
Remedy ARS product?

I have a small home project that I would like to
complete, but can't
afford ARS for home.I am looking only for the
engine, no attached HD
app, etc.


Thanks!
Alec

Sent via BlackBerry from T-Mobile

___
_
___
UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org ARSlist:"Where
the
Answers Are"

___
_

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

___
_
___
UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org ARSlist:"Where
the
Answers Are"

___

GSA Schedule

[Rick Ponzo]

I'm looking for a company that sells licenses on the GSA Schedule. 


Anyone?

Thanks,

--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: DSO - No license -- how to stop it from starting up ?

[Rick Ponzo]

Hey Patrick,

comment out the line in the armonitor.cfg file that refers to serverds.exe.

Regards,
Rick Ponzo

patrick zandi wrote:

**
I do not have DSO installed -- so I thought.. It is attempting to 
startup..  How to I stop the startup process in windows 2003 server..
is that a Services ? I did not see one.. or ARmoitor ? or is that 
regedit or all three ?

getting the barking of
Mon Aug 27 13:28:02 2007  Distrib : The AR System is not licensed for 
the Distributed Server Option (ARDSERR 3100)
Mon Aug 27 13:28:02 2007  Distrib : AR System Distributed Server 
terminated -- fatal error encountered (ARDSNOTE 3001)

--
Patrick Zandi
__20060125___This posting was submitted with HTML 
in it___ 


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Computed Groups not displayed in User

[Rick Ponzo]

Has anyone run across the issue when creating Computed Groups that they 
didn't show up in the User record for members of groups included in the 
computed group?


Thanks,
Rick

--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Pushing Values to TCO:Cost form

[Rick Ponzo]

Hi Antonio,

What is the qualification you are using to to create the new record?  
One sure way to create the record is to Push Field If 1=2.


Rick Ponzo
IntegrITS Corporation


Antonio Maradiaga wrote:

**
All,
 
Trying to push values to the TCO:Costs form to create a new record 
from a staging form I've created.  I'm passing all the required 
fields, but my filter keeps modifying the same record instead of 
creating a new entry in the TCO:Costs form.  I'm currently using:
 
ARS v6.3 on Win 2K3 server

ITSM v5.6
SQL Server
 
Has anyone worked with the TCO:Costs form and can anyone tell me why 
my "Create new request" option on my push fields action is not 
creating new records?


Thanks.
 
~Antonio
__20060125___This posting was submitted with HTML 
in it___ 


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Search

[Rick Ponzo]

Hi Ramón,

You can use an active link set to a low execution order that Executes 
On: Search. (That's a checkbox value on the front of the active link 
object form). Use a Set Fields action to set the value in the field. If 
this value is coming from somewhere else you can use the Set Fields 
action the same way and pull the value into the field.


Rick Ponzo
IntegrITS Corporation

Ramón Zaragoza García wrote:

**

I have to set a value in a field just when the user clicks on the 
button “Search”, how can I do this?


__20060125___This posting was submitted with HTML 
in it___ 


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Search Menu Values

[Rick Ponzo]

Hi Roger,

No, there shouldn't be anything that would cause that to occur just 
because of the menu being attached.  You should run some AL and Filter 
Logs to see what else may be modifying that field.


Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]



Nall, Roger wrote:

**

Hello All,

 


ARS 6.3 patch 16

WIN2k

SQL2k

 

I just noticed something strange the other day. I have a search menu 
attached to a field on Form A. The form referenced in the search menu 
is Form A. The Label and Value referenced in the menu is the field 
that the menu is attached to. The only valued I have entered are text 
values. When I look at the data being stored in the database I see 
numbers instead of text. Has there been some sort of change that would 
account for this?


 


Thanks,

 


Roger A. Nall

Manager, OSSNMS Remedy

T-Mobile USA

Desk: 813-348-2556(New)

Cell: 973-652-6723

FAX: 813-348-2565

sf49fanv AIM IM

RogerNall   Yahoo IM

 

 

__20060125___This posting was submitted with HTML 
in it___ 


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Random request selection

[Rick Ponzo]

I've heard of many ways to do this, but one I've used in the past worked 
fairly well...


I created an Escalation that had a Run-If of 'Create Date' > $DATE$ + 
32400 and another Escalation that had a Run-If of 'Create Date' > $DATE$ 
+ 54000.  They were run on a form that had a copy of all of the fields I 
wanted to report on.  A set fields action of Request ID != $NULL$ worked 
with If Multiple Entries Match: Use First Matching Request.


Once a week a report was generated from that form and the records were 
set to inactive.


At least that's how I remember it working!

Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]


Matthew Wollman wrote:

**
Is there a way to select random requests from a form? For example, we 
want to start doning random checks on the quality of our tickets. So 
we want to pick 10 random resolved tickets each week from our 
support-groups. I figured I could create a macro or AL to query the 
from with a date range, group range, and select 10 random and print 
them to my default printer with a specified report. I looked trhogh 
DAB and DAA and could not find a function or process to do a Random 
selection. Any ideas?
 
My fallback plan is to search for resolved tickets in a date range and 
group range and export the results to excel, use excel RAND function 
get the ticket num bers and search on those in Remedy and print those out.
 


Matthew L. Wollman

Supervisor of Faculty & Staff Help Desk Services
Faculty of Arts & Sciences Computer Services
Office (617) 496-8947
Cell (617) 285-6952
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

Harvard University
1 Oxford Street
Science Center B14E
Cambridge, MA 02138

Would you like to comment about the service you receive from FASCS?
Now you can! An online survey is available at:
http://www.fas.harvard.edu/~fascs/survey.html 
<http://www.fas.harvard.edu/%7Efascs/survey.html>


 
__20060125_______This posting was submitted with HTML 
in it___ 


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Help

[Rick Ponzo]

Hi Shibu,

If you don't want to go the route of creating a Display-Only form and 
associated workflow, then you can prevent a search being done on the 
User form with the Login name being $NULL$.  Create an Active Link that 
executes on Search.  The Run If statement can be:


($OPERATION$ =  "QUERY" ) AND ('Login Name' = $NULL$)

and the Permissions will be the Group you want this workflow to execute on.

You can present an error message as the If Action telling the user they 
need to enter a value in the Login Name field before searching.


An alternative to opening the User form with the Update button, is to 
create a display-only form and open that.  The form will have the fields 
on it that you want the user to be able to see/modify.  If they are 
going to be able to modify the fields then they will have to have 
permission on the User form to do so.


Once you create the display-only form and add the fields you can then 
add 3 buttons to the form.  One will search for the login name and 
return the data for the fields you added to the form if there is an 
exact match.  This can be accomplished using an active link and a Set 
Fields action. Another button can be used to modify the record that is 
returned and a Push Fields action will update the User record.  The 
third button closes the form without performing any save or modify actions.


This is a good way to control the access the user has.

Either option should work for you.

Hope that helps,

Rick Ponzo


Shibu Samuel wrote:
Hi Rick, 
 
Thanks for the response. 
 
The search is not done thorugh a Display Only form. There is an Update button that opens the User form in the Search mode. If the User belongs to a particular group then the Login Id has to be enterd to search for a record. Could yoy please advise how this could be done without having to create a new view of the User form with the Search Option disabled.
 
Thanks 
Shibu Samuel 
 




From: Action Request System discussion list(ARSList) on behalf of Rick Ponzo
Sent: Mon 21/05/2007 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Help



It sounds like a display only form may be what you're looking for.  By
using a display only form you can add a button that conducts the search
based on a value entered into a character field.  You can control if you
would allow wildcards, or require an exact match.

This sounds like a better approach for what you want to do.

Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]


Shibu Samuel wrote:
  

Hi All,

My requirement is to do a search on the User form based on the Logon Id. Users 
belonging to a particular group should not be able to do a blank search on the 
User form. Only upon entering the Logon Id should they be able to view the 
record for the Logon Id entered.

Is it possible to do this through workflow or should I be creating a new view 
altogether for Users belonging to this particular group where the Search option 
could be disabled. Is there a way to disable blank search for Users belonging 
to a particular group to disable the option of search if the Logoin Id field is 
empty.

Thanks
Shibu Samuel


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

 



--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

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

  


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Help

[Rick Ponzo]

It sounds like a display only form may be what you're looking for.  By 
using a display only form you can add a button that conducts the search 
based on a value entered into a character field.  You can control if you 
would allow wildcards, or require an exact match.


This sounds like a better approach for what you want to do.

Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]


Shibu Samuel wrote:
Hi All, 
 
My requirement is to do a search on the User form based on the Logon Id. Users belonging to a particular group should not be able to do a blank search on the User form. Only upon entering the Logon Id should they be able to view the record for the Logon Id entered.
 
Is it possible to do this through workflow or should I be creating a new view altogether for Users belonging to this particular group where the Search option could be disabled. Is there a way to disable blank search for Users belonging to a particular group to disable the option of search if the Logoin Id field is empty.


Thanks
Shibu Samuel 
 


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

  


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Help Desk ticket creation

[Rick Ponzo]

Hi Atul,

Not sure exactly what you are seeing, but are you saying the ticket 
"status" is closed on submit, or just that the form closes; and that a 
new ticket is opened in "create" mode with the same data populated in 
the form, or it is just a blank form open in submit mode?


Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]


Atul Vohra wrote:

Hi All,

This may be a very basic question but am not able to figure this out. After we 
submit a new ticket, the submitted ticket closes and a new ticket (in create 
form) is opened.

I think this is controlled by some data form but not sure. Traced the workflow 
but did not see anything related.

ARS 6.3

Any help would be appreciated.

Thanks
Atul

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

  


--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]

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

Re: Remedy forms

[Rick Ponzo]

Hi Katherine,

Try this for starters:

Open the midtier configuration tool.
Select Cache Settings
Press the Flush Cache button. -You should see a successful update text 
display.

Also have the user flush the cache on their web browser.

If that doesn't work, take a look at the views to see which one is being 
used for the web if there are multiple views being used.


Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]


Katherine Hoffner wrote:

**
Hi,
 
I am currently using AR 6.3.  We have users log in using Mid Tier.  
All of our contact information is on that first "welcoming" page.  We 
reciently changed our phone number and I cannot get the number to 
change at all.  I can go into the administrator and find the page and 
change it there but it wont transmit to the actual page users see.  I 
am at a loss.
 
thanks


--
Katherine
__20060125___This posting was submitted with HTML 
in it___ 


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

Re: Error

[Rick Ponzo]

Have you tried having that user login from another computer?  Does the 
same thing happen?


Can anyone else login from the computer that is having the problem? 


This will at least narrow it down to computer or user.

Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED]


Gary Roach wrote:

**
I've tried clearing cache on the midtier and his browser.  Still get 
the error.


Gary Roach
[EMAIL PROTECTED]
Global Information Technology
1600 Technology Way
Latrobe, PA 15650
724-539-1510



*Axton <[EMAIL PROTECTED]>*
Sent by: "Action Request System discussion list(ARSList)" 



05/11/2007 09:55 AM
Please respond to
arslist@ARSLIST.ORG



To
arslist@ARSLIST.ORG
cc

Subject
Re: Error









That would be a javascript originated error.  If just one user is
having this problem, have them clear their browser's cache then see if
you still get the error.

Axton Grams

On 5/11/07, Gary Roach <[EMAIL PROTECTED]> wrote:
> **
> All,
>
> I have one user getting the following error when clicking on a link 
on the

> midtier to open a window.does anyone know what this could be ?
>
> Microsoft IE caught exception : undefined is null or not an object.
>
> Thanks for your help,
>
> Gary Roach
>  [EMAIL PROTECTED]
>  Global Information Technology
>  1600 Technology Way
>  Latrobe, PA 15650
>
>
>
>  __20060125___This posting was
> submitted with HTML in it___

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


__20060125___This posting was submitted with HTML 
in it___ 


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

Re: Need help with filter qual

[Rick Ponzo]

It sound like you may have some workflow that is doing a "Commit 
Changes" even if nothing is changed.  One way to check that is to open 
an incident and close it without making any changes and see if the 
modified date reflects a change.


You can also use the modified date field to determine if an incident was 
just updated by the logged-in use.


Rick Ponzo
Integrits Corporation


SUBSCRIBE arslist Neel wrote:

Fred,

That's a great point!! But then it'll leave another question. What is
user modifies the incident WITHOUT changing the status? Is there anyways
we can say that a particular incident want modified by logged-in user?
It could be any change and not just status.

~ Neel.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, May 07, 2007 4:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Need help with filter qual

If you don't change status on a form then 'TR.Status' is NULL so it will
not match the database.

Change that part to   ( 'Status' != 'DB.Status')

Fred 



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Neel
Sent: Monday, May 07, 2007 4:26 PM
To: arslist@ARSLIST.ORG
Subject: Need help with filter qual
Importance: High

Hello fellow-listers,

We have a staging email-form that grabs incoming emails from 'AR System
Email Messages' form. When email have Incident number in email
subject-line, we parse the incident # and open incident in "Modify"
mode.

Now, we have a filter that executes on HPD:Help Desk on Modify and on
Submit both.

	The Run If condition is: 
	( 'Status' != "New") AND ( 'TR.Status' != 'DB.Status')


If Action:
Push Values to: AR System Email Messages

Push Filed If:
'Incident Number' = $Incident Number$

If No Request Match: Take No Action

If Any Request Match: Modify All Matching Requests

Custom Fields: Status = Assigned.

The filter executes every-time I double-click the email record from
staging form (double-clicking a record in email staging form opens
incident window in modify mode) and now here comes a problem:

When the incident window opens up in modify mode, if I close the
incident window without doing ANYTHING (without modifying and saving
anything), it STILL processes the email status to "Assigned". I want to
be able to tag the email with Assigned status ONLY when I click "Save"
button on incident form.

Any suggestions?

Thanks in advance,

Neel Gautam.


This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete
the original.  Any other use of the email by you is prohibited.


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


This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

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

  


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

Re: WebService License Release

[Rick Ponzo]

Thanks for your response, Dylan.  I attempted to use an active link 
after submit as you suggested, but it was unsuccessful.  The search 
doesn't really open a window either, it just returns the output back to 
the calling application.



Wheeler, Dylan wrote:

You could tie the process to a active link that executes on After
Submit. Using the execute on Search wouldn't help for the query though
since it executes before the search happens. Maybe open the results in a
new window, close the old window and tie the AL to that?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo
Sent: Monday, February 12, 2007 8:11 AM
To: arslist@ARSLIST.ORG
Subject: WebService License Release


Greetings all,

I've made a few attempts to release a license that was used during a web

service create or query.  Tech Support recommended using the 
PERFORM-ACTION-EXIT-APP process, but that doesn't work in a filter so 
it's not much use in this situation.


Any ideas?

Thanks,
Rick Ponzo


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


This message and any attachments are for the intended recipient(s) only and may 
contain privileged, confidential and/or proprietary information about Downey 
Savings or its customers, which Downey Savings does not intend to disclose to 
the public.  If you received this message by mistake, please notify the sender 
by reply e-mail and delete the message and attachments.

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


  


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

WebService License Release

[Rick Ponzo]

Greetings all,

I've made a few attempts to release a license that was used during a web 
service create or query.  Tech Support recommended using the 
PERFORM-ACTION-EXIT-APP process, but that doesn't work in a filter so 
it's not much use in this situation.


Any ideas?

Thanks,
Rick Ponzo

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

Re: Workflow

[Rick Ponzo]

That's a great solution Michelle. Now all that's needed for real time is 
an interval of 1...or create 3 active links that are set to interval 
3...or something like that....


Rick Ponzo


Lucero, Michelle - IST contractor wrote:

**
Hi, John:
"Now there is the issue of trying to activate/deactivate the interval 
so it only runs when needed."
It will stop when the qualification is no longer met. ($FIELDLABEL$ = 
"myfieldlabel")
There is no need for an Active Link guide. I tested it without one. It 
starts and stops as desired.

Michelle


*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Reiser, John J

*Sent:* Tuesday, January 30, 2007 1:31 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Workflow

**
Rick,
Is it that much of a performance hit if the SET fields is done on the 
CURRENT SCREEN of the AL?
I mean, there should be no DB request for this action and anything 
that would process a count would use some CPU time. Correct?


John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - 
paraphrased by me




*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Rick Cook

*Sent:* Tuesday, January 30, 2007 11:52 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Workflow

**
Again, there is a performance price for the Interval, especially if 
multiple users will be doing it at the same time. If it's a price that 
you can pay, then go for it.

*Rick*

*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Reiser, John J

*Sent:* Tuesday, January 30, 2007 8:29 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Workflow

**
Darshana, Rick, Dan & Saravanan,
The enhancement request for the full client and the Midtier would be 
great but there is an alternative with AL workflow and the interval.
Granted it has a minimum of 3 seconds but you could fire a set fields 
on interval that counts the length of the current field and subtracts 
it from the known max length of the field.
Now there is the issue of trying to activate/deactivate the interval 
so it only runs when needed. Maybe inside an AL Guide?


John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - 
paraphrased by me




*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Daniel Bloom

*Sent:* Tuesday, January 30, 2007 10:04 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Workflow

**

I would suggest submitting it as an enhancement request.

Rick Cook replied back in November with

“**

You could possibly do it in a View field, using either some OLE or 
Java function. That would be my best guess. I can't think of any 
native ARS way to do it.


**Rick**

I concur or

It sounds like something BMC Remedy could add to the Web Client.

Of course all such things will add weight to the web client and slow 
things down.


(I am sure the clever webbish folks can come up with a work around, 
based on what Rick has suggested)


but I suspect the extra processing may make it not worth the gain for 
the users).


… Daniel



*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Saravanan Palaniappan

*Sent:* January 30, 2007 4:52 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Workflow

Did any one found solution for the question below

With Regards

PL.Saravanan

BTGS EXPEDIO FM | Team Virtusa (Chennai ATC) | Ph: +44-42002700 Extn: 
3279 | Mobile : 99404-08691 .Email: [EMAIL PROTECTED]




*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Darshana Jivan [MTN 
Network Solutions]

*Sent:* 27 November 2006 15:29
*To:* arslist@ARSLIST.ORG
*Subject:* Workflow

Hi,

Is it possible to populate a field as you typing in another 
field….like real time information and not populating it after losing 
focus or something…


What I am trying to do is while you tying into a text field it should 
display how many characters are left for you to type in another text 
field like the example below.


Any Ideas?

E.G



Characters Left:

*Regards,***

*Darshana Jivan*

*MTN Network Solutions*

Cell: 0832000451

Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]

Re: Workflow

[Rick Ponzo]

I thought of one way to make the counter work...you can use an active 
link that fires on gain focus of the field and on a 3 second interval 
and sets your counter field based on the LENGTH() function. I haven't 
thought about it long enough to figure out how to stop the active link 
once the interval begins.


It's not real time...but 3 seconds is close if you're a slow typer...

Rick Ponzo


Saravanan Palaniappan wrote:

**

Did any one found solution for the question below

With Regards

PL.Saravanan

BTGS EXPEDIO FM | Team Virtusa (Chennai ATC) | Ph: +44-42002700 Extn: 
3279 | Mobile : 99404-08691 .Email: [EMAIL PROTECTED]




*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Darshana Jivan [MTN 
Network Solutions]

*Sent:* 27 November 2006 15:29
*To:* arslist@ARSLIST.ORG
*Subject:* Workflow

Hi,

Is it possible to populate a field as you typing in another 
field….like real time information and not populating it after losing 
focus or something…


What I am trying to do is while you tying into a text field it should 
display how many characters are left for you to type in another text 
field like the example below.


Any Ideas?

E.G



Characters Left:

*Regards,***

*Darshana Jivan*

*MTN Network Solutions*

Cell: 0832000451

Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

MTN Corporate

39 Rivonia Road

No1 Commerce Square 3^rd Floor

Sandhurst

Johannesburg

2196

P.O. Box 3070; Randburg; 2125; South Africa.

| Disclaimer |
This email and the documents transmitted with it are confidential and 
are intended for the addressee only, and must be treated as such. The 
views expressed herein are those of the author and do not necessarily 
represent those of MTN Network Solutions (MTN NS). MTN NS accepts no 
liability in respect of any illegal content. No employee or agent of 
MTN NS is authorised to conclude a binding agreement on behalf of MTN 
NS by email (or otherwise) unless specifically stating otherwise in 
such correspondence. Binding agreements with MTN NS may only be 
concluded if printed in hard copy and signed by an authorised 
representative of MTN NS.


__20060125___This posting was submitted with HTML 
in it___

-
This message, including any attachments, contains confidential 
information intended for a specific individual and purpose, and is 
intended for the addressee only. Any unauthorized disclosure, use, 
dissemination, copying, or distribution of this message or any of its 
attachments or the information contained in this e-mail, or the taking 
of any action based on it, is strictly prohibited. If you are not the 
intended recipient, please notify the sender immediately by return 
e-mail and delete this message.


__20060125___This posting was submitted with HTML 
in it___ 


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

Re: AR System user Warning HELP

[Rick Ponzo]

Hi Katherine,

Export a definition, or take a look at a current full def and search on 
42099 and 42098 and you should be able to find the workflow that is 
triggering the message.  The problem is that the workflow is checking 
for a Business Time Holiday and Business Time Workday Tag called "user". 

You could also begin by looking at which objects were modified recently, 
and identify what those objects have to do with Business Time.


Rick Ponzo


Katherine Hoffner wrote:

**
Hi all...
 
I came in to work with a wonderfull issue.  When ever anyone in my 
groups tries to send in a ticke they get the following.
 
The business Hour tag 'user' does not exist in the Business Times 
Holidays.  See your administrature to have it configured.  ( ARWARN 42099)
 
The Business Hours tag 'user' does not exist in the business times 
Workdays form to have the tag configured (ARWARN 42098(  42105)


None of this was ever set up so I am unsure how to put it back.  Is 
there a way to find out who did what to the system.  I actually 
already know who but they dont remember, but maybe there is a way to 
find out what it was she actually did.
 
 
 


Katherine
 
__20060125___This posting was submitted with HTML 
in it___ 


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

Re: Web Services

[Rick Ponzo]

Do you have a different name in the Label field?  I believe it will take 
the name in the Label field over the web service name.


Rick Ponzo
Integrits Corporation

Suddhasil sircar wrote:

**
Hi Listers,

I am trying to create Web Services in remedy. It's getting saved but 
when I am trying to view the WSDL its giving me this error.


*ARERR [8804]
The specified container does not exist: TAJ_TEST2 *

The name of the web service is *TAJ_TEST2*

Did anybody face this error?

 


I am using

Remedy 5.01

UNIX Server

Java 1.4.2_12

 

I have set the correct java path and edited the ar.conf file as per 
the user manual.


__20060125___This posting was submitted with HTML 
in it___ 


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

Re: Custom Web Service create method

[Rick Ponzo]

Mark,
I ran into a similar situation.  I ended up creating a new form 
specifically for webservice input.  I created filters that populated 
certain fields with data based on a value set in a specific field on the 
submit. 

When the submit is complete you can format the fields exactly the way 
you want them to look in HelpDesk, then push them in a filter.  Place a 
field on your new transfer form to receive the Request ID of the ticket 
you created during the push.  Return the new field value in the output 
mapping.


Regards,
Rick Ponzo

Hi everyone,
Thanks for the sugestions.
But unfortunately, no one of the solutions work.

Trying Frederick's sugestion my custom tool, which is
MSVisualStudio2005, says:
"Custom tool error: Unable to import WebService/Schema. Schema item
'complexType' named 'CreateInputMap' from namespace 'urn:CreateEntry'.
The 'use' attribute must be optional (or absent) if the default
attribute is present."

Even if I set the 'use' attribute to 'optional' its still needs those
parameters. 
Maybe playng with a xml schema would help??


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


  


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