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