Re: BMC MyIT

2013-05-24 Thread Shawn Stonequist
Looks like there hasn't been any new information on MyIT since end of April- is 
there anything new? I just got an email ad from BMC today and was looking 
through the archives for more info.

If anyone is familiar with it, a couple questions I have are:
-Based on the Licensing link, it appears its using the same Remedy licenses 
(e.g. we use the same licenses for MyIT as for Remedy User, etc.). Am I 
understanding this correctly?

-How does it integrate with customized Remedy apps? Or, does it integrate 
solely with ITSM? 

If it helps, I'm just interested in the entry/viewing pieces, not so much on 
the self-help (e.g. engineer who is bringing up a new server for the first time 
can enter info on their phone, or perhaps even snap a picture with the phone's 
camera, and it makes a Remedy entry in Custom Form Servers or another 
engineer doesn't know what's on a server, so they take a snapshot of the serial 
number with their phone and everything we associated that server's record in 
Custom Form Servers is displayed on their phone). I might be pipe-dreaming on 
this though...

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Re: User Client 7.6.3 7.6.4sp1: Tabs, Tables, Printing

2011-06-01 Thread Shawn Stonequist
Getting further along on this

Trying to write an Active Link to use OLE to send a 'Print Screen' to Word,
then have Word print.

Found an old List record saying how to get the Print Screen to work using
Run Process, but I can't get it to work :~( (maybe I just messed it up,
since I don't use Run Process often?)

http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0905L=arslistP=R87513I=-3X=3083BD126142279CD7

Tried setting the Run Process to: SendKeys( ^{p}, )

but the response is that system can't find the file

And onward I go!
Shawn

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


User Client 7.6.3 7.6.4sp1: Tabs, Tables, Printing

2011-05-31 Thread Shawn Stonequist
Greetings list!

We are (still) upgrading from our 6.0.3 Remedy server to a brand new (Ok-
not that new...) 7.6.3 Remedy server. We encountered a new issue that I
can't figure out or find in the Archives (spent about 30 minutes, but not
really even sure what to look for).

This new issue that we found is that, when trying to print the record
details, if a Table field was displayed within a tab of a Page field and
refreshed to show its corresponding data, then the printout would repeat
the table over the upper left corner of the details, in addition to where
the table belongs under the tab. The only way around this (that we can find)
is to Print Preview first. The strange part is that it doesn't occur with
ALL tab/table combinations (and we can't figure out why).

For example, the form in question has 14 tabs (3 hidden). The first tab has
3 small tables, and various other tabs have between 1-4 tables. When Tabs 1
or 11 are selected and printed, they print just fine, everytime, without
fail. When any of the other tabs that have information are printed, they
print the double tables everytime without fail. I tried duplicating the
properties of both the tabs and the tables from those that work to those
that don't, but it has no effect. Using a development form, I tried to
recreate the conditions of the tables that work, but always failed (except 1
time, which I haven't been able to reproduce). It seems that it is only an
issue when there is a Tab/Table combination in play (we have many other
custom forms as well, without tabs, that have no issues what-so-ever).

We have even tried using 7.6.4 sp1 against our test server running the 7.6.3
server (as this combination resolved a number of other issues we were
having, like strange characters when copying/pasting, and an error that
occurs when a user chooses to accept the consequences of updating a record
after another user has since the last Get time). All results are the same-
we can't get rid of this ghost table image.

Any ideas?

Enviroment 1:
Remedy Server 6.0.3
Remedy Client 7.6.3

Enviroment 2:
Remedy Server 6.0.3
Remedy Client 7.6.4 sp1

Enviroment 3:
Remedy Server 7.6.3
Remedy Client 7.6.4 sp1

Thanks soo much in advance for any possible assistance!
Shawn Stonequist
EMNS, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: User Client 7.6.3 7.6.4sp1: Tabs, Tables, Printing

2011-05-31 Thread Shawn Stonequist
Good thought, but this happens to multiple printers.

After fiddling a bit, I actually figured out why it happens to some but not
others:

In actuallity, it does happen to all of them, however, for those which are
located at lower coordinates on their respective page, the printout is
reprinting the tables using the same coordinates and layered between the
fields and the Page field.

Example: If a table is located at Page1 X:1, Y:1, then the table is
reprinted at MainForm X:1, Y:1. If its at Page1 X:200, Y:200, then the
reprint is Main X:200, Y:200. If the Page Field itself is at Main X:199,
Y:199, and covers the same or larger area as the table, then the Page field
covers it.

I tried to place a box field behind the fields, but the reprint is layered
above the fields, so this doesn't help.

Shawn

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: User Client 7.6.3 7.6.4sp1: Tabs, Tables, Printing

2011-05-31 Thread Shawn Stonequist
Does anyone know how to make a Macro/Button/Active Link/Run Process/Anything
which will:
1) Open Print Preview
2) Print

I think this will help (found on google an old page from Matt Reineldt, but
couldn't get in to it:

http://www.mattreinfeldt.com/forums/ubbthreads.php/topics/69270/Print_Preview_in_a_Macro)

If anyone has this (so that I can hopefully at least use it for base
knowledge and apply a fix), I would be most grateful!!

Shawn

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


How to do Double Dynamic values?

2011-02-17 Thread Shawn Stonequist
Greetings List!

I tried searching the archives for this, but always came up with too much or
not enough, so I must not be searching for the right thing.

Basically, I have add a From field to our ARS version 6.3 AR System Email
Template form so that the From can be set without needing to make changes
in AR Admin client. 

The end result is going to be to give managers of departments the ability to
maintain their own notifications (they update an interface, it pushes values
and HTML templates to the AR System Email Template form, and those values
are used in the notification Filter/Escalation).

While this currently works great for hardcoded values (e.g.
supp...@company.com), its not working so great for dynamic values (e.g.
$User's Email$)- it is coming out from $User's email$@company.com - I
mean, it is this exactly, not being translated to the value on the Form in
the 'User's Email' address field. If a Manager changes their mind (again)
and changes from a dynamic value to a hard value (or vice verse), I have to
keep going into AR Admin to change

How do I essentially do a double dynamic, to make it recognize the value
as a Field variable instead of a solid value? Maybe I am going about this
the wrong way?

I thought of doing a push back to the Template, but would prefer not to, as
I don't want to risk two users activating the same notification at the same
time, and the External Function isn't available (only Keywords and fields)

Any thoughts?

As always, thank you all so much in advance for any help you can provide!

Thanks in advance for your help!
Shawn Stonequist
Remedy 6.3
EMNS 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


OT: Problems posting to the List

2011-02-16 Thread Shawn Stonequist
 
This is a test. Has it been received?
 
If so, can anyone help me? I seem unable to post anything through the
ARSList web (http://listserv.rbugs.com/cgi-bin/wa.exe?P1
http://listserv.rbugs.com/cgi-bin/wa.exe?P1L=arslist L=arslist) despite
trying from several different browsers
 
Thanks in advance for your help!
Shawn Stonequist
Remedy 6.3
EMNS 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


ARS Client 7.6 Copy/Paste Issues

2011-02-16 Thread Shawn Stonequist
Greetings List!

We are upgrading from 6.3 to 7.6 (finally!)

We are upgrading clients first, since they are compatible with the 6.3
server and we are unable to upgrade everything simultaneously.

One thing we noticed is that when users of 7.6 clients copy/paste from
emails, websites, etc., strange characters are being added- everything from
c and . to , %, {, and even non-Western characters (I think I
even saw the Japanese Yen symbol once). Unfortunately, I couldn't find
anything in the BMC KM or the List Archives (not really even sure what to
look for) so apologies if this is a repeat.

It seems completely random- not specific to plain text, rich text, or HTML
text being copied (in my own personal experience).

The issue this presents is that the extra character causes false negative
responses in workflow objects. For example, if an email address is
copied/pasted, Enter key is pressed, previous contacts from that email
address should be returned, but the extra character make this false (as well
as prevents the current contact from being presented when this process
occurs for the same address in the future).

And since it does not *always* add a character, I can't even write a
workflow object to strip the last character off. Once we were aware of what
was happening, of course we had users remove the character themselves (but
you know how silly those human beings can be- they always forget or miss
some here and there ;) ).

Any thoughts/ideas?

Thanks in advance for your help!
Shawn Stonequist
Remedy 6.3
EMNS 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Upgrade planned - to ARS 7.5 Windows 7

2010-08-30 Thread Shawn Stonequist
Greetings List!

I am hoping someone will have information, as it seems rather scarce.

We are upgrading our Remedy system from 6.03 to 7.5 (yay!) and some of our
client-side OS to Windows 7 (still undecided if this is a yay or nay).

Haven't found much on the compatability between these two (List, ARS Wiki,
BMC support site), only that there are some issues with the ARS Client on
W7. The ARS Server itself will still run on the same *nix OS its been
running on. I think we are upgrading the DB to Oracle 10 or 11 something or
other (don't know these details)

Anyone happen to know more (I'm guessing at this point its not a supported
combination)?

Incidently, anything we should watch out for in our ARS upgrade (we pretty
much use the client independently, just a few Crystal Reports 11- as in I
run them for everyone else and disperse a finished product).

ARS 6.3 = 7.5
Oracle 9i = 10 or 11

Huge thanks in advance for any advice!
Shawn Stonequist
EMNS, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Methods to display PopUp window on mutliple user's client screen without using Remedy Alert client

2010-06-30 Thread Shawn Stonequist
We are still on 6.3, but I did something similar to Gary, with a twist.

We have several customers and each customer we record infromation for has
their own schema.

I created a display only form with a page field and a tab for each customer,
a s well as a table, and an AL that refreshes the table regularly. For each
tab, I also created a Notify On field so the user could choose when they
wanted to be alerted (e.g. if a Priority column has a record with a High
Priority value, etc.) and a Warning would pop-up.

I also threw in a few other bells  whistles - an option for the Managers to
select their employees so the manager quickly view what is assigned to each
employee, a button to open the selected record from the table, using a table
loop in the event multiple records are selected, the ability to modify
certain fields within the table (which also grants the ability to users to
do a Modify All without actually using Modify All that has caused some
issues for us in the past), row counts so the user can see how many in each
table, and it seems to be a very handy tool.

Hope this helps!
Shawn Stonequist
EMNS, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: how to implement a carriage return

2009-03-20 Thread Shawn Stonequist
Serouche,

Yes! We've done this- all you have to do is select the option Return/Table
Dbl-Clk and select the field that your users must be in when they press
Return/Enter.

The only condition is that the field can only be 1 row tall- if it is more
than 1, then the system enters a carriage return as text in the field. If
your field is 1 row, your users will have to open the Expand Box to input
any carriage returns they desire.

Hope this helps!
Shawn Stonequist
Remedy 6.3
EMNS 

-Original Message-
From: Remedy Maniac [mailto:remedy.man...@googlemail.com] 
Sent: Thursday, March 19, 2009 3:56 AM
Subject: how to implement a carriage return

dear all,

I need to implement at one place only a carriage return in the following
way:
I have a character field (A) where my users put text.
I have a button which on click fires the workflow to get the value from A
I'd like the workflow being fired with carriage return instead of the button
Of course you can always click on tab to get the focus on the button. 
But I'd prefer to have the carriage return effect directly.
Has anybody alreday implemented something similar?
Any idea or tips?
Many thanks in advance.
Serouche

My env is
ARS 6.00.01 (still haven't upgraded. But soon) mid-tiers on 6.3 with Apache
1.33 and Tomcat 4


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

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


Re: Monday Humor: They're ready for a conference now I think

2008-11-19 Thread Shawn Stonequist
The solution is to hire the lingerie  underwear (for the gals) models FOR
the nerdy/geeky computer convention ;`)

  _  

From: Pruitt, Christopher J [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 18, 2008 9:59 AM
Subject: Re: Monday Humor: They're ready for a conference now I think


** 

I think the line from George Hamilton says it all.

 

It's extraordinary, It's going to change the landscape. It's just what
Miami needs.

 

I guess Miami's image needs more lingerie models than some nerdy IT people. 

Christopher Pruitt
EDS, an HP Company
mailto: [EMAIL PROTECTED] 

We deliver on our commitments 
so you can deliver on yours. 

Confidentiality Notice: This message and any files transmitted with it are
intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged, and
exempt from disclosure under applicable law. If you are not the intended
addressee for this e-mail, you are hereby notified that any copying,
distribution, or dissemination of this e-mail is strictly prohibited. If you
have received this e-mail in error, please immediately destroy, erase, or
discard this message. Please notify the sender immediately by return e-mail
if you have received this e-mail by mistake.

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Monday, November 17, 2008 8:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Monday Humor: They're ready for a conference now I think

 

** (Hotel management meeting a few months ago)

OK, should we scare off the boring software company to free up the date for
lingerie models?  All in favor?  All opposed?

Well, Vegas won't have that problem.

Rick

On Mon, Nov 17, 2008 at 4:58 PM, Benedetto Cantatore
[EMAIL PROTECTED] wrote:

** 

I guess they were motivated when they found out it was Victoria Secret
models.

 

Ben Cantatore
Remedy Manager
(914) 457-6209

 

Emerging Health IT
3 Odell Plaza
Yonkers, New York 10701


 [EMAIL PROTECTED] 11/17/08 1:19 PM 

http://www.usatoday.com/life/people/2008-11-16-victorias-secret_N.htm?loc=in
terstitialskip

David M Clark
Remedy Programmer/Analyst



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

__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


Re: Crystal Report Question - SOLVED

2008-10-29 Thread Shawn Stonequist
Huge thanks to all! Using a combination of ideas from you, here is what I
used (in case anyone wants to know):

Formula field 1: AM/PM =
if Time({Times__eSight.Start}) Time(12,00,00) then AM
else PM

Formula field 2: Day =
DayOfWeek ({Times__eSight.Start})

Formula field 3: Day/Shift = 
~
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and 
[EMAIL PROTECTED]/PM} =AM) then S-M
Shift else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and 
[EMAIL PROTECTED]/PM} =AM) then M-T
Shift else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and 
[EMAIL PROTECTED]/PM} =AM) then T-W
Shift else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and 
[EMAIL PROTECTED]/PM} =AM) then W-T
Shift else
if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and 
[EMAIL PROTECTED]/PM} =AM) then T-F
Shift
~

Then I was able to group by Day/Shift, which gave me everything I needed!

Huge thanks to all again!!!

Shawn

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


Crystal Report Question

2008-10-28 Thread Shawn Stonequist
Greetings List!

Nor a Remedy question, but hopefully someone can help me anyway.

I'm trying to write a report to show all records created between Sunday 7pm
through Friday 7am between the hours of 7am and 7pm.

I've tried 

Time({Form.Create Date})Time (18, 59, 59) or
Time({Form.Create Date})Time (7, 00, 00)) and
DayOfWeek({Form.Create Date})7

however, this gives me records created between Friday 7pm and Sunday 7am as
well, which need to be excluded.

I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't
think how to do this.

Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday
PM/TuesdayAM, etc.

Does anyone have any ideas?

HUGE THX IN ADVANCE!!!

Shawn Stonequist
EMNS Inc.

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


Mega-Super Search Form (or Building a Google Remedy)?

2008-05-16 Thread Shawn Stonequist
Greetings List!

I've been asked to build a feature that searches multiple fields at once.
I've got some thoughts on how to accomplish this, but I was wondering if
there were any hints/tips/suggestions/watch out points that you all may
have out there.

Here's what I have so far:
1) Display only form
2) Search Criteria field
3) Form Selection field (Search menu using the Data Dictionary)
4) Multiple tables (hidden unless its form = Form Selection field) showing
key information from each form (with drill down option available)

Tables would be setup with qualifications something like:

'FieldA' LIKE %+$Search Criteria$+% OR 'FieldB' LIKE %+$Search
Criteria$+%

Any thoughts/advise/etc. on this approach?

Thanks in advance for your help!
Shawn Stonequist
Remedy 6.3
EMNS, Inc.

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


6.3 HTML Templates Attachments

2008-03-20 Thread Shawn Stonequist
Greetings List!

Hopefully, this is an easy one~

We have an HTML Template Email that we've added an attachment to (so we can
do company logo). We followed the directions on page 209 of the
EmailEngine-630.pdf manual. Everything appears to be setup correctly.

Unfortunately, when we generate the email, the email is sent, the correct
template is sent, but the attachment isn't (so of course the image won't
display in the email).

Any advice would be greatly appreciated!!

Thx!

Shawn Stonequist
EMNS, Inc.

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


Re: DST - Leap Year Issue with Date Only fields

2008-03-12 Thread Shawn Stonequist
Does anyone know how the Date (not Date/Time displayed as Date Only) data is
stored?

For instance, we know Date/Time fields (regardless of how they are
displayed) are actually stored as Epoch/Unix time.

Thanks in advance!

Shawn Stonequist
EMNS Inc.

-Original Message-
From: Michelle L [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 12, 2008 1:54 PM
Subject: Re: DST - Leap Year Issue with Date Only fields

Hi, Randy:

Thank you for your response.  But, we're already on ARS 6.3 Patch 23.  Was
there another patch to address this.  Is this patch generally available or
is it something that you have to specifically request.

Thanks,
Michelle


   
 Randy Simon   
 [EMAIL PROTECTED] 
 Sent by: Action   To 
 Request Systemarslist@ARSLIST.ORG 
 discussion cc 
 list(ARSList)
 [EMAIL PROTECTED] Subject 
 ORG  Re: DST - Leap Year Issue with Date 
   Only fields 
   
 03/12/2008 11:30  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




If you are on ARS 6.3 there is a patch for this problem.
We had the same problem, but we are on 6.0 and would need to upgrade to
6.3 and install the patch.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michelle L
Sent: Wednesday, March 12, 2008 11:29 AM
To: arslist@ARSLIST.ORG
Subject: DST - Leap Year Issue with Date Only fields

Hey Y'all:

Remedy ARS 6.3 P23 (Server is in Central time zone) Windows 2003 SQL Server
2000 Admin tool ARS 6.3 P23 User Tool 6.3 P23 and 7.0.1 Patch 005

We're not sure if this issue is DST only related or DST and Leap Year
related.

We discovered an interesting phenomenon when we reviewed records in various
forms with Date fields (not Date/Time).  On March 9, 2008 starting at 3:00
AM and continuing through the remainder of the day, any Date field set with
$DATE$ was set to March 8, 2008.  It didn't matter what time of day it was.
Date/Time fields were appropriately set to March 9, 2008 and current time.

We had to update thousands of records in various forms.

Did anyone who is still on Remedy ARS 6.3 experience this?

Thanks,
Michelle



==

Confidentiality Notice: The information contained in and transmitted with
this communication is strictly confidential, is intended only for the use of
the intended recipient, and is the property of Countrywide Financial
Corporation or its affiliates and subsidiaries.  If you are not the intended
recipient, you are hereby notified that any use of the information contained
in or transmitted with the communication or dissemination, distribution, or
copying of this communication is strictly prohibited by law.  If you have
received this communication in error, please immediately return this
communication to the sender and delete the original message and any copy of
it in your possession.

==


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



STATEMENT OF CONFIDENTIALITY:

The information contained in this message or any attachments to this message
are intended only for the person(s) or entity to which it is addressed and
may contain confidential and/or privileged material as well as being
protected from disclosure.
Any review, retransmission, dissemination or other use of, or taking of any
action in reliance upon, this information by persons or entities other than
the intended recipient is strictly prohibited. If you received this in
error, please contact us immediately

Re: Cleaning Up Groups

2008-03-06 Thread Shawn Stonequist
 Frank,

You can use the Groups area in Remedy admin- just open the Group to be
removed, then you can view which forms they have access to etc.

Shawn Stonequist
EMNS Inc.

-Original Message-
From: Frank Caruso [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 05, 2008 2:23 PM
Subject: Cleaning Up Groups

Is there a way to figure out whether a Remedy Group is being used in work
flow, field permission, run if statement etc ??

We are trying to clean up dozens of groups that are no longer associated
with any user, but would also like to know whether the permission can be
found on any Remedy objects.

Thank you

Frank


___
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: Phone Numbers

2008-02-20 Thread Shawn Stonequist
Carey,

Its perfect!!!

'Field' LIKE %[^-0-9]% worked like a charm!

I feel like its my birthday already! ;)

Huge thanks!
Shawn Stonequist

-Original Message-
From: Carey Matthew Black [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 19, 2008 2:34 PM
Subject: Re: Phone Numbers

I think this Run if should get the job done.

  'Field' LIKE %[^-0-9]%

If you have to you might have to go as far as...
  'Field' LIKE %[^-0123456789]%
or maybe
  'Field' LIKE %[^0123456789-]%

( I seem to remember the hyphen need to be first to be understood as not
being a range, but I can not find that in the docs at the moment.)

Read it as:

When the field has a character that is not(^) a hyphen or in the
range([0-9]) of 0 to 9.

That just does not seem like that long of a Run If to me. :)


JMHO: However I would push to not support the hyphen too. they are silly in
a phone number. BTW: open and close parentheses are also silly. Phone
_numbers_ are numbers... not formatting. That is for reports/display tools
to do.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On Feb 19, 2008 2:01 PM, Shawn Stonequist [EMAIL PROTECTED] wrote:
 Greetings List!

 This may be a bit strange. We have a form that is used  populated by 
 one of our customers. The data is sent electronically to third company.
 Unfortunately, strange characters are being entered into the Phone 
 Number fields, which is causing an issue. The customer is requesting 
 an error message (not a replacement) when anything other than a digit 
 or a hyphen is entered.

 Does anyone know of a way to do this (other than an extremely long Run 
 If qualification that lists every letter and symbol)?

 Huge thanks!
 Shawn Stonequist
 EMNS, Inc.
 Remedy 6.3


___
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


Phone Numbers

2008-02-19 Thread Shawn Stonequist
Greetings List!

This may be a bit strange. We have a form that is used  populated by one of
our customers. The data is sent electronically to third company.
Unfortunately, strange characters are being entered into the Phone Number
fields, which is causing an issue. The customer is requesting an error
message (not a replacement) when anything other than a digit or a hyphen is
entered.

Does anyone know of a way to do this (other than an extremely long Run If
qualification that lists every letter and symbol)?

Huge thanks!
Shawn Stonequist
EMNS, Inc.
Remedy 6.3

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


Out of Hours Flag not working

2008-02-11 Thread Shawn Stonequist
Greetings List!

We are trying to setup something to identify tickets/requests which are
entered out of hours. 

We are using Remedy 6.3. I tried enabling a Business Calendar, however, the
second tab never shows the fields- as if they are hidden waiting for an
action before they display. I'm afraid of changing any workflow for fear of
breaking the entire thing.

When this didn't work, I tried creating my own, however, the TIME Keyword
didn't work on just time (or rather the time entered to compare TIME again
didn't work- it changed it to a full Date/Time, which of course it ALWAYS
fires after that date).

Does anyone know how to work around this?

Huge thanks in advance!
Shawn Stonequist
EMNS, Inc.
Remedy 6.3

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


Group Form, Floating Licenses Field

2008-01-24 Thread Shawn Stonequist
Greetings List!

We are wondering how the Floating License field works on the Group form. Is
anyone using this field currently? What are some of the positive and
negative impacts it use has?

For instance, if we have 40 licenses total, and set this number 10 for Group
A, am I correct that no more than 10 tokens will be issued to members of
Group A, even if they have 15 users on? And if Group A has only 5 users on,
will non-Group A members be able to use the remaining 35 tokens, or will it
only be possible for non-Group A members to use up to 30 tokens (since 10
have been assigned to Group A itself)?

Please let me know if I'm not clear- its been a long week, so this all makes
sense in my head at the moment.

Thanks in advance for your help!
Shawn Stonequist
Remedy 6.3
EMNS, Inc.

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


OT: Crystal Report - Last Record per Group

2007-12-28 Thread Shawn Stonequist
Greetings List!

I know this is more Crystal than Remedy, but I'm hoping someone here may be
able to assist anyway.

I'm trying to write a Crystal Report on a Joined Form which combines
end-user Account Information (on the parent form) with end-user payment
history records (from the child form). I need to display various details
from both the account itself and information from the last payment only for
each account.

I tried inserting a group based on the Account Number, then suppressing
Details if not OnLastRecord, however, this only produced the very last
record. When I tried various equations involving Previous, PreviousIsNull,
Next, and NextIsNull, however, these produced 0 results or All results,
instead of only the last results.

HUGE thanks in Advance!

Shawn Stonequist
EMNS, Inc.
Crystal Reports 11

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


Print Hardcopy Notifications?

2007-11-19 Thread Shawn Stonequist
Greetings List!

We've setup a series of notifications for one of our customers. They are
requesting that these notifications be printed manually as well when email
isn't viable, yet have the print outs maintain the same look and feel as
the emails.

I saw in the OLE that there's several Print selections in the OLE
Automation Control, but I have no idea how to use them. Does anyone know if
these are what I'm looking for, and if so, where I can find more information
about how to use them? Will this allow me to use the HTML Templates we have
to email the printer? Or is there another way to go about this?

HUGE THX!!!
Shawn Stonequist
EMNS, Inc.
Remedy 6.03

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


Re: Loading Patch 21

2007-11-15 Thread Shawn Stonequist
Greetings List!

I found this thread from a couple weeks ago. We are planning to install
Patch 21 this weekend and we are wondering if there are anymore issues
found, or if anyone knows if these issues already stated have been resolved.

Thx!
Shawn Stonequist
EMNS, Inc.

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


Re: User tool abruptly closes the session.

2007-11-15 Thread Shawn Stonequist
Dan  Girish,

We are seeing this as well- exact same message. I don't have any solutions
yet (we are still struggling ourselves), but here's what we've tried (in
case it gives anyone any ideas):

1) It appears to be a Windows general fault message
2) It only occurs to us when we are using workflow that runs on Press
Return and tries to set fields (there are one or two select other
circumstances, however, this one is the most common)
3) It is only occuring to some of our users, not all
4) Those that it occurs to is using Windows 2000 Prof  Remedy 6.0.3 patch
18 (we thought Patch 18 would resolve the issue and it didn't).

We've worked with our Remedy support and they have said that it was a
Windows issue, and we've worked our Administrators and they've said its a
Remedy issue.

Shawn Stonequist
EMNS, Inc

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


List Problems?

2007-11-15 Thread Shawn Stonequist
Are there issues with the list? I was just notified that emails I sent in
March/April had just been posted

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


Email template - Issue with Dynamic Template Names

2007-11-15 Thread Shawn Stonequist
List~

I'm experiencing an issue using dynamic template names. I have several
buttons on one of our forms, each sends a different HTML Template. To
consolidate workflow and make things a bit easier to use, I'm try to have
each button set a temp field with the Template name, then have 1 Filter use
the temp field to read which email should be sent. 

Instead, what is happening is that the HTML Template isn't being read at
all, and the notification that goes out is the old Remedy 4.5 Style
notification (the 'ugly' list of fields and values). I have the filter set
with the Content field as $Temp Field$, and the HTML Template name was
copied  pasted into the workflow that sets the Temp Field, so I know it is
exactly correct. The Template Name is Customer - Missing docs (not sure if
the - is causing any trouble, I wouldn't think so).

Does anyone know how to set the Template name dynamically?

HUGE THANKS


Thanks in advance for your help!
Shawn Stonequist
Remedy 6.3 p21
EMNS 

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


Re: Sending emails in HTML format

2007-11-05 Thread Shawn Stonequist
Mike,
 
Just curious, do you have your template entries set to HTML?
 



Thanks in advance for your help!
Shawn Stonequist
Remedy 6.3
EMNS 


  _  

From: Mike Balogh [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 02, 2007 8:34 AM
Subject: Sending emails in HTML format


** 
Hi everyone -
 
I'm working with a 6.03 server and email engine to try to send a certain
email notification formatted as html (as I've done many times before on
other servers).  I've setup html header and footer templates with attached
images.  And specified those header and footer templates in the approprate
place on the filter that sends the notification.  In addition, the message
body contains content which includes html tags.
 
When the message is sent, however, the content is only placed in the Plain
Text Body field on the AR System Email Messages form.  The HTML Body field
is left blank.   On the email client end, the html tags are still
interpreted properly but the formatting is a mess and the embedded images do
not display.
 
On the AR System Email Messages form, if I create an identical email record
to be sent, but copy and paste the content out of the Plain Text Body field
of the original email and into the HTML Body field of the new email, the
formatting is fine and the embedded images display properly when received.
 
So my question is:  How do I force the email engine to send the notification
as html instead of plain text?  What does it look for that would indicate
that the message being sent should be formatted as html?  Every other server
I've ever worked with in this regard has done so without issue.
 
Thanks in advance for any help you can provide,
~Mike
 
---
Michael J Balogh
Wingspan Systems Inc.
 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
 
 
__20060125___This posting was submitted with HTML in
it___ 

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


View Thread ID Details?

2007-10-22 Thread Shawn Stonequist
Greetings List!!

I'm wondering if there is anyway that can be used to view specific thread
IDs.

I ask because it seems every Monday, between 8am  10am, our ARServer slows
significantly. We've held off doing various Monday Morning reports 
backups, but without any improvement.

Our DB believes that the issue is being caused by a thread, but can't tell
which one.

I ran our Thread Logging in the System Config, but I only got ID's and
when they started (2, but only just after we received the complaint about
the Server's performance). Unfortunately, this log doesn't say *what* these
threads were doing.

It is my hope that, by finding out what these threads are doing (even if I
have to start the Thread Logging on the previous Friday, weekends are
low-to-no activity anyway) we can determine what is causing this issue-
errant search? user with a bad query? automated system? etc.

Huge thanks in advance to all!!!

Shawn Stonequist
Remedy 6.3
EMNS 

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


6.3 Mid Tier Search Question

2007-09-07 Thread Shawn Stonequist
Listers,

I implore your help once again!!!

We just setup Mid Tier, so please forgive what may be a silly question.

Once of the things that we found (but can't explain), is that it seems that
the $NULL$ keyword works differently.

For instance, while running a search with the NULL keyword in a particular
field (specifically, !=$NULL$), there were 0 results returned.

When we did the same in the User Client, or used the Advanced Search (for
both User  Mid Tier), then we received 277 results.

After investigating the logs, we found that by using the Fields on Mid Tier,
the SQL did:
   Table.Field != ''   

Using the same logs, and running the search by Advanced Search or the User
client, we found that the SQL did:

   Table.Field IS NOT NULL   

Is there a reason for this that anyone is aware of? Is there a way to make
it behave itself (sorry, bad pun)?

HUGE thx in advance
Shawn Stonequist
EMNS Inc.
Remedy/MidTier 6.3

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


Re: Fields that are in Crystal report,are not visible when I run the report through AR User.

2007-09-06 Thread Shawn Stonequist
 
Preeti,

I only mention this because I keep forgetting about it ;)

Remember that Crystal is using the Database Names for the Fields, and Remedy
User is using the Display Names for the Fields, as they appear in the View
being used when the Report is created.

HTH!
Shawn Stonequist
EMNS Inc.


-Original Message-
From: Riya_D [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 06, 2007 5:12 AM
Subject: Re: Fields that are in Crystal report,are not visible when I run
the report through AR User.

Yes I have given all the fields(visible and invisible fields) Public
permission.


Anthony K R wrote:
 
 Do you have 'Remedy Permission' on those invisible fields?
 
 Regards,
 Anthony
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:[EMAIL PROTECTED] On Behalf Of Riya_D
 Sent: Thursday, September 06, 2007 12:28 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Fields that are in Crystal report,are not visible when I 
 run the report through AR User.
 
 The ODBC Use Underscores check box is checked in AR User tool.Still 
 the columns are not visible.
 
 
 remedy26 wrote:
 
 Preeti,
 
 One my clients is facing the same problem.
 
 Make sure you have checked Use ODBC Underscores in
 Tools-Options-Advanced tab.
 
 It may be the cause if its unchecked.
 
 In my case I can see the report perfectly on the server - user tool
 but on
 the clients - user tool some columns are missing.
 
 Any ideas what may be the cause???
 
 
 Thanks in advance.
 
 Prashant
 
 On 9/6/07, Riya_D [EMAIL PROTECTED] wrote:

 Fields (of AR User form) that are in Crystal report,are not visible
 when
 I
 run the report through AR User.

 Field(column) are visible when I run the Crystal report directly.But
 when
 I
 run the same Report through AR User tool some columns are not
 visible.
 --
 View this message in context:

 http://www.nabble.com/Fields-that-are-in-Crystal-report%2Care-not-visi
 bl
 e-when-I-run-the-report-through-AR-User.-tf4389793.html#a12515886
 Sent from the ARS (Action Request System) mailing list archive at 
 Nabble.com.



 __
 __
 ___
 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
 
 
 
 --
 View this message in context:
 http://www.nabble.com/Fields-that-are-in-Crystal-report%2Care-not-visi
 bl
 e-when-I-run-the-report-through-AR-User.-tf4389793.html#a12516703
 Sent from the ARS (Action Request System) mailing list archive at 
 Nabble.com.
 
 __
 __
 ___
 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
 
 

--
View this message in context:
http://www.nabble.com/Fields-that-are-in-Crystal-report%2Care-not-visible-wh
en-I-run-the-report-through-AR-User.-tf4389793.html#a12519513
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.


___
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


Import Issues - 6.3

2007-09-04 Thread Shawn Stonequist
Greetings List!!

I'm running into something strange while doing an import. I have the
preferences set to update records, and have mapped the Request ID field.

For some reason, the import tool complains that Field ID 8 is missing
(which, it shouldn't, it should be updating existing Request ID, which
already has Field ID 8 filled in). So I map it (its not like this field is
changing so I don't care as much). When I check the User Tool, I now have
twice as many records as I started with.

Again, the preferences are set to Update, not Replace or Generate New,
so I'm very confused.

Shawn Stonequist
EMNS, Inc.
Remedy 6.3

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


Re: BMC have done it again

2007-08-22 Thread Shawn Stonequist
From a money perspective, doesn't it make sense?
 
If your customers don't know they can build their own apps, then they'll buy
more OOTB, which require separate licenses, yes?

  _  

From: Bradford Bingel [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 20, 2007 11:51 PM
Subject: Re: BMC have done it again


** 
Indeed, it makes you wonder . . .
 
Last time I spoke with a Remedy direct salesperson, new the the company in
the last couple of years, they were unclear what the AR System was.  They
knew all about the applications (Service Desk, Change Management, etc.) but
had no idea the AR System was actually a workflow engine toolkit, upon which
applications could be built.  Guess they figured the AR System was that
thing customers need to buy along with their application licenses.
 
It's ironic that BMC Remedy treats the core product that provides the
applications with their power and flexibility, and the product which build
Remedy to what it is today, as a second-class citizen.

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Molenda
Sent: Monday, August 20, 2007 9:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMC have done it again


** 

I have never understood why BMC still continues to term ARSystem as a
Heritage product. Most vendors term Heritage products as the old stuff that
is going away.

 

Guess it is not a mainstream, frontrunner, flagship product?

 

 

Thanks-n-advance; 

HDT Platform Incident / Problem Manager  Architect 
Robert Molenda 
IT OS PA 
Tel: +1 408 503 2701 
Fax: +1 408 503 2912 
Mobile: +1 408 472 8097 
[EMAIL PROTECTED] 

Quality begins with your actions.

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Monday, August 20, 2007 7:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMC have done it again

 

Actually the Remedy (AR System) patches are still the same as before.

 

The page where you select Remedy Heritage Products, visit the Patch
Download site. has been updated but the patch page is still the same.

 

Fred

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ian Trimnell
Sent: Monday, August 20, 2007 4:13 AM
To: arslist@ARSLIST.ORG
Subject: BMC have done it again

** 

Just went to BMC Support Central to check out the latest patches and have
noticed that they have gone and changed the product download area.   This
has now changed to Electronic Product Distribution (or EPD) and it does
not now work with any of my browsers :-(   

Response from https://webapps.bmc.com/epd/ is:


Proxy Error


The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET
https://webapps.bmc.com/epd/  /epd/.

Reason: Error reading from remote server

Why oh why do these people go and change things?  BTW, I am using Firefox 2
and IE 6 and they both worked with the old download system.  So my question
to BMC is 'what has changed?'

Yours in frustration,

Ian
  _  


Ian Trimnell, AR System Lead Developer (amongst other jobs),
Specialist Support  Information Team, Academic  Administrative Computing
Service
Open University, MILTON KEYNES, UK
Phone: 01908 653741   web: http://www.open.ac.uk/ 

 

  

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___ __20060125___This posting was submitted with
HTML in it___ 

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


Table Loop Update issue - 3rd action of a guide not running

2007-08-20 Thread Shawn Stonequist
Greetings List!!

Another Table Loop issue I'm hoping you can help with! Many thanks in
advance!!

I've got an Active Link (executes on a button) that runs an Active Link
Guide that includes 3 active links, and has 1 label just before the 3rd AL.
The 3rd AL refreshes the table, sets some temp fields based on the refreshed
table, then sets a Diary Field with the values of those temp fields.

When Table Looping is off, this works perfectly (though of course, only
works on 1 row per button press).

With Table Looping on, the Guide seems to completely ignore the last Active
Link. According to the Logs, the Guide runs, checks the first and second
links, runs the appropriate one, then goes to the Label and stops.

This is perfect except for the fact that it stops too soon, and I see no
reason for it to do so.

A little more detail if its helpful:

The first two AL are set to check the Status in the table, and if its not
theirs push their value to the child record (e.g. the Active Status AL
only runs if the Status is Inactive and vice verse for the second one),
then uses a Go to Label action to ensure that the other AL is skipped.
(here is where it all ends when Table Loop is turned on).

The third AL refreshes the table, sets the temp fields in the first set
fields action, then uses a second set field action to set the Diary field.

Any ideas?
Again, thanks in advance for your help!!!
Shawn Stonequist
EMNS, Inc.

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


Re: Table Field Question - Set Fields based on Column

2007-08-17 Thread Shawn Stonequist
 Thilo,

I think this is what I need, but I can't seem to get it to work.

Here's how I have it setup:

Active Link 1: 
Run If: Return on Field Next Due
Action 1: Set Field Next Due with Colmin (Column Target)
Action 2: Call Guide Next Due IDs w/ Table Loop
Active Link Guide Next Due IDs contains Active Link 2

Active Link 2:
Run If: Field Next Due = Column Target
Action 1: Set Field Next Due ID = Column ID
Action 2: Exit Guide

Most grateful for ALL help
Shawn Stonequist
EMNS, Inc.
Remedy 6.3

-Original Message-
From: Thilo Stapff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 16, 2007 2:31 PM
Subject: Re: Table Field Question - Set Fields based on Column

You might implement a table loop guide. This guide would contain a single
Active Link that does something like the following:

Run If: 'Next Due Time' = 'tmp_colmin'
   Action 1: Set Fields from current screen
 'tmp_entry_id' = 'column_entry_id'
   Action 2: Exit Guide


This method might be too slow if the table contains a large number of rows.


Regards,
Thilo Stapff



Shawn Stonequist wrote:
 Greetings List!
 
 I currently have a table field that, among other things, shows the 
 Entry ID, and various Target Due times from data in another Form. 
 Using a COLMIN function, I'm able to set a field with the Next Due 
 Time showing the time that the next record is due. However, I'd also 
 like to set the Entry ID of the next record due itself. I'd like to do 
 this from the table, as the source schema is rather large and is 
 polled once already to create the results in the table.
 
 Is this possible?
 
 Thx!
 Shawn Stonequist
 EMNS, Inc.
 Remedy 6.3
 
 __
 _ 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


Table Field Question - Set Fields based on Column

2007-08-16 Thread Shawn Stonequist
Greetings List!

I currently have a table field that, among other things, shows the Entry ID,
and various Target Due times from data in another Form. Using a COLMIN
function, I'm able to set a field with the Next Due Time showing the time
that the next record is due. However, I'd also like to set the Entry ID of
the next record due itself. I'd like to do this from the table, as the
source schema is rather large and is polled once already to create the
results in the table.

Is this possible?

Thx!
Shawn Stonequist
EMNS, Inc.
Remedy 6.3

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


Re: Attachement Updation - File Contents Changed

2007-08-03 Thread Shawn Stonequist
 Just a thought, but instead of attaching the files directly to the request
you are on, what if it was a child form, with a Submit-Only, single field,
attachment pool?
 
This way, to upload a new attachment, a new child record has to be created,
and you know who  when did it. This would also keep historical records, you
could compare the file at each and every stage/change that took place, or if
you don't need this, you could simply delete the previous records. 
 
I've not worked through this completely, so I'm not sure what complications
might arise (though, immediately I can think of the fact users will have to
open the child record before they can get to the attachment) .
 
HTH
Shawn Stonequist
EMNS, Inc.
  _  


On 8/2/07, Meenakshinathan [EMAIL PROTECTED] wrote: 

Hi Robert,

Thanks for the information.

Anyhow this solution is not working. Remedy stores the attachments in
the following way number of characters,no of bytes(i am sure. but
it might bytes),filename with extenstion. 

I am not user this TR and DB can apply for attachement fields.

can any one give me a alternative solution on this? Looking for your
inputs.

Thanks,
Meenakshinathan


On Jul 28, 2:36 am, Robert Halstead  [EMAIL PROTECTED] wrote:
 I'm not entirely sure on this, but couldn't you do a filter on modify
 with a run-if condition as: 'TR.Attachment' != ' DB.Attachment' ??  I'm
 not entirely sure how remedy stores the attachments.  It might
 work

 Anyone else ??

 On 7/27/07, Meenakshinathan  [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  wrote:

  Hi Listers,

  In my application, at first stage users can attach 3-4 files. when the
  request assinged to next stage, that next stage user can edit or 
  modify the attachment and can upload it again. In this stage my client
  has an requirement like, first stage user to be notified whenever any
  attachement is updated. If anybody came throrough this , can you 
  please let me know how do i implement this?

  Thanks,
  Meenakshinathan

 
___-

  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where
the Answers Are

 --
 A fool acts, regardless; knowing well that he is wrong. The ignoramus
 acts on only what he knows, but all that he knows. 
 The ignoramus may be saved, but the fool knows that he is doomed.

 Robert Halstead


___-

 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the
Answers Are


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



__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___ 

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


Re: Populating a field based on values for other fields plus some string

2007-07-27 Thread Shawn Stonequist
 Ray,

This can be done by Filter or Active link (Filter if the SQLFilter field is
on a different form than the one your user is saving)

You can use a simple Set Fields action (or Push Fields if sending to a
different form)

Under the Fields section of the If or Else tab, select SQLFilter from
the drop down menu, then use the following for Value:

Customer =  + $Field1$ +  AND Severity =  + $Field2$

Remember to use the double quotes () around any text/strings and the dollar
signs around any dynamic values you wish to use.

HTH

Shawn Stonequist
EMNS Inc.


-Original Message-
From: Ray [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 26, 2007 9:14 PM
Subject: Populating a field based on values for other fields plus some
string

Hi: I have three fields called Field1, Field2 and SQLFilter in a form. 
User provides data for Field1and or Field2. When the user hits the save
button, I want to populate the SQLFilter field with the following string
Customer = 'Value of Field1' AND Severity = Value of Field2

I am thinking I have to use a filter. Not sure how to go about it. Can
someone help

Thanks
Ray


___
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


View Field HTML Email Templates

2007-07-27 Thread Shawn Stonequist
Greetings List!!!

I've setup a series of HTML Email templates for one of our customers that
successfully sends under various conditions when the end-user list in the
entry has an email address- everything works perfectly!

Now, this customer wants to be able to make a printout to be snail-mailed to
end-users that do not have email addresses.

I had two thoughts on how to do this, but neither has been successful:

1) Create a View Field, with a Set Field action that pulls the HTML Email
Template, then the user can right-click and print.

2) Send the user to an HTML webpage that displays the HTML Email Template.

I prefer #1, since any updates will be applied to both x-mails at the same
time, however, on neither of these options have I been able to get the
values to populate (e.g. #$$Last Name$$# in the email is still #$$Last
Name$$# in the View field, even though the Last Name should display Smith
instead).

Any ideas? My only other thought was to email the user, and they would then
print from their email, though this would involve several more steps and a
waiting period, which they would prefer to avoid.

Thanks SOOO much!!!

Shawn Stonequist
EMNS, Inc.

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


Re: Urgent: - in email address causes a problem in sending email

2007-07-13 Thread Shawn Stonequist
Neel,

Not sure if this helps, but as we send a lot of email on behalf of one of
our customers to their customers, and their customers have all variety of
email addresses and formats, I did some checking on what we've sent to see
if we have this issue as well, or if there was something I could provide to
help you with.

We are on 6.3 as well, and on reviewing the Message entries, I found that
everything was being sent properly, even when there appeared a -.

This may be a little different from how you are using the email system
though- we are setting the To using a field on the record itself, not user
(we don't have any users with a - in their email address, so I can't
comment on this).

What you may wish to do (since it seems to work when taking a dynamic email
address as opposed to a user email address) is have a hidden field with a
Set Fields action that sets the email address with the -, then have your
Email Filter/Escalation use the hidden field as the To, instead of the
user's Login.

HTH

Shawn Stonequist
EMNS Inc.

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


Re: Need Help with Dynamic Date-based criteria for Escalations

2007-07-06 Thread Shawn Stonequist
John,

Thanks for the advice!! Unfortunately, I've tried yesterday, today, and
tomorrow, and still it doesn't show, even though using the same for the 9
month criteria does produce results.

The 9 month one even uses the exact same Date field, so I assume that if the
Date field or the DST were an issue, it would be affecting both.

I used Remedy to calculate the future dates from yesterday, today, and
tomorrow so that I could search independently for those static dates with
the same criteria, and had results for yesterday (428) and tomorrow (9)
- but nothing when I used the dynamic yesterday and tomorrow.

Shawn Stonequist
EMNS, Inc.

-Original Message-
From: Reiser, John J [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 05, 2007 4:21 PM
Subject: Re: Need Help with Dynamic Date-based criteria for Escalations

 Shawn,

Could it be that the Daylight Savings Time (DST) change over is affecting
your measurement?
Since it works correctly for the 9 months criteria, which puts the
calculation back into DST for 2008, and not for the 6 month time frame,
which is Standard Time for 2007.

Subtract an extra 86400 seconds and see if you get your 428 records for
12/31/07.

HTH,


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 
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Thursday, July 05, 2007 4:21 PM
To: arslist@ARSLIST.ORG
Subject: Need Help with Dynamic Date-based criteria for Escalations

Greetings List!!

I'm experiencing difficulties with an escalation. We're using Remedy 6.3

I'm having difficulty determining why the correct criteria, when using the
specific date of 12/31/07 and running a Run If qualification in the
appropriate form, I receive 428 records, while when I us the dynamic date of
(DATE = (Expire DT - 15552000) and the exact same criteria otherwise, I
receive no results at all- the date is the only part of the criteria that is
changed.

Here is the troubleshooting I've done so far:

I have 2 similar escalations- one that is triggered approximately 9 months
(270 days or 23328000 seconds) prior to the value of a Date field, the other
that is triggered approximately 6 months (180 days or 15552000 seconds)
prior to the value of the same Date field. While there are other criteria
used, they are the same for both escalations.

When I copy my 9 month search criteria into the Form against which it runs,
I received 36 results. This corresponds to the emails that were sent this
morning when the 9 month escalation ran- so I know that the criteria itself
is correct.

When I replace the number of seconds used with that the 6 month criteria
(15552000), I receive no results.

On a test form, I setup 2 Date fields and a button. When the button is
pressed, it adds the number of seconds I have for each escalation to the
Date keyword, and displays the results.

The 9 month field produces a date of 3/31/08. This corresponds to the value
of the Date field of 36 accounts- each of these was issued an email this
morning when the escalation ran.

The 6 month field produces a date of 12/31/07. This corresponds to the value
of the Date field of 428 accounts. None of these accounts received any email
notices this morning.

I have even tried replacing the 15552000 with (60*60*24*180)- it still
failed.

Can you please help me to understand why the dynamic date figure is
preventing the escalation from being triggered?

Many thanks in advance!!!
Shawn Stonequist
EMNS, Inc.


___
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

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


Re: Need Help with Dynamic Date-based criteria for Escalations

2007-07-06 Thread Shawn Stonequist
Carey,

Not a problem- I appreciate the suggestion!

The field was created while we were still on 4.5- so while it only displays
the Date, it is behaving like a Date/Time. I added the number of days as I
thought it might help clarify the situation (apologies for having done the
opposite).

I setup a test account with an Expire Date of 1/1/08 (as I had none that
were naturally occurring already), and 15552000 +/- 86400 should work
regardless (either 428 for 12/31 or 9 for 1/2/08).

Thanks and looking forward to more help!
Shawn Stonequist
EMNS, Inc.

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


Re: Need Help with Dynamic Date-based criteria for Escalations

2007-07-06 Thread Shawn Stonequist
List,

I'm not sure if this means anything to anyone, but I ran through a number of
tests to see what quantity of days/seconds would give me issues. After much
testing, I found that anything under 248 days (21427200 seconds) was
returning No Results when there were suppose to be, and anything equal to
248 and up WAS returning the proper results.

If anyone has any ideas, I'd be most grateful!!!
Thx!!!
Shawn Stonequist
EMNS, Inc.

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


(SOLVED) Need Help with Dynamic Date-based criteria for Escalations

2007-07-06 Thread Shawn Stonequist
John,

I understand what you are saying about DST now!! I guess I am just that
thick headed that I had to figure it out the hard way :(

Thanks for ALL of EVERYONE's help
I've included in my qualification both +1hr  -1hr, just to make sure I
won't have to revisit this in 6 months ;)

Thanks again everyone!!!
Shawn Stonequist
EMNS, Inc.

-Original Message-
From: Reiser, John J [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 05, 2007 4:21 PM
Subject: Re: Need Help with Dynamic Date-based criteria for Escalations

 Shawn,

Could it be that the Daylight Savings Time (DST) change over is affecting
your measurement?
Since it works correctly for the 9 months criteria, which puts the
calculation back into DST for 2008, and not for the 6 month time frame,
which is Standard Time for 2007.

Subtract an extra 86400 seconds and see if you get your 428 records for
12/31/07.

HTH,


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 

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


Need Help with Dynamic Date-based criteria for Escalations

2007-07-05 Thread Shawn Stonequist
Greetings List!!

I'm experiencing difficulties with an escalation. We're using Remedy 6.3

I'm having difficulty determining why the correct criteria, when using the
specific date of 12/31/07 and running a Run If qualification in the
appropriate form, I receive 428 records, while when I us the dynamic date of
(DATE = (Expire DT - 15552000) and the exact same criteria otherwise, I
receive no results at all- the date is the only part of the criteria that is
changed.

Here is the troubleshooting I've done so far:

I have 2 similar escalations- one that is triggered approximately 9 months
(270 days or 23328000 seconds) prior to the value of a Date field, the other
that is triggered approximately 6 months (180 days or 15552000 seconds)
prior to the value of the same Date field. While there are other criteria
used, they are the same for both escalations.

When I copy my 9 month search criteria into the Form against which it runs,
I received 36 results. This corresponds to the emails that were sent this
morning when the 9 month escalation ran- so I know that the criteria itself
is correct.

When I replace the number of seconds used with that the 6 month criteria
(15552000), I receive no results.

On a test form, I setup 2 Date fields and a button. When the button is
pressed, it adds the number of seconds I have for each escalation to the
Date keyword, and displays the results.

The 9 month field produces a date of 3/31/08. This corresponds to the value
of the Date field of 36 accounts- each of these was issued an email this
morning when the escalation ran.

The 6 month field produces a date of 12/31/07. This corresponds to the value
of the Date field of 428 accounts. None of these accounts received any email
notices this morning.

I have even tried replacing the 15552000 with (60*60*24*180)- it still
failed.

Can you please help me to understand why the dynamic date figure is
preventing the escalation from being triggered?

Many thanks in advance!!!
Shawn Stonequist
EMNS, Inc.

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


Re: include a blank value at the top of an 'on search' menu

2007-06-18 Thread Shawn Stonequist
Neel ,
 
We've got some of these-  I built a form with 4 fields- Menu Name, Menu
Label, Menu Value, Status. Basically, for each blank we want, we choose the
Search Menu that it is to be added to, set the Status to Active, then save
without a Label or Value. All the menus using this form are set to Sort on
Label, so this puts the blank at the top
 
HTH!!!


Shawn Stonequist
EMNS Inc.
866.970.
[EMAIL PROTECTED] 

  

  _  


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Neel Guatam
Sent: 15 June 2007 20:27
To: arslist@ARSLIST.ORG
Subject: include a blank value at the top of an 'on search' menu

 

Hello listers,

 

I've a character menu that does a look-up on some other form to grab a list
of available values. I would like to add a blank value on top of the menu
item. Any ideas as to how this can be done?

 

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.

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___

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


Email List Issues - Remedy 6.3

2007-05-08 Thread Shawn Stonequist
Greetings List!

I wasn't able to find anything in the archives or the manuals, so I'm hoping
you can help me.

We have a list of checkboxes that we want to send in an Email. When saved,
the values ($Checkbox$) is saved into a field Email Body, then setting the
Text field to 

Unfortunately, if checkboxes are NOT selected, this may leave several empty
lines in the email. I tried using REPLACE($Email Body$,  ||,  ),
however, this defeats the purpose of the line break to begin with and pushes
all the values into a single string that isn't easy to read.

I've put into place the following set field action: REPLACE($Email Body$,
||,  |), which improves the matter by cutting the line breaks in half,
however, there are still empty line breaks (e.g. 6 empty lines between
values becomes 3 empty lines between values).

The only other thing I can think of is 1 Active Link per Checkbox- if
checked, then add to the Email Body field. I'd prefer not to have 1 AL per
Checkbox- is this the only way to do this?

Thx in advance!!!
Shawn Stonequist
EMNS Inc.

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


Crystal Question: Arrays

2007-04-18 Thread Shawn Stonequist
Greetings List!

I'm trying to run a Crystal Report using Data from Remedy. In one field I
have a menu which sets values such as 

Value1: SubValue1
Value1: SubValue2
Value2: SubValue1

etc.

I'm trying use the Split command to break these apart so I can group the
SubValues by the Value in a Cross-Tab.

I've got the formula for the Split, but I can't figure out how to use this
to grab the first element created and display it so that I can use it in the
groupings.

Is there a way to do this? Or, is there another way to break this one field
into two (e.g. like Excel's Text to Columns using a Delimiter of :)?

I've poured through the Crystal Help, but it wasn't helpful- when I seemed
to get a valid solution, I was told that I needed to script the array,
example: Array [i]. When I put the Split into the brackets, it said that the
rest wasn't part of the equation.

Thanks in advance for your help!!!
Shawn Stonequist
Emns, Inc.

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


Re: Advanced Change Fields

2007-04-16 Thread Shawn Stonequist
Thad,
 
Sorry- yes, it is version 6.3
 
While I understand the goal, the issue is that when I use the Database ID
for the Table fields, the Change Field action doesn't fire. In other words,
I've tried setting the Current Table field 12345, $12345$, and $12345$.
 
None of these seems to work properly- when I get to the point in my workflow
where the Refresh should occur, nothing happens and I get the following
message in my Logs:
 
ACTL - Passed qualification -- perform if actions
ACTL  0: Set Characteristics
ACTL   * No such field on schema
ACTL   Refresh field
 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 13, 2007 11:49 AM
To: Shawn Stonequist
Subject: RE: Advanced Change Fields



Maybe I'm not getting what you are asking.  Attached is a def file with a
Display only form and 3 active links.  Two of the active links set the
FieldID of the last table touched.  The 3rd active link triggers on a button
to refresh the correct table.  As you select the tables, note the field id
shows up in the char field.  You can then right-click and clear the table to
validate the next step.  Click the button and the table with the fieldid in
the char field will refresh. 

I didn't see version info, this is 6.3.   

Let me know how this works. 

Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard Bach




Shawn Stonequist [EMAIL PROTECTED] 


04/13/2007 05:22 AM 



To
'Thad Esser' [EMAIL PROTECTED] 

cc
arslist@ARSLIST.ORG 

Subject
RE: Advanced Change Fields






Thad, 
  
Thank you! Unfortunately, this sets the Database ID number, which I have
tried and doesn't seem to work with the Advanced Change Field properties. 
  
I appreciate the assistance! 
  
Shawn Stonequist 
EMNS, Inc. 


  _  

From: Thad Esser [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 12, 2007 3:35 PM
Subject: Re: Advanced Change Fields

** 
Have you tired the $FIELDID$ keyword in your Set Fields? 

Current Table = $FIELDID$ 

Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard Bach



Shawn Stonequist [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG 


04/12/2007 12:15 PM 



Please respond to
arslist@ARSLIST.ORG




To
arslist@ARSLIST.ORG 

cc

Subject
Advanced Change Fields








** 
Greetings list! 
 
I've got a few table fields on a form and would like to refresh the last one
touched when a menu option is selected. I'm trying to use the Advanced
properties of the Change Field Action so I only need 1 (I already have other
workflow that has to run anyway, so I added a Set Fields that sets the value
of Current Table as well). 
 
It appears that my Set Fields that states what the current table is isn't
correct- I've tried the following 
 
Current Table = $Table Name$ 
Current Table = $Table ID$ 
Current Table = Table Name 
Current Table = Table ID 
Current Table = $Table Name$ 
 
I can see that Current Table field is being set properly for each of the
above options that I tried. Unfortunately, when I review the workflow logs,
it appears that the System doesn't like any of these and states that *
No such field on schema 
 
No Run If 
No Execute On 
Menu/Row Choice is selected 
My Advanced Change Field simply Reads: 
Field Name: $Current Table$ 
Refresh Table Field is checked 
 
Does anyone know why I'm having issues? 
 
Thanks! 
Shawn Stonequist 
EMNS, Inc 
__20060125___This posting was submitted with HTML in
it___ 

***IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended to
be a legally binding signature.*** 


__20060125___This posting was submitted with HTML in
it___ 



***IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended to
be a legally binding signature.***



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


Re: Advanced Change Fields

2007-04-16 Thread Shawn Stonequist
Thad,
 
Unfortunately, our spam filters blocked your definitions, so I don't know.
With regards to the permissions, I test everything as an Admin first so I
can focus on functionality, then go back and test with a test login that has
specific permissions.
 
I did setup workflow to use FieldID, then it worked- I went back and set the
FieldID to the Database ID of the table, and now its working as well- I'm
not sure if I had an error or?
 
Thank you VERY MUCH for your help!
Shawn Stonequist
EMNS, Inc.

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 16, 2007 11:02 AM
To: Shawn Stonequist
Subject: RE: Advanced Change Fields



Hmm, that is odd.  Does my test form work okay for you?  I wonder if it is
just your one form, or if its something with the system?  Have you looked at
permissions on all the fields involved? 
  
Thad Esser
Remedy Developer
Work: 503-220-6192
Argue for your limitations, and sure enough, they're yours.-- Richard Bach




Shawn Stonequist [EMAIL PROTECTED] 


04/16/2007 05:05 AM 



To
[EMAIL PROTECTED] 

cc
arslist@ARSLIST.ORG 

Subject
RE: Advanced Change Fields






Thad, 
  
Sorry- yes, it is version 6.3 
  
While I understand the goal, the issue is that when I use the Database ID
for the Table fields, the Change Field action doesn't fire. In other words,
I've tried setting the Current Table field 12345, $12345$, and $12345$. 
  
None of these seems to work properly- when I get to the point in my workflow
where the Refresh should occur, nothing happens and I get the following
message in my Logs: 
  
ACTL - Passed qualification -- perform if actions
ACTL  0: Set Characteristics
ACTL   * No such field on schema
ACTL   Refresh field 
  


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 13, 2007 11:49 AM
To: Shawn Stonequist
Subject: RE: Advanced Change Fields


Maybe I'm not getting what you are asking.  Attached is a def file with a
Display only form and 3 active links.  Two of the active links set the
FieldID of the last table touched.  The 3rd active link triggers on a button
to refresh the correct table.  As you select the tables, note the field id
shows up in the char field.  You can then right-click and clear the table to
validate the next step.  Click the button and the table with the fieldid in
the char field will refresh. 

I didn't see version info, this is 6.3.   

Let me know how this works. 

Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard Bach



Shawn Stonequist [EMAIL PROTECTED] 


04/13/2007 05:22 AM 




To
'Thad Esser' [EMAIL PROTECTED] 

cc
arslist@ARSLIST.ORG 

Subject
RE: Advanced Change Fields








Thad, 
 
Thank you! Unfortunately, this sets the Database ID number, which I have
tried and doesn't seem to work with the Advanced Change Field properties. 
 
I appreciate the assistance! 
 
Shawn Stonequist 
EMNS, Inc. 


  _  

From: Thad Esser [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 12, 2007 3:35 PM
Subject: Re: Advanced Change Fields

** 
Have you tired the $FIELDID$ keyword in your Set Fields? 

Current Table = $FIELDID$ 

Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard Bach


Shawn Stonequist [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG 


04/12/2007 12:15 PM 



Please respond to
arslist@ARSLIST.ORG





To
arslist@ARSLIST.ORG 

cc

Subject
Advanced Change Fields











** 
Greetings list! 

I've got a few table fields on a form and would like to refresh the last one
touched when a menu option is selected. I'm trying to use the Advanced
properties of the Change Field Action so I only need 1 (I already have other
workflow that has to run anyway, so I added a Set Fields that sets the value
of Current Table as well). 

It appears that my Set Fields that states what the current table is isn't
correct- I've tried the following 

Current Table = $Table Name$ 
Current Table = $Table ID$ 
Current Table = Table Name 
Current Table = Table ID 
Current Table = $Table Name$ 

I can see that Current Table field is being set properly for each of the
above options that I tried. Unfortunately, when I review the workflow logs,
it appears that the System doesn't like any of these and states that *
No such field on schema 

No Run If 
No Execute On 
Menu/Row Choice is selected 
My Advanced Change Field simply Reads: 
Field Name: $Current Table$ 
Refresh Table Field is checked 

Does anyone know why I'm having issues? 

Thanks! 
Shawn Stonequist 
EMNS, Inc 
__20060125___This posting was submitted with HTML in
it___ 

***IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient

Push Fields to Multiple Table Selections

2007-04-16 Thread Shawn Stonequist
Greetings List!

Is it possible to push a value to the same field on a list in a Table?

For example, if the table has 10 entries, I want users to be able to select
x number of entries, then press a button that changes the status of all
selected. How can this be done?

Thx!
Shawn Stonequist
EMNS, Inc.

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


Re: Advanced Change Fields

2007-04-13 Thread Shawn Stonequist
Thad,
 
Thank you! Unfortunately, this sets the Database ID number, which I have
tried and doesn't seem to work with the Advanced Change Field properties.
 
I appreciate the assistance!
 
Shawn Stonequist
EMNS, Inc.

  _  

From: Thad Esser [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 12, 2007 3:35 PM
Subject: Re: Advanced Change Fields


** 
Have you tired the $FIELDID$ keyword in your Set Fields? 

Current Table = $FIELDID$ 

Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard Bach




Shawn Stonequist [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList)
[EMAIL PROTECTED] 


04/12/2007 12:15 PM 


Please respond to
[EMAIL PROTECTED]



To
[EMAIL PROTECTED] 

cc

Subject
Advanced Change Fields






** 
Greetings list! 
  
I've got a few table fields on a form and would like to refresh the last one
touched when a menu option is selected. I'm trying to use the Advanced
properties of the Change Field Action so I only need 1 (I already have other
workflow that has to run anyway, so I added a Set Fields that sets the value
of Current Table as well). 
  
It appears that my Set Fields that states what the current table is isn't
correct- I've tried the following 
  
Current Table = $Table Name$ 
Current Table = $Table ID$ 
Current Table = Table Name 
Current Table = Table ID 
Current Table = $Table Name$ 
  
I can see that Current Table field is being set properly for each of the
above options that I tried. Unfortunately, when I review the workflow logs,
it appears that the System doesn't like any of these and states that *
No such field on schema 
  
No Run If 
No Execute On 
Menu/Row Choice is selected 
My Advanced Change Field simply Reads: 
Field Name: $Current Table$ 
Refresh Table Field is checked 
  
Does anyone know why I'm having issues? 
  
Thanks! 
Shawn Stonequist 
EMNS, Inc 
__20060125___This posting was submitted with HTML in
it___ 


***IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended to
be a legally binding signature.***


__20060125___This posting was submitted with HTML in
it___

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


Capturing Search Criteria

2007-04-13 Thread Shawn Stonequist
Greetings List!
 
I have two questions regarding capture search information:
 
1) Is there a way to capture the information from the Advanced Search bar
and send it via Push Fields action to another form?
 
2) Is there an easy way to capture all Non Null fields searched on? (the
only way I can think of is a Run-If statement for each and every field- the
form I would like this on has a LOT of fields).
 
Thank you in advance!
Shawn Stonequist
EMNS, Inc.

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


Advanced Change Fields

2007-04-12 Thread Shawn Stonequist
Greetings list!
 
I've got a few table fields on a form and would like to refresh the last one
touched when a menu option is selected. I'm trying to use the Advanced
properties of the Change Field Action so I only need 1 (I already have other
workflow that has to run anyway, so I added a Set Fields that sets the value
of Current Table as well).
 
It appears that my Set Fields that states what the current table is isn't
correct- I've tried the following
 
Current Table = $Table Name$
Current Table = $Table ID$
Current Table = Table Name
Current Table = Table ID
Current Table = $Table Name$
 
I can see that Current Table field is being set properly for each of the
above options that I tried. Unfortunately, when I review the workflow logs,
it appears that the System doesn't like any of these and states that *
No such field on schema
 
No Run If
No Execute On
Menu/Row Choice is selected
My Advanced Change Field simply Reads:
Field Name: $Current Table$
Refresh Table Field is checked
 
Does anyone know why I'm having issues?
 
Thanks!
Shawn Stonequist
EMNS, Inc

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


Re: User tool abruptly closes the session.

2007-04-10 Thread Shawn Stonequist
List,
We are seeing the same issue as Girish. I do not believe this problem is
related to the Preference Server- we were on 4.5 until last September, and
we had been having this issue for at least 1 year prior to that. After
upgrading, we still see the issue. We just started using the Preference
Server, but this has not affected the frequency of the issue.
 
What we did notice was that our users that are on XP have never seen this
issue at all. Our users on WIN2K have this problem frequently (as many as 3
times in an hour). We aren't sure the OS is the key though, as our XP Users
don't use Remedy as much. As well, we've noticed that this occurs 95% of the
time when an Active Link's Set Fields action is run (maybe there is
something in the AL and this is only a coincidence).
 
Girish,
Do your XP users have this problem as well? Is it occurring when specific
actions are taken?
 
Shawn Stonequist
EMNS, Inc.
 

  _  

From: Dan Caissie [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 09, 2007 6:25 AM
Subject: Re: User tool abruptly closes the session.


** 

Would this group click on Tool and then logon and change the Preference
server?

This is where I have seen this problem, if I do that I can expect the user
tool to crash as soon as I would go to save any thing.

I think this could be a bug of some sort.

 

Dan Caissie

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thimmanna, Girish
Sent: Monday, April 09, 2007 3:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: User tool abruptly closes the session.

 

Hi,

 

We are getting an error message : AR System User application has encountered
a problem and needs to be closed.

 We are sorry for the
inconvenience.

This error will close the session and we have to start a new session.

The OS on the desktop is :WIN XP/WIN 2K.

This is not happening to all users.Its only struck our FLS team.

The instances are not same.This could happen during any stage of logging a
incident/a click on any menu.

There is no problem in logging.Its only after that.

 

Regards,

 

Girish

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dan Caissie
Sent: Thursday, April 05, 2007 6:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: User tool abruptly closes the session.

** 

Are you getting an error message or anything in the event log on the local
system?

Is this happing on a windows system?

Did you try to run the user tool on the AR server to see if there are
issues?

Could it be a network issue?

Workflow that's running that's closing all windows.

Logging?

 

Dan

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thimmanna, Girish
Sent: Thursday, April 05, 2007 11:34 AM
To: arslist@ARSLIST.ORG
Subject: FW: User tool abruptly closes the session.

 

 

Hi All, 

Please, Can anyone throw some light on this. 
Thanks in advance. 

Regards, 

Girish. 
__ 
From:   Thimmanna, Girish  
Sent:   Monday, April 02, 2007 10:59 AM 
To: arslist@ARSLIST.ORG 
Subject:User tool abruptly closes the session. 

 

Hi All, 

We have recently started facing this problem with the User tool. 
It seems like the whole of our FLS is caught with the same problem were the
User tool session ends abruptly. 
The Error says: 
The AR System User Application has encountered a problem and needs to be
closed. 
We have tried to use an latest patch update User installation. But doesn't
solve the problem. 
The User tool version presently used is 5.1.2 patch 1303. 

Any help is much appreciated. Thanks in advance. 

 

Regards, 
Girish. S .T 
Remedy Application Management Services 

 

This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender. Thank you.

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with HTML
in it___

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


Issues with online Compose/Send?

2007-04-10 Thread Shawn Stonequist
List,

For the past few weeks, I've noticed that anything I submit via the site's
Compose page has not been submitted to the list and seems to get lost,
even when I request a copy sent to myself.

Is anyone else seeing this, or just me?

Thx!
Shawn Stonequist
EMNS, Inc.

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


Remedy Full Text Searching

2007-02-23 Thread Shawn Stonequist
Greetings List!!

We've heard through the grapevine that FTS was back in version 7, however,
we haven't been able to ascertain many details on this. Is it true? Is it
worth upgrading from 6.3? If anyone is using this, what issues, if any, have
been encountered?

Our Support is checking into this for us, but we wanted to see what other
Remedy Admins thought as well.

As always, thanks so much for your time!!!
Shawn Stonequist
EMNS, Inc.

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


Indexing in Remedy 6.3

2007-02-18 Thread Shawn Stonequist
Greetings List!

Management has asked me a couple questions regarding Remedy Indexes. Still
considering myself an amateur, I gave my best guess as I understood, but
they would like to confirm.

They would like to know:
1) How exactly does Remedy Indexing work?
2) In 4.5 we had case-insensitive searches. In 6.3, I've not been able to
find this. Does it exist? How do we activate it?

I tried searching the archives, but I always came up with too little or too
much- if anyone knows of past-posts that would help as well, I'd be most
grateful!

As always, thank you in advance for all your help!

Shawn Stonequist
Amateur Remedy Admin
EMNS, Inc.

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


Remedy 6.3 Indexing Questions

2007-02-18 Thread Shawn Stonequist
Greetings List!

Management has asked me for details how Remedy Indexing works. I let them
know that I believed it created the indexes in Oracle and from there the
Indexing was all up to Oracle and our DBA would be able to go into further
detail, but that I wasn't sure and would find out. Is someone able to
confirm/correct this theory?

As well, we would like to know what happened to Case-Insensitive searching.
We came from 4.5 with its FTS Indexing that could be set to allow
Case-Insensitive searches, however, we can't find any settings to allow this
within 6.3. Can anyone assist?

As always, thanks in advance!

Shawn Stonequist
EMNS, Inc.

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


Issue with the List Page? RE: Remedy Indexing questions

2007-02-09 Thread Shawn Stonequist
Greetings List!
 
I was just wondering if there are any issues with the Post to List feature
on the site- I've tried posting something twice now, and its still not made
it into the Archives. Just wondering.
 
As for the questions I was attempting to ask:
 
I'm wondering if anyone has details on how Remedy Indexing actually works-
e.g. does Remedy simply send the Indexing to the underlying database, then
the underlying database (i.e. Oracle) does whatever it does with Indexes?
Or?
 
Also, is there a way to activate Case-Insensitive searching? We used to have
this with FTS on 4.5, but don't see anything comparable in 6.3 that we are
now using.
 
As always, thanks in advance!!
 
Shawn Stonequist
EMNS, Inc.

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


Re: Newbie

2007-01-17 Thread Shawn Stonequist
Tony,

I was in something of a similar predicament- in my case, I quickly came to
the extent of our outgoing admin's knowledge and found myself on my own.
The third most helpful thing that I found (after this list and the manuals)
was creating a dummy form (we only have a production enviroment as well).
This is still useful to me today to try out things and figure out what works
and what issues I'll run into.

FYI, you can get the Admin Client
here:http://www.bmc.com/info_center_support/overview/0,3252,19097_4736150,00.html
though I believe you need your Remedy Support login information to access.

HTH
Shawn Stonequist
EMNS, Inc.

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


Re: How to disable Copy All and Paste All Functionality

2007-01-15 Thread Shawn Stonequist
Wouldn't it be a great Enhancement if Remedy/BMC would add Copy All to the
Execute On list? Then we could handle it as we needed.

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


Re: Remedy 6.3 Manage Licenses (Last Access Time Issue)

2007-01-08 Thread Shawn Stonequist
Joe,

Thank you for your response! Yes, I personally have made updates many times
over, so I would imagine that it would have updated. Also, our system isn't
Locked, so I believe (based on my amatuer understanding) that in this
mode, creates also require a Write license.

Thx!!!
Shawn Stonequist

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


Re: Remedy 6.3 Manage Licenses (Last Access Time Issue)

2007-01-08 Thread Shawn Stonequist
Dave,

This is helpful- but we are on path 18. Would the fix have been included in
this patch as well?

Thx!!!
Shawn Stonequist

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


Re: Remedy 6.3 Manage Licenses (Last Access Time Issue)

2007-01-08 Thread Shawn Stonequist
Matt,

Thank you so much! This would be most helpful!!

Thx!
Shawn Stonequist

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


Re: Remedy 6.3 Manage Licenses (Last Access Time Issue)

2007-01-08 Thread Shawn Stonequist
Dave,

Does this mean that we need to use Patch 17, then 18 again?

Thx!!!
Shawn

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


Remedy 6.3 Manage Licenses (Last Access Time Issue)

2007-01-05 Thread Shawn Stonequist
Greetings List!!!

I'm experiencing something unusual with the Manage License in the Admin
Tool. Ever since we upgraded from 4.5 to 6.3, it seems that the Last Access
Time is always the same as the Connect Time.

For instance, my own login has been on since 6:41 this morning, and 6:41 is
the Last Access time, however, I've been using my login steady since then in
both User  Admin tools. In 4.5, the Last Access Time would update to
whenever the user last saved. This doesn't seem to be the case anymore (I
have closed and reopened the Manage License dialogue, so I know I'm not
looking at a previous snapshot).

Is this the way it should be with 6.3? If not, does anyone know what is
wrong or how to fix it?

Thank  you VERY much in advance!
Shawn

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


Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-03 Thread Shawn Stonequist
Thanks you Axton, Patrick,  Lars!!!

We really appreciate the input so far and I've taken these suggestions to
the powers that be for discussion!!

I look forward to any other ideas that may be out there!

Thank you all again!!
Shawn Stonequist
EMNS, Inc.

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


Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-02 Thread Shawn Stonequist
Greetings List!!

We have an issue in which some users (we know not who) are running queries
which are affecting the performance of our Remedy system, causing
significant delays, issues, and even complete system lock-ups for all our Users.

We have three goals that we would like to accomplish:
1) Identify the user(s) and what they are doing
2) Prevent future performance degradation of this nature
3) Stop offending queries in progress should prevention be not possible to
bypassed in some manner, using a method other than rebooting our database
(as this brings all our users down, which is what we are trying to remedy)

We are interested in any possible solutions or paths to accomplish one or
more of these goals. We spoke with our Remedy Partner that provides our
support, but unfortunately, their best resolution was using User/API/SQL
Logging Remedy-side.

Unfortunately, for this to be successful, we would need to know before the
offending query is run, or have it always running (something our SA is
against due to system resource concerns)

Our SA provided me the following information concerning our configuration,
which may be helpful (I apologize that I don't know what it all means):

Distributed Server
Remedy 6.3.0 patch 018
Oracle 10.0.2
Monolithic

We look forward to and appreciate any assistance available.

Thanks
Shawn Stonequist
EMNS, Inc.

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


Crystal Reports - Default Date Parameters

2006-11-12 Thread Shawn Stonequist
Greetings again List!

I was unable to locate anything in the Archives- if anyone knows I'd be most
grateful.

Basically, is there a way to set a Crystal Reports Data Range parameter
which defaults to Yesterday, whatever that may be?

Thx in advance!
Shawn Stonequist
EMNS, Inc.

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


Sending Data to View Fields

2006-11-12 Thread Shawn Stonequist
Greetings List!

I was wondering if anyone knew of a way to send data to URL/Website from the
Remedy form fields to the URL when it is displayed in a View Field?

Thx in advance!
Shawn Stonequist
EMNS, Inc.

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


Re: Character Fields

2006-10-19 Thread Shawn Stonequist
Lisa,

Depending on what version of Remedy you are using, there are two solutions:

1) In Remedy 6.3, you can use an Active Link 'Change Field' to change the color

2) This one will take a little more work, but in Remedy 4.5 you can give
your character field no label, then create Text fields that appear/hide as
needed in the varying colors that you want (if I recall correctly, 4.5 will
require that you list the Text field as a hyperlink- I used to just refer it
to a file and put a transparent box over it so that users couldn't click
on it).

We didn't have anything between 4.5 and 6.3, so I'm not sure what those
versions offer.

HTH

Shawn Stonequist
EMNS, Inc.
Remedy Support

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Crystal Reports Question - Parsing a Diary Field

2006-10-12 Thread Shawn Stonequist
Greetings List!

This question is about Crystal Reports 11. I'm trying to create a which,
among other things, finds a key phrase in a diary field, then returns the
date/time/user stamp of the entry that contains the key phrase.

Does anyone have any idea how this can be accomplished?

Thx in advance!!!

Shawn Stonequist
EMNS, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Question about object-prop values

2006-10-12 Thread Shawn Stonequist
Greetings List!

We were reviewing exported definitions from our new 6.3 Remedy. We saw a
number of workflow objects had a line of code at the end for object-prop.
We did some checking and were told that this has something to do with Web
Aliases, however, this doesn't seem to 'fit', since the object-prop
differs, or in some cases doesn't appear at all, for workflow on the same form.

Does anyone have more information on this or confirmation of what this is for?

Thx in advance!
Shawn Stonequist
EMNS, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Re: Remedy Notification

2006-10-11 Thread Shawn Stonequist
We have several forms which use dynamic addressing- you may want to check
your data as well

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Re: Upgrading Remedy - 4.5 to 6

2006-07-24 Thread Shawn Stonequist
Thanks everyone who responded!!! All this information will be most helpful!!!

If anyone else has any/more advice/tips/info- it would be most welcome.
We've been on 4.5 for almost 6 years and this is my first upgrade (our SA is
receiving help from our Remedy Support too).

Our start/end config is similar to Mike White's if this helps.

Thanks in advance all!!!
Shawn Stonequist
EMNS, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Upgrading Remedy - 4.5 to 6

2006-07-20 Thread Shawn Stonequist
Greetings List!

We are currently working on upgrading our Remedy from 4.5 to 6 (woo hoo!)
and have new servers, databases, etc. that we will be using.

In the past when we've migrated/moved our Remedy, we have moved the data by
exporting it through the User Client (our largest form was only 45k entries,
followed by a 25k entry form). Today however, we have at least a dozen forms
with 60k+ (several with 200k+) and are encountering timeouts and other
performance issues when trying to export the data to be moved. The last time
we tried moving the data from one DB to the new DB, it all but blew up.

We are wondering if anyone else has had to move (what we consider) large
amounts of data and knows of a more efficient way to do this.

Thank you VERY much in advance for your assistance!

Shawn Stonequist
EMNS, Inc.
Remedy 4.5

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org