Hi Gordon,
is there a way to do this on the web not having the User tool.
I mean maybe there is a way using OLE and php or perl on a webpage? Is it?
Serouche
Bezhenar, Dmitry wrote:
Hello Frank,
Thank you for your useful answer.
I have a question reg. item 7 in your list.
How is it possible to tie a report, which exports data to application, to an
Open Window action?
There are only 3 options - screen, file and printer.
Kind Regards / C ?????????
Dmitry Bezhenar
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of FRANK, GORDON CTR DISA JSSC
Sent: Monday, November 19, 2007 4:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: Export Form Data to Excel on Button Action (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
This can be done in the following way:
1. Create a DDE.ini file in your Home directory
2. Copy the following into the DDE.ini text file
[excelrecord]
Path=c:\excel\excel.exe
Application=excel
Topic=system
Format=TAB
XFRDATA=Clipboard
Command1=[NEW(1)][PASTE()][SAVE.AS(,0)]
3. Enable "Report to Application" option is selected in the Options
dialog box
4. Build and save a report in the Remedy User tool
5. Choose Report > Export to > Application from the Report menu bar
6. Your query and created report will be sent to Excel
7. Tie this report to an Open Window action in an Active Link with a
Button (Permissions: Public)
Below is a web link with explains this in more detail:
http://service-it-remedy.web.cern.ch/service-it-remedy/clients/aruser/Re
ports15.html
A description is also available in the Remedy User Tool help.
You can also execute Visual Basic code. To do this you will need to
substitute VB for the
"Command1=[NEW(1)][PASTE()][SAVE.AS(,0)]" see VB Help for more detail.
You will have to work with relative addressing in Visual Basic (a
recorded macro in VB will give you static addressing).
Gordon M. Frank
DISA\Version FNS
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian
Sent: Monday, November 19, 2007 7:30 AM
To: arslist@ARSLIST.ORG
Subject: Export Form Data to Excel on Button Action
**
Hi Listers,
I require to perform a data export of a regular form to an excel sheet
on click of a button. And also that it shouldnt require the user to
interact other than clicking the button.
I tried by using the Open window action to run a report but here again
it requires the user to select a format to which the data has to be
saved as. i require that the workflow automatically opens an excel sheet
and displays the exported data on to the excel sheet.
i would appreciate if some one could shed some light on this or if
anyone has done the same to share the idea.
thanks and regards
Anesh
__20060125_______________________This posting was submitted with HTML in
it___
Classification: UNCLASSIFIED
Caveats: NONE
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
