Does anyone know a way to select a diary filed from the appropriate Remedy
table column without the timestamp and username embedded in it? Or is there
another table or view that I could use that only has the diary field
without the user and timestamp?

Thanks,

Oracle version: Oracle 8.1.6.0.0
Remedy version: 4.5
OS: Solaris 2.7

Hello All,
I have created a dialog box that contains numerous character fields. I need
to push all of the data from all of these fields into a diary field on the
parent form. I have been able to push the data but I have ran into a
problem. The problem that I have is that all of the character fields are
pushed together with no spaces. Any ideas as to how I can add a space
between each comment?


> RICHARD A. BEDWELL, SSgt, USAF
> ACC NOSC Integration Branch
> Langley AFB, VA
> 83 CS/SCNN
> DSN: 574-6563
> Coml: (757) 764-6563
> email: richard.bedwell@langley.af.mil
>
>

-----Original Message-----
From: Bedwell Richard A SSgt 83 CS/SCNN [SMTP:richard.bedwell@LANGLEY.AF.MIL]
Sent: Tuesday, December 05, 2000 3:22 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:

**

Hello All,
I have created a dialog box that contains numerous character fields. I need
to push all of the data from all of these fields into a diary field on the
parent form. I have been able to push the data but I have ran into a
problem. The problem that I have is that all of the character fields are
pushed together with no spaces. Any ideas as to how I can add a space
between each comment?


> RICHARD A. BEDWELL, SSgt, USAF
> ACC NOSC Integration Branch
> Langley AFB, VA
> 83 CS/SCNN
> DSN: 574-6563
> Coml: (757) 764-6563
> email: richard.bedwell@langley.af.mil
>
>

Try:

$FIELD$ + " "+$FIELD2$ + " "

Bedwell Richard A SSgt 83 CS/SCNN wrote:

> **
>
> Hello All,
> I have created a dialog box that contains numerous character fields. I need
> to push all of the data from all of these fields into a diary field on the
> parent form. I have been able to push the data but I have ran into a
> problem. The problem that I have is that all of the character fields are
> pushed together with no spaces. Any ideas as to how I can add a space
> between each comment?
>
> > RICHARD A. BEDWELL, SSgt, USAF
> > ACC NOSC Integration Branch
> > Langley AFB, VA
> > 83 CS/SCNN
> > DSN: 574-6563
> > Coml: (757) 764-6563
> > email: richard.bedwell@langley.af.mil
> >
> >
>
>
>

When you build you Push Field action, try something like this

'Diary Field' = $Field1$ + " " + $Field24 + " " + $Field3$ + " " ........

Yves Morvan

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Bedwell Richard A SSgt
83 CS/SCNN
Sent: Tuesday, December 05, 2000 9:22 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Hello All,
I have created a dialog box that contains numerous character fields. I need
to push all of the data from all of these fields into a diary field on the
parent form. I have been able to push the data but I have ran into a
problem. The problem that I have is that all of the character fields are
pushed together with no spaces. Any ideas as to how I can add a space
between each comment?


> RICHARD A. BEDWELL, SSgt, USAF
> ACC NOSC Integration Branch
> Langley AFB, VA
> 83 CS/SCNN
> DSN: 574-6563
> Coml: (757) 764-6563
> email: richard.bedwell@langley.af.mil
>
>

David,

If I'm not mistaken, that's how the diary is stored. I believe there are
API calls that will decode it for you, so you could write your own code to
strip out the text.

--On Tuesday, December 05, 2000 10:28 AM +0100 "Wark, David Mr."
wrote:

> **
>
> Does anyone know a way to select a diary filed from the appropriate Remedy
> table column without the timestamp and username embedded in it? Or is
> there another table or view that I could use that only has the diary field
> without the user and timestamp?
>
> Thanks,
>
> Oracle version: Oracle 8.1.6.0.0
> Remedy version: 4.5
> OS: Solaris 2.7
>
>
>
>



------------------------------------------------------------------------
Adam Wilkinson awilkins@umich.edu 734/936-8368
------------------------------------------------------------------------
University of Michigan
Information Technology Central Services
UMCE User Services

Remedy Helpdesk Project Leader, Consulting Tools Project Leader,
Expert Consultant and Virus Buster
------------------------------------------------------------------------

David,
Don't know if it would satisfy your requirements or not, but a regular
character field with size 0 gives you the same capacity as a diary field and
does not include the auto stamping of user-id and date.

Larry Salisbury
Acxiom Corporation
Woodland Hills, CA
voice: 818-715-5679
fax: 818-715-5218

-----Original Message-----
From: Wark, David Mr. [SMTP:WarkD@HQ.5SIGCMD.ARMY.MIL]
Sent: Tuesday, December 05, 2000 01:28
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:

**

Does anyone know a way to select a diary filed from the appropriate Remedy
table column without the timestamp and username embedded in it? Or is there
another table or view that I could use that only has the diary field
without the user and timestamp?

Thanks,

Oracle version: Oracle 8.1.6.0.0
Remedy version: 4.5
OS: Solaris 2.7

Has anyone modified the Excel.xla template used in Remedy CRM?

Has anyone added the ability to use different Excel.xla files for different reports?

Remedy CRM Customer Support?

Thanks,
-Geoff

Hi,

Can anyone help?

I want to add a table update, similar to the following action right-click on table, Refresh All in Table. I need it to be added to an Active Link action. I have tried to write these keystrokes to a macro but it gives an empty macro.

Also does any body have a list of values and meanings for "Current-window-action" variable in a macro?

Regards

John.


John Bibby
Consultant
Application Support
Ericsson IT Services
Ericsson Ltd
Greenhoe Road
SCUNTHORPE
DN17 2BZ
Tel: +44 (0)1724 401085
Fax: +44 (0)1724 401398
email: john.bibby@etl.ericsson.se
The information in this e-mail is confidential and may be legally privileged. It is intended solely for the named recipient(s). Access to this e-mail by anyone else is unauthorised. The views are those of the sender and not necessarily the views of Ericsson.
In sending this e-mail the sender is not acting as an agent, representative or in any other capacity for or on behalf of Ericsson. The contents of this e-mail are not legally binding on Ericsson and do not create legal relations of any kind.
Ericsson accepts no responsibility or liability whatsoever or howsoever arising in connection with this e-mail.
Any attachment(s) to this message has been checked for viruses, but please rely on your own virus checker and procedures.
If you contact us by e-mail, we will store your name and address to facilitate communications.
If you are not the intended recipient, please inform us by telephoning 01444 234567, or by fax to 01444 234234 and then delete the e-mail and any copies of it.

John,
It's very simple, add a Change Field action in an active link selecting
your table and check refresh table.

Christian Smerz
Enron Corporation

> -----Original Message-----
> From: "Action Request System discussion list(ARSList)"
> @ENRON
> [mailto:IMCEANOTES-+22Action+20Request+20System+20discussion+20list+28
> ARSList+29+22+20+3CARSLIST+40LISTSERV+2EVISTAIT+2ECOM+3E+40ENRON@ENRON
> .com] On Behalf Of "John Bibby (ETL)"
> Sent: Wednesday, December 20, 2000 7:46 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject:
>
> **
>
> Hi,
>
> Can anyone help?
>
> I want to add a table update, similar to the following action
> right-click on table, Refresh All in Table. I need it to be added to
> an Active Link action. I have tried to write these keystrokes to a
> macro but it gives an empty macro.
>
> Also does any body have a list of values and meanings for
> "Current-window-action" variable in a macro?
>
> Regards
>
> John.
>
>
> John Bibby
> Consultant
> Application Support
> Ericsson IT Services
> Ericsson Ltd
> Greenhoe Road
> SCUNTHORPE
> DN17 2BZ
> Tel: +44 (0)1724 401085
> Fax: +44 (0)1724 401398
> email: john.bibby@etl.ericsson.se
> The information in this e-mail is confidential and may be legally
> privileged. It is intended solely for the named recipient(s). Access
> to this e-mail by anyone else is unauthorised. The views are those of
> the sender and not necessarily the views of Ericsson.
> In sending this e-mail the sender is not acting as an agent,
> representative or in any other capacity for or on behalf of Ericsson.
> The contents of this e-mail are not legally binding on Ericsson and do
> not create legal relations of any kind.
> Ericsson accepts no responsibility or liability whatsoever or
> howsoever arising in connection with this e-mail.
> Any attachment(s) to this message has been checked for viruses, but
> please rely on your own virus checker and procedures.
> If you contact us by e-mail, we will store your name and address to
> facilitate communications.
> If you are not the intended recipient, please inform us by telephoning
> 01444 234567, or by fax to 01444 234234 and then delete the e-mail and
> any copies of it.
>
>
>
>

Is there a way that if your id is say created in uppercase or
lowercase in the User Form that when
a person logs in you can have Remedy ignore the case they are using
and allow them to logon.
Does not limit them to the case the id was created.

Create an escalation to convert all logins, and passwords in the User form
to UPPER, or LOWER. Use the Upper / Lower functions available in set fields.
However the best way to do this is at the data base level. MS SQL has a case
insensitive switch you can set at install. If you are using Oracle I would
check with your DBA.

Aaron~

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Price, Daphne
Sent: 12/20/2000 1:24 PM
To: ARSLIST@LISTSERV.VISTAIT.COMin
Subject:

**

Is there a way that if your id is say created in uppercase or
lowercase in the User Form that when
a person logs in you can have Remedy ignore the case they are using
and allow them to logon.
Does not limit them to the case the id was created.

unsuscribe

_____

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Thanks!

-----Original Message-----
From: Aaron Marchbanks [mailto:amarch@airmail.net]
Sent: Wednesday, December 20, 2000 3:10 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Create an escalation to convert all logins, and passwords in the User form
to UPPER, or LOWER. Use the Upper / Lower functions available in set fields.
However the best way to do this is at the data base level. MS SQL has a case
insensitive switch you can set at install. If you are using Oracle I would
check with your DBA.

Aaron~

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Price, Daphne
Sent: 12/20/2000 1:24 PM
To: ARSLIST@LISTSERV.VISTAIT.COMin
Subject:

**

Is there a way that if your id is say created in uppercase or
lowercase in the User Form that when
a person logs in you can have Remedy ignore the case they are using
and allow them to logon.
Does not limit them to the case the id was created.

Hi,
This is Ashraf Kamal whishing you a merry xmas and a happy aed to all of you


=====
Ashraf Kamal Khalid
Remedy Tecnical Consultant
CyberMAK Information Systems

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

Hello all,

I need HELP!

I want to have a different VIEW presented on the WEB,
how is that accomplished? I read somewhere that you
can have different views but can't figure out how to
tell ARWeb what view to use?

As usual TIA :)

=====

Regards,

Linda Gage (415) 656-4470(415) 806-1461

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Hi, Linda.

You need to name the views so they begin with 'web' followed by what the
view is intended for.

Examples:
webQuery
webSubmit
webModify
webDisplay

Once you've saved views with these names, Remedy and ARWeb will take care of
the rest.

TIP: If you have views with ANY of these names, Remedy will use them
INSTEAD of the default view. So, you can have a webQuery view and ARWeb
will use that view no matter what window type (submit, modify, display,
query) is used. So, if you want all window types to use the same view, save
yourself some work and simply have one web view - or just the views you
need.

Hope this helps.

Eric
Eric Evans, Remedy Skilled Professional
Senior Remedy Developer/Administrator
Senior Systems Analyst
Computer Sciences Corporation
Stuttgart, Germany
011-49-711-680-6190


-----Original Message-----
From: Linda Gage [mailto:lindagage@YAHOO.COM]
Sent: Thursday, December 28, 2000 4:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Hello all,

I need HELP!

I want to have a different VIEW presented on the WEB,
how is that accomplished? I read somewhere that you
can have different views but can't figure out how to
tell ARWeb what view to use?

As usual TIA :)

=====

Regards,

Linda Gage (415) 656-4470(415) 806-1461

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Linda,

This feature is in ARWeb 4.0 only, not 3.0. It can be accessed by the URL
parameter &V=


Best Regards,

Ann Zbylut
Process Automation Engineer
GE Capital ITS
Enterprise Management
Work (916) 569-5263
Pager (888) 437-5810


-----Original Message-----
From: Linda Gage [mailto:lindagage@YAHOO.COM]
Sent: Thursday, December 28, 2000 7:21 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Hello all,

I need HELP!

I want to have a different VIEW presented on the WEB,
how is that accomplished? I read somewhere that you
can have different views but can't figure out how to
tell ARWeb what view to use?

As usual TIA :)

=====

Regards,

Linda Gage (415) 656-4470(415) 806-1461

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Thanks!
--- Ann Zbylut wrote:
> **
>
> Linda,
>
> This feature is in ARWeb 4.0 only, not 3.0. It can
> be accessed by the URL
> parameter &V=
>
>
> Best Regards,
>
> Ann Zbylut
> Process Automation Engineer
> GE Capital ITS
> Enterprise Management
> Work (916) 569-5263
> Pager (888) 437-5810
>
>
> -----Original Message-----
> From: Linda Gage [mailto:lindagage@YAHOO.COM]
> Sent: Thursday, December 28, 2000 7:21 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject:
>
>
> **
>
> Hello all,
>
> I need HELP!
>
> I want to have a different VIEW presented on the
> WEB,
> how is that accomplished? I read somewhere that you
> can have different views but can't figure out how to
> tell ARWeb what view to use?
>
> As usual TIA :)
>
> =====
>
> Regards,
>
> Linda Gage (415) 656-4470(415) 806-1461
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
>
>

> To UNSUBSCRIBE, email the message "unsubscribe
> arslist" to:
>
>
>

> To UNSUBSCRIBE, email the message "unsubscribe
> arslist" to:


=====

Regards,

Linda Gage (415) 656-4470(415) 806-1461

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/