UNCLASSIFIED

We are using ARS 6.3 patch 21
Windows Server 2003
SQL 2000
Help Desk 5.5


I have an Active Link that runs from a button.
When employed, this is the workflow:

If Action 1
Open Window
Window Type: Report
Target Location: New
Qualification: ( 'Status Display' !=  "Resolved" ) AND ( 'Status Display'
!=  "Closed" )

Report Information:
Report Type: Crystal
Name: Morning Report
Target: File
Operation: Create
Location Reporting Form


Works like a charm.

Can I automate the save to file without a person selecting the "Save to"
properties?


Sandra Hennigan

OSD Enterprise Remedy Administrator
Office # 703-602-2525 x248

Apparently, there is nothing that cannot happen today.  Mark Twain


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Thursday, April 24, 2008 9:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: Can you export to a csv file from Mid Tier?


Brian,

The Open Window action (for running a Report) requires several inputs:

'Window Type' = "Report"
'Target Location' = "New" or "Current" (your choice)
'Server Name'
'Form Name'
'Form View'  ( not sure how this one matters)

Then you have 4 other tabs of things to fill out for this action:
Qualification, Sort Info, Report Information.

I was speaking of a filed on the Report Information tab. 'Target :' and
NOT the 'Target Location: ' field in the "header" of the action. But I can
see how my description was not 100% complete. ( Your current value is
likely "File".)

--
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 Thu, Apr 24, 2008 at 9:25 AM, Sokol, Brian <[EMAIL PROTECTED]>
wrote:
> Hi Carey,
>
>  Thanks. By Target are you referring to the Target Location setting in
> the Open Window settings? I changed that value from New to to-file:
> POSInventory.csv but still get the same result. It defaults to
> Report.rpt. I am hoping I am doing something wrong here that can
> easily  be corrected.
>
>  Brian
>
>
>  -----Original Message-----
>  From: Action Request System discussion list(ARSList)
>
>
> [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
>  Sent: Wednesday, April 23, 2008 11:24 PM
>  To: arslist@ARSLIST.ORG
>  Subject: Re: Can you export to a csv file from Mid Tier?
>
>  Brian,
>
>  You can do it... it is just not obvious....
>
>  You need to supply the "Target" string (in the WindowOpen action)
> like  this...
>
>  to-file:<space>
>
>  No "<space>" is not in the string, but you need a white space
> character  there for it to work right.
>
>  If you also want to specify the actual file name then the target
> would
>  be:
>
>  to-file: some.csv
>
>  If the file name presented is a *.csv then the report will output to
> csv.  If it is *.xml.. then xml
>  If it is anything else... then I think you get report (rpt) format.
>
>
>  ( I forget where or when I learned this... but I remember it being a
> very obscure (and accurate) source.)
>
>  HTH.
>  --
>  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 Wed, Apr 23, 2008 at 3:29 PM, Sokol, Brian <[EMAIL PROTECTED]>
>  wrote:
>  > **
>  >
>  > Jason,
>  >
>  > One last question. I am trying to setup a simple means for a
> manager  > to run an export of a query in Remedy. I can now run a
> query, select  > Report, select the report, change the output to
> export etc. Too  > complicated for this person. I created an AL to run
> a report. Problem  > is if you select Destination as File there is no
> where to have Remedy  > export the data as a CSV. It always selects
> RPT and there is no way to
>
>  > over ride it from the Mid Tier that I can see. In the user tool you
> > can change the file type to CSV before saving and it works. Do you
> > know any way to force this on the Mid Tier?  >
>  > Brian
>  >
>  >  ________________________________
>  >
>  > From: Action Request System discussion list(ARSList)
>  > [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller
>  > Sent: Wednesday, April 23, 2008 2:25 PM
>  >
>  >
>  > To: arslist@ARSLIST.ORG
>  > Subject: Re: Can you export to a csv file from Mid Tier?
>  >
>  >
>  >
>  > ** That is interesting that support doesn't know about this.  For one
>  > I would think it is a pretty common issue.  Anybody who has upgraded
>  > their pre
>  > 7 server would experience it (unless a Unix installer uses a
different
>
>  > mapping that updates or overwrites).  Maybe not many people have
> tried
>
>  > exporting to Excel?  Second we resolved this ourselves at my last
> job  > but I am pretty sure that we told support exactly what we did
> to fix  > it when closing out our ticket.  I guess the solution didn't
> make it  > any further then the incident record (ISS03165279 for
> anybody on the  > inside who may want to look it up).  >
>  > We just fixed it on our server here.  Here is what we did:
>  >
>  > Updated configuration record Request ID: 000000000000001 for AR
System
>
>  > report type.
>  >
>  > Changed Run Command value
>  > From:
>  >
> /servlet/NativeReportServlet?O=$RPTOP$&U=$USR$&P=$PWD$&Q=$RPTQUERY$&QR
>  >
=$RPTQOVR$&S=$RPTSVR$&F=$RPTFORM$&VW=$RPTVIEW$&VWEXT=$RPTVIEWEXT$&APP=
>  >
$RPTAPP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAG
>  > E$&CTRY=$COUNTRY$&enc=$RPTENC$
>  >
>  > To:
>  >
/servlet/NativeReportServlet?O=$RPTOP$&U=$USR$&P=$PWD$&Q=$RPTQUERY$&QR
>  >
=$RPTQOVR$&S=$RPTSVR$&F=$RPTFORM$&VW=$RPTVIEW$&VWEXT=$RPTVIEWEXT$&APP=
>  >
$RPTAPP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAG
>  > E$&CTRY=$COUNTRY$&enc=$RPTENC$&DT=$RPTDEST$&CS=$RPTCHARSET$
>  >
>  > Let me know if this works for you.
>  >
>  > Jason
>  >
>  >
>  > On Wed, Apr 23, 2008 at 6:36 AM, Sokol, Brian <[EMAIL PROTECTED]>
>  wrote:
>  >
>  > > **
>  > >
>  > > Thanks Jason,
>  > >
>  > > Yes it is an upgraded server. I opened a tkt with BMC support but
>  > > they
>  > were clueless. They kept insisting it was a problem with my report
>  > (even though I get the same error on all reports). It is getting more
>  > and more difficult to prove there is a bug. Please let me know if you
>  > come up with a solution.
>  > >
>  > > Brian
>
>  <snip>
>
>  > > > From: Action Request System discussion list(ARSList)
>  > [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian
>  > > > Sent: Saturday, 19 April 2008 3:34 a.m.
>  > > > To: arslist@ARSLIST.ORG
>  > > > Subject: Can you export to a csv file from Mid Tier?
>  > > >
>  > > >
>  > > >
>  > > > **
>  > > >
>  > > > I thought this was now possible? I am on ver 7.1. I have a
> report  > > > for  > the form I am using. In the Report window I
> selected Destination File  > and Report Format CSV. When I click Run a
> get a window to name the  > file. That all works up to that point.
> When I click Ok after naming  > the file I get an
>  > error:
>  > > >
>  > > > Report Error
>  > > > Failed To Perform Action
>  > > >
>  > > > Am I doing something wrong here?
>  > > >
>  > > > Brian Sokol
>  > > > Manager, Desktop Services
>  > > > Scholastic Inc.
>  > > > 557 Broadway
>  > > > NY, NY 10012
>  > > > (212) 343-6494
>  > > > http://www.Scholastic.com

__________________________________________________________________________
_____
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"

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to